ZuoTi.Pro
Question

Using exponential smoothing of the data, forecast the sales for the month of July. actual sale:...

Using exponential smoothing of the data, forecast the sales for the month of July. actual sale: March 1,210 April 1,280, May 1,260 June 1,275

Forecast April 1,240

Alpha 0.20

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1
Period Actual [A(t)]
March 1210
April 1280
May 1260
June 1275
F(t) = F(t-1) + α [A(t-1) - F(t-1)]
Period Exponential Forecast [F(t)]
F(t-1) + α [A(t-1) - F(t-1)]
April Given = 1240
May 1240 + 0.20 [1280 - 1240] = 1248
June 1248 + 0.20 [1260 - 1248] = 1250
July 1250 + 0.20 [1275 - 1250] = 1255
Therefore, As per the Exponential Forecast, Sales for July is 1255
0 0
Add a comment
Know the answer?
Add Answer to:
Using exponential smoothing of the data, forecast the sales for the month of July. actual sale:...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Please help. Im stuck on the exponential smoothing part of this problem. Here are the actual...

    Please help. Im stuck on the exponential smoothing part of this problem. Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 110 February 130 March 150 April 170 May 160 June 180 July 140 August 130 September 140 a. Forecast April through September using a three-month moving average. (Round your answers to 1...

  • 1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100...

    1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100 February 200 March 150 April 400 May 300 June 200 July 250 August 350 September 400 October 350 November 400 December 500 a. 150.0 b. 477.3 c. 450.0 d. Not enough information is given to make a forecast 2. Apply regression to the data shown below. The slope of the line estimated using the regression model is: Sales January 100 February 200 March 150...

  • Actual sales of TV's for the first six month in 2021 were as follows: January      60           ...

    Actual sales of TV's for the first six month in 2021 were as follows: January      60            February     80          March   42 April           68            May             44           June     72 Use this information and determine in whole numbers: 1 The average actual monthly sales for that period          2 Trends: Reduce this average by 6% per month for the next three months    3 Simple Moving Average (SMA): make a forecast for July using a three months simple moving average.        4 Weighted Moving Average (WMA): make...

  • Use Exponential smoothing with alpha=0.3 to forecast the sales for 2015 using the data given below...

    Use Exponential smoothing with alpha=0.3 to forecast the sales for 2015 using the data given below (Use two decimal points): 2012 194 2013 169 2014 175 ans: _______________

  • Here are the actual tabulated demands for an item for a nine-month period (January through September)....

    Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 110 February 130 March 150 April 170 May    160 June      180 July    140 August 130 September 140 A. Forecast April through September using a three-month moving average. B. Use simple exponential smoothing with an alpha of 0.3 to estimate April through...

  • Use Exponential smoothing with alpha=0.3 to forecast the sales for 2015 using the data given below...

    Use Exponential smoothing with alpha=0.3 to forecast the sales for 2015 using the data given below (Use two decimal points): 2012 154 2013 195 2014 169 I HAVE 8 MINUTES TO ANSWER THIS PLEASE!!

  • Predict Inc., is using a simple exponential smoothing model to forecast their monthly sales but they...

    Predict Inc., is using a simple exponential smoothing model to forecast their monthly sales but they are not sure of the best alpha value to use. They ran some computerized forecasts with different alpha values and reported the following. What alpha value should they use? alpha 0.15 0.20 0.25 0.30 0.35 0.40 0.45 0.50 MAD 18.4 14.7 13.2 16.2 15.3 11.7 10.2 12.5 Group of answer choices 0.45 0.15 0.2 0.35 0.5

  • A small Italian restaurant wants to forecast pepperoni pizza sales. Actual sales and forecasts for the...

    A small Italian restaurant wants to forecast pepperoni pizza sales. Actual sales and forecasts for the past several months are shown below. The owner prefers to use an exponential smoothing forecasting model with αλπηα&νβσπ; = 0.30. What would be the exponential smoothing forecast for June? Period Demand Forecast April 500 480 May 476 June 503

  • Use the following sales data to answer the questions. Month                              Sales January&nbsp

    Use the following sales data to answer the questions. Month                              Sales January                              $250,000 February                            $200,000 March                               $300,000 April                                  $350,000 May                                   $450,000 Using a two month moving average, what are the expected sales for June? Using a three month moving average, what are the expected sales for June? Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six months are shown below, along with the results of two different...

  • John Taylor Salons want to forecast monthly customer demand from June through August using trend ...

    Using Excel John Taylor Salons want to forecast monthly customer demand from June through August using trend adjusted exponential smoothing. Given alpha (a) 0.20, Beta (B) -0.40, the Forecast for May 45 (FMay-45) customers, and the trend for May 0 (Tmay-0), forecast a FIT (forecast including trend) for the months of June through August. 3. Month Actual Sales May June July August 50 61 73 80 Jay Sharp Guard wants to compare the accuracy of two methods that it has...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT