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

  • Historical demand for a product is as follows: DEMAND April 59 May 54 June 74 July...

    Historical demand for a product is as follows: DEMAND April 59 May 54 June 74 July 59 August 79 September 74 a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.) Forecast for October             b. Using single exponential smoothing with α = 0.30 and a September forecast = 64, calculate a forecast for October. (Round your answer to 2 decimal places.) Forecast for October             c. Using simple linear regression,...

  • Given is a historical time series for job services demand in the prior 6 months. Month...

    Given is a historical time series for job services demand in the prior 6 months. Month Demand 1 625 2 734 3 711 4 603 5 668 6 785 The Period 6 forecast by using weighted moving average with weights of 0.05, 0.25, 0.40, and 0.30 = (in 2 decimal places)

  • The owner of At the Beach is forecasting this month's (October's) demand for a new tanning...

    The owner of At the Beach is forecasting this month's (October's) demand for a new tanning booth based on the historical data given below. Month Number of Visits April 100 May 140 June 110 July 150 August 120 September 160 a) What is this month’s forecast using the naïve approach? b) What is this month’s forecast using a three-month simple moving average? c) What is this month's forecast using a four-month weighted moving average with weights of .4, .3, .2,...

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

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