Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
A
Appendix: Measure Calculations
This appendix provides additional information on 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 Sales R - COGS | |
| COGS | (Net Sales R + Markdown POS R) * (1 - CMU%) + Shrink C | Elapsed periods add COGS adj R. |
| COGS exc VAT C | COGS C / (1 + VAT C %) | |
| CMU% | (BOP R + Receipts R - Shrink R - MOS R- Markdown Perm R) - (BOP C + Receipts C - Shrink C - MOS C)) / (BOP R + Receipts R - Shrink R - MOS R- Markdown Perm R) | |
| Net GM R | GM R + Vendor Funds R + Royalties R - Restocking Cost R - MOS C - Markdown Due to W/F | |
| Net GM % | Net GM R / Net Sales R | |
| GM R exc VAT | Net Sales R exc VAT - COGS exc VAT C | |
| GM R% exc VAT | GM R exc VAT / Net Sales R exc VAT | |
| Net GM R exc VAT | GM R exc VAT + Vendor Funds R + Royalties - Restocking Cost - MOS R/(1+VAT%) - Markdown Due to W/F/(1+VAT%) | |
| Net GM R % exc VAT | Net GM R exc VAT / Net Sales R exc VAT | |
| Sales | ||
| Sales R | Sales Reg+Promo R + Sales Clr R | |
| Sales R | Sales U * Sales AUR | |
| Sales U | Sales R / Sales AUR | |
| Sales AUR | Sales R / Sales U | |
| Net Sales R | Net Sales Reg+Promo R + Net Sales Clr R | An edit to Net Sales will proportionally spread the change to Net Reg+Promo and Net Sls Clr. |
| Net Sales Reg+Promo R | Sales Reg + Promo R - Net Return Reg + Promo R | |
| Returns R | Returns Reg + Promo R + Returns Clr R | |
| Returns R % | Returns R / Sales R | |
| Net Return R | Return R + Return Back to Online R | |
| Markdowns POS | ||
| Markdown POS R | Reg+Promo Markdown POS R + Clr Markdown POS R | This is specific for planning the Point of Sales Markdowns. |
July 30, 2026 Appendix A-1 of A-3
Appendix A
| Measure Label | Measure Calculation | Notes |
|---|---|---|
| Markdown POS R | Markdown POS % * Net Sales R | |
| Markdown POS % | Markdown POS R / Net Sales R | |
| Markdown POS Due to W/F | W/F Markdown POS R * % Owned by Retailer | |
| Markdown Permanent | ||
| Markdown Perm R | Reg+Promo Markdown Perm R + Clr Markdown Perm R | Markdown Perm metric is mainly for planning the permanent markdowns and existing markdown (Markdown POS R) are specifically for planning Promotional Markdowns / Point of Sales Markdowns. |
| Markdown Perm R % | Markdown Perm R / BOP R | |
| Markdown Perm Reg + Promo R% | Markdown Perm Reg + Promo R / (BOP Reg + Promo R- Move to Clear R) | |
| Markdown Perm Clr R % | Markdown Perm Clr R / BOP Clr R + Move to Clear R | |
| Inventory | ||
| EOP R | EOP Reg+Promo R + EOP Clr R | |
| EOP Reg+Promo R | BOP Reg+Promo R + Receipts R - Net Sales Reg+Promo R - Markdown POS Reg+Promo R - Shrink R - Misc Adj R - Move to Clr R + Inv Adj R - Pick Up in Store Reg + Promo R - Ship to Customer Reg+Promo R- Markdown Perm Reg + Promo R | For Merch Target/Merch Plan. See EOP calc for Location Planning. |
| EOP Clr R | Clr BOP R - Net Sales Clr R - Clr Markdown POS R - MOS R + Move to Clr R- Markdown Perm Clr R | For Merch Target/Merch Plan. See EOP calc for Location Planning. |
| EOP R (For Location Plan) | Receipt R + BOP R - Net Sales R - Markdown POS R - Shrink R + Transfer In/Out R | |
| Receipt R | EOP Reg+Promo R - BOP Reg+Promo R + Net Sales Reg+Promo R + Reg Promo Markdown POS R + Shrink R + Misc Adj R + Move to Clr R - Inv Adj R + Markdown Perm Reg + Promo R | |
| Forward Cover R | Forward cover uses an internal function which counts the number of future periods which EOP can cover the future Net Sales plus Markdown. As the end of the calendar horizon in the segment is reached, the future net sales and markdown do not exist to calculate cover. In this case, the function_copies_the Net Sales plus Markdown 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 forward cover measure with an additional benefit that it shows the aggregated level in number of weeks using the 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. | |
| On Order | ||
| Net On Order R | On Order R + On Order Adj R |
July 30, 2026 Appendix A-2 of A-3
Appendix A
| Measure Label | Measure Calculation | Notes |
|---|---|---|
| OTB R | For Un-elapsed: CP EOP R - WP EOP R + WP Receipts R - Net On Order R Elapsed: 0 | For Targets, CP is labeled as Tgt. Therefore, in the given calculation, CP EOP equates to Tgt EOP. |
| On Order Adj C | On Order Adj R * (1 - On Order Adj MU %) | |
| Net On Order MU % | (Net On Order R - Net On Order C) / Net On Order R | |
| Key Performance Indicator | s | |
| Avg Sales R per Location | Net Sales R / # of Location count | Count of Locations open/ active. |
| Cum Turn R | sum(Sales R) / Cum Avg Inv R | |
| Sell Thru R % | Sales R / (BOP R + Receipts R) | |
| Stock to Sales Ratio R | BOP R / Sales R | |
| Week Over Week Build Measure Sales (WoW Build) | = Current week Sales R / Previous week Sales R | |
| Wp var to LY % | (Wp - Ly) / abs(Ly) | |
| Fulfillment | ||
| Pickup In Store R | Direct Channel: (Sales R * BOPIS %) * -1 Brick & Mortar: Sales R (ofDirect Channel) * BOPIS % | Buy Online Pickup in Store % (BOPIS %) |
| Ship to Customer R | Direct Channel: Sales R (ofB&M Channel) * BSSC % Brick & Mortar: (Sales R * BSSC %) * -1 | Buy in Store Ship to Customer % (BSSC %) |
| Buy Online Return In Store R (BORIS R) | Round(Return R (ofDirect Channel) / BORO %) - Return R (of Direct Channel) | Buy Online Return Online % (BORO %) |
| Return Back to Online R | Direct Channel: BORIS R * % BORIS back to Warehouse Brick & Mortar: (BORIS Return R * % BORIS back to Warehouse) * -1 | |
| Restocking Cost R | Direct Channel: (Return U * Warehouse Restocking $/U) + (Return Back to Online U * Store to Warehouse Restocking $/U) Brick & Mortar: (Return U + Return Back to Online U) * Store to Warehouse Restocking $/U |
July 30, 2026 Appendix A-3 of A-3