Questions from Management Science


Q: The file contains five years of monthly data on sales (number

The file contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage...

See Answer

Q: The file P13_20.xlsx contains the monthly sales of

The file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next s...

See Answer

Q: A company manufactures two products on two machines. The number of

A company manufactures two products on two machines. The number of hours of machine time and labor depends on the machine and product as shown in the file. The cost of producing a unit of each product...

See Answer

Q: The file P13_21.xlsx contains the weekly sales of

The file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next 30 weeks. D...

See Answer

Q: The file P13_22.xlsx contains total monthly U.

The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully c...

See Answer

Q: You have been assigned to forecast the number of aircraft engines ordered

You have been assigned to forecast the number of aircraft engines ordered each month by Commins Engine Company. At the end of February, the forecast is that 100 engines will be ordered during April. D...

See Answer

Q: Simple exponential smoothing with  = 0.3 is being used

Simple exponential smoothing with  = 0.3 is being used to forecast sales of digital cameras at Lowland Appliance. Forecasts are made on a monthly basis. After August camera sales are observed, the fo...

See Answer

Q: The file P13_25.xlsx contains the quarterly numbers of

The file P13_25.xlsx contains the quarterly numbers of applications for home mortgage loans at a branch office of Northern Central Bank. a. Create a time series chart of the data. Based on what you se...

See Answer

Q: The file P13_26.xlsx contains the monthly number of

The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoot...

See Answer

Q: The file contains yearly data on the proportion of Americans under the

The file contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. a. Create a time series chart of the data. Based on what you see, which of the exponent...

See Answer