The daily demand for the latest monitor at Millennium Computer Corp. follows a uniform distribution between 5 and 20. Millennium Computer purchases these minitors for $55 and sells them for $100. It costs the company $20 to place an order and $0.5 for every monitor held in inventory at the end of each day. Millennium Computer's inventory is replenished once every day as follows. At the beginning of each day, Millennium Computer reviews its inventory. If there are less than 17 units in inventory, Millennium Computer orders monitors so that the inventory level is moved up to 17. For example, if there are 8 monitors in inventory, Millennium Computer orders 9 monitors so its inventory will be moved up to 17. Assume the initial inventory on Day 1 is 15 units, any unmet demand on any day is lost to competitors, and order placed at the beginning of each day arrives immediately. For each unit of met demand, a shortage cost of $65 will incur. (a) [4 PTS] Fill out the following table. Initial Order Inv. Q Inv. After Order is Received Demand Number Ending Sold Inv. Day 18 16 Ordering Purchase Holding Shortage Cot Cost Cost Cost Shortage Revenue Profit (b) (2 PTS] Compute the average daily profit and the service level from the table in part (a). Average daily profit: Service level: () (2 Pts] If the initial inventory is less than 17, the order quantity equals Otherwise, the order quantity equals 0. i. initial inventory - 17 ii. 17-initial inventory iii. 17 iv. initial inventory Consider the following Excel spreadsheet. ABC 2 Initial Order nu. Ale Dully Number Inding Number Gebeng Puchong Shortage Dolly Day InventoryQuantity Onders Received Demand Sold Im Not Met een Cost Cod Cow Prote 1 15 2 3 4 5 6 IMNI 10 71 1 9 10 14 15 16 Summary Me TE 19 Mean Daily Profit Standard Deviation Minimum Daily Pro Musim Bally Profit Service level 21 i. (2 PTS) Using part (c), write down the Excel formula you would use for cell 14 ii. [1 pr] Write down the expression you would use for cell F4. iii. (2 PTS] If the demand is less than the initial inventory after the order is received, then the number of units sold is equal to Otherwise, the number of units sold is equal to iv. [1 Pr] Using the previous part, write down Excel formula you would use for cell H4. v. (2 PTS) If the demand is less than the initial inventory after the order is received, then the ending inventory is equal to Other- wise, the ending inventory is equal to vi. [1 PT] Using the previous part, write down Excel formula you would use for cell 14 vii. (2 PTS] If the demand is less than the initial inventory after the order is received, then the shortage is equal to Otherwise, the shortage is equal to viii. (1 PT] Using the previous part, write down Excel formula you would use for cell J4. ix. [1 PT] Write down the Excel formula you would use for cell K4. x. [1 PT] Write down the Excel formula you would use for cell L4. xi. [1 PT] Write down the Excel formula you would use for cell M4. xii. (1 PT] Write down the Excel formula you would use for cell N4. xiii. (1 pt) Write down the Excel formula you would use for cell 04. xiv. (1 pt] Write down the Excel formula you would use for cell P5. xv. (1 PT] Write down the Excel formula you would use for cell D5. xvi. (2 PTS) Write down the Excel formula you would use for cell G21. The daily demand for the latest monitor at Millennium Computer Corp. follows a uniform distribution between 5 and 20. Millennium Computer purchases these minitors for $55 and sells them for $100. It costs the company $20 to place an order and $0.5 for every monitor held in inventory at the end of each day. Millennium Computer's inventory is replenished once every day as follows. At the beginning of each day, Millennium Computer reviews its inventory. If there are less than 17 units in inventory, Millennium Computer orders monitors so that the inventory level is moved up to 17. For example, if there are 8 monitors in inventory, Millennium Computer orders 9 monitors so its inventory will be moved up to 17. Assume the initial inventory on Day 1 is 15 units, any unmet demand on any day is lost to competitors, and order placed at the beginning of each day arrives immediately. For each unit of met demand, a shortage cost of $65 will incur. (a) [4 PTS] Fill out the following table. Initial Order Inv. Q Inv. After Order is Received Demand Number Ending Sold Inv. Day 18 16 Ordering Purchase Holding Shortage Cot Cost Cost Cost Shortage Revenue Profit (b) (2 PTS] Compute the average daily profit and the service level from the table in part (a). Average daily profit: Service level: () (2 Pts] If the initial inventory is less than 17, the order quantity equals Otherwise, the order quantity equals 0. i. initial inventory - 17 ii. 17-initial inventory iii. 17 iv. initial inventory Consider the following Excel spreadsheet. ABC 2 Initial Order nu. Ale Dully Number Inding Number Gebeng Puchong Shortage Dolly Day InventoryQuantity Onders Received Demand Sold Im Not Met een Cost Cod Cow Prote 1 15 2 3 4 5 6 IMNI 10 71 1 9 10 14 15 16 Summary Me TE 19 Mean Daily Profit Standard Deviation Minimum Daily Pro Musim Bally Profit Service level 21 i. (2 PTS) Using part (c), write down the Excel formula you would use for cell 14 ii. [1 pr] Write down the expression you would use for cell F4. iii. (2 PTS] If the demand is less than the initial inventory after the order is received, then the number of units sold is equal to Otherwise, the number of units sold is equal to iv. [1 Pr] Using the previous part, write down Excel formula you would use for cell H4. v. (2 PTS) If the demand is less than the initial inventory after the order is received, then the ending inventory is equal to Other- wise, the ending inventory is equal to vi. [1 PT] Using the previous part, write down Excel formula you would use for cell 14 vii. (2 PTS] If the demand is less than the initial inventory after the order is received, then the shortage is equal to Otherwise, the shortage is equal to viii. (1 PT] Using the previous part, write down Excel formula you would use for cell J4. ix. [1 PT] Write down the Excel formula you would use for cell K4. x. [1 PT] Write down the Excel formula you would use for cell L4. xi. [1 PT] Write down the Excel formula you would use for cell M4. xii. (1 PT] Write down the Excel formula you would use for cell N4. xiii. (1 pt) Write down the Excel formula you would use for cell 04. xiv. (1 pt] Write down the Excel formula you would use for cell P5. xv. (1 PT] Write down the Excel formula you would use for cell D5. xvi. (2 PTS) Write down the Excel formula you would use for cell G21