Cell Name Original Value Final Value
Cell Name Original Value Final Value
Cell Name Original Value Final Value
40 Answer Report
Worksheet: [Book2]Sheet1
Report Created: 16/09/20 2:08:54 AM
Result: Solver found a solution. All constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 197575232.746 Seconds.
Iterations: 0 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 1E-06
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative
Variable Cells
Cell Name Original Value Final Value Integer
$F$15 y1 0 0 Binary
$G$15 y2 0 0 Binary
$F$16 y1 0 0 Binary
$G$16 y2 0 0 Binary
$F$17 y1 0 0 Binary
$G$17 y2 0 0 Binary
$F$18 y1 0 0 Binary
$G$18 y2 0 0 Binary
$F$19 y1 0 0 Binary
$G$19 y2 0 0 Binary
$F$20 y1 0 0 Binary
$G$20 y2 0 0 Binary
$F$21 y1 0 0 Binary
$G$21 y2 0 0 Binary
$F$22 y1 0 0 Binary
$G$22 y2 0 0 Binary
$F$23 y1 0 0 Binary
$G$23 y2 0 0 Binary
Constraints
Cell Name Cell Value Formula Status Slack
$H$15 y1+y2<=1 $H$15<=1 Not Binding 1
$H$16 y1+y2<=1 $H$16<=1 Not Binding 1
$H$17 y1+y2<=1 $H$17<=1 Not Binding 1
$H$18 y1+y2<=1 $H$18<=1 Not Binding 1
$H$19 y1+y2<=1 $H$19<=1 Not Binding 1
$H$20 y1+y2<=1 $H$20<=1 Not Binding 1
$H$21 y1+y2<=1 $H$21<=1 Not Binding 1
$H$22 y1+y2<=1 $H$22<=1 Not Binding 1
$H$23 y1+y2<=1 $H$23<=1 Not Binding 1
$K$14 HS 125 $K$14>=$N$15 Not Binding 94.6
$K$15 S 125 $K$15>=$N$16 Not Binding 94.6
$K$16 S 125 $K$16>=$N$17 Not Binding 101
$K$17 S 125 $K$17>=$N$18 Not Binding 125
$K$18 S 125 $K$18>=$N$19 Not Binding 86.6
$K$19 S 125 $K$19>=$N$20 Not Binding 86.6
$K$20 S 125 $K$20>=$N$21 Not Binding 78.6
$K$21 S 125 $K$21>=$N$22 Not Binding 79.4
$K$22 S 125 $K$22>=$N$23 Not Binding 78.6
$F$15:$G$23=Binary
Assume NonNegative
per week production Production cost Current inventory Cost per unit
Shampoo (S) 100 225 125 2.25
Hand Sanitizers (H) 80 310 143 3.875
At a time
either of
them canbe
produced Addition in production Production cost S H
y1+y2<=1 S H 125 143
0 0 0 0 0 70 105
1 100 0 225 0 115 67
0 0 0 0 0 71 37
1 0 80 0 310 71 117
1 100 0 225 0 126 69
1 0 80 0 310 81 101
1 0 80 0 310 45 123
1 100 0 225 0 110 66
1 0 80 0 310 75 88
4658.60063
Constraints
production weekend inventory> 0.8*next week demand
Switching cost if y11-y12=0 (y11-y12)500
production cost y1*Pc y2*PC
Inventory cost 0.195*production cost per unit*inventory at the weekend/12
9.79875 509.79875
231.3984375 731.3984375
6.654375 506.654375
313.94875 313.94875
231.87375 731.87375
317.1296875 817.1296875
316.654375 316.654375
231.1425 731.1425