Microsoft Excel 16 0 Sensitivity Report Worksheet Book1 Sheet1 Report Created 7 14 2020 11 48 25 AM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $E$6 X1 111 1 0 500 100 140 $F$6 X2 4 0 800 583 3 500 $G$6 X3 0 704 4 1000 704 4 1E 30 $H$6 X4 36 9 0 600 500 100 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R H Side Increase Decrease $K$9 Material 300 116 7 300 20 133 3 $K$10 Machine Hours 156 0 160 1E 30 4 $K$11 Labor Hours 192 9 0 280 1E 30 87 1 $K$12 Inspection Hours 40 800 40 1 7 2 5 $K$13 Shipping 2500 5 6 2500 1568 664 Does the optimal solution change if the amount of Material (a resource constraint) increases to 400 lbs If yes, then what is the new Objective Function Value Show your work

The Answer is in the image, click to view ...

Question: Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 7/14/2020 11:48:25 AM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase

Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 7/14/2020 11:48:25 AM


Variable Cells
			Final	Reduced	Objective	Allowable	Allowable
	Cell	Name	Value	Cost	Coefficient	Increase	Decrease
	$E$6	X1	111.1	0	500	100	140
	$F$6	X2	4	0	800	583.3	500
	$G$6	X3	0	-704.4	1000	704.4	1E+30
	$H$6	X4	36.9	0	600	500	100

Constraints
			Final	Shadow	Constraint	Allowable	Allowable
	Cell	Name	Value	Price	R.H. Side	Increase	Decrease
	$K$9	Material	300	116.7	300	20	133.3
	$K$10	Machine Hours	156	0	160	1E+30	4
	$K$11	Labor Hours	192.9	0	280	1E+30	87.1
	$K$12	Inspection Hours	40	800	40	1.7	2.5
	$K$13	Shipping	2500	5.6	2500	1568	664

Does the optimal solution change if the amount of Material (a resource constraint) increases to 400 lbs.? If yes, then what is the new Objective Function Value? Show your work.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Stewart Manufacturing buys on terms of 2/10, net 30, but it has not been paying on timeit is a slower payer and its suppliers are getting upset. Stewart does not take discounts, and it has been...

Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 7/14/2020 11:48:25 AM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient...

Q4: Consider the LP + 10B + 4C min 3A s.t. + + ALAL 40 + B B 2B A 35 > 0 9 7 The problem is solved by Excel Solver and the Excel Solver sensitivity report for the LP model is given below: Variable...

This is output from a MINIMIZATION problem. I want to remind you that when Excel reports dual variables (shadow prices), the shadow price = (Objective value AFTER right hand side change of +1)...

The Excel output represent a problem whose solution will tell a specialty retailer how many of four different styles of umbrellas to stock in order to maximize profit. It is assumed that everyone...

Microsoft Excel 16.59 Sensitivity Report Worksheet: [Book1]Sheet3 Report Created: 4/3/22 9:57:58 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient...

The tables that follow make up the sensitivity report for Eli Willy (a pharmaceutical distributor). Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost...

The tables that follow make up the sensitivity report for El Willy la pharmaceutical distributor) Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient...

The tables that follow make up the sensitivity report for Eli Willy (a pharmaceutical distributor). Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost...

The Board of Directors of Moon Light Limited, a listed company appointed Mr. Tel, Chartered Accountant as its first auditor within 30 days of the date of registration of the Company to hold office...

Write a C++ method to determine the number of bits that would be required to flip to convert integer A to integer B.

Question 1 7 Which crop became inextricably integral to the Southem economy and identity in the frat half of the 1 9 th certery? sugarcane rice contion indigo

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...