1. X Company had the following 10 months of data on materials handling cost and number of moves

1. Determine the high point and the low point.

2. Calculate the variable rate for materials handling based on the number of moves.

3. Calculate the fixed monthly cost of material handling.

4. Write the cost formula for the materials handling activity showing the fixed cost and variable rate.

5. If the company estimates that November will have 31.300 moves, what is the total estimated materials handling cost for that month?

6. What if the company wants to estimate materials handling cost for the coming year and expects 330.000 moves? What will the estimated total materials handling cost be? What is the total fixed materials handling cost? Why doesnt it equal the fixed cost calculated in Requirement 3 above

Month Number of Moves January February March Materials Handling Cost $ 875,000 1,340,000 1,472,000 18,500 35,000 45,000 April May June July August September October 1,050,000 1,215,000 1,300,000 1,541,000 27,000 30,000 34,000 42,000 1,445,000 1,275,000 812,000 38,000 33,000 15,000