
Introduction to Management Science 12th Edition by Bernard Taylor
Edition 12ISBN: 978-0133778847
Introduction to Management Science 12th Edition by Bernard Taylor
Edition 12ISBN: 978-0133778847 Exercise 3
State University is playing Tech in their annual football game on Saturday. A sportswriter has scouted each team all season and accumulated the following data: State runs four basic plays- a sweep, a pass, a draw, and an off tackle; Tech uses three basic defenses-a wide tackle, an Oklahoma, and a blitz. The number of yards State will gain for each play against each defense is shown in the following table:
The probability that State will run each of its four plays is shown in the following table:
The probability that Tech will use each of its defenses follows:
The sportswriter estimates that State will run 40 plays during the game. The sportswriter believes that if State gains 300 or more yards, it will win; however, if Tech holds State to fewer than 300 yards, it will win. Use simulation to determine which team the sportswriter will predict to win the game.



Explanation
Use the Excel spreadsheet belo...
Introduction to Management Science 12th Edition by Bernard Taylor
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255