What is the average deviation-method of forecasting

Reference no: EM131279272

Recently the FDA approved a new blood test that could be used to diagnose fibromyalgia. Before the blood test was approved, it had been very difficult to diagnose this condition. The lab at General Hospital has noticed that the request for this test have increased over the past six months and they have had a difficult time keeping the supplies in house required to complete the test. They would like to develop a way to forecast the demand for this test at least a week in advance so that they can include the needed materials for the test in their weekly supply order. Using the data in Blood Test from the homework spreadsheet, complete the following tasks.

1) Create a 3 week moving average forecast using all available data. Calculate the MAD of the forecast. What is the forecast for week 23? What is the average deviation (MAD) using this method of forecasting?

Reference no: EM131279272

Questions Cloud

Position retail trade in a market : How can customer service be used to position retail trade in a market?

Additional literature on takeoffs and landings : After reading this week's additional literature on takeoffs and landings, post one paragraph on your impressions, comments, or lessons learned from the readings. Imagine you are the captain of a transport airplane and your balanced field length or cr..

Contrast engine specifications-including thrust-weight : Compare and contrast engine specifications, including thrust, weight, and bypass ratios for the GE F404 and J85; two very common engines. What aircraft use these engines? List your source. Compare and contrast the largest turbo engine to the smallest..

According to the boeing aero magazine article : According to the Boeing Aero Magazine article on Angle of Attack (AOA), when is AOA good to use in commercial airliners? How is it useful in Military fighter jets? Comment on how you have used AOA in your own flying.

What is the average deviation-method of forecasting : Recently the FDA approved a new blood test that could be used to diagnose fibromyalgia. Before the blood test was approved, it had been very difficult to diagnose this condition. Create a 3 week moving average forecast using all available data. Calcu..

Use to identify potential chemical hazards within facility : Identify at least 4 sources of information an industrial hygienist might use to identify potential chemical hazards within a facility. Discuss strategic and operational planning in an organization. When is each used? How do they differ? Consider the ..

The right-hand side value- all variables are non-negative : Solve the following 3 variable problem in Excel. Maximize 10X1 + 7X2 + 5X3; subject to the constraints: X1 + X2 + X3 = 70; -X2 + X3

Describing what is the filtering effect of six sigma : Differentiate Efficacy from Effectiveness in medical care. Why is the concept of cost-effectiveness more important than cost-efficacy? If you were Finnvold, how would you conduct an organizational diagnosis that would lead off the implementation? des..

Reputation for providing quality health care services : Human Resources Management: Case Study Happy Valley Hospital is a community-based health care facility with a reputation for providing quality health care services to the residents of Happy Valley and its surrounding markets. what should the recruitm..

User Account

All Pages