Top Posters
Since Sunday
y
2
m
2
m
2
u
2
m
2
B
2
M
2
e
2
k
2
N
2
y
2
m
2
New Topic  
Dukun Dukun
wrote...
Posts: 23
Rep: 0 0
2 years ago

Hi All please solve the following linear programming problems at below with the best explanation of the answer.

1.   The Whitt Window Company is a company with only three employees which makes two different kinds of hand-crafted windows: a wood-framed and an aluminum-framed window. They earn $180 profit for each wood-framed window and $90 profit for each aluminum-framed window. Doug makes the wood frames, and can make 6 per day. Linda makes the aluminum frames, and can make 4 per day. Bob forms and cuts the glass, and can make 48 square feet of glass per day. Each wood-framed window uses 6 square feet of glass and each aluminum-framed window uses 8 square feet of glass. The company wishes to determine how many windows of each type to produce per day to maximize total profit.

(a)   Describe the Wyndor Glass Co. problems. Construct and fill in a table for this problem, identifying both the activities and the resources.
(b)   Formulate a linear programming model for this problem.
(c)   Use the graphical method to solve this model.
(d)   A new competitor in town has started making wood-framed windows as well. This may force the company to lower the price they charge and so lower the profit made for each woodframed window. How would the optimal solution change (if at all) if the profit per wood-framed window decreases from $180 to $120? From $180 to $60? (You may find it helpful to use the Graphical Analysis and Sensitivity Analysis procedure).
(e)   Doug is considering lowering his working hours, which would decrease the number of wood frames he makes per day. How would the optimal solution change if he makes only 5 wood frames per day? (You may find it helpful to use the Graphical Analysis and Sensitivity Analysis procedure).


Read 486 times
13 Replies
Replies
Anonymous
wrote...
2 years ago
Hi Dukun

Does this help?
 Attached file 
You must login or register to gain access to this attachment.
Dukun Author
wrote...
2 years ago
Hello please anyone can help me to solved the questions.
wrote...
Educator
2 years ago
Hello please anyone can help me to solved the questions.

Did the attachment help?

(a) looks good White Checkmark
(b) looks good White Checkmark
(c) White Checkmark
(d) White Checkmark
(e) White Checkmark
Dukun Author
wrote...
2 years ago
Hello please anyone can help me to solved the question to point c) Graphical Method using excel. please.

wrote...
Educator
2 years ago
Does it have to be in Excel?
Dukun Author
wrote...
2 years ago
Yes please can you help, to point c) Graphical Method only using excel the answer.
Answer accepted by topic starter
bio_manbio_man
wrote...
Educator
Top Poster
Posts: 33333
2 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

Dukun Author
wrote...
2 years ago
thanks you very much
Anonymous Author
wrote...
2 years ago Edited: 2 years ago
the answer same with https://biology-forums.com/index.php?action=dlattach;topic=2029437.0;attach=99558

but its a have feedback.  please can anyone help it

Great effort  but when it comes to decide the number of product, please go the closest lower integer number. So instead of X2 =1.5 then make X2 = 1 Regarding to the sensitivity analysis you may use the following answer: Slope Z = -C1/C2 = -C1/90 = -2 Slope constraint 1 = -3/4 Range of optimality -C1/90 = -3/4 ? -C1 = -67.5 ? 67.5 = C1 When C1 reduced to 120, still optimal because C1 > 67.5 When c1 reduced to 60, not optimal any more due to C1 < 67.5
wrote...
Educator
2 years ago
Can you provide a screenshot of the feedback given?
Anonymous Author
wrote...
2 years ago
Sure, please help.



Anonymous
wrote...
2 years ago
Hi, honestly, I am not very sure.

Quote
So instead of X2 =1.5 then make X2 = 1



Quote
When C1 reduced to 60, not optimal any more due to C1 < 67.5


Anonymous Author
wrote...
2 years ago
Hello anyone please help.
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  721 People Browsing
Related Images
  
 190
  
 186
  
 195
Your Opinion
What's your favorite coffee beverage?
Votes: 304