Answers shown in the last picture, please show how to obtain without excel. proc

Question

Answers shown in the last picture, please show how to obtain without excel.
procedure requires the patient to proceed through seven levels of treatment The smount The of time it takes for a patient to move from one level of treatment to the next follows. The projected number of completed stomach procedures over the next 15 days is shown below. Consider three critical resources of nurses, beds, and lab tests that are requirod at each level of treatment as shown below surgery at its facility. This BOR Level Level 1 Level 2 Level 3 Level 4 Level 5 Level 6 Level 7 Total Lead time in Days 9 Required for Nurse Hours Beds Required Lab Tests Required Required Per day Per day Per day Bypass Patients Level t Level 2 Level 3 Level 4 Leve 5 Level 6 Level 7 14 20 12 10 Day of the Month Bypass 1 23 4567s1o 1112 13 14 15

Explanation / Answer

The workings of this requirement can be done both with excel and without excel. As the question specifically mentions about without excel, am going to explain the procedure to be followed in getting the solution.

It appears that the given data about the projected number of cardiac bypass surgeries completed over next 15 days is missing from the images attached. So I will try answering it assuming that a number of completed surgeries on day 1 are x1, on day 2 are x2, on day 3 are x3 and so on. This means a number of surgeries completed on day 15 are x15. (Please substitute the values of x1, x2, .... x15 to calculate final answer).

The cycle time of the surgical procedure is 9 days. If x15 surgeries are getting completed on day 15, then x15 surgeries would be at level 1 on day 7, at level 2 on day 8, at level 3 on day 9, at level 4 on days 10 and 11, at level 5 on day 12, at level 6 on days 13 and 14, and finally at level 7 on day 15.

In another way, this means on day 1, there will be x9 number of patients at level 1, x8 number of patients at level 2, x7 number of patients at level 3, (x6 + x5) number of patients at level 4, x4 number of patients at level 5, (x3 + x2) number of patients at level 6 and x1 number of patients at level 7.
So,
Nurse hours required on Day 1 = (3*x9) + (x8) + (6*x7) + (14*(x6 + x5)) + (20*x4) + (12*(x3 + x2)) + (5*x1)
Beds required on Day 1 = (x8) + (3*x7) + (2*(x6 + x5)) + (3*x4) + (2*(x3 + x2)) + (3*x1)
Lab tests required on Day 1 = (x7) + (5*(x6 + x5)) + (2*x4) + (10*(x3 + x2)) + (2*x1)

Similarly, on day 2, there will be x10 number of patients at level 1, x9 number of patients at level 2, x8 number of patients at level 3, (x7 + x6) number of patients at level 4, x5 number of patients at level 5, (x4 + x3) number of patients at level 6 and x2 number of patients at level 7.

So, Nurse hours required on Day 2 = (3*x10) + (x9) + (6*x8) + (14*(x7 + x6)) + (20*x5) + (12*(x4 + x3)) + (5*x2)
Beds required on Day 2 = (x9) + (3*x8) + (2*(x7 + x6)) + (3*x5) + (2*(x4 + x3)) + (3*x2)
Lab tests required on Day 2 = (x8) + (5*(x7 + x6)) + (2*x5) + (10*(x4 + x3)) + (2*x2)

Likewise, the calculations can be done until Day 15. Since there is no data given for surgeries getting completed after 15 days, we can assume that there is no inflow of new patients from Day 8 onwards.
This means that on Day 13, there will (x15 + x14) number of patients at level 6 and x13 number of patients at level7. On Day 14, there will be x15 number of patients at level 6 and x14 number of patients at level 7. On Day 15, there will just be x15 number of patients at level 7.

Steps Involved in this Resource Requirement Problem:

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.