cost take home 2

cost take home 2 - Month Aug Sept Oct Nov Dec Jan Feb Mar...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Month Pack Supplies Costs Units Produced Product Volume Orders Filled Aug $18,000 1,700 680 160 Sept $26,000 2,000 920 250 Oct $20,000 1,900 720 170 Nov $28,000 2,100 1,080 245 Dec $24,000 1,500 800 210 Jan $25,000 1,750 850 220 Feb $23,500 1,800 840 205 Mar $17,000 1,750 960 180 Apr $23,000 1,850 810 215 May $21,000 1,800 720 200 Jun $24,500 2,050 740 190 Jul $16,000 1,400 660 160
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Units Produced Product Volume Orders Filled Units Produced 1 Product Volume 0.51 1 Orders Filled 0.52 0.73 1 correlation
Background image of page 2
Anne James Advanced Cost Take Home Exam SUMMARY OUTPUT- Orders Filled Regression Statistics Multiple R 0.89 R Square 0.79 Adjusted R Square 0.77 adjusts for error Standard Error 1792.18 Observations 12 ANOVA df SS MS F Significance F Regression 1 124047548.71 124047548.71 38.62 0 Residual 10 32119117.96 3211911.8 Total 11 156166666.67 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -298.27 3651.71 -0.08 0.94 -8434.78 7838.24 -8434.78 7838.24 Orders Filled 112.09 18.04 6.21 0 71.9 152.28 71.9 152.28 RESIDUAL OUTPUT Observation Predicted Pack Supplies Costs Residuals DURBIN WATSON 1 17636.32 363.68 132266.29 2 27724.52 -1724.52 -2088.2 4360597.04 2973969.03 3 18757.23 1242.77 2967.29 8804825.84 1544484.08 4 27164.06 835.94 -406.84 165516.25 698788.75 5 23240.87 759.13 -76.81 5899.69 576272.89 6 24361.79 638.21 -120.91 14619.61 407318.15 7 22680.42 819.58 181.37 32894.13 671714.97 8 19878.14 -2878.14 -3697.72 13673140.88 8283683.23 9 23801.33 -801.33 2076.81 4313137.51 642128.8 10 22119.96 -1119.96 -318.63 101526.75 1254314.92 11 20999.05 3500.95 4620.91 21352823.87 12256647.87 12 17636.32 -1636.32 -5137.27 26391494.21 2677529 79216475.77 32119117.96 2.47
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Anne James Advanced Cost Take Home Exam orders filled 150 170 190 210 230 250 270 -4000 -3000 -2000 -1000 0 1000 2000 3000 4000 Orders Filled Residual Plot Orders Filled Residuals 150 170 190 210 230 250 270 15000 17500 20000 22500 25000 27500 30000 Orders Fil ed Line Fit Plot Column B Column B Orders Fil ed Pack Supplies Costs 15000 17000 19000 21000 23000 25000 27000 29000 -4000 -3000 -2000 -1000 0 1000 2000 3000 4000 Residuals versus predictions Residuals Supplies Costs 0 2 4 6 8 10 12 14 -4000 -3000 -2000 -1000 0 1000 2000 3000 4000 Residuals over time Residuals
Background image of page 4
Anne James Advanced Cost Take Home Exam 0 20 40 60 80 100 120 15000 17000 19000 21000 23000 25000 27000 29000 Normal Probability Plot Sample Percentile Pack Supplies Costs
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
SUMMARY OUTPUT: Units produced Regression Statistics Multiple R 0.63 R Square
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 20

cost take home 2 - Month Aug Sept Oct Nov Dec Jan Feb Mar...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online