Management Science - Mid Term.xlsx

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

Info icon 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
Image of page 1

Info icon 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.
Image of page 2
Truck Maintenance Expense Miles Drivenge of Truck 1 $908.56 10,500 10
Image of page 3

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

Image of page 4
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

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern