Assume the weight is 0.6 for the most recent period; 0.2 for the second most recent; 0.1 for the third most recent; and 0.1 for the fourth most recent period. Using the four-period weighted moving average technique to predict the demand in February 2019. Find the X and Y values. DtFt PeriodDemandFour-period weighted Moving Average2014September9400 October10300 November11200 December4998 2015January98007209 February9555X March9800YGroup of answer choicesX = 9899.8; Y = 9778.2X = 9312.8; Y = 9555.2X = 9029.6; Y = 9312.8X = 9555.0; Y = 9313.7X = 9872.4; Y = 9029.4

YEAR PERIOD DEMAND FORECAST 2017 SEP 9400 OCT 10300 NOV 11200 DEC…

Answered: Assume the weight is 0.6 for the most…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Assume the weight is 0.6 for the most recent period; 0.2 for the second most recent; 0.1 for the third most recent; and 0.1 for the fourth most recent period. Using the four-period weighted moving average technique to predict the demand in February 2019. Find the X and Y values.

		Dt	Ft
	Period	Demand	Four-period weighted Moving Average
2014	September	9400
	October	10300
	November	11200
	December	4998
2015	January	9800	7209
	February	9555	X
	March	9800	Y

Group of answer choices

X = 9899.8; Y = 9778.2

X = 9312.8; Y = 9555.2

X = 9029.6; Y = 9312.8

X = 9555.0; Y = 9313.7

X = 9872.4; Y = 9029.4

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions