Question: Bob and Sam make birdhouses. Each week they have 80 hours of labor and 36 feet of wood available. It requires 8 hours of labor and 2 feet of wood to make a small birdhouse, and 10 hours of labor and 6 feet of wood to make a large birdhouse. The demand for birdhouses is no more than six per week. A small birdhouse earns $400 in profit, and a large birdhouse earns $100. The Bob & Same want to know how many of each item to make each week to maximize profit.

a. Formulate an integer programming model for this problem (written in a format similar to the way Problems A & B were presented).

b. Solve this problem by using the Excel/Solver and show your work consistently.