Operations management

User Generated

ArrqTenqrN

Business Finance

Description

Copy of Ex_2.1_and_14.1_template-1.xlsm

Read this assignment well before you place your bid. Its due in 8 hours from now. I NEED PERFECT work

  • Exercises: 2.1 and 14.1

    The following exercises are required and cover topics in this week's required reading. Review the instructions carefully before completing and submitting the exercises. For the exercises this week and in following weeks, please use the Excel templates provided. For several of the exercises you will use automated templates (that is, Excel templates that automatically perform calculations) to arrive at your answers.

    1) Complete Exercise 2.1 on page 45 in Quantitative Methods in Health Care Management. In the Excel document below, you may use Sheet 1 ("Moving Averages Template"), which includes an automated Excel table, for your calculations, or do these manually. Use Sheet 2 to record your answers to a, b, c, and this additional question (2.1d): "In 1–2 sentences, explain which of the three results you have the most confidence in projecting accurately and why that is."

    2) Complete Exercise 14.1 on page 386 in Quantitative Methods in Health Care Management. In the Excel document below, use Sheet 3 ("Single Channel Template"), which includes an automated Excel table, for your calculations, and use Sheet 4 to record your answers. For an explanation of the automated table for Exercise 14.1, refer to Quantitative Methods, p. 379.

    Note on using the Excel templates: Save the template to your desktop before using. Make sure macros are enabled so that you can use the automated Excel template. Any existing numbers in green cells in the automated table are for examples, and show where you should enter the data. You must delete or overwrite these numbers to do your calculations. The yellow cells are protected to prevent users from accidentally deleting or overwriting the formulas. There is no need to unprotect the template.


Unformatted Attachment Preview

Moving Average Periods of Moving Average = MAD = MAPE = Period 1 2 3 4 5 6 7 8 9 10 11 12 13 3 51,22222 0,023087 Actual Forecast 2160 2186 2246 2251 0 2243 0 2162 0 0 2500 Error 2000 2251 2243 2162 1500 1000 Periods of Moving Average = 4 500 MAD = MAPE = Period 1 2 3 4 5 6 7 50,875 0,023099 Actual Forecast 2160 2186 2246 2251 2243 0 2162 0 0 Error 0 0 2243 2162 2 Actual Forecast-Moving A Forecast-Moving A 4 Actual Forecast-Moving Average=3 Forecast-Moving Average=4 6 Periods 8 10 12 EX2.1 Months Visits July 2160 August 2186 September 2246 October 2251 November 2243 December 2162 January Naïve 3-MA 4-MA Answers a. January forecast b. January forecast using 3-MA c. January forecast using 4-MA In 1-2 sentences, explain which you explain which of the three results you have the most confidence in projecting ac d. Single Channel, Poisson Arrival, and Exponential Service Time (M/M/1) Arrival rate Service rate Average Number of customers waiting for service Average Number of customers in the system (waiting or being served) Average time customers wait in line Average time customers spend in the system System utilization Service time Probability of zero units in system Probability of 3 units in system System Utilization 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% System Utilization 1 λ μ Lq L Wq W ρ 1/μ P0 n P3 18 20 8,1000 9,0000 0,4500 0,5000 90% 0,0500 0,1000 3 0,0729 Average Time customers spend in system 1 Average Time Customers Spend in Line 0,4200 0,4400 0,4600 0,4800 0,5000 0,5200 EX14.1 Arrival rate= Service rate= Nurse agent= Answers 18 20 1 per hour A. System Utilization B. Average Number in Line C. Average Time in Line D. Average Time in the System
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags