Sunset Beach Resort provides the following data on cleaning costs and the number of occupied rooms for the past four months: Month Occupied Rooms Cleaning Costs January 1,250 $28,750 February 1,450 $32,150 March 1,850 $38,950 April 2,100 $43,200 Use the high-low method to estimate the fixed cost of cleaning per month and the variable cost of cleaning per occupied room.

Sunset Beach Resort provides the following data on cleaning costs and the number of occupied rooms for the past four months: Month Occupied Rooms Cleaning Costs January 1,250 $28,750 February 1,450 $32,150 March 1,850 $38,950 April 2,100 $43,200 Use the high-low method to estimate the fixed cost of cleaning per month and the variable cost of cleaning per occupied room.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter7: Linear Regression

Section: Chapter Questions

Problem 13P: Johnson Filtration. Inc., provides maintenance service for water filtration systems throughout...

See similar textbooks

Similar questions

Johnson Filtration. Inc., provides maintenance service for water filtration systems throughout southern Florida. Customers contact Johnson with requests for maintenance service on their water filtration systems. To estimate the service time and the service cost. Johnson’s managers want to predict the repair time necessary for each maintenance request. Hence, repair time in hours is the dependent variable. Repair time is believed to be related to three factors: the number of months since the last maintenance service, the type of repair problem (mechanical or electrical), and the repairperson who performs the repair (Donna Newton or Bob Jones). Data for a sample of 10 service calls are reported in the following table: Develop the simple linear regression equation to predict repair time given the number of months since the last maintenance service, and use the results to test the hypothesis that no relationship exists between repair time and the number of months since the last maintenance service at the 0.05 level of significance. What is the interpretation of this relationship? What does the coefficient of determination tell you about this model? Using the simple linear regression model developed in part (a), calculate the predicted repair time and residual for each of the 10 repairs in the data. Sort the data in ascending order by value of the residual. Do you see any pattern in the residuals for the two types of repair? Do you see any pattern in the residuals for the two repairpersons? Do these results suggest any potential modifications to your simple linear regression model? Now create a scatter chart with months since last service on the x-axis and repair time in hours on the y-axis for which the points representing electrical and mechanical repairs are shown in different shapes and/or colors. Create a similar scatter chart of months since last service and repair time in hours for which the points representing repairs by Bob Jones and Donna Newton are shown in different shapes and/or colors. Do these charts and the results of your residual analysis suggest the same potential modifications to your simple linear regression model? Create a new dummy variable that is equal to zero if the type of repair is mechanical and one if the type of repair is electrical. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the type of repair. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Create a new dummy variable that is equal to zero if the repairperson is Bob Jones and one if the repairperson is Donna Newton. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the repairperson. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service, the type of repair, and the repairperson. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Which of these models would you use? Why?
The expected costs for the Maintenance Department of Stazler, Inc., for the coming year include: Fixed costs (salaries, tools): 64,900 per year Variable costs (supplies): 1.35 per maintenance hour Estimated usage by: Actual usage by: Required: 1. Calculate a single charging rate for the Maintenance Department. 2. Use this rate to assign the costs of the Maintenance Department to the user departments based on actual usage. Calculate the total amount charged for maintenance for the year. 3. What if the Assembly Department used 4,000 maintenance hours in the year? How much would have been charged out to the three departments?
Haysbert Company provides management services for apartments and rental units. In general, Haysbert packages its services into two groups: basic and complete. The basic package includes advertising vacant units, showing potential renters through them, and collecting monthly rent and remitting it to the owner. The complete package adds maintenance of units and bookkeeping to the basic package. Packages are priced on a per-rental unit basis. Actual results from last year are as follows: Haysbert had budgeted the following amounts: Required: 1. Calculate the contribution margin variance. 2. Calculate the contribution margin volume variance. 3. Calculate the sales mix variance.
Assume a hotel rented 400, 480, and 420 rooms in the months of April, May, andJune, respectively; and the total housekeeping costs for the three months in question were $6,000, $6,800, and $6,200. With use of the high-low method, what is theamount of monthly fixed housekeeping costs?a. $1,000b. $1,500c. $2,000d. $2,500
Hapza cleaning services has opening hours that fluctuate from month to month. The electricity costs and hours of operation for past six months is listed below: Month Total hours of operation Total electricity cost January 650 $ 4 240 February 700 $ 4 400 March 800 $ 4 800 April 600 $ 4 200 May 550 $ 3 700 June 500 $ 3 600 Required: (a) Use the high-low method to estimate the cost behaviour for the complex’s electricity costs, assuming that the variable costs vary in proportion to the hours of operation. Express the total cost behaviour in formula form (Y = a + bx). What is the variable electricity cost per hour of operation? (b) During July, the complex will open for 570 hours. Predict the complex’s total electricity costs for July using the cost estimation method employed in above requirement (a). (c) What is the main drawback of the high-low method of cost estimation?
Please give me answer the question
The graph below shows monthly data collected on facilities maintenance department costs and on the number of patient-days serviced over the past year. 50, 000 45,000 UneofBest FIE 40,000 35 000 30,000 25, 000 20,000 15,000 10,000 5000 1,000 2000 3.000 4,000 5,000 6,000 s of Patient-Days Using 0 and 3,000 patient-days, the total cost at an activity level of 8,000 customer patient-days would be: O a. $91,000 O b. $66,860 Oc. $63,360 O d. $55,000 Maintenance Department Costs
The following information is available for a company's utility cost for operating its machines over the last four months. Month Machine hours Utility cost January 900 $ 5,450 February 1,800 $ 6,900 March 2,400 $ 8,100 April 600 $ 3,600 Using the high-low method, the estimated variable cost per machine hour for utilities is:
ake's Roof Repair has provided the following data concerning its costs: Fixed Cost per Month Cost per Repair-Hour $ 21,300 $ 16.00 $ 7.00 $ 0.50 $ 1.50 Wages and salaries Parts and supplies Equipment depreciation $ 2,770 Truck operating expenses $5,780 $ 4,630 Administrative expenses $3,820 $ 0.80 For example, wages and salaries should be $21,300 plus $16.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 $46.00 per repair-hour. Required: Compute the company's activity variances for May. Note: 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. Rent
Jake's Roof Repair has provided the following data concerning its costs: Fixed Cost Cost per per Month $ 20,800 Wages and salaries Parts and supplies Equipment depreciation Truck operating expenses Repair-Hour $ 15.00 $ 7.60 $ 0.45 $ 1.80 $ 2,770 $ 5,730 $ 4,610 $ 3,880 Rent Administrative expenses $ 0.60 For example, wages and salaries should be $20,800 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 company expects its sales to be $49.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.) Jake's Roof Repair Activity Variances For the Month Ended May 31 < Prev 4 of 4 Next ...... .....
A wholesaler of custom-built air-conditioning units for commercial buildings gathered the following monthly data relating to units shipped and total shipping expense: Units shipped Total shipping expense $2,000 $2,500 $1,900 $2,200 $2,500 $3,030 $1,950 Month 2. January February March 3. April May June 4. 7. July 3 Using the high-low method estimate the cost formula for shipping expenses, calculate the variable shipping expense as well as fixed shipping expense per unit. %24 (All answers are whole numbers - unless specified otherwise. You should NOT include the $ sign or a comma. E.g., you should type 1000 for one thousand. Negative numbers should be added with a minus sign, e.g, -1000 for a decrease or loss of one thousand.) Variable shipping expense = $ per unit. Fixed shipping expense = $ per unit.
Jake's Roof Repair has provided the following data concerning its costs: Fixed Cost Cost per per Month Repair-Hour Wages and salaries Parts and supplies $ 21,400 $ 15.00 $ 7.20 Equipment depreciation $ 2,740 $ 0.55 Truck operating expenses Rent $ 5,720 $ 1.70 $ 4,660 $ 3,880 $ 0.70 Administrative expenses For example, wages and salaries should be $21,400 plus $15.00 per repair-hour. The company expected to work 2,700 repair-hours in May, but actually worked 2,600 repair-hours. The company expects its sales to be $47.00 per repair-hour. Required: Compute the company's activity variances for May. Note: 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. Revenue Expenses: Jake's Roof Repair Activity Variances For the Month Ended May 31 Wages and salaries Parts and supplies Equipment depreciation Truck operating expenses Rent Administrative expenses Total expense Net…