Amy Pelletier operates House, se, an upse scal average in mid-town Manhattan. Her clientele consists of business persons tourists visiting the city. Based on the historical sales records she keeps, year Amy believes her business will achieve a food sales increase of 4 pe per month for each of the first six months of the year. She feels this incre will be the result of increases in guest counts (not check average). At mid-year (July 1), Amy intends to increase her menu prices (and thus, her check average) by 2 percent. She feels that while 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. Taking into account her guest count growth estimates and mid-year prices increases, Amy would like to estimate her predicted year-end food revenues. Prepare the revenue estimates for Hall's House. (Spreadsheet hint: Use the ROUND function to zero decimal places in the Guest Count Forecast columns, cells D5:D10 and D15:D20. Use the SUM function for the totals, cells D11 and D21. Otherwise, your answers will not be correct.) Months January Through June Guest Guest Count Guest Original Check Count % Increase Count Revenue Month Last Year Estimate Forecast Average Forecast January 6,270 February 6,798 March 6,336 April 6.400 May 4.930 6.864 June 6 Month Total
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps