Accounting: Cost estimation with high-low method.
Not what you're looking for?
Ken Howard, financial analyst at JVR Corporation, is examining the behavior of quarterly maintenance costs for budgeting purposes. Howard collects the following data on machine-hours worked and maintenance costs for the past 12 quarters:
Quarter Machine-Hours Maintenance Costs
1 - 90,000 $185,000
2 - 110,000 $220,000
3 - 100,000 $200,000
4 - 120,000 $240,000
5 - 85,000 $170,000
6 - 105,000 $215,000
7 - 95,000 $195,000
8 - 115,000 $235,000
9 - 95,000 $190,000
10 - 115,000 $225,000
11 - 105,000 $180,000
12 - 125,000 $250,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. Howard anticipates that JVR will operate machines for 90,000 hours in quarter 13. Calculate the predicted maintenance costs in quarter 13 using the cost function estimated in #1.
* Complete in Excel
Purchase this Solution
Solution Summary
The problem deals with estimating costs using the high-low method.
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Basics of corporate finance
These questions will test you on your knowledge of finance.