Why do we want to calculate the cost per product?
We want to know how much do we lost by not producing enough. This will help your report to be more clear and concise with numbers and data. This will not be helpful until you have a period that the inventory equal zero.
Choose two consecutive periods, in which one of them has zero inventory (Px) and the other one has left-over inventory (Py). ( the market share of the period with left-over inventory has to be bigger than that of the period with zero inventory). If the market share of zero inventory period is bigger , that means the segment is shrinking, and you produce less next period.
Subtract market share of the product’s target segment of Py and Px. (Py-Px).
The market share of the product for each segment will be found in the consumer panel.
Multiply the difference by segment size.
The segment size will be found in market forecast.
Multiply the number you got in step 3 with the price of the product in Px.
Below is the example:
Segment size: 312,000
So we lost about $714,480 for not produce enough for period 2.
I am writing this blog with one of my group mates, James Argenta. Thank you very much for helping me, James