Monsanto sells genetically modified seed to farmers. It needs to decide how much seed to put into a warehouse to serve demand for the next growing season. It will make one quantity decision. It costs Montanso $7 to make each kilogram (kilogram) of seed. It sells each kilogram for $43. If it has more seed than demanded by the local farmers, the remaining seed is sent overseas. Unfortunately, it only earns $4 per kilogram from the overseas market (but this is better than destroying the seed because it cannot be stored until next year). If demand exceeds its quantity, then the sales are lost?the farmers go to another supplier. As a forecast for demand, it will use a normal distribution with a mean of 300,000 and a standard deviation of 100,000. Use Table below

Note: If a part of the question specifies whether to use Table , or to use Excel, then credit for a correct answer will depend on using the specified method.

1) How many kilograms should Montanso place in the warehouse before the growing season? Use Table 13.4 and round-up rule.

2) If Montanso put 450,000 kilograms in the warehouse, what is its expected revenue (include both domestic revenue and overseas revenue)? Use Table and round-up rule.

3) How many kilograms should Montanso place in the warehouse to minimize inventory while ensuring that the stockout probability is no greater than 1%? Use Table and round-up rule.

4) What is maximum profit for this seed?

0.7 0.7580 0.8429 0.8 0.7881 0.9202 0.9 0.8159 1.0004 1.0 0.8413 1.0833 1.1 0.8643 1.1686 1.2 0.8849 1.2561 1.3 0.9032 1.3455 1.4 0.9192 1.4367 1.5 0.9332 1.5293 1.6 0.9452 1.6232 1.7 0.9554 1.7183 1.8 0.9641 1.8143 1.9 0.9713 1.9111 2.0 0.9772 2.0085 2.1 0.9821 2.1065 2.2 0.9861 2.2049 2.3 0.9893 2.3037 2.4 0.9918 2.4027 2.5 0.9938 2.5020 2.6 0.9953 2.6015 2.7 0.9965 2.7011 2.8 0.9974 2.8008 2.9 0.9981 2.9005 3.0 0.9987 3.0004 3.1 0.9990 3.1003 3.2 0.9993 3.2002 3.3 0.9995 3.3001 3.4 0.9997 3.4001 3.5 0.9998 3.5001 3.6 0.9998 3.6000 3.7 0.9999 3.7000 3.8 0.9999 3.8000 3.9 1.0000 3.9000 4.0 1.0000 4.0000