Problem 3. A manufacturing firm must decide, among three possible product families, which one(s) it should produce and sell and in what quantity. Each product family requires production hours in each of three departments. In addition, each product family requires its own sales force, which must be supported no matter how large or small the sales volume happens to be. The parameters describing the situation are summarized in the following table: Product Family Hours F1 F2 F3 Available Profit per unit $1.20 $1.80 $2.20 Hours Required per Thousand Units Hours Department A 4 8 2,000 Department B 2 5 5 2,000 Department C 2,000 NNW 3 9 100 Sales Cost ($000) 60 200 Max Demand Potential (000) 400 300 50 The manufacturing firm also requires that product family F2 have a production level of at least 250,000 if it is to have a sales force. Formulate this profit maximization problem as an integer linear program and then solve it using SOLVER Problem 3. A manufacturing firm must decide, among three possible product families, which one(s) it should produce and sell and in what quantity. Each product family requires production hours in each of three departments. In addition, each product family requires its own sales force, which must be supported no matter how large or small the sales volume happens to be. The parameters describing the situation are summarized in the following table: Product Family Hours F1 F2 F3 Available Profit per unit $1.20 $1.80 $2.20 Hours Required per Thousand Units Hours Department A 4 8 2,000 Department B 2 5 5 2,000 Department C 2,000 NNW 3 9 100 Sales Cost ($000) 60 200 Max Demand Potential (000) 400 300 50 The manufacturing firm also requires that product family F2 have a production level of at least 250,000 if it is to have a sales force. Formulate this profit maximization problem as an integer linear program and then solve it using SOLVER