Solve the problem using excel and solver.

A company produces three different types of wrenches: W111, W222, and W333. It has a firm order for 2,000 W111 wrenches, 3,750 W222 wrenches, and 1,700 W333 wrenches. Between now and the order delivery date, the company has only 16,500 fabrication hours and 1,600 inspection hours. The time that each wrench requires in each department is shown in the table at the bottom of this page. Also shown are the costs to manufacture the wrenches in-house and the costs to outsource them. For labeling considerations, the company wants to manufacture in-house at least 60% of each type of wrench that will be shipped. How many wrenches of each type should be made in-house and how many should be outsourced? What will be the total cost to satisfy the order? Table for Problem 3-7 Wrench Fabrication In-House Outsource Inspection Hours Hours Cost Cost W111 2.50 0.25 $17.00 $20.40 W222 3.40 0.30 $19.00 $21.85 W333 3.80 0.45 $23.00 $25.76