Asad Najeeb

Kisa Talib
M. Wasif Farooq
Tehreem Tahir

MBA 2k16 B
 x1 x2 x3 x4 x5 x6 x7
Objective function 425.875 452.66 431.03 154.6 605.03 513.98 550.6
Time 0.75 1 0.83 1.16 0.83 0.83 1.16
Number of orders: Cupcakes 1
Red Velvet 1
Lemon Parfait 1
Bread Pudding 1
Belgian Chocolate Dessert 1
BB Cheesecake 1
Brownies 1
Macarons
Double Chocolate Cookies
Customized Cupcakes
Customized cakes
Butter 120 100 75 100 25 75 100
Flour 150 150 150 0 0 0 120
Cocoa Powder hershey 23 0 0 0 0 0 0
Cocoa Powder 23 15 0 0 0 0 35
Icing Sugar 200 600 50 0 0 50
Sugar 200 200 276 120 0 0 200
Eggs 1 1 4 3 0 0 2
Chocolate 0 0 0 0 300 0 0
Cream 200 200 300 200 0
Bitter sweet Chocolate 0 0 0 0 0 0 0
Vanilla 8 8 1 0 0 1 1
Baking Soda 0 4 0 0 0 0
Salt 0 2.5 0 0 0 0
Chopped Chocolate Cadburry 0 0 0 0 0 0
Hersheys Chips 0 0 0 0 0 0
Almond meal 0 0 0 0 0 0
Lemon 0 2 4 0 0 2 0
Cream Cheese 0 0 0 0 0 300 0
Blueberry Filling 0 0 0 0 0 200 0
Digestives 0 0 200 0 0 200 0
Oreo 0 0 0 0 200 0 0
Milk 150 100 100 400 0 0 0
Baking Powder 3 1 3 0 0 0 0.25
Glucose 0 0 0 0 0 0
Oil 90 0 100 0 0 0 0
cost/budget 462 606 1068 426 894 984 330

Assumptions
1- There is demand for all items
x1 x2 x3 x4 x5 x6 x7
1 2 0 0 2 2 4
x8 x9 x10 x11
1200.838 443.875 1039.075 1785.9 usage sign available per month Q 12days
3 0.917 4.41 7 93.378 <= 96
1 <= 12 12
2 <= 4 4
0 <= 2 2
0 <= 2 2
2 <= 2 2
2 <= 4 4
4 <= 4 4
1 3 <= 3 3
1 4 <= 5 5
1 0 <= 8 8
1 10 <= 24 24
0 60 120 100 2160 <= 6000
0 60 150 150 2670 <= 10000
0 0 23 23 253 <= 1000
0 70 23 23 703 <= 1200
150 850 1100 12950 <= 16200
150 125 200 200 4350 <= 5000
3 2 1 2 48 <= 48
100 75 0 100 2200 <= 5000
50 0 0 100 2150 <= 4800
0 113 0 0 452 <= 2000
0 3.75 8 8 125 <= 300
0 2.5 0 0 18 <= 500
0 2.5 0 0 15 <= 1000
0 75 0 0 300 <= 600
0 50 0 0 200 <= 545
159 0 0 0 477 <= 900
0 0 0 0 8 <= 24
0 0 0 0 600 <= 1200
0 0 0 0 400 <= 595
0 0 0 0 400 <= 800
0 0 0 0 400 <= 500
0 0 150 150 1850 <= 2000
0 0 3 3 36 <= 500
0 0 0 0 0 <= 2000
0 0 90 90 990 <= 10000
756 444 598.8 1185 22644 <= 25000

x8 x9 x10 x11 Zmax Profit labor cost

3 4 0 10 29008.63 24508.63 3000
transport cost 1500
x1 cupcakes
x2 red velvet
x3 lemon parfait
x4 bread puding
x5 belgian choclate
x6 BB cheesecake
x7 brownies
x8 macarons
x9 dpuble choc
x10 cust cupcakes
x11 cust cakes

cost =labor+transport
4500
 x1 x2 x3 x4 x5 x6 x7
