Question 1 A company produces 3 products. Each unit of product 1, 2, and 3 generate a profit of GH₵10, GH₵12, and GH₵12 respectively. Each product has to go through a manufacturing, assembly, and testing phase. The company’s resources are such that only 20 hours of manufacturing, 20 hours of assembly, and 20 hours of testing are available. Each unit of product 1 has to spend 1 hour in manufacturing, 2 hours in assembly, and 2 hours in testing. Each unit of product 2 has to spend 2 hours in manufacturing, 1 hour in assembly, and 2 hours in testing. Each unit of product 3 has to spend 2 hours in manufacturing, 2 hours in assembly, and 1 hour in testing. The Company wants to know how many units of each product it should produce, in order to maximize its profit.    a) Formulate a linear programming model for this problem.   The model was solved using solver and part of the results is provided in the table below. Use it to answer the questions that follow.    b) Management have asked you to determine the optimal solution. Write your answer in a form of a report to be submitted to the management.    c) Advice the management about objective function value corresponding to your answer in (b).

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Question

Question 1
A company produces 3 products. Each unit of product 1, 2, and 3 generate a
profit of GH₵10, GH₵12, and GH₵12 respectively.
Each product has to go through a manufacturing, assembly, and testing phase.
The company’s resources are such that only 20 hours of manufacturing, 20
hours of assembly, and 20 hours of testing are available. Each unit of product
1 has to spend 1 hour in manufacturing, 2 hours in assembly, and 2 hours in
testing. Each unit of product 2 has to spend 2 hours in manufacturing, 1 hour
in assembly, and 2 hours in testing. Each unit of product 3 has to spend 2
hours in manufacturing, 2 hours in assembly, and 1 hour in testing. The
Company wants to know how many units of each product it should produce,
in order to maximize its profit. 

 

a) Formulate a linear programming model for this problem.

 

The model was solved using solver and part of the results is provided in the
table below. Use it to answer the questions that follow. 

 

b) Management have asked you to determine the optimal solution. Write
your answer in a form of a report to be submitted to the management. 

 

c) Advice the management about objective function value corresponding to
your answer in (b).

 

Variable Cells
Redu Objecti Allowab Allowab
le
Final
се
ve
le
Valu
Coeffici
Decreas
Cell
Name
Cost
ent
Increase
e
$B$
10
X1 =
4
10
6
4
$B$
2.66666
11
X2 =
4
12
6667
4
$B$
2.66666
12
X3 =
4
12
6667
4
Constraints
Shad Constra Allowab Allowab
Final
int
le
le
ow
Valu
R.H.
Decreas
Name
$F$ Manufacturi
ng Usage
$E$ Assembly
Usage
$F$ Testing
Cell
e
Price
Side
Increase
6.66666
5
20
3.6
20
6667
10
6.66666
6.
20
1.6
20
6667
10
6.66666
7
Usage
20
1.6
20
6667
10
Transcribed Image Text:Variable Cells Redu Objecti Allowab Allowab le Final се ve le Valu Coeffici Decreas Cell Name Cost ent Increase e $B$ 10 X1 = 4 10 6 4 $B$ 2.66666 11 X2 = 4 12 6667 4 $B$ 2.66666 12 X3 = 4 12 6667 4 Constraints Shad Constra Allowab Allowab Final int le le ow Valu R.H. Decreas Name $F$ Manufacturi ng Usage $E$ Assembly Usage $F$ Testing Cell e Price Side Increase 6.66666 5 20 3.6 20 6667 10 6.66666 6. 20 1.6 20 6667 10 6.66666 7 Usage 20 1.6 20 6667 10
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,