Use the Simplex Method to solve the following problem. Show all work. 2. A contractor builds three types of houses; the Aries, the Belfair and the Wexford. Each house requires one lot and the following table gives the number of labor-hours and the amount of capital needed for each type of house, as well as the profit on the sale of each house. There are 12 lots, 47,500 labor-hours and $3,413,000 available for the contractor's use. Belfair 3,700 $279,600 $25,000 Wexford 5,000 Aries 3,000 $205,000 $20,000 Labor-hours Capital Profit $350,000 $30,000 a. Building how many of each type of house will maximize her profit b. What is the maximum possible profit?

Suppose you make beautiful coffee tables out of juniper trees. Your materials cost for each table is $135. You pay your craftsman $25 per hour and it takes him 5 hours to complete one table. If you sell these tables for $689, What is the Gross Profit Margin on the coffee tables

.

Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40   a)  Generate the Answer Report using SOLVER in EXCEL.  Then, clearly answer what is the optimal solution?  What is the resulting profit? b) Generate the Sensitivity Report for the model that you built. Interpret, in context, the Shadow Price for the Leather and the Satin constraints.  Include units in your interpretations.