***VIEW ONLINE THE EXCEL SHEET IS MORE VISIBLE***

A B C D E H 1 TY-PLAN F G Department Name and # LY-LAST YEAR Average Stock $ 147,913 Tumover Rate 222 Overall Markdown % 10.03% ACTUAL ACTUAL Workroom Expenses na March April May June July Season Total 100% 1 Six-Month Merchandising Plan 2 Student Practice Template 3 4 LY-LAST YEAR TY-PLAN 5 Mark Up % 58% 6 Cost % 42% 7 8 Spring 20 February 9 10 11 Monthly % of Sales 12.04% 12 13 SALES Last Year $ 39,600 $ 14 Plan 15 Revised 16 Actual 17 18 BOM Stock Last Year $ 130,680 $ 19 Plan 20 Revised 21 Actual 14.04% 12.89% 20.06% 21.91% 19.06% 100.00% 42,400 $ 46,200 $ 66,000 $ 72,100 $ 62,700 $ 329,000 132,990 $ 133,980 $ 165,000 $ 159,720 $ 163,020 22 Last Year $ 132,990 $ 133,980 $ 165,000 $ $ 159,720 $ 163,020 $ 150,000 23 EOM STOCK 24 (EOS stock is 25 Jan July EOM) 26 27 Plan Revised Actual Last Year $ 1,650 $ 2,640 $ $ 3,960 $ 9,900 $ $ 9,240 $ 33,009 28 Markdowns 29 5,619 $ 17.02% Monthly % 5.00% 8.00% 12.00% 29.99% 27.99% 100.00% Plan Monthly % Actual 30 31 32 33 34 35 Retail Purchase Last Year $ 43,560 $ 46,030 $ 82,839 $ 64,680 $ 85,300 $ 58,920 $ 381,329 Plan 36 Revised 37 Actual 38 39 Cost Purchases Last Year 40 Plan 41 Revised $ 18,295 $ 19,333 $ 34,792 $ 27,166 $ 35,826 $ 24,746 $ 160,158 Actual 3.14 2.60 42 43 44 Stock to Sales R Last Year 3.30 2.90 2.50 2.22 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 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. 56 D E H 1 A B 1 Six-Month Merchandising Plan 2 Student Practice Template Department Name and LY LAST YEAR 1 ACTUAL TRAN 4 5 LYLAN VAR Sex ACTUAL Mark Up Cost Season Teal 18 2 200 100.00 1 000 44001 200 100 00 DO 8 Spring 20 9 10 11 Month of 12 1 M 14 15 Red 16 Atual 17 18 HONOR 19 Plen 20 21 Actuel 3305 165.000 15875 . 13300 . 10.101 16.10 14.00 Red All 23 BON NOG 24 W 25 OM 26 27 20 de 29 30 31 32 33 TITIT Layar 5 2003 3. 20 50 13. 20 1000 A Last year 1 35 36 37 Red A RS 183333 S. 3.15 300 100.15 29 Coat Pares Last Year Plan I 42 Acum 2:14 200 230 222 46 Plan a 8% increase in sales for Spring 2021 47 Use the last year monthly X of sales 48 Use the last year monthly % of markedowns 49 Use last year Overall Markdown so Use last year Stock to Sale Ratio 51 Use markup percent of 58% 52 Use End of Season Stock of $160,000 53 Plan monthly sales, BOM stock dollars, EOM stock dollars, Markdowns, retail purchases for each month 50 S5 Note: The revised and actual rows in the template will not be used in the assignment. A B C D E H 1 TY-PLAN F G Department Name and # LY-LAST YEAR Average Stock $ 147,913 Tumover Rate 222 Overall Markdown % 10.03% ACTUAL ACTUAL Workroom Expenses na March April May June July Season Total 100% 1 Six-Month Merchandising Plan 2 Student Practice Template 3 4 LY-LAST YEAR TY-PLAN 5 Mark Up % 58% 6 Cost % 42% 7 8 Spring 20 February 9 10 11 Monthly % of Sales 12.04% 12 13 SALES Last Year $ 39,600 $ 14 Plan 15 Revised 16 Actual 17 18 BOM Stock Last Year $ 130,680 $ 19 Plan 20 Revised 21 Actual 14.04% 12.89% 20.06% 21.91% 19.06% 100.00% 42,400 $ 46,200 $ 66,000 $ 72,100 $ 62,700 $ 329,000 132,990 $ 133,980 $ 165,000 $ 159,720 $ 163,020 22 Last Year $ 132,990 $ 133,980 $ 165,000 $ $ 159,720 $ 163,020 $ 150,000 23 EOM STOCK 24 (EOS stock is 25 Jan July EOM) 26 27 Plan Revised Actual Last Year $ 1,650 $ 2,640 $ $ 3,960 $ 9,900 $ $ 9,240 $ 33,009 28 Markdowns 29 5,619 $ 17.02% Monthly % 5.00% 8.00% 12.00% 29.99% 27.99% 100.00% Plan Monthly % Actual 30 31 32 33 34 35 Retail Purchase Last Year $ 43,560 $ 46,030 $ 82,839 $ 64,680 $ 85,300 $ 58,920 $ 381,329 Plan 36 Revised 37 Actual 38 39 Cost Purchases Last Year 40 Plan 41 Revised $ 18,295 $ 19,333 $ 34,792 $ 27,166 $ 35,826 $ 24,746 $ 160,158 Actual 3.14 2.60 42 43 44 Stock to Sales R Last Year 3.30 2.90 2.50 2.22 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 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. 56 D E H 1 A B 1 Six-Month Merchandising Plan 2 Student Practice Template Department Name and LY LAST YEAR 1 ACTUAL TRAN 4 5 LYLAN VAR Sex ACTUAL Mark Up Cost Season Teal 18 2 200 100.00 1 000 44001 200 100 00 DO 8 Spring 20 9 10 11 Month of 12 1 M 14 15 Red 16 Atual 17 18 HONOR 19 Plen 20 21 Actuel 3305 165.000 15875 . 13300 . 10.101 16.10 14.00 Red All 23 BON NOG 24 W 25 OM 26 27 20 de 29 30 31 32 33 TITIT Layar 5 2003 3. 20 50 13. 20 1000 A Last year 1 35 36 37 Red A RS 183333 S. 3.15 300 100.15 29 Coat Pares Last Year Plan I 42 Acum 2:14 200 230 222 46 Plan a 8% increase in sales for Spring 2021 47 Use the last year monthly X of sales 48 Use the last year monthly % of markedowns 49 Use last year Overall Markdown so Use last year Stock to Sale Ratio 51 Use markup percent of 58% 52 Use End of Season Stock of $160,000 53 Plan monthly sales, BOM stock dollars, EOM stock dollars, Markdowns, retail purchases for each month 50 S5 Note: The revised and actual rows in the template will not be used in the assignment