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 2,640 2,860 980 2,420 2,090 4,470 4,020 3,940 1,630 1,090 1,390 2,910 Electrical Costs $ 13,200 $ 14,300 $ 4,900 $ 12,100 $ 10,450 $ 18,860 $ 17,160 $ 16,760 $8,150 $ 5,450 $ 6,950 $ 14,550

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 2,640 2,860 980 2,420 2,090 4,470 4,020 3,940 1,630 1,090 1,390 2,910 Electrical Costs $ 13,200 $ 14,300 $ 4,900 $ 12,100 $ 10,450 $ 18,860 $ 17,160 $ 16,760 $8,150 $ 5,450 $ 6,950 $ 14,550

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter1: Introduction To Managerial Accounting

Section: Chapter Questions

Problem 6BE: Jakes Cabins is a small motel chain with locations near the national parks of Utah, Wyoming, and...

See similar textbooks

Similar questions

The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hoteland the number of occupancy-days over the last year. An occupancy-day represents a room rented out for oneday. The hotel’s business is highly seasonal, with peaks occurring during the ski season and in the summer.Month Occupancy-Days Electrical CostsJanuary ..................... 1,736 $4,127February .................... 1,904 $4,207March ........................ 2,356 $5,083April ........................... 960 $2,857May ........................... 360 $1,871June .......................... 744 $2,696July ............................ 2,108 $4,670August ....................... 2,406 $5,148September ................ 840 $2,691October ..................... 124 $1,588November ................. 720 $2,454December ................. 1,364 $3,529Required:1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost ofelectricity per occupancy-day.…
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,250 $ 9,660 February 3,470 $ 10,185 March 3,660 $ 10,360 April 1,760 $ 6,160 May 1,350 $ 4,725 June 4,350 $ 11,575 July 3,280 $ 9,765 August 1,610 $ 5,635 September 700 $ 2,450 October 1,300 $ 4,550 November 1,640 $ 5,740 December 2,220 $ 7,770 Required: 1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. (Do not round your intermediate calculations. Round your Variable cost answer to 2 decimal places and Fixed cost element answer to nearest whole dollar amount.)
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,350 $ 9,241 February 3,610 $ 9,666 March 1,680 $ 5,208 April 1,230 $ 3,813 May 4,380 $ 10,428 June 1,690 $ 5,239 July 4,130 $ 10,058 August 4,250 $ 10,125 September 1,950 $ 6,045 October 2,140 $ 6,634 November 1,480 $ 4,588 December 2,710 $ 7,829 Required: 1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. (Do not round your intermediate calculations. Round your Variable cost answer to 2 decimal places and Fixed cost element answer to nearest whole dollar amount.) 2. What other factors in addition to…
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. . . . . . . . . . . . 1,736 $4,127 February . . . . . . . . . . . 1,904 $4,207 March . . . . . . . . . . . . . 2,356 $5,083 April . . . . . . . . . . . . . . 960 $2,857 May. . . . . . . . . . . . . . . 360 $1,871 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 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 . . . . . . . . 1,736 $4,127 February . . . . . . . 1,904 $4,207 March . . . . . . . . . 2,356 $5,083 April . . . . . . . . . . 960 $2,857 May . . . . . . . . . . . 360 $1,871 June . . . . . . . . . . 744 $2,696 July . . . . . . . . . . . 2,108 $4,670 August . . . . . . . . 2,406 $5,148 September . . . . . 840 $2,691 October . . . . . . . 124 $1,588 November . . . . . .…
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 2,710 $ 5,270 February 3,600 $ 6,205 March 860 $ 2,150 April 2,170 $ 4,350 May 4,200 $ 7,160 June 1,530 $ 3,825 July 4,110 $ 7,050 August 4,060 $ 6,925 September 1,980 $ 4,090 October 1,160 $ 2,900 November 1,210 $ 3,025 December 2,480 $ 4,910 Required: 1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. (Do not round your intermediate calculations. Round your Variable cost answer to 2 decimal places and Fixed cost element answer to nearest whole dollar amount.) What is the fixed cost of electricity per month?
The controller for Nina Group reviewed the following large transactions this month for the company: ● Purchase of a forklift to use in the warehouse: $32,000 (8-year life, depreciated on a straight-line basis, recorded monthly). ● Purchase of materials for use in the production of wheelbarrows (the company’s primary product): $114,000 (all was used in production this month, and all units produced were sold). ● Recognized payroll costs for this month’s production, office, and administrative employees: $45,000 (one-third for each category). ● Investment in mutual funds (with excess cash): $65,000. What dollar amount from these transactions would be recorded as an expense this month? What dollar amount would still be listed as an asset at the end of the month?
Kim Epson operates a full-service car wash, which operates from 8 a.m. to 8 p.m., 7 days a week. The car wash has two stations: an automatic washing and drying station and a manual interior cleaning station. The automatic washing and drying station can handle 30 cars per hour. The interior cleaning station can handle 200 cars per day. Based on a recent yearend review of operations, Kim estimates that future demand for the interior cleaning station for the 7 days of the week, expressed in average number of cars per day, would be as follows: Day Mon. Tues. Wed. Thurs. Fri. Sat. Sun. Cars 160 180 150 140 280 300 250 By installing additional equipment (at a cost of $50,000), Kim can increase the capacity of the interior cleaning station to 300 cars per day. Each car wash generates a pretax contribution of $4.00. Should Kim install the additional equipment if she expects a pretax payback period of three years or less?
Jake’s Roof Repair has provided the following data concerning its costs: Fixed Costper Month Cost perRepair-Hour Wages and salaries $ 21,200 $ 15.00 Parts and supplies $ 7.20 Equipment depreciation $ 2,740 $ 0.45 Truck operating expenses $ 5,710 $ 1.80 Rent $ 4,640 Administrative expenses $ 3,890 $ 0.60 For example, wages and salaries should be $21,200 plus $15.00 per repair-hour. The company expected to work 2,800 repair-hours in May, but actually worked 2,700 repair-hours. The company expects its sales to be $51.00 per repair-hour. Required: Compute the company’s activity variances for May. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
Following is information for the Rooms Department for the Ocean Front Hotel for the first six periods of the year. Room Revenue $8,713,000 Transient Rooms Sold 83,730 Group Rooms Sold 16,270 Total Rooms Sold 100,000 Operating Expenses Linen $31,100 Cleaning Supplies $24,000 Guest Supplies $104,800 Outside Services $24,000 Laundry $80,500 Concierge Expense $60,000 Office Supplies $19,200 Reservation Expenses Reservation Department $150,000 Fixed Res Center Cost $180,000 Variable Reser. Center Cost at $6 per transient res. $251,200 Total Reservation Expense $581,200 All other Expense $120,000 Total Operating Expenses $1,044,800 Total Operating Expense Percentage 12.0% Use the table above to answer Use the following formulas to calculate each one of the line items. They will be used to prepare the annual budget for next year. Round the average cost per period to whole dollars, round the cost per occupied room…
Following is information for the Rooms Department for the Ocean Front Hotel for the first six periods of the year. Room Revenue $8,713,000 Transient Rooms Sold 83,730 Group Rooms Sold 16,270 Total Rooms Sold 100,000 Operating Expenses Linen $31,100 Cleaning Supplies $24,000 Guest Supplies $104,800 Outside Services $24,000 Laundry $80,500 Concierge Expense $60,000 Office Supplies $19,200 Reservation Expenses Reservation Department $150,000 Fixed Res Center Cost $180,000 Variable Reser. Center Cost at $6 per transient res. $251,200 Total Reservation Expense $581,200 All other Expense $120,000 Total Operating Expenses $1,044,800 Total Operating Expense Percentage 12.0% Use the table above to answer Use the following formulas to calculate each one of the line items. They will be used to prepare the annual budget for next year. Round the average cost per period to whole dollars, round the cost per occupied room…
Following is information for the Rooms Department for the Ocean Front Hotel for the first six periods of the year. Room Revenue $8,713,000 Transient Rooms Sold 83,730 Group Rooms Sold 16,270 Total Rooms Sold 100,000 Operating Expenses Linen $31,100 Cleaning Supplies $24,000 Guest Supplies $104,800 Outside Services $24,000 Laundry $80,500 Concierge Expense $60,000 Office Supplies $19,200 Reservation Expenses Reservation Department $150,000 Fixed Res Center Cost $180,000 Variable Reser. Center Cost at $6 per transient res. $251,200 Total Reservation Expense $581,200 All other Expense $120,000 Total Operating Expenses $1,044,800 Total Operating Expense Percentage 12.0% Use the table above to answer Use the following formulas to calculate each one of the line items. They will be used to prepare the annual budget for next year. Round the average cost per period to whole dollars, round the cost per occupied room…