Purchase Solution

Controller material handling cost regression high low costs

Not what you're looking for?

Ask Custom Question

Controller completed a cost study of the firms' material handling department in which he used work measurement to quantify departments' activity. Factor unit used in the work measurement study was hundreds of kg of equipment unloaded or loaded at the company's loading dock.
Month units of activity material handling dpt cost
In hundreds of kg
January 1800 11700
February 1600 11300
March 1300 11250
April 1000 10200
May 2200 11100
June 2400 12550
July 2000 12000
August 1800 11400
Sep 2600 12120
Oct 1100 11050
Nov 1200 11350
Dec 1400 11350

1. Draw a scatter diagram of the cost data for the material handling department.
2. Fit a cost line to the diagram.
3. Estimate variable and fixed components of the dpt cost behavior pattern using the cost line.
4. Specify and equation to express the department cost behavior.
5. Estimate material handling department cost behavior using the high low method.
6. Explain why the cost estimates developed in 4 and 5 differ.
7. Predict company's material handling cost for a month when 2250 units of activity are recorded.
8. Construct excel spreadsheet to perform a least squares regression Estimate variable and fixed cost components in the company's material handling dpt costs.

Purchase this Solution

Solution Summary

Your tutorial is attached in Excel. You have three estimates for variable and fixed costs: (1) my visual fit on the scatter diagram, (2) the high low methods, and (3) regression. The formula and process for high low is given. The reason for the difference between scatter fit and high low is shown is a visual format.

Solution Preview

Your tutorial is attached in Excel. You have three estimates for variable and ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.