Question: Please answer it with Excel. If you can't answer it please don't say No idea. Let anybody else to solve it okay? Problem 3. A
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 2,000 Department B 5 5 2,000 Department C 2,000 8 3 2 2 3 9 100 50 Sales Cost ($000) 60 200 Max Demand Potential (000) 400 300 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
