Dollar Plan Assignment
Pastel12
AMM2510AWeek13HandoutDollarPlanBasicStockDataF2021.xlsxBasic Stock Data
| Sales Plan TY | $24,000,000 | Season: | Department: | Buyer's Name: | |||||||||||
| Actual Sales LY | $23,500,000 | ||||||||||||||
| Store # | 257 | Actual LY | Plan TY | Actual LY | Plan TY | ||||||||||
| Total Retail Reductions $ | Net Sales (Seasonal) | ||||||||||||||
| TY's Monthly Distribution (%) for Sales and Reductions | Total Retail Reductions % | Sales Change (%) over LY | |||||||||||||
| Month | Sales Distribution (% of total sales) | $ Sales | Red. Distribution (% of total reduction) | $Reduction | Initial Mark-up % | Average Retail Stock | |||||||||
| AUG | 15.00% | $3,600,000.00 | 14.00% | $806,400.00 | GM% | Stock Turnover | |||||||||
| SEPT | 18.00% | $4,320,000.00 | 10.00% | $576,000.00 | Profit% | Average Monthly Sales | |||||||||
| OCT | 10.00% | $2,400,000.00 | 8.00% | $460,800.00 | GMROI | Basic Stock | |||||||||
| NOV | 20.00% | $4,800,000.00 | 18.00% | $1,036,800.00 | |||||||||||
| DEC | 27.00% | $6,480,000.00 | 25.00% | $1,440,000.00 | Season: | Aug/Feb | Sep/March | Oct/April | Nov/May | Dec/June | Jan/July | Season Totals | |||
| JAN | 10.00% | $2,400,000.00 | 25.00% | $1,440,000.00 | SALES | LY Sales ($) | |||||||||
| TOTAL | 100.00% | $24,000,000 | 100.00% | $5,760,000.00 | % TT (LY) | ||||||||||
| TY Planned Sales ($) | |||||||||||||||
| TY's MEMO Figures | % TT (Planned TY) | ||||||||||||||
| FEB Sales | $2,500,000 | Total Red% (of $Sales) | 24.00% | REDUCTIONS | LY Red ($) | ||||||||||
| FEB BOM | $12,200,000 | MD% | 20% | % TT (LY) | |||||||||||
| Inventory TO | 2.5 | Shortage% | 2% | TY Planned Red ($) | |||||||||||
| GM% | 56.60% | Sales Discounts% | 2% | % TT (Planned TY) | |||||||||||
| P% | 5.00% | Average Stock | $9,600,000.00 | Avge stock = Net sales/ TO | Red% (of $NS TY) | ||||||||||
| IMU% | 65.00% | Basic Stock | $5,600,000.00 | IMU% = (GM% + Reduction%) / (1+Reduction%) | BOM STOCK | Last Year ($) | |||||||||
| Planned Year ($) | |||||||||||||||
| PURCHASES / RECEIPTS | EOM STOCK | Last Year ($) | |||||||||||||
| BOM | EOM | PURCHASE @ R | PURCHASE @ C | On Order @ R | OTB @ R | Planned TY ($) | |||||||||
| AUG | $9,200,000.00 | $9,920,000.00 | $5,126,400.00 | $1,794,240.00 | $34,000 | $1,760,240.00 | PLANNED PURCHASES @ R | LY Purchases @R ($) | |||||||
| SEPT | $9,920,000.00 | $8,000,000.00 | $2,976,000.00 | $1,041,600.00 | $18,500 | $1,023,100.00 | TY Planned ($) | ||||||||
| OCT | $8,000,000.00 | $10,400,000.00 | $5,260,800.00 | $1,841,280.00 | $13,500 | $1,827,780.00 | PLANNED PURCHASES @ C | LY Purchases @C ($) | |||||||
| NOV | $10,400,000.00 | $12,080,000.00 | $7,516,800.00 | $2,630,880.00 | $20,000 | $2,610,880.00 | TY Planned ($) | ||||||||
| DEC | $12,080,000.00 | $8,000,000.00 | $3,840,000.00 | $1,344,000.00 | $21,500 | $1,322,500.00 | ON ORDER | OO @R | |||||||
| JAN | $8,000,000.00 | $12,200,000.00 | $8,040,000.00 | $2,814,000.00 | $12,500 | $2,801,500.00 | OO @C | ||||||||
| TOTAL | $32,760,000.00 | $11,466,000.00 | OPEN TO BUY | OTB @R | |||||||||||
| OTB @C |
Week 13 Activity
