Home Insert Draw Page Layout Formulas Data Review View To AutoSum Recently Used 2 Logical A Text Define Name CB 13 Lookup & Reference O Math & Trig More Functions Insert Function Financial Date & Time EO Create from Selectio M23 x 0 2. Lakota Vela operates Hall's House, a mid-priced restaurant with a $30.00 check average. Her clientelo consists of business people and tourists visiting her city. Based on the historical sales records she keeps, Lakota believes her business will achieve a food sales increase next year of 4 percent per month for each of the first six months of the year. She feels this increase will be the result of increases in guest counts (not . check averages) - At mid-year (July 1), Lakota intends to increase her menu prices and thus, her check average) by 2 percent. She feels that although these price increases could result in a slight, short-term reduction in her guest counts, the restaurant's guest counts will still increase 3 percent for the last six months of the year. 10 Taking into account her guest count growth estimates and mid-year price increases, Lakota would like to estimate her predicted year-end food revenues. Prepare the revenue estimates for Hall's House. 12 (Spreadsheet hint: Use the ROUNDDOWN function to zero decimal places in the Guest Count Forecast columns. Use the SUM function for the totals. 14 15 TE 20 15 Show all work to 2 decimals 12 Months January through June Hint: Guest counts should be whole numbers. Guest TE Count Guest Count Guest Original Last % Increase Count Check Revenue 21 Month Year Estimate Forecast Average Forecast 22 January 6.295 20 February 6.823 2 March 6,361 25 April 6,425 26 May 6,955 zr June 6,889 6-Month Total 39.748 29 20 Months July through December Guest 22 Count Guest Count Guest Original 33 Last % Increase Count Check Revenue 34 Month Year Estimate Forecast Average Forecast 3 July 6,883 30 August 6,468 37 September 6,321 3 October 6.440 39 November 6.976 40 December 7,166 41 6-Month Total 40,254 43 Home Insert Draw Page Layout Formulas Data Review View To AutoSum Recently Used 2 Logical A Text Define Name CB 13 Lookup & Reference O Math & Trig More Functions Insert Function Financial Date & Time EO Create from Selectio M23 x 0 2. Lakota Vela operates Hall's House, a mid-priced restaurant with a $30.00 check average. Her clientelo consists of business people and tourists visiting her city. Based on the historical sales records she keeps, Lakota believes her business will achieve a food sales increase next year of 4 percent per month for each of the first six months of the year. She feels this increase will be the result of increases in guest counts (not . check averages) - At mid-year (July 1), Lakota intends to increase her menu prices and thus, her check average) by 2 percent. She feels that although these price increases could result in a slight, short-term reduction in her guest counts, the restaurant's guest counts will still increase 3 percent for the last six months of the year. 10 Taking into account her guest count growth estimates and mid-year price increases, Lakota would like to estimate her predicted year-end food revenues. Prepare the revenue estimates for Hall's House. 12 (Spreadsheet hint: Use the ROUNDDOWN function to zero decimal places in the Guest Count Forecast columns. Use the SUM function for the totals. 14 15 TE 20 15 Show all work to 2 decimals 12 Months January through June Hint: Guest counts should be whole numbers. Guest TE Count Guest Count Guest Original Last % Increase Count Check Revenue 21 Month Year Estimate Forecast Average Forecast 22 January 6.295 20 February 6.823 2 March 6,361 25 April 6,425 26 May 6,955 zr June 6,889 6-Month Total 39.748 29 20 Months July through December Guest 22 Count Guest Count Guest Original 33 Last % Increase Count Check Revenue 34 Month Year Estimate Forecast Average Forecast 3 July 6,883 30 August 6,468 37 September 6,321 3 October 6.440 39 November 6.976 40 December 7,166 41 6-Month Total 40,254 43