Question

QUESTION 4 Submit an Excel file with work required The following represents the trend in the number of admissions to our hosp
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)

We have run the 2 year moving averages as the below

Moving admissions 11700 11600 11500 11420 11400 11320 11290 11150 year averages 11650 11550 11460 11410 11360 11305 11220

first moving average is (year1 + year2)/2 = 11650 is placed corresponding on year 2.and go on.

b)

Forecasts

Period Forecast Lower Upper
9 11220 10993.6 11446.4
10 11220 10993.6 11446.4

Moving Average Plot for admissions 11700 11600 -95.0% PI 11500 Moving Average 11400 11300 11200 11100 MAPE MAD 109.2 MSD 1333

Add a comment
Know the answer?
Add Answer to:
QUESTION 4 Submit an Excel file with work required The following represents the trend in the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • Using Excel Sheet to answer the following make sure you submit the file with the work...

    Using Excel Sheet to answer the following make sure you submit the file with the work required The following data represent the number of refrigerators sold for each of the past five months for Templeton Appliances. Month Sales 1. Using two-period Simple moving average to fill the rest of the table 2. Using forecasting command.The sale forecast for Month 6 is 3. Using forecasting command. The sale forecast for Month 7 is

  • Question 1. A realtor working in a large city wants to identify the secular trend in...

    Question 1. A realtor working in a large city wants to identify the secular trend in the weekly number of single-family houses sold by her firm. For the past 15 weeks she has collected data on her firm’s home sales, as shown in the table. Week t Homes sold yt Week t Homes sold yt Week t Homes sold yt 1 59 6 137 11 88 2 73 7 106 12 75 3 70 8 122 13 62 4 82...

  • Title: ER Operations Manager Used the files attached to answer the following Questions: o Use this Excel file C 3 and C 4 Excel file.xlsx o Use this file to submit your work C4 Part IIdocx Questi...

    Title: ER Operations Manager Used the files attached to answer the following Questions: o Use this Excel file C 3 and C 4 Excel file.xlsx o Use this file to submit your work C4 Part IIdocx Question 2: Multiple Regression: Effect of Age and General Health Status Score on Total ER Cost. 1. Purpose 2. Importance 3. Variables 4. Sample Size 5. Hypothesis 6. Methodology 7. Findings 8. Interpretations/Implications ting: Monthly Patient Volume. Question 3: Forec Scenario: You are the...

  • CORRECTED: ABC ORIGINAL PROBLEM DATA (18I Excel File: CHECK FIGURES: AX40 Traditional Unit Cost: $62.75 EX90...

    CORRECTED: ABC ORIGINAL PROBLEM DATA (18I Excel File: CHECK FIGURES: AX40 Traditional Unit Cost: $62.75 EX90 ABC Unit Cost: $116.80 For several years, Adria Manufacturing has produced a single product called AX40. Then two years ago, the company automated a portion of its plant and at the same time introduced a second product called EX90 which has become increasingly popular. The EX90 is a more complex product, requiring one hour of direct labor time per unit to manufacture and extensive...

  • Please read the article and answer about questions. You and the Law Business and law are...

    Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...

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