To build a house per month a company needs two bricklayers, four construction assistant and one carpenter. To build an apartment in same time interval, the same company needs three bricklayers, eight construction assistant and three carpenters. The company has a total workforce of 30 bricklayers, 70 construction assistant and 20 carpenters.

The builder makes a profit of $3,000 on the sale of each house and $5,000 in the sale of each apartment and all the construction companys "production" is sold.

What is the optimal number of houses and apartments that the company should build in order to have maximum profit?

a) What is the objective function?

b) What is the set of constraints for this problem?

c) Organize the input information and model the problem into a spreadsheet.

d) Use Solver to find the optimal solution

please provide a step by step on the excel sheet