Attachment # 00001668 - HW7_answer_sheet.xlsx
HW7_answer_sheet.xlsx (21.49 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
<=Profits for each productMaximized profitsPlease enter your solution in Yellow cellsLaborResourcesAvailable ResourcesSporting GoodsResource Requirements per UnitProductRubber (lb.)Leather (ft2)BasketballFootballTotal resources availableProfits ($)Please use computer method to solve the problemConstraintsDecision variablesObjective functioninput Constraintsinput Objective function(3a)(3b)(1)(2)A & B productsHours/ UnitLine 1Line2ABTotal HoursProduct AProduct Bdecision variables(2a)(2b)Sensitivity analysisMin MaxCoefficients in the objective function (profits for A and B)Shadow priceLine 2Additional ProfitsIrwin textile millsCottonCorduroydenimDemandsLeft overPlease run sensitivity analysis on P10 and enter the results (changes in coefficients of the objective function, and shadow prices) in YELLOW cellsPlease run sensitivity analysis on P14 and answer the following questions.a.       If Irwin Mills can obtain additional cotton or processing time, but not both, which should it select? How much? Explain your answer. Answer: Then explain the sensitivity range for the demand for corduroy. a.       Identify the sensitivity ranges for the objective function coefficients and for the constraint quantity values. Corduroy Demand rangesMinUnited Aluminum companyAluminum GradeMillHighMediumLowconstraintsCost ($)Mill #1Mill #2Minimize Cost ($)>=a.       Identify and explain the shadow prices for each of the aluminum grade contract requirements.Shadow Priceb.       Identify the sensitivity ranges for the objective function coefficients and the constraint quantity values.c.BiscuitLabor (hr.)Sausage (lb.)Ham (lb.)Flour (lb.)Sausage ---HamBurger Doodle franchise Maximize Profits a.       Identify and explain the shadow prices for each of the resource constraintsSausageFlourb.       Which of the resources constrains profit the most?Answer: c. Identify the sensitivity ranges for the profit of a sausage biscuit and the amount of sausage available. Sausage ProfitsSausage amounts
Please help me understand week 7 MAT540

Please help me understand week 7 MAT540

Question # 00022147 Posted By: princessj Updated on: 08/05/2014 04:25 PM Due on: 08/17/2014
Subject General Questions Topic General General Questions Tutorials:
Question
Dot Image
Please help me understand week 7 MAT540
Dot Image
Attachments
Week_7_discussion.docx (12.72 KB)
mat540_hw_wk7.docx (28.89 KB)
HW7_answer_sheet.xlsx (21.49 KB)
Tutorials for this Question
  1. neil2103
    Tutorial # 00021480 Posted By: neil2103 Posted on: 08/05/2014 06:51 PM
    Puchased By: 3
    Tutorial Preview
    The solution of Pleas-e help me understand week 7 MAT540-[ayment...
      Get the Solution
    Attachments
    Solution-00021480.zip (125 KB)
Whatsapp Lisa