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

Please answer it with Excel. If you can't answer it please don't say No idea. Let anybody else to solve it okay? Please answer it with Excel. If you can't answer it please don't

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!