Microsoft Excel 15.0 Sensitivity Report
Worksheet: [Program me a Flying Car or two 20(1).xlsx]Make me a Flying Car
Report Created: 22-Jul-21 8:45:39 AM
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$19 quantity Ferrari 0 0 500 40.306748466 1E+030
$C$19 quantity BMW 67.36196319 0 320 177.72727273 107.70491803
$D$19 quantity Lotus 374.35582822 0 300 109 37.329545455
$E$19 quantity Tesla 102.97546012 0 300 105.26315789 125.14285714
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
Molding
Minutes
$F$26 Available 120920.2454 0 135000 1E+030 14079.754601
Sanding
Minutes
$F$27 Available 96577.453988 0 135000 1E+030 38422.546012
Polishing
Minutes
$F$28 Available 108000 0.490797546 108000 22085.526316 12207.446809
Painting
Minutes
$F$29 Available 108000 0.5349693252 108000 8895.3488372 14447.368421
, Finishing Assbly
Minutes
$F$30 Available 112500 0.4797546012 112500 21250 27516.393443
Minutes
$F$31 Available 0 -40.306748466 0 180 0
Minutes
$F$32 Available 67.36196319 0 0 67.36196319 1E+030
Minutes
$F$33 Available 374.35582822 0 0 374.35582822 1E+030
Minutes
$F$34 Available 102.97546012 0 0 102.97546012 1E+030
Worksheet: [Program me a Flying Car or two 20(1).xlsx]Make me a Flying Car
Report Created: 22-Jul-21 8:45:39 AM
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$19 quantity Ferrari 0 0 500 40.306748466 1E+030
$C$19 quantity BMW 67.36196319 0 320 177.72727273 107.70491803
$D$19 quantity Lotus 374.35582822 0 300 109 37.329545455
$E$19 quantity Tesla 102.97546012 0 300 105.26315789 125.14285714
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
Molding
Minutes
$F$26 Available 120920.2454 0 135000 1E+030 14079.754601
Sanding
Minutes
$F$27 Available 96577.453988 0 135000 1E+030 38422.546012
Polishing
Minutes
$F$28 Available 108000 0.490797546 108000 22085.526316 12207.446809
Painting
Minutes
$F$29 Available 108000 0.5349693252 108000 8895.3488372 14447.368421
, Finishing Assbly
Minutes
$F$30 Available 112500 0.4797546012 112500 21250 27516.393443
Minutes
$F$31 Available 0 -40.306748466 0 180 0
Minutes
$F$32 Available 67.36196319 0 0 67.36196319 1E+030
Minutes
$F$33 Available 374.35582822 0 0 374.35582822 1E+030
Minutes
$F$34 Available 102.97546012 0 0 102.97546012 1E+030