A Appendix: Cost Calculations

This appendix provides additional information on find a few of the core retail calculations to help aid your understanding. It is important to understand that a particular measure can be calculated in many ways because it is impacted by many different input measures. When a value is changed that impacts other editable values, the impacted measures that then need to be recalculated are protected so that you cannot also update those values. This prevents a deadlock or circular calculation in which you do not know where to start recalculating.

Measure Label	Measure Calculation	Notes
Margin
GM R	Net Sls R - Net Sls C
GM %	GM R / Net Sls R
Net GM R	GM R + Vendor Funds R + Royalties R - Shrink C - MOS C
Net GM %	Net GM R / Net Sls R
Sales
Net Sls C	Net Sls U * Net Sls AUC
Net Sls C	Net Sls Reg+Promo C + Net Sls Clr C	An edit to Net Sales will proportionally spread the change to Net Reg+Promo and Net Sls Clr.
Inventory
EOP C	Reg+Promo EOP C + Clr EOP C
EOP Reg+Promo C	Reg+Promo BOP C + Rec C - Net Sls Reg+Promo C - Shrink C - Misc Adj C - Move to Clr + Inv Adj C	For Merch Target/Merch Plan. See EOP calc for Location Planning.
Clr EOP C	Clr BOP C - Net Sls Clr C - MOS C + Move to Clr C	For Merch Target/Merch Plan. See EOP calc for Location Planning.
EOP C (for Loc Plan)	Receipt C + BOP C - Net Sales C - Shrink C + Transfer In/Out C
Receipts C	Reg+Promo EOP C - Reg+Promo BOP C + Net Sls Reg+Promo C + Shrink C + Misc Adj C + Move to Clr C - Inv Adj C
Forward Cover C	Forward cover uses an internal function which counts the number of future periods which EOP can cover the future Net Sales. As the end of the calendar horizon in the segment is reached, the future net sales do not exist to calculate cover. In this case, the function copies the Net Sales for the segment's calendar horizon (such as the half) into the future to enable calculating a forward cover value.
Forward Cover Week	This is same as the Forward Cover measure with an additional benefit that it shows the aggregated level in number of weeks using the PET agg method. This helps users to understand the forward cover inventory at week level only even when user looks at the calendar at the aggregated / parent level.
Stock to Sales Ratio C	BOP C / Net Sls C
Sell Thru C %	Net Sales C / (BOP C + Receipts C)