INFO300:11-ntegrated Core: Operations Management Mohammad Odeh11/2/17 7:57 PM Te

Question

INFO300:11-ntegrated Core: Operations Management Mohammad Odeh11/2/17 7:57 PM Test: Exam 1-INFO300 - FA17 - Extra Credit Submit Test This Question: 1 pt 2012(2complete) This Test: 2 pts possible The monthly sales for Yazici Bateries, Inc., were as folows Month Jan Feb Mar Apr May JunAug SeptOct Nov Dec 1 20 12 1316 15 19 22 22 21 22 This exercise contains only parts b and c. b)The forecast for the next month (Aan) using the naive methods| sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach- saies round yourresponse the0dcnr paces. The forecast for the next period (Jan) using a 6-month weighted average with weights o 0.10, 010, 0.10, 0.20,0.20, and 0.30, where the heaviest woights are applied to the most recent monthsales (round your response to one decimal place) Using exponential smoothing with #040 and a September forecast of 21.00, the fo ocast for the next period Jan " sales round your usponse to todo mal paces Using a method of trend projection, the forecast for the next month (Jan)sales (round your response to two dlecimal places) c) The method that can be used for making a forecast for the month of March is Enter your answer in each of the answer boxes

Explanation / Answer

Answer 4:-

Month Sales Forecast

Sep

22

21

Oct

22

21.4

Nov

21

21.64

Dec

22

21.38

The formula for the exponential smoothening is as below:-

Ft = Ft-1 +(At-1-Ft-1)

In the question ,

Ft-1 =21

At-1=22

=0.4

For Oct:-

Ft = 21+ 0.4(22-21) =21.4

For Nov:-

Ft =21.4+0.4(22-21.4) =21.64

For Dec:-

Ft =21.64+0.4(21-21.64) =21.38

For Jan:-

Ft =21.38+0.4(22-21.38) =21.63

So forecast for Jan =21.63

Month Sales Jan 19 Feb 20 Mar 17 Apr 12 May 13 Jun 16 Jul 15 Aug 19 Sep 22 Oct 22 Nov 21 Dec 22 Answer 1:- Naïve Method:- The sales of the last month is equal to the forecast of the next month. Thus the foecast of the next month will be = 22 Answer 2:- 3 month moving averge = (22+21+22)/3 = 21.67 Answer 3:- 6 month weighted average = 15*0.1+19*0.1+22*0.1+22*0.2+21*0.2+22*0.3 = 20.8

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---