Mike Carlton, financial analyst at MVR Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Carlton collects the following data on machine-hours worked and utility costs for the past 8 quarter (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.) 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 Carlton anticipates that MVR will operate machines for 100.000 hours in - X Data table Quarter Quarter 1 Quarter 2 Machine-Hours C Utility Costs 265,000 200,000 95,000 $ 50,000 - X

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question

A 155.

Mike Carlton, financial analyst at MVR Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Carlton 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.)
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. Carlton anticipates that MVR will operate machines for 100,000 hours in
quarter 9. Calculate the predicted utility costs in quarter 9 using the cost
function estimated in requirement 1.
Print
Done
X
Data table
Quarter
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Quarter 5
Quarter 6
Quarter 7
Quarter 8
Machine-Hours
Print
100,000
65,000
C
95,000 $
50,000
85,000
90,000
80,000
75,000
Utility Costs
265,000
200,000
250,000
280,000
220,000
260,000
275,000
245,000
Done
Transcribed Image Text:Mike Carlton, financial analyst at MVR Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Carlton 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.) 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. Carlton anticipates that MVR will operate machines for 100,000 hours in quarter 9. Calculate the predicted utility costs in quarter 9 using the cost function estimated in requirement 1. Print Done X Data table Quarter Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 5 Quarter 6 Quarter 7 Quarter 8 Machine-Hours Print 100,000 65,000 C 95,000 $ 50,000 85,000 90,000 80,000 75,000 Utility Costs 265,000 200,000 250,000 280,000 220,000 260,000 275,000 245,000 Done
Expert Solution
steps

Step by step

Solved in 5 steps with 1 images

Blurred answer
Knowledge Booster
Accounting Profits
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education