show the work in excel

B E G H 1 Basic EOQ or Model #1 2. Demand D 3 Holding Cost Ch A Ordering Cost Co 5. Lead Time L 6 Item Cost C (effc) 7% Holding Cost 1 & # of Workdays 9. Daily Demand 10 Discount percent 11 List Price Item C 12 13 36000 items/year 0.45 $/item/yr 25 $/order days 0.82 $/item %/year /year items/day % D Output EOQ Optimal Q Q we must use Average Inventory Annual Holding Cost Annual Ordering Cost Total Inventory Cost ROP # of orders/year Cycle time Annual Item cost Grand Total Cost 2000 items/order 2000 items/order 1000 items 450 $/year 450 S/year 900 S/year 0 items 18 #DIV/0! days 29520 $/year 30420 $/year 12.21 Cesar Rego Computers, a Mississippi chain of com- puter hardware and software retail outlets, supplies both edu- cational and commercial customers with memory and storage devices. It currently faces the following ordering decision relating to purchases of very high-density disks: D = 36,000 disks S = $25 H = $0.45 Purchase price = $.85 Discount price $0.82 Quantity needed to qualify for the discount 6,000 disks Should the discount be taken? Pod B E G H 1 Basic EOQ or Model #1 2. Demand D 3 Holding Cost Ch A Ordering Cost Co 5 Lead Time L 6 Item Cost C (effc) 7% Holding Cost 1 & # of Workdays 9 Daily Demand 10 Discount percent 11 List Price Item C 12 13 36000 items/year 0.45 S/item/yr 25 $/order days 0.82 $/item %/year /year items/day % D Output EOQ Optimal Q Q we must use Average Inventory Annual Holding Cost Annual Ordering Cost Total Inventory Cost ROP # of orders/year Cycle time Annual Item cost Grand Total Cost 2000 items/order 2000 items/order 1000 items 450 $/year 450 S/year 900 S/year 0 items 18 #DIV/0! days 29520 $/year 30420 $/year