Question: using the data below, calculate the weighted moving average for June and July. Most recent is weighted at .4;second most recent at .3; third most

using the data below, calculate the weighted moving average for June and July. Most recent is weighted at .4;second most recent at .3; third most recent at .2; and fourth most recent at .1

month	actual	forecast
January	2500
February	2600
March	4800
April	6800
May	7500
June	10500
July

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!

On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and...

1. Using the data below, calculate the weighted moving average for June and July. Most recent is weighted at .4;second most recent at .3; third most recent at .2; and fourth most recent at .1 2....

please answer 6,7,8 QUESTION 6 See chapter 18, page 477, problem 6 . Complete the forecasts using the exponential smoothing method with 02. What is the MAD (mean absolute devation of the forecasts...

Q1. A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data. (To receive full credit, please write the formulae for all the...

Natalies Cupcake store has decided to calculate a weighted moving average forecast for October for one of their flavors of cupcakes. After detailed research and analysis, she decided to use 0.4 for...

1. Use the data from Bodville General Hospital for the past 5 years below. You are the hospital's manager, and are considering the best forecasting methods. Accordingly, you need to calculate the...

See chapter 1 8 , problem 1 5 a . What is the July forecast? ( using a weighted moving average with weights 0 . 6 for most recent month, 0 . 3 for the next, and 0 . 1 for the third most recent month...

QUESTION 7 See chapter 18, problem 15 a. What is the July forecast? (using a weighted moving average with weights 0.6 for most recent month, 0.3 for the next, and 0.1 for the third most recent month)...

You are the manager of a college library, and you need to forecast the number of students who will visit the library tomorrow. You have the data for the number of students who visited the library...

Question 8 4 out of 4 points Correct Calculate a weighted moving average forecast for period 6 , using the following data: Weights: use . 5 as weight for most recent demand, use . 3 , as weight for...

1- calculate a weighted moving average forecast for period 6, using the following data: weights: use 5 as weight for most recent demand, use 3, as weight for next most recent demand and use 2 as...

We discussed the inventory and supply chain considerations such as small lot sizes, dose supplier ties, and quality at the source In Chapter, Lean Systems. What are the implications of these...

Assume that as part of the asset transformation process a bank takes in short term deposits with a maturity less than one year and transforms it into a 30 year mortgage loan to a customer. Is this...

The three major components in any transaction processing system include data, a decision - making model, and a user interface. 5 0 True or False 0 0 . 4 6 . 4 4 Prev 6 0 of 8 0 Next

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...