Can you do this assignment

Chapter  9:  Budget  Assignment  2014                                  ACC  6107  

You have been asked to prepare the operating budget for a 150 room hotel, with a 50 seat Coffee Shop, a 100 seat Dining Room and a 25 seat Bar. The operating budget for the year is based on the following information: Hotel Rooms Department: Occupancy is expected to be 75% with an average room rate of $110.00. Fixed wages for the rooms’ department personnel are estimated @ $320,000. In addition, for every 18 rooms occupied each day, one housekeeper will be required for an 7.5 hour shift at a rate of $11.50 an hour. Staff fringe benefits are 13% of total wages. Linen and laundry costs are estimated @ 9% of total room sales revenue. Supplies and other items are estimated @5% of total room sales revenue. Food Department: The Dining Room is open 6 days a week, 52 weeks a year for lunch and dinner only. Lunch seat turnover is 1.5, with an average food cheque of $10.40. Dinner seat turnover is 1.3 with an average food cheque of $25.90. The Coffee Shop is open 7 days a week for all meal periods. Breakfast seat turnover is 1.8 with an average food cheque of $6.25. Lunch seat turnover is 1.4 with an average food cheque of $12.35. Dinner seat turnover is 1.1 with an average cheque of $16.10. In addition to these three meals, the coffee shop also serves coffee and snacks with a turnover of 3.0 @ an average cheque of $3.65. The Bar serves an estimated 25 food orders per day with an average cheque of $13.80. The bar is closed on Sundays and certain holidays, operating a total of 307 days out of the year. Total payroll costs, including fringe benefits for the food department are estimated @ 48% of total food sales revenues. Other variable costs represent the following % of total food sales revenue. • Food cost: 39% • Laundry and Linen: 4% • Supplies: 8% • Other Costs: 3%

Beverage Department: (307 operating days a year): Each seat in the bar is expected to generate $6,300 per year. In addition, the bar will be credited with any beverages served in the Coffee Shop and Dining Room. In the Coffee Shop, beverage sales revenue is estimated @ 15% of combined lunch and dinner food sales revenue, and in the Dining Room 25% of combined lunch and dinner food sales revenue. The beverage department operating costs are as follows:

• Liquor cost 35% of total beverage sales revenue. • Payroll and fringe benefits are 28% of total beverage sales revenue. • Supplies and other operating costs are 7% of total beverage sales revenue.

Chapter  9:  Budget  Assignment  2014                                  ACC  6107  

Undistributed (indirect) expenses:

Admin and general $357,600 Marketing 3% of total Revenues Utilities costs $185,300 Property operation & maintenance $225,900 Insurance $54,650 Property taxes $108,300

ROUND ALL FINAL NUMBERS TO THE NEAREST DOLLAR.

From the preceding information prepare a departmental budget for each of the three departments (Hotel Rooms, Food, and Beverage). Then consolidate the departmental budgets into a complete hotel operating budget. The end result should include 3 departmental budgeted income statements and 1 consolidated hotel budgeted income statement. Please show your work – you will be rewarded part marks even if you don’t have the correct answer.