Prepare an operations budget for the Mica Motel with the given information

Chapter 10 problem 10 Prepare an operations budget for The Mica Motel with the given information. The Mica Motel opens 365 days a year. It is an 100-room motel with a 50-seat coffee shop. Of the 100 rooms, 70 are doubles and 30 are singles. The doubles are sold at $100 each night and the singles are sold at $80 each night. Forecasted occupancy is 70% for doubles and 60% for singles. The average occupancy per room is 1.6 (only one person stays in a single but two or more may stay in a double for $100ight). 40% of those staying in the singles and 20% of those staying in the doubles eat breakfast in the coffee shop. Assume there is no walk-in business for breakfast. The average check is $4.80. The lunch and dinner business have seat turnovers and average check as follows: Mon-Fri Sat Lunch Turnover 1.25 0.5 1.5 Average Check $6.00 $6.50 $7.00 Dinner Turnover 1.0 1.0 0.5 Average Check $10.75 $12.50 $11.25 Sun The first day of the year for which you are to prepare the budget is Monday. The food cost is 35%. The labor cost is 20% for rooms and 32% for coffee shop. Other direct expenses are 10% for rooms and 12% for coffee shop. Undistributed operating expenses include $100,000 of fixed expenses and the remainder is 10% of total revenue. Other fixed costs include Property Taxes $30,000, Depreciation $60,000, and Interest $50,000. The motel's average income tax rate is 30% of income before income taxes. Use 53 Mondays and 52 Tuesdays to Sundays for the year. Round all numbers to the nearest 1