explan it how i get each Range in excle and the unit price

tires hold The ord 12.21 Cesar Rego Computers, a Mississippi chain of com- puter hardware and software retail outlets, supplies both edu- cational and commercial customers with menory and storage devices. It currently faces the following ordering decision relating to purchases of very high-density disks: D = 36,000 disks S = $25 I = 20% Purchase price = $0.85 Discount price = $0.82 Quantity needed to qualify for the discount = 6,000 disks Should the discount be taken? PX tire: ord 36000 7 Data 8 Demand rate, D 9 Setup cost, S 10 Holding cost %, Total Cost vs Order Quantity 11 180000 1780001 1780001 176000 121 Range 1 Range 2 Range 3 13 Minimum quantity 700 1000 2000 14 Unit PriceP 54.8 15 116 Results 17 Range 1 Range 2 R ange 3 18 Q' (Square root formu 1341.6407861369.306394 1376.494403 19 Order Quantity 1341.640786 1369.306394 2000 20 21 Holding cost $670.82 $65727 $950.00 22 Setup cost $670.82 $657.27 $450.00 23 24 Unit costs $180,000.00 $172,800.00 $171,000.00 1344076 700.05430 223.06777 2003281573 $181.341.64 $174,114.53 $172,400.00 26 Total cost, 27 28 Base incon 1341.640786 Intcort Sotun mit Holding my Total unit costs Total Costs tires hold The ord 12.21 Cesar Rego Computers, a Mississippi chain of com- puter hardware and software retail outlets, supplies both edu- cational and commercial customers with menory and storage devices. It currently faces the following ordering decision relating to purchases of very high-density disks: D = 36,000 disks S = $25 I = 20% Purchase price = $0.85 Discount price = $0.82 Quantity needed to qualify for the discount = 6,000 disks Should the discount be taken? PX tire: ord 36000 7 Data 8 Demand rate, D 9 Setup cost, S 10 Holding cost %, Total Cost vs Order Quantity 11 180000 1780001 1780001 176000 121 Range 1 Range 2 Range 3 13 Minimum quantity 700 1000 2000 14 Unit PriceP 54.8 15 116 Results 17 Range 1 Range 2 R ange 3 18 Q' (Square root formu 1341.6407861369.306394 1376.494403 19 Order Quantity 1341.640786 1369.306394 2000 20 21 Holding cost $670.82 $65727 $950.00 22 Setup cost $670.82 $657.27 $450.00 23 24 Unit costs $180,000.00 $172,800.00 $171,000.00 1344076 700.05430 223.06777 2003281573 $181.341.64 $174,114.53 $172,400.00 26 Total cost, 27 28 Base incon 1341.640786 Intcort Sotun mit Holding my Total unit costs Total Costs