Nathan Davidson, financial analyst at LMN Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Davidson collects the following data on machine-hours worked and utility costs for the past 8 quarters: (Click the icon to view the data.) Read the requirements. Requirement 1. Estimate the cost function for the quarterly data using the high-low method. (Complete all answer boxes.) Data table + Quarter Machine-Hours Utility Costs Quarter 1 100,000 $ 265,000 Quarter 2 55,000 200,000 Quarter 3 90,000 250,000 Quarter 4 105,000 280,000 Quarter 5 70,000 220,000 Quarter 6 95,000 260,000 Quarter 7 85,000 275,000 Quarter 8 80,000 245,000 Print Done - ☑ Requirements 1. Estimate the cost function for the quarterly data using the high-low method. 2. Plot and comment on the estimated cost function. 3. Davidson anticipates that LMN will operate machines for 105,000 hours in quarter 9. Calculate the predicted utility costs in quarter 9 using the cost function estimated in requirement 1. Print Done ✓

Nathan Davidson, financial analyst at LMN Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Davidson collects the following data on machine-hours worked and utility costs for the past 8 quarters: (Click the icon to view the data.) Read the requirements. Requirement 1. Estimate the cost function for the quarterly data using the high-low method. (Complete all answer boxes.) Data table + Quarter Machine-Hours Utility Costs Quarter 1 100,000 $ 265,000 Quarter 2 55,000 200,000 Quarter 3 90,000 250,000 Quarter 4 105,000 280,000 Quarter 5 70,000 220,000 Quarter 6 95,000 260,000 Quarter 7 85,000 275,000 Quarter 8 80,000 245,000 Print Done - ☑ Requirements 1. Estimate the cost function for the quarterly data using the high-low method. 2. Plot and comment on the estimated cost function. 3. Davidson anticipates that LMN will operate machines for 105,000 hours in quarter 9. Calculate the predicted utility costs in quarter 9 using the cost function estimated in requirement 1. Print Done ✓

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 3P: Jensen Tire Auto is deciding whether to purchase a maintenance contract for its new computer wheel...

See similar textbooks

Similar questions

The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method, express the companys overtime wages as an equation where x represents number of invoices processed. Assume BC has monthly fixed costs of $3,800. Predict the overtime wages if 9,000 invoices are processed. Predict the overtime wages if 6,500 invoices are processed. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.
Crystal Mining has completed the following data to analyze utility cost:MonthMachine Hours Utility CostJanuary200P 300February325440March400480April410490May525620June680790July820840August900900Required:1.Use the least squaresmethod to develop a formula for budgeting utility cost. (Round off value of b to two decimal places and the value of a to nearest peso.2.Prepare flexible budget with separate variable and fixed categories for utility costs at 350, 500, and 600 machine hours.
Wayne Mueller, financial analyst at CELL Corporation, is examining the behav- ior of quarterly utility costs for budgeting purposes. Mueller collects the following data on machine-hours worked and utility costs for the past 8 quarters: Utility Costs $215,000 Quarter Machine-Hours 120,000 150,000 200,000 270,000 170,000 250,000 225,000 195,000 2 75,000 110,000 150,000 90,000 140,000 130,000 3 4 5 100,000 1. Estimate the cost function for the quarterly data using the high-low method. 2. Plot and comment on the estimated cost function. 3. Mueller anticipates that CELL will operate machines for 125,000 hours in quarter 9. Calculate the pre- dicted utility costs in quarter 9 using the cost function estimated in requirement 1.
High-low method. Wayne Mueller, financial analyst at CELL Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Mueller collects the following data on machine-hours worked and utility costs for the past 8 quarters:
As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you've been asked to do some what-if analyses. Following is the budgeted Information regarding the coming year: Selling price per unit Variable cost per unit Fixed costs (per year) Required: $ 100.00 60.00 1,113,040 1. What is the breakeven volume, in units and dollars, for the coming year? 2. Assume that the goal of the company is to earn a pretax (operating) profit of $316,000 for the coming year. How many units would the company have to sell to achieve this goal? 3. Assume that of the $60 variable cost per unit the labor-cost component is $27. Current negotiations with the employees of the company indicate some uncertainty regarding the labor cost component of the variable cost figure presented above. What is the effect on the breakeven point in units if selling price and fixed costs are as planned, but the labor cost for the coming year is…
Check my work As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you've been asked to do some what-if analyses. Following is the budgeted information regarding the coming year: Selling price per unit Variable cost per unit Fixed costs (per year) Required: $ 100.00 63.00 1,227,327 1. What is the breakeven volume, in units and dollars, for the coming year? 2. Assume that the goal of the company is to earn a pretax (operating) profit of $332,001 for the coming year. How many units would the company have to sell to achieve this goal? 3. Assume that of the $63 variable cost per unit the labor-cost component is $29. Current negotiations with the employees of the company indicate some uncertainty regarding the labor cost component of the variable cost figure presented above. What is the effect on the breakeven point in units if selling price and fixed costs are as planned, but the labor cost for the…
Botana Company constructed the following formula for its monthly utility cost. Total utility cost = $1,200 + ($8.10 × Labor hours) Assume that 775 labor hours are budgeted for the month of April. If Botana Company incurs 9,600 labor hours for the year, what would be the estimate of total utility cost?
Veritas Company constructed the following formula for its monthly utility cost. Total utility cost $2,100 + ($5.50 x Labor hours) Assume that 557 labor hours are budgeted for the month of April. If Botana Company incurs 12,600 labor hours for the year, what would be the estimate of total utility cost for the year?
Using account analysis, Pymble Co. wishes to estimate employees' automobile expenses as a function of miles driven. Costs for the past quarter, during which 58,000 miles were driven, are classified as follows: Item Classification Cost $3,200 11,200 3,900 1,800 2,100 Fuel Variable Fixed Fixed Variable Fixed Depreciation Insurance Maintenance Parking Predict the total cost for the coming quarter for which the employees' auto travel budget would be 65,000 miles: $
As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you've been asked to do some what-if analyses. Following is the budgeted information regarding the coming year: Selling price per unit Variable cost per unit Fixed costs (per year) $ 100.00 70.00 1,200,000 Required: 1. What is the breakeven volume, in units and dollars, for the coming year? 2. Assume that the goal of the company is to earn a pretax (operating) profit of $300,000 for the coming year. How many units would the company have to sell to achieve this goal? 3. Assume that of the $70 variable cost per unit the labor-cost component is $25. Current negotiations with the employees of the company indicate some uncertainty regarding the labor cost component of the variable cost figure presented above. What is the effect on the breakeven point in units if selling price and fixed costs are as planned, but the labor cost for the coming year is…
The controller of the Stump Company is preparing the budget for 2021 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior 2 months are: LOADING... (Click the icon to view the information.) Requirements 1. Estimate the cost function for delivery. 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. Requirement 1. Estimate the cost function for delivery. Delivery costs = + ( × ) Delivery costs = + ( × ) Requirement 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. The cost function in requirement 1 is an estimate of how costs behave ▼ outside of within the relevant range, not at cost levels ▼ outside within the relevant range. If there are no months with zero miles driven represented in the delivery cost…
The cost data for BC Billing Solutions for the year 2020 is as follows: A. Using the high-low method, express the company’s overtime wages as an equation wherexrepresents number of invoices processed. Assume BC has monthly fixed costs of $3,800. B. Predict the overtime wages if 9,000 invoices are processed. D. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.