Answered step by step
Verified Expert Solution
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
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
Get Instant Access with AI-Powered 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