PA 13-3 Montanso sells genetically modified seed to farmers. It... Use Table 13.4 Montanso 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 (kg) of seed. It sells each kg for $43. If Montanso has more seed than demanded by the local farmers, the remaining seed is sent overseas. Unfortunately, only $4 per kg is earned 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, Montanso will use a normal distribution with a mean of 300000 and a standard deviation of 100000. If a part of the question specifies whether to use Table 13.4, or to use Excel, then credit for a correct answer will depend on using the specified method. How many kilograms should Montanso place in the warehouse before the growing season? Use Table 13.4 and round-up rule. If Montanso put 450000 kgs in the warehouse, what is its expected b. revenue (include both domestic revenue and overseas revenue)? Use Table 13.4 and round-up rule. How many kilograms should Montanso place in the warehouse to c. minimize inventory while ensuring that the stockout probability is no greater than 1%? Use Table 13.4 and round-up rule. d. What is maximum profit for this seed? TABLE 13.4 The Distribution, F(Q), and Expected Inventory, I(Q), Functions for the Standard Normal Distribution Function 1(2) z F(z) (z) F(z) Hz) F(z) .0000 -4.0 .0000 -1.3 .0968 .0455 .9192 1.4367 -3.9 .0000 .0000 . 1151 .0561 .9332 1.5293 -1.2 -1.1 1.4 1.5 1.6 1.7 .0001 .0000 .1357 .0686 .9452 1.6232 -3.8 -3.7 -3.6 .0001 .0000 -1.0 .1587 .0833 .9554 1.7183 .0002 .0000 .1841 . 1004 1.8 .9641 1.8143 -0.9 -0.8 -3.5 .0002 .0001 .2119 .1202 1.9 .9713 1.9111 -3.4 .0003 .0001 -0.7 .2420 .1429 2.0 .0005 .0001 -0.6 .2743 2.1 1687 .1978 .9772 2.0085 .98212.1065 9861 2.2049 .9893 2.3037 .0007 .0002 -0.5 .3085 -3.3 -3.2 -3.1 -3.0 2.2 .0010 .0003 -0.4 .3446 2304 2.3 .0013 .0004 -0.3 .3821 2668 2.4 .9918 2.4027 -2.9 .0019 .0005 .4207 .3069 -0.2 -0.1 2.5020 2.6015 -2.8 .0026 .0008 .4602 2.5 2.6 2.7 .3509 -2.7 .0035 .0011 .3989 .5000 .5398 .0047 .0015 4509 2.8 -2.6 -2.5 - .5069 2.9 .0062 .0082 .0020 .0027 -2.4 .9938 .9953 .9965 .9974 19981 .9987 .9990 .9993 .9995 .9997 .5668 .5793 .6179 .6554 .6915 3.0 3.1 2.7011 2.8008 2.9005 3.0004 3.1003 3.2002 3.3001 3.4001 .0037 .6304 .0107 .0139 .0179 .0049 -2.3 -2.2 -2.1 -2.0 -1.9 .6978 3.2 .0065 .7257 .7580 .7687 .8429 3.3 3.4 .0228 .0085 0287 .0111 .9202 3.5 3.6 -1.8 .0359 .7881 .8159 .8413 .0143 1.0004 .0446 .0183 1.0833 3.7 .9998 .9998 .9999 .9999 1.0000 1.0000 3.5001 3.6000 3.7000 3.8000 3.9000 4.0000 .0548 .0232 1.1 -1.7 -1.6 -1.5 -1.4 8643 1.1686 .0668 .0293 1.2 .8849 .9032 1.2561 1.3455 3.8 3.9 4.0 .0808 .0367 PA 13-3 Montanso sells genetically modified seed to farmers. It... Use Table 13.4 Montanso 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 (kg) of seed. It sells each kg for $43. If Montanso has more seed than demanded by the local farmers, the remaining seed is sent overseas. Unfortunately, only $4 per kg is earned 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, Montanso will use a normal distribution with a mean of 300000 and a standard deviation of 100000. If a part of the question specifies whether to use Table 13.4, or to use Excel, then credit for a correct answer will depend on using the specified method. How many kilograms should Montanso place in the warehouse before the growing season? Use Table 13.4 and round-up rule. If Montanso put 450000 kgs in the warehouse, what is its expected b. revenue (include both domestic revenue and overseas revenue)? Use Table 13.4 and round-up rule. How many kilograms should Montanso place in the warehouse to c. minimize inventory while ensuring that the stockout probability is no greater than 1%? Use Table 13.4 and round-up rule. d. What is maximum profit for this seed? TABLE 13.4 The Distribution, F(Q), and Expected Inventory, I(Q), Functions for the Standard Normal Distribution Function 1(2) z F(z) (z) F(z) Hz) F(z) .0000 -4.0 .0000 -1.3 .0968 .0455 .9192 1.4367 -3.9 .0000 .0000 . 1151 .0561 .9332 1.5293 -1.2 -1.1 1.4 1.5 1.6 1.7 .0001 .0000 .1357 .0686 .9452 1.6232 -3.8 -3.7 -3.6 .0001 .0000 -1.0 .1587 .0833 .9554 1.7183 .0002 .0000 .1841 . 1004 1.8 .9641 1.8143 -0.9 -0.8 -3.5 .0002 .0001 .2119 .1202 1.9 .9713 1.9111 -3.4 .0003 .0001 -0.7 .2420 .1429 2.0 .0005 .0001 -0.6 .2743 2.1 1687 .1978 .9772 2.0085 .98212.1065 9861 2.2049 .9893 2.3037 .0007 .0002 -0.5 .3085 -3.3 -3.2 -3.1 -3.0 2.2 .0010 .0003 -0.4 .3446 2304 2.3 .0013 .0004 -0.3 .3821 2668 2.4 .9918 2.4027 -2.9 .0019 .0005 .4207 .3069 -0.2 -0.1 2.5020 2.6015 -2.8 .0026 .0008 .4602 2.5 2.6 2.7 .3509 -2.7 .0035 .0011 .3989 .5000 .5398 .0047 .0015 4509 2.8 -2.6 -2.5 - .5069 2.9 .0062 .0082 .0020 .0027 -2.4 .9938 .9953 .9965 .9974 19981 .9987 .9990 .9993 .9995 .9997 .5668 .5793 .6179 .6554 .6915 3.0 3.1 2.7011 2.8008 2.9005 3.0004 3.1003 3.2002 3.3001 3.4001 .0037 .6304 .0107 .0139 .0179 .0049 -2.3 -2.2 -2.1 -2.0 -1.9 .6978 3.2 .0065 .7257 .7580 .7687 .8429 3.3 3.4 .0228 .0085 0287 .0111 .9202 3.5 3.6 -1.8 .0359 .7881 .8159 .8413 .0143 1.0004 .0446 .0183 1.0833 3.7 .9998 .9998 .9999 .9999 1.0000 1.0000 3.5001 3.6000 3.7000 3.8000 3.9000 4.0000 .0548 .0232 1.1 -1.7 -1.6 -1.5 -1.4 8643 1.1686 .0668 .0293 1.2 .8849 .9032 1.2561 1.3455 3.8 3.9 4.0 .0808 .0367