In preparing for the upcoming holiday season, Fresh Toy Company(FTC) designed a new doll called The Dougie that teaches childrenhow to dance. The fixed cost to produce the doll is $120,000. Thevariable cost, which includes material, labor, and shipping costs,is $30 per doll. During the holiday selling season, FTC will sellthe dolls for $45 each. If FTC overproduces the dolls, the excessdolls will be sold in January through a distributor who has agreedto pay FTC $8 per doll. Demand for new toys during the holidayselling season is extremely uncertain. Forecasts are for expectedsales of 40,000 dolls with a standard deviation of 10,000. Thenormal probability distribution is assumed to be a good descriptionof the demand. FTC has tentatively decided to produce 40,000 units(the same as average demand), but it wants to conduct an analysisregarding this production quantity before finalizing thedecision.

1. Create a what-if spreadsheet model using a formula that relatethe values of production quantity, demand, sales, revenue fromsales, amount of surplus, revenue from sales of surplus, totalcost, and net profit. What is the profit corresponding to averagedemand (40,000 units)?
   
   $  
2. Modeling demand as a normal random variable with a mean of40,000 and a standard deviation of 10,000, simulate the sales ofthe Dougie doll using a production quantity of 40,000 units. Whatis the estimate of the average profit associated with theproduction quantity of 40,000 dolls? Round your answer to thenearest dollar.
   
   $  
3. Before making a final decision on the production quantity,management wants an analysis of a more aggressive 50,000-unitproduction quantity and a more conservative 30,000-unit productionquantity. Run your simulation with these two production quantities.What is the mean profit associated with each? Round your answers tothe nearest dollar.
   
   30,000-unit production quantity: $  
   
   50,000-unit production quantity: $  
4. Compare the three production quantities (30,000, 40,000, and50,000) using all these factors. What trade-offs occur? Round youranswers to 3 decimal places.
   
   30,000 units:
   
   40,000 units:
   
   50,000 units: