Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Shown below are 15 data points relating to the Receiving cost and tons of material for Acme Manufacturing Receiving Tons of Observation Cost Material 1
Shown below are 15 data points relating to the Receiving cost and tons of material for Acme Manufacturing Receiving Tons of Observation Cost Material 1 $ 67,100 47,300 2 75,200 68,200 3 92,200 93,500 4 88,600 79,200 5 87,700 96,800 6 80,200 49,500 7 98,000 73,700 8 67,600 40,700 9 68,500 46,200 10 78,500 63,800 11 71,700 50,600 12 80,300 48,400 13 78,000 55,000 14 80,000 69,300 15 93,800 53,900 Required: a. Using the High-Low method, determine the cost equation for receiving costs. (4 pts) b. Use the equation in part a. to estimate receiving costs when the tons of material are estimated to be 65,000. (3 pts) c. Using the following regression output, determine the cost equation for receiving costs. (4 pts) d. Use the equation in part c. to estimate receiving costs when the tons of material are estimated to be 65,000. (3 pts) SUMMARY OUTPUT Regression Statistics Multiple R 0.67127413 R Square 0.45060896 Adjusted R Square 0.40834811 Standard Error 7535.38792 Observations 15 ANOVA df SS MS F Significance F Regression 1 605442408 605442408 10.662563 0.0061439 Residual 13 738166925 56782071 Total 14 1.344E+09 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 56893.6114 7484.6066 7.6014164 3.895E-06 40724.102 73063.12 40724.1 73063.12 X Variable 1 0.37816027 0.1158097 3.265358 0.0061439 0.1279685 0.628352 0.127969 0.628352
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