Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Spreadsheet Environmental considerations, material losses, and waste disposal can be included in the EQQ model to improve inventory-management decisions. Assume that the annual demand for
Spreadsheet Environmental considerations, material losses, and waste disposal can be included in the EQQ model to improve inventory-management decisions. Assume that the annual demand for an industrial chemical is 2,200 lb, item cost is $2/lb, order cost is $33, inventory holding cost rate (percent of item cost) is 18 percent. Use the EOQ Model Excel template in MindTap 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: Total cost: $ Choose the correct graph illustrating the inventory costs. The correct graph is -Select- v b. Now assume that eight percent of the chemical is not used and disposed of, with a disposal cost of $0.50/lb. 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: lb Total cost: $ C. What implications do these results have for sustainability practices? Although the total cost in part b is -Select- w|, by adjusting the economic order quantity, the company -Select- w|actually save additional costs while protecting the environment
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started