Cost Modeling. General Widget Corporation has collected data on the daily output and daily production cost of

Question:

Cost Modeling. General Widget Corporation has collected data on the daily output and daily production cost of widgets produced at its factory. (Data for the study are shown in the table below.) The company believes that daily output (DO) and daily production cost (PC) ought to be linearly related. Thus, for some numbers a and b:

PC = a + b x DO

Build a least-squares model to estimate the parameters a and b in the linear relationship. In other words, minimize the sum of squared differences between the model’s predicted values and the observations. What are the best values of the parameters a and b for this criterion?

a. What is the minimum value of the objective function? (Verify your results by using Excel’s Regression tool.)

b. Suppose, instead, that a better criterion is thought to be minimizing the sum of absolute deviations between the model’s predicted values and the observations. What are the best values of the parameters a and b for this criterion? What is the minimum value of the objective function?

c. Suppose, instead, that a better model than the linear model is thought to be the power function PC = a(DO)b

Using the sum of absolute deviations (as in the previous part), what values of a and b provide the best fit? What is the minimum value of the objective function?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Management Science The Art Of Modeling With Spreadsheets

ISBN: 1301

4th Edition

Authors: Stephen G. Powell, Kenneth R. Baker

Question Posted: