Great Eastern Inns has a total of 1,200 rooms in its chain of motels located in eastern Canada. On average, 65% of the rooms are occupied each day. The company’s operating costs are $20 per occupied room per day at this occupancy level, assuming a 30-day month. This $20 figure contains both variable and fixed cost elements. During February, the occupancy rate dropped to only 45%. A total of $399,600 in operating cost was incurred during February.
OCCCUPANCY RATE | Rooms Occupied | Total Cost | ||
High LEVEL | 65% | 780 | 468,000 | |
Low Level | 45% | 540 | 399,600 | |
Change | 240 | 68,400 | ||
Change per unit (Variable cost) = Change in total cost / Change in Units Sold | ||||
=68400 / 240 | ||||
Variable cost | 285 | per room per day | ||
Fixed Cost calculation | ||||
Variable Cost + Fixed cost = Total cost | ||||
285 * 780 + Fixed Cost = 468000 | ||||
Fixed op. Cost | Fixed Operating Cost = 245700 | |||
3) | If occupancy rate 60% | |||
Rooms Occupied | 720 | |||
Variable cost-total | 205,200 | |||
Fixed cost | 245,700 | |||
Total expected cost | 450,900 | |||
Great Eastern Inns has a total of 1,200 rooms in its chain of motels located in...
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer Month January February March April May June July August September October November December Occupancy-Days 3,240 3.060 1,150 2.260 4,310 1,270 3.410 640 1.310 3,760 1.330 2,570 Electrical...
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month January February March April May June July August September October November December Occupancy-Days 3,000 850 4,430 1,470 3,650 1,120 3,910 3,840 1,900 1,090 2,040 2,990 Electrical...
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month January February March April May June July August September October November December Occupancy-Days 4,260 3,650 3,160 2,150 2.260 1,450 3,180 3,750 2,220 1,580 1,690 2,750 Electrical...
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month January February March April May June Occupancy-Days 3,300 2,960 3,550 1,600 1,370 1,350 3,490 3,750 1,390 1,060 1,520 2,900 Electrical Costs $ 8,024 $ 7,767 $...
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month January February March April May June July August September October November December Occupancy-Days 3,290 3,160 1,800 4,430 970 1,650 4,150 4,160 2,050 1,110 780 2,810 Electrical...
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented out for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy- Days Electrical Costs January 3,180 $ 6,510 February 2,920 $ 6,261 March 3,780 $ 7,392 April 2,160 $ 5,569...
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month January February March April May June July August September October November December Occupancy-Days Electrical Costs 2,710 $ 5,270 3,600 $ 6,205 860 $ 2,150 2,170 $...
Prepare the pro forma income statement for a two-department company A hotel operation has 120 rooms and a 100-seat restaurant. Please prepare a pro forma income statement for the next year to determine the forecasted net income. Rooms department: In the previous year of operations the occupancy rate was 70% and the average room rate was $48. The GM is forecasting the occupancy rate to increase by 5% and the average room rate is to be increased by $4. Cost...
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented out for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy- Days Electrical Costs January 3,030 $ 9,044 February 3,080 $ 9,234 March 3,980 $ 11,913 April 1,630 $ 6,194 May 1,270 $ 4,826 June...
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel’s business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy-Days Electrical Costs January 3,000 $ 15,000 February 850 $ 4,250 March 4,430 $ 18,570 April 1,470 $ 7,350 May 3,650 $ 18,250 June 1,120 $...