Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Chad Richardson, financial analyst at MVR Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Richardson collects the following data on machine-hours

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Chad Richardson, financial analyst at MVR Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Richardson 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. 1 Data Table Quarter Machine-Hours Utility Costs 125,000 $ 80,000 115,000 130,000 95,000 120,000 110,000 105,000 245,000 180,000 230,000 270,000 200,000 250,000 255,000 225,000 2 3 4 6 8 1 Requirements 1. 2. 3. Estimate the cost function for the quarterly data using the high-low method. Plot and comment on the estimated cost function. Richardson anticipates that MVR will operate machines for 130,000 hours in quarter 9. Calculate the predicted utility costs in quarter 9 using the cost function estimated in requirement 1 Requirement 1. Estimate the cost function for the quarterly data using the high-low method. (Complete all answer boxes.) After you hit continue, the screen may take you below the beginning of the next step. If so, scroll back up to the top of the step.) Requirement 2. Plot and comment on the estimated cost function Plot the line for the estimated cost function using the high-low method. The data points for the 8 quarters have already been entered in for you. (Enlarge the graph and use the line button displayed below to draw the graph.) Click the graph, choose a tool in the palette and follow the instructions to create your graph Delete Clear Machine-Hours Comment on the estimated cost function by choosing the correct statement to go with each of the evaluation criteria listed below. Economic plausibility: O The cost function shows a negative economically plausible relationship between machine-hours and utility costs. There is not a clear-cut O The cost function shows a positive economically plausible relationship between machine-hours and utility costs. There is a clear-cut relationship of higher machine-hours and utility costs. relationship of higher machine-hours and utility costs Goodness of fit: O The high-low line appears to "fit" the data well. The vertical differences between the actual and predicted costs appear to be quite small. O The high-low line appears to not "fit" the data well. The vertical differences between the actual and predicted costs appear to be quite large Slope of high-low line O The slope of the line appears to be reasonably steep indicating that, on average, utility costs in a quarter vary with machine-hours used O The slope of the line appears to be unreasonably steep indicating that, on average, utility costs in a quarter do not vary with machine-hours used. Requirement 3. Richardson anticipates that MVR will operate machines for 130,000 hours in quarter 9. Calculate the predicted utility costs in quarter 9 using the cost function estimated in requirement 1 The predicted maintenance costs would be $ for quarter 9 Chad Richardson, financial analyst at MVR Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Richardson 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. 1 Data Table Quarter Machine-Hours Utility Costs 125,000 $ 80,000 115,000 130,000 95,000 120,000 110,000 105,000 245,000 180,000 230,000 270,000 200,000 250,000 255,000 225,000 2 3 4 6 8 1 Requirements 1. 2. 3. Estimate the cost function for the quarterly data using the high-low method. Plot and comment on the estimated cost function. Richardson anticipates that MVR will operate machines for 130,000 hours in quarter 9. Calculate the predicted utility costs in quarter 9 using the cost function estimated in requirement 1 Requirement 1. Estimate the cost function for the quarterly data using the high-low method. (Complete all answer boxes.) After you hit continue, the screen may take you below the beginning of the next step. If so, scroll back up to the top of the step.) Requirement 2. Plot and comment on the estimated cost function Plot the line for the estimated cost function using the high-low method. The data points for the 8 quarters have already been entered in for you. (Enlarge the graph and use the line button displayed below to draw the graph.) Click the graph, choose a tool in the palette and follow the instructions to create your graph Delete Clear Machine-Hours Comment on the estimated cost function by choosing the correct statement to go with each of the evaluation criteria listed below. Economic plausibility: O The cost function shows a negative economically plausible relationship between machine-hours and utility costs. There is not a clear-cut O The cost function shows a positive economically plausible relationship between machine-hours and utility costs. There is a clear-cut relationship of higher machine-hours and utility costs. relationship of higher machine-hours and utility costs Goodness of fit: O The high-low line appears to "fit" the data well. The vertical differences between the actual and predicted costs appear to be quite small. O The high-low line appears to not "fit" the data well. The vertical differences between the actual and predicted costs appear to be quite large Slope of high-low line O The slope of the line appears to be reasonably steep indicating that, on average, utility costs in a quarter vary with machine-hours used O The slope of the line appears to be unreasonably steep indicating that, on average, utility costs in a quarter do not vary with machine-hours used. Requirement 3. Richardson anticipates that MVR will operate machines for 130,000 hours in quarter 9. Calculate the predicted utility costs in quarter 9 using the cost function estimated in requirement 1 The predicted maintenance costs would be $ for quarter 9

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Process Modeling Simulation And Design

Authors: Manuel Laguna, Johan Marklund

3rd Edition

1138061735, 978-1138061736

More Books

Students also viewed these Accounting questions

Question

Do you usually feel alert when you wake up in the morning? Yes No

Answered: 1 week ago