Question

In: Operations Management

Historical demand for a product is: DEMAND January 20 February 19 March 23 April 20 May...

Historical demand for a product is:

DEMAND

January 20

February 19

March 23

April 20

May 24

June 23

a. Using a weighted moving average with weights of 0.40 (June), 0.40 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.) July forecast

b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) July forecast

c. Using single exponential smoothing with ? = 0.30 and a June forecast = 14, find the July forecast. (Round your answer to 1 decimal place.) July forecast

d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data. (Do not round intermediate calculations. Round your intercept value to 1 decimal place and slope value to 2 decimal places.) Y = + t

e. Using the regression equation in d, calculate the forecast for July. (Do not round intermediate calculations. Round your answer to 1 decimal place.) July forecast

Solutions

Expert Solution

  1. Weighted moving average for July

= 0.40 x Demand for June + 0.4 x demand for May + 0.2 x demand for April

= 0.40 x 23 + 0.40 x 24 + 0.2 x 20

= 9.2 + 9.6 + 4

= 22.8

  1. Forecast for July using 3 month moving average

= ( Demand April + Demand May + Demand June) /3

= ( 20 + 24 + 23 ) / 3

= 22.33

  1. Forecast for July using exponential smoothing

= 0.30 x Demand June + ( 1 – 0.30) x Forecast June

= 0.3 x 23 + 0.7 x 14

= 6.9 + 9.8

= 16.7

  1. Let Y = a + b.t

Where,

Y ( Dependent variable ) = Forecasted demand

T = serial number of month ( e.g January = 1 , February = 2 , March = 3 , April = 4 , May = 5 , June = 6 etc )

We place all the data of month and demand in 2 adjacent columns excel and apply the formula LINEST ( ) to arrive at values of A and B.

Accordingly values of A and B are :

A = 18.8

B = 0.77

Therefore , Regression equation :

Y = 18.8 + 0.77.t

  1. Forecast for July ( i.e. t = 7 ) will be

= 18.8 + 0.77x7

= 18.8 + 5.39

= 24.19


Related Solutions

Historical demand for a product is DEMAND January 15 February 12 March 16 April 15 May...
Historical demand for a product is DEMAND January 15 February 12 March 16 April 15 May 17 June 16 a. Using a weighted moving average with weights of 0.60 (June), 0.20 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.) b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) c. Using single exponential smoothing with ? = 0.30 and a June forecast = 11, find...
Historical demand for a product is as follows: April                60 May                 60 Jun
Historical demand for a product is as follows: April                60 May                 60 June                55 July                 75 August             80 September       75 (a.) Using a simple four-month moving average, calculate a forecast for October. (b.) Using single exponential smoothing with alpha=0.3 and a September forecast =70, calculate a forecast for October. (c.) Using simple linear regression, calculate the trend line (Yt) for the historical data. The X-axis scale is: April = 1, May = 2, and so forth. Y-axis is Demand from...
Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July...
Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July 61 August 86 September 81 a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.) 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.) c. Using simple linear regression, calculate the trend line for the historical data....
Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900,...
Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900, 11,400, 11,900, and 13,400 units, respectively. The ending finished goods inventory equals 20% of the following month's sales. The ending raw materials inventory equals 40% of the following month’s raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. If 61,000 pounds of raw materials are required for production in March, then the budgeted raw material purchases for February...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units)...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, MATT, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told MATT his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information...
Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000...
Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000 August $180,000 Actual November and December 2018 sales were $200,000 and $90,000, respectively. Cash sales are 45% of the total and the rest are on credit. About 70% of credit sales are typically collected one month after the sale and 30% the second month. Monthly inventory purchases represent 50% of the following month’s sales. The firm pays 40% of its inventory purchases in cash...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $9,000 per year, using the straight-line method. He has supplied you with the following information (above) to help you...
Month Patient Days January 543 February 528 March 531 April 542 May 558 June 545 July...
Month Patient Days January 543 February 528 March 531 April 542 May 558 June 545 July 543 August 550 September 546 October 540 November 535 December 529 Predict naïve forecast of patient days for February and June. Predict the patient days for January, using a four-period moving average. Predict the patient days for January, using the six-period moving average. Plot the actual data and the results of the four period and the six-period moving averages. Which is a better predictor?
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information (above) to...
Historical demand for iphones in a retail store is as follows: Sales    January 12 February...
Historical demand for iphones in a retail store is as follows: Sales    January 12 February 14 March 15 April 12 May 16 a) Using the simple mean method, find the June forecast. b) Using a simple exponential smoothing with alpha = 0.1 and a January forecast = 13, find the June Forecast. c) Use MAD to decide which method produced the better forecast.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT