Please Use EXCEL SOLVER to answer this question. Show me some screenshots and formulas of how you used excel solver! Thank you so much!

Problem 3: Procurement Optimization You own a large dry goods store chain, and you have several standard stock shelf items you like to keep in stock. You put a bid out to 6 different vendors who all offer the products you need. They each submit bids for the items they are interested in supplying. Your demand for each item is Work Gloves 10,000 -- Variety Pack Welding Rod 8,000 --- Fire Extinguisher 6,000 --- Shop Heater 7,000 --- ScrewDriver Set 9,000. Also, because of some bank policy changes, no Supplier is willing to sell you more than $300,000 in this bid cycle. What's your minimum total supply cost