Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fill out the blue table on the bottom-right of the file , thank you so much. Microsoft Excel 16.0 Sensitivity Report Worksheet: [MSW Assignment 1

Fill out the blue table on the bottom-right of the file , thank you so much.

image text in transcribedimage text in transcribedimage text in transcribed
Microsoft Excel 16.0 Sensitivity Report Worksheet: [MSW Assignment 1 Key Sp2021.xlsx]Sheet1 Report Created: 4/1/2021 12:41:53 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$7 Y1 15 0 0.5 0.4 0.4 $D$7 Y2 15 O 0.3 1.2 0.133333333 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$10 A LHS 30 0 12 18 1E+30 $E$11 BLHS 24 0.125 24 48 9.6 $E$12 C LHS 120 0.075 120 144 80 $E$13 D LHS 12 0 26 1E+30 14Criterion Minimize 12 Variable Cells: Allowable Increase and Decrease Checks 0.5 0.3 New Coefficient Prediction of Solution P Y1 0.9 NO CHANGE Choices Y1 Y2 0.1 NO CHANGE 15 15 1 CHANGE 0 CHANGE Y1 Y2 LHS Type RHS Y2 1.5 NO CHANGE Constraints A 0 2 30 >= 0.166666667 NO CHANGE B 0.4 1.2 24 >= 24 1.6 CHANGE C 6 2 120 >= 120 0.066666667 CHANGE D 0.4 0.4 12

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

A Short Course In Automorphic Functions

Authors: Joseph Lehner

1st Edition

0486799921, 9780486799926

More Books

Students also viewed these Mathematics questions