| Sales and Inventory Planning- Assignment #1 |
| 45pts |
| # of weeks | 4 | 5 | 4 | 4 | 5 | 4 |
| LY | FEB | MAR | APR | MAY | JUNE | JULY | TOTAL | AVG | TURN |
| BOM | $ 801.0 | $ 1,299.4 | $ 1,251.7 | $ 1,064.0 | $ 1,474.1 | $ 1,601.6 | $ 7,491.8 | $ 1,248.8 | 1.64 |
| SALES $ | $ 297.5 | $ 432.8 | $ 300.0 | $ 300.2 | $ 392.6 | $ 319.7 | $ 2,042.8 |
| MARKDOWNS | $ 41.1 | $ 39.3 | $ 22.5 | $ 22.9 | $ 32.8 | $ 75.6 | $ 234.2 |
| MD % | 13.8% | 9.1% | 7.5% | 7.6% | 8.4% | 23.6% | $ 0.1 |
| RECEIPTS | $ 837.0 | $ 424.4 | $ 134.8 | $ 733.2 | $ 552.9 | $ 43.7 | $ 2,726.0 |
| EOM | $ 1,299.4 | $ 1,251.7 | $ 1,064.0 | $ 1,474.1 | $ 1,601.6 | $ 1,250.0 |
| PLAN | FEB | MAR | APR | MAY | JUNE | JULY | TOTAL | AVG | TURN |
| BOM |
| SALES $ | $ 355.7 |
| MARKDOWNS |
| MD % |
| RECEIPTS |
| EOM |
| CREATE A PLAN BASED OFF LY HISTORY |
| 1. Insert three rows to LY chart and add Monthly Sales Builds, Monthly ST %, WOH. (Feb will not have a build) 15 points |
| 2. TY Feb Sales are already planned. Plan remaining TY Sales's months by using LY Monthly Sales Builds - 5 points |
| 3. Easter LY was in March and TY will switch to April. Copy LY Markdown %s to find your Plan MD $, but make sure to switch March and April to correlate with Easter. - 5 points |
| 4. Plan TY BOM inventory by using LY Monthly ST%. Then Plan Jul EOM by using LY Jul WOH - 10 points |
| 5. Fill in Receipts, Avg Stock and Turn based off current planned numbers. 10pts |
| (include markdowns in receipt calculation) |
GHOST HAM
Mrch2860SalesandInventoryAssignment2.xlsx
