| | | Actual (LY) | Plan (TY) | Change(%) over LY |
| Total Retail ($) | | 135,000.00 | 148,500.00 | 10.00% |
| Total Reduction (of Sales) % | | 10.00% | 8.00% |
| Initial Markup % | | | 55.00% |
| Average Retail Stock |
| Average Monthly Sales |
| | | Aug | Sep | Oct | Nov | Dec | Jan | TOTAL |
| Sales | LY Actual ($) | $ 6,750.00 | $ 20,250.00 | $ 40,500.00 | $ 40,500.00 | $ 20,250.00 | $ 6,750.00 | $ 135,000.00 |
| | LY Actual (%) | 5.00% | 15.00% | 30.00% | 30.00% | 15.00% | 5.00% | 100.00% |
| | TY Plan ($) | 7,425.00 | 22,275.00 | 44,550.00 | 44,550.00 | 22,275.00 | 7,425.00 | 148,500.00 |
| | TY Plan (%) | 5.00% | 15.00% | 30.00% | 30.00% | 15.00% | 5.00% | 100.00% |
| Reduction | LY Actual (% of Seasonal Reductions) | 0.00% | 10.00% | 15.00% | 15.00% | 25.00% | 35.00% | 100.00% |
| | TY Plan ($) |
| | TY Plan (% of Seasonal Reductions) | 0.00% | 10.00% | 15.00% | 15.00% | 25.00% | 35.00% | 100.00% |
| | TY Plan - (% of Sales) | | | | | | | 8.00% |
| SSR | LY & TY | 3 | 2.5 | 1.8 | 1.6 | 2 | 2.7 |
| BOM | TY Plan ($) |
| EOM | TY Plan ($) |
| Purchases @Retail | TY Plan ($) |
| Purchases @Cost | TY Plan ($) |
| MMU | TY Plan (%) |
| | TY Plan ($) |
Pastel12
Assingment11homeworkdata.xlsx
