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 Week Cover |
This is same as forward cover measure with an additional benefit that shows the aggregated level in number of weeks using PET agg method. This helps you to understand the forward cover inventory at week level only, even when you look 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) |
|