Dollar Plan Assignment
Pastel12
Assignment12Excel.xlsxBasic Stock Assignment Data
| Season: | Department: | Buyer's Name: | ||||||
| Actual LY | Plan TY | Actual LY | Plan TY | |||||
| Total Retail Reductions $ | Net Sales (Seasonal) | $24,370,000 | ||||||
| Total Retail Reductions % | 21.00% | Sales Change (%) over LY | 8.00% | |||||
| Initial Mark-up % | Average Retail Stock | |||||||
| GM% | 54.00% | Stock Turnover | 2.3 | |||||
| Profit% | 6.00% | Average Monthly Sales | ||||||
| GMROI | Basic Stock | |||||||
| Season: | Aug/Feb | Sep/March | Oct/April | Nov/May | Dec/June | Jan/July | Season Totals | |
| SALES | LY Sales ($) | |||||||
| % TT (LY) | ||||||||
| TY Planned Sales ($) | ||||||||
| % TT (Planned TY) | 13.00% | 12.50% | 13.50% | 19.00% | 25.50% | 16.50% | 100.00% | |
| REDUCTIONS | LY Red ($) | |||||||
| % TT (LY) | ||||||||
| TY Planned Red ($) | ||||||||
| % TT (Planned TY) | 10.00% | 9.00% | 11.00% | 16.00% | 30.00% | 24.00% | 100.00% | |
| Red% (of $NS TY) | ||||||||
| BOM STOCK | Last Year ($) | |||||||
| Planned Year ($) | ||||||||
| EOM STOCK | Last Year ($) | |||||||
| Planned TY ($) | $12,230,000 | |||||||
| PLANNED PURCHASES AT RETAIL | LY Purchases @R ($) | |||||||
| TY Planned ($) | ||||||||
| PLANNED PURCHASES AT COST | LY Purchases @C ($) | |||||||
| TY Planned ($) | ||||||||
| ON ORDER | OO @R | $25,000 | $20,300 | $17,630 | $25,170 | $25,390 | $13,480 | |
| OO @C | ||||||||
| OPEN TO BUY | OTB @R | |||||||
| OTB @C | ||||||||
| Leave LY's cells Blank | ||||||||
| Fill This Year's Cells |
Name Six- Month Plan (Basic Stock) Due Date
