CWD Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder The shaper is available for 120 hours, and the grinder is available for 110 hours. No more than 200 units of component 3 can be sold, but up to 1000 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component I that must be satisfied. The profit contributions for c omponents 1, 2, and 3 are $8, $6, and S9, respectively. Let C- units of component I manufactured C;- units of component 2 manufactured C,- units of component 3 manufactured sc, + 6C; + 6C, + 4C, + 4C + SC: + Max 9C, 4C, s 7200 20, s 6600 C s 200 s 1000 S 1000 2 600 C. C, C 20 s.t. Answer the following questions (a-i) using the output below pleae be brief. If there are two possible answers one will suffice. Where necessary a range analysis must be shown.(hint convert to minutes) | An additional 4 hours of shaper time became available. Evaluate the effect? Explain- Two hours of Grinder time was lost. Evaluate the effect? 2 An additional 20 units of component 3 was requested. Evaluate the effect

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section: Chapter Questions
Problem 111P
icon
Related questions
Question

please see images 

$B$2 number of units c1
$C$2 number of units c2
$D$2 number of units c3
Constraints
600 Contin
700 Contin
200 Contin
Slack
Name
SE$10 C1 minimum
SE$S Shaper
Cell
Cell Value
Formula
Status
600 ŞE$10>=$G$10 Binding
7200 ŞE$5<=$G$5
Binding
Not
SE$6 Grinder
SE$7 C3 maximum
6300 SE$6<=$G$6
Binding
Binding
300
200 ŞE$7<=$G$7
Not
SE$8 C1 maximum
600 ŞE$8<=$G$8
Binding
400
Not
SE$9 C2 maximum
700 ŞE$9<=$G$9
Binding
300
Microsoft Excel 14.0 Sensitivity Report
Norksheet: [Assignment 1 S1 2015-16 solutionB.xlsx]Q2 LP formulation MAX
Jariable Cells
Final Reduced Objective Allowable
Allowable
Coefficient Increase
Cell
$B$2 number of units c1
$C$2 number of units c2
$D$2 number of units c3
Name
Value
Cost
Decrease
600
8
1
1E+30
700
6.
3 0.666666667
200
1E+30
3
Constraints
Final
Shadow
Constraint Allowable
Allowable
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
SE$10 C1 minimum
SE$S Shaper
600
-1
600
400 85.71428571
7200
1.5
7200
240
2800
SE$6 Grinder
6300
6600
1E+30
300
SE$7 C3 maximum
200
3
200
700
100
C1 maximum
SE$8
SE$9 C2 maximum
600
1000
1E+30
400
700
1000
1E+30
300
Transcribed Image Text:$B$2 number of units c1 $C$2 number of units c2 $D$2 number of units c3 Constraints 600 Contin 700 Contin 200 Contin Slack Name SE$10 C1 minimum SE$S Shaper Cell Cell Value Formula Status 600 ŞE$10>=$G$10 Binding 7200 ŞE$5<=$G$5 Binding Not SE$6 Grinder SE$7 C3 maximum 6300 SE$6<=$G$6 Binding Binding 300 200 ŞE$7<=$G$7 Not SE$8 C1 maximum 600 ŞE$8<=$G$8 Binding 400 Not SE$9 C2 maximum 700 ŞE$9<=$G$9 Binding 300 Microsoft Excel 14.0 Sensitivity Report Norksheet: [Assignment 1 S1 2015-16 solutionB.xlsx]Q2 LP formulation MAX Jariable Cells Final Reduced Objective Allowable Allowable Coefficient Increase Cell $B$2 number of units c1 $C$2 number of units c2 $D$2 number of units c3 Name Value Cost Decrease 600 8 1 1E+30 700 6. 3 0.666666667 200 1E+30 3 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SE$10 C1 minimum SE$S Shaper 600 -1 600 400 85.71428571 7200 1.5 7200 240 2800 SE$6 Grinder 6300 6600 1E+30 300 SE$7 C3 maximum 200 3 200 700 100 C1 maximum SE$8 SE$9 C2 maximum 600 1000 1E+30 400 700 1000 1E+30 300
CWD Manufacturing makes three components for sale to refrigeration companies. The
components are processed on two machines: a shaper and a grinder. The times (in minutes)
required on each machine are as follows:
Machine
Component
Shaper
Grinder
The shaper is available for 120 hours, and the grinder is available for 110 hours. No more than
200 units of component 3 can be sold, but up to 1000 units of each of the other components can
be sold. In fact, the company already has orders for 600 units of component I that must be
satisfied. The profit contributions for components 1, 2, and 3 are s8, $6, and $9, respectively.
Let C = units of component 1 manufactured
C;= units of component 2 manufactured
C;= units of component 3 manufactured
8C, +
6C, +
4C; +
6C: +
4C; +
5C: +
Max
9C,
4C, s 7200
20, s 6600
C, s 200
s 1000
S 1000
2 600
C. C, C, 20
s.t.
C:
Answer the following questions (a-i) using the output below please be brief. If there are two possible
answers one will suffice. Where necessary a range analysis must be shown.(hint convert to minutes)
| An additional 4 hours of shaper time became available. Evaluate the effect? Explain-
Two hours of Grinder time was lost. Evaluate the effect?
- An additional 20 units of component 3 was requested. Evaluate the effect
Microsoft Excel 14.0 Answer Report
Report Created: 10/16/2015 2:52:09 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Objective Cell (Max)
Cell
Name
Original Value
Final Value
SES3
Profit
10800
Variable Cells
Cell
Name
Original Value
Final Value
Integer
Transcribed Image Text:CWD Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder The shaper is available for 120 hours, and the grinder is available for 110 hours. No more than 200 units of component 3 can be sold, but up to 1000 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component I that must be satisfied. The profit contributions for components 1, 2, and 3 are s8, $6, and $9, respectively. Let C = units of component 1 manufactured C;= units of component 2 manufactured C;= units of component 3 manufactured 8C, + 6C, + 4C; + 6C: + 4C; + 5C: + Max 9C, 4C, s 7200 20, s 6600 C, s 200 s 1000 S 1000 2 600 C. C, C, 20 s.t. C: Answer the following questions (a-i) using the output below please be brief. If there are two possible answers one will suffice. Where necessary a range analysis must be shown.(hint convert to minutes) | An additional 4 hours of shaper time became available. Evaluate the effect? Explain- Two hours of Grinder time was lost. Evaluate the effect? - An additional 20 units of component 3 was requested. Evaluate the effect Microsoft Excel 14.0 Answer Report Report Created: 10/16/2015 2:52:09 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Objective Cell (Max) Cell Name Original Value Final Value SES3 Profit 10800 Variable Cells Cell Name Original Value Final Value Integer
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 7 images

Blurred answer
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,