Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I can't seem to figure out what I'm doing wrong for exponential smoothing. I've attached my excel number/work. 37 The following data are monthly sales

I can't seem to figure out what I'm doing wrong for exponential smoothing. I've attached my excel number/work.

image text in transcribedimage text in transcribedimage text in transcribed

37 The following data are monthly sales of jeans at a local department store. The buyer would like to forecast sales of jeans for the next month, July. Month Sales January February 35 March April 38 May June 45 42 48 (a) Your answer is partially correct. Forecast sales of jeans for March through June using the naive method, a two-period moving average, and exponential smoothing with an a = 0.1. (Round answers to 1 decimal place, e.g. 15.2.) 2-Period Moving Exponential Month Sales Nave Forecast Average Smoothing January 37 February 35 March 42 35 36 5.2 April 38 42 38.5 0.7 May 48 38 40 10.6 June 45 48 43 38.4 0.1 alpha (a)= Moving average year sales nave forecast moving average smoothing 37 35 42 2 A1-F1 (Nave) 37 - 37 35 42 jan feb march april may june 7 2 0 4 10 a1-f1 37 37 36.8 37.32 37.388 38.4492 37 36 38.5 40 43 smoothing 0 -2 5.2 0.68 10.612 -38.4492 0 2 5.2 0.68 38 48 4 10 38 48 10.612 38.4492 45 3 3 alpha (a)= sales A1-F1 (Nave) Moving average 0.1 moving average year jan feb nave forecast =C8 37 35 42 -C8 =C9 march april may june =ABS(C9-09) =E21 =ABS(C11-D11) =ABS(C12-D12) =ABS(C13-D13) 38 smoothing =D8 =H8+($G$6*$1$8) =H9+($G$6*$1$9) =H10+($G$6*$I$10) =H11+($G$6*$I$11) =H12+($G$6*$I$12) =AVERAGE(D8:09) =AVERAGE(D9:010) =AVERAGE(D10:011) =AVERAGE(D11:012) =AVERAGE(D12:013) al-f1 =C8-H8 =C9-H9 =C10-H10 =C11-H11 =C12-H12 =C113-H13 =ABS(C9-09) =ABS(C10-D10) -ABS(C11-D11) =ABS(C12-D12) =ABS(C13-D13) smoothing =ABS(18) =ABS(19) =ABS(110) =ABS(111) =ABS(112) =ABS(113) =C10 =C11 =C12 48 45

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Principles

Authors: Howard F. Stettler

3rd Edition

0130521183, 9780130521187

More Books

Students also viewed these Accounting questions

Question

Question 1 (a2) What is the reaction force Dx in [N]?

Answered: 1 week ago