solution

At Green University, football related souvenirs have greatly contributed to the overall profitability of the football games. One such souvenir is the football program at each game. The number of programs sold (demand) at each game is described by the following probability distribution

Number of programs sold (D)

2300

2400

2500

2600

2700

Probability

0.15

0.22

0.24

0.21

0.18

Historically, Green has never sold fewer than 2300 programs or more than 2700 programs at one game. Each program costs $6 to produce and sells for $18. Any programs that are not sold are donated to local charity for free. Let D be the demand and Q be the order size.

  • If Q < D, then the store has sold all that was purchased and realized a net profit of $ 18Q – 6Q.
  • If Q > D, then the store has (Q-D) copies left over. D copies are sold at $18, and the remainder is donated. Thus, the net profit is $ 18D – 6Q.

To demonstrate the simulation process, develop 3 simulation runs, using random numbers (RN) given in the following table. These random numbers have been drawn randomly from a bag containing numbers from 00 to 99. University is looking at printing Q (2400, 2500 or 2600) programs, compute the profit for the 3 runs and then compute the average profit for each order size to determine the best Q.

Note: You must show all the details in setting up the simulation process.

Run #

RN

D

Profit

Q= 2400

Q = 2500

Q = 2600

1

33

2

45

3

77

Average Profit

Based on the average profit, what is the best order size Q?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"