20 Jun Question Due Monday December 2, 8 a.m. A reminder of the rules: You areFORBIDDE
Question
Due Monday December 2, 8 a.m.
A reminder of the rules: You areFORBIDDENto:
Work with or talk with anyone else about the midterm. This is a solo effort – YOUR effort.
Talk to anyone or ask anyone but this course’s TA or the Professor about any questions you may have.
Give hints to another student about the exam or send them your Excel file.
Review any past exams from prior years for this class.
Failure to abide by these rules will result in sanctions as described in the University’s academic code of conduct and will result in a failing grade for the course.
Rules for Submission
(otherwise we spend as much time trying to figure out what’s what as we do grading)
1. Type your name in cell G2 in the worksheet called Q21 to verify that you understand and have abided by the rules for this exam.
2. There are 20 multiple choice/fill in the blank questions online on Moodle. Be sure to complete those questions, AND the following questions below. For the questions on Moodle, you can save but not submit while you are working on the questions, and then submit ONLY when you have completed them. You can only submit your answers to the Moodle questions ONCE. The questions below should be completed in the excel file and uploaded to Moodle.
3. You will upload to Moodle the Excel File: Rename the Excel file: <yourlastname>.
4. Complete the questions online and upload your Excel file
The number in parentheses after each question number is how many points that problem is worth.
21. (8) Your hospital’s surgical services department has 8 Operating Rooms. The Operating Rooms are currently staffed from 7 am to 3 pm. Each room has its own staff.
Current demand for surgical services results in an average of 2 surgeries done per room per day.
Each surgical procedure (excluding setup and cleanup time) lasts 2.5 hours, on average.
Room Resource:Before each surgery, an OR must be set up, which takes on average 30 minutes. Thus, the room is unavailable to start a surgery until setup is complete. Set up for the next day’s surgical procedures cannot be done the day before – thus, although the staff arrives at 7 am, they must spend their first half hour of work setting up the ORs for that day’s first surgical procedure in each room. After each surgery, an OR must be cleaned, again, taking on average 30 minutes, making it unavailable for set up for the next surgery until cleanup has been complete. Thus, each surgery generates an hour of OR room ‘downtime’.
Staff Resource:Setup and cleanup are conducted by the OR staff, so the staff is available and working during set up and clean up times. However, each room’s staff takes a ½ hour break sometime during the 8 hour shift.
Complete the following daily capacity questions for the surgical services department in worksheet Q21.
Be sure your answers show formulas referring to cells, not just calculations (so, set it up as a model as indicated in the spreadsheet). If there is just an answer typed in the cell that we don’t know where it came from, or you will receive 0 credit even if you have the right answer.
Please note that you do NOT need to set up a big flow time analysis table like in the homework. Just use the table provided Excel sheet to enter the data, and then refer to those cells to answer the questions below in the appropriate Excel cells.
21a: If the ORs could be open 24 hours a day, the daily theoretical capacity of the hospital’s ORs would be: ________ surgical procedures (answer for the 8 ORs, not an individual OR)
However, since the ORs are staffed for only 8 hours a day, answer the remaining questions assuming 8 hours per OR per day, and provide an answer for all 8 ORs, not one individual OR.
21b: The daily theoretical capacity of the hospital’s ORs is: ________ surgical procedures
21c: The daily effective capacity of the hospital’s ORs is: ________ surgical procedures
21d: The daily actual throughput of the hospital’s ORs is: ________ surgical procedures
21e: The daily theoretical capacity of the hospital’s OR staffing is: ________ surgical procedures
21f: The daily effective capacity of the hospital’s OR staffing is: ________ surgical procedures
21g: Suppose both the setup and cleanup time could be reduced from 30 minutes each to 15 minutes each. The new daily effective capacity of the hospital’s ORs would be: ________ surgical procedures
A: worksheet Q22basecase
(30 points) Your hospital has an inpatient unit dedicated to patients who are admitted for diabetes related issues. Once a patient is admitted, the first thing that must happen is for the physician to order bloodwork. The steps of what transpires are shown below. All steps are sequential (one must be completed before the next can start), with the exception that steps 7&8 can be run concurrently to step 9 (assume lab tech is not needed for steps 7,8, and 9). When the lab tech assembles the results of the two tests in step 10, he finds that 20% of the time, there is an error, and steps 6,7,8, 9 and 10 must be repeated. (Assume he has kept a portion of the sample in the event that this rework is needed and that he never “runs out” of a sample that necessitates having to back up to re-draw more blood from the patient.) The process flow chart, and tables are shown on worksheet Q22 base case.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.