GSCM 330 Strategic Supply AND Master Planning Week 2 Answer

GSCM 330 Strategic Supply AND Master Planning Week 2 Answer

Problems 4.23, 4.27, 4.33, and 4.35.
Sales of vegetable dehydrators at Bud Banis’s discount department store in St. Louis over the past year are shown below. Management prepared a forecast using a combination of exponential smoothing and its collective judgment for the 4 months (March, April, May, and June of 2010):
a) Compute MAD and MAPE for management’s technique.
b) Do management’s results outperform (i.e., have smaller MAD and MAPE than) a naive forecast?
c) Which forecast do you recommend, based on lower forecast error?

Mark Cotteleer owns a company that manufactures sailboats. Actual demand for Mark’s sailboats during each season in 2006 through 2009 was as follows:
Mark has forecasted that annual demand for his sailboats in 2011 will equal 5,600 sailboats. Based on this data and the multiplicative seasonal model, what will the demand level be for Mark’s sailboats in the spring of 2011?

The number of transistors (in millions) made at a plant in Japan during the past 5 years follows:
Period Demand (y) Period(x)
Year 1 140 1
Year 2 160 2
Year 3 190 3
Year 4 200 4
Year 5 210 5

a) Forecast the number of transistors to be made next year, using linear regression.

b) Compute the mean squared error (MSE) when using linear regression.

c) Compute the mean absolute percent error (MAPE).

John Howard, a Mobile, Alabama, real estate developer, has devised a regression model to help determine residential housing prices in South Alabama. The model was developed using recent sales in a particular neighbourhood. The price (Y) of the house is based on the size (square footage = X) of the house. The model is:
Y = 13,473 + 37.65X
The coefficient of correlation for the model is 0.63.

a) Use the model to predict the selling price of a house that is 1,860 square feet.

b) A 1,860-square-foot house recently sold for $95,000. Explain why this is not what the model predicted.

c) If you were going to use multiple regression to develop such a model, what other quantitative variables might you include?

d) What is the value of the coefficient of determination in this problem?

For getting the instant digital download answer, Please click on the “PURCHASE” link below to get “GSCM 330 Strategic Supply AND Master Planning Week 2 Answer”.

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on

GSCM 330 Week 2