Answered step by step
Verified Expert Solution
Link Copied!

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

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

New Trends In Algebraic Geometry

Authors: K Hulek ,M Reid ,C Peters ,F Catanese

1st Edition

0521646596, 978-0521646598

More Books

Students also viewed these Mathematics questions