Question

PLANNING EXERCISE INSTRUCTIONS FILL IN THE MISSING INFORMATION MANAS INCREASE IN SALES OVER LAST YEAR.PL 7 2 6 MONTH MERCHANDISE PLAN STOCK TO SALES 1.6 L PLANNED REDUCTIONS % 10% SPRING 20 FEB $16,500 LAST YEAR 1.0 15% MAR 1.5 15% APR 1. 15% MAY 1.6 20% 25% JUN $32,000 $18,000 $15.000 $38,500 $40,000 $160.000 CHANGE $25,000 $58,500 $30,000 $28,500 $85,000 $65,000 $292,000 LAST YEAR RETAIL STOCK (BOM) $58,500 $30,000 $28,600 $85,000 $65,000 $45,000 $312.000 $40.000 EOM) XCHANGE $1,650 $ 3,200 1,800 $ ,500 3,850 $ 4,000 $16,000 10% 10% 10% 10% 10% 10% $45.000 $ 10,000 $ 15,000 $ 70,000 $ 40,000 $ 18,500 $198.500 AT RETAIL

Answer 1

Please file below mentioned answer.

Working 1 - Excel Tell me what you want to do... Formulas Data Review View Share File . Home Insert Page Layout Cut Le Copy Format Painter BIU - Clipboard Font Calibri -11 A A === 2 & Wrap Text General D o Samrat Das AutoSum" AY O Sort & Find & Clear Filter - Select Editing Paste - >- A S E 0 .08 Merge & Center - Alignment % , Number Conditional Format as Cell Formatting* Table Styles Styles Insert Delete Format - Cells H K L M N O A 5% B C D E F G 1 Instruction fill in the missing information, plan A 5% increase in sale over the last year. Plan reduction at 10% on sales. 2 6 Month merchandise plan Stock to sale 1.5 1.8 1.5 1.7 2 Planned Reduction % 10% 15% 15% 15% 25% Spring 20 FEB MAR APR MAY JUN Last year 16,500 32,000 18,000 15,000 38,500 Sales Plan 17,325 33,600 18,900 15,750 40,425 % change 5% 5% 5% 5% Last year 25,000 58,500 30,000 28,500 85,000 10 Retail Stock (BOM) Plan 24,750 57,600 27,000 25,500 77,000 % change -1.0% -1.5% -10.0% -10.5% -9.4% Last year 58,500 30,000 28,500 85,000 65,000 13 Retail Stock (EOM) Plan 87,750 54,000 42,750 1,44,500 1,30,000 % change 50.0% 80.0% 50.0% 70.0% 100.0% Last year 1,650 3,200 1,800 1,500 3,850 Reduction Plan 1,650 3,200 1,800 1,500 3,850 Planned % 10% 10% 10% 10% 10% Last year 45,000 10,000 70,000 40,000 Purchases at Retail Plan 1 81,975 33,200 36,450 1,36,250 97,275 % change 82.2% 232.0% 143.0% 94.6% 143.2% 11 1.5 L 20% JUL 40,000 42,000 5% 65,000 60,000 -7.7% 45,000 67,500 50.0% 4,000 4,000 10% 18,500 53,500 189.2% 12 1,60,000 1,68,000 5% 2,92,000 2,71,850 -6.9% 3,12,000 5,26,500 68.8% 16,000 16,000 10% 1,98,500 4,38,650 121.0% 15,000 23 Sheet1 Ready H || || - - 00:24 ? )) ENG 29-11-2019 e S 049 A O