This Question: 15 pts 2017 (0 complete) This Quiz: 100 pts possible NewThe month

Question

This Question: 15 pts 2017 (0 complete) This Quiz: 100 pts possible NewThe monthly sales for Yazici Batteries, Inc., were as follows Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 20 20 17 15 1116 16 1922 21 23 24 This exercise contains only parts b and c b) The forecast for the next month (Jan) using the naive method-sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach-I sailes (round your response to two decimal places) recent monthsales (round your response to one decimal place) Using exponential smoothing 6 The forecast for the next period (Jan) using a 6-month weighte d average with weights of 0.10. 0,10, 0 10, 0 20, 0.20, and 0.30, where the heaviest weights are applied to the most forecast of 21.00, the forecast for the next period (Jan)- sales (round your response to two decimal places) Jan)-, sales round your response to two 8 with = 0.30 and a September forecast of 21.00, the forecast for the next period using a method of trend projection, the forecast for the next month (Jan) - Ill sales (round your response to two decimal L1c) The method that can be used for making a forecast for the month of Marchis 9 Enter your answer in each of the answer boxes. Show All weingarten2.swf QM 352 Grade Projec. .xlsx .

Explanation / Answer

b) from naive method forecast =Dec month actual =24

3 month moving average =(21+23+24)/3 =22.67

6 month weighted average forecast =(0.3*24+0.2*23+0.2*21+0.1*22+0.1*19+0.1*16)=21.70

exponential smoothing forecast:

January forecast =22.42

please revert for option given in part C)

sales forecast January 20 February 20 March 17 April 15 May 11 June 16 July 16 August 19 September 22 21.00 October 21 21.30 November 23 21.21 December 24 21.75 January 22.42

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.