only need part B

Spreadsheet Environmental considerations, material losses, and waste disposal can be included in the EOQ model to improve Inventory-management decisions. Assume that the annual demand for an industrial chemical is 2,500 lb, Item cost is $2/1b, order cost is $34, Inventory holding cost rate (percent of item cost) is 19 percent. Use the EOQ Model Excel template in Mind Tap to answer the following: a. Find the EOQ and total cost, assuming no waste disposal. Do not round intermediate calculations. Round your answer for the EOQ to the nearest whole number and for the total cost to the nearest cent. Economic Order Quantity: 668.86 ib Total costs 254.17 Choose the correct graph illustrating the inventory costs. The correct graph is graph De B17 fx 1 B C D A E F G 1 H 1 Economic Order Quantity Model 2 Enter the data only in the yellow cells. Cengage Learning Not for commercial use. 3 4 Inventory Costs 5 Annual Demand Rate Ordering Cost Unit Cost Carrying Charge Rate 24000.00 $38.00 $11.40 0.18 6 7 $3,000.00 8 $2,500.00 10 11 $2,000.00 $1,500.00 Order cost -Holding cost Total cost 51,000.00 9 Economic Order Quantity 942.81 Order cost $967.32 Inventory cost $967.32 12 Total cost $1,934.64 13 14 Sensitivity Analysis 15 Enter any order quantity to evaluate the cost 16 and compare with EOQ 17 Order Quantity Order cost $912,000.00 Inventory cost $1.03 20 Total cost $912,001.03 21 22 EOQ Benefit $910,066.38 $500.00 18 19 $0.00 1131 1225 1320 1414 Order quantity 23 24 25 26 27 28 29 Chart Calculations 30 31 Order Quantity 471 566 660 32 33 Order cost Inventory cost Total cost $1,934.64 $483.66 $2.418.31 $1,612.20 $580.39 $2,192.60 $1,381.89 $677.13 $2,059.01 $1,209.15 $773.86 $1,983.01 $1,074.80 $870.59 $1,945.39 $967.32 $967.32 $1,934.64 CA79 2 C1 Al 10 al 34 754 35 849 36 27 943 1927 + EOQ Model Chart Calculations Order Quantity 471 566 3 660 754 4 849 5 Order cost Inventory cost Total cost $1,934.64 $483.66 $2,418.31 $1,612.20 $580.39 $2,192.60 $1,381.89 $677.13 $2,059.01 $1,209.15 $773.86 $1,983.01 $1,074.80 $870.59 $1,945.39 $967.32 $967.32 $1,934.64 $879.38 $1,064.05 $1,943.44 $806.10 $1,160.79 $1,966.89 $744.09 $1,257.52 $2,001.61 $690.94 $1,354.25 $2,045.20 $644.88 $1,450.98 $2,095.86 -6 943 37 1037 38 1131 39 1226 40 1320 41 1414 42 43 b. Now assume that six percent of the chemical is not used and disposed of, with a disposal cost of $0.50/b. Find the EOQ and total cost when disposal costs are incorporated into the model. (Hint: add to the holding cost the disposal cost times the percent of product that is disposed of.) Round your answer for the EOQ to the nearest whole number and round your answer for the total cost to the nearest cent. Use the rounded EOQ value in your calculations. Do not round any other intermediate calculations Economic Order Quantity: 583.10 ib Total cost: $