Simulate the sales of programs at 10 football games use the

Question

I have two problem to be solved. I would appreciate if the answers are done in the same file of the question given.

Problem 1:

Every home football game for the past eight years at Eastern State University has been sold out. The revenues from the ticket sales are significant, but the sale of food beverages, and souvenirs has contributed greatly to the overrall 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
PROGRAMS SOLD	PROBABILITY
23	0.15
24	0.22
25	0.24
26	0.21
27	0.18

Historically, 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 program 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 radom 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 be the average profits be the 10games simulated in part(a)?

(c) If the university decided to print 2,600 programs for each game, what would the average profits be for the 10 games simulated in part (a)?

TABLE 13.4 Table of Radom Numbers
	7
	60
	77
	49
	76
	95
	51
	16
	14
	85
	59
	85
	40
	42
	52
	39
	73
	89
	88
	24
	1
	11
	67
	62
	51

Problem 2:

Stephanie Robbins is the Three Hills Power company management analyst assigned to stimulate maintenance costs. In section 13.6 we describe the simulation of 15 generator breakdowns and the repair times required when one repairperson is on duty per shift. The total simulated maintenance cost of current sysytem is $4,320.

Robbins would now like to examine the relative cost-effectiveness 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 one half the times required with only one repairperson on duty per shift.

The table 13.13 can then be restarted as follows:

REPAIR TIME REQUIRED (HOURS)	PROBABILITY
0.5	0.28
1	0.52
1.5	0.2
	1

 

(a) Simulate this proposed maintaince sysytem change over a 15-generator breakdown period. Select the random numbers needed for time between breakdowns from the second- from- the-bottom row of table 13.4 (beginning with the digits69). Select random numbers for generator repair times from the last row of the table.

(b) Should Three Hills add a second repairperson each shift?

Table 13.13 Generator Repair Times Required

	REPAIR TIME		NUMBER		CUMULATIVE	RADOM
	REQUIRED(HOURS)		OF TIMES	PROBABILITY	PROBABILITY	NUMBER
			OBSERVED			INTERVAL
	1		28	0.28	0.28	01 TO 28
	2		52	0.52	0.8	29 TO 80
	3		20	0.2	1	81 TO 00
	TOTAL		100	1

Select the random numbers needed for time between breakdowns from the second- from- the-bottom row of table 13.4 (beginning with the digits69). Select random numbers for generator repair times from the last row of the table.

second from the bottom row
69	84	12	94	51	36	17	2	15	29	16	52	56	43	26	22	8	62
last row of the table
37	77	13	10	2	18	31	19	32	85	31	94	81	43	31	58	33	51