Question

The marketing department needs to forecast the number of complaints arising from a particular defect in...

The marketing department needs to forecast the number of complaints arising from a particular defect in a product. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is exponential smoothing accounting for seasonality with a smoothing constant of 0.75 and a previous forecast (with seasonality) of 390. Please round your forecast to the nearest whole number.

Jul 2020: 424 Jun 2020: 472 May 2020: 430 Apr 2020: 332 Mar 2020: 361 Feb 2020: 379
Jan 2020: 343 Dec 2019: 369 Nov 2019: 330 Oct 2019: 486 Sep 2019: 482 Aug 2019: 408
Jul 2019: 401 Jun 2019: 456 May 2019: 315 Apr 2019: 372 Mar 2019: 349 Feb 2019: 423
Jan 2019: 479 Dec 2018: 374 Nov 2018: 441 Oct 2018: 380 Sep 2018: 356 Aug 2018: 489
Jul 2018: 495 Jun 2018: 466 May 2018: 497 Apr 2018: 401 Mar 2018: 301 Feb 2018: 414
Jan 2018: 349 Dec 2017: 425 Nov 2017: 385 Oct 2017: 480

Homework Answers

Answer #1

Answer:

Exponential smoothing Forecast formula:

F (t+1)=                Ft+α(At-Ft)

Where,               

α = Smoothing constant = 0.75  

Ft = Forecast for immediate previous period      

At = Actual Demand for immediate previous period        

F (t+1) = Single exponential smoothing forecast for current period          

Forecast for previous period = Forecast for Oct 2017 = 390

Hence the forecast using Exponential Smoothing is as under:

Month and Year

Actual Number of defects
(At)

Forecast Number of defects
(Ft)

Oct-17

480

390

Nov-17

385

458

Dec-17

425

403

Jan-18

349

420

Feb-18

414

367

Mar-18

301

402

Apr-18

401

326

May-18

497

382

Jun-18

466

468

Jul-18

495

467

Aug-18

489

488

Sep-18

356

489

Oct-18

380

389

Nov-18

441

382

Dec-18

374

426

Jan-19

479

387

Feb-19

423

456

Mar-19

349

431

Apr-19

372

370

May-19

315

372

Jun-19

456

329

Jul-19

401

424

Aug-19

408

407

Sep-19

482

408

Oct-19

486

464

Nov-19

330

481

Dec-19

369

368

Jan-20

343

369

Feb-20

379

350

Mar-20

361

372

Apr-20

332

364

May-20

430

340

Jun-20

472

408

Jul-20

424

456

Smoothing constant = α =

