Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the Excel output below, what happens when the profit contribution for both products X and Y are changed to $4.75 each? This question

Based on the Excel output below, what happens when the profit contribution for both products X and Y are changed to $4.75 each? This question is independent of the previous question so the assumption is that you've 'reset' the problem to its original output values shown and are now applying the change indicated in this current question only. Max 4X + 5Y s.t. 1 X + 2 Y <= 10 labour in hours 6 X + 6 Y <= 36 material available in kg 8 X + 4 Y <= 40 storage available in sq m Solution Decision Variables X Y items Produced 2 4 Maximize Total Profit 28 Constraints Amount Used (LHS) Amount Available (RHS) labour in hours 10 <= 10 material avail in kg 36 <= 36 storage avail in sq m 32 <= 40 Sensitivity report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$18 items Produced X 2 0 4 1 1.5 $C$18 items Produced Y 4 0 5 3 1 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$23 labour in hours Amount Used (LHS) 10 1 10 2 2 $B$24 material avail.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Changing the profit contribution for both products X and Y to 475 each will not affect the optimal s... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Decision Modeling With Spreadsheets

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

3rd Edition

136115837, 978-0136115830

More Books

Students also viewed these Accounting questions