Question: 14 15 Q1 A product has a consistent year round demand. You are the planner and have been tasked with 16 experimenting with some time

14 15 Q1 A product has a consistent year round demand. You are the planner and have been tasked with 16 experimenting with some time series analysis. Using this previous weekly demand, calculate the 17 following forecasts for each period possible. A) Two - Period Simple moving average B) 3 Period 18 Weighted moving average using weights of .6, .3,.1, C) Four-period weighted moving average 19 with weights of .4,.3,.2,.1 and D) Exponential Smoothing forecast using an Alpha of .15 and a 20 Week 1 forecast of 2000 units. Round all forecasts to whole numbers. 21 22 Week Demand SMA WMA WMA EXP Sm .15 23 2240 2 Period .6, .3, .1 .4,.3,.2,.1 2000 24 2 2360 25 3 2208 26 4 2415 27 5 2395 28 6 2155 29 7 2190 30 8 2288 31 9 2390 32 10 2405 33 11 2305 34 12 2210

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 Mathematics Questions!

answer and formulas needed 3 4 5 6 7 8 By uploading this assignment, I affirm that I have not given or received any unauthorized help and that all work submitted is my own. I have abided by Seneca's...

Please solve it AutoSav Review View Draw Page Layout Formulas Data Home Insert ab General V 12 " A" A E x Delete v Calibri (Body) Conditional Format Cell $ ~ % 9 68 98 Formatting as Table Styles...

In you need to edit afer to stay in Protected Vir Enable ting 826 02 AA 1 H 2 Student Name: 3 Student Number: 4 5 Q1 A product has a consistent year round demand. You are the planner and have been...

Please fill solve all SMA WMA etc extBox 2 4 X V fx H K A B C D E F G student Name: By submitting this assignm any unauthorized help, and Student Number: The college's definition of In order to get...

Q1 A product has a consistent year round demand. You are the planner and have been tasked with experimenting with some time series analysis. Using this previous weekly demand, calculate the following...

ques 1 and 2 AutoSave OFF --- 2 Exc Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 12 ' Wrap Text IG U bli Paste BIU aA Merge & Centre F37 fx B C D G H Q1 A product has...

X Calibri (Body) 11 ' ' General 25 Wrap Tout v Merge Center Parte BIU O a A SEE $ %) 33 x vf D F G Student Name: Student Number: Q1 A product has a consistent year round demand. You are the planner...

What deductions and tax credits do these three qualify for? Descriptions are below So far I have Ji I have: Mortgage Interest Deduction Charitable Donations Deduction Medical Expenses Deduction...

This chapter discusses several benefits that can result when you are faced with an interpersonal conflict. Describe an interpersonal conflict you have experienced and explain which of these benefits...

On July 1 , Shady Creek Resort borrowed $ 3 4 0 , 0 0 0 cash by signing a 1 0 - year, 8 % instaliment note requiring equal payments each June 3 0 of $ 5 0 . 6 7 0 . What amount of interest expense...

For internal uses, managers are more concerned with receiving Information that achieves which of the following standards? 1) Completely objective and verifiable. 2) Completely accurate and precise....