Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve this using please Excel Solver feature and explain your work as you go along The weekly profit at Pickens Memorial Hospital depends on

Please solve this using please Excel Solver feature and explain your work as you go along

image text in transcribed The weekly profit at Pickens Memorial Hospital depends on the number of patients admitted in three separate categories (medical, surgical, and pediatric). The hospital can admit a total of 200 patients (regardless of category) each week. However, because Pickens Memorial serves a large community, patient demand in each category by itself, far exceeds the total patient capacity. Due to a fixed overhead, the profit per patient in each category actually. increases as the number of patients increase. Further, some patients who are initially classified as medical patients then get reclassified as surgical patients. As a result, the profit per surgical patient also depends on the number of medical patients admitted. The following information has been provided by the accounting department: Profit contribution per medical patient =$45+$2M Profit contribution per surgical patient =$70+$3S+$2M Profit contribution per pediatric patient =$60+$3P Where M,S, and P are the number of medical, surgical, and pediatric patients. Pickens Memorial has identified 3 main constraints for this model: x-ray capacity, marketing budget, and lab capacity. The table below shows the relevant weekly data for these thee constraints, for each category of patient. The table also shows the weekly availabilities of each of these three resources. In addition, based on historical data, the lab supervisor believes the time required per lab test increases as the number of medical patients increase, as follows: Time required per lab test (in hours) =0.2+.001M Pickens seeks to maximize its weekly profit by selecting the optimal amount of each type of patient to admit. Set up this problem as a non-linear programming problem. Solve this problem with Solver

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Purchasing and Supply Chain Management

Authors: W.C Benton

3rd edition

78024110, 978-0078117091, 78117097, 978-0078024115

More Books

Students also viewed these General Management questions

Question

It is made up DNA threads?

Answered: 1 week ago

Question

It initiates and regulates cell division?

Answered: 1 week ago

Question

It contains chromatin fibres?

Answered: 1 week ago

Question

Chromatin fibres is made up of DNA AND........?

Answered: 1 week ago

Question

The structure of DNA was first discovered by.........

Answered: 1 week ago