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 270 170 260 Cleaning cost $6,450 $4,060 $5,100 $4,100 $6,880 $4,200 $6,530 How much are estimated monthly variable costs using the high-low method? Round to two decimal places.
Q: During a recent month, Cleveland Company planned to provide cleaning services to 30 customers for…
A: Accounting: Accounting is a system, or a process of collecting and organizing economic…
Q: The desired profit margin per hour is $27. The material loading charge is 60% of invoice cost.…
A: Hourly rate computation :- ( Total cost / Total available hour ) * Hour for manufacturing one unit…
Q: The following are the Maintenance Costs incurred in a Machine Shop for six months with corresponding…
A: A high low method is used to separate the mixed cost into fixed cost and variable cost. In this…
Q: Bill owns a machine shop. In reviewing the shop's utility bills for the past 12 months, he found…
A:
Q: The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the…
A: High low method is used to calculate the variable cost per unit. Using this method the total…
Q: Dew Drop Inn, Inc., has direct labor costs of $13 per hour, direct materials are $1 per room and…
A: The total cost consists of all the outlay made by a firm for making its business activities…
Q: Jake's Roof Repair has provided the following data concerning its costs: Fixed Cost Cost per…
A: Solution Costing is any system for assigning cost to an element of a business. It is an estimate of…
Q: The ACC Tutoring Service provides tutoring to accounting students. The volume of tutoring is low at…
A: Fixed cost: Fixed cost refers to those costs that will incur irrespective of the production process.…
Q: In the month of June, Jose Hebert's Beauty Salon gave 3,800 haircuts, shampoos, and permanents at an…
A: The contribution margin is calculated by deducting the variable cost from the sales revenues of the…
Q: During a recent month, Cleveland Company planned to provide cleaning services to 30 customers for…
A: Budgeted revenue = Budgeted no. of customers x budgeted hours per job x rate per hour = 30*3*25 =…
Q: Gia foods produce frozen meal, which it sellls fro $8 each. the company computes a new monthly fixed…
A: Sales revenue: It is the revenue earned by a business on selling the goods or providing services to…
Q: Western Trucking operates a fleet of delivery trucks. The fixed expenses to operate the fleet are…
A: Total variable cost = 92,097 miles x $0.49 per mile = $45,127.53
Q: Gia's Foods produces frozen meals, which it sells for $8 each. The company computes a new monthly…
A: Variable costing: Under the variable costing only the variable manufacturing costs like direct…
Q: The following data relate to a company that produces and sells a travel guide that is updated…
A: Contribution margin ratio is the ratio of contribution per unit to sales per unit. It can be…
Q: Gia’s Foods produces frozen meals, which it sells for $8 each. The company computes a new monthly…
A: Definition: Variable costing income statement is referred to as the statement which is used to…
Q: Global Publishers has collected the following data for recent months: Month…
A: Fixed cast, as the name suggests are the cost that are fixed irrespective of the production or no of…
Q: Gia's Foods produces frozen meals, which it sells for $8 each. The company computes a new monthly…
A: Solution:- i)a Computation of the product cost per meal produced under absorption costing as follows…
Q: Marwick’s Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,499 per…
A: 1. Prepare a traditional format income statement for August as shown below:
Q: Required: Using the high-low method, estimate the fixed cost of electricity per month and the…
A: The accumulated records of the total electrical costs of the hotel and the number of occupancy-days…
Q: Jake's Roof Repair has provided the following data concerning its costs: Fixed Cost Cost per…
A: Activity variance: Under the activity variance we subtract actual results from the flexible budget.…
Q: During a recent month, Cantho Company planned to provide cleaning services to 30 customers for $26…
A: Revenues are estimated on the basis of past experiences and therefore it is planned what the price…
Q: Gulf Shore Lawn and Garden Maintenance provides two general outdoor services: lawn maintenance and…
A: Break-even Sales: It is that point of sales at which a total of fixed and variable expenses are…
Q: National Investor Group is opening an office in Portland, Oregon. Fixed monthly costs are office…
A: Break even sales = Total Fixed CostsProfit Volume Ratio Profit Volume Ratio = ContributionSalesx 100…
Q: In the month of June, Jose Hebert's Beauty Salon gave 3,800 haircuts, shampoos, and permanents at an…
A: Formula used: Contribution margin = Contribution margin per unit x Number of Haircuts
Q: A wholesaler of custom-built air-conditioning units for commercial buildings gathered the following…
A: The high low method of estimating costs dictates that the difference between the cost at the highest…
Q: Repair Shop Co. provides electronic repairs and has the following budget for next year: Repair…
A: The time rate is calculated on the basis of the number of hours used for repairs. Loading charge is…
Q: The output and production cost of a computer manufacturer for the last four months are as follows:…
A: Here in this question, we are required to calculate variable cost and fixed cost per unit for high…
Q: The manager of Trusty Car Inspection reviewed the monthly operating costs for the past year. The…
A: Cost accounting is useful since it can show where a company spends money, how much it generates, and…
Q: The data below relates to SunRise for January and February of the current year.…
A: Computation of variable cost is as follows: High low method =Maintenance cost at high no. of units/…
Q: Hapza cleaning services has opening hours that fluctuate from month to month. The electricity costs…
A: A high low method of cost estimation is used to calculate the variable cost and fixed cost of the…
Q: The following information is available about electricity costs for the first six months of the year.…
A: Solution... Highest point = 6,200 machine hours Total cost = $5,980 Lowest point = 2,300…
Q: The following information is available about electricity costs for the first six months of the year.…
A: High low method Formula: Variable cost per unit = (Highest activity cost - Lowest activity cost) /…
Q: Mountain Dental Services is a specialized dental practice whose only service is filling cavities.…
A:
Q: Mountain Dental Services is a specialized dental practice whose only service is filling cavities.…
A: High-low method is used in costing to segregate fixed and variable costs. Following formula is used…
Q: The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the…
A: High activity level is on month of June. occupancy days. Electrical costs 4,350.…
Q: The following information is available for a company's utility cost for operating its machines over…
A: High-low method: In the high-low method, the semi variable-cost approximation is calculated by using…
Q: Prepare a production budget for January and February Prepare a purchases budget in units for…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: Based on the following information, calculate fixed costs per month using the high-low method. …
A: To compute variable cost.
Q: Western Trucking operates a fieet of delivery trucks. The fixed expenses to operate the fleet are…
A: Total Cost = Fixed Cost + Variable Cost Variable Cost = Total Miles Driven * Variable Cost Per Mile…
Q: Gia's Foods produces frozen meals, which it sells for $8 each. The company computes a new monthly…
A: Variable costing: Under variable costing, the variable costs are assigned at unit level and all…
Q: Western Trucking operates a fleet of delivery trucks. The fixed expenses to operate the fleet are…
A: Operating costing is a system of determining costs based on providing a service. The concept is…
Q: During August, Marwick’s Pianos, Inc., sold and delivered 56 pianos. Required: 1. Prepare a…
A: Income Statement of business shows all revenues and expenses of the business for the particular…
Q: The manager of Trusty Car Inspection reviewed the monthly operating costs for the past year. The…
A: The high-Low level method is a technique to calculate fixed cost and Variable cost with the limited…
Q: Janice Huffman has decided to start Finch Cleaning, a residential housecleaning service company. She…
A: d. Number of houses cleaned 15 25 35 The total expected cost of equipment rental 700 700 700…
Q: Peter Ltd manufactures and sells batteries. The cost data for the product are given below. The…
A: Variable cost is the cost accounting technique wherein all the variable production costs are only…
Q: Zerbel Company, a wholesaler of large, custom-built air conditioning units for commercial buildings,…
A:
Q: The following information is available about electricity costs for the first six months of the year.…
A: High low method: Variable cost per unit = (Highest activity cost - Lowest activity cost) / (Highest…
Q: The chief executive of Dabid's salon is interested in accumulating some information on the overhead…
A: Variable cost means the cost which vary with the level of output and fixed cost means the cost which…
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 | 270 | 170 | 260 |
| Cleaning cost | $6,450 | $4,060 | $5,100 | $4,100 | $6,880 | $4,200 | $6,530 |
How much are estimated monthly variable costs using the high-low method?
Round to two decimal places.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- The accounting department of a large limousine company is analyzing the costs of its services. The cost data and level of activity for the past 16 months follow. Month Special Analyses CustomerAccounts PaychecksProcessed AccountingService Costs 1 1 190 1,100 $ 58,800 2 1 260 1,010 61,600 3 2 270 1,170 59,200 4 2 250 920 59,100 5 3 160 1,280 60,600 6 2 170 1,180 61,900 7 1 340 830 59,000 8 4 220 1,220 61,400 9 3 150 1,210 61,300 10 1 230 1,270 60,100 11 2 220 1,130 60,200 12 2 300 930 61,200 13 3 190 1,010 59,700 14 3 290 1,120 60,700 15 4 300 910 60,500 16 2 180 980 60,200 Totals 36 3,720 17,270 $ 965,500 In addition to the above information, you learn that the accounting department had the following total…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…The accounting department of a large limousine company is analyzing the costs of its services. The cost data and level of activity for the past 16 months follow. Month Special Analyses CustomerAccounts PaychecksProcessed AccountingService Costs 1 2 325 1,029 $ 63,800 2 4 310 993 68,900 3 2 302 1,268 64,000 4 1 213 1,028 61,300 5 2 222 984 61,600 6 0 214 712 50,800 7 1 131 762 51,020 8 1 123 739 54,300 9 0 115 708 50,500 10 2 296 1,232 64,800 11 2 213 978 58,000 12 1 222 929 57,500 13 2 217 1,059 62,200 14 2 132 942 54,900 15 4 300 1,299 71,530 16 4 315 1,283 64,800 Totals 30 3,650 15,945 $ 959,950 In…
- 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…
- 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…The following information shows the occupancy days and electrical costs of of hotel 'Violet sky'. Hotel business is highly seasonal. The Occupancy Days and Electrical costs are as follows: Month Guest Occupancy Days Maintenance costs January 11,736 $40,127 February 11,904 $40,207 March 12,356 $50,083 April 1,960 $20,857 May 1,360 $10,871 June 1,744 $20,696 July 2,108 $40,670 August 12,406 $ 50,148 September 1,840 $ 20,691 October 1,124 $ 10,588 November 1,720 $ 20,454 Decemeber 11,364 $ 30,529 Requirement: (a)Using high -low method formulate y=a +bx (b) What would 31000 Guest occupancy days will cost for maintenance of the hotel? [marks
- Lea Ray is the revenue manager at the 200-room Hilton Garden Inn. She tracks her occupancy and ADR on a daily basis. The following data represent her hotel's Thursday night performance for the past seven weeks. Thursday Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Occ. % 69.5 73.5 66.5 72.0 72.5 69.0 77.0 ADR $151.50 $145.95 $161.50 $178.50 $179.95 $129.95 $159.95 Using that historical data, calculate her Occupancy %, ADR, and RevPAR for these trailing periods:Jake's Roof Repair has provided the following data concerning its costs: Fixed Cost per Month $21,000 Cost per Repair-Hour $15.00 $7.50 $ 0.35 $ 1.70 $ 0.70 Wages and salaries Parts and supplies Equipment depreciation Truck operating expenses Rent Administrative expenses For example, wages and salaries should be $21,000 plus $15.00 per repair-hour. The company expected to work 2,900 repair-hours in May, but actually worked 2,800 repair-hours. The company expects its sales to be $51.00 per repair-hour Revenue Expenses $ 2,710 $ 5,740 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 (.e., zero variance). Input all amounts as positive values.) $ 4,620 $ 3,820 Wages and salaries Parts and supplies Equipment depreciation Truck operating expenses Rent Jake's Roof Repair Activity Variances For the Month Ended May 31 Administrative expenses Total expense Net operating…The ABD Hotel's guest-days ofoccupancy and custodial supplies expense over the last seven |months were: Custodial Guest Days Supplies Month Expense 375,000 Оссирancy 4,000 6,500 8,000 10,500 March April May June July August September 412,500 525,000 600,000 675,000 537,500 487,500 12,000 9,000 7,500 Guest-days is a measure of the overall activity at the hotel. For example, a guest who stays at the hotel for three days is counted as three guest-days. Required: Using the high-low method, estimate a cost formula for custodial supplies expense. Using the cost formula you derived above, what amount of custodial supplies would you expect to be incurred at an occupancy level of 11,000 guest-days? 2