Anyone could help me with this?

4. The organisation operational plan indicates that there is a marketing allocation of $3,000,000 for the whole organisation to help achieve the sales targets. There is a risk that Hools may only sell with a 30% increase in volume over the next quarter and that a sales promotion may be required. Using the example spread sheet you prepared for step 2, prepare a 'Contingency Budget' {for a single store} to include a Hools sale for the nal month of the quarter. Budget for Hools to increase their unit sales for that month by 60% if a $30,000 advertising program is run in combination with a sales price, equating to a 10% reduction from the normal retail price. The revised target for the quarter ($4,542,788) still needs to be reached. Step 2 C A o E | F G | H I 1 PREVIOUS QUARTER FORECAST FOR NEXT QUARTER Q ft? 5 | Revued' sales gures against Revised sales figures to meet Q \"1'! uan I a es uan I 2 information provided target 3 . 150.000 5 150.000 5.000 3 195.000 5 30,00 4 S 1. 250.000 5 1.000.000 10.000 31.000000 100,00 5 3.750 5 750.000 5 750.000 3.750 5 975.000 5 200,00 4.875 6 7.500 5 525.000 5 787.500 11.250 5 787.500 5 70,00 11.250 7 2.525 5 25.250 5 0 S - S - - 8 2.500 5 375.000 5 375.000 2.500 5 487.500 5 150,00 3.250 9 8.750 5 875.000 5 875.000 8.750 51.137.500 5 100,00 11.370 10 42. 525 S 3.950.250 S 3.937.511) 41.250 54.542. 788 47. 245 11 12 Target 5 4. 542. 788 I .l 13 all based on above calculations 5 605.288 Total of unchanged items 5 2.150.000 These items must increase by 30% to meet shortfall of 14 605.288,00 and meet revised target 1 I: A A B c o E F G H | l _1 sALes DATA PREVIOUS QUARTER FORECAST FOR NEXT QUARTER 2 Product Price/u nit Quantity Sales Talia-:95 to meet 3 Widgets 4 Zings 5 Ears E Hon-ls S 7 Pings 8 "no: 9 Heels 10 Total 5 1.1_ 1; Target 11 Shortfall Total of unchanged items 5 14 15 Contingemv budget I 16 Calculations of Hools sales based on ? 17 Quantity sold per mont h based on previous quarter: ? 18 Price/u nit Quantity Sales Comment 19 Month 1 5 5 20 Month 2 5 5 11 Month 3 5 5 22 TOTAL 5 5