0.75

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
A manufacturing area needs to forecast the number of people working. The data for several months...
A manufacturing area needs to forecast the number of people working. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is the linear regression accounting for seasonality. Please round your forecast to the nearest whole number. ul 2020: 81 Jun 2020: 85 May 2020: 95 Apr 2020: 83 Mar 2020: 93 Feb 2020: 85 Jan 2020: 97 Dec 2019: 92 Nov 2019:...
Given the following history, use a three-quarter moving average to forecast the demand for the third...
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec. JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC     Last year 165 185 200 230 240 265 210 200 195 265 290 315   This year 175 200 165 260 260 200   Forecast...
Use the data below to answer this questions. a.) Generate a scatter of the data b....
Use the data below to answer this questions. a.) Generate a scatter of the data b. ) Report the monthly averages (January for all years, February for all years etc.) c.) Is there seasonality? Is there a trend? d.) How can you forecast the value for March 2020? Generate that forecast. e.) (Not technical) This forecast will for sure be wrong. Why? Reference period Employment 3 Persons Jan-01 1,879.50 Feb-01 1,901.00 Mar-01 1,925.30 Apr-01 1,914.60 May-01 1,961.50 Jun-01 1,960.60 Jul-01...
Use the data below to answer this questions. Period Employment Jan-01 1,879.50 Feb-01 1,901.00 Mar-01 1,925.30...
Use the data below to answer this questions. Period Employment Jan-01 1,879.50 Feb-01 1,901.00 Mar-01 1,925.30 Apr-01 1,914.60 May-01 1,961.50 Jun-01 1,960.60 Jul-01 1,953.40 Aug-01 1,940.20 Sep-01 1,928.00 Oct-01 1,909.20 Nov-01 1,896.40 Dec-01 1,881.40 Jan-02 1,880.20 Feb-02 1,884.00 Mar-02 1,902.60 Apr-02 1,913.40 May-02 1,937.40 Jun-02 1,990.90 Jul-02 1,994.80 Aug-02 2,013.10 Sep-02 2,002.30 Oct-02 1,982.50 Nov-02 1,969.00 Dec-02 1,959.20 Jan-03 1,928.20 Feb-03 1,952.40 Mar-03 1,980.40 Apr-03 1,972.00 May-03 1,987.80 Jun-03 2,018.70 Jul-03 2,027.80 Aug-03 2,030.20 Sep-03 2,012.20 Oct-03 2,032.30 Nov-03 2,008.30...
FOR4. The Excel file Unemployment Rates provides data on monthly rates for 4 years. (8 pts)...
FOR4. The Excel file Unemployment Rates provides data on monthly rates for 4 years. (8 pts) a.         Develop 3- and 6-months moving average forecasts, and exponential smoothing forecasts (use alpha of your choice) b.         Using MAD as a criterion, explain which model yields better forecast? DATA: Unemployment Rates Year Month Rate (%) 2009 Jan 7.8 2009 Feb 8.3 2009 Mar 8.7 2009 Apr 9.0 2009 May 9.4 2009 Jun 9.5 2009 Jul 9.5 2009 Aug 9.6 2009 Sep...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date Return Jan-06 5.39 Feb-06 4.83 Mar-06 5.41 Apr-06 4.64 May-06 4.05 Jun-06 3.41 Jul-06 3.92 Aug-06 3.46 Sep-06 5.06 Oct-06 5.44 Nov-06 4.96 Dec-06 4.17 Jan-07 3.48 Feb-07 4.7 Mar-07 4.38 Apr-07 3.82 May-07 4.19 Jun-07 4.35 Jul-07 3.83 Aug-07 5.42 Sep-07 3.29 Oct-07 4 Nov-07 3.42 Dec-07 3.24 Jan-08 5.21 Feb-08 4.84 Mar-08 4.59 Apr-08 3.82 May-08 3.61 Jun-08 4.34 Jul-08 4.94 Aug-08...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date Return Jan-06 3.13 Feb-06 4.15 Mar-06 3.18 Apr-06 4.94 May-06 4.34 Jun-06 4.19 Jul-06 5.12 Aug-06 5.26 Sep-06 3.81 Oct-06 3.1 Nov-06 3.87 Dec-06 4.89 Jan-07 3.94 Feb-07 3.42 Mar-07 4.13 Apr-07 3.54 May-07 4.58 Jun-07 4.19 Jul-07 4.62 Aug-07 3.89 Sep-07 3.62 Oct-07 3.92 Nov-07 4.46 Dec-07 3.23 Jan-08 4.78 Feb-08 4.71 Mar-08 5.05 Apr-08 3.46 May-08 3.15 Jun-08 4.82 Jul-08 3.87 Aug-08...
Year Month Return Year Month Return 2006     Jan 3.95 2008     Jul 3.29 2006     Feb 3.77 2008...
Year Month Return Year Month Return 2006     Jan 3.95 2008     Jul 3.29 2006     Feb 3.77 2008     Aug 4.62 2006     Mar 5.29 2008     Sep 4.81 2006     Apr 3.77 2008     Oct 5.16 2006     May 4.47 2008     Nov 3.69 2006     Jun 5.2 2008     Dec 5.15 2006     Jul 3.9 2009     Jan 5.29 2006     Aug 4.33 2009     Feb 3.19 2006     Sep 4.41 2009     Mar 3.89 2006     Oct 5.14 2009     Apr 4.48 2006     Nov 3.24 2009     May 5.27 2006     Dec 4.13 2009     Jun 3.93 2007     Jan...
Rounded to the nearest whole number, what is the standard deviation for Google weekly closing prices...
Rounded to the nearest whole number, what is the standard deviation for Google weekly closing prices from December 12, 2008 to December 4, 2009?   4-Dec-09 585.01 27-Nov-09 579.76 20-Nov-09 569.96 13-Nov-09 572.05 20-Nov-09 551.1 30-Oct-09 536.12 23-Oct-09 553.69 16-Oct-09 549.85 9-Oct-09 516.25 2-Oct-09 484.58 25-Sep-09 492.48 18-Sep-09 491.46 11-Sep-09 472.14 4-Sep-09 461.3 28-Aug-09 464.75 21-Aug-09 465.24 14-Aug-09 460 7-Aug-09 457.1 31-Jul-09 443.05 24-Jul-09 446.72 17-Jul-09 430.25 10-Jul-09 414.4 2-Jul-09 408.49 26-Jun-09 425.32 19-Jun-09 420.09 12-Jun-09 424.84 5-Jun-09 444.32 29-May-09 417.23...
A local bookstore recorded their revenue (in thousands) for the last 36 months starting in September,...
A local bookstore recorded their revenue (in thousands) for the last 36 months starting in September, as provided below. a. find the deseasonalized line of best fit b. use the additive model of seasonal forecasting to predict the revenue for each month of the next academic year c. use the multiplicative model of seasonal forecasting to predict the revenue for each month of the next academic year d. what is the predicted total profit for the academic year for each...