What quantity should be ordered, and which supplier should be used?

I choose vendor 1 range 1 because the TC was the lowest is this correct? My work is below.

Question 1. Emery Pharmaceutical uses an unstable chemical compound that must be kept in an environment where both temperature and humidity can be controlled. Emery uses 800 pounds per month of the chemical, estimates the holding cost to be 50% of the purchase price (because of spoilage), and estimates order costs to be $50 per order. The cost schedules of two suppliers are as follows. What quantity should be ordered, and which supplier should be used? (10 points) Vendor 1 Vendor 2 Quantity Price/lb Quantity Price/lb 1-499 $17.00 1-399 $17.10 500-999 $16.75 400-799 $16.85 1000+ $16.50 800-1199 $16.60 1200+ $16.25 HINT: Create 2 worksheets; one for each vendor. Highlight the best order quantity and cost for each vendor. Compare the results of the two worksheets and type your conclusion (chosen supplier) in one of the worksheets. In case you see the ##### error in the cells, it is because the value in that cell does not match with the width of the cell; you need to resize the cell to be able to see the value in it. 1 Vendor 1 2. 3 Inventory/Quantity Discount Model 4 Enter the data in the shaded area. The minimum quantity is the minimum amount that needs to be ordered in 5 order to get the price that is in the same column. 6 7 Data Total Cost vs Order Quantity 800 50 50.00% (percentage) 20000 18000 Range 1 Range 2 16000 Range 3 500 16.75 1000 16.5 17 14000 12000 8 Demand rate, D 9 Order cost, S 10 Holding cost %, 11 12 13 Minimum quantity 14 Unit Price, P 15 16 Results 17 18 Q* (Square root formula) 19 Order Quantity 20 21 Holding cost 22 Order cost 23 24 Unit costs 25 26 Total cost, TC 10000 Range 1 Range 2 Range 3 97.01425001 97.73555549 98.47319278 97.01425001 1000 8000 500 6000 4000 $412.31 $412.31 $2,093.75 $80.00 $4,125.00 $40.00 2000 0 $13,600.00 $13,400.00 $13,200.00 16667 20833 250.00 29167 333.33 375.00 41667 45833 500.00 54167 58333 70833 750.00 79167 83333 875.00 91667 95833 1000.00 1041.67 1083.33 1125.00 625.00 66667 Quantity $14,424.62 $15,573.75 $17,365.00 27 28 Base inc on 29 Cost table 30 31 Q 1 2 3 32 33 34 4 5 6 7 8 9 35 36 37 38 39 40 41 42 43 44 10 11 12 13 14 15 16 17 500 Unit cost 166.6666667 208.3333333 250 291.6666667 333.3333333 375 416.6666667 458.3333333 500 541.6666667 583.3333333 625 666.6666667 708.3333333 750 791.6666667 833.3333333 875 916.6666667 958.3333333 1000 1041.666667 1083.333333 Setup cost Holding cost Total unit costs Total Costs 17 240 708.3333333 13600 14548.333 17 192 885.4166667 13600 14677.417 17 160 1062.5 13600 14822.5 17 137.1428571 1239.583333 13600 14976.726 17 120 1416.666667 13600 15136.667 17 106.6666667 1593.75 13600 15300.417 17 96 1770.833333 13600 15466.833 17 87.27272727 1947.916667 13600 15635.189 16.75 80 2093.75 13400 15573.75 16.75 73.84615385 2268.229167 13400 15742.075 16.75 68.57142857 2442.708333 13400 15911.28 16.75 64 2617.1875 13400 16081.188 16.75 60 2791.666667 13400 16251.667 16.75 56.47058824 2966.145833 13400 16422.616 16.75 53.33333333 3140.625 13400 16593.958 16.75 50.52631579 3315.104167 13400 16765.63 16.75 48 3489.583333 13400 16937.583 16.75 45.71428571 3664.0625 13400 17109.777 16.75 43.63636364 3838.541667 13400 17282.178 16.75 41.73913043 4013.020833 13400 17454.76 16.5 40 4125 13200 17365 16.5 38.4 4296.875 13200 17535.275 16.5 36.92307692 4468.75 13200 17705.673 45 46 47 18 19 20 48 49 50 51 52 21 22 23 9 CUT Total Cost vs Order Quantity 50 - Sneh SIP 20090 LECOS Rp1 R? Ron Ranut 4081 1200 1711685 1681623 DO 231 OF COR 14000 10 COST 2 Du n Cerrar Beranda 9 Ordercoss 10 Halling 11 12 13 MILInely 14 Unt Prire 15 16 Results 17 13 Di Squee root famul 19 Order Quantity 30 How 2 Holst 32 Order 23 34 Unte 25 20 TOT 22 29 Ryeinc on 19 Coats 30 31 Rp1 Rp? ? Rip RM 4 26 2018 97.44510743 96.170111 29.22276767 96.72016668 009 1200 MOOC COB COOC SI Sena 2000 5 200C 561352 $1,68500 100.DO $ $13,000 $13.400D , $ $14,507.04 $15,205.00 DI D 200 DO 200.00 0000 330000 0000 * 420.30 DODGE CCS DE 90 91 TC DC 00002 LORO 000OC 32000 LOCEDU LEEDS LIED FOR ILDO CO : $13,JAD.DO $11,000 $ $16, BSD.DO $17,900.33 TIEDE query L2000D 323000 23000 00: a Untecat ESB 200 250 20 SEPER 17.) 205 13.3 17.d 123.3333333 13.3 19.1 114 215T: 1 2 3 1 5 TE CE GOF 00 34 15 SITE DELTARARIS 150 400 150 500 550 500 7 08 17 2685 IGAS 2685 73.72727271 65.66666662 CATST be 098 189 | . SUVES ! 40 ID 11 12 200 Hold rest Tebal na Tctal Dests coat 95 1680 14785 1DGETS LIGEC 1400ES 1282.3 1:660 15095) 149625 11GE 1539054 1685 1:460 15263 109.621 11400 1516451 210623 1:450 1516633 3216ATI 11460 15A ICARA 1:450 1602412 3729.12 11481 16279 248.73 1:400 16485 9159373 12481 16642 TL lbab 35273 1:280 366545 13200 170.44 3942.3 1:260 172646 4150 13210 17470 4357.5 12475.6 1565 1126C 17141 14 4772.5 1:250 18.67.22 LAT: 110 1700 21 5074.125 12000 1811013 17 054 FT SUD 2685 57.14285714 1685 5111 15.5 16.5 472353 13. 4444444444 16.6 42.10526315 42 43 44 DAZET 57 14 1! 16 11 45 16 10 20 21 22 300 950 1000 1050 1300 991 ! 47 31 DATET 28.095238 3.16163455 24.7526062 49 16.6 15.5 16.6 1625 2625 1625 OSET DS . 51 12 1300 1250 1100 32 20. 16922073 CIEC! CU CIEL DUULI