Dell computers sells laptops Table 1 presents the 12 month sales for the year 2017 (10 points) Month Sales (in thousands) Jan 10 Feb 8 Mar 12 Apr 15 May 18 Jun 16 Jul 12 Aug 14 Sep 19 Oct 21 Nov 11 Dec 18 Forecast Jan 2018 sales using (1) five period moving average (2) A four period weighted moving average with weights 0 3 for Dec, 0 3 for Nov, 0 2 for Oct, 0 2 for Sep (3) Exponential smoothing with smoothing constant 0 3, assuming a Aug forecast 15

The Answer is in the image, click to view ...

Question: Dell computers sells laptops. Table 1 presents the 12 month sales for the year 2017 (10 points). Month Sales (in thousands) Jan 10 Feb 8

Dell computers sells laptops. Table 1 presents the 12 month sales for the year 2017 (10 points).

Month	Sales (in thousands)
Jan	10
Feb	8
Mar	12
Apr	15
May	18
Jun	16
Jul	12
Aug	14
Sep	19
Oct	21
Nov	11
Dec	18

Forecast Jan 2018 sales using: (1) five period moving average; (2) A four period weighted moving average with weights 0.3 for Dec, 0.3 for Nov, 0.2 for Oct, 0.2 for Sep; (3) Exponential smoothing with smoothing constant 0.3, assuming a Aug forecast 15.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Dell computers sells laptops. Table 1 presents the 12 month sales for the year 2017 . Month Sales (in thousands) Jan 10 Feb 8 Mar 12 Apr 15 May 18 Jun 16 Jul 12 Aug 14 Sep 19 Oct 21 Nov 11 Dec 18...

Dell computers sells laptops. Table 1 presents the 12 month sales for the year 2017 (10 points). Month Sales (in thousands) Jan 10 Feb 8 Mar 12 Apr 15 May 18 Jun 16 Jul 12 Aug 14 Sep 19 Oct 21 Nov 11...

Dell computers sells laptops. Table 1 presents the 1 2 month sales for the year 2 0 1 7 . Forecast Jan 2 0 1 8 sales using: ( 1 ) five period moving average; ( 2 ) A four period weighted moving...

Dell computers sells laptops. Table 1 presents the 12 month sales for the year 2017. Month Sales (in thousands) Jan 10 Feb 8 Mar 12 Apr 15 May 18 Jun 16 Jul 12 Aug 14 Sep 19 Oct 21 Nov 11 Dec 18...

I need help with my homework! it's my fourth time to post this question! if possible, please include explanation. Given checkpoint: Budgeted income statement==>> Jan 2018 net income/loss is (2,800)!...

I need help with questions 3D&E, 4C, 5D&E, and 6-11. Thank you! Cost of Capital 54 ACE REPAIR, INC. Directed In 1978, while he was taking a course on entrepreneurship as a business student at a large...

Please answer both questions Worked Problems (Show your calculations in order to get full credit) 1. Favors Distribution Company purchases small imported trinkets in bulk, packages them, and sells...

Questions JPEG 1) Calculate (a) MAD, (b) MSE, and (c) MAPE for the following forecast versus actual sales figures. (Please round to four decimal places for MAPE.) Actual Forecast Error Abs(error)...

Worked Problems (Show your calculations in order to get full credit) 1. Favors Distribution Company purchases small imported trinkets in bulk, packages them, and sells them to retail stores. They are...

Propose structures for compounds that fit the following descriptions: (a) C 10 H 14 H NMR: 7.18 (4 H, broad singlet); 2.70 (4 H, quartet, J = 7 Hz); 1.20 (6 H, triplet, J = 7 Hz) IR: 745 cm 1 (b)...

The three typical accounting events associated with borrowing money through a bond issue are 1. Exchanging the bonds for cash on the day of issue. 2. Making cash payments for interest expense and...

Patient is to receive 1,000 units/hr of heparin using the infusion pump. On hand is 25,000 units heparin in 500 mL of D5W. Calculate how you will set the pump

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...