Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Practices A Complete Guide

Authors: Gerardus Blokdyk

2023rd Edition

1038804450, 978-1038804457

More Books

Students also viewed these Accounting questions