please show the formulas used to get the answers

Buyer's demand Accepteble #of defective items 1500 30 Price Defective Percentage Capacity Supplier 1 Supplier 2 Supplier 3 Supplier 4 $ 10.00 $ 11.00 $ 12.00 $ 13.00 0.02 0.015 0.01 0.005 1000 1000 1000 1000 In this problem, we assume that a buyer is going to buy a single item from four suppliers to meet its demand that is 1500 units. The suppliers offer different wholesale prices that are $10, $11, $12 and $13, respectively. They also produce defective item and the percentage is 2% for the first supplier, 1.5% for the second supplier, 1% for the third supplier, and 0.5% for the forth supplier. Production capacity for all the suppliers is 1000 units. Assume that the buyer wants to minimize its purchasing cost. Use Solver to solve the problem for this case: acceptable number of defective items is less than 30 units. Order quantity from the supploers In this problem, you want to: 1. minimize the purchasing cost 2. meet the demand 3. incorporate the suppliers' production capacity into your calculation 4. keep number of defective items less than 30 units