Question

Problem 3-17 A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales...

Problem 3-17

A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were

Day: 1 2 3 4 5 6 7 8 9
Number sold: 32 35 38 37 44 43 41 44 42
Day: 10 11 12 13 14 15
Number sold: 48 43 53 44 50 49


a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 48 for Day 8, an initial trend estimate of 2, and α = β = .2, develop demand forecasts for Days 9 through 16. Then compute the resultant MSE using the error values from Days 8 through 15. (Round your intermediate period-by-period forecast and error values to 3 decimal places. Round your final MSE answer to 3 decimal places.)

MSE ____?

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
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six months (January – June): Month Period Sales January 1 16 February 2 25 March 3 20 April 4 20 May 5 31 June 6 35 July 7 26 August 8 (a) Use this information to answer the following 7 questions: 6.Using January through July values, develop a linear trend equation for this time series (to 4 decimals). Please write the equation in the proper form. 7.Using your answer from...
For the data given below, forecast period 17 using following methods and suggest the best forecasting...
For the data given below, forecast period 17 using following methods and suggest the best forecasting model 1. Simple Moving Average (Three Period) 2. Weighted Average (50% on t-1, 30% on t-2, 20% on t-3) 3. Exponential Smoothing (α=.1), F1= y intercept from regression) 4. Exponential Smoothing (α=.3), F1= y intercept from regression) 5. Exponential Smoothing with trend (α=.3) and (δ=.3), F1= y intercept from regression)** 5. Exponential Smoothing with trend (α=.1) and (δ=.3), F1= y intercept from regression)** 6....
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six months (January – June): Month Period Sales January 1 16 February 2 25 March 3 20 April 4 20 May 5 31 June 6 35 July 7 26 August 8 (a) Use this information to answer the following 7 questions: ques 1 given the information above 1.Use exponential smoothing (a= 0.10) to forecast the sales for August (to 2 decimals). What is the value? 2. Compute the MSE for...
A stock price has been recorded over the past 10 days.  Determine the Mean Squared Error (MSE)...
A stock price has been recorded over the past 10 days.  Determine the Mean Squared Error (MSE) over periods four to ten (inclusive) for a Weighted Moving Average (WMA) forecast using weights of 0.5, 0.4, 0.1 (with 0.5 applying to the most recent period). Day Demand 1       1,042 2       1,042 3       1,044 4       1,029 5       1,025 6       1,050 7       1,069 8       1,048 9       1,063 10       1,057 a. 11.85 b. 82.97 c....
A small business has recorded sales over the last 20 years.  The data is provided in accompanying...
A small business has recorded sales over the last 20 years.  The data is provided in accompanying workbook, tab “Small Business”. The business would like to use this data to provide a sales forecast for the future, specifically, the next two years. Build a spreadsheet that shows all the forecasts on a side-by-side basis so they can be compared for effectiveness using an error measure. Create a chart showing the data in time.  Discuss any patterns in the dat Create moving average...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Problem 2: Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total Problem 3: A firm uses simple exponential smoothing with to forecast demand. The forecast for the week...
16) Sales of tablet computers at Ted​ Glickman's electronics store in​ Washington, D.C., over the past...
16) Sales of tablet computers at Ted​ Glickman's electronics store in​ Washington, D.C., over the past 10 weeks are shown in the table​below:                                                                                                                       Week 1 2 3 4 5 6 7 8 9 10 Demand 20 21 27 38 26 29 37 24 25 29 ​a) The forecast for weeks 2 through 10 using exponential smoothing with alphaα ​= 0.55 and a week 1 initial forecast of 20.0 are ​(round your responses to two decimal​ places): Week 1 2...
A large Portland manufacturer wants to forecast demand for a piece of​ pollution-control equipment. A review...
A large Portland manufacturer wants to forecast demand for a piece of​ pollution-control equipment. A review of past sales ​(Upper A Subscript tAt​), as shown​ below, indicates that an increasing trend is present.  Smoothing constants are assigned the values of alphaα = 0.20 and betaβ = 0.4 The firm assumes the initial forecast for month 1 ​(Upper F 1F1​) was 11.00 units and the trend over that period Upper T 1T1 was 2.00 units. Using​ trend-adjusted exponential​ smoothing, Forecasts (Upper...
A convenience store recently started to carry a new brand of soft drink. Management is interested...
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing​ (let alpha α equals=0.4 with an initial forecast for week 1 of 586​) methods to forecast demand for week 13....
After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential...
After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of trend is based on the net change of 23 for the three periods from 1 to 4, for an average of +7.67 units. Period Actual Period Actual 1 208 6 261 2 231 7 276 3 226 8 286 4 231 9 291 5 251 10 Use α=.60 and β=.15, and TAF...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT