Management Science - Mid Term.xlsx

# Management Science - Mid Term.xlsx - Month f product 1f...

• 12

This preview shows pages 1–4. Sign up to view the full content.

Month f product 1f product 2f product 3f product 4roduction cost 1 368 376 435 451 \$73,271 SUMMARY OUTPUT 2 654 531 550 1264 \$136,260 3 287 519 404 612 \$83,189 Regression Statistics 4 74 676 426 571 \$71,316 Multiple R 0.962524 5 315 790 174 629 \$79,429 R Square 0.926452 6 463 468 570 900 \$100,897 Adjusted R 0.903822 7 369 624 327 894 \$85,651 Standard E 5351.221 8 434 796 455 599 \$99,197 Observatio 18 9 260 586 428 1029 \$92,610 10 438 686 494 1020 \$106,545 ANOVA 11 329 734 484 974 \$102,187 df 12 375 464 358 935 \$86,182 Regression 4 13 303 576 381 987 \$85,200 Residual 13 14 198 283 280 684 \$64,319 Total 17 15 451 604 512 928 \$116,988 16 349 618 425 1011 \$95,426 Coefficients 17 143 621 384 683 \$81,205 Intercept 4642.561 18 313 567 493 865 \$93,629 Units of pr 63.2058 Units of pr 32.57078 Units of pr 58.8209 Units of pr 26.23379 Regression Equation : Predicted Cost = 4642.56 + 63.205 units of product 1 + 32.57 units of product 2 + 58.82 units of 4642.56 is the fixed cost of production. As its is a fixed cost, so it will not vary whether the quantity pr

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

SS MS F ignificance F 4.7E+009 1.2E+009 40.9388 3.01E-007 3.7E+008 28635566 5.1E+009 tandard Erro t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% 8642.743 0.537163 0.600229 -14028.95 23314.07 -14028.95 23314.07 12.70503 4.974864 0.000254 35.75825 90.65336 35.75825 90.65336 9.758521 3.337676 0.005346 11.48878 53.65278 11.48878 53.65278 15.75008 3.734641 0.0025 24.79492 92.84688 24.79492 92.84688 7.510171 3.493102 0.003966 10.00905 42.45853 10.00905 42.45853 product 3 + 26.23 units of product 4 roduced increases or decreases.
Truck Maintenance Expense Miles Drivenge of Truck 1 \$908.56 10,500 10

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

This is the end of the preview. Sign up to access the rest of the document.
• Fall '15
• Self number, Book of Job, maintenance expense

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern