aqua with sensitivity
DESCRIPTION
v gudTRANSCRIPT
Answer Report 1Microsoft Excel 14.0 Answer ReportWorksheet: [Book2]Sheet1Report Created: 2/24/2015 9:47:29 AMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0 Seconds.Iterations: 2 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic ScalingMax Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegativeObjective Cell (Max)CellNameOriginal ValueFinal Value$D$5Unit Profits Total profit6610066100Variable CellsCellNameOriginal ValueFinal ValueInteger$B$4Nuber to make Aqua Spas122122Contin$C$4Nuber to make Hydrolux7878ContinConstraintsCellNameCell ValueFormulaStatusSlack$D$10Tubing reqd Used2712$D$10