Details of this Paper

Every home football game for the past eight years

Description

solution


Question

Question;4-19Every home football game for the past eight years at Eastern State University has been sold out. The revenuesfrom ticket sales are significant, but the sale of food, beverages, and souvenirs has contributed greatlyto the overall profitability of the football program. One particular souvenir is the football program for eachgame. The number of programs sold at each game is described by the following probability distributionNUMBER (IN 100s) OFPROGRAMS SOLD PROBABILITY23 0.1524 0.2225 0.2426 0.2127 0.18Historically, Eastern has never sold fewer than 2,300 programs or more than 2,700 programs at one game.Each program costs $0.80 to produce and sells for $2.00. Any programs that are not sold are donated toa recycling center and do not produce any revenue.(a) Simulate the sales of programs at 10 football games. Use the last column in the random number table (Table 14.4) and begin at the top of the column.(b) If the university decided to print 2,500 programs for each game, what would the average profits befor the 10 games simulated in part (a)?(c) If the university decided to print 2,600 programs for each game, what would the average profits befor the 10 games simulated in part (a)?Random Number table to be used52 06 50 88 53 30 10 47 99 37 66 91 35 32 00 84 57 0737 63 28 02 74 35 24 03 29 60 74 85 90 73 59 55 17 6082 57 68 28 05 94 03 11 27 79 90 87 92 41 09 25 36 7769 02 36 49 71 99 32 10 75 21 95 90 94 38 97 71 72 4998 94 90 36 06 78 23 67 89 85 29 21 25 73 69 34 85 7696 52 62 87 49 56 59 23 78 71 72 90 57 01 98 57 31 9533 69 27 21 11 60 95 89 68 48 17 89 34 09 93 50 44 5150 33 50 95 13 44 34 62 64 39 55 29 30 64 49 44 30 1688 32 18 50 62 57 34 56 62 31 15 40 90 34 51 95 26 1490 30 36 24 69 82 51 74 30 35 36 85 01 55 92 64 09 8550 48 61 18 85 23 08 54 17 12 80 69 24 84 92 16 49 5927 88 21 62 69 64 48 31 12 73 02 68 00 16 16 46 13 8545 14 46 32 13 49 66 62 74 41 86 98 92 98 84 54 33 4081 02 01 78 82 74 97 37 45 31 94 99 42 49 27 64 89 4266 83 14 74 27 76 03 33 11 97 59 81 72 00 64 61 13 5274 05 81 82 93 09 96 33 52 78 13 06 28 30 94 23 37 3930 34 87 01 74 11 46 82 59 94 25 34 32 23 17 01 58 7359 55 72 33 62 13 74 68 22 44 42 09 32 46 71 79 45 8967 09 80 98 99 25 77 50 03 32 36 63 65 75 94 19 95 8860 77 46 63 71 69 44 22 03 85 14 48 69 13 30 50 33 2460 08 19 29 36 72 30 27 50 64 85 72 75 29 87 05 75 0180 45 86 99 02 34 87 08 86 84 49 76 24 08 01 86 29 1153 84 49 63 26 65 72 84 85 63 26 02 75 26 92 62 40 6769 84 12 94 51 36 17 02 15 29 16 52 56 43 26 22 08 6237 77 13 10 02 18 31 19 32 85 31 94 81 43 31 58 33 51Please complete using excel solver

 

Paper#62055 | Written in 18-Jul-2015

Price : $19
SiteLock