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

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture