Complete a season six-month merchandising plan using last year's results. Use historical sales (LY) results and percentage increase in sales to project plans for sales by dollars for this year (TY).

Build the formulas needed to calculate the following:

- Total season sales

- Sales by month

- BOM stock by month

- Markdowns by month

- Retail purchases by month

- Cost purchases by month

- Average stock dollars

- Turnover rate

Please use the provided Excel merchendising plan worksheet!

B D F G H Department Name and# LY-LAST YEAR TY-PLAN ACTUAL 1 Six-Month Merchandising Plan 2 Student Practice Template 3 4 LY-LAST YEAR TY-PLAN 5 Mark Up% 6 Cost% ACTUAL wy 2008 Revised 8 Spring 20 February April Season Total 100% 10 11 Monthly of Sales 12.04% 14.45 21315 19.06 100.00 12 13 SALES Last Year $ 39.500 $ 42.400 48.2005 68.000 72,1003 62.700 $ 329.000 14 Pan 15 Revised 16 Actual 17 18 BOM Stock Last Year 130.680 $ 132.905 133.903 965005 1597205 163.920 19 20 Revhed 21 Actual 22 23 EOM STOCK Last Year $ 132.00 133.00 185.000 150720 163,020 150.000 24 (EOSsboks Pan 25 Jany EOM 26 Actual 27 28 Markdown Last Year S 16505 2.5405 5.5195 390S 9.9005 9.2405 33.000 29 Monthly 5X 8.00 17021 12.00 29.99% 27 100.00 30 Plan 31 Monthly 32 Actual 33 34 ROST Last Year PLAN 43.560 48,030 12.99 $ 6480 85300 58.920 S 381329 35 Pin 36 Revbed 37 Actual 38 39 Cost Purchases Last Year 5 182955 19.3333 347925 27.1665 35.8265 247465 160.158 40 Pan 41 Revised 42 Actual 43 44 Stock to Sales R. Last Year 3.14 20 2.50 222 2.60 45 Plan 46 Plan a 8% increase in sales for Spring 2021 47 Use the last year monthly % of sales 48 Use the last year monthly % of markdowns 49 Use last year Overall Markdown % 50 Use last year Stock to Sale Ratio 51 Use markup percent of 58% 52 Use End of Season Stock of $160,000 53 Plan month sales, BOM stock dollars, EOM stock dollars, Markdowns, retail purchases for each month 54 55 Note: The revised and actual rows in the template will not be used in the assignment. 56 B D F G H Department Name and# LY-LAST YEAR TY-PLAN ACTUAL 1 Six-Month Merchandising Plan 2 Student Practice Template 3 4 LY-LAST YEAR TY-PLAN 5 Mark Up% 6 Cost% ACTUAL wy 2008 Revised 8 Spring 20 February April Season Total 100% 10 11 Monthly of Sales 12.04% 14.45 21315 19.06 100.00 12 13 SALES Last Year $ 39.500 $ 42.400 48.2005 68.000 72,1003 62.700 $ 329.000 14 Pan 15 Revised 16 Actual 17 18 BOM Stock Last Year 130.680 $ 132.905 133.903 965005 1597205 163.920 19 20 Revhed 21 Actual 22 23 EOM STOCK Last Year $ 132.00 133.00 185.000 150720 163,020 150.000 24 (EOSsboks Pan 25 Jany EOM 26 Actual 27 28 Markdown Last Year S 16505 2.5405 5.5195 390S 9.9005 9.2405 33.000 29 Monthly 5X 8.00 17021 12.00 29.99% 27 100.00 30 Plan 31 Monthly 32 Actual 33 34 ROST Last Year PLAN 43.560 48,030 12.99 $ 6480 85300 58.920 S 381329 35 Pin 36 Revbed 37 Actual 38 39 Cost Purchases Last Year 5 182955 19.3333 347925 27.1665 35.8265 247465 160.158 40 Pan 41 Revised 42 Actual 43 44 Stock to Sales R. Last Year 3.14 20 2.50 222 2.60 45 Plan 46 Plan a 8% increase in sales for Spring 2021 47 Use the last year monthly % of sales 48 Use the last year monthly % of markdowns 49 Use last year Overall Markdown % 50 Use last year Stock to Sale Ratio 51 Use markup percent of 58% 52 Use End of Season Stock of $160,000 53 Plan month sales, BOM stock dollars, EOM stock dollars, Markdowns, retail purchases for each month 54 55 Note: The revised and actual rows in the template will not be used in the assignment. 56