Input Available Constraints
Labour 7000 Limited Demand
Raw material 2500 Limited Resources
Produced 212.4167 0 1041 0 0 0
Product A B C D E F
Labour usage per Unit 6 7.5 5.5 7 6 4
Raw Material per Unit 3.2 2.6 1.5 0.8 0.7 0.3
Unit Price 1270 1210 990 770 660 330
Variable Cost 650 570 360 280 220 120
Demand 960 928 1041 977 1084 1055
Unit Profit 620 640 630 490 440 210
Profit 787528.3
Labour Usage 7000
Raw Material 2241.233
Constraints
Limited Demand
Limited Resources
Hotel Staff Required
Day Monday Tuesday WednesdaThursday Friday Saturday Sunday
Need 13 15 19 15 18 17 10
Minimize Number of Staff 13 15 19 15 18 17 10
Monday Tuesday WednesdThursday Friday Saturday Sunday
19 Monday 1 1 1 1 1 0 0
0 Tuesday 0 1 1 1 1 1 0
0 Wednesda 0 0 1 1 1 1 1
17 Thursday 1 0 0 1 1 1 1
0 Friday 1 1 0 0 1 1 1
0 Saturday 1 1 1 0 0 1 1
0 Sunday 1 1 1 1 0 0 1
36 36 19 19 36 36 17 17
19
Cost to produce and distribute from one region to another Region Kigoma
Demand 2500
Kigoma Dodoma Singida Kagera Ruvuma Lindi Morogoro
Arusha 400 180 150 370 450 420 320 Region Arusha
Dar 380 220 270 490 250 230 150 Capacity 5000
Mbeya 300 230 250 440 240 210 200
Mwanza 280 330 300 160 500 480 350
Kigoma Dodoma Singida Kagera Ruvuma Lindi Morogoro
Arusha 1 1 1 1 1 1 1 7 2290
Dar 1 1 1 1 1 1 1 7 1990
Mbeya 1 1 1 1 1 1 1 7 1870
Mwanza 1 1 1 1 1 1 1 7 2400
4 4 4 4 4 4 4 8550
Dodoma Singida Kagera Ruvuma Lindi Morogoro
4500 2000 2500 1200 1000 3800
Dar Mbeya Mwanza
7500 3000 2000
NPV Year 1 Cost Year 2 Cost Year 3 CosYear4 CosLbr 1 Lbr 2 Lbr 3
1 Project 1 758 600 500 845 1190 1535 1880 75
1 Project 2 916 718 432 300 168 36 198 209
1 Project 3 933 755 564 893 325 271 254 135
1 Project 4 304 789 872 469 452 272 101 194
1 Project 5 727 733 535 679 376 171 111 176
1 Project 6 708 637 896 357 594 255 220 260
1 Project 7 627 653 793 375 486 226 194 239
1 Project 8 882 705 792 406 602 132 285 271
1 Project 9 326 714 489 471 610 227 284 103
1 Project 10 749 672 709 304 797 153 194 230
1 Project 11 650 660 603 773 364 227 264 272
1 Project 12 602 797 709 328 763 214 242 292
1 Project 13 950 673 812 619 306 233 200 102
1 Project 14 779 704 769 683 734 123 256 168
1 Project 15 490 772 509 607 549 103 295 135
1 Project 16 795 626 769 895 814 217 295 171
1 Project 17 318 743 618 698 484 113 211 274
1 Project 18 350 609 367 662 513 246 295 107
1 Project 19 393 602 782 624 725 192 216 126
1 Project 20 620 790 898 766 317 210 162 158
1 Project 21 817 645 699 828 717 159 268 183
1 Project 22 848 730 651 507 660 170 154 237
1 Project 23 569 365 544 378 621 223 222 231
1 Project 24 520 458 688 508 885 100 184 255
1 Project 25 358 821 303 768 584 100 262 276
1 Project 26 353 595 638 404 842 127 273 252
1 Project 27 640 340 583 850 399 177 126 290
1 Project 28 906 767 394 799 797 135 252 137
1 Project 29 324 444 522 608 334 266 185 269
1 Project 30 357 668 867 763 367 156 230 190
1 Project 31 792 756 343 821 572 222 154 140
1 Project 32 403 602 401 577 854 102 120 126
1 Project 33 718 759 707 508 302 230 188 141
1 Project 34 491 497 803 816 408 250 139 267
1 Project 35 839 769 611 535 339 200 223 226
1 Project 36 781 854 443 748 822 253 110 167
1 Project 37 530 678 548 770 370 100 194 150
1 Project 38 804 363 874 500 308 238 157 221
1 Project 39 385 304 391 412 656 223 221 168
1 Project 40 596 300 835 646 629 192 294 233
24908 25667 25263 24500 22635 8779 10113 7856
Lbr 4 Available
58 Year 1 Cost 15000
16 Year 2 Cost 12000
48 Year 3 Cost 10000
38 Year4 Cost 13000
51 Lbr 1 2300
50 Lbr 2 4500
29 Lbr 3 3200
20 Lbr 4 1000
44
55
34 Maximize NPV
31 Project 4 and 5 must be undertaken
41 5 projects must be chosen from project 1 to 10
29 Do not choose project 18
49 If project 6 is chosen, 11 can not be chosen and vice versa
60 Project 20 and 14 must be taken together or left out
14
25
16
54
57
46
18
14
42
24
45
11
17
49
39
53
44
32
33
37
14
37
10
49
1433
I am planning for my retirement, and at the beginning of this year and each of the next 39 years, I’ m
going to contribute some money to my retirement fund. Each year, I plan to increase my retirement
contribution by TZS 600,000. When I retire in 40 years, I plan to withdraw (at the beginning of each
year) TZS 200 Mln per year for 20 years. I’ve made the following assumptions about the yields for my
retirement investment portfolio:
During the first 20 years of my investing, the investments will earn 9 percent per year.
During all other years, my investments will earn 6 percent per year.
Year Contribution rate Withdraw Balance
DAR ARUSH BABATI BARIAD BUKOB DODOM GEITA IRINGA KIBAHA KIGOMA
DAR 646 814 1127 1433 451 1228 492 35 1258
ARUSHA 646 168 762 1068 425 863 689 611 1090
BABATI 814 168 594 900 257 695 521 779 922
BARIADI 1127 762 594 654 676 376 940 1092 761
BUKOBA 1433 1068 900 654 982 298 1246 1398 551
DODOMA 451 425 257 676 982 777 264 416 807
GEITA 1228 863 695 376 298 777 1041 1193 514
IRINGA 492 689 521 940 1246 264 1041 457 1071
KIBAHA 35 611 779 1092 1398 416 1193 457 1223
KIGOMA 1258 1090 922 761 551 807 514 1071 1223
LINDI 452 1098 1266 1579 1885 903 1680 944 487 1710
MBEYA 822 1020 851 899 1205 594 1000 330 787 860
MOROGORO 192 621 516 935 1241 259 1036 300 157 1066
MOSHI 566 80 248 842 1148 505 943 769 531 1170
MPANDA 1383 1581 1413 695 720 1155 684 891 1348 299
MTWARA 556 1202 1370 1683 1989 1007 1784 1048 591 1814
MUSOMA 1370 499 513 164 634 919 337 1183 1335 851
MWANZA 1152 787 619 230 416 701 119 965 1117 633
NJOMBE 710 907 739 1158 1464 482 1259 218 675 1089
SHINYANGA 989 624 456 138 516 538 239 802 954 622
SINGIDA 696 331 163 431 737 245 532 509 661 759
SONGEA 947 1144 976 1396 1671 720 1496 455 912 1326
S'WANGA 1150 1348 1179 928 954 922 917 658 1115 532
TABORA 829 661 493 332 638 378 433 642 794 429
TANGA 354 435 603 1197 1503 588 1298 629 319 1525
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
LINDI MBEYA MORO GMOSHI MPAND MTWAR MUSOM MWANZA JOMBE SHINYA SINGIDA
452 822 192 566 1383 556 1370 1152 710 989 696
1098 1020 621 80 1581 1202 499 787 907 624 331
1266 851 516 248 1413 1370 513 619 739 456 163
1579 899 935 842 695 1683 164 230 1158 138 431
1885 1205 1241 1148 720 1989 634 416 1464 516 737
903 594 259 505 1155 1007 919 701 482 538 245
1680 1000 1036 943 684 1784 337 119 1259 239 532
944 330 300 769 891 1048 1183 965 218 802 509
487 787 157 531 1348 591 1335 1117 675 954 661
1710 860 1066 1170 299 1814 851 633 1089 622 759
1068 644 1018 1629 104 1822 1604 839 1441 1148
1068 630 1100 561 1122 1142 924 229 761 603
644 630 541 1191 748 1178 960 518 797 504
1018 1100 541 1104 1122 579 867 987 704 411
1629 561 1191 1104 1683 938 720 790 557 693
104 1122 748 1122 1683 1926 1708 893 1545 1252
1822 1142 1178 579 938 1926 218 1401 381 674
1604 924 960 867 720 1708 218 1183 163 456
839 229 518 987 790 893 1401 1183 1020 727
1441 761 797 704 557 1545 381 163 1020 293
1148 603 504 411 693 1252 674 456 727 293
602 466 755 1224 1027 656 1638 1420 237 1257 964
1396 328 958 1428 233 1450 1171 953 557 790 931
1281 567 637 741 363 1385 575 357 796 194 330
806 959 329 355 1520 910 933 1222 847 1059 766
SONGEA S'WAN TABORA TANGA
947 1150 829 354
1144 1348 661 435
976 1179 493 603
1396 928 332 1197
1671 954 638 1503
720 922 378 588
1496 917 433 1298
455 658 642 629
912 1115 794 319
1326 532 429 1525
602 1396 1281 806
466 328 567 959
755 958 637 329
1224 1428 741 355
1027 233 363 1520
656 1450 1385 910
1638 1171 575 933
1420 953 357 1222
237 557 796 847
1257 790 194 1059
964 931 330 766
794 1033 1084
794 596 1287
1033 596 1096
1084 1287 1096
