File Home 11 Arial 12 - ' ' 22 Wrap Text A. Metge & Center Currency $ - % -21 Paste BIU Conditional Formatas Formatting - Table - Styl Styles Font Gpboard Alignment Number E14 f G H B 1 Peggy Richey operates Peggy's Pizza Place She has maintained a sales history for January through June, and she wants to compare this year's sales with last year's sales Calculato ber sales vanances and percentage variances for the 2. list 6 months of the year Sales Last Percentage Month Sales This Year Year Variance Variance 4 January $37,702.73 $34,86151 $2,84122 8.15 5 February $33,472.03 $31,485 60 $1986.43 6.31 6 March $36,492.98 $33,707.79 $2 785 19 8.26 7 April $35550.12 $32,557 85 $2,992 27 9.19 8 May $36,890.12 $37,852.421 $962 30 -254 9 June $3748252 $37 256 36 $226.16 0.61 Total $217,590 50 $207,72153 $9,868.97 $29.98 11 10 Al AN 1 W AEE2Merge Geri Ceny % Pante B! Conditional im Formatting lab. De F 114 $ G H Peggy wants to use the sales and variance information from her first six months of the year to forecast her revenues for the last six months of the year She decides to use her a month fotal percentage variance of 475% to predict her changes in sales Help her calculate the projected sales increases and revenue 12 forecards for the last six months of the year Predicted Projected Sales Revenue Month Sales Last Year Change Increase Forecast 14 July $36,58791 4755 51373793 16 August $36989.73 4759 $1,757.01 16 September S40 890 32 4.18% $1,94258 Odober $37,858 63 1754 51279 28 1 November $37, 12245 475% SIR2032 19 December $3718871 $1,700 6 Month 5221 64375 $10.70 20 Create a ne chart showing the revenue forecast for the next six months. You hould include the name of the month and the forecastigures 14 CHE 1 O 01 type here to O DELL 2 Q W E R T A Caps lock S D F G shift N B ctrl in alt