Assignment1_Problem 1-Solution1.xlsx - Microsoft Excel 15.0...

• Homework Help
• 12
• 100% (1) 1 out of 1 people found this document helpful

This preview shows page 1 - 3 out of 12 pages.

Microsoft Excel 15.0 Answer ReportWorksheet: [Book55]Sheet1Report Created: 8/3/2017 3:41:29 PMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0.063 Seconds.Iterations: 8 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\$E\$7Exposure t.v 121602160Variable CellsCellNameOriginal ValueFinal ValueInteger\$E\$6variables t.v 11010 Contin\$F\$6variables t.v. 255 Contin\$G\$6variables radio 11515 Contin\$H\$6variables radio 21818 Contin\$I\$6variables news12020 Contin\$J\$6variables news 21010 ContinConstraintsCellNameCell ValueFormulaStatusSlack\$E\$19tv budget LHS150000 \$E\$19>=\$L\$9Not Binding10000\$E\$20radio budget LHS99000 \$E\$20<=\$L\$10 Binding0\$E\$21news budget LHS30000 \$E\$21>=\$L\$11 Binding0\$E\$22tv ads LHS15 \$E\$22<=\$L\$12Not Binding5\$E\$23radio ads/tvads LHS3 \$E\$23>=\$L\$13Not Binding3\$E\$24tv1 LHS10 \$E\$24<=\$L\$14 Binding0\$E\$25 radio 1 LHS15 \$E\$25<=\$L\$15 Binding0\$E\$26news 1 LHS20 \$E\$26<=\$L\$16 Binding0\$E\$27total budget LHS279000 \$E\$27<=\$L\$17 Binding0
Microsoft Excel 15.0 Sensitivity ReportWorksheet: [Book55]Sheet1Report Created: 8/3/2017 3:41:29 PMVariable CellsFinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecrease\$E\$6variables t.v 110090 1.00000E+03035\$F\$6variables t.v. 25055 11.6666666675\$G\$6variables radio 115025 1.00000E+0305\$H\$6