Question: Question 3 7 ( 3 points ) You are the production manager for a gear manufacturer. The following report presents the result of a linear
Question points
You are the production manager for a gear manufacturer. The following report presents the result of a linear program to determine the optimal product mix between four possible products Gears A B C and D which would use the following resources: drilling hours, milling hours, lathe hours, and inspection hours. The coefficients of the objective function represent the profit to be made from the manufacture of each type of gear.
Variable Cells
Cell
Name
Final Value
Reduced Cost
Objective Coefficient
Allowable Increase
Allowable Decrease
$C$
Number to Make Gear A
$D$
Number to Make Gear B
E
$E$
Number to Make Gear C
$F$
Number to Make Gear D
E
Constraints
Cell
Name
Final Value
Shadow Price
Constraint
RH Side
Allowable
Increase
Allowable
Decrease
G$
Drilling Hours
$G$
Milling Hours
E
$G$
Lathe Hours
$G$
Inspection Hours
E
What is the Objective Function?
Question options:
Maximize Profit times Number of Gear Atimes Number of Gear Btimes Number of Gear Ctimes Number of Gear D
Maximize Profit times Number of Gear Atimes Number of Gear C
Maximize Profit times Number of Gear Atimes Number of Gear Btimes Number of Gear Ctimes Number of Gear D
Maximize Profit times Number of Gear Btimes Number of Gear D
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
