Question: 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

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!

owing table gives the number of units of bpe Ablood used at Woodlawn Hospital in the past 6 weeks The torecasted demand tor the week of October 12 using a 3.week movng average = pints (Round your...

01. The soft goods department of a large department store sells 175 units per month of a certain large bath towel. The unit cost of a towel to the store is $2.50 and the cost of placing an order has...

Final Project Assignment SCM 301 Overview of the Case Analysis We have discussed many concepts in SCM 301 related to planning, sourcing, making and delivering products and services. The purpose of...

NOTE 1: In creating spreadsheets, you are to apply the fundamental spreadsheet skills that you acquired in your previous spreadsheet classes. That is, you are to use relative and absolute...

Overview As part of the continued advancement of technology, a drone camera market has emerged in recent years. The drone camera market has been growing as more photography enthusiasts have begun...

heres my questions I hope you can give me the correct answers thankyouu The table below shows the demand for a particular brand of fax machine in a department store in each of the last twelve months....

Help me answer these questions please: 2) Please help me find the three week weighted moving average and Mean Squared Error of the table below 3) Help me compute the exponential smoothing forecasts...

1. To establish a driver education school, organizers must decide how many cars, instructors, and students to have. Costs are estimated as follows. Annual fixed costs to operate the school are...

Comprehensive Problem 9-1 Dr. Carol Harris, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335 and her birthdate is July 1,...

Design an electric circuit that contains T-attenuator that attenuates the = 18.7 volt 140 2 to 80%: (4 points) on the resistance load R

Suppose that there are 150 freshmen engineering majors at a college and each of them will take the same five courses next semester. Four of these courses will be taught in small sections of 25...

Recent cashflow results suggests that closer scrutiny of the accounts receivable policies are outdated and therefore require further evaluation. What steps would you take to improve cash flow related...

What is SQL DROP TABLE Statement??