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
Expert's Answer
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order NowGet Online
Assignment Help Services