Please solve 5-24 in excel

bookshelf.vitalsource.com C Apple A Country Ca.: EBSCOhost Office 365 Oaks Christian Digital Reso..croeconomics Files ARE 155 Excel Study Guide - Google Sheets Solved: Consider the MSA marketing research example. eTextbooks | Rent or Buy Online Textbooks | VitalSour. VitalSource Bookshelf: Managerial Decision Modeling. Integer Constraints in Linear Programming - YouTube OO D 18 16 14 16 Favorites Solved Problem 5-2 Table for Problem 5-22 Apple Go to Solved Problem 5-2 A Country Called Prison :.. To To Office 365 Q 195 Solution Q Oaks Christian Plant Supply Store Demand From K From X V Z K L Digital Resources for Macr... A 400 X 400 A 54 $7 $4 $56 $5 Bookmarks Menu AT&T U-verse- Online Self.. R 500 Y 325 $5 $4 K $7 AT&T U-verse- Support Site AT&T U-verse- Manage Yo. C 350 400 Se 57 $5 $7 Poema Autobiografico Fini. The plant supervisor would like to assign jobs so that total time is minimized. Use the assignment model to find the best solution. 13. 5-24 Greg Pickett, coach of a little-league baseball team, is preparing for a series of four games against four good opponents. Greg would like to increase the probability of winning as many games as possible by carefully scheduling his pitchers against the teams they are each most likely to defeat. Because the games are to be played back to back in less than one week, Greg cannot count on any pitcher to start in more than one game. Greg knows the strengths and weaknesses not only of his pitchers but also of his opponents, and he believes he can estimate the probability of winning each of the four games with each of the four starting pitchers. Those probabilities are listed in the table at the top of the next column. Opponent Starting Pitcher Des Moines Davenport Omaha Peoria Jones 0.40 0,80 0.50 0.60 Baker 0.30 0.40 0.80 0.70 Parker 0.80 0.80 0.70 0.90 Wilson 0.20 0.30 0.40 0.50 What pitching rotation should Greg set to provide the highest sum of the probabilities of winning each game for his team? 14. 5-25 Cindy Jefferson, hospital administrator at Anderson Hospital must appoint head nurses to four newly established departments: urology, cardiology, orthopedics, and pediatrics. Believing in the decision modeling approach to problem solving, Cindy has interviewed four nurses-Morris, Richards, Cook, and Morgan-and developed an index scale ranging from 0 to 100 to be used in the assignment. An index of 0 implies that the nurse would be perfectly suited to that task. A value close to 100, on the other hand, implies that the nurse is not at all suited to head that unit. The following table gives the complete set of index scales that Cindy feels represent all possible assignments. 202 Aa )