Objective function 425.875 452.66 431.03 154.6 605.03 513.98 550.6
Time 0.75 1 0.83 1.16 0.83 0.83 1.16
Number of orders: Cupcakes 1
Red Velvet 1
Lemon Parfait 1
Bread Pudding 1
Belgian Chocolate Dessert 1
BB Cheesecake 1
Brownies 1
Macarons
Double Chocolate Cookies
Customized Cupcakes
Customized cakes
Butter 120 100 75 100 25 75 100
Flour 150 150 150 0 0 0 120
Cocoa Powder hershey 23 0 0 0 0 0 0
Cocoa Powder 23 15 0 0 0 0 35
Icing Sugar 200 600 50 0 0 50
Sugar 200 200 276 120 0 0 200
Eggs 1 1 4 3 0 0 2
Chocolate 0 0 0 0 300 0 0
Cream 200 200 300 200 0
Bitter sweet Chocolate 0 0 0 0 0 0 0
Vanilla 8 8 1 0 0 1 1
Baking Soda 0 4 0 0 0 0
Salt 0 2.5 0 0 0 0
Chopped Chocolate Cadburry 0 0 0 0 0 0
Hersheys Chips 0 0 0 0 0 0
Almond meal 0 0 0 0 0 0
Lemon 0 2 4 0 0 2 0
Cream Cheese 0 0 0 0 0 300 0
Blueberry Filling 0 0 0 0 0 200 0
Digestives 0 0 200 0 0 200 0
Oreo 0 0 0 0 200 0 0
Milk 150 100 100 400 0 0 0
Baking Powder 3 1 3 0 0 0 0.25
Glucose 0 0 0 0 0 0
Oil 90 0 100 0 0 0 0
cost/budget 462 606 1068 426 894 984 330
min requirement

x1 x2 x3 x4 x5 x6 x7
0 0 0 0 0 0 8
x8 x9 x10 x11
1200.838 443.875 1039.075 1785.9 usage sign available per month Q 30days
3 0.917 4.41 7 216.1 <= 240
0 <= 30 30
0 <= 15 15
0 <= 5 5
0 <= 10 10
0 <= 10 10
0 <= 15 15
8 <= 15 15
1 10 <= 10 10
1 0 <= 15 15
1 2 <= 20 20
1 24 <= 60 60
0 60 120 100 3440 <= 12000
0 60 150 150 4860 <= 20000
0 0 23 23 598 <= 2000
0 70 23 23 878 <= 2400
150 850 1100 29600 <= 32400
150 125 200 200 8300 <= 10000
3 2 1 2 96 <= 96
100 75 0 100 3400 <= 10000
50 0 0 100 2900 <= 9600
0 113 0 0 0 <= 4000
0 3.75 8 8 216 <= 600
0 2.5 0 0 0 <= 1000
0 2.5 0 0 0 <= 2000
0 75 0 0 0 <= 1200
0 50 0 0 0 <= 1090
159 0 0 0 1590 <= 1800
0 0 0 0 0 <= 48
0 0 0 0 0 <= 2400
0 0 0 0 0 <= 1190
0 0 0 0 0 <= 1600
0 0 0 0 0 <= 1000
0 0 150 150 3900 <= 4000
0 0 3 3 80 <= 1000
0 0 0 0 0 <= 4000
0 0 90 90 2340 <= 20000
756 444 598.8 1185 39837.6 <= 40000
1 24 >= 15

x8 x9 x10 x11 Zmax Profit labor cost=l+t

10 0 2 24 61352.93 52352.93 7500 9000
transport 1500
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [MM part1.xlsx]ingredients constrints
Report Created: 28/12/2017 16:44:42

Variable Cells
Final Reduced Objective Allowable
Cell Name Value Cost Coefficient Increase
$B$45:$L$45

Constraints
Final Shadow Constraint Allowable
Cell Name Value Price R.H. Side Increase
$M$14:$M$38 <= $O$14:$O$38

$M$3 Time usage 96 182.84331104 96 11.63060748

$M$39 cost/budget usage 25000 0.0860276459 25000 165.5917
$M$4:$M$13 <= $O$4:$O$13
Allowable
Decrease

Allowable
Decrease

4.45856722
1144.599466