Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

· Week 5 Case Study 1 - Submit Here Case Study 1:Forecasting Due Week 5 and worth 75 points Using the Northern College Health Services visit volume in Appendix 6-1 on page 113 of the textbook, for...

1 answer below »

· Week 5 Case Study 1 - Submit Here

Case Study 1:Forecasting

Due Week 5 and worth 75 points

Using the Northern College Health Services visit volume in Appendix 6-1 on page 113 of the textbook, for this assignment, you will be providing a forecast of the number of clinic visits for November 2008 using the average change, confidence interval, average percent change, moving averages, and exponential smoothing forecasting methods. Use the Internet or Strayer Library to research at least two (2) examples of the forecasting methods being used in health services organizations.

Write a two to three (2-3) page paper in which you:

1. Explain each step in the forecasting process for each method.

2. Provide a brief summary of your researched health services organizations implementing the forecasting methods.

3. Provide a forecast of the number of clinic visits for November 2008 using each method of the forecasting process.

4. Conclude which forecasting method provides the best forecast, and provide a rationale for your conclusion.

Your assignment must follow these formatting requirements:

· Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

· Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

· Evaluate forecasting strategies and methods.

· Use technology and information resources to research issues in quantitative methods for health services.

· Write clearly and concisely about quantitative methods for health services using proper writing mechanics.

Clickhereto view the grading rubric.

Answered Same Day Nov 15, 2021

Solution

Pooja answered on Nov 15 2021
144 Votes
Methods of Forecasting
Student Name:
Student ID:
1)
Method 1: average change
     
     
    At
    Change
    Ft
    2005.00
    Jan
    21.00
     
     
     
    Fe
    19.00
    -2.00
    21.40
     
    Ma
    16.00
    -3.00
    19.40
     
    Ap
    20.00
    4.00
    16.40
     
    May
    15.00
    -5.00
    20.40
     
    Jun
    18.00
    3.00
    15.40
     
    July
    16.00
    -2.00
    18.40
     
    Aug
    14.00
    -2.00
    16.40
     
    Sept
    18.00
    4.00
    14.40
     
    Oct
    25.00
    7.00
    18.40
     
    Nov
    30.00
    5.00
    25.40
     
    Dec
    16.00
    -14.00
    30.40
    2006.00
    Jan
    22.00
    6.00
    16.40
     
    Fe
    26.00
    4.00
    22.40
     
    Ma
    31.00
    5.00
    26.40
     
    Ap
    39.00
    8.00
    31.40
     
    May
    44.00
    5.00
    39.40
     
    Jun
    17.00
    -27.00
    44.40
     
    July
    22.00
    5.00
    17.40
     
    Aug
    18.00
    -4.00
    22.40
     
    Sept
    27.00
    9.00
    18.40
     
    Oct
    33.00
    6.00
    27.40
     
    Nov
    29.00
    -4.00
    33.40
     
    Dec
    33.00
    4.00
    29.40
    2007.00
    Jan
    32.00
    -1.00
    33.40
     
    Fe
    34.00
    2.00
    32.40
     
    Ma
    39.00
    5.00
    34.40
     
    Ap
    42.00
    3.00
    39.40
     
    May
    41.00
    -1.00
    42.40
     
    Jun
    21.00
    -20.00
    41.40
     
    July
    24.00
    3.00
    21.40
     
    Aug
    28.00
    4.00
    24.40
     
    Sept
    47.00
    19.00
    28.40
     
    Oct
    45.00
    -2.00
    47.40
     
    Nov
    46.00
    1.00
    45.40
     
    Dec
    44.00
    -2.00
    46.40
    2008.00
    Jan
    39.00
    -5.00
    44.40
     
    Fe
    41.00
    2.00
    39.40
     
    Ma
    34.00
    -7.00
    41.40
     
    Ap
    39.00
    5.00
    34.40
     
    May
    38.00
    -1.00
    39.40
     
    Jun
    19.00
    -19.00
    38.40
     
    July
    28.00
    9.00
    19.40
     
    Aug
    29.00
    1.00
    28.40
     
    Sept
    37.00
    8.00
    29.40
     
    Oct
    39.00
    2.00
    37.40
     
    Nov
     
     
    39.40
    
    
    
    
    
    
    
    avg
    0.4
     
Method 2: average percentage change
     
     
    At
    Change
    Ft
    2005.00
    Jan
    21.00
     
     
     
    Fe
    19.00
    -9.52%
     22.11
     
    Ma
    16.00
    -15.79%
     20.01
     
    Ap
    20.00
    25.00%
     16.85
     
    May
    15.00
    -25.00%
     21.06
     
    Jun
    18.00
    20.00%
     15.80
     
    July
    16.00
    -11.11%
     18.96
     
    Aug
    14.00
    -12.50%
     16.85
     
    Sept
    18.00
    28.57%
     14.74
     
    Oct
    25.00
    38.89%
     18.96
     
    Nov
    30.00
    20.00%
     26.33
     
    Dec
    16.00
    -46.67%
     31.59
    2006.00
    Jan
    22.00
    37.50%
     16.85...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here