Star Limited, a management consultancy firm, has operating hours fluctuate from week to week. Its utilities costs and operating hours for the past six weeks are as follow: Week Operating Hours Utilities Cost ($) 1 42 630 2 55 705 3 37 427 33 485 5 39 552 41 637 Required: a) Use the high-low method to estimate the cost behaviour for the company's utilities costs, assuming that variable costs vary in proportion to the hours of operation. Express the cost behaviour in a cost function (Y = a + bX). b) Star Limited is expected to be operated for 45 hours in next week. Predict the company's total utilities cost for the week

Star Limited, a management consultancy firm, has operating hours fluctuate from week to week. Its utilities costs and operating hours for the past six weeks are as follow: Week Operating Hours Utilities Cost ($) 1 42 630 2 55 705 3 37 427 33 485 5 39 552 41 637 Required: a) Use the high-low method to estimate the cost behaviour for the company's utilities costs, assuming that variable costs vary in proportion to the hours of operation. Express the cost behaviour in a cost function (Y = a + bX). b) Star Limited is expected to be operated for 45 hours in next week. Predict the company's total utilities cost for the week

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Data table Month Total Cost Machine Hours January.. 3,420 1,090 February..... S 3,760 1,120 March .... $ 3,532 1,080 April ..... 3,720 1,220 May S 4,800 1,330 June 4,192 1,480 .. %24 %24
1) Barkoff Enterprises, which uses the high-low method to analyze cost behavior, has determined that machine hours best explain the company's utilities cost. The company relevant range of activity varies from a low of 600 machine hours to a high of 1,100 machine hours, with the following data being available for the first six months of the year: Month January February March Utilities $ 8,700 8,360 8,950 9,360 9,625 Machine Hours 800 720 S10 April May 920 950 June 9,150 900 The fixed utilities cost per month for Barkoff is: A) $4,400. B) $5,100. 9 $4,760. D) $3,764. E) None of the answers is correct.
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs = +xBillable Hours X Monthly Overhead Costs and Billable Hours Data (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) Overhead Costs Billable Hours 0 $315,000 3,000 $365,000 4,000 $395,000 5,000 $447,000 6,000 $530,000 7,000 $550,000 8,000
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs +(9) x Billable Hours (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) X Monthly Overhead Costs and Billable Hours Data Overhead Costs Billable Hours $315,000 3,000 $360,000 4,000 $385,000 5,000 $438,000 6,000 $520,000 7,000 $540,000 8,000 D Print Done
The controller of Hall Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Month TotalMaintenance Costs TotalMachine Hours January $2,817 3,734 February 3,201 4,268 March 3,841 6,402 April 4,801 8,429 May 3,414 5,335 June 4,930 8,536 Determine the variable-cost components using the high-low method. (Round variable cost to 2 decimal places e.g. 12.25.) Variable cost per machine hour $ eTextbook and Media Determine the fixed cost components using the high-low method. (Round answer to 0 decimal places e.g. 2,520.) Fixed costs $
1.Using the high-low method of analyzing costs, answer the following questions and show computations to support your answers. a. What is the estimated variable portion of maintenance costs per labor hour? 2.What is the estimated fixed maintenance cost each month? 3.Formulate the regression equation 4.If it is estimated that 600 labor hours will be used in July, what is the expected total power cost for July? 5.Using the least-squares method of analyzing costs, answer the following questions and show computations to support your answers. a. What is the estimated variable portion of maintenance costs per labor hour? 5a. What is the estimated fixed maintenance cost each month? 5b.Formulate the regression equation 5c.If it is estimated that 600 labor hours will be used in July, what is the expected total power cost for July?
XYZ Company's accountant is estimating next period's total overhead costs (Y). She performed three regression analyses, the first is based on direct labor hours (DLH), the second is based on machine hours (Mhr), and the third is based on quantity produced (Q). The results were: [Y=$95,000+ $9×DLH; R-square Y=190,000+2Q; R-square-D0.55]. How much of the variations on the overhead costs is explained 0.90]; [Y= $120,000 $5xMhr; R-square = 0.10]; by the machine hours (Mhr)? Select one: O a. 90% Ob. None of the answers given Oc.45% O6.55% Oe. 10% Next page page
The controller of Sunland Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Month TotalMaintenance Costs TotalMachine Hours January $2,590 330 February 2,890 380 March 3,490 530 April 4,390 660 May 3,090 530 June 5,470 730 Determine the variable cost components using the high-low method. (Round answer to 2 decimal places e.g. 2.25.) Variable cost per machine hour $enter the variable cost per machine hour in dollars rounded to 2 decimal places Determine the fixed cost components using the high-low method. Total fixed costs $enter the total fixed costs in dollars
Barkoff Enterprises, which uses the high-low method to analyze cost behavior, has determined that machine hours best explain the company's utilities cost. The company's relevant range of activity varies from a low of 600 machine hours to a high of 1,100 machine hours, with the following data being available for the first six months of the year: Month Utilities Machine Hours January $8,700 800 February 8,360 720 March 8,950 810 April 9,360 920 May 9,625 950 June 9,150 900 The variable utilities cost per machine hour for Barkoff is: Select one: a. $5.00. b. $4.50. c. $0.18 d. $5.50.e. None of the answers is correct.
Hot'lanta, Inc., which uses the high-low method to analyze cost behavior, has determined that machine hours best explain the company's utilities cost. The company's relevant range of activity varies from a low of 600 machine hours to a high of 1,100 machine hours, with the following data being available for the first six months of the year: Month Utilities Machine Hours January $8700 800 February 8360 720 March 8950 810 April 9360 920 May 9625 950 June 9150 900 1The variable utilities cost per machine hour is: a) $0.18. b) an amount other than those listed above. ) $4.50. d) $5.00. e) $5.50. 2. The fixed utilities cost per month is: a) an amount other than those listed above. b) $4,760. ) $3,764. d) $5,100. e) $4,400. 3. Using the high-low method, the utilities cost associated with 980 machine hours would be: a) an amount other than those listed above. b) $9,660. ) $9,700. d) $9,790. e) $9,510.
The following information is available for a company's maintenance cost over the last seven months. Month June July August September October November December Units Produced 90 180 120 150 210 240 60 Using the high-low method, estimate both the fixed and variable components of its maintenance cost. Change in cost Change in volume Total cost at the high point Variable costs at the high point: Volume at the high point: Variable cost per unit produced Total variable costs at the high point Total fixed costs Maintenance Cost $ 4,190 6,260 4,880 5,570 6,950 7,640 3,500 Total cost at the low point Variable costs at the low point: Volume at the low point: Variable cost per unit produced Total variable costs at the low point Total fixed costs High-Low method - Calculation of variable cost per unit produced Cost at high point minus cost at low point Volume at high point minus volume at low point
11) Barkoff Enterpeises, which uses the high-low method to analyze cost behavior, has determined that machine hours best explain the company's utilities cost. The company's relevant range of activity varies from a low of 600 machine hours to a high of 1,100 machine hours, with the following data being available for the first six months ot the year: Month Machine Hours Utilities 8,700 January February March 800 720 810 920 8,360 8,950 April May June 9,360 9,625 9,150 950 900