hw quantitative analysis
I have to give the answers in Excel QM
problem 1
The three princes of Serendip
Went on a little trip.
They could not carry too much weight;
More than 300 pounds made them hesitate.
They planned to the ounce. When they returned to Ceylon
They discovered that their supplies were just about gone
When, what to their joy, Prince William found
A pile of coconuts on the ground.
“Each will bring 60 rupees,” said Prince Richard with a grin
As he almost tripped over a lion skin.
“Look out!” cried Prince Rupert with glee
As he spied some more lion skins under a tree.
“These are worth even more – 300 rupees each
If we can just carry them down to the beach.”
Each skin weighed fifteen pounds and each coconut, five,
But they carried them all and made it alive.
The boat back to the island was very small.
15 cubic feet baggage capacity – that was all.
Each lion skin took up one cubic foot
While eight coconuts the same space took.
With everything stowed away they headed to sea
And on the way calculated what their new wealth might be.
“Eureka!” cried Prince Rupert. “Our worth is so great
That there’s no other way we could return in this state.
Any other skins or nut which we might have brought
Would now have us poorer. And now I know what –
I’ll write my friend Horace in England, for surely
Only he can appreciate our serendipity.”
formalate and solve serendipity by graphical LPin order to calculate what their new wealth might be
problem 2
Prepare a written report to the CEO of Mt. Sinai Hospital in Problem 8-18 on the expansion of the hospital. Round off your answers to the nearest integer. The format of presentation of results is important. The CEO is a busy person and wants to be able to find your optimal solution quickly in your report. Cover all the areas given in the following sections, but do not mention any variables or shadow prices.
(a) What is the maximum revenue per year, how many medical patients/year are there, and how many surgical patients/year are there? How many medical beds and how many surgical beds of the 90-bed addition should be added?
(b) Are there any empty beds with this optimal solution? If so, how many empty beds are there? Dis¬cuss the effect of acquiring more beds if needed.
(c) Are the laboratories being used to their capacity? Is it possible to perform more lab tests/year? If so, how many more? Discuss the effect of acquiring more lab space if needed.
(d) Is the x-ray facility being used to its maximum? Is it possible to do more x-rays/year? If so, how many more? Discuss the effect of acquiring more x-ray facilities if needed.
Is the operating room being used to capacity? Is it possible to do more operations/year? If so, how many more? Discuss the effect of acquiring more operating room facilities if needed.
(e) is the operating room being used to capacity ? is it possible to do more operations/year? if so, how many more ? discuss the effect of acquiring more operating room room facilities if needed.
