Please include Excel answers and spreadsheet formulas, thank you!

2) The Judson Corporation has acquired 100 lots on which it is about to build homes. Two styles of homes are to be built, the "Cape Cod" and the "Ranch Home". Judson wishes to build these 100 homes over the next nine months. During this time, Judson will have available 13,000 man-hours of bricklayer labor and 12,000 hours of carpenter labor. Each Cape Cod requires 200 man-hours of carpentry labor and 50 man-hours of bricklayer labor. Each Ranch Home requires 120 hours of bricklayer labor and 100 man-hours of carpentry. The profit contribution of Cape Cod is projected to be $5100, whereas that of a Ranch Home is projected at $5000. a) Formulate the problem to maximize profit. For parts b) and c) below, can you determine the answer without resolving the problems with Solver? b) A gentleman who owns 15 vacant lots adjacent to Judson's 100 lots needs some money quickly and offers to sell his 15 lots (as a package deal) for $60,000. Should Judson buy? What assumptions are you making? c) One of Judson's salesmen who is a native of Massachusetts feels certain he could sell the Cape Cods for $2000 more each than Judson is currently projecting. Should Judson change its planned mix of homes? What assumptions are inherent in your recommendation