Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

image text in transcribed

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 Ready

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance And Public Policy

Authors: Jonathan Gruber

7th Edition

1319281109, 9781319281106

More Books

Students also viewed these Finance questions