Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Create a moving average table for 3-month average and 5-month average Orders for 10-month period Month Orders Delivered per Month 3MA 5MA January 120 February 90 March 100 April 75 May 110 June 50 July 75 130 110 90 August September October November 1. Find 3-month moving average for the next (each) month (above table) 2. Find 5-month moving average for the next (each) month (above table) Weighted moving average Compute the weighted average forecast using the following weigts: 0.3, 0.2, 0.4, and 0.1 For example, if the Instant Paper Clip Supply Company wants to compute a 3-month weighted moving average with a weight of 50% for the October data, a weight of 33% for the September data, and a weight of 17% for August: WMA, = ΣW;D where => W = the weight for period i, between 0% and 100% (i.e., between 0 and 1.0) ΣW; = 1.00 WMA= What is the 3-month weighted moving average taking into consideration above weights assigned Your answer Solve proble and create line graph similar to the sample tabsheet

Create a moving average table for 3-month average and 5-month average Orders for 10-month period Month Orders Delivered per Month 3MA 5MA January 120 February 90 March 100 April 75 May 110 June 50 July 75 130 110 90 August September October November 1. Find 3-month moving average for the next (each) month (above table) 2. Find 5-month moving average for the next (each) month (above table) Weighted moving average Compute the weighted average forecast using the following weigts: 0.3, 0.2, 0.4, and 0.1 For example, if the Instant Paper Clip Supply Company wants to compute a 3-month weighted moving average with a weight of 50% for the October data, a weight of 33% for the September data, and a weight of 17% for August: WMA, = ΣW;D where => W = the weight for period i, between 0% and 100% (i.e., between 0 and 1.0) ΣW; = 1.00 WMA= What is the 3-month weighted moving average taking into consideration above weights assigned Your answer Solve proble and create line graph similar to the sample tabsheet

A Guide to SQL
A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter6: Updating Data
Section: Chapter Questions
Problem 4SCG
See similar textbooks
icon
Related questions
Question

 

• Solve the problem (pls refer to the inserted image) and create line graph.

Create a moving average table for 3-month average and 5-month average Orders for 10-month period Month Orders Delivered per Month 3MA 5MA January 120 February 90 March 100 April 75 May 110 June 50 July 75 130 110 90 August September October November 1. Find 3-month moving average for the next (each) month (above table) 2. Find 5-month moving average for the next (each) month (above table) Weighted moving average Compute the weighted average forecast using the following weigts: 0.3, 0.2, 0.4, and 0.1 For example, if the Instant Paper Clip Supply Company wants to compute a 3-month weighted moving average with a weight of 50% for the October data, a weight of 33% for the September data, and a weight of 17% for August: WMA, = ΣW;D where => W = the weight for period i, between 0% and 100% (i.e., between 0 and 1.0) ΣW; = 1.00 WMA= What is the 3-month weighted moving average taking into consideration above weights assigned Your answer Solve proble and create line graph similar to the sample tabsheet
Transcribed Image Text:Create a moving average table for 3-month average and 5-month average Orders for 10-month period Month Orders Delivered per Month 3MA 5MA January 120 February 90 March 100 April 75 May 110 June 50 July 75 130 110 90 August September October November 1. Find 3-month moving average for the next (each) month (above table) 2. Find 5-month moving average for the next (each) month (above table) Weighted moving average Compute the weighted average forecast using the following weigts: 0.3, 0.2, 0.4, and 0.1 For example, if the Instant Paper Clip Supply Company wants to compute a 3-month weighted moving average with a weight of 50% for the October data, a weight of 33% for the September data, and a weight of 17% for August: WMA, = ΣW;D where => W = the weight for period i, between 0% and 100% (i.e., between 0 and 1.0) ΣW; = 1.00 WMA= What is the 3-month weighted moving average taking into consideration above weights assigned Your answer Solve proble and create line graph similar to the sample tabsheet
Expert Solution
steps

Step by step

Solved in 2 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
SEE MORE TEXTBOOKS