SOLVER 5Problems: Binary Integer ModelsProduction planning department of Graysta

SOLVER 5Problems: Binary Integer ModelsProduction planning department of Graystar Prefabricated Homes Company has to decide which types of homes to produce for the next period. They have four prefabricated homes (ABC and D). Each home uses three different materials lumber particleboard and drywall. The table given below shows the expected profits for each house the amount of materials used in house and the available quantities of these materials.ABCDAvailableProfit20000170002100024000Lumber107111025Particle Board547620Drywall21.532.56Formulate the problem to determine which house(s) should be produced to maximize the profit.