Question: 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

1 Expert Approved Answer

Step: 1 Unlock

To solve this problem well perform the required operations in an Excel spreadsheet Youll need to use ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

1 Chapter 2 , Question 8 Use the ROUND function to zero decimal places in the Guest Count Forecast columns, cells D 5 through D 1 0 ( D 5 :D 1 0 ) and D 1 5 through D 2 0 ( D 1 5 :D 2 0 ) . Use the...

-The Lopez brothers, Angelo, Antonio, and Isaiah, own the Lopez Cantina. Angelo is in charge of marketing, and he is developing his sales forecast for next year. Because of his marketing efforts, he...

B. Using the weighted check average calculated in part A, determine Angelo's projected sales, assuming a 5 percent increase in guest counts. (Spreadsheet hint: Use the ROUND function to zero decimal...

B . Use the ROUND function to zero decimal places in the Guest Count Forecast column, cells C 2 3 :C 3 4 . Use the SUM function for the total, cell C 3 5 . Otherwise, your answers will not be correct.

determine Angelo's projected sales, 35 assuming a 5 percent increase in guest counts. (Spreadsheet hint: Use the ROUNDDOWN 36 function to zero decimal places in the Guest Count Forecast column, cells...

6. "The Lopez brothers, Angelo, Antonio, and Isaiah, own the Lopez Cantina. Angelo is in charge of marketing, and he is developing his sales forecast for next year. Because of his marketing efforts,...

Chapter 2, Question 5 The Lopez brothers, Angelo, Antonio, and Isaiah, own the Lopez Cantina. Angelo is in charge of marketing, and he is developing his sales forecast for next year. Because of his...

The Lopez brothers, Victor, Tony, and Soren, own the Lopez Cantina. Victor is in charge of marketing, and he is developing his sales forecast for next year. Because of his marketing efforts, he...

YO19_Excel_Cho3_Prepare_Wedding Project Description: Clint Keller and Addison Ryan have just booked a wedding at Painted Paradise Resort and Spa When requested by a happy couple, the Turquoise Oasis...

what is the formula for revenue forecast rical percentage of guests who eat breakfast? 8. Lakota Vela operates Hall's House, a mid-priced restaurant with a $30.00 check average. Her clientele...

Write a function called filter-seq that takes a sequence s (a string) and an alphabet a (a string), and generates a result sequence (a string) by including only the characters of s that occur in the...

Find the cell reaction and calculate the potential of the following cell at 298 K. Cd(s) | CdS0 (0.01 mol kg, y = 0.383), PbSO4(s) | Pb - Pb | PbSO4(s), CdSO (1.00 mol kg, y = 0.042) | Cd(s) T *****e

6 5 of 3 3 0 8 . 2 1 On your 2 3 rd birthday you open a 4 0 1 K account ( retirement account ) . At that time and on each succeeding birthday up to and including your 6 0 th birthday, you deposit $ 2...

Kasko Stores accepts debit as well as its own credit card and national credit cards for payment. During the year the following selected transactions occurred. Record the journal entries for each...