Novelty Toy Company has just approved a prototype for a Super Bowl MVP Bobblehead figurine and wants to start production. They know that sales of this product are highly uncertain, but having sold similar merchandise in the past, they believe demand to be normally distributed with a mean of 35,000 and standard deviation of 5,000. (We expect this to be the total of all demand during the NFL off-season. No discounts on this product will be offered.)

The production cost of this item is $9.00 per unit, and the items will be sold for a price of $15.00 per unit.

After having these items for sale on their website throughout the NFL off-season, all unsold items will be returned to the factory to be recycle/repurposed (Novelty Toy Company will remove all paint from these items and repaint them in the image of the #1 Draft NFL Pick to capitalize on the start of a new season). The cost of repurposing these unused items is $2 per item.

Help Novelty Toy Company to decide on a production quantity for this item. Use Monte Carlo Simulation to evaluate production quantities from 25,000 to 50,000, in increments of 5,000.

Run a single (2-variable) Excel Data Table with 1000 iterations (rows) of profit for each of the different production quantities.