Share
Explore BrainMass

Cost Curve Anaylsis

You have been presented with the following cost data table and asked to fit a statistical cost function.
Quantity | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
Total Cost | 104 | 107 | 109 | 111.5 | 114.5 | 118 | 123 | 128.5 | 137 | 150

Question 1: fit (estimate) three possible statistical cost functions to the data. Use straight-line, quadratic, and cubic formulas.

2: discuss the statistical results you obtained in question 1. Include in your discussion R^2 , the coefficients, and the statistical significance of the coefficients. For the statistical significance test, use the p-test rather than the t-test.

3: If the data represent 10 months of production for one plant of a specific company, would you consider this to be a short-run analysis?

4: how would you answer to question 3 change if you were told that the data represent 10 different plants during a particular month of the year?

How would I answer this in a word doc and an Excel? Please help.

Solution Summary

The solution assists with fitting a statistical cost function to the data.

$2.19