ZuoTi.Pro
Question

2. The historical demand for a product is below Plese forcast the drmapr 300 (fid the company Month Profit in Year 20167 Sales (Use a 3-month simple moving z 23 (bUse a3month weighted moving average w 3 (March) March forecast 29 Find trend line and then foecast demand O p
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

a) Simple moving average= Sum of n Sales / n.

So (23+27+31) / 3 = 27

b) Weighted moving average: (weight %1 X Sales1) + (weight %2 X Sales2) + (weight %3 X Sales3)
Hence (0.6 X 23) + (0.3 X 27) + (0.1 X 31) = 24

c) March Actual Sale = 31 , a=0.8 ,March Forecast= 29

April Forecast = March forecast + a X (Actual Sales - March Forecast)
   = 29 + 0.8 (31-29)
   = 30.6

d) information missing. required value of Beta and trend of January

0 0
Add a comment
Know the answer?
Add Answer to:
2. The historical demand for a product is below Plese forcast the drmapr 300 (fid the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 2. The historical demand for a product is below. Please forecast the demand in April. Month...

    2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 © Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y=a+bx, and then forecast demand. (3 points)

  • 2. The historical demand for a product is below. Please forecast the demand in April. Month...

    2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 (c) Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y = a+bx, and then forecast demand. (3 points)

  • The historical demand for a product is as follows: Month Demand January 12 February 11 March...

    The historical demand for a product is as follows: Month Demand January 12 February 11 March 15 April 12 May 16 June 15 Stating any assumptions that you make answer the following questions. (i) Using a weighted moving average with weights of 0.60 for June; 0.30 for May and 0.10 for April, find the July forecast. (4 marks) (ii) Using a simple three-month moving average, find the July forecast. (4 marks) (iii) Using simple exponential smoothing with α=0,2 and a...

  • she e A O AoCE A Cd Aaßbo AabCc T H Rp E Question 4 (20%)...

    she e A O AoCE A Cd Aaßbo AabCc T H Rp E Question 4 (20%) Historical demand for a product is Demand January February 11 March 12 15 April May June 12 16 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 a 0.2 and a June forecast 13, find the July forecast....

  • nstructions You are responsible for creating the weekly forecast for Products X, Y, and Z for War Eagle Trading Company...

    nstructions You are responsible for creating the weekly forecast for Products X, Y, and Z for War Eagle Trading Company (WETCO). Create and evaluate forecasts as described in questions 1-10 below. Enter your answers in the table provided at the bottom of the assignment. All forecasts should be reported to the nearest whole number. Use the following in creating all forecasts: a7 W.6 n 3 W 3 Wa1 W 01 Demand for weeks 1-9 for each product is shown below....

  • Take Test: Ch 03-A4 QUESTION 3 Given is a historical time series for job services demand...

    Take Test: Ch 03-A4 QUESTION 3 Given is a historical time series for job services demand in the prior 6 months. Month Demand 1 635 2 754 3 706 4 618 725 6 745 The Period 5 forecast by using weighted moving average with weights of 0.05, 0.25, 0.40, and 0.30 decimal places) (in 2 3 points Save Answe Save All Answers Save and Submit 24

  • National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: MonthSales(000)UnitsFeb.15Mar.18Apr.12May.20Jun.23Ju1.23Aug -27b. Forecast September sales volume using each of the following: (1)A linear trend equation.(2) A five-month moving average. (3) Exponential smoothing with a smoothing constant equal to .25, assuming a March forecast of 17(000).(4) The naive approach. (5) A weighted average using.55 for August, .10 for July, and .35 for June.

  • The business analyst for Video Sales, Inc. wants to forecast yearly demand for DVD decoders based...

    The business analyst for Video Sales, Inc. wants to forecast yearly demand for DVD decoders based on the following historical data: Year 5 years ago 4 years ago 3 years ago 2 years ago Last year Demand 900 700 600 500 300 Question 12 (5 points) What is the forecast for this year using a three-year simple moving average? 420 510 467 300 650 What is the forecast for last year using simple exponential smoothing with smoothing constant alpha =...

  • Problem 3-2 National Scan, Inc., sells radlo frequency Inventory tags. Monthly sales for a seven-month period...

    Problem 3-2 National Scan, Inc., sells radlo frequency Inventory tags. Monthly sales for a seven-month period were as follows: Sales Month(ee)Units Feb Mar Apr May Jun Jul Aug 2e 23 25 18 28 30 b. Forecast September sales volume using each of the folloWng: (1 A linear trend equation.(Round your Intermedlate calculatlons and final answer to 2 declmal places.) Yt thousands (2) A five-month moVing average. (Round your answer to 2 declmal places.) Moving averagehousands (3) Exponentlal smoothing with a...

  • 1) A company has recorded the demand for a new type of tire for the last...

    1) A company has recorded the demand for a new type of tire for the last five months. Month 1 2 3 4 5 Demand ('00s) 14 17 19 23 24 a) Use a two month moving average to generate a forecast for demand in month 6. b) Apply exponential smoothing with a smoothing constant of 0.9 to generate a forecast for demand for demand in month 6. c) Which of these two forecasts do you prefer and why? 2)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT