Calculate the net requirements and planned order releases

Assignment Help Operation Management
Reference no: EM131381335

"Shouldice Hospital, the house that hernias built, is a converted country estate which gives the hospital 'a country club' appeal." - American Medical News

Shouldice Hospital in Canada is widely known for one thing-hernia repair! In fact, that is the only operation it performs, and it performs a great many of them. Over the past two decades this small 90-bed hospital has averaged 7,000 operations annually. Last year, it had a record year and performed nearly 7,500 operations. Patients' ties to Shouldice do not end when they leave the hospital. Every year the gala Hernia Reunion dinner (with complimentary hernia inspection) draws in excess of 1,000 former patients, some of whom have been attending the event for over 30 years.

A number of notable features in Shouldice's service delivery system contribute to its success. (1) Shouldice accepts only patients with the uncomplicated external hernias, and it uses a superior technique developed for this type of hernia by Dr. Shouldice during World War II. (2) Patients are subject to early ambulation, which promotes healing. (Patients literally walk off the operating table and engage in light exercise throughout their stay, which lasts only three days.) (3) Its country club atmosphere, gregarious nursing staff, and built-in socializing make a surprisingly pleasant experience out of an inherently unpleasant medical problem. Regular times are set aside for tea, cookies, and socializing. All patients are paired up with a roommate with similar background and interests.

The Production System

The medical facilities at Shouldice consist of five operating rooms, a patient recovery room, a laboratory, and six examination rooms. Shouldice performs, on average, 150 operations per week, with patients generally staying at the hospital for three days. Although operations are performed only five days a week, the remainder of the hospital is in operation continuously to attend to recovering patients.

An operation at Shouldice Hospital is performed by one of the 12 full-time surgeons assisted by one of seven part-time assistant surgeons. Surgeons generally take about one hour to prepare for and perform each hernia operation, and they operate on four patients per day. The surgeons' day ends at 4 p.m., although they can expect to be on call every 14th night and every 10th weekend.

The Shouldice Experience

Each patient undergoes a screening exam prior to setting a date for his or her operation. Patients in the Toronto area are encouraged to walk in for the diagnosis. Examinations are done between 9 a.m. and 3:30 p.m. Monday through Friday and between 10 a.m. and 2 p.m. on Saturday. Out-of-town patients are mailed a medical information questionnaire (also available over the Internet), which is used for the diagnosis. A small percentage of the patients who are overweight or otherwise represent an undue medical risk are refused treatment. The remaining patients receive confirmation cards with the scheduled dates for their operations. A patient's folder is transferred to the reception desk once an arrival date is confirmed. Patients arrive at the clinic between 1 and 3 p.m. the day before their surgery. After a short wait, they receive a brief preoperative examination. They are then sent to an admissions clerk to complete any necessary paperwork. Patients are next directed to one of the two nurses' stations for blood and urine tests and then are shown to their rooms. They spend the remaining time before orientation getting settled and acquainting themselves with their roommates.  Orientation begins at 5 p.m., followed by dinner in the common dining room. Later in the evening, at 9 p.m., patients gather in the lounge area for tea and cookies. Here new patients can talk with patients who have already had their surgery. Bedtime is between 9:30 and 10 p.m.

On the day of the operation, patients with early operations are awakened at 5:30 a.m. for preoperative sedation. The first operations begin at 7:30 a.m. Shortly before an operation starts, the patient is administered a local anesthetic, leaving him or her alert and fully aware of the proceedings. At the conclusion of the operation, the patient is invited to walk from the operating table to a nearby wheelchair, which is waiting to return the patient to his or her room. After a brief period of rest, the patient is encouraged to get up and start exercising. By 9 p.m. that day, he or she is in the lounge having cookies and tea and talking with new, incoming patients.

The skin clips holding the incision together are loosened, and some are removed, the next day. The remaining clips are removed the following morning, just before the patient is discharged.

When Shouldice Hospital started, the average hospital stay for hernia surgery was three weeks. Today, many institutions push "same-day surgery" for a variety of reasons. Shouldice Hospital firmly believes that this is not in the best interests of patients, and is committed to its three-day process. Shouldice's postoperative rehabilitation program is designed to enable the patient to resume normal activities with minimal interruption and discomfort. Shouldice patients frequently return to work in a few days; the average total time off is eight days.

"It is interesting to note that approximately 1 out of every 100 Shouldice patients is a medical doctor."

Future Plans

The management of Shouldice is thinking of expanding the hospital's capacity to serve considerable unsatisfied demand. To this effect, the vice president is seriously considering two options. The first involves adding one more day of operations (Saturday) to the existing five-day schedule, which would increase capacity by 20%. The second option is to add another floor of rooms to the hospital, increasing the number of beds by 50%. This would require more aggressive scheduling of the operating rooms. The administrator of the hospital, however, is concerned about maintaining control over the quality of the service delivered. He thinks the facility is already getting very good utilization. The doctors and the staff are happy with their jobs, and the patients are satisfied with the service. According to him, further expansion of capacity might make it hard to maintain the same kind of working relationships and attitudes.

Check-In Day

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Sunday

Monday

30

30

30

 

 

 

 

Tuesday

 

30

30

30

 

 

 

Wednesday

 

 

30

30

30

 

 

Thursday

 

 

 

30

30

30

 

Friday

 

 

 

 

 

 

 

Saturday

 

 

 

 

 

 

 

Sunday

30

30

 

 

 

 

30

Total

60

90

90

90

60

30

30

Above is a room occupancy table for the existing system. Each row in the table follows the patients that checked in on a given day. The columns indicate the number of patients in the hospital on a given day. For example, the first row of the table shows that 30 people checked in on Monday and were in the hospital on Monday, Tuesday, and Wednesday. By summing the rows in the table for the Wednesday column, we see that there are 90 patients staying in the hospital that day.

1. How well is the hospital currently utilizing its beds?

2. Develop a similar table to show the effects of adding operations on Saturday. (Assume that 30 operations would still be performed each day.) How would this affect the utilization of the bed capacity? Is this capacity sufficient for the additional patients?

3. Now look at the effect of increasing the number of beds by 50%. How many operations could the hospital perform per day before running out of bed capacity? (Assume operations are performed five days per week, with the same number performed on each day.) How well would the new resources be utilized relative to the current operation? Could the hospital really perform this many operations? Why? (Hint: Look at the capacity of the 12 surgeons and the five operating rooms.)

4. Although financial data are sketchy, an estimate from a construction company indicates that adding bed capacity would cost about $100,000 per bed. In addition, the rate charged for the hernia surgery varies between about $900 and $2,000 (U.S. dollars), with an average rate of $1,300 per operation. The surgeons are paid a flat $600 per operation. Due to all the uncertainties in government health care legislation, Shouldice would like to justify any expansion within a five-year time period. How would you do that?

5. Assume that the administrators at Shouldice want to minimize inventory requirements. Calculate the net requirements and planned order releases (planned ordered cleanings) for operating rooms, beds, and medical kits. Assume lot-for-lot lot sizing is used.

Only need question 5 with explanation.

Attachment:- Assignment.rar

Verified Expert

Please find the doc attached in this we have performed "Shouldice should invest $4MM in a new unit, which will increase bed capacity by 50% and require its surgeons to perform Saturday surgeries"

Reference no: EM131381335

Questions Cloud

John always uses exactly two pats of jam : John always uses exactly two pats of jam (J) on each piece of toast (T). if toast costs $0.25/slice and jam costs $0.10/pat, find John's (i) budget constraint (the equation) and (ii) best affordable bundle, if he has $18/week to spend on toasts an..
Discuss the health hazards associated with chemicals : Discuss the health hazards associated with chemicals'. Discuss all regulatory requirement for this process related to Industrial hygiene(I.e. PELs/TLVs. OSHA standards)
Price elasticity of demand for gasoline : Suppose the price elasticity of demand for gasoline at the pump is 0.67. About how big a price increase will be required to decrease consumption of gasoline by 4 percent?
Design a blocking design for the situation in given problem : In a four-factor design based on portfolio size for welldiversified portfolios, with 240 data points, the F statistic was significant at the 1% level of significance. Explain.
Calculate the net requirements and planned order releases : Assume that the administrators at Shouldice want to minimize inventory requirements. Calculate the net requirements and planned order releases (planned ordered cleanings) for operating rooms, beds, and medical kits. Assume lot-for-lot lot sizing i..
Personal loan rates follow mortgage rates : It seems that most personal loan rates follow mortgage rates. Is this true? What are the historical mortgage interest rates in the United States for the last 30 years? What happens when rates are high? What happens when rates are low?
Prepare capital budgeting model and analysis : Prepare Capital Budgeting Model and Analysis. Describe a capital budgeting project (i.e., an investment in fixed assets) that might be undertaken by the company that you have selected.
Modern global economic prosperity and poverty : "The roots of both modern global economic prosperity and poverty (the so-called GreatDivergence) are in the Industrial Revolution that began in the late 18th century." Discuss
Relation between blocks and treatments : What important assumption about the relation between blocks and treatments is necessary for carrying out a block design ANOVA?

Reviews

inf1381335

2/6/2017 5:08:12 AM

I got word that my undertaking is finished and I passed. You made an awesome showing with regards to with all the help you gave me and I welcome it in particular. Much obliged to you, thank you, bless your heart!!! So our arrangement is done and you have completed your end of it. Fare thee well and thank you again for whatever you did.

inf1381335

2/6/2017 5:07:33 AM

Expert needs to take into account Friday Saturday and Sunday of the previous week when calculating the MRP there should not be any negative numbers Also how in the world is the Projected available balance for operations room requirements & and bed requirements being calculated? According to your own formula these numbers are wrong. I need this corrected asap.

inf1381335

2/6/2017 5:06:54 AM

