Our calculation logic will use the following simple data structures:
Product Master
Contains Product Group information for each Product. We will need only the Product Group attribute for our calculation.
|
Product ID |
Product Group |
|---|---|
|
sku |
attribute2 |
Product_Costs PX
Contains products' Average Costs valid at different Valid From dates. We will use this information to calculate product cost on a specific target date and also an average cost for a whole product group.
|
Product ID |
Average Cost |
Last Purchasing Price |
Valid From |
|---|---|---|---|
|
sku |
attribute1 |
attribute2 |
attribute4 |
MarginAdj PP
Contains a percentual Margin adjustment for each Product Group. We will add this percentage to the final price based on the product group.
|
Product Group |
Margin (%) |
|---|---|
|
name |
attribute1 |
CountryFactor PP
Contains a Factor per Country code and Product Group. We will multiply the final price with this factor. Country code will be a user input.
|
Country Code |
Product Group |
Factor |
|---|---|---|
|
key1 |
key2 |
attribute1 |