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
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
Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Eugene F. Brigham, Phillip R. Daves
Chapter22: Providing And Obtaining Credit
Section: Chapter Questions
Problem 9MC: Now assume that it is several years later. The brothers are concerned about the firm’s current...
Related questions
Concept explainers
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.
Question
Transcribed Image Text:QQ!
Amy Pelletier operates Hall's House, an upscale restaurant with a $30.00 check
average in mid-town Manhattan. Her clientele consists of business persons
on
24
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 price
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
Increase
Count
Month
Last Year
Estimate
Forecast
Average
Forecast
6,270
February
6,798
March
6.336
April
6.400
674
June
6.864
& Morth Total
LAS
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning