please use solver/excel for accurate answers

Problem 5 03 Data envelopment analysis can measure the relative efficiency of a group of hospitals. The following data from a particular study involving seven teaching hospitals include three input measures and four output measures Hospital Input Measures Full Time Supply Equivalent Expence Nonphysicians (1000) 310.0 134.60 278.5 114.30 165.6 131.30 250.0 316.00 206.4 151.20 384.0 217.00 530.1 770.80 Bed Days Available (1000) 116.00 106.80 65.52 94.40 102.10 153.70 215.00 Nurses Interns Trained Hospital Trained Output Measures Patient Days Patient Days (65 or older) (under 65) (1000) (1000) 55.31 49.52 37.64 55.63 32.91 25.77 33.53 41.99 15 141 160 21 Patient Days (65 oder) (1000) Patient Days (under 65) (10 ) Trained and 32.91 32.45 55 10 119.70 Formulate a linear programming model that can be used to performa there is before the bank. If your answerere, ter n cement analysis for hop the na m e . If required, round your answer in the w w heplied to inputs and outputs for hospital w e d to us and outputs for hospital d oudous for hospital wf-weight e d to puts and outputs for hospital ght applied to put outputs for hospital 1 153.0 wwwwww . places. If you enter the conti b. Solve the model. Round your answers to two decimal places. If your answer is zero, enter "0". If the constant is "1" it must be entered in the box C. Is hospital E relatively inefficient? What is the interpretation of the value of the objective function? The value of the objective function indicates that the resources used by Hospital are required to produce the outputs of Hospital. d. Which hospitals are involved in making up the composite hospital? Can you make a general statement about which hospitals will make up the composite unit associated with a unit that is not inefficient? Explain. If a hospital is not relatively inefficient, the hospital the composite hospital with weight equal to 1. Problem 5 03 Data envelopment analysis can measure the relative efficiency of a group of hospitals. The following data from a particular study involving seven teaching hospitals include three input measures and four output measures Hospital Input Measures Full Time Supply Equivalent Expence Nonphysicians (1000) 310.0 134.60 278.5 114.30 165.6 131.30 250.0 316.00 206.4 151.20 384.0 217.00 530.1 770.80 Bed Days Available (1000) 116.00 106.80 65.52 94.40 102.10 153.70 215.00 Nurses Interns Trained Hospital Trained Output Measures Patient Days Patient Days (65 or older) (under 65) (1000) (1000) 55.31 49.52 37.64 55.63 32.91 25.77 33.53 41.99 15 141 160 21 Patient Days (65 oder) (1000) Patient Days (under 65) (10 ) Trained and 32.91 32.45 55 10 119.70 Formulate a linear programming model that can be used to performa there is before the bank. If your answerere, ter n cement analysis for hop the na m e . If required, round your answer in the w w heplied to inputs and outputs for hospital w e d to us and outputs for hospital d oudous for hospital wf-weight e d to puts and outputs for hospital ght applied to put outputs for hospital 1 153.0 wwwwww . places. If you enter the conti b. Solve the model. Round your answers to two decimal places. If your answer is zero, enter "0". If the constant is "1" it must be entered in the box C. Is hospital E relatively inefficient? What is the interpretation of the value of the objective function? The value of the objective function indicates that the resources used by Hospital are required to produce the outputs of Hospital. d. Which hospitals are involved in making up the composite hospital? Can you make a general statement about which hospitals will make up the composite unit associated with a unit that is not inefficient? Explain. If a hospital is not relatively inefficient, the hospital the composite hospital with weight equal to 1