Using last year's figures for a hardware department, plan a 12% increase for next year, maintaining the same monthly sales percentages, the same stock-to-stock ratios, and the same markdown percents as last year. A six-month plan is completed below. Last year's spring season figures were as follows: Markdowns $4,560 $2,361 $6,438 $6,892 $4,650 $2,005 OM Stocks $97,800 $124,590 $115,410 $103,830 $102,280 $91,730 $104,400 Sales Volume $42,700 $55,600 $51,700 $63,100 $45,500 $33,000 February March April May June July August Last year's departmental markup was 48%. Analyze the information below and answer the questions underneath the plan. Departmental Name: No. IThie Yoar) n/a (Last Yoar). n/a Workroom Cost Cash Discount % Shortage/Overage % Average Stock Season Stock Turnover SIX-MONTH n/a n/a MERCHANDISING PLAN n/a n/a $118,439 $105,720 Departmental Markup 2.76 2.76 Actual Last Year Plan Overall Markdown% 9.23% 9.23% 48.0% 48.0% Spring 20 Fall 20 Sales Percent Each Month May June Dec. Feb. Mar. Apr. Oct 18% July Season Total Aug 15% 42,700 Sept Nov. Jan. 100% 291,600 326,592 22% 16% 11% 19% 33,000 36,960 55,600 62,272 45,500 50,960 63,100 Last Year 51,700 57,904 47,824 70,672 Sales Plan $ Revised Actual 124,590 139,489 97,800 109,517 115,410 102,280 114,660 91,730 102,749 103,830 116,609 Last Year Retail 129, 126 Stock Plan (OM) $ Revised Actual 6,438 7,209 12.45% 12.45% 4,560 5,108 10.68% 10.68% 2,361 6,892 7,717 26,906 30,136 4,650 5,208 10.22% 10.22% 2,005 2,247 Last Year Plan (dollars) 2,647 4.25% 4.25% Markdowns 10.92% 6.08% Last Year Monthly % 10.92% 6.08% Plan Monthly % Actual Dollars 325,106 364,131 74,050 82,904 48,781 54,556 46,558 52,596 68,442 76,440 47,675 53,378 39,600 44,257 Last Year Plan Retail Purchases Revised Actual 35,589.84 39,748.80 52.0% 38,506.00 Plan 43,110.08 25,366.12 28,369.12 24,210.16 27,349.92 24,791.00 27,756.56 169,055.12 189,348.12 20,592.00 23,013.64 Last Year Cost Purchases Revised Actual EOM 124,590 139,489 102,280 114,660 91,730 102,749 35.8% 115,410 103,830 104,400 116,920 Last Year Stock 129,126 116,609 Plan July 31 & Jan 31 Revised Actual SRESteck Last Year 2.29 2.24 2.23 1.65 2.25 2.78 Sales 1.65 2.29 2.24 2.23 2.25 2.78 Plan Patio Merchandise Manager Department Buyer Controller What is the sum of the sales percentages from February to July? Explain, in words, how to calculate the sales percentage for each month. Which month during this season had the highest sales last year? The stock-to-sales ratio for the month of May was 1.65 last year. Explain, in words, what this means. Explain how to calculate last year's markdown percentage for the entire season. Then, calculate this percentage Compare the result from #5 to last year's markdown percentage for May. Provide one possible scenario that would cause this. Explain how to calculate the retail purchases for each month. The EOM for the month of March is the same as the BOM for the month of Using last year's figures for a hardware department, plan a 12% increase for next year, maintaining the same monthly sales percentages, the same stock-to-stock ratios, and the same markdown percents as last year. A six-month plan is completed below. Last year's spring season figures were as follows: Markdowns $4,560 $2,361 $6,438 $6,892 $4,650 $2,005 OM Stocks $97,800 $124,590 $115,410 $103,830 $102,280 $91,730 $104,400 Sales Volume $42,700 $55,600 $51,700 $63,100 $45,500 $33,000 February March April May June July August Last year's departmental markup was 48%. Analyze the information below and answer the questions underneath the plan. Departmental Name: No. IThie Yoar) n/a (Last Yoar). n/a Workroom Cost Cash Discount % Shortage/Overage % Average Stock Season Stock Turnover SIX-MONTH n/a n/a MERCHANDISING PLAN n/a n/a $118,439 $105,720 Departmental Markup 2.76 2.76 Actual Last Year Plan Overall Markdown% 9.23% 9.23% 48.0% 48.0% Spring 20 Fall 20 Sales Percent Each Month May June Dec. Feb. Mar. Apr. Oct 18% July Season Total Aug 15% 42,700 Sept Nov. Jan. 100% 291,600 326,592 22% 16% 11% 19% 33,000 36,960 55,600 62,272 45,500 50,960 63,100 Last Year 51,700 57,904 47,824 70,672 Sales Plan $ Revised Actual 124,590 139,489 97,800 109,517 115,410 102,280 114,660 91,730 102,749 103,830 116,609 Last Year Retail 129, 126 Stock Plan (OM) $ Revised Actual 6,438 7,209 12.45% 12.45% 4,560 5,108 10.68% 10.68% 2,361 6,892 7,717 26,906 30,136 4,650 5,208 10.22% 10.22% 2,005 2,247 Last Year Plan (dollars) 2,647 4.25% 4.25% Markdowns 10.92% 6.08% Last Year Monthly % 10.92% 6.08% Plan Monthly % Actual Dollars 325,106 364,131 74,050 82,904 48,781 54,556 46,558 52,596 68,442 76,440 47,675 53,378 39,600 44,257 Last Year Plan Retail Purchases Revised Actual 35,589.84 39,748.80 52.0% 38,506.00 Plan 43,110.08 25,366.12 28,369.12 24,210.16 27,349.92 24,791.00 27,756.56 169,055.12 189,348.12 20,592.00 23,013.64 Last Year Cost Purchases Revised Actual EOM 124,590 139,489 102,280 114,660 91,730 102,749 35.8% 115,410 103,830 104,400 116,920 Last Year Stock 129,126 116,609 Plan July 31 & Jan 31 Revised Actual SRESteck Last Year 2.29 2.24 2.23 1.65 2.25 2.78 Sales 1.65 2.29 2.24 2.23 2.25 2.78 Plan Patio Merchandise Manager Department Buyer Controller What is the sum of the sales percentages from February to July? Explain, in words, how to calculate the sales percentage for each month. Which month during this season had the highest sales last year? The stock-to-sales ratio for the month of May was 1.65 last year. Explain, in words, what this means. Explain how to calculate last year's markdown percentage for the entire season. Then, calculate this percentage Compare the result from #5 to last year's markdown percentage for May. Provide one possible scenario that would cause this. Explain how to calculate the retail purchases for each month. The EOM for the month of March is the same as the BOM for the month of