Solve the following Network Problems. Do graphical method, excel, and pom-qm. The Research and Development Division of the Emax Corporation has developed three new products. A decision now needs to be made on which mix of these products should be produced. Management wants primary consideration given to three factors: maximizing total profit, stability in the workforce, and achieving a decrease in the company’s expenses next year from the $60 million incurred this year. The impact of each of the new products (per unit rate of production) on each of these factors is shown in the following table: FACTOR UNIT CONTRIBUTION UNIT CONTRIBUTION UNIT CONTRIBUTION GOAL UNITS PENALTY   PRODUCT PRODUCT PRODUCT         1 2 3       TOTAL PROFIT 14 9 16 ≥135 MILLIONS OF DOLLARS 4 EMPLOYMENT LEVEL 6 2 4 =45 HUNDREDS OF EMPLOYEES 3(+), 5(-) EXPENSES NEXT YEAR 6 6 8 ≤60 MILLIONS OF DOLLARS 2 Formulate a linear programming model for this problem. Use excel solver method to solve this model.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter9: Decision Making Under Uncertainty
Section9.2: Elements Of Decision Analysis
Problem 2P
icon
Related questions
Question

Solve the following Network Problems. Do graphical method, excel, and pom-qm.

  1. The Research and Development Division of the Emax Corporation has developed three new products. A decision now needs to be made on which mix of these products should be produced. Management wants primary consideration given to three factors: maximizing total profit, stability in the workforce, and achieving a decrease in the company’s expenses next year from the $60 million incurred this year.

The impact of each of the new products (per unit rate of production) on each of these factors is shown in the following table:

FACTOR UNIT CONTRIBUTION UNIT CONTRIBUTION UNIT CONTRIBUTION GOAL UNITS PENALTY
  PRODUCT PRODUCT PRODUCT      
  1 2 3      
TOTAL PROFIT 14 9 16 ≥135 MILLIONS OF DOLLARS 4
EMPLOYMENT LEVEL 6 2 4 =45 HUNDREDS OF EMPLOYEES

3(+), 5(-)

EXPENSES NEXT YEAR 6 6 8 ≤60 MILLIONS OF DOLLARS 2
  1. Formulate a linear programming model for this problem.
  2. Use excel solver method to solve this model.

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Maintenance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,