Maximizing Monthly Revenues Using Solver in Microsoft Excel

School: Virginia Tech - Course: ACIS 1504 - Subject: Accounting

StoreMonthly Revenue 1127 298 367 492 579 6104 799 874 987 4,7,8 5,6,7,8 Question69 Question 7Max Revenuex1 + Revenuex2 Question 8Constraint >=x4 + x7 +x8 + x9 Question 93, 5, 6, 4, 7, 8 X5 + X6 + X7 + X9 >= 1 Question 10in order tomaximizemonthly revenues

Microsoft Excel 16.0 Answer Report Worksheet: [Book1]Sheet2 Report Created: 10/6/2022 4:01:03 PM Result: Solver found a solution.All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.109 Seconds. Iterations: 13 Subproblems: 0 Solver Options Max Time Unlimited,Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) CellNameOriginal Value Final Value $B$12Total Revenue #1827827 Variable Cells CellNameOriginal Value Final ValueInteger $B$10Store selection #111 Binary $C$10Store selection #211 Binary $D$10Store selection #311 Binary $E$10Store selection #411 Binary $F$10Store selection #511 Binary $G$10Store selection #611 Binary $H$10Store selection #711 Binary $I$10Store selection #811 Binary $J$10Store selection #911 Binary Constraints CellNameCell ValueFormulaStatusSlack $K$3Top circle Sum2 $K$3>=1Not Binding1 $K$4Middle circle Sum5 $K$4>=1Not Binding4 $K$5Right Circle Sum4 $K$5>=1Not Binding3 $K$6Bottom Circle Sum4 $K$6>=1Not Binding3 $B$10:$J$10=Binary