Optimization3
xlsx
keyboard_arrow_up
School
Thompson Rivers University *
*We aren’t endorsed by this school
Course
6250
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
xlsx
Pages
1
Uploaded by AdmiralComputer13551
278df2ae772784a5be31d9a9268bc2352b0ed13a.xlsx
Profit
Product
Profit
Technician A
Technician B
Technician C
Technician D
# units to make
#1
$6
2.0 2.5 0
0
80
What would be the revised maximum profit if you could sell 51 units of Product 3 =
#2
$7
0
3.0 0
3.5 50
What would be the revised maximum profit if every technician would now work 121 hours every month =
#3
$10
3.0 0
4.0 0
50
at would be the revised maximum profit if Technician D was cross trained and took 2.5 hours to do Product #3 =
# of Hours available =
120
120
120
120
Product
Total Profit
Technician A
Technician B
Technician C
Technician D
Demand
Units to Make
Product 1
$480
80.0
80.0
0.0
0.0
80
80
Product 2
$350
0.0
50.0
0.0
34.3
50
50
Product 3
$500
50.0
0.0
30.0
0.0
50
50
$1,330
130.0
130.0
30.0
34.3
Problems From Chapter #29
Using Solver to Determine the Optimal Product Mix Problem #1: At a chip manufacturing plant, four technicians (A, B, C, and D) produce three products (Products 1, 2, and 3). This month, the chip manufacturer can sell 80 units of Product 1, 50 units of Product 2, and at most 50 units of Product 3. Technician A can make only Products 1 and 3. Technician B can make only Products 1 and 2. Technician C can make only Product 3. Technician D can make only Product 2. For each unit produced, the products contribute the following profit: Product 1, $6; Product 2, $7; and Product 3, $10. The time (in hours) each technician needs to manufacture a product is as follows:
Each technician can work up to 120 hours per month. How can the chip manufacturer maximize its monthly profit? Assume a fractional number of units can be produced.
% Change from original profit
Set up and solve this model and find the maximum profit that can be made subject to the constraints.
Once you have a solution put your answer in general terms in the space below. In additional answer the three marginal insight questions. - insights are always based off the original model so make sure you return to the original setting each time
- You might want to copy the model down below and use this to get your insights that way your original model is always correct.
- you will also have to copy and paste as values for each insight so you remove the formulas ANSWER:
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help