Question: Use the data in this table to answer the below questions Month SMA Actual Demand 36 WMA 1 2 3 38 40 41 4 5

Use the data in this table to answer the below questions Month SMA Actual Demand 36 WMA 1 2 3 38 40 41 4 5 44 38 39.7 ?? 38.8 40.2 ?? 6 48 1. Calculate 3 months Simple Moving Average forecast for Month 2. Calculate the Weighted Moving Average Forecast for Month 6. 3. Calculate the Mean Absolute Deviation (MAD) for both Simple 4. Which method do you recommend? Why? (1 mark) For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). B B I y S Paragraph Arial V recast for Month 6 (1 mark) cast for Month 6. assume the weight of the most recent month is 0.6, two for both Simple Moving Average and Weighted Moving Average (2 mark- mark) Mac). > al 14px iii ili A most recent month is 0.6, two months ago 0.2. three months ago 0.2 (1 mark) ted Moving Average (2 marks) a 6 Ix% v A

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!

ID Salary Compa Midpoint Age 1 2 4 5 6 9 12 16 19 21 25 27 29 30 32 33 34 38 40 41 44 46 47 49 50 3 7 8 10 11 13 14 15 17 18 20 22 23 24 26 28 31 35 36 37 39 42 43 45 48 60.3 27.2 61 47.7 76 74.3...

production planning and control the data is used for this project is : a) Apply forecasting to help predicting the future demand. (No limitation, use your engineering sense) b) Develop materials...

the data for this project is: Due Aug 13th, 2020 The goal of the project is to allow you to implement appropriate tools and methods in production planning and inventory management. The project should...

1 2 3 4 7 8 9 12 13 14 15 16 17 18 19 20 21 22 23 24 28 29 30 31 38 40 41 44 47 48 49 50 51 62 63 64 66 67 68 69 70 71 73 74 76 77 78 79 80 81 82 85 86 87 88 89 90 91 92 93 94 95 99 100 101 104 105...

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...

AGEC 440 Homework #3 100 Points Available This Homework Will Use the Homework 3 Excel Data Sheet (Data Tab) Please carry any decimals out two places if numbers are involved in your answer. 1....

EFB106 COST AND BENEFIT ANALYSIS FOR PROJECT APPRAISAL Assessment Item 1: Sensitivity Analysis Online resource: http://www.cbabuilder.co.uk/ CBA Builder Excel Tool:...

using the table below answer the following questions (you can use R or SAS): - is height useful in explaining our data set? (individual f test) - is there multicollinearity between weight and other...

ID Salary Compa Midpoint Age Performance Service Gender Rating ID Salary Compa Midpoin t Age 12 14 15 16 17 18 25 26 27 28 29 31 34 35 36 37 39 40 41 42 43 45 48 49 50 1 2 3 4 5 6 7 8 9 10 11 13 19...

PLEASE READ - This question has been incorrectly answered multiple times and the experts keep coping and pasting the old responses. Please do not copy and paste from the prior question. For question...

What is the dollar amount you need to invest every year, starting at age 26 and ending at age 65 (40 years) to reach the target lump sum at age 65? The target lump sum is $6,094,321.50.

How does the personality of a spokesperson used in advertising help shape the emotional benefits of a product?

Sixty - five financan of ales ill business cite les are access to credit as her primary reasonfor their financial struggles. If four small businesses are surveyed, what is the probability none of...

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...