Donaldson Bed and Breakfast has six available rooms to rent to tourists visiting Niagara Falls. Guests enjoy a comfortably appointed room with an attached bathroom and the owners provide a hearty breakfast each morning. The owners have calculated that their typical occupancy rate is 80% per month. The cost to rent each room is $65 per occupied room per day assuming a 30-day month. Some of this cost is fixed and some variable. During the month of June, the occupancy rate went down to 60% and the total cost to operate that month was $7, 650. Required: 1. Using the high-low method, estimate the variable and fixed cost elements of the bed and breakfast's operation in a typical month. Note: Do not round your intermediate calculations. Round the "Variable cost per room" to 2 decimal places. Average # room nights rented per month Total Monthly Cost High level of activity Low level of activity Change Variable cost per room Fixed cost per year 2. Express the variable and fixed costs in the form Y = a + bX. Note: Do not round your intermediate calculations. Round the "Variable cost per room" to 2 decimal places. 3. If the occupancy rate went up to 90% in a particular month, what total cost would you expect to be incurred that month? Note: Do not round intermediate calculations.
Donaldson Bed and Breakfast has six available rooms to rent to tourists visiting Niagara Falls. Guests enjoy a comfortably appointed room with an attached bathroom and the owners provide a hearty breakfast each morning. The owners have calculated that their typical occupancy rate is 80% per month. The cost to rent each room is $65 per occupied room per day assuming a 30-day month. Some of this cost is fixed and some variable. During the month of June, the occupancy rate went down to 60% and the total cost to operate that month was $7, 650. Required: 1. Using the high-low method, estimate the variable and fixed cost elements of the bed and breakfast's operation in a typical month. Note: Do not round your intermediate calculations. Round the "Variable cost per room" to 2 decimal places. Average # room nights rented per month Total Monthly Cost High level of activity Low level of activity Change Variable cost per room Fixed cost per year 2. Express the variable and fixed costs in the form Y = a + bX. Note: Do not round your intermediate calculations. Round the "Variable cost per room" to 2 decimal places. 3. If the occupancy rate went up to 90% in a particular month, what total cost would you expect to be incurred that month? Note: Do not round intermediate calculations.
Step by step
Solved in 3 steps
