Scribd Logo
Upload

Welcome to Scribd!

  • 80 views

    Data Section: Statistics and Linear Regression

    Uploaded by

    Angelica Festejo
    1) The document contains production and maintenance cost data for 12 months. 2) Summary statistics calculated include total yearly maintenance costs, average monthly production and costs, highest/lowest monthly production and costs. 3) Linear regression analysis estimates a fixed monthly cost of $45,410 and variable cost per unit of $1.31. Using this, a cost prediction of $84,713 is calculated for projected next month production of 30,000 units.

    Copyright:

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

    Data Section: Statistics and Linear Regression

    Uploaded by

    Angelica Festejo
    80 views4 pages
    1) The document contains production and maintenance cost data for 12 months. 2) Summary statistics calculated include total yearly maintenance costs, average monthly production and costs, highest/lowest monthly production and costs. 3) Linear regression analysis estimates a fixed monthly cost of $45,410 and variable cost per unit of $1.31. Using this, a cost prediction of $84,713 is calculated for projected next month production of 30,000 units.

    Original Title

    STATS4

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1) The document contains production and maintenance cost data for 12 months. 2) Summary statistics calculated include total yearly maintenance costs, average monthly production and costs, highest/lowest monthly production and costs. 3) Linear regression analysis estimates a fixed monthly cost of $45,410 and variable cost per unit of $1.31. Using this, a cost prediction of $84,713 is calculated for projected next month production of 30,000 units.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    80 views4 pages

    Data Section: Statistics and Linear Regression

    Uploaded by

    Angelica Festejo
    1) The document contains production and maintenance cost data for 12 months. 2) Summary statistics calculated include total yearly maintenance costs, average monthly production and costs, highest/lowest monthly production and costs. 3) Linear regression analysis estimates a fixed monthly cost of $45,410 and variable cost per unit of $1.31. Using this, a cost prediction of $84,713 is calculated for projected next month production of 30,000 units.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    You are on page 1of 4

    A B C D E F

    1 Angelica Michelle Festejo


    2 STATS
    3 Statistics and Linear Regression
    4
    5 Data Section
    6
    7 Units Maintenance
    8 Produced Costs
    9 Month X Y
    10 Jan 21,000 $79,000
    11 Feb 33,000 83,000
    12 Mar 38,000 84,000
    13 Apr 20,000 60,000
    14 May 18,000 59,000
    15 Jun 44,000 102,000
    16 Jul 27,000 81,000
    17 Aug 23,000 74,000
    18 Sep 45,000 106,000
    19 Oct 31,000 90,000
    20 Nov 31,500 98,000
    21 Dec 23,500 94,000
    22
    23
    24 Answer Section
    25
    26 Summary Statistics
    27 Total maintenance costs for the year $1,010,000
    28 Average number of units produced per month 29,583
    29 Lowest number of units produced in a month 18,000
    30 Highest maintenance costs in a month $106,000
    31 Average maintenance cost per unit produced for the year $2.85
    32
    33 Linear Regression
    34 Fixed cost per month (intercept) $45,410
    35 Variable cost per unit produced (slope) $1.31
    36
    37 Estimated volume for next month 30,000
    38 Cost prediction for next month (forecast) $84,713
    39
    Cost Prediction
    3. January Units for January
    25,000 $ 78,162
    20,000 $ 71,612
    0 $ 45,410

    The cost prediction of 0 units is similar to the fixed cost per month.

    4. Fixed cost per month is estimated to be equal to $45,410.


    June, July ,August, and September are closest to the predicted costs.
    February, March, April, and May are the most efficient because
    they are below the regression line that was projected in the chart.
    The number of months that were projected as most efficient is
    similar to those closest to the predicted costs whereas four months
    early in the year are most efficient and four months after are
    closest to the predicted costs. Moreover, the fact that there are
    higher costs at the end of the year implies the need for the
    company's attention.
    Chart

    Angelica Michelle Festejo

    Maintenance Costs
    $120,000

    $100,000

    $80,000

    $60,000

    $40,000

    $20,000

    $0
    15,000 20,000 25,000 30,000 35,000 40,000 45,000 50,000
    Units Produced

    Page 3
    Chart

    3.
    January Units Cost Prediction for January
    25,000 $ 78,162
    20,000 $ 71,612
    0 $ 45,410

    It looks familiar since the answer for fixed cost


    per month is also $45,410

    Page 4

    You might also like