Question

Bob is a photographer who sells prints on consignment. Each week during the​ summer, Bob checks...

Bob is a photographer who sells prints on consignment. Each week during the​ summer, Bob checks the inventory so that he can replenish the prints that have been sold. The following data show the number of prints sold each week during the last eight weeks. Complete parts a through e below.

Week   Sold
1   14
2   8
3   9
4   13
5   17
6   16
7   11
8   10

​a) Forecast the demand for Week 9 using a​ two-period simple moving average.

The forecasted demand for Week 9 using a​ two-period simple moving average is

​(Type an integer or a decimal. Do not​ round.)

b) Calculate the MAD for the forecast in part a.

MAD=

​(Round to two decimal places as​ needed.)

​c) Forecast the demand for Week 9 using a​ three-period simple moving average.

The forecasted demand for Week 9 using a​ three-period simple moving average is

​(Round to two decimal places as​ needed.)

​d) Calculate the MAD for the forecast in part c.

MAD=

​(Round to two decimal places as​ needed.)

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1. Bob is a photographer who sells prints on consignment. Each week during the​ summer, Bob...
1. Bob is a photographer who sells prints on consignment. Each week during the​ summer, Bob checks the inventory so that he can replenish the prints that have been sold. The following data show the number of prints sold each week during the last eight weeks. Week   Sold 1   15 2   11 3   8 4   15 5   18 6   17 7   9 8   10 ​a) Forecast the demand for Week 9 using a​ two-period simple moving average. (Type an integer...
The following data show the average prices for a​ 32-inch LCD television over a​ six-year period...
The following data show the average prices for a​ 32-inch LCD television over a​ six-year period based on​ fourth-quarter results. Complete parts a through e below. Year 2005 2006 2007 2008 2009 2010 Price ​$1577 ​$1871 ​$729 ​$561 ​$521 ​$370 ​a) Forecast the average price of a​ 32-inch LCD television during the fourth quarter of 2011 using a​ two-period simple moving average. The forecasted average price of a​ 32-inch LCD television during the fourth quarter of 2011 using a​ two-period...
The following data show the average prices for a​ 32-inch LCD television over a​ six-year period...
The following data show the average prices for a​ 32-inch LCD television over a​ six-year period based on​ fourth-quarter results. Complete parts a through e below. Year 2005 2006 2007 2008 2009 2010 Price $1,529 $864 $732 $597 $501 $379 ​a) Forecast the average price of a​ 32-inch LCD television during the fourth quarter of 2011 using a​ two-period simple moving average. ​b) Calculate the MAD for the forecast in part a. ​c) Forecast the average price of a​ 32-inch...
Problem 3 Hospitality Hotels forecasts monthly labor needs. (a) Given the following monthly labor figures, make...
Problem 3 Hospitality Hotels forecasts monthly labor needs. (a) Given the following monthly labor figures, make a forecast for June using a three-period moving average and a five-period moving average. (Round answers to 2 decimal places, e.g. 15.25.) Month Actual Values January 33 February 45 March 44 April 41 May 44 3-Period Moving Average 5-Period Moving Average (b) What would be the forecast for June using the naïve method? (Round answers to 2 decimal places, e.g. 15.25.) Forecast for June...
Step by step plz Freight car loadings over a 10-week period at a busy port are...
Step by step plz Freight car loadings over a 10-week period at a busy port are as follows: Week Number 1 220 2 245 3 280 4 275 5 300 6 310 7 362 8 360 9 402 10 400 Develop forecast from week 5 to week 10 by using 4-week moving average. Find the MAD for this forecasting method. Please round your answer to 4 decimal places if necessary.
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple...
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. The actual values for 12 periods (shown in order) are: (1) 45  (2)...
An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...
An electrical contractor's records during the last five weeks indicate the number of job requests: Week: 1 2 3 4 5 Requests: 23 29 23 28 25 Predict the number of requests for week 6 using each of these methods: a. Naive. Number of requests             b. A four-period moving average. (Round your answer to 2 decimal places.) Number of requests             c. Exponential smoothing with α = .20. Use 22 for week 2 forecast. (Round your intermediate...
n electrical contractor's records during the last five weeks indicate the number of job requests: Week:...
n electrical contractor's records during the last five weeks indicate the number of job requests: Week: 1 2 3 4 5 Requests: 17 19 15 18 19 Predict the number of requests for week 6 using each of these methods: a. Naive. Number of requests b. A four-period moving average. (Round your answer to 2 decimal places.) Number of requests c. Exponential smoothing with α = .30. Use 17 for week 2 forecast. (Round your intermediate forecast values and final...
(b) Develop the three-week moving average forecasts for this time series. (Round your answers to two...
(b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 16 2 11 3 13 4 10 5 14 6 12 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 16 2 11 3 13 4...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12 16 11 18 13 (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 19 2 12 3 16 4 11 5 18 6 13 Compute MSE. (Round your answer to two decimal places.) MSE =   What is the forecast for week 7? (c) Use α = 0.2 to compute...