ONLY QUESTION 7 PLEASE THANK YOU

ONLY QUESTION 7 PLEASE THANK YOU

ONLY QUESTION 7 PLEASE THANK YOU

ONLY QUESTION 7 PLEASE THANK YOU

Case Study Team Project Spreadsheet 01_(25 pts.) Background Information: 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: Sales Volume BOM Stocks Markdowns February $42,700 $97,800 $4,560 March $55,600 $124,590 $2,361 April $51,700 $115,410 $6,438 May $63,100 $103,830 $6,892 June $45,500 $102.280 $4,650 July $33,000 $91.730 $2,005 August $104,400 Last year's departmental markup was 48%. Analyze the information below and answer the questions underneath the plan. Departmental Norte Nane Nu Plan This Yew Mitual Let Yet O IG SME,4.26 2.76 9.23% RO 5104720 2.76 9.23% % UN San JI 11% 100% 33,00 291.800 38,965 326.59 June SARG Total 45.500 114,050 91,730 102.70) Six-MONTH Workroom Cast MERCHANDISING PLAN Cash Discount Shortage og Average Stock Departmental Markup Benson Back Turnover Last Year Pan Actual 48.0% 1 Orriarkdowns Sorin 20 Feb Mar Apr May III A Sie Cod Nex Sales Para Ench Month 75% 1978 14% 22% 42.700 35,00D 51,700 6.100 Sales Han 47.821 62,272 67,90 70.672 $ Hoe Ach Retail Le 27.10124.590 La 275,410 303,230 Stock Ha 100.517 135.48 129,120 116,609 BOM Tad 15 M I 4,500