Question

A walk-in ambulatory health care facility operates without appointments. It is analyzing when it

receives business in an effort to better staff itself. The staff are examining the registration process first and have

obtained the following data for the period from 2:00 PM to 6:30 PM, which is the busiest time during the day.

The registration desk throughput is 10 patients per hour. Assume 0 patients waiting to be registered at 2:00.

		Ri	Ro	ΔR	I(t)
		Number	Number
Time		Patients	Completing	Buildup	Ending
Period		Arriving	Registration	Rate	Inventory
2:00 - 2:30		3
2:30 - 3:00		7
3:00 - 3:30		4
3:30 - 4:00		8
4:00 - 4:30		12
4:30-5:00		6
5:00 - 5:30		5
5:30 - 6:00		4
6:00 - 6:30		1

Use the data you entered above, to create a line graph showing how the inventory level increases and decreases over time

Answer 1

	Ri	Ro	ΔR	I(t)
		Number	Number
Time		Patients	Completing	Buildup	Ending
Period		Arriving	Registration	Rate per hour	Inventory
2:00 - 2:30		3	3		0
2:30 - 3:00		7	5	4	2
3:00 - 3:30		4	5	0	1
3:30 - 4:00		8	5	6	4
4:00 - 4:30		12	5	14	11
4:30-5:00		6	5	2	12
5:00 - 5:30		5	5	0	12
5:30 - 6:00		4	5	0	11
6:00 - 6:30		1	5	0	7

== General 11 X 3. O.A >>. Wrap Test Merge & Center Alignment ! 92 Conditional Formatas Cell Formatting Table Styles Styles Adobum Sort & Find & Clear Filter. Select Editing Insert Delete Format - Number BL BN X Z M BO BQ V Y BU BP BR W ENDING INVENTORY Sheet1 e OOP