Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | May 2017 |
Last Sign in: | 307 Weeks Ago, 3 Days Ago |
Questions Answered: | 66690 |
Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Use Solver to create Answer and Sensitivity Reports for question 22 at the end of Chapter 2, and answer the following questions:
Â
a. If the profit on doors increased to $700, would the optimal solution change?
b. If the profit on windows decreased to $200, would the optimal solution change?
c. Explain the shadow price for the finishing process.
d. If 20 additional hours of cutting capacity became available, how much additional profit could the company earn?
e. Suppose another company wanted to use 15 hours of Sanderson's sanding capacity and was willing to pay $400 per hour to acquire it. Should Sanderson agree to this? How (if at all) would your answer change if the company instead wanted 25 hours of sanding capacity?
Question 22
Sanderson Manufacturing produces ornate, decorative wood frame doors and windows. Each item produced goes through three manufacturing processes: cutting, sanding, and finishing. Each door produced requires 1 hour in cutting, 30 minutes in sanding, and 30 minutes in finishing. Each window requires 30 minutes in cutting, 45 minutes in sanding, and 1 hour in finishing. In the coming week Sanderson has 40 hours of cutting capacity available, 40 hours of sanding capacity, and 60 hours of finishing capacity. Assume all doors produced can be sold for a profit of $500, and all windows can be sold for a profit of $400.
a. Formulate an LP model for this problem.
b. Sketch the feasible region.
c. What is the optimal solution?
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on-----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------