Additionally question 5's solution should not be just bullet points. The request is for such but also thought around the solution in a paragraph - around how you determined the data in the excel. This is critical. The tables from the doc need to be in excel w formulas. professor will request. That was part of the request Thank you, Please also ask expert why is there no information in Hernia Master Schedule? Please have expert check formulas in question 5. Also question need to talk about minimize inventory requirement. Solution should not follow question being asked. all numbers be base on the Demand above outline above master production schedule. there is an error in the net requirement cell formula please correct and confirm. please let expert that utilization formula missing in cells thanks can you please ask expert why there is a -# in projected available balance and where did he get the projected available balance for medical kits, bed requirements, and operating room requirements. Why is there zeros in scheduled receipts?

inf1381335

2/6/2017 5:00:10 AM

Can you provide a written answer explanation in original thoughts for each question as well? 400- 500 for all questions including a question 5 Please have expert use attached excel for question 5 need discussion a rounds solution I need answer explanation for question 1-5 orginal thought. I don't need 500 words to answer question 5. Every question can be answer in 100 words I need question 5 soliton using on excel attached as described below With formulas in each cell and review of solution Please advise will every question be answered with orginal thoughts on excel solution w explanation And show excel work with formula in each cells ? For question 5 the attached sheet will be used showing work and formulas in each cell with Orginal thoughts around solution? Please confirm will every question be answered with orginal thoughts on excel sheet solution w explanation And show excel work with formula in each cells ? For question 5 the attached sheet will be used showing work and formulas in each cell with solution explanation in orginal thought For tomorrow I need the excel work sheet (W formulas) for questions 1-4 it is need for the assignment

len1381335

2/3/2017 12:47:16 AM

I do not understand whether we need to factor in patients that are not currently being operated on but using beds or not. Additionally, I don't know whether we need to take the # for demand and figure out how it applies to the hours in the day as rooms are available. If I am missing something, or if we are just supposed to use the data in the spreadsheet without using any other based on the case study, please let me know. The medical kits are required for all operations. Gross requirements 28 operations = 56 medical kits. Don’t worry about patients already in beds. There is enough bed capacity given the 3 day turnover. Hours are not important in this version of MRP.

len1381335

2/3/2017 12:46:27 AM

In this Operation Management Assignment, total No Of Words: 200. Only need question 5 with explanation. Use attached excel for question 5 only, in excel please show all formulas in cells. Shouldice Hospital, the house that hernias built, is a converted country estate which gives the hospital 'a country club' appeal." Assume that the administrators at Shouldice want to minimize inventory requirements. Calculate the net requirements and planned order releases (planned ordered cleanings) for operating rooms, beds, and medical kits.

Write a Review

 

Operation Management Questions & Answers

  Follow-up appointment in a row

Lisa Daily is a patient of your medical practice. She has just failed to show for her fourth follow-up appointment in a row even though you confirmed it with her yesterday. You call her house but only reach her voice mail. What should the assistant s..

  Describe high performance cultures within an organization

Discuss the possible benefits that a company obtains by forming strategic alliances with other companies. Explain why the strategy development process must involve managers at all organizational levels? How would you describe high performance culture..

  What is the dpmo measure for this process

Each unit could have as few as zero defects, and as many as five. After inspecting 2,000 units, they discovered 33 defects. What is the DPMO measure for this process?

  Legally sufficient consideration and will be enforceable

Which of the following promises is supported by legally sufficient consideration and will be enforceable?

  Determining the legal structure for a business

summary that should focus on the rationale used in determining the legal structure for a business. Be prepared to discuss in class.

  Claim for workers compensation benefits

Melanie " mel" insurer in injured on the job. she files a claim for workers compensation benefits. She is terminated for doing so. She had no contract for any specific term of employment. Mel nevertheless wants to bring a claim for wrongful discharge..

  What is slack and why is it important

What is "slack" and why is it important. Why is activity-on-arrow (AOA) or activity-on-node (AON) of significant value to the project manager

  Immediate and the general external environments

Globalization has tended to sharpen the distinction between the immediate and the general external environments

  What would be cost saving per hour from paying less money

A company has started a phone service that uses overseas doctors to provide emergency medical consultations. The responding doctors are based in a country with low wages but with a highly skilled pool of physicians. How much (in $) does the company p..

  From the e-activity-microsystem-mesosystem-exosystem

From the e-Activity, describe one (1) situation in your life from the past several years that required adjustment according to the Ecological theory. Discuss one to two (1-2) examples from your situation that apply to each of Bronfenbrenner’s five (5..

  Explain why the operation of revenue management systems

Once an airline publishes its schedule, the short run marginal cost of an additional passenger is very low. Explain why the operation of revenue management systems may set some ticket prices below that needed to cover fully-allocated cost.

  Explain differences between intended and realized strategy

Explain the differences between intended and realized strategy. Why is it so difficult to execute strategies just as they are originally planned? What can be done to minimize the gap between intended and realized strategies?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd