In Merchandise Plan, we currently have a custom metric created and pulling in actuals which is "EOP Cost Landed." Would like to request that this metric be a formula that is calculated for future weeks. The formula would be: EOP Cost Landed = BOP Cost Landed + Receipt Cost – Gross Sales Cost Landed + Returns Cost + Transfer Receipt Cost + Adjustment Cost. Also, BOP Cost Landed would equal the Previous Month's EOP Cost Landed. We do not want these two new formulas to impact any other current metrics or formulas.
• BOP Cost Landed = Previous Month’s EOP Cost Landed
• EOP Cost Landed = BOP Cost Landed + Receipt Cost – Gross Sales Cost Landed + Returns Cost + Transfer Receipt Cost + Adjustment Cost
In our current business we are now tracking inventory levels at product cost and landed cost. Product Cost being the priority for planning purposes which is our current BOP Cost and EOP Cost. We would like to have BOP Cost Landed and EOP Cost Landed as secondary metrics to reference for reporting and planning purposes.