Question: DEMAND FORCASTING WEIGHTED MOVING AVERAGE Lowes has found that in a four-month period, the best forecast to use in its electrical products area, is reached

DEMAND FORCASTING WEIGHTED MOVING AVERAGE

Lowes has found that in a four-month period, the best forecast to use in its electrical products area, is reached by using 40% of the actual sales for the most recent month, 30% of two months ago, 20% of sales three months ago, and 10% of actual sales four months ago. Find the forecast for the fifth and sixth months, if the actual demand is given to us.

Month 1 = 100 (actual sales) Month 2 = 90 (actual demand) Month 3 = 105 (actual demand) Month 4 = 95 (actual demand) Month 5 = 102 (actual demand)

F5 =

F6 =

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!

DEMAND FORCASTING - WEIGHTED MOVING AVERAGE Popeye's Chicken has found that in a four-month period, the best forecast methodology to use for its Ghost Pepper Wings, is reached by using 40% of the...

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...

Here is all the information provided with the answers to Q 1 and 2. If someone could please help me with 3 and 4. There is no more information or references provided other than what is above. 3) This...

Please answer all of those questions Just Born Scenario The Just Born company (http://www.justborn.com/) manufactures a variety of candies including Peeps. The original product (marshmallow chicks)...

The three major types of forecasts used by organizations in planning future operations are: A) strategic, tactical, and operational. B) economic, technological, and demand. C) exponential smoothing,...

In September 1954, using $500 to buy some basic equipment and a bicycle for deliveries, the Saputo family founded the company in Montreal bearing their name. Today, Saputo produces, markets, and...

QUESTION 1 Please download the attached Excel workbook, follow the instructions within, and enter resulting answers below. Answers should be to two decimals, unless otherwise indicated. Forecasting1:...

1. One of the reasons Wal-Mart is such an efficient firm is because they utilize cross-docking and thus decrease their inventory carrying cost. (Points: 2) True False 2. Because it cannot generate...

1. Throx sells higher-end custom-design socks in three-sock sets (rather than two). The company operates from a small packaging and distribution facility in Richmond, CA from which it ships product...

Statement of cash flows; investing and financing activities Refer to the situation described in BE 4-13. Prepare the cash flows from investing and financing activities sections of HHC's statement of...

You deposit $6,000 into an account that promises to pay you an annual interest rate of 5.5 percent for the next 6 years. You will leave the money deposited in the account and 10 years from today you...

1 2 - 1 1 REPL.ACEMENT ANALYSIS St . Johns River Shipyards is considering the replacement of an 8 - year - old riveting machine with a new one that will increase earnings from $ 2 4 , 0 0 0 to $ 4 6...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...