Questions from Spreadsheet Modeling

Q: Create a double moving average model (with k 5 4)

Create a double moving average model (with k 5 4) for the data set. a. Prepare a line graph comparing the double moving average predictions against the original data. b. What are the forecasts for t...

Q: Create an exponential smoothing model that minimizes the MSE for the data

Create an exponential smoothing model that minimizes the MSE for the data set. Use Solver to determine the optimal value of a. a. What is the optimal value of a? b. Prepare a line graph comparing th...

Q: Use Holt’s method to create a model that minimizes the MSE for

Use Holt’s method to create a model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a and b. a. What are the optimal values of a and b? b. Prepare a line graph c...

Q: Under what condition(s) is it appropriate to use simulation

Under what condition(s) is it appropriate to use simulation to analyze a model? That is, what characteristics should a model possess in order for simulation to be used?

Q: Branch banks must keep enough money on hand to satisfy customers’ cash

Branch banks must keep enough money on hand to satisfy customers’ cash demands. Suppose that the daily demand for cash at a branch of University Bank follows a lognormal distribution...

Q: Hometown Insurance sells 10-year annuities to retirees who are looking

Hometown Insurance sells 10-year annuities to retirees who are looking for stable sources of investment income. Hometown invests the annuity funds it receives in an equity index fund with annual retur...

Q: WVTU is a television station that has 20 thirty-second advertising

WVTU is a television station that has 20 thirty-second advertising slots during their regularly scheduled programming each evening. The station is now selling advertising for the first few days in Nov...

Q: The owner of a ski apparel store in Winter Park, CO

The owner of a ski apparel store in Winter Park, CO must make a decision in July regarding the number of ski jackets to order for the following ski season. Each ski jacket costs $54 and can be sold du...

Q: Tarrows, Pearson, Foster, and Zuligar (TPF&Z

Tarrows, Pearson, Foster, and Zuligar (TPF&Z) is one of the largest actuarial consulting firms in the United States. In addition to providing its clients with expert advice on executive compensati...

Q: The owner of a golf shop in Myrtle Beach, SC must

The owner of a golf shop in Myrtle Beach, SC must decide how many sets of beginner golf clubs to order for the coming tourist season. Demand for golf clubs is random but follows a Poisson distribution...