Purchase Solution

Fixed and variable costs with the Scattergraph method

Not what you're looking for?

Ask Custom Question

Month Machine Hours Utility Cost
Jan 200 $300
Feb 325 440
March 400 480
April 410 490
May 525 620
June 680 790
July 820 840
Aug 900 900

1. Determine the fixed and variable costs using:
A. Scattergraph Method
B. High-Low Method

2. Determine the cost formula using both methods.

3. Within the relevant range, can the formula be reliably used to predict utility cost? Can the a and b values in the cost formula be interpreted as fixed and variable costs? Why or why not?

4. Using both formulas predict the utility cost in a month the uses 850 machine hours?

Purchase this Solution

Solution Summary

The fixed and variable costs with the scattergraph methods are examined.

Solution Preview

Please see attachment.

HIGH LOW METHOD

Month Machine Hours Utility Cost
Jan 200 300
Feb 325 440
Mar 400 480
Apr 410 490
May 525 620
Jun 680 790
Jul 820 840
Aug 900 900

1. Determine the fixed and variable costs using:
A. Scatter graph Method

Fixed cost $145.36
Variable cost $0.87

B. High-Low ...

Solution provided by:
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
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

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.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Operations Management

This quiz tests a student's knowledge about Operations Management