Excel Solver Solution.

0.13 Innis Construction Company specializes in building moderately priced homes in Cincinnati, Ohio. Tom Innis has identified eight potential locations to construct new single-family dwellings, but he cannot put up homes on all of the sites because he has only $300,000 to invest in all projects. The accompanying table shows the cost of constructing homes in each area and the expected profit to be made from the sale of each home. Note that the home-building costs differ considerably due to lot costs, site preparation, and differences in the models to be built. Note also that a fraction of a home cannot be built. Formulate and find the optimal solution for Innis's problem. COST OF BUILDING AT THIS SITE ($) 60,000 50,000 EXPECTED PROFIT K$) 5.000 6.000 LOCATION Clifton Mt. Auburn Mt. Adams Amberly Norwood Covington Rosclawn 103,000 50,000 41,000 80,000 69,000 10.000 12.000 8,000 3,000 9,000 10.000 Eden Park