Question

In: Finance

Rooter's Cleaning Services provided data concerning the costs incurred to clean hotel rooms for which hotel...

Rooter's Cleaning Services provided data concerning the costs incurred to clean hotel rooms for which hotel customers pay $150 per night. Data for the past 7 months are as follows: January February March April May June July Number of rooms cleaned 250 160 200 150 300 170 260 Cleaning cost $6,450 $4,060 $5,100 $4,100 $6,760 $4,200 $6,530 How much are estimated monthly variable costs using the high-low method?

Solutions

Expert Solution

Ans. Months Variable cost
January (250*17.73) 4432.5
February (160*17.73) 2836.8
March (200*17.73) 3546
April (150*17.73) 2659.5
May (300*17.73) 5319
June (170*17.73) 3014.1
July (260*17.73) 4609.8
*Calculations:
   Number of Cleaning
Months rooms cleaned cost
January 250 6450
February 160 4060
March 200 5100
April 150 4100
May 300 6760
June 170 4200
July 260 6530
Variable cost per unit =   (Highest Total cost - Lowest total cost) / (Highest Units - Lowest units)
(6760 - 4100) / (300 - 150)
17.73333
*Highest units has the highest cost & Lowest units has the lowest cost (assumed).

jeff jeffy answered 3 years ago
Next > < Previous

Related Solutions

Cheap Stay Inc. is considering building a budget hotel that offers clean small rooms with bathrooms....
Cheap Stay Inc. is considering building a budget hotel that offers clean small rooms with bathrooms. They anticipate that the 120 rooms will rent for 36,000 room-nights per year. The market price for equivalent rooms is $60 per night. Cheap Stay estimates that the cost of capital will be $7,900,000 and they would like an annual return on 15%. Following are the estimated annual operating costs: Variable operating costs $18 per room night Fixed Costs: Salaries and wages $450,000 Building...
The Harriet Hotel in downtown Boston has 100 rooms that rent for $150 per night. It costs the hotel $30 per room in variable costs
In Crystal BallThe Harriet Hotel in downtown Boston has 100 rooms that rent for $150 per night. It costs the hotel $30 per room in variable costs (cleaning, bathroom items, etc.) each night a room is occupied. For each reservation accepted, there is a 5% chance that the guest will not arrive. If the hotel overbooks, it costs $200 to compensate guests whose reservations cannot be honored.How many reservations should the hotel accept if it wants to maximize the average...
Let's assume A Hotel has 900 rooms. The total fix costs for thehotel on any...
Let's assume A Hotel has 900 rooms. The total fix costs for the hotel on any given night are 22350.The variable costs per rooms is 43. assume the average daily rate for hotel last night is 90. How many room have been sold be break-even last night? What percent of occupancy should have made to be break-even last night?
Bennette Corporation has provided the following data concerning its overhead costs for the coming year:  ...
Bennette Corporation has provided the following data concerning its overhead costs for the coming year:     Wages and salaries $ 440,000 Depreciation   170,000 Rent   190,000 Total $ 800,000   The company has an activity-based costing system with the following three activity cost pools and estimated activity for the coming year: Activity Cost Pool Total Activity Assembly 30,000 labor-hours Order processing 550 orders Other Not applicable   The Other activity cost pool does not have a measure of...
On August 1, 2013, Bee Clean entered its second year of operations, providing cleaning services to...
On August 1, 2013, Bee Clean entered its second year of operations, providing cleaning services to community centres and sports, fitness and recreation arenas as well as doing small repairs (such as to ice). On July 31, 2014, Bee Cummins, the owner, finalized the company’s records, which showed the following items.   Accounts payable $ 11,000 Office equipment $ 20,800      Accounts receivable 58,000 Prepaid rent 5,600      Bee Cummins, capital, Rent expense 22,000         July 31, 2013* 80,900 Repair revenue...
Transaction Entries Thoro Clean, a firm providing house-cleaning services, began business on April 1. The following...
Transaction Entries Thoro Clean, a firm providing house-cleaning services, began business on April 1. The following accounts in its general ledger are needed to record the transactions for April: Cash; Accounts Receivable; Supplies; Prepaid Van Lease; Equipment; Accounts Payable; Notes Payable; Common Stock; Retained Earnings; Dividends; Cleaning Fees Earned; Wage Expense; Advertising Expense; and Fuel Expense. a. Using the accounting equation, record each of the transactions in columnar format. b. Use journal entries to record the following transactions for April...
All Clean of Alberta manufactures individual shampoos for hotel/motel clientele. The fixed manufacturing overhead costs for...
All Clean of Alberta manufactures individual shampoos for hotel/motel clientele. The fixed manufacturing overhead costs for 2019 will total $576,000. The company uses good units finished for fixed overhead allocation and anticipates 300,000 units of production. Good units finished on average 92 percent of total units produced. During January, 20,000 units were produced. Actual fixed overhead cost per good unit averaged $2.82 in January. Required (20 Points - Show formula and calculation for full points). A. Determine the fixed overhead...
An engineering company which uses job costing to attribute costs to individual products and services provided...
An engineering company which uses job costing to attribute costs to individual products and services provided to its customers has began the preparation of its fixed production overhead cost budget for 2017. Cost has been identified as follows: Machining Assembly Finishing Stores Maintenance K’000 K’000 K’000 K’000 K’000 Apportioned cost 6,000 2,500 1,500 1,000 800 The stores and maintenance departments are production department and provide services as follows: Machining Assembly Finishing Stores Maintenance Stores 40% 30% 20% - 10% Maintenance...
An engineering company which uses job costing to attribute costs to individual products and services provided...
An engineering company which uses job costing to attribute costs to individual products and services provided to its customers has began the preparation of its fixed production overhead cost budget for 2017. Cost has been identified as follows: Machining Assembly Finishing Stores Maintenance K’000 K’000 K’000 K’000 K’000 Apportioned cost 6,000 2,500 1,500 1,000 800 The stores and maintenance departments are production department and provide services as follows: Machining Assembly Finishing Stores Maintenance Stores 40% 30% 20% - 10% Maintenance...
1. Jake’s Roof Repair has provided the following data concerning its costs: Fixed Cost per Month...
1. Jake’s Roof Repair has provided the following data concerning its costs: Fixed Cost per Month Cost per Repair-Hour Wages and salaries $ 21,000 $ 15.00 Parts and supplies $ 7.60 Equipment depreciation $ 2,710 $ 0.50 Truck operating expenses $ 5,750 $ 1.80 Rent $ 4,680 Administrative expenses $ 3,860 $ 0.70 For example, wages and salaries should be $21,000 plus $15.00 per repair-hour. The company expected to work 2,600 repair-hours in May, but actually worked 2,500 repair-hours. The...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT