Scribd Logo
Upload

Welcome to Scribd!

  • 44 views

    TEAM 4 - Overhead Costs

    Uploaded by

    VamsiDeepak
    This document contains a regression analysis of overhead costs using machine hours and production runs as predictors. The regression model explains 86.6% of the variance in overhead and both machine hours and production runs are statistically significant predictors of overhead with p-values less than 0.0001. There are no outliers identified.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    TEAM 4 - Overhead Costs

    Uploaded by

    VamsiDeepak
    44 views6 pages
    This document contains a regression analysis of overhead costs using machine hours and production runs as predictors. The regression model explains 86.6% of the variance in overhead and both machine hours and production runs are statistically significant predictors of overhead with p-values less than 0.0001. There are no outliers identified.

    Original Description:

    Cost

    Original Title

    TEAM 4 _ Overhead Costs

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a regression analysis of overhead costs using machine hours and production runs as predictors. The regression model explains 86.6% of the variance in overhead and both machine hours and production runs are statistically significant predictors of overhead with p-values less than 0.0001. There are no outliers identified.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    44 views6 pages

    TEAM 4 - Overhead Costs

    Uploaded by

    VamsiDeepak
    This document contains a regression analysis of overhead costs using machine hours and production runs as predictors. The regression model explains 86.6% of the variance in overhead and both machine hours and production runs are statistically significant predictors of overhead with p-values less than 0.0001. There are no outliers identified.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 6

    This isis fictitious

    This fictitious data.


    data.
    A B C D
    1 Month Machine Hours Production Runs Overhead
    2 1 1539 31 99798
    3 2 1284 29 87804
    4 3 1490 27 93681
    5 4 1355 22 82262
    6 5 1500 35 106968
    7 6 1777 30 107925
    8 7 1716 41 117287
    9 8 1045 29 76868
    10 9 1364 47 106001
    11 10 1516 21 88738
    12 11 1623 37 105830
    13 12 1376 37 88730
    14 13 1327 49 100624
    15 14 1178 50 98857
    16 15 1491 37 102622
    17 16 1667 41 108059
    18 17 1769 34 110054
    19 18 1104 44 91892
    20 19 1196 46 98693
    21 20 1794 29 110530
    22 21 1379 38 96883
    23 22 1448 32 99593
    24 23 1505 32 94564
    25 24 1420 42 105752
    26 25 1475 27 93224
    27 26 1118 34 75398
    28 27 1433 58 113137
    29 28 1589 26 85609
    30 29 1585 32 98498
    31 30 1493 33 101803
    32 31 1124 36 88371
    33 32 1536 28 102419
    34 33 1678 41 117183
    35 34 1723 35 107828
    36 35 1413 30 88032
    37 36 1390 54 117943
    38
    39 37 1430 35 97180
    40 38 1560 45 111676.27
    41 39 1520 40 105516.72
    StatTools Report
    Analysis: Regression
    Performed By: UMA
    Date: 27-Dec-17
    Updating: Static
    Variable: Overhead

    Multiple Regression for Overhead Multiple_x000D_ Adjusted_x000D_ Std. Err. of_x000D_ Rows_x000D_
    R-Square
    R R-square Estimate Ignored
    Summary
    0.9308 0.8664 0.8583 4108.9930902 0

    Degrees of_x000D_ Sum of_x000D_ Mean of_x000D_ F p-Value


    Freedom Squares Squares
    ANOVA Table
    Explained 2 3614020660.9 1807010330.5 107.02612793 < 0.0001
    Unexplained 33 557166199.1 16883824.215

    Standard_x000D_ Confidence Interval 95%


    Coefficient t-Value p-Value
    Error
    Regression Table Lower
    Constant 3996.6782085 6603.6509323 0.6052225124 0.5492 -9438.550632
    Machine Hours 43.536398116 3.5894836996 12.128874724 < 0.0001 36.233538619
    Production Runs 883.61792524 82.25140753 10.742891238 < 0.0001 716.27617839
    Outliers

    Confidence Interval 95%


    Upper
    17431.907049
    50.839257613
    1050.9596721
    StatTools Report
    Analysis: Regression
    Performed By: UMA
    Date: 27-Dec-17
    Updating: Static
    Variable: Overhead

    Multiple Regression for Overhead Multiple_x000D_ Adjusted_x000D_ Std. Err. of_x000D_ Rows_x000D_
    R-Square
    R R-square Estimate Ignored
    Summary
    0.9308 0.8664 0.8583 4108.9930902 0

    Degrees of_x000D_ Sum of_x000D_ Mean of_x000D_ F p-Value


    Freedom Squares Squares
    ANOVA Table
    Explained 2 3614020660.9 1807010330.5 107.02612793 < 0.0001
    Unexplained 33 557166199.1 16883824.215

    Standard_x000D_ Confidence Interval 95%


    Coefficient t-Value p-Value
    Error
    Regression Table Lower
    Constant 3996.6782085 6603.6509323 0.6052225124 0.5492 -9438.550632
    Machine Hours 43.536398116 3.5894836996 12.128874724 < 0.0001 36.233538619
    Production Runs 883.61792524 82.25140753 10.742891238 < 0.0001 716.27617839
    Outliers

    Confidence Interval 95%


    Upper
    17431.907049
    50.839257613
    1050.9596721

    You might also like