Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 places in the Guest Count Forecast column, cells C23:C34. Use the SUM function for the total, cell C35. Otherwise, your answers will not be correct.) MONTH SALES LAST PREDICTED PROJECTED REVENUE YEAR CHANGE SALES FORCAST INCREASE JANUARY $45,216.00 5% 47.476.8 FEBURARY 48,538.00 5% MARCH 50,009.00 5% APRIL 45,979.00 5% MAY 49,703.00 5% JUN 48,813.00 5% JULY 55,142.00 5% AUGUST 59,119.00 5% SEPTEMBE 55,257.00 5% R OCTOBER 50,900.00 5% NOVEMBER 54,054.00 5% DECEMBER 50,998.00 5% TOTAL 613,728.00 5%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Advanced Financial Accounting

Authors: Theodore E. Christensen, David M. Cottrell, Cassy Budd

13th International Edition

1265042616, 9781265042615

Students also viewed these Accounting questions

Question

Does positivity have a place in the workplace? Explain.

Answered: 1 week ago