Question

IV. The following are monthly actual and forecast demand levels for July thru December for units...

IV. The following are monthly actual and forecast demand levels for July thru December for units of a       product manufactured by the N. Tamimi Pharmaceutical Company:

Month      Actual Demand    Forecast Demand

July                           71                              78

August                    80                              75

September          101                           83

October                 84                              84

November            60                              88

December            73                              85

Compute a tracking signal and determine whether the forecasts are in control.

Business   Operations-Management   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Month Actual Demand Forecast demand Error Cumulative error Absolute Deviation Sum of AD MAD Tracking Signal
July 71 78 -7 -7 7 7 7 -1.00
Aug 80 75 5 -2 5 12 6 -0.33
Sep 101 83 18 16 18 30 10 1.60
Oct 84 84 0 16 0 30 7.5 2.13
Nov 60 88 -28 -12 28 58 11.6 -1.03
Dec 73 85 -12 -24 12 70 11.67 -2.06
MAD= Sum of Absolute deviation / numbeer of months
Tracking Signal = Cumulative error/ MAD
Answer:- As tracking signal is normal thus the forecast should be considered under control
0 0
Know the answer?
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
Similar Questions
The following are monthly actual and forecast demand levels for May through December for units of...
The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the D. Bishop Company in Des Moines:    Month Actual Demand Forecast Demand May 108 104 June 80 100 July 112 99 August 112 101 September 105 100 October 106 106 November 125 102 December 115 111 For the given forecast, the tracking signal = ___ MADs (round your response to two decimal places).
The following data is given: August trend forecast                         = 600 units Actual sales in August   &nb
The following data is given: August trend forecast                         = 600 units Actual sales in August                       = 370 units Actual sales in September                  = 700 units Actual sales in October                      = 665 units Seasonal index for August                 = 0.9 Seasonal index for Septemeber          = 1.2 Seasonal index for October                = 1.1 Seasonal index for Novermber          = 0.8 Smoothing Constant, α                      = 0.2 Use simple exponential smoothing to find the forecast (seasonalized) for November.
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Problem 2: Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total Problem 3: A firm uses simple exponential smoothing with to forecast demand. The forecast for the week...
V had actual sales and purchases for July and August 2020 as given in the Excel...
V had actual sales and purchases for July and August 2020 as given in the Excel spreadsheet, along with its forecast sales and purchases for the period September 2020 through February 2021. The firm makes 30% of all sales for cash and collects 35% of its sales in each of the two months following the sale. Other cash inflows are expected to be $22,000 in September and February, $25,000 in November and January, and $37,000 in December. The firm pays...
Your manager is trying to determine what forecasting method to use. Based upon the following historical...
Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. - PLEASE show all work in Excel including formulas. a. Calculate the simple three-month moving average forecast for periods 4-12. b. Calculate the weighted three-month moving average using weights of 0.50, 0.30, and 0.20 for periods 4-12. c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F1)...
The data are not actual data, but are modeled after data collected by Trautwein and Ammerman...
The data are not actual data, but are modeled after data collected by Trautwein and Ammerman (2013) for a study on the effects of cochlear implants (CI) on the language, speech, and perception skills of 32 deaf children: 16 subjects with at least one cochlear implant (CI) and 16 subjects (with hearing loss) without an implant. (CI subjects were implanted at 13 or 14 months of age. So, no subjects had CIs at the time of the first data collection.)...
You have just been hired by WidgetCo; a long trusted manufacturer of Widgets. Unfortunately, the company...
You have just been hired by WidgetCo; a long trusted manufacturer of Widgets. Unfortunately, the company has been suffering from very high inventory levels as compared to others in the highly competitive Widget industry. Your boss thinks there might be a problem in the forecasting and wants you to figure it out. You have selected a representative family of items and asked for the complete 2 years history of forecasts and actuals. Sadly, they only have the last twelve months,...
Aggregate Planning A key hospital supplier, IVs Plus (IVP) located in Salina, KS sells IV tubing...
Aggregate Planning A key hospital supplier, IVs Plus (IVP) located in Salina, KS sells IV tubing and stands to hospitals and clinics. Sales have picked up ever since they introduced their newest “Squeaky Clean” IV stand, which eliminates all oils and germs left behind by users. Though IVP sells these stands all year long, they sell the most during the summer months, when end-of-fiscal year purchases are at a peak. The demand over the next 12 months is shown in...
Question 1: Wendy's Happy Homes Inc. manufactures Home Appliances. Monthly sales of Wendy's Washers and Dryer...
Question 1: Wendy's Happy Homes Inc. manufactures Home Appliances. Monthly sales of Wendy's Washers and Dryer Sets for a nine-month period were as follows: MONTH Washer and Dryer Sales January 490 February 480 March 450 April 500 May 480 June 470 July 490 August 520 September 530 Forecast October sales using: 1) A four-month moving average 2) a six-month moving average 3. Compute the MAD for each forecast method you used. Actual October sales were 520 units. 4) Which method...
Cornwell Glass produces replacement automobile glass for all makes of cars. Cornwell has a sophisticated forecasting...
Cornwell Glass produces replacement automobile glass for all makes of cars. Cornwell has a sophisticated forecasting system that uses data from past years to find seasonal factors and long-term trends. The system uses data from past weeks to find recent trends. The following table presents the forecasted demands for the coming year on a weekly basis. Week Demand Week Demand April 15 1,829 November 4 1,864 22 1,820 11 1,989 29 1,887 18 2,098 May 6 1,958 25 2,244 13...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT