Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the ROUND function to zero decimal places in the Guest Count Forecast columns, cells D5 through D10 (D5:D10) and D15 through D20 (D15:D20). Use
Use the ROUND function to zero decimal places in the Guest Count Forecast columns, cells D5 through D10 (D5:D10) and D15 through D20 (D15:D20). Use the SUM function for the totals, cells D11 and D21. Otherwise, your answers will not be correct. Months January through June Month Guest Count Last Year Guest Count % Increase Estimate Guest Count Forecast Original Check Average Revenue Forecast January 6,270 4.00% 6,521 30 $195,624.00 February 6,798 4.00% 7,070 30 March 6,336 4.00% 6,589 30 April 6,400 4.00% 6,656 30 May 6,930 4.00% 7,207 30 June 6,864 4.00% 7,139 30 6-Month Total 39,598 24.00% 41,182 180 $195,624.00
Step 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