1319 Every home football game for the past eight years at Eastern State University has been sold out. The revenues from ticket sales are significant, but the sale of food, beverages, and souvenirs has contributed greatly to the overall profitability of the football program. One particular souvenir is the football program for each game. The number of programs sold at each game is described by the following probability distribution. Number (in 100s) of Probability Programs sold 23 24 25 26 27 0.15 0.22 0.24 0.21 0.18 Historically, Eastern has never sold fewer than 2,300 programs or more than 2.700 programs at one game. Each program costs $.80 to produce and sells for $2.00. Any programs that are not sold are donated to a 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 13.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 be for 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 be fore the 10 games simulated in part (a.)? Problem 1325 Stephanie Robbins is the Three Hills Power Company management analyst assigned to simulate maintenance costs. In section 13.6 we describe the simulation of 15 generator breakdowns and the repair times required when on repair person is on duty per shift. The total simulated maintenance cost of the current system is $4,320. Robbins would now like to examine the relative costeffectiveness of adding one more worker per shift. Each new repairperson would be paid $30 per hour, the same rate as the first is paid. The cost per breakdown hour is still $75. Robbins makes one vital assumption as she begins - that repair times with two workers will be exactly onehalf the times required with only one repairperson on duty per shift. Table 13.13 can then be restated as follows. Repair time Required (Hours) 0.5 1 1.5 Probability 0.28 0.52 0.20 1.00 a. Simulate this proposed maintenance system change over a 15generator breakdown period. Select the random numbers needed for time between breakdowns from the secondfromthebottom row of table 13.4 (beginning with the digits 69). Select random numbers for generator repair times from the last row of the table (beginning with 37). b. Should Three Hills add a second repairperson each shift? A 1 Problem 13-19 Template 2 3 4 5 6 7 8 9 10 11 B 12 13 14 15 16 17 Number (in 100s) of Programs Sold 23 24 25 26 27 Probability 0.15 0.22 0.24 0.21 0.18 C D E F G H I J K Cumulative Probability Interval of Random Number (range defined by Cumulative Probability) Day Random Number Selection (from Table 14.4) Demand (100s) based on selected Random Number Part b: Quantity Sold Part b: Profit Part c: Quantity Sold Part c: Profit Problem 13-25 Template Repair Time Required (Hours) 0.50 1.00 1.50 Probability 0.28 0.52 0.20 Cumulative Probability Interval of Random Number (range defined by Cumulative Probability) Breakdown Number Random Number Selection (from Table 14.4) Time Between Breakdowns (hrs) (from Table 14.12) Convert Time Between Breakdowns to 00:00 Format Time of Breakdown (00:00) Repair Time Required (hrs) Time this Person is Random Number (range defined by Free to Begin this Selection Cumulative Repair (00:00) (from Table 14.4) Probability) Convert Repair Number of Time Required Time Repair Hours Machine to 00:00 Format Ends (00:00) is Down Problem 1319 Every home football game for the past eight years at Eastern State University has been sold out. The revenues from ticket sales are significant, but the sale of food, beverages, and souvenirs has contributed greatly to the overall profitability of the football program. One particular souvenir is the football program for each game. The number of programs sold at each game is described by the following probability distribution. Number (in 100s) of Probability Programs sold 23 24 25 26 27 0.15 0.22 0.24 0.21 0.18 Historically, Eastern has never sold fewer than 2,300 programs or more than 2.700 programs at one game. Each program costs $.80 to produce and sells for $2.00. Any programs that are not sold are donated to a 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 13.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 be for 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 be fore the 10 games simulated in part (a.)? Problem 1325 Stephanie Robbins is the Three Hills Power Company management analyst assigned to simulate maintenance costs. In section 13.6 we describe the simulation of 15 generator breakdowns and the repair times required when on repair person is on duty per shift. The total simulated maintenance cost of the current system is $4,320. Robbins would now like to examine the relative costeffectiveness of adding one more worker per shift. Each new repairperson would be paid $30 per hour, the same rate as the first is paid. The cost per breakdown hour is still $75. Robbins makes one vital assumption as she begins - that repair times with two workers will be exactly onehalf the times required with only one repairperson on duty per shift. Table 13.13 can then be restated as follows. Repair time Required (Hours) 0.5 1 1.5 Probability 0.28 0.52 0.20 1.00 a. Simulate this proposed maintenance system change over a 15generator breakdown period. Select the random numbers needed for time between breakdowns from the secondfromthebottom row of table 13.4 (beginning with the digits 69). Select random numbers for generator repair times from the last row of the table (beginning with 37). b. Should Three Hills add a second repairperson each shift? A 1 Problem 13-19 Template 2 3 4 5 6 7 8 9 10 11 B 12 13 14 15 16 17 Number (in 100s) of Programs Sold 23 24 25 26 27 Probability 0.15 0.22 0.24 0.21 0.18 C D E F G H I J K Cumulative Probability Interval of Random Number (range defined by Cumulative Probability) Day Random Number Selection (from Table 14.4) Demand (100s) based on selected Random Number Part b: Quantity Sold Part b: Profit Part c: Quantity Sold Part c: Profit Problem 13-25 Template Repair Time Required (Hours) 0.50 1.00 1.50 Probability 0.28 0.52 0.20 Cumulative Probability Interval of Random Number (range defined by Cumulative Probability) Breakdown Number Random Number Selection (from Table 14.4) Time Between Breakdowns (hrs) (from Table 14.12) Convert Time Between Breakdowns to 00:00 Format Time of Breakdown (00:00) Repair Time Required (hrs) Time this Person is Random Number (range defined by Free to Begin this Selection Cumulative Repair (00:00) (from Table 14.4) Probability) Convert Repair Number of Time Required Time Repair Hours Machine to 00:00 Format Ends (00:00) is Down