Question
Jerry Thomas is the manger for the storeroom for Classic Manufacturing. He was asked to estimate the future monthly purchase costs for part number 782.
Jerry Thomas is the manger for the storeroom for Classic Manufacturing. He was asked to estimate the future monthly purchase costs for part number 782. Jerry collected the cost and quantity data for the past nine months as provided below.
Month | Purchase cost | Quantity Purchased |
January | $ 12,925 | 2,762 |
February | $ 13,250 | 2,862 |
March | $ 17,903 | 4,212 |
April | $ 16,075 | 3,818 |
May | $ 13,375 | 2,966 |
June | $ 14,064 | 3,447 |
July | $ 15,550 | 3,685 |
August | $ 10,483 | 2,356 |
September | $ 15,200 | 3,636 |
Estimated monthly purchases of part 782 for the following three months are:
October 3,590
November 3,960
December 3,290
Required:
- Use the high-low method to develop a linear formula to estimate the purchase costs for the parts to be purchased for the rest of the year
- Use the formula in (a) to estimate the purchase costs for each of the months October to December.
- Use the regression method to develop a formula to estimate the purchase costs for the parts to be purchased for the rest of the year.
- Use the formula in (c) to estimate the purchase costs for each of the months October to December.
- What are your comments on the results in (b) and (d) above?
Show all your calculations for (a) to (d).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started