ble Clipboard Font Algnment Number Styles A B G H Any Pelletier operates Hall's House, an upscale restaurant with a $30.00 check average in midtown Manhattan Her clientele consists of business persons and tourist visiting the city Based on the historical sales records she keeps, next year Amy believes her business will achieve a food sales increase of 4% per month for each of the first six months of the year. She feels this increase will be the result of increases in customer counts (not check averages) Help Amy forecast her customer count and revenue based + for the first six months of the year 2 Months January Through June Customer Count% Customer Original Count Last Increase Count Check Revenue Month Year Estimate Forecast Average Forecast 4 January 6,270 4% $30.00 5 February 6,798 4% $30.00 6 March 6,336 $30.00 7 April 6.400 4% $30.00 8 May 6.930 4% $30.00 June 6864 $30.00 6 month 10 total $30.00 11 Peste C BTU - 2-0A SE Merge Center - S - % Conditional fons Cell Formatting ble Syles Stiri Dute- Forma Fest Alignment hamber J M 11 At mid-year (July 1), Amy intends to increase her menu prices and thus her check average) by 2% She feels that while these price increases could result in a slight, short term reduction in her customer counts the restaurant's customer counts will still increase 3% for the last six months of the year Taking into account her customer count growth estimates and mid-year price increases, Any would like to estimate her predicted year 12 end food revenus Prepare the revenue estimates for Hal's House Months July Through December New Check customer Average Customer Count% Customer (Avg sales Count Last Increase Count Revenue Month Year Estimate Forecast customer Forecast 15 July 6,845 3% 16 August 5,430 17 September 6.283 3% valOctobes 6.402 3% 19 November 6938 20 December ZA128 6 month total 3% per 3 21 C200 NO . Type here to search O DOLL 24 Compile the following data for the entire year for Hall's House customer Count Revenue Forecast Forecast 12 month total Ch 01 DO Cho