Q 1. Bring up the income statement for Barnaby’s Hideaway on your Excel spreadsheet
(provided). The following changes are anticipated in the coming year:
1. Both food and beverage sales are expected to increase by 5 percent.
2. Food and beverage cost percentages will remain the same.
3. Salaries and wages will increase by 4 percent.
4. The cost of employee benefits will increase, but will continue to be the same percentage of
salaries and wages.
5. Other controllable costs will increase by $6,500.
6. Occupancy costs will increase by $2,000.
7. Interest and depreciation will remain the same.
Prepare a budget for Barnaby’s Hideaway for the coming year, using Figure 2.3 in the text as a
model for your budget.
- JudyLv 74 weeks ago
you sure do need help