Question

The following data is given: August trend forecast                         = 600 units Actual sales in August   &nb

The following data is given:

August trend forecast                         = 600 units

Actual sales in August                       = 370 units

Actual sales in September                  = 700 units

Actual sales in October                      = 665 units

Seasonal index for August                 = 0.9

Seasonal index for Septemeber          = 1.2

Seasonal index for October                = 1.1

Seasonal index for Novermber          = 0.8

Smoothing Constant, α                      = 0.2

Use simple exponential smoothing to find the forecast (seasonalized) for November.

Math   Advanced-Math   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following tabulations are actual sales of units for six months and a starting forecast in...
The following tabulations are actual sales of units for six months and a starting forecast in January. ACTUAL FORECAST January 116 96 February 112 March 115 April 88 May 82 June 112 a. Calculate forecasts for the remaining five months using simple exponential smoothing with α = 0.3. b. Calculate the MAD for all the forecasts, including January's. (Round your answer to 1 decimal place.)
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September,...
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September, and October as follows: Actual: May 5,930 units June 6,240 units Forecast: July 5,910 units August 6,890 units September 5,630 units October 5,210 units Required: a. The firm’s policy is to have finished goods inventory on hand at the end of the month that is equal to 70% of the next month’s sales. It is currently estimated that there will be 4,137 units on...
IV. The following are monthly actual and forecast demand levels for July thru December for units...
IV. The following are monthly actual and forecast demand levels for July thru December for units of a       product manufactured by the N. Tamimi Pharmaceutical Company: Month      Actual Demand    Forecast Demand July                           71                              78 August                    80                              75 September          101                           83 October                 84                              84 November            60                              88 December            73                              85 Compute a tracking signal and determine whether the forecasts are in control.
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....
The following are monthly actual and forecast demand levels for May through December for units of...
The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the D. Bishop Company in Des Moines:    Month Actual Demand Forecast Demand May 108 104 June 80 100 July 112 99 August 112 101 September 105 100 October 106 106 November 125 102 December 115 111 For the given forecast, the tracking signal = ___ MADs (round your response to two decimal places).
The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21...
The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21 March 15 April 14 May 13 June 16 July 17 August 18 September 20 October 20 November 21 December 23 Plot the monthly sales data. Forecast January sales using each of the following: Naive method. A 3-month moving average. A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. Exponential smoothing using...
The LaPann Company has obtained the following sales forecast data: July August September October Cash Sales...
The LaPann Company has obtained the following sales forecast data: July August September October Cash Sales $80,000 $70,000 $50,000 $60,000 Credit Sales $240,000 $220,000 $180,000 $200,000 The regular pattern of collection of credit sales is 30% in the month of sale and 70% in the month following the month of sale.  There are no bad debts. The budgeted accounts receivable balance on September 30th is: $126,000 $154,000 $161,000 $186,000
V had actual sales and purchases for July and August 2020 as given in the Excel...
V had actual sales and purchases for July and August 2020 as given in the Excel spreadsheet, along with its forecast sales and purchases for the period September 2020 through February 2021. The firm makes 30% of all sales for cash and collects 35% of its sales in each of the two months following the sale. Other cash inflows are expected to be $22,000 in September and February, $25,000 in November and January, and $37,000 in December. The firm pays...
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...
*******NOTE: I must be able to attach an **EXCEL** document with cell data to the assignment...
*******NOTE: I must be able to attach an **EXCEL** document with cell data to the assignment submission. More important than the answer is the step by step process on how to get these functions to work properly in **EXCEL**. Thank you!****** Using the given data set, please forecast future sales data using each method. Then, determine which method you prefer and why. GAP Data set: $M Year Quarter Period GAP 2012 Q1 1 $ 3,487 2012 Q2 2 $ 3,575...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT