A B D E F G H $ 18,295 S 19,333$ 34.792 S 27.166 $ 35,826 $ 24,746 $ 160,150 Cost Purchases Last Year Plan Revised Actual 2.22 2.60 Stock to Sales R. Last Year 3.30 3.14 2.90 2.50 Plan 6 Plan a 8% increase in sales for Spring 2021 27 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 S3 each month 54 55 Note: The revised and actual rows in the template will not be used in the assignment. 56 Six-Month Merchandising Plan Student Practice Template Department Name and # LY-LAST YEAR TY-PLAN ACTUAL Average Stock $ 147,913 TY-PLAN ACTUAL 2 22 LY-LAST YEAR Mark Up% 58% Cost % 42% Turnover Rate Overall Markdown % Workroom Expenses 10.03% wa Spring 20 February March April May June July Season Total 100% Monthly % of Sales 12.04% 14.04% 12.89% 20.06% 21.91% 19.06% 100.00% SALES $ 39,600 $ 42.400$ 46,200 $ 66,000 $ 72,100 $ 62,700$ 329,000 Last Year Plan Revised Actual $ 130,680$ 132 990 $ 133,980$ 165,000 $ 159.720S 163,020 $ 132.990$ 8 BOM Stock Last Year 9 Plan 20 Revised 21 Actual 22 23 EOM STOCK Last Year 24 (EOS stocks Plan 25 JanJuly EOM) Revised 26 Actual 27 28 Markdowns Last Year 29 Monthly % 30 Plan 133,980 $ 165,000 $ 159,720$ 163,020 S 150,000 $ 140 $ 5.00% 2,840S 8.00% 5,619 $ 17 02% 3,960 $ 12.00% 9.900 S 29.99% 9,240$ 27.99% 33,009 100.00% Sheet1 A Actual 9,240$ Markdowns $ 2,640$ 8.00% 1,650 $ 5.00% 33,009 100.00% 5,619 $ 17.02% 9,900 $ 29.99% 3,960$ 12.00% 27.99% Last Year Monthly % Plan Monthly % Actual 58,920$ 381,329 24,746 $ 160,158 2.22 2.60 Retall Purchases Last Year $ 43,560$ 46,030 $ 82,839 $ 84.680$ 85,300 $ Plan 6 Revised -7 Actual 58 39 Cost Purchases Last Year $ 18,295 S 19,333$ 34,792 $ 27.166 S 35,8265 40 Plan 41 Revised 42 Actual 43 44 Ratio Last Year 3.30 3.14 2.90 2.50 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% S2 Use End of Season Stock of $160,000 53 Plan monthly 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 A B D E F G H $ 18,295 S 19,333$ 34.792 S 27.166 $ 35,826 $ 24,746 $ 160,150 Cost Purchases Last Year Plan Revised Actual 2.22 2.60 Stock to Sales R. Last Year 3.30 3.14 2.90 2.50 Plan 6 Plan a 8% increase in sales for Spring 2021 27 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 S3 each month 54 55 Note: The revised and actual rows in the template will not be used in the assignment. 56 Six-Month Merchandising Plan Student Practice Template Department Name and # LY-LAST YEAR TY-PLAN ACTUAL Average Stock $ 147,913 TY-PLAN ACTUAL 2 22 LY-LAST YEAR Mark Up% 58% Cost % 42% Turnover Rate Overall Markdown % Workroom Expenses 10.03% wa Spring 20 February March April May June July Season Total 100% Monthly % of Sales 12.04% 14.04% 12.89% 20.06% 21.91% 19.06% 100.00% SALES $ 39,600 $ 42.400$ 46,200 $ 66,000 $ 72,100 $ 62,700$ 329,000 Last Year Plan Revised Actual $ 130,680$ 132 990 $ 133,980$ 165,000 $ 159.720S 163,020 $ 132.990$ 8 BOM Stock Last Year 9 Plan 20 Revised 21 Actual 22 23 EOM STOCK Last Year 24 (EOS stocks Plan 25 JanJuly EOM) Revised 26 Actual 27 28 Markdowns Last Year 29 Monthly % 30 Plan 133,980 $ 165,000 $ 159,720$ 163,020 S 150,000 $ 140 $ 5.00% 2,840S 8.00% 5,619 $ 17 02% 3,960 $ 12.00% 9.900 S 29.99% 9,240$ 27.99% 33,009 100.00% Sheet1 A Actual 9,240$ Markdowns $ 2,640$ 8.00% 1,650 $ 5.00% 33,009 100.00% 5,619 $ 17.02% 9,900 $ 29.99% 3,960$ 12.00% 27.99% Last Year Monthly % Plan Monthly % Actual 58,920$ 381,329 24,746 $ 160,158 2.22 2.60 Retall Purchases Last Year $ 43,560$ 46,030 $ 82,839 $ 84.680$ 85,300 $ Plan 6 Revised -7 Actual 58 39 Cost Purchases Last Year $ 18,295 S 19,333$ 34,792 $ 27.166 S 35,8265 40 Plan 41 Revised 42 Actual 43 44 Ratio Last Year 3.30 3.14 2.90 2.50 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% S2 Use End of Season Stock of $160,000 53 Plan monthly 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
