Question: B) Compute a 3- month moving average for months 4-9. IN TABLE BELOW (GO 2 Decimal places....ie.3.97; .8.49, etc.) Month Demand 3-month moving Abs Value

B) Compute a 3- month moving average for months 4-9. IN TABLE BELOW (GO 2 Decimal places....ie.3.97; .8.49, etc.) Month Demand 3-month moving Abs Value 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 9 C) Compute a 3- month weighted moving average for months 4-9 using the weights of .55, .33, .12 (with the most recent month first). IN TABLE BELOW (GO 2 Decimal places....ie.3.97; .8.49, etc.) Month Demand 3-month weighted Abs Value 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 9 What is the forecast for month 9:__________________ (GO 2 Decimal places....ie.3.97; .8.49, etc.) What is the MAD for the 3-month weighted moving average ______________ (GO 2 Decimal places....ie.3.97; .8.49, etc.) Which is more accurate based on MAD (moving or weighted moving)

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!

A rice dealer predicts the demand for the 12 th month using the actual sales (in tons) of last 11 months. The dealer subjectively used 0.40,0.30,0.30 respectively for the most recent, recent and...

Problem #1: (30 points) Fill out the following problem table and show full work for at least two of the months. Demand for Month Bulldozers Error 4MA Error 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 9 ? AE...

Chapter 151. The manager of the Carpet City outlet needs to make an accurate forecast of the demand for SoftShag carpet (its biggest seller). If the manager does not order enough carpet from the...

Linear Trend - Multiple Regression The average price per gallon of gasoline in major U.S. cities for each month during the years 1999-2001 are shown in the table below: Month 1999 2000 2001 January...

The objective of the Homework assignment is to provide an opportunity to apply or practice the tools and techniques covered in the course and to provide an opportunity to articulate key concepts...

appeso questions 1-3. Weekly sales of ballpeen hammers at a home improvement store have been 14.9,30, 22, 34, 12.19.23 over the past 8 weeks. The following table shows the forecasts for weeks 4, 5...

A milk vendor wants to predict the demand for the 11 th month using the actual sales of last 10 months. The manager subjectively used 0.40,0.30,0.30 respectively for the most recent, recent and...

The monthly sales for Yazici Batteries, Inc., were as follows: Feb Month Sales Jan 21 Mar 15 Apr May Jun 15 11 15 Jul 17 20 Aug Sept Oct 19 22 22 Nov 21 Dec 23 This exercise contains only parts and...

1. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on...

. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on a...

Using the force diagram, apply Newton's second law, and sum the torques to find the unknown forces. Since this is a static problem (no motion), both the net force and the net torque are zero. Part 3...

The marketing research organization GfK Roper conducts a yearly survey on consumer attitudes worldwide. They collect demographic information on the roughly 1500 respondents from each country that...

Can you please note and explain any differences between preparing this balance sheet in accordance with Generally Accepted Accounting Principles (GAAP) vs under International Financial Reporting...

What is SQL DROP TABLE Statement??