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
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.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fad0ac84e-0550-43a0-af29-56c9639f04a2%2Fcbdb0c0b-a2c1-453b-9d10-e30c4c24ac11%2Ffa6ruu_processed.jpeg&w=3840&q=75)
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
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 7 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.