Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help figuring the answers to the colored blocks Reren File HomeInsertPage LayoutFormulas Data Reriew View Add-Ins A1 Chapter 2, Question 1 1 Chapter 2,
need help figuring the answers to the colored blocks
Reren File HomeInsertPage LayoutFormulas Data Reriew View Add-Ins A1 Chapter 2, Question 1 1 Chapter 2, uestion 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. Calculate her sales variances and percentage variances for the 2 first 6 months of the earSales Last Percentage 3 Month Sales This Year Year 4 January 5 February 6 March Variance Variance $37,702.73 $34,861.51 $33,472.03 $31,485.60 $36,492.98 $33,707.79 $35,550.12 $32,557.85 $36,890.12 $37,852.42 $37,482.52 $37,256.36 8 Ma 9 June 10 Total 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 six-month total percentage variance of 4 75% to predict her changes in sales. Help her calculate the projected sales increases and revenue PredictedProjected Sales Revenue Forecast Sales Last YearChange 4.75% 4.75% 4.75% 4.75% 4,75% Increase 13 14 Ju 15 August 16 September 17 October 18 November Month $36,587.91 | $36.989 731 $40,896 321 $37,858.63| $37.122.45 37 188 71 ReadyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started