Calculating Total Product Costs

One of the primary goals of the Fishcakes International model is to figure out what it costs, on a daily basis, to produce each type of fishcake. Between the Production, FishRequired and Inventory cubes, you have all the information necessary to calculate this daily cost in the Production cube.

In the rule for the Inventory cube, you create statements that calculate the average price per Kg of each fish type, as well as the daily purchase cost for each fish type.
In the rule for the FishRequired cube, you create a rule statement that calculates the cost of each fish required for a given fishcake on a daily basis, based on values in the Inventory cube.
Finally, you create rule statements for the Production cube that calculate the daily production cost for each fishcake type as well as the cost per Kg of each fishcake type.