Dollar Plan Assignment
Pastel12
AMM2510AWeek12HandoutDollarPlanSSRDataF2021.xlsxSSR Activity
| Six- Month Budget | Season: ________ | Department:___________ | Buyer's Name:________________ | ||||||
| Actual (LY) | Plan (TY) | Change(%) over LY | ||||||
| Total Retail ($) | $900,000.00 | $1,080,000.00 | 20.00% | |||||
| Total Retail Reductions ($) | $60,300.00 | $81,000.00 | 34.33% | |||||
| Total Reduction (of Sales) % | 6.70% | 7.50% | ||||||
| Initial Markup % | 65.00% | |||||||
| Average Retail Stock | $587,142.86 | $696,742.86 | 18.67% | |||||
| Average Monthly Sales | $150,000.00 | $180,000.00 | 20.00% | |||||
| Season: | Aug | Sep | Oct | Nov | Dec | Jan | Season Total | |
| SALES | Last Year Sales $ | $75,000.00 | $205,000.00 | $135,000.00 | $135,000.00 | $230,000.00 | $120,000.00 | $900,000.00 |
| % TT (LY) | 8.33% | 22.78% | 15.00% | 15.00% | 25.56% | 13.33% | 100.00% | |
| Planned Sales $ | $90,000.00 | $246,000.00 | $162,000.00 | $162,000.00 | $276,000.00 | $144,000.00 | $1,080,000.00 | |
| % TT (Planned TY) | 8.33% | 22.78% | 15.00% | 15.00% | 25.56% | 13.33% | 100.00% | |
| REDUCTIONS | Last Year $ | $2,000.00 | $2,000.00 | $6,500.00 | $6,500.00 | $19,300.00 | $24,000.00 | $60,300.00 |
| % TT (LY) | 3.32% | 3.32% | 10.78% | 10.78% | 32.01% | 39.80% | 100.00% | |
| Planned Year $ | $2,686.57 | $2,686.57 | $8,731.34 | $8,731.34 | $25,925.37 | $32,238.81 | $81,000.00 | |
| % TT (Planned TY) | 3.32% | 3.32% | 10.78% | 10.78% | 32.01% | 39.80% | 100.00% | |
| Reduction (of Sales) % | 2.99% | 1.09% | 5.39% | 5.39% | 9.39% | 22.39% | 7.50% | |
| STOCK | BOM (LY) $ | $455,500.00 | $550,000.00 | $650,000.00 | $700,500.00 | $750,000.00 | $550,000.00 | |
| SSR (LY) | 6.07 | 2.68 | 4.81 | 5.19 | 3.26 | 4.58 | ||
| BOM (TY) $ | $546,600.00 | $660,000.00 | $780,000.00 | $840,600.00 | $900,000.00 | $660,000.00 | ||
| SSR (TY) | 6.07 | 2.68 | 4.81 | 5.19 | 3.26 | 4.58 | ||
| EOM (LY) $ | $550,000.00 | $650,000.00 | $700,500.00 | $750,000.00 | $550,000.00 | $454,000.00 | ||
| EOM (TY) $ | $660,000.00 | $780,000.00 | $840,600.00 | $900,000.00 | $660,000.00 | $490,000.00 | ||
| PLANNED PURCHASES | Purchases at Retail $ (TY) | $206,086.57 | $368,686.57 | $231,331.34 | $230,131.34 | $61,925.37 | $6,238.81 | $1,104,400.00 |
| Purchases at Cost $ (TY) | $72,130.30 | $129,040.30 | $80,965.97 | $80,545.97 | $21,673.88 | $2,183.58 | $386,540.00 | |
| MAINTAINED MARKUP | Planned (TY) $ | $57,559.70 | $158,959.70 | $102,244.03 | $102,244.03 | $170,326.12 | $82,316.42 | $673,650.00 |
| Planned (TY) % | 63.96% | 64.62% | 63.11% | 63.11% | 61.71% | 57.16% | 62.38% |
&"Times New Roman,Bold"&14Six-Month Dollar Plan (SSR)
