You are managing a computer store and are trying to determine the number of computers to keep in stock. Your current policy is to order 1100 computers whenever end-of-month inventory is 400 computers or less. Each time an order is placed a xed cost of $600 and a variable cost of $1500 per computer is incurred. Your store sells the computers for $2800 each. Ifyou don't have any computers in stock a customer buys a computer from a competitor. At the end of each month, there is a holding cost of $10 for each computer in stock. Orders are placed at the end of a month and are delivered in approximately 4 weeks. For example, if you order at the end of Month 1, the delivery will take place at the end of Month 2, and the new computers can be sold starting in Month 3 (the computers will be added to the stock before inventory is taken at the end of Month 2 - the holding cost applies to all inventory at the end of the month). Assume that demand for computers each month is a random variable that is normally distributed with mean 400 and standard deviation 100 and at the beginning of Month 1 you have 200 computers. A simulation model has been created for evaluating this inventory restocking policy for the next 2 years assuming that salvage value for items that remain in stock at the end of month 24 is 0. Question 6 3 pts What formula should appear in cell D10? Choose all that apply. O MIN ( B10, C10) O MAX (B10, C10) O B10 O C10 + IF(C10-B10>0, B10-C10, 0) O C10 + IF(B10-C10>0, B10-C10, 0)A A I B D E i F G H I 1 Reorder point 400 mean demand 400 2 Reorder quantity 1100 stdev demand 100 Price 52,300 variable cost $1,500 Fixed cost 5600 inventory holding 005' $10 Month Beginning Demand Units Ending Reorder Revenue Holding Reorder Cost Inventory so Id Inventory qua ntltvr cost 1 200 742 200 0 1100 560,000 0 1,650,600 2 0 491 0 1100 0 0 11,000 0 3 1100 354 354 746 0 939,95 1 7,464 0 4 746 334 334 363 1100 1,074,264 3,623 1,650,6{l} 14 5 363 357 357 1106 0 993,462 11,062 0 6 1106 450 450 656 0 1,261,302 6,557 0 7 656 291 291 365 1100 814,765 3,647 1,650,600 3 365 623 365 1100 0 1,021,257 11,000 0 9 1100 542 542 553 0 1,513,072 5,573 0 19 10 553 549 549 9 1100 1,537,068 39 1,650,600 20 11 9 335 9 1100 0 24,860 11,000 0 II 12 1100 396 396 704 0 1,109,546 7,037 0 22 13 704 459 459 244 1100 1,286,367 2,443 1,650,600 23 14 244 365 244 1100 0 634,037 11,013) 0 24 15 1100 316 316 734 0 833,745 7,344 0 25 16 784 489 489 295 1100 1,369,555 2,952 1,650,600 26 17 295 481 295 1100 0 826,700 11,000 0 27 18 11W 361 361 739 0 1,069,649 7,394 0 23 19 239 410 410 329 1100 1,146,094 3,294 1,650,600 29 20 329 338 329 1100 0 922,257 11,000 0 30 21 1100 387 387 713 0 1,082,820 7,133 0 31 22 713 378 373 335 1100 1,057,967 3,354 1,650,600 32 23 335 357 335 1100 0 939,213 11,!!!) 0 33 24 1100 334 334 716 0 1,074,324 7,153 0 34 35 Revenue Inv 1:051 Reorder Cost 36 23,194,324 163,641 13,204,800 37 Profit 33 $9,825,383.21 \\- Question 8 3 pts Fill in the blanks to complete the formula appearing in cell F10. Each blank is a cell index. Write down the cell index without any space. For example, write down $F$1 instead of $F $1. The formula should be able to use the drag and fill functionality in Excel. |F(