16 A hospital is planning an $8 million addition to its existing facility. The architect has been...
Question:
16 A hospital is planning an $8 million addition to its existing facility. The architect has been asked to consider the following design parameters: (1) There should be at least 10 and no more than 20 intensive care unit
(ICU) rooms; (2) there should be at least 10 and no more than 20 cardiac care unit (CCU) rooms; (3) there should be no more than 50 double rooms; (4) there should be at least 35 single rooms; and (5) all patient rooms should fit inside the allotted 40,000-square-foot space (not including hallways). The following table summarizes the relevant room data:
SINGLE DOUBLE ICU CCU Cost per room to build and furnish
($thousands)
$45 $54 $110 $104 Minimum square feet required 300 360 320 340 Profit per room per month ($thousands)
$21 $28 $ 48 $ 41 How many rooms of each type should the architect include in the new hospital design?
Step by Step Answer:
Managerial Decision Modeling With Spreadsheets
ISBN: 9781292024196
3rd Edition
Authors: Barry Render