Forecasting: weighted moving average
Not what you're looking for?
Historical demand for a product is
DEMAND
January 12
February 11
March 15
April 12
May 16
June 15
a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.
b. Using a simple three-month moving average, find the July forecast.
c. Using single exponential smoothing with α = 0.2 and a June forecast = 13, find the July forecast. Make whatever assumptions you wish.
d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data.
e. Using the regression equation in d, calculate the forecast for July.
Thanks
Purchase this Solution
Solution Summary
Excel file shows a month's foretasted demand using:
a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.
b. Using a simple three-month moving average
c. single exponential smoothing
d. simple linear regression analysis
Purchase this Solution
Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Motivation
This tests some key elements of major motivation theories.