Questions from Analytics

Q: The Excel file Closing Stock Prices provides data for four

The Excel file Closing Stock Prices provides data for four stocks and the Dow Jones Industrials Index over a 1-month period.a. Develop spreadsheet models for forecasting each of the stock prices using...

Q: For the data in the Excel file Gasoline Prices do

For the data in the Excel file Gasoline Prices do the following:a. Develop spreadsheet models for forecasting prices using simple moving average and simple exponential smoothing.b. Compare your result...

Q: Consider the prices for the DJ Industrials in the Excel

Consider the prices for the DJ Industrials in the Excel file Closing Stock Prices. The data appear to have a linear trend over the time period provided.a. Use simple linear regression to forecast the...

Q: Sandford Tile Company makes ceramic and porcelain tile for residential

Sandford Tile Company makes ceramic and porcelain tile for residential and commercial use. They produce three different grades of tile (for walls, residential flooring, and commercial flooring), each...

Q: Consider the data in the Excel file Consumer Price Index.

Consider the data in the Excel file Consumer Price Index.a. Use simple linear regression to forecast the data. What would be the forecasts for the next 2 years?b. Use the double exponential smoothing...

Q: Consider the data in the Excel file Nuclear Power. Use

Consider the data in the Excel file Nuclear Power. Use simple linear regression to forecast the data. What would be the forecasts for the next 3 years?

Q: The State of Ohio Department of Education has a mandated

The State of Ohio Department of Education has a mandated ninth-grade proficiency test that covers writing, reading, mathematics, citizenship (social studies), and science. The Excel file Ohio Educatio...

Q: Use Analytic Solver Platform to simulate the Outsourcing Decision Model

Use Analytic Solver Platform to simulate the Outsourcing Decision Model under the assumptions that the production volume will be triangular with a minimum of 800, maximum of 1,700, and most likely val...

Q: For ColPal model in Problem 2, graph the constraints and

For ColPal model in Problem 2, graph the constraints and identify the feasible region. Then identify each of the corner points and show how increasing the objective function value identifies the optim...

Q: The Excel file Store and Regional Sales Database provides sales

The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, uni...