Final Appendix

July 2020
PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA

Overview

Download & View Final Appendix as PDF for free.

More details

Words: 19,264
Pages: 297

Preview
Full text

10. Appendix

Page 553 of 297

Page | 554

Page | 555

Appendix (A): Data Collection

Page | 556 Table A1: Machine list of the can making line.

No

Operation

Rate

Worker/Machine

1 2 3 4 5 6 7

Slitting Welding Lacquering Curing Flanging Seaming Palletizing

Slitting machine Welder Lacquering machine Curing machine Flanging machine Seamer Palletizer

8

Storing

500 sheet/hr 160 cans/min 160 cans/min 160 cans/min 160 cans/min 160 cans/min 2940 can/forklift 5 min/forklift -

2 workers + Forklift

Page | 557 Table A2: Machine list of the filling line.

No

Operation

Rate

Worker/machine

1 2 3 4 5 6

Soaking Reel washing Bucket elevator Blanching Destoning Inspection

8-14 hr/hopper 15 min/batch -

7 8 9 10 11

Solid filling Liquid filling Seaming Coding Crate loading

12 13 14 15 16 17

Sterilizing Crate unloading labeling Check labels Packaging Palletizing

140 cans/min 140 cans/min 140 cans/min 140 cans/min 5 min/crate (6 layers, 120 cans/layer) Distribution 5 min/crate

5 Hoppers Reel washer Elevator 1 Blancher 1 Destoner Inspection Belt 4-6 inspectors 1 Solid filler 1 Liquid filler Seamer Coding machine 1 worker+Crate loader

18

Storing

140 cans/min 140 labels/min 30 cartoons/min 90 cartoons/pallet 1 pallet/min -

5 retorts 2 workers+Crate unloader Labeler 1 worker Shrink wrapper 2 workers+forklift 2 workers+forklift

Page | 558

Appendix (B): Daily Production (Can Making Line and Filling Line)

Page | 559

Daily Production of the Can Making Line Table B1: Summary of the daily production of the can making line (400 g can only).

No.

Date

No. of Sheets Used

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 26 27 28 29 30 31 32 33 34 35

18-8-2008 19-8-2008 20-8-2008 23-8-2008 24-8-2008 25-8-2008 26-8-2008 27-8-2008 1-9-2008 2-9-2008 3-9-2008 4-9-2008 7-9-2008 8-9-2008 9-9-2008 10-9-2008 13-9-2008 14-9-2008 15-9-2008 20-9-2008 21-9-2008 22-9-2008 23-9-2008 24-9-2008 27-9-2008 28-9-2008 29-9-2008 7-10-2008 8-10-2008 11-10-2008 12-10-2008 13-10-2008 14-10-2008 15-10-2008 18-10-2008

3000 3000 1500 1500 3000 3000 3000 3000 1500 3000 1500 3000 1500 3000 1500 1500 3000 1500 3000 3000 3000 3000 1500 1500 1500 3000 1500 1000 1500 3000 4000 4000 3600 3500 2864

Quantity (Cans)

Scrap 1

Scrap 2

Total

Scrap (%)

76875 76678 39032 58864 79876 84806 83140 63429 53694 64301 65100 57474 31516 65417 57847 51115 62588 62155 54146 61100 60203 56200 63120 37037 67200 67200 65325 75376 35203 73990 95666 100401 101100 98200 80102

33 40 48 51 36 30 29 44 32 29 44 33 30 24 56 44 53 33 25 49 93 81 55 41 39 21 31 96 53 68 51 101 57 93 115

35 30 99 89 51 66 44 36 37 33 38 36 38 36 93 96 68 51 38 36 69 58 39 36 52 33 37 89 39 44 38 68 39 43 52

68 70 147 140 87 96 73 80 69 62 82 69 68 60 149 140 121 84 63 85 162 139 94 77 91 54 68 185 92 112 89 169 96 136 167

0.09 0.09 0.38 0.24 0.11 0.11 0.09 0.13 0.13 0.1 0.13 0.12 0.22 0.09 0.26 0.27 0.19 0.14 0.12 0.14 0.27 0.25 0.15 0.21 0.14 0.08 0.1 0.25 0.26 0.15 0.09 0.17 0.09 0.14 0.21

Page | 560

No.

Date

No. of Sheets Used

36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Avg.

19-10-2008 20-10-2008 21-10-2008 22-10-2008 26-10-2008 27-10-2008 28-10-2008 29-10-2008 1-11-2008 2-11-2008 3-11-2008 4-11-2008 8-11-2008 9-11-2008 10-11-2008 11-11-2008 12-11-2008 15-11-2008 -

3773 3700 2300 3000 3000 3000 3000 3000 3000 3000 2800 3000 1500 3000 3000 1500 3000 2000 2979.9

Quantity (Cans)

Scrap 1

Scrap 2

Total

Scrap (%)

105600 105600 65642 80010 82655 85101 85916 50748 69040 85101 78600 71393 39944 78581 85730 44701 80973 44002 69147.4

56 43 39 48 50 44 29 36 96 51 99 83 55 118 44 66 53 40 53

35 37 31 35 36 30 34 31 37 29 44 38 35 30 26 37 28 24 45

91 80 70 83 86 74 63 67 133 80 143 121 90 148 70 103 81 64 97.9

0.09 0.08 0.11 0.1 0.1 0.09 0.07 0.13 0.19 0.09 0.18 0.17 0.23 0.19 0.08 0.23 0.1 0.15 0.15

Page | 561 Table B2: Summary of number of boxes used daily in the can making line.

No. of Boxes

Frequency (out of 103 data points)

Percentage (%)

1 2 3 Total

19 78 6 103

18 76 6 100

From the table above, it can be concluded that the number of boxes used daily follows the following distribution: ANINT(DISC(0.18, 1, 0.94, 2, 1, 3)

Page | 562

Daily Production of the Filling Line Table B3: Summary of the daily production of the filling line (400 g can only).

No.

Date

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 26 27 28 29 30 31 32 33 34 35

18-8-2008 19-8-2008 20-8-2008 21-8-2008 23-8-2008 24-8-2008 25-8-2008 26-8-2008 27-8-2008 28-8-2008 30-8-2008 31-8-2008 1-9-2008 2-9-2008 3-9-2008 6-9-2008 7-9-2008 8-9-2008 9-9-2008 10-9-2008 11-9-2008 12-9-2008 13-9-2008 14-9-2008 15-9-2008 16-9-2008 17-9-2008 18-9-2008 19-9-2008 20-9-2008 21-9-2008 22-9-2008 23-9-2008 24-9-2008 25-9-2008

Production Production (Cartons) (Cans) 66888 2787 67488 2812 64416 2684 67920 2830 58008 2417 81264 3386 66264 2761 61632 2568 67680 2820 66120 2755 69456 2894 61392 2558 44736 1864 44064 1836 50112 2088 43296 1804 49608 2067 53568 2232 53232 2218 61992 2583 57624 2401 60672 2528 56376 2349 45816 1909 57624 2401 55488 2312 48792 2033 45528 1897 18552 773 28272 1178 52032 2168 47136 1964 57792 2408 53016 2209 67296 2804

Page | 563

No.

Date

36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Avg. SD

9-26-2008 9-27-2008 9-28-2008 9-29-2008 9-30-2008 1-10-2008 2-10-2008 3-10-2008 4-10-2008 5-10-2008 6-10-2008 7-10-2008 8-10-2008 9-10-2008 26-10-2008 27-10-2008 28-10-2008 29-10-2008 1-11-2008 2-11-2008 3-11-2008 4-11-2008 5-11-2008 -

Production Production (Cartons) (Cans) 70560 2940 69576 2899 64704 2696 67176 2799 63504 2646 65208 2717 69240 2885 56088 2337 76176 3174 45960 1915 47880 1995 59376 2474 49680 2070 19464 811 39264 1636 55392 2308 33312 1388 23400 975 47256 1969 77280 3220 49272 2053 58584 2441 95064 3961 2338.1 56113.2 599.1 14378.0

Page | 564

Appendix (C): Daily Production Fitting (Can Making Line and Filling Line)

Page | 565

Daily Production of the Can Making Line The Best Fit:

Figure C1: Histogram of the daily production of the can making line.

Arena Input Analyzer Output: Distribution Summary Distribution: Normal Expression: NORM(6.91e+004, 1.81e+004) Square Error: 0.010554 Chi Square Test Number of intervals =5 Degrees of freedom =2 Test Statistic = 1.31 Corresponding p-value = 0.522 Kolmogorov-Smirnov Test Test Statistic = 0.0862 Corresponding p-value > 0.15 Data Summary Number of Data Points = 53 Min Data Value = 3.15e+004 Max Data Value = 1.06e+005 Sample Mean = 6.91e+004 Sample Std Dev = 1.83e+004 Histogram Summary Histogram Range = 3.15e+004 to 1.06e+005 Number of Intervals = 7

Page | 566

Daily Scrap Cans in the Can Making Line The Best Fit:

Figure C2: Histogram of the number of scrap cans.

Distribution Summary Distribution: Gamma Expression: 54 + GAMM(36.9, 1.19) Square Error: 0.019010 Chi Square Test Number of intervals =5 Degrees of freedom =2 Test Statistic = 12.4 Corresponding p-value < 0.005 Kolmogorov-Smirnov Test Test Statistic = 0.102 Corresponding p-value > 0.15 Data Summary Number of Data Points = 53 Min Data Value = 54 Max Data Value = 185 Sample Mean = 97.9 Sample Std Dev = 34.1 Histogram Summary Histogram Range = 54 to 185 Number of Intervals = 7

Page | 567

Fitting the Normal Distribution:

Figure C3: Histogram of the number of scrap cans.

Distribution Summary Distribution: Normal Expression: NORM(97.9, 33.8) Square Error: 0.071031 Chi Square Test Number of intervals =5 Degrees of freedom =2 Test Statistic = 23.5 Corresponding p-value < 0.005 Kolmogorov-Smirnov Test Test Statistic = 0.289 Corresponding p-value < 0.01 Data Summary Number of Data Points = 53 Min Data Value = 54 Max Data Value = 185 Sample Mean = 97.9 Sample Std Dev = 34.1 Histogram Summary Histogram Range = 54 to 185 Number of Intervals = 7

Page | 568

Daily Production of the Filling Line

Figure C4: Histogram of the daily production of the filling line.

Arena Input Analyzer Output: Distribution Summary Distribution: Normal Expression: NORM(2.34e+003, 594) Square Error: 0.011827 Chi Square Test Number of intervals =5 Degrees of freedom =2 Test Statistic = 2.25 Corresponding p-value = 0.344 Kolmogorov-Smirnov Test Test Statistic = 0.0906 Corresponding p-value > 0.15 Data Summary Number of Data Points = 58 Min Data Value = 773 Max Data Value = 3.96e+003 Sample Mean = 2.34e+003 Sample Std Dev = 599 Histogram Summary Histogram Range = 773 to 3.96e+003 Number of Intervals = 7

Page | 569

Appendix (D): Summary of Production for Different Types of Products

Page | 570

Fava beans Table D1: Production summary for Fava beans (date of production and the quantity).

No.

Date

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 26 27 28 29 30 31 32 33 34 35 Avg. SD

7-7-2008 12-7-2008 17-7-2008 24-7-2008 30-7-2008 6-8-2008 9-8-2008 10-8-2008 13-8-2008 16-8-2008 26-8-2008 28-8-2008 30-8-2008 31-8-2008 6-9-2008 9-9-2008 10-9-2008 15-9-2008 16-9-2008 17-9-2008 21-9-2008 27-9-2008 28-9-2008 29-9-2008 6-10-2008 8-10-2008 11-10-2008 12-10-2008 14-10-2008 20-10-2008 29-10-2008 1-11-2008 2-11-2008 4-11-2008 5-11-2008 -

Quantity (Cartons) 366 980 713 1663 673 2593 344 2882 496 2295 704 1881 1805 450 1804 102 1872 1909 817 718 723 50 124 2209 466 2457 504 2717 1145 749 216 1170 359 2441 2834 1235.17 905.74

Page | 571

Chickpeas Table D2: Production summary for chickpeas (date of production and the quantity).

No.

Date

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

7-7-2008 14-7-2008 19-7-2008 20-7-2008 26-7-2008 28-7-2008 29-7-2008 3-8-2008 5-8-2008 11-8-2008 12-8-2008 16-8-2008 19-8-2008 21-8-2008 24-8-2008 25-8-2008 27-8-2008 31-8-2008 1-9-2008 3-9-2008 7-9-2008

Quantity (Cartons) 2055 1488 1168 2659 3059 784 2478 1279 2675 2725 1215 532 2808 2830 2867 2761 2820 1529 1864 2088 2067

No.

Date

22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Avg. SD

8-9-2008 9-9-2008 11-9-2008 13-9-2008 14-9-2008 18-9-2008 27-9-2008 28-9-2008 4-10-2008 5-10-2008 7-10-2008 18-10-2008 21-10-2008 22-10-2008 26-10-2008 28-10-2008 29-10-2008 2-11-2008 3-11-2008 -

Quantity (Cartons) 1169 1477 2401 981 2349 914 1914 2284 614 577 2696 1866 2474 1079 1043 1388 470 2686 2053 1854.65 791.36

Page | 572

Peas Table D3: Production summary for peas (date of production and the quantity).

No.

Date

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 26 27 28 29 Avg. SD

13-7-2008 19-7-2008 28-7-2008 30-7-2008 3-8-2008 4-8-2008 12-8-2008 18-8-2008 23-8-2008 26-8-2008 28-8-2008 2-9-2008 8-9-2008 13-9-2008 16-9-2008 20-9-2008 21-9-2008 23-9-2008 24-9-2008 4-10-2008 5-10-2008 6-10-2008 11-10-2008 20-10-2008 22-10-2008 27-10-2008 1-11-2008 2-11-2008 5-11-2008 -

Quantity (Cartons) 2175 902 1163 516 199 1589 680 1759 1648 728 795 626 1063 2225 1584 531 50 757 1917 2190 2259 2208 2142 895 1011 2308 799 175 201 1210.17 742.27

Page | 573

Beans Table D4: Production summary for beans (date of production and the quantity).

No.

Date

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

9-7-2008 10-7-2008 14-7-2008 17-7-2008 22-7-2008 27-7-2008 28-7-2008 30-7-2008 4-8-2008 7-8-2008 9-8-2008 13-8-2008 16-8-2008 18-8-2008 20-8-2008 23-8-2008 26-8-2008 28-8-2008 30-8-2008 31-8-2008

Quantity (Cartons) 1796 2224 441 1942 2389 1653 1088 804 504 1838 2306 2135 108 514 2684 519 624 79 1089 579

No.

Date

21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Avg. SD

2-9-2008 9-9-2008 10-9-2008 17-9-2008 20-9-2008 23-9-2008 24-9-2008 5-10-2008 8-10-2008 13-10-2008 14-10-2008 15-10-2008 18-10-2008 20-10-2008 25-10-2008 26-10-2008 29-10-2008 5-11-2008 -

Quantity (Cartons) 1210 639 711 637 1172 421 251 104 342 2885 916 3174 894 351 295 593 289 926 1082.26 856.40

Page | 574

Corn Table D5: Production summary for corn (date of production and the quantity).

No.

Date

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Avg. SD

4-3-2008 17-3-2008 31-3-2008 23-4-2008 27-4-2008 14-5-2008 26-5-2008 18-6-2008 25-6-2008 9-7-2008 19-7-2008 27-7-2008 6-8-2008 18-8-2008 23-8-2008 26-8-2008 17-9-2008 6-10-2008 18-10-2008 -

Quantity (Cartons) 417 482 517 843 130 670 234 519 103 386 252 128 371 484 444 512 957 225 274 418.32 231.12

Page | 575

Mushroom Table D6: Production summary for mushroom (date of production and the quantity).

No.

Date

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Avg. SD

23-3-2008 1-4-2008 27-4-2008 30-4-2008 26-5-2008 5-6-2008 22-6-2008 23-6-2008 26-6-2008 30-6-2008 8-7-2008 13-7-2008 27-7-2008 30-7-2008 7-8-2008 12-8-2008 18-8-2008 23-8-2008 20-9-2008 14-10-2008 25-10-2008 -

Quantity (Cartons) 1171 430 353 430 505 235 389 484 706 398 613 314 577 203 343 492 30 325 194 276 194 412.48 235.76

Page | 576

Appendix (E): Demand Quantity Fittings

Page | 577

This Appendix contains the plots and the distribution summary of the quantities of each entity, using the following hypothesis for all entities: H0: Normal H1: Not Normal After plotting the quantities using Arena Input Analyzer software, the following distributions were deduced.

Note there was not enough data for both corn and mushroom. It would have been possible to go back to the previous months to obtain more data, but because Arena Input Analyzer does not give weights for most recent data, this was not done in order to get more accurate results.

Page | 578

Beans The Best Fit:

Figure E1: Histogram of the beans quantity.

Arena Input Analyzer Output: Distribution Summary Distribution: Beta Expression: 79 + 3.1e+003 * BETA(0.603, 1.26) Square Error: 0.015434 Chi Square Test Number of intervals = 4 Degrees of freedom = 1 Test Statistic = 3.44 Corresponding p-value = 0.0675 Kolmogorov-Smirnov Test Test Statistic = 0.121 Corresponding p-value > 0.15 Data Summary Number of Data Points = 38 Min Data Value = 79 Max Data Value = 3.17e+003 Sample Mean = 1.08e+003 Sample Std Dev = 856 Histogram Summary Histogram Range = 79 to 3.17e+003 Number of Intervals = 6 Reject the null hypothesis.

Page | 579

Chickpeas The Best Fit:

Figure E2: Histogram of the chickpeas quantity.

Arena Input Analyzer Output: Distribution Summary Distribution: Beta Expression: 470 + 2.59e+003 * BETA(0.889, 0.774) Square Error: 0.010475 Chi Square Test Number of intervals = 6 Degrees of freedom = 3 Test Statistic = 2.57 Corresponding p-value = 0.47 Kolmogorov-Smirnov Test Test Statistic = 0.085 Corresponding p-value > 0.15 Data Summary Number of Data Points = 40 Min Data Value = 470 Max Data Value = 3.06e+003 Sample Mean = 1.85e+003 Sample Std Dev = 791 Histogram Summary Histogram Range = 470 to 3.06e+003 Number of Intervals = 6 Reject the null hypothesis.

Page | 580

Fava beans The Best Fit:

Figure E3: Histogram of the Fava beans quantity

Arena Input Analyzer Output: Distribution Summary Distribution: Beta Expression: 50 + 2.83e+003 * BETA(0.577, 0.802) Square Error: 0.036349 Chi Square Test Number of intervals = 5 Degrees of freedom = 2 Test Statistic = 6.94 Corresponding p-value = 0.0328 Kolmogorov-Smirnov Test Test Statistic = 0.125 Corresponding p-value > 0.15 Data Summary Number of Data Points = 35 Min Data Value = 50 Max Data Value = 2.88e+003 Sample Mean = 1.24e+003 Sample Std Dev = 906 Histogram Summary Histogram Range = 50 to 2.88e+003 Number of Intervals = 5 Reject the null hypothesis.

Page | 581

Peas The Best Fit:

Figure E4: Histogram of the peas quantity.

Arena Input Analyzer Output: Distribution Summary Distribution: Uniform Expression: UNIF(50, 2.31e+003) Square Error: 0.043757 Chi Square Test Number of intervals = 5 Degrees of freedom = 4 Test Statistic = 6.34 Corresponding p-value = 0.19 Kolmogorov-Smirnov Test Test Statistic = 0.168 Corresponding p-value > 0.15 Data Summary Number of Data Points = 29 Min Data Value = 50 Max Data Value = 2.31e+003 Sample Mean = 1.21e+003 Sample Std Dev = 742 Histogram Summary Histogram Range = 50 to 2.31e+003 Number of Intervals = 5 Reject the null hypothesis.

Page | 582

Corn The Best Fit:

Figure (E5): Histogram of the peas quantity.

Arena Input Analyzer Output: Distribution Summary Distribution: Triangular Expression: TRIA(103, 188, 957) Square Error: 0.014911

Kolmogorov-Smirnov Test Test Statistic = 0.148 Corresponding p-value > 0.15 Data Summary Number of Data Points = 19 Min Data Value = 103 Max Data Value = 957 Sample Mean = 418 Sample Std Dev = 231 Histogram Summary Histogram Range = 103 to 957 Number of Intervals = 5 Reject the null hypothesis.

Page | 583

Mushroom The Best Fit:

Figure E6: Histogram of the mushroom quantity.

Arena Input Analyzer Output: Distribution Summary Distribution: Normal Expression: NORM(412, 230) Square Error: 0.021688 Chi Square Test Number of intervals =2 Degrees of freedom = -1 Test Statistic = 1.24 Corresponding p-value < 0.005 Kolmogorov-Smirnov Test Test Statistic = 0.202 Corresponding p-value > 0.15 Data Summary Number of Data Points = 21 Min Data Value = 30 Max Data Value = 1.17e+003 Sample Mean = 412 Sample Std Dev = 236 Histogram Summary Histogram Range = 30 to 1.17e+003 Number of Intervals = 5

Fail to reject the null hypothesis.

Page | 584

Appendix (F): Inter-Arrival of Different Types of Products Fitting

Page | 585

This Appendix contains the plots and the distribution summary for the inter-arrival rate of each entity, using the following hypothesis for all entities: H0: Exponential H1: Not Exponential After plotting the inter-arrival rate using Arena Input Analyzer software, the following distributions were obtained.

Note there was not enough data for both corn and mushroom. It would have been possible to go back to the previous months to obtain more data, but because Arena Input Analyzer does not give weights for most recent data, this was not done in order to get more accurate results.

Page | 586

Beans The Best Fit:

Figure F1: Histogram of the peas inter-arrival.

Arena Input Analyzer Output: Distribution Summary Distribution: Beta Expression: 0.5 + 7 * BETA(0.827, 2.05) Square Error: 0.018130 Chi Square Test Number of intervals = 4 Degrees of freedom = 1 Test Statistic = 4.16 Corresponding p-value = 0.0433 Data Summary Number of Data Points = 37 Min Data Value = 1 Max Data Value = 7 Sample Mean = 2.51 Sample Std Dev = 1.61 Histogram Summary Histogram Range = 0.5 to 7.5 Number of Intervals = 7

Reject the null hypothesis.

Page | 587

Chickpeas The Best Fit:

Figure F2: Histogram of the chickpeas inter-arrival.

Arena Input Analyzer Output: Distribution Summary Distribution: Weibull Expression: 0.5 + WEIB(1.95, 1.33) Square Error: 0.001643 Chi Square Test Number of intervals = 4 Degrees of freedom = 1 Test Statistic = 0.487 Corresponding p-value = 0.491 Data Summary Number of Data Points = 39 Min Data Value = 1 Max Data Value = 7 Sample Mean = 2.28 Sample Std Dev = 1.45 Histogram Summary Histogram Range = 0.5 to 7.5 Number of Intervals = 7 Reject the null hypothesis.

Page | 588

Fava beans The Best Fit:

Figure F3: Histogram of the Fava beans inter-arrival.

Arena Input Analyzer Output: Distribution Summary Distribution: Beta Expression: 0.5 + 8 * BETA(0.568, 1.52) Square Error: 0.001658 Chi Square Test Number of intervals = 4 Degrees of freedom = 1 Test Statistic = 0.297 Corresponding p-value = 0.612 Data Summary Number of Data Points = 34 Min Data Value = 1 Max Data Value = 8 Sample Mean = 2.68 Sample Std Dev = 2.03 Histogram Summary Histogram Range = 0.5 to 8.5 Number of Intervals = 8 Reject the null hypothesis.

Page | 589

Peas The Best Fit:

Figure F4: Histogram of the peas inter-arrival.

Arena Input Analyzer Output: Distribution Summary Distribution: Weibull Expression: 0.5 + WEIB(2.7, 1.5) Square Error: 0.020186 Chi Square Test Number of intervals = 4 Degrees of freedom = 1 Test Statistic = 2.79 Corresponding p-value = 0.0964 Data Summary Number of Data Points = 28 Min Data Value = 1 Max Data Value = 7 Sample Mean = 2.93 Sample Std Dev = 1.7 Histogram Summary Histogram Range = 0.5 to 7.5 Number of Intervals = 7 Reject the null hypothesis.

Page | 590

Corn The Best Fit:

Figure F5: Histogram of the corn inter-arrival.

Arena Input Analyzer Output: Distribution Summary Distribution: Uniform Expression: UNIF(1.5, 17.5) Square Error: 0.042438

Data Summary Number of Data Points = 18 Min Data Value =2 Max Data Value = 17 Sample Mean = 8.89 Sample Std Dev = 4.6 Histogram Summary Histogram Range = 1.5 to 17.5 Number of Intervals = 16 Reject the null hypothesis.

Page | 591

Mushroom The Best Fit:

Figure F6: Histogram of the mushroom inter-arrival.

Arena Input Analyzer Output: Distribution Summary Distribution: Exponential Expression: 0.5 + EXPO(7.05) Square Error: 0.083893 Chi Square Test Number of intervals =3 Degrees of freedom =1 Test Statistic = 0.456 Corresponding p-value = 0.5 Data Summary Number of Data Points = 20 Min Data Value =1 Max Data Value = 18 Sample Mean = 7.55 Sample Std Dev = 5.56 Histogram Summary Histogram Range = 0.5 to 18.5 Number of Intervals = 18 Fail to reject the null hypothesis.

Page | 592

Appendix (G): Dates of the Machines Failures

Page | 593

Palletizer\De-Palletizer Table G1: Dates of the Palletizer\De-Palletizer failures.

No.

Date

No.

Date

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

1-11-2006 1-2-2007 19-2-2007 3-3-2007 1-4-2007 19-8-2007 19-08-2007 20-8-2007 21-8-2007 22-8-2007 26-8-2007 27-8-2007 27-8-2007 3-9-2007 3-9-2007 8-9-2007 9-9-2007 10-9-2007 13-9-2007 21-9-2007 24-9-2007

22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

24-9-2007 2-10-2007 3-10-2007 4-10-2007 16-10-2007 30-10-2007 3-11-2007 7-11-2007 12-11-2007 12-12-2007 13-12-2007 5-2-2008 10-2-2008 1-5-2008 14-5-2008 17-5-2008 31-5-2008 5-6-2008 19-8-2008 21-8-2008

Page | 594

Process Line Table G2: Dates of the Process line failures.

No.

Date

No.

Date

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 26 27 28 29 30 31

1-11-2006 1-11-2006 12-11-2006 17-11-2006 17-11-2006 2-12-2006 13-12-2006 14-12-2006 14-12-2006 27-12-2006 15-1-2007 26-1-2007 2-2-2007 14-2-2007 4-3-2007 8-3-2007 1-4-2007 2-4-2007 2-4-2007 5-8-2007 10-8-2007 11-8-2007 12-8-2007 24-8-2007 26-8-2007 29-8-2007 2-9-2007 3-9-2007 6-9-2007 6-9-2007 11-9-2007

32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62

12-9-2007 13-9-2007 15-9-2007 15-9-2007 20-9-2007 22-9-2007 25-9-2007 3-10-2007 4-10-2007 11-10-2007 27-10-2007 31-10-2007 1-11-2007 6-11-2007 7-11-2007 11-11-2007 22-11-2007 23-11-2007 1-12-2007 12-12-2007 23-12-2007 7-2-2008 7-2-2008 1-3-2008 9-4-2008 18-4-2008 31-5-2008 16-6-2008 17-6-2008 18-6-2008 27-8-2008

Page | 595

Crate Loader Table G3: Dates of the crate loader failures.

No.

Date

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

1-10-2006 25-1-2007 3-2-2007 15-2-2007 2-4-2007 15-8-2007 6-9-2007 8-9-2007 22-9-2007 23-9-2007 3-10-2007 4-10-2007 6-10-2007 18-10-2007 1-11-2007 7-11-2007 8-11-2007 10-11-2007 23-11-2007 21-4-2008 1-5-2008 19-5-2008 22-6-2008

Page | 596

Retorts Table G4: Dates of the retorts failures.

No.

Date

No.

Date

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

1-11-2006 11-11-2006 2-12-2006 8-12-2006 17-12-2006 13-1-2007 15-1-2007 4-3-2007 14-3-2007 1-4-2007 2-4-2007 18-8-2007 21-8-2007 27-8-2007 1-9-2007 2-9-2007 3-9-2007 4-9-2007 5-9-2007 8-9-2007 10-9-2007 11-9-2007

23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

12-9-2007 22-9-2007 24-9-2007 8-10-2007 24-10-2007 30-10-2007 5-11-2007 6-11-2007 7-11-2007 7-11-2007 19-11-2007 26-11-2007 4-2-2008 1-4-2008 2-5-2008 31-5-2008 31-5-2008 18-6-2008 16-8-2008 1-11-2008 6-11-2008

Page | 597

Labeler Table G5: Dates of the labeler failures.

No.

Date

No.

Date

1

29

2

11-1-2006 13-2-2007

30

23-10-2007 27-10-2007

3

4-3-2007

31

28-10-2007

4

24-3-2007

32

1-11-2007

5

26-3-2007

33

5-11-2007

6

9-4-2007

34

6-11-2007

7

16-8-2007

35

7-11-2007

8

16-8-2007

36

11-11-2007

9

18-8-2007

37

12-11-2007

10

19-8-2007

38

13-11-2007

11

5-9-2007

39

14-11-2007

12

7-9-2007

40

17-11-2007

13

8-9-2007

41

21-11-2007

14

11-9-2007

42

23-11-2007

15

12-9-2007

43

25-11-2007

16

15-9-2007

44

27-11-2007

17

18-9-2007

45

28-11-2007

18

22-9-2007

46

1-12-2007

19

22-9-2007

47

2-12-2007

20

23-9-2007

48

9-12-2007

21

24-9-2007

49

10-12-2007

22

4-10-2007

50

12-12-2007

23

8-10-2007

51

13-12-2007

24

9-10-2007

52

15-12-2007

25

10-10-2007

53

16-12-2007

26

17-10-2007

54

2-3-2008

27

18-10-2007

55

29-5-2008

28

20-10-2007

56

1-6-2008

Page | 598

Shrink Wrapper Table G6: Dates of the shrink wrapper failures.

No.

Date

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 26 27 28 29 30 31 32 33 34 35

11-1-2006 11-6-2006 12-13-2006 1-10-2007 1-27-2007 1-29-2007 2-4-2007 2-13-2007 2-15-2007 3-3-2007 3-11-2007 4-2-2007 7-25-2007 8-19-2007 8-20-2007 8-21-2007 8-29-2007 8-30-2007 9-9-2007 9-11-2007 9-18-2007 9-30-2007 10-3-2007 10-4-2007 10-23-2007 10-27-2007 11-7-2007 11-14-2007 11-22-2007 11-25-2007 11-26-2007 12-1-2007 12-26-2007 6-1-2008 9-1-2008

Page | 599

Fillers and Seamer Table G7: Dates of the fillers and seamer failures.

No.

Date

No.

Date

No.

Date

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 26 27 28 29 30 31 32 33 34 35

19-10-2006 24-10-2006 30-10-2006 31-10-2006 11-1-2006 11-2-2006 11-5-2006 13-11-2006 13-11-2006 14-11-2006 17-11-2006 18-11-2006 12-2-2006 12-8-2006 12-10-2006 12-11-2006 16-12-2006 20-12-2006 26-12-2006 1-12-2007 15-1-2007 16-1-2007 20-1-2007 22-1-2007 25-1-2007 1-2-2007 4-3-2007 8-3-2007 15-3-2007 19-3-2007 1-4-2007 2-4-2007 8-4-2007 4-6-2007 5-6-2007

36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70

5-6-2007 6-6-2007 9-6-2007 12-6-2007 12-6-2007 23-6-2007 27-6-2007 30-6-2007 14-8-2007 15-8-2007 15-8-2007 16-8-2007 19-8-2007 20-8-2007 22-8-2007 27-8-2007 4-9-2007 6-9-2007 7-9-2007 7-9-2007 10-9-2007 19-9-2007 22-9-2007 23-9-2007 29-9-2007 2-10-2007 3-10-2007 4-10-2007 5-10-2007 7-10-2007 9-10-2007 10-10-2007 16-10-07 23-10-2007 27-10-2007

71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102

30-10-2007 1-11-2007 7-11-2007 12-11-2007 18-11-2007 23-11-2007 27-11-2007 28-11-2007 1-12-2007 11-12-2007 13-12-2007 15-12-2007 23-12-2007 26-12-2007 17-1-08 26-1-2008 18-2-2008 18-2-2008 23-2-2008 30-3-2008 18-4-2008 31-5-2008 1-6-2008 1-6-2008 1-6-2008 3-7-2008 4-9-2008 4-9-2008 8-9-2008 22-9-2008 25-10-2008 5-11-2008

Page | 600

Crate Un-loader Table G8: Dates of the crate un-loader failures.

No.

Date

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

1-11-2006 17-2-2007 4-3-2007 13-3-2007 9-4-2007 6-10-2007 8-10-2007 20-10-2007 24-10-2007 7-11-2007 11-11-2007 23-11-2007 8-12-2007 16-12-2007 26-12-2007 5-6-2008 28-6-2008 12-7-2008 28-7-2008 30-8-2008 20-9-2008

Page | 601

Can Line Table G9: Dates of the crate un-loader failures.

No.

Date

No.

Date

No.

Date

1

25-10-06

40

5-9-2007

79

24-11-2007

2

25-10-06

41

5-9-2007

80

24-11-2007

3

28-10-06

42

7-9-2007

81

25-11-2007

4

31-10-06

43

8-9-2007

82

26-11-2007

5

1-11-2006

44

9-9-2007

83

27-11-2007

6

1-11-2006

45

9-9-2007

84

28-11-2007

7

2-11-2006

46

12-9/2007

85

1-12-2007

8

7-11-2006

47

16-9-2007

86

8-12-2007

9

13-11-2006

48

17-9-2007

87

9-12-2007

10

2-12-2006

49

19-9-2007

88

10-12-2007

11

3-12-2006

50

19-9-2007

89

10-12-2007

12

10-12-2006

51

27-9-2007

90

11-12-2007

13

12-12-2006

52

29-9-2007

91

11-12-2007

14

16-12-2006

53

29-9-2007

92

12-12-2007

15

17-12-2006

54

1-10-2007

93

22-12-2007

16

17-12-2006

55

3-10-2007

94

23-12-2007

17

14-1-2007

56

4-10-2007

95

25-12-2007

18

14-1-2007

57

6-10-2007

96

26-12-2007

19

1-2-2007

58

8-10-2007

97

6-2-2008

20

14-2-2007

59

8-10-2007

98

13-2-2008

21

4-3-2007

60

9-10-2007

99

14-2-2008

22

12-3-2007

61

9-10-2007

100

15-2-2008

23

17-3-2007

62

10-10-2007

101

16-2-2008

24

15-4-2007

63

11-10-2007

102

17-2-2008

25

21-4-2007

64

15-10-2007

103

18-2-2008

26

22-5-2007

65

15-10-2007

104

19-2-2008

27

15-8-2007

66

15-10-2007

105

19-2-2008

28

20-8-2007

67

16-10-2007

106

18-3-2008

29

20-8-2007

68

16-10-2007

107

29-3-2008

30

21-8-2007

69

16-10-2007

108

6-4-2008

31

21-8-2007

18-10-2007

109

12-4-2008

32

25-8-2007

70 71

21-10-2007

110

31-5-2008

33

28-8-2007

72

22-10-2007

111

1-6-2008

34

29-8-2007

73

24-10-2007

112

16-9-2008

35 36

30-8-2007

74

27-10-2007

113

20-9-2008

1-9-2007

75

27-10-2007

114

6-10-2008

37

1-9-2007

76

5-11-2007

115

5-11-2008

38

4-9-2007

77

7-11-2007

116

8-11-2008

39

5-9-2007

78

12-11-2007

117

8-11-2008

Page | 602

Appendix (H): Mean Time between Failures of the Machines Fittings

Page | 603

This Appendix contains the plots and the distribution summary for the mean time between failures of the machines in days, using the following hypothesis for all entities: H0: Exponential H1: Not Exponential After plotting the inter-arrival rate using Arena Input Analyzer software, the following distributions were achieved.

Page | 604

Palletizer\De-Palletizer The Best Fit:

Figure H1: Histogram of the time between failures for the palletizer\de-palletizer.

Arena Input Analyzer Output: Distribution Summary Distribution: Lognormal Expression: -0.5 + LOGN(11.8, 28.3) Square Error: 0.026584 Chi Square Test Number of intervals =6 Degrees of freedom =3 Test Statistic = 6.17 Corresponding p-value = 0.106 Data Summary Number of Data Points = 40 Min Data Value =0 Max Data Value = 80 Sample Mean = 11.7 Sample Std Dev = 20 Histogram Summary Histogram Range = -0.5 to 80.5 Number of Intervals = 81

Page | 605

Fitting the Exponential Distribution:

Figure H2: Histogram of the time between failures for the palletizer\de-palletizer.

Arena Input Analyzer Output: Distribution: Exponential Expression: -0.5 + EXPO(12.2) Square Error: 0.048098 Chi Square Test Number of intervals =7 Degrees of freedom =5 Test Statistic = 20.4 Corresponding p-value < 0.005 Data Summary Number of Data Points = 40 Min Data Value =0 Max Data Value = 80 Sample Mean = 11.7 Sample Std Dev = 20 Histogram Summary Histogram Range = -0.5 to 80.5 Number of Intervals = 81 Fail to reject the null hypothesis.

Page | 606

Process Line The Best Fit:

Figure H3: Histogram of the time between failures for the process line.

Arena Input Analyzer Output: Distribution Summary Distribution: Lognormal Expression: -0.5 + LOGN(8.23, 15.1) Square Error: 0.021259 Chi Square Test Number of intervals =7 Degrees of freedom =4 Test Statistic = 7.42 Corresponding p-value = 0.122 Data Summary Number of Data Points = 61 Min Data Value =0 Max Data Value = 89 Sample Mean = 7.87 Sample Std Dev = 14.2 Histogram Summary Histogram Range = -0.5 to 89.5 Number of Intervals = 90

Page | 607

Fitting the Exponential Distribution

Figure H4: Histogram of the time between failures for the process line.

Arena Input Analyzer Output: Distribution Summary Distribution: Exponential Expression: -0.5 + EXPO(8.37) Square Error: 0.029554 Chi Square Test Number of intervals =7 Degrees of freedom =5 Test Statistic = 9.49 Corresponding p-value = 0.093 Data Summary Number of Data Points = 61 Min Data Value =0 Max Data Value = 89 Sample Mean = 7.87 Sample Std Dev = 14.2 Histogram Summary Histogram Range = -0.5 to 89.5 Number of Intervals = 90 Fail to reject the null hypothesis.

Page | 608

Crate Loader The Best Fit:

Figure H5: Histogram of the time between failures for the crate loader.

Arena Input Analyzer Output: Distribution Summary Distribution: Weibull Expression: 0.999 + WEIB(7.39, 0.348) Square Error: 0.007064 Chi Square Test Number of intervals =1 Degrees of freedom = -2 Test Statistic = 0.151 Corresponding p-value < 0.005 Kolmogorov-Smirnov Test Test Statistic = 0.287 Corresponding p-value = 0.0437 Data Summary Number of Data Points = 22 Min Data Value =1 Max Data Value = 108 Sample Mean = 19.8 Sample Std Dev = 29.6 Histogram Summary Histogram Range = 0.999 to 108 Number of Intervals = 5

Page | 609

Fitting the Exponential Distribution:

Figure H6: Histogram of the time between failures for the crate loader.

Arena Input Analyzer Output: Distribution Summary Distribution: Exponential Expression: 0.999 + EXPO(18.8) Square Error: 0.035631 Chi Square Test Number of intervals =2 Degrees of freedom =0 Test Statistic = 3.78 Corresponding p-value < 0.005 Kolmogorov-Smirnov Test Test Statistic = 0.269 Corresponding p-value = 0.0718 Data Summary Number of Data Points = 22 Min Data Value =1 Max Data Value = 108 Sample Mean = 19.8 Sample Std Dev = 29.6 Histogram Summary Histogram Range = 0.999 to 108 Number of Intervals = 5 Fail to reject the null hypothesis

Page | 610

Retorts The Best Fit:

Figure H7: Histogram of the time between failures for the retorts.

Arena Input Analyzer Output: Distribution Summary Distribution: Exponential Expression: -0.5 + EXPO(18.8) Square Error: 0.035631 Chi Square Test Number of intervals =2 Degrees of freedom =0 Test Statistic = 3.78 Corresponding p-value < 0.005 Data Summary Number of Data Points = 42 Min Data Value =0 Max Data Value = 99 Sample Mean = 12.6 Sample Std Dev = 19.6 Histogram Summary Histogram Range = -0.5 to 99.5 Number of Intervals = 100 Fail to reject the null hypothesis

Page | 611

Labeler The Best Fit:

Figure H8: Histogram of the time between failures for the labeler.

Arena Input Analyzer Output: Distribution Summary Distribution: Lognormal Expression: -0.5 + LOGN(5.06, 7.91) Square Error: 0.144637 Chi Square Test Number of intervals =7 Degrees of freedom =4 Test Statistic = 44.6 Corresponding p-value < 0.005 Data Summary Number of Data Points = 55 Min Data Value =0 Max Data Value = 75 Sample Mean = 7.05 Sample Std Dev = 17.4 Histogram Summary Histogram Range = -0.5 to 75.5 Number of Intervals = 76

Page | 612

Fitting the Exponential Distribution:

Figure H9: Histogram of the time between failures for the labeler.

Arena Input Analyzer Output: Distribution Summary Distribution: Exponential Expression: -0.5 + EXPO(7.55) Square Error: 0.214247 Chi Square Test Number of intervals =8 Degrees of freedom =6 Test Statistic = 120 Corresponding p-value < 0.005 Data Summary Number of Data Points = 55 Min Data Value =0 Max Data Value = 75 Sample Mean = 7.05 Sample Std Dev = 17.4 Histogram Summary Histogram Range = -0.5 to 75.5 Number of Intervals = 76 Fail to reject the null hypothesis

Page | 613

Shrink Wrapper The Best Fit:

Figure H10: Histogram of the time between failures for the shrink wrapper.

Arena Input Analyzer Output: Distribution Summary Distribution: Weibull Expression: 0.999 + WEIB(6.24, 0.448) Square Error: 0.004172 Chi Square Test Number of intervals =1 Degrees of freedom = -2 Test Statistic = 0.0417 Corresponding p-value < 0.005 Kolmogorov-Smirnov Test Test Statistic = 0.209 Corresponding p-value = 0.091 Data Summary Number of Data Points = 34 Min Data Value =1 Max Data Value = 114 Sample Mean = 14.5 Sample Std Dev = 25.8 Histogram Summary Histogram Range = 0.999 to 114 Number of Intervals = 5

Page | 614

Fitting the Exponential Distribution:

Figure H11: Histogram of the time between failures for the shrink wrapper.

Arena Input Analyzer Output: Distribution Summary Distribution: Exponential Expression: 0.999 + EXPO(13.5) Square Error: 0.019049 Chi Square Test Number of intervals =2 Degrees of freedom =0 Test Statistic = 3.73 Corresponding p-value < 0.005 Kolmogorov-Smirnov Test Test Statistic = 0.301 Corresponding p-value < 0.01 Data Summary Number of Data Points = 34 Min Data Value =1 Max Data Value = 114 Sample Mean = 14.5 Sample Std Dev = 25.8 Histogram Summary Histogram Range = 0.999 to 114 Number of Intervals = 5 Fail to reject the null hypothesis

Page | 615

Fillers and Seamer The Best Fit:

Figure H12: Histogram of the time between failures for the fillers and seamer.

Arena Input Analyzer Output: Distribution Summary Distribution: Lognormal Expression: -0.5 + LOGN(5.69, 8.04) Square Error: 0.014423 Chi Square Test Number of intervals =7 Degrees of freedom =4 Test Statistic = 9.31 Corresponding p-value = 0.0551 Data Summary Number of Data Points = 101 Min Data Value =0 Max Data Value = 46 Sample Mean = 5.5 Sample Std Dev = 8.49 Histogram Summary Histogram Range = -0.5 to 46.5 Number of Intervals = 47

Page | 616

Fitting the Exponential Distribution:

Figure H13: Histogram of the time between failures for the fillers and seamers.

Arena Input Analyzer Output: Distribution Summary Distribution: Exponential Expression: -0.5 + EXPO(6) Square Error: 0.032386 Chi Square Test Number of intervals =7 Degrees of freedom =5 Test Statistic = 32.7 Corresponding p-value < 0.005 Data Summary Number of Data Points = 101 Min Data Value =0 Max Data Value = 46 Sample Mean = 5.5 Sample Std Dev = 8.49 Histogram Summary Histogram Range = -0.5 to 46.5 Number of Intervals = 47 Fail to reject the null hypothesis

Page | 617

Crate Un-loader The Best Fit:

Figure H14: Histogram of the time between failures for the crate un-loader.

Arena Input Analyzer Output: Distribution: Lognormal Expression: 1.5 + LOGN(26.5, 48.7) Square Error: 0.041113 Chi Square Test Number of intervals =3 Degrees of freedom =0 Test Statistic = 3.61 Corresponding p-value < 0.005 Data Summary Number of Data Points = 20 Min Data Value =2 Max Data Value = 94 Sample Mean = 24.7 Sample Std Dev = 25.4 Histogram Summary Histogram Range = 1.5 to 94.5 Number of Intervals = 93

Page | 618

Fitting the Exponential Distribution:

Figure H15: Histogram of the time between failures for the crate un-loader.

Arena Input Analyzer Output: Distribution Summary Distribution: Exponential Expression: 1.5 + EXPO(23.2) Square Error: 0.041532 Chi Square Test Number of intervals =3 Degrees of freedom =1 Test Statistic = 2.78 Corresponding p-value = 0.0969 Data Summary Number of Data Points = 20 Min Data Value =2 Max Data Value = 94 Sample Mean = 24.7 Sample Std Dev = 25.4 Histogram Summary Histogram Range = 1.5 to 94.5 Number of Intervals = 93 Fail to reject the null hypothesis

Page | 619

Can Plant The Best Fit:

Figure H16: Histogram of the time between failures for the can plant.

Arena Input Analyzer Output: Distribution Summary Distribution: Lognormal Expression: -0.5 + LOGN(4.28, 7.15) Square Error: 0.025681 Chi Square Test Number of intervals =7 Degrees of freedom =4 Test Statistic = 17.6 Corresponding p-value < 0.005 Data Summary Number of Data Points = 116 Min Data Value =0 Max Data Value = 77 Sample Mean = 4.66 Sample Std Dev = 10.6 Histogram Summary Histogram Range = -0.5 to 77.5 Number of Intervals = 78 Exponential:

Page | 620

Fitting the Exponential Distribution

Figure H17: Histogram of the time between failures for the can plant.

Arena Input Analyzer Output: Distribution Summary Distribution: Exponential Expression: -0.5 + EXPO(5.16) Square Error: 0.057509 Chi Square Test Number of intervals Degrees of freedom Test Statistic = 59 Corresponding p-value

=8 =6 < 0.005

Data Summary Number of Data Points = 116 Min Data Value =0 Max Data Value = 77 Sample Mean = 4.66 Sample Std Dev = 10.6 Histogram Summary Histogram Range = -0.5 to 77.5 Number of Intervals = 78 Fail to reject the null hypothesis

Page | 621

Appendix (I): Determining Sample Size (By using Minitab)

Page | 622

Determining Sample Size of the Can Making Line Arena Mode Minitab was used to determine the best sample size (number of replication of the model). The standard deviation was assumed to be equal to the standard deviation of the sample of the real system and from the observations, it was assumed that the interval width is equal to 15,000 which is smaller than the standard deviation.

Minitab output: Power and Sample Size 2-Sample t Test Testing mean 1 = mean 2 (versus not =) Calculating power for mean 1 = mean 2 + 15000 Alpha = 0.05 Sigma = 18289.5 Sample Target Actual Size Power Power 33 0.9000 0.9068

Page | 623

Determining Sample Size of the Can Filling Line Arena Mode Minitab was used to determine the best sample size (number of replication of the model). The standard deviation was assumed to be equal to the standard deviation of the sample of the real system and from the observations, it was assumed that the interval width is equal to 500 which is smaller than the standard deviation.

Minitab output: Power and Sample Size 2-Sample t Test Testing mean 1 = mean 2 (versus not =) Calculating power for mean 1 = mean 2 + 500 Alpha = 0.05 Sigma = 599.1 Sample Target Actual Size Power Power 32 0.9000 0.9076

Page | 624

Appendix (J): Summary of Arena Model (Can Making Line) – Daily Production Counter and Scrap Cans Counter

Page | 625 Table J1: Summary of Daily Production counter and Scrap Cans counter in the Can Making Arena Model.

Replication No. 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 26 27 28 29 30 31 32 33 Average SD

Daily Production (Cans) 72688 36342 36347 72691 72696 72697 36340 72691 72678 72673 72681 72691 72688 72683 72681 36342 72702 72707 36344 72687 72692 72697 36359 72685 72703 72684 36344 72673 36346 72695 72696 72689 72710 63879.45 15817.06

Scrap Cans (Cans) 112 58 53 109 104 103 60 109 122 127 119 109 112 117 119 58 98 93 56 113 108 103 50 115 97 116 56 127 54 105 104 111 90 96.57576 24.99629

Page | 626 Table J2: Summary of production counter of the Can Filling Line Arena Model of the as-is model, alternative 1, alternative 2, and alternative 3 (Replication length is 26 days).

Replication As-is Alt 1 Alt 2 Alt 3 No. 1 1889944 1889944 1889944 1889944 2 1889973 1889973 1889973 1889973 3 1889959 1889959 1889959 1889959 4 1889892 1889892 1889892 1889892 5 1889964 1889964 1889964 1889964 6 1890021 1890021 1890021 1890021 7 1889973 1889973 1889973 1889973 8 1889937 1889937 1889937 1889937 9 1889971 1889971 1889971 1889971 10 1889895 1889895 1889895 1889895 11 1890017 1890017 1890017 1890017 12 1890038 1890038 1890038 1890038 13 1889988 1889988 1889988 1889988 14 1889919 1889919 1889919 1889919 15 1890017 1890017 1890017 1890017 16 1889945 1889945 1889945 1889945 17 1890010 1890010 1890010 1890010 18 1890006 1890006 1890006 1890006 19 1889924 1889924 1889924 1889924 20 1890060 1890060 1890060 1890060 21 1889854 1889854 1889854 1889854 22 1889859 1889859 1889859 1889859 23 1889971 1889971 1889971 1889971 24 1889893 1889893 1889893 1889893 25 1890008 1890008 1890008 1890008 26 1890015 1890015 1890015 1890015 27 1889954 1889954 1889954 1889954 28 1889973 1889973 1889973 1889973 29 1890064 1890064 1890064 1890064 30 1889977 1889977 1889977 1889977 31 1889996 1889996 1889996 1889996 32 1889896 1889896 1889896 1889896 33 1890014 1890014 1890014 1890014 Avg. 1889967 1889967 1889967 1889967 SD 54.24489 54.24489 54.24489 54.24489

Page | 627 Table J3: Summary of daily production counter of the Can Filling Line Arena Model of the as-is model, alternative 1, alternative 2, and alternative 3.

Replication No. 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 26 27 28 29 30 31 32 33 Avg. SD

As-is

Alt 1

Alt 2

Alt 3

72690.15 72691.27 72690.73 72688.15 72690.92 72693.12 72691.27 72689.88 72691.19 72688.27 72692.96 72693.77 72691.85 72689.19 72692.96 72690.19 72692.69 72692.54 72689.38 72694.62 72686.69 72686.88 72691.19 72688.19 72692.62 72692.88 72690.54 72691.27 72694.77 72691.42 72692.15 72688.31 72692.85 72691.06 2.086342

72690.15 72691.27 72690.73 72688.15 72690.92 72693.12 72691.27 72689.88 72691.19 72688.27 72692.96 72693.77 72691.85 72689.19 72692.96 72690.19 72692.69 72692.54 72689.38 72694.62 72686.69 72686.88 72691.19 72688.19 72692.62 72692.88 72690.54 72691.27 72694.77 72691.42 72692.15 72688.31 72692.85 72691.06 2.086342

72690.15 72691.27 72690.73 72688.15 72690.92 72693.12 72691.27 72689.88 72691.19 72688.27 72692.96 72693.77 72691.85 72689.19 72692.96 72690.19 72692.69 72692.54 72689.38 72694.62 72686.69 72686.88 72691.19 72688.19 72692.62 72692.88 72690.54 72691.27 72694.77 72691.42 72692.15 72688.31 72692.85 72691.06 2.086342

72690.15 72691.27 72690.73 72688.15 72690.92 72693.12 72691.27 72689.88 72691.19 72688.27 72692.96 72693.77 72691.85 72689.19 72692.96 72690.19 72692.69 72692.54 72689.38 72694.62 72686.69 72686.88 72691.19 72688.19 72692.62 72692.88 72690.54 72691.27 72694.77 72691.42 72692.15 72688.31 72692.85 72691.06 2.086342

Page | 628

Appendix (K): Summary of Arena Model (Can Filling Line) – Daily Production Counter

Page | 629 Table K1: Summary of daily production counter of the Can Filling Line Arena Model of the as-is model, alternative 1, alternative 2, and alternative 3.

Replication No. 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 26 27 28 29 30 31 32 Average SD

As-Is 2114 2458 2401 2287 2436 2400 2381 2201 2410 2436 2465 2382 2287 2401 2213 2446 2436 2436 2457 2218 2435 2400 2341 2251 2471 2436 2442 2196 2437 2255 2437 2294 2364.375 99.18433

Daily Production Alt 1 Alt 2 Alt 3 2399 2399 2399 2458 2458 2458 2401 2401 2622 2437 2437 2437 2436 2436 2436 2400 2400 2400 2481 2481 2398 2201 2201 2416 2410 2410 2410 2436 2436 2436 2465 2465 2465 2382 2382 2382 2436 2436 2436 2401 2401 2401 2523 2523 2523 2465 2465 2465 2436 2436 2436 2436 2436 2436 2457 2457 2457 2206 2506 2506 2435 2435 2435 2400 2400 2400 2507 2507 2507 2401 2401 2401 2471 2471 2471 2436 2436 2436 2442 2442 2442 2176 2434 2434 2437 2437 2437 2224 2273 2323 2437 2437 2437 2278 2402 2402 2403.438 2426.281 2438.875 88.25145 60.79221 51.27079

Page | 630

Appendix (L): Category Overview Report of the Arena Model (Can Production Line)

Page | 631

L.1 As-Is Model (Replication length = one day)1

1

The same report was obtained for the different alternatives

Page | 632

Page | 633

Page | 634

Page | 635

Page | 636

Page | 637

L.2 As-Is Model (Replication length = one month)1

1

The same report was obtained for the different alternatives

Page | 638

Page | 639

Page | 640

Page | 641

Page | 642

Page | 643

Appendix (M): Category Overview Report of the Arena Model (Can Filling Line)

Page | 644

M.1 As-Is Model

Page | 645

Page | 646

Page | 647

Page | 648

Page | 649

Page | 650

M.2 Alternative 1 Model

Page | 651

Page | 652

Page | 653

Page | 654

Page | 655

Page | 656

M.3 Alternative 2 Model

Page | 657

Page | 658

Page | 659

Page | 660

Page | 661

Page | 662

M.4 Alternative 3 Model

Page | 663

Page | 664

Page | 665

Page | 666

Page | 667

Page | 668

Appendix (N): Demand Forecasting

Page | 669

1. Baked Beans

Table N1: Forecasted demand for the next five years for baked beans.

Time

Dt*

CQt*

Ft*

7 8 9 10

10131 10204 10274 10344

1.017 1.223 1.533 0.996

10148 10217 10289 10357

St* 10062 10132.296 10205.087 10275.107 10345.266

Gt* 86.511 84.912 83.700 82.332 81.115

Dt

Ft

10299 12480 15751 10299

10317 12496 15774 10312

















30

12074

0.951

12083

12075.019

86.361

11486

11495

31 32 33 34 35 36 37 38 39 40 41 42

12157 12244 12328 12413 12498 12586

1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951

12161 12243 12330 12414 12499 12584 12671 12757 12843 12929 13015 13100

12157.100 12244.343 12328.515 12412.866 12498.276 12585.363

85.933 86.064 85.875 85.722 85.691 85.831

12359 14976 18901 12359 11050 10468

12363 14974 18905 12360 11050 10467 12255 11916 11079 11994 11357 12463

1.017 1.223 1.533

13186 13272 13358

43 44 45





17220 17306 17392 17478 17564 17649 17735





0.951 1.017 1.223 1.533 0.996 0.884 0.832







 90 91 92 93 94 95 96

13405 16232 20480

16382 17594 21271 26796 17487 15604 14752

Page | 670

2. Black Eye Beans

Table N2: Forecasted demand for the next five years for black eye beans.

Time

Dt*

CQt*

Ft*

7 8 9 10

1437 1447 1457 1467

1.017 1.223 1.533 0.996

1439 1449 1459 1469

Dt

Ft

1461 1770 2234 1461

1463 1772 2237 1463











1713 1724 1737 1749 1761 1773 1785

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

1714 1725 1736 1749 1761 1773 1785 1797 1809 1822 1834 1846 1858 1870 1882 1895

1712.645 1724.287 1736.661 1748.599 1760.563 1772.677 1785.029

12.249 12.188 12.207 12.180 12.158 12.154 12.174

1629 1753 2124 2681 1753 1567 1485

1630 1754 2124 2681 1753 1567 1485 1738 1690 1571 1701 1611 1768 1901 2302 2905

















 90 91 92 93 94 95 96

Gt* 12.270 12.043 11.871 11.677 11.505



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 1427 1437.101 1447.426 1457.357 1467.308

0.951 1.017 1.223 1.533 0.996 0.884 0.832

2442 2455 2467 2479 2491 2503 2515

2323 2495 3017 3801 2480 2213 2092

Page | 671

3. Broad Beans

Table N3: Forecasted demand for the next five years for broad beans.

Time

Dt*

CQt*

Ft*

7 8 9 10

14370 14474 14573 14673

1.017 1.223 1.533 0.996

14396 14493 14595 14692

Ft

14609 17703 22343 14609

14635 17726 22377 14628







17140 17251 17367 17491 17610 17730 17851 17974 18096 18218 18340 18461 18583 18705 18827 18948

17128.742 17245.175 17368.933 17488.333 17607.987 17729.143 17852.678

122.506 121.898 122.084 121.816 121.600 121.555 121.753

16294 17531 21244 26812 17531 15675 14850

16306 17538 21241 26817 17533 15675 14848 17384 16903 15716 17014 16111 17678 19016 23026 29051







0.951 1.017 1.223 1.533 0.996 0.884 0.832

24427 24549 24671 24793 24914 25036 25158





0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533







 90 91 92 93 94 95 96

Dt



 17127 17245 17369 17488 17608 17729 17853

Gt* 122.718 120.450 118.731 116.790 115.063



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 14273 14372.937 14476.193 14575.518 14675.041

23238 24957 30174 38011 24806 22135 20926

Page | 672

4. Chick Peas

Table N4: Forecasted demand for the next five years for chick peas.

Time

Dt*

CQt*

Ft*

7 8 9 10

19106 19244 19376 19508

1.017 1.223 1.533 0.996

19139 19269 19404 19534

Ft

19423 23537 29706 19423

19457 23568 29750 19449







22788 22936 23090 23255 23413 23572 23733 23898 24059 24221 24383 24545 24707 24869 25031 25193

22773.145 22927.947 23092.486 23251.232 23410.315 23571.396 23735.639

162.875 162.067 162.315 161.958 161.670 161.611 161.874

21663 23308 28244 35648 23308 20840 19743

21679 23317 28240 35654 23311 20841 19741 23113 22473 20895 22621 21419 23504 25282 30614 38624







0.951 1.017 1.223 1.533 0.996 0.884 0.832

32477 32639 32801 32962 33124 33286 33448





0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533







 90 91 92 93 94 95 96

Dt



 22771 22927 23093 23251 23410 23571 23736

Gt* 163.156 160.142 157.856 155.276 152.980



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 18976 19109.224 19246.507 19378.563 19510.880

30896 33181 40117 50537 32980 29429 27822

Page | 673

5. Chick Peas 10mm

Table N5: Forecasted demand for the next five years for chick peas 10mm.

Time

Dt*

CQt*

Ft*

7 8 9 10

2486 2504 2522 2539

1.017 1.223 1.533 0.996

2491 2508 2525 2542

Dt

Ft

2528 3063 3866 2528

2532 3067 3872 2531











2963 2984 3005 3026 3047 3068 3089

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

2966 2985 3005 3026 3047 3068 3089 3110 3131 3152 3173 3194 3215 3236 3257 3279

2963.668 2983.814 3005.227 3025.886 3046.588 3067.551 3088.926

21.196 21.091 21.123 21.077 21.040 21.032 21.066

2819 3033 3676 4639 3033 2712 2569

2821 3034 3675 4640 3034 2712 2569 3008 2925 2719 2944 2788 3059 3290 3984 5027

















 90 91 92 93 94 95 96

Gt* 21.233 20.841 20.543 20.207 19.909



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 2470 2486.850 2504.716 2521.901 2539.121

0.951 1.017 1.223 1.533 0.996 0.884 0.832

4226 4248 4269 4290 4311 4332 4353

4021 4318 5221 6577 4292 3830 3621

Page | 674

6. Chick Peas with Chili

Table N6: Forecasted demand for the next five years for chick peas with chili.

Time

Dt*

CQt*

Ft*

7 8 9 10

134 135 136 137

1.017 1.223 1.533 0.996

134 135 136 137

Dt

Ft

136 165 208 136

136 165 208 136











159 161 162 163 164 165 166

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

160 161 162 163 164 165 166 167 168 170 171 172 173 174 175 176

159.455 160.539 161.691 162.802 163.916 165.044 166.194

1.140 1.135 1.137 1.134 1.132 1.132 1.133

152 163 198 250 163 146 138

152 163 198 250 163 146 138 162 157 146 158 150 165 177 214 270

















 90 91 92 93 94 95 96

Gt* 1.142 1.121 1.105 1.087 1.071



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 133 133.801 134.762 135.686 136.613

0.951 1.017 1.223 1.533 0.996 0.884 0.832

227 229 230 231 232 233 234

216 232 281 354 231 206 195

Page | 675

7. Fava Beans

Table N7: Forecasted demand for the next five years for fava beans.

Time

Dt*

CQt*

Ft*

7 8 9 10

15342 15453 15559 15665

1.017 1.223 1.533 0.996

15369 15473 15582 15686

Ft

15597 18900 23854 15597

15624 18925 23890 15617







18299 18418 18541 18674 18801 18928 19058 19190 19320 19450 19580 19710 19840 19970 20100 20230

18286.982 18411.289 18543.415 18670.889 18798.633 18927.983 19059.871

130.789 130.141 130.340 130.053 129.822 129.775 129.986

17395 18716 22680 28625 18716 16735 15854

17408 18724 22677 28630 18719 16735 15852 18560 18046 16779 18164 17200 18874 20302 24583 31016







0.951 1.017 1.223 1.533 0.996 0.884 0.832

26079 26209 26339 26469 26599 26729 26859





0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533







 90 91 92 93 94 95 96

Dt



 18286 18411 18544 18671 18798 18928 19060

Gt* 131.016 128.595 126.759 124.687 122.844



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 15238 15344.830 15455.069 15561.111 15667.362

24809 26645 32214 40582 26483 23632 22341

Page | 676

8. Fava Beans with Chili

Table N8: Forecasted demand for the next five years for fava beans with chili.

Time

Dt*

CQt*

Ft*

7 8 9 10

194 196 197 198

1.017 1.223 1.533 0.996

195 196 197 199

Dt

Ft

198 239 302 198

198 240 303 198











232 233 235 237 238 240 242

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

232 233 235 237 238 240 241 243 245 246 248 250 251 253 255 256

231.708 233.283 234.957 236.572 238.191 239.830 241.501

1.657 1.649 1.651 1.648 1.645 1.644 1.647

220 237 287 363 237 212 201

221 237 287 363 237 212 201 235 229 213 230 218 239 257 311 393

















 90 91 92 93 94 95 96

Gt* 1.660 1.628 1.605 1.579 1.555



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 193 194.430 195.826 197.169 198.515

0.951 1.017 1.223 1.533 0.996 0.884 0.832

330 332 334 335 337 339 340

314 338 408 514 336 299 283

Page | 677

9. Egyptian Foul Medames

Table N9: Forecasted demand for the next five years for Egyptian foul medames.

Time

Dt*

CQt*

Ft*

7 8 9 10

1831 1844 1857 1869

1.017 1.223 1.533 0.996

1834 1846 1859 1872

Dt

Ft

1861 2255 2846 1861

1864 2258 2851 1864











2182 2197 2213 2228 2243 2259 2274

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

2183 2198 2212 2228 2243 2259 2274 2290 2305 2321 2336 2352 2367 2383 2398 2414

2182.040 2196.873 2212.638 2227.849 2243.091 2258.526 2274.263

15.606 15.529 15.552 15.518 15.491 15.485 15.510

2076 2233 2706 3416 2233 1997 1892

2077 2234 2706 3416 2234 1997 1891 2215 2153 2002 2167 2052 2252 2422 2933 3701

















 90 91 92 93 94 95 96

Gt* 15.633 15.344 15.125 14.878 14.658



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 1818 1830.977 1844.131 1856.784 1869.462

0.951 1.017 1.223 1.533 0.996 0.884 0.832

3112 3127 3143 3158 3174 3189 3205

2960 3179 3844 4842 3160 2820 2666

Page | 678

10. Saudi Foul Medames

Table N10: Forecasted demand for the next five years for Saudi foul medames.

Time

Dt*

CQt*

Ft*

7 8 9 10

109 110 111 111

1.017 1.223 1.533 0.996

109 110 111 112

Dt

Ft

596 722 912 596

111 135 170 111











130 131 132 133 134 135 136

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

130 131 132 133 134 135 136 136 137 138 139 140 141 142 143 144

130.055 130.939 131.879 132.786 133.694 134.614 135.552

0.930 0.926 0.927 0.925 0.923 0.923 0.924

665 715 867 1094 715 640 606

124 133 161 204 133 119 113 132 128 119 129 122 134 144 175 221

















 90 91 92 93 94 95 96

Gt* 0.932 0.915 0.902 0.887 0.874



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 108 109.131 109.915 110.669 111.425

0.951 1.017 1.223 1.533 0.996 0.884 0.832

185 186 187 188 189 190 191

176 189 229 289 188 168 159

Page | 679

11. Lebanese Foul Medames

Table N11: Forecasted demand for the next five years for Lebanese foul medames.

Time

Dt*

CQt*

Ft*

7 8 9 10

586 591 595 599

1.017 1.223 1.533 0.996

587 591 596 599

Dt

Ft

596 722 912 596

597 723 913 597











699 704 709 714 718 723 728

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

699 704 709 714 719 723 728 733 738 743 748 753 758 763 768 773

698.911 703.662 708.711 713.583 718.465 723.409 728.450

4.999 4.974 4.981 4.970 4.962 4.960 4.968

665 715 867 1094 715 640 606

665 716 867 1094 715 640 606 709 690 641 694 657 721 776 940 1185

















 90 91 92 93 94 95 96

Gt* 5.007 4.915 4.845 4.765 4.695



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 582 586.464 590.678 594.730 598.791

0.951 1.017 1.223 1.533 0.996 0.884 0.832

997 1002 1007 1012 1017 1022 1027

948 1018 1231 1551 1012 903 854

Page | 680

12. Green Peas Table N12: Forecasted demand for the next five years for green peas.

Time

Dt*

CQt*

Ft*

7 8 9 10

21114 21266 21412 21559

1.017 1.223 1.533 0.996

21151 21294 21444 21587

Ft

21465 26010 32828 21465

21502 26044 32877 21493







25183 25346 25517 25699 25874 26049 26227 26409 26588 26767 26946 27125 27303 27482 27661 27840

25166.463 25337.533 25519.365 25694.794 25870.595 26048.605 26230.109

179.992 179.100 179.373 178.978 178.661 178.596 178.886

23939 25758 31212 39394 25758 23030 21818

23957 25768 31208 39401 25761 23031 21815 25542 24834 23091 24998 23671 25974 27939 33831 42684







0.951 1.017 1.223 1.533 0.996 0.884 0.832

35890 36069 36248 36427 36606 36784 36963





0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533







 90 91 92 93 94 95 96

Dt



 25165 25337 25520 25694 25870 26049 26230

Gt* 180.303 176.972 174.446 171.594 169.057



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 20970 21117.487 21269.197 21415.131 21561.354

34143 36668 44333 55848 36446 32522 30746

Page | 681

13. Hummus Tahineh - Chick Peas 7mm

Table N13: Forecasted demand for the next five years for hummus tahineh – chick peas 7mm.

Time

Dt*

CQt*

Ft*

7 8 9 10

11395 11477 11556 11635

1.017 1.223 1.533 0.996

11415 11492 11573 11650

Ft

11584 14037 17717 11584

11605 14056 17743 11599







13591 13679 13771 13869 13964 14059 14155 14253 14349 14446 14542 14639 14735 14832 14928 15025

13582.067 13674.392 13772.524 13867.201 13962.079 14058.149 14156.105

97.140 96.658 96.806 96.593 96.421 96.386 96.543

12920 13901 16845 21260 13901 12429 11775

12929 13907 16843 21264 13903 12430 11774 13785 13403 12462 13491 12775 14018 15078 18258 23036







0.951 1.017 1.223 1.533 0.996 0.884 0.832

19369 19466 19563 19659 19756 19852 19949





0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533







 90 91 92 93 94 95 96

Dt



 13581 13674 13773 13867 13962 14058 14156

Gt* 97.308 95.510 94.146 92.608 91.238



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 11318 11396.878 11478.755 11557.514 11636.429

18426 19789 23926 30141 19670 17552 16593

Page | 682

14. Hummus Tahineh with Garlic Table N14: Forecasted demand for the next five years for hummus tahineh with garlic.

Time

Dt*

CQt*

Ft*

7 8 9 10

78 79 80 80

1.017 1.223 1.533 0.996

79 79 80 80

Dt

Ft

80 97 122 80

80 97 122 80











93 94 95 95 96 97 97

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

94 94 95 95 96 97 97 98 99 99 100 101 101 102 103 103

93.480 94.116 94.791 95.443 96.096 96.757 97.431

0.669 0.665 0.666 0.665 0.664 0.663 0.664

89 96 116 146 96 86 81

89 96 116 146 96 86 81 95 92 86 93 88 96 104 126 159

















 90 91 92 93 94 95 96

Gt* 0.670 0.657 0.648 0.637 0.628



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 78 78.441 79.004 79.546 80.089

0.951 1.017 1.223 1.533 0.996 0.884 0.832

133 134 135 135 136 137 137

127 136 165 207 135 121 114

Page | 683

15. Hotdog Sausage Table N15: Forecasted demand for the next five years for hotdog sausage.

Time

Dt*

CQt*

Ft*

7 8 9 10

68 68 69 69

1.017 1.223 1.533 0.996

68 69 69 69

Dt

Ft

69 84 106 69

69 84 106 69











81 82 82 83 83 84 84

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

81 82 82 83 83 84 84 85 86 86 87 87 88 88 89 90

81.023 81.574 82.159 82.724 83.290 83.863 84.447

0.579 0.577 0.577 0.576 0.575 0.575 0.576

77 83 100 127 83 74 70

77 83 100 127 83 74 70 82 80 74 80 76 84 90 109 137

















 90 91 92 93 94 95 96

Gt* 0.580 0.570 0.562 0.552 0.544



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 68 67.987 68.476 68.946 69.416

0.951 1.017 1.223 1.533 0.996 0.884 0.832

116 116 117 117 118 118 119

110 118 143 180 117 105 99

Page | 684

16. Frankfurter Sausage

Table N16: Forecasted demand for the next five years for frankfurter sausage.

Time

Dt*

CQt*

Ft*

7 8 9 10

112 113 113 114

1.017 1.223 1.533 0.996

112 113 114 114

Dt

Ft

114 138 174 114

114 138 174 114











133 134 135 136 137 138 139

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148

133.344 134.251 135.214 136.143 137.075 138.018 138.980

0.954 0.949 0.950 0.948 0.947 0.946 0.948

127 136 165 209 136 122 116

127 137 165 209 136 122 116 135 132 122 132 125 138 148 179 226

















 90 91 92 93 94 95 96

Gt* 0.955 0.938 0.924 0.909 0.896



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 111 111.891 112.695 113.468 114.243

0.951 1.017 1.223 1.533 0.996 0.884 0.832

190 191 192 193 194 195 196

181 194 235 296 193 172 163

Page | 685

17. Cocktail Sausage Table N17: Forecasted demand for the next five years for cocktail sausage.

Time

Dt*

CQt*

Ft*

7 8 9 10

307 309 312 314

1.017 1.223 1.533 0.996

308 310 312 314

Dt

Ft

312 379 478 312

313 379 478 313











366 369 371 374 376 379 382

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

366 369 371 374 377 379 382 384 387 390 392 395 397 400 403 405

366.248 368.737 371.384 373.937 376.495 379.086 381.727

2.619 2.606 2.610 2.605 2.600 2.599 2.603

348 375 454 573 375 335 318

349 375 454 573 375 335 317 372 361 336 364 344 378 407 492 621

















 90 91 92 93 94 95 96

Gt* 2.624 2.575 2.539 2.497 2.460



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 305 307.323 309.531 311.655 313.783

0.951 1.017 1.223 1.533 0.996 0.884 0.832

522 525 528 530 533 535 538

497 534 645 813 530 473 447

Page | 686

18. Lima Beans Table N18: Forecasted demand for the next five years for lima beans.

Time

Dt*

CQt*

Ft*

7 8 9 10

274 276 278 280

1.017 1.223 1.533 0.996

275 277 279 280

Dt

Ft

279 338 426 279

279 338 427 279











327 329 331 334 336 338 341

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

327 329 331 334 336 338 341 343 345 348 350 352 355 357 359 362

326.882 329.104 331.466 333.745 336.028 338.340 340.698

2.338 2.326 2.330 2.325 2.321 2.320 2.324

311 335 405 512 335 299 283

311 335 405 512 335 299 283 332 323 300 325 307 337 363 439 554

















 90 91 92 93 94 95 96

Gt* 2.342 2.299 2.266 2.229 2.196



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 272 274.291 276.262 278.157 280.056

0.951 1.017 1.223 1.533 0.996 0.884 0.832

466 468 471 473 475 478 480

443 476 576 725 473 422 399

Page | 687

19. Mixed Vegetables Table N19: Forecasted demand for the next five years for mixed vegetables.

Time

Dt*

CQt*

Ft*

7 8 9 10

1022 1029 1036 1043

1.017 1.223 1.533 0.996

1024 1030 1038 1045

Dt

Ft

1039 1259 1589 1039

1041 1260 1591 1040











1218 1226 1235 1243 1252 1261 1269

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

1219 1227 1235 1244 1252 1261 1269 1278 1287 1295 1304 1313 1321 1330 1339 1347

1217.837 1226.115 1234.914 1243.403 1251.910 1260.525 1269.308

8.710 8.667 8.680 8.661 8.646 8.642 8.657

1158 1246 1510 1906 1246 1114 1056

1159 1247 1510 1907 1247 1114 1056 1236 1202 1117 1210 1145 1257 1352 1637 2066

















 90 91 92 93 94 95 96

Gt* 8.725 8.564 8.442 8.304 8.181



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 1015 1021.902 1029.243 1036.305 1043.381

0.951 1.017 1.223 1.533 0.996 0.884 0.832

1737 1745 1754 1763 1771 1780 1789

1652 1774 2145 2703 1764 1574 1488

Page | 688

20. Mushroom Pieces and Stems Table N20: Forecasted demand for the next five years for mushroom pieces and stems.

Time

Dt*

CQt*

Ft*

7 8 9 10

530 534 537 541

1.017 1.223 1.533 0.996

531 534 538 542

Dt

Ft

539 653 824 539

540 654 825 539











632 636 641 645 649 654 658

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

632 636 640 645 649 654 658 663 667 672 676 681 685 690 694 699

631.641 635.934 640.498 644.901 649.313 653.781 658.337

4.518 4.495 4.502 4.492 4.484 4.482 4.490

601 646 783 989 646 578 548

601 647 783 989 647 578 548 641 623 580 627 594 652 701 849 1071

















 90 91 92 93 94 95 96

Gt* 4.525 4.442 4.378 4.307 4.243



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 526 530.017 533.825 537.488 541.158

0.951 1.017 1.223 1.533 0.996 0.884 0.832

901 905 910 914 919 923 928

857 920 1113 1402 915 816 772

Page | 689

21. Whole Mushrooms Table N21: Forecasted demand for the next five years for whole mushrooms.

Time

Dt*

CQt*

Ft*

7 8 9 10

682 687 691 696

1.017 1.223 1.533 0.996

683 688 692 697

Dt

Ft

693 840 1060 693

694 841 1062 694











813 818 824 830 835 841 847

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

813 819 824 830 836 841 847 853 859 864 870 876 882 888 893 899

812.722 818.246 824.118 829.783 835.461 841.209 847.071

5.813 5.784 5.793 5.780 5.770 5.768 5.777

773 832 1008 1272 832 744 705

774 832 1008 1272 832 744 705 825 802 746 807 764 839 902 1093 1378

















 90 91 92 93 94 95 96

Gt* 5.823 5.715 5.634 5.541 5.460



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 677 681.965 686.864 691.577 696.299

0.951 1.017 1.223 1.533 0.996 0.884 0.832

1159 1165 1171 1176 1182 1188 1194

1103 1184 1432 1804 1177 1050 993

Page | 690

22. Peas and Carrots Table N4: Forecasted demand for the next five years for peas and carrots.

Time

Dt*

CQt*

Ft*

7 8 9 10

149 150 151 152

1.017 1.223 1.533 0.996

149 150 151 152

Dt

Ft

151 183 231 151

152 184 232 151











177 179 180 181 182 184 185

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

178 179 180 181 182 184 185 186 187 189 190 191 192 194 195 196

177.394 178.599 179.881 181.118 182.357 183.612 184.891

1.269 1.262 1.264 1.262 1.259 1.259 1.261

169 182 220 278 182 162 154

169 182 220 278 182 162 154 180 175 163 176 167 183 197 238 301

















 90 91 92 93 94 95 96

Gt* 1.271 1.247 1.230 1.210 1.192



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 148 148.853 149.922 150.951 151.982

0.951 1.017 1.223 1.533 0.996 0.884 0.832

253 254 256 257 258 259 261

241 258 312 394 257 229 217

Page | 691

23. Peeled Fava Beans with Chili

Table N4: Forecasted demand for the next five years for peeled fava beans with chili.

Time

Dt*

CQt*

Ft*

7 8 9 10

670 675 680 685

1.017 1.223 1.533 0.996

672 676 681 685

Dt

Ft

682 826 1042 682

683 827 1044 682











799 804 810 816 821 827 833

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

800 805 810 816 822 827 833 839 844 850 856 861 867 873 878 884

799.068 804.500 810.273 815.843 821.425 827.077 832.840

5.715 5.687 5.695 5.683 5.673 5.671 5.680

760 818 991 1251 818 731 693

761 818 991 1251 818 731 693 811 789 733 794 752 825 887 1074 1355

















 90 91 92 93 94 95 96

Gt* 5.725 5.619 5.539 5.448 5.368



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 666 670.508 675.325 679.958 684.601

0.951 1.017 1.223 1.533 0.996 0.884 0.832

1140 1145 1151 1157 1162 1168 1174

1084 1164 1408 1773 1157 1033 976

Page | 692

24. Red Kidney Beans

Table N24: Forecasted demand for the next five years for red kidney beans.

Time

Dt*

CQt*

Ft*

7 8 9 10

2244 2260 2276 2291

1.017 1.223 1.533 0.996

2248 2263 2279 2294

Dt

Ft

2281 2764 3489 2281

2285 2768 3494 2284











2674 2693 2712 2731 2749 2768 2788

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

2676 2694 2712 2731 2750 2768 2787 2807 2826 2845 2864 2883 2902 2921 2940 2959

2674.656 2692.837 2712.162 2730.806 2749.490 2768.409 2787.699

19.129 19.034 19.063 19.022 18.988 18.981 19.012

2544 2737 3317 4187 2737 2448 2319

2546 2739 3317 4187 2738 2448 2319 2715 2639 2454 2657 2516 2760 2969 3596 4536

















 90 91 92 93 94 95 96

Gt* 19.162 18.808 18.540 18.237 17.967



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 2229 2244.337 2260.460 2275.970 2291.510

0.951 1.017 1.223 1.533 0.996 0.884 0.832

3814 3833 3852 3871 3890 3909 3928

3629 3897 4712 5935 3873 3456 3268

Page | 693

25. Red Kidney Beans with Chili

Table N25: Forecasted demand for the next five years for red kidney beans with chili.

Time

Dt*

CQt*

Ft*

7 8 9 10

63 63 64 64

1.0166166 1.2230602 1.5331733 0.9956439

63 63 64 64

Dt

Ft

64 77 98 64

64 77 98 64











75 75 76 76 77 77 78

0.9513114 1.0166166 1.2230602 1.5331733 0.9956439 0.8841296 0.831788 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

75 75 76 76 77 77 78 78 79 79 80 81 81 82 82 83

74.744 75.253 75.793 76.314 76.836 77.364 77.904

0.535 0.532 0.533 0.532 0.531 0.530 0.531

71 77 93 117 77 68 65

71 77 93 117 77 68 65 76 74 69 74 70 77 83 100 127

















 90 91 92 93 94 95 96

Gt* 0.536 0.526 0.518 0.510 0.502



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 62 62.719 63.170 63.603 64.037

0.951 1.017 1.223 1.533 0.996 0.884 0.832

107 107 108 108 109 109 110

101 109 132 166 108 97 91

Page | 694

26. SWEET CORN

Table N26: Forecasted demand for the next five years for sweet corn.

Time

Dt*

CQt*

Ft*

7 8 9 10

1833 1846 1858 1871

1.017 1.223 1.533 0.996

1836 1848 1861 1874

Dt

Ft

1863 2258 2849 1863

1866 2261 2854 1865











2184 2199 2215 2230 2245 2261 2277

0.951 1.017 1.223 1.533 0.996 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.951 1.017 1.223 1.533

2186 2200 2215 2231 2246 2261 2276 2292 2308 2323 2339 2354 2370 2385 2401 2416

2184.332 2199.181 2214.963 2230.189 2245.448 2260.898 2276.652

15.622 15.545 15.569 15.534 15.507 15.501 15.527

2078 2236 2709 3419 2236 1999 1894

2079 2237 2709 3420 2236 1999 1893 2217 2155 2004 2170 2054 2254 2425 2936 3705

















 90 91 92 93 94 95 96

Gt* 15.649 15.360 15.141 14.894 14.673



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 1820 1832.900 1846.068 1858.734 1871.426

0.951 1.017 1.223 1.533 0.996 0.884 0.832

3115 3131 3146 3162 3177 3193 3208

2963 3183 3848 4847 3163 2823 2669

Page | 695

27. WHITE BEANS

Table N27: Forecasted demand for the next five years for white beans.

Time

Dt*

CQt*

Ft*

7 8 9 10

376 378 381 384

1.017 1.223 1.533 0.995

376 379 381 384

Dt

Ft

382 463 584 382

382 463 585 382











448 451 454 457 460 463 467

0.952 1.017 1.223 1.533 0.995 0.884 0.832 0.967 0.934 0.863 0.928 0.873 0.952 1.017 1.223 1.533

450 453 455 459 462 465 468 471 475 479 483 487 491 495 499 503

447.787 450.812 454.120 457.280 460.404 463.524 466.660

4.834 4.653 4.519 4.383 4.257 4.143 4.043

426 458 555 701 458 410 388

428 460 557 703 460 411 389 455 443 413 448 425 467 503 610 771

















 90 91 92 93 94 95 96

Gt* 3.199 3.142 3.105 3.059 3.014



 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

St* 373 375.573 378.349 380.992 383.603

0.952 1.017 1.223 1.533 0.995 0.884 0.832

685 689 693 697 701 705 709

652 701 848 1069 698 623 590

Page | 696

Appendix (O): LINDO Output

Page | 697

Study 1 – Establishing a New Factory LP OPTIMUM FOUND AT STEP

20

OBJECTIVE VALUE = 13991.0000 FIX ALL VARS.(

4) WITH RC > 995.556

NEW INTEGER SOLUTION OF

13991.0000

AT BRANCH

0 PIVOT

BOUND ON OPTIMUM: 13991.00 ENUMERATION COMPLETE. BRANCHES=

0 PIVOTS=

LAST INTEGER SOLUTION IS THE BEST FOUND RE-INSTALLING BEST SOLUTION... OBJECTIVE FUNCTION VALUE 1)

13991.00

VARIABLE

VALUE

REDUCED COST

Y11

1.000000

0.000000

Y12

0.000000

1200.000000

Y13

0.000000

1500.000000

Y14

0.000000

1160.000000

Y15

0.000000

900.000000

Y16

0.000000

1200.000000

Y17

1.000000

450.000000

Y21

0.000000

0.000000

Y22

0.000000

1200.000000

Y23

0.000000

1500.000000

Y24

0.000000

1160.000000

Y25

0.000000

900.000000

Y26

0.000000

1200.000000

27

27

Page | 698 Y27

0.000000

450.000000

Y31

0.000000

5600.000000

Y32

1.000000

0.000000

Y33

1.000000

500.000000

Y34

1.000000

360.000000

Y35

1.000000

300.000000

Y36

1.000000

600.000000

Y37

0.000000

1050.000000

S2

0.000000

5323.000000

S3

1.000000

5323.000000

S1

1.000000

0.000000

ROW SLACK OR SURPLUS

DUAL PRICES

2)

0.000000

0.000000

3)

0.000000

0.000000

4)

0.000000

0.000000

5)

0.000000

0.000000

6)

0.000000

0.000000

7)

0.000000

0.000000

8)

0.000000

0.000000

9)

0.000000

0.000000

10)

0.000000

0.000000

11)

0.000000

0.000000

12)

0.000000

0.000000

13)

0.000000

0.000000

14)

0.000000

0.000000

Page | 699 15)

0.000000

0.000000

16)

1.000000

0.000000

17)

0.000000

0.000000

18)

0.000000

0.000000

19)

0.000000

0.000000

20)

0.000000

0.000000

21)

0.000000

0.000000

22)

1.000000

0.000000

23)

0.000000

-6458.000000

24)

0.000000

0.000000

25)

11.000000

0.000000

26)

0.000000

0.000000

27)

69.000000

0.000000

NO. ITERATIONS= BRANCHES=

27

0 DETERM.= 1.000E

0

Page | 700

Study 2 – Using New Trucks LP OPTIMUM FOUND AT STEP

77

OBJECTIVE VALUE = 13991.0000 FIX ALL VARS.( 12) WITH RC > 96.6667 NEW INTEGER SOLUTION OF

13991.0000

AT BRANCH

0 PIVOT

BOUND ON OPTIMUM: 13991.00 ENUMERATION COMPLETE. BRANCHES=

0 PIVOTS=

LAST INTEGER SOLUTION IS THE BEST FOUND RE-INSTALLING BEST SOLUTION... OBJECTIVE FUNCTION VALUE 1)

13991.00

VARIABLE

VALUE

REDUCED COST

Y11

1.000000

0.000000

Y12

0.000000

1200.000000

Y13

0.000000

1500.000000

Y14

0.000000

1160.000000

Y15

0.000000

900.000000

Y16

0.000000

1200.000000

Y17

1.000000

450.000000

Y21

0.000000

0.000000

Y22

0.000000

1200.000000

Y23

0.000000

1500.000000

Y24

0.000000

1160.000000

Y25

0.000000

900.000000

Y26

0.000000

1200.000000

90

90

Page | 701 Y27

0.000000

450.000000

Y31

0.000000

5600.000000

Y32

1.000000

0.000000

Y33

1.000000

500.000000

Y34

1.000000

360.000000

Y35

1.000000

300.000000

Y36

1.000000

600.000000

Y37

0.000000

1050.000000

S2

0.000000

5323.000000

S3

1.000000

5323.000000

T12

0.000000

900.000000

T13

0.000000

1125.000000

S1

1.000000

0.000000

ROW SLACK OR SURPLUS

DUAL PRICES

2)

0.000000

0.000000

3)

0.000000

0.000000

4)

0.000000

0.000000

5)

0.000000

0.000000

6)

0.000000

0.000000

7)

0.000000

0.000000

8)

0.000000

0.000000

9)

0.000000

0.000000

10)

0.000000

0.000000

11)

0.000000

0.000000

12)

0.000000

0.000000

Page | 702 13)

0.000000

0.000000

14)

0.000000

0.000000

15)

0.000000

0.000000

16)

1.000000

0.000000

17)

0.000000

0.000000

18)

0.000000

0.000000

19)

0.000000

0.000000

20)

0.000000

0.000000

21)

0.000000

0.000000

22)

1.000000

0.000000

23)

0.000000

-6458.000000

24)

0.000000

0.000000

25)

11.000000

0.000000

26)

0.000000

0.000000

27)

69.000000

0.000000

NO. ITERATIONS= BRANCHES=

90

0 DETERM.= 1.000E

0

Page | 703

Study 3 – Increasing the Capacity of the Existing Factory LP OPTIMUM FOUND AT STEP

22

OBJECTIVE VALUE = 12283.0000 FIX ALL VARS.( SET

2) WITH RC > 1021.13

S3 TO >=

1 AT

1, BND= -0.1399E+05 TWIN=-0.1277E+05

NEW INTEGER SOLUTION OF

13991.0000

AT BRANCH

114

1 PIVOT

114

BOUND ON OPTIMUM: 12768.00 FLIP

S3 TO <=

SET

T12 TO >=

0 AT 1 AT

1 WITH BND= -12768.000 2, BND= -0.1315E+05 TWIN=-0.1293E+05

NEW INTEGER SOLUTION OF

13153.0000

AT BRANCH

118

2 PIVOT

118

BOUND ON OPTIMUM: 12929.36 FLIP

T12 TO <=

0 AT

2 WITH BND= -12929.363

SET

Y13 TO <=

0 AT

3, BND= -0.1293E+05 TWIN=-0.1000E+31

118

SET

Y33 TO <=

0 AT

4, BND= -0.1293E+05 TWIN=-0.1000E+31

118

SET

Y37 TO <=

0 AT

5, BND= -0.1293E+05 TWIN=-0.1000E+31

118

SET

Q1 TO >=

1 AT

6, BND= -0.1345E+05 TWIN=-0.1000E+31

125

DELETE

Q1 AT LEVEL

6

DELETE

Y37 AT LEVEL

5

DELETE

Y33 AT LEVEL

4

DELETE

Y13 AT LEVEL

3

DELETE

T12 AT LEVEL

2

DELETE

S3 AT LEVEL

1

ENUMERATION COMPLETE. BRANCHES=

3 PIVOTS=

LAST INTEGER SOLUTION IS THE BEST FOUND RE-INSTALLING BEST SOLUTION...

125

Page | 704 OBJECTIVE FUNCTION VALUE 1)

13153.00

VARIABLE

VALUE

REDUCED COST

Y11

1.000000

0.000000

Y12

0.000000

1200.000000

Y13

0.000000

1500.000000

Y14

1.000000

1160.000000

Y15

1.000000

900.000000

Y16

1.000000

1200.000000

Y17

1.000000

450.000000

Y21

0.000000

0.000000

Y22

0.000000

1200.000000

Y23

0.000000

1500.000000

Y24

0.000000

1160.000000

Y25

0.000000

900.000000

Y26

0.000000

1200.000000

Y27

0.000000

450.000000

Y31

0.000000

5600.000000

Y32

0.000000

0.000000

Y33

0.000000

500.000000

Y34

0.000000

360.000000

Y35

0.000000

300.000000

Y36

0.000000

600.000000

Y37

0.000000

1050.000000

S2

0.000000

5323.000000

Page | 705 S3

0.000000

5323.000000

T12

1.000000

900.000000

T13

1.000000

1125.000000

Q1

1.000000

960.000000

S1

1.000000

0.000000

ROW SLACK OR SURPLUS

DUAL PRICES

2)

0.000000

0.000000

3)

0.000000

0.000000

4)

0.000000

0.000000

5)

0.000000

0.000000

6)

0.000000

0.000000

7)

0.000000

0.000000

8)

0.000000

0.000000

9)

0.000000

0.000000

10)

0.000000

0.000000

11)

0.000000

0.000000

12)

0.000000

0.000000

13)

0.000000

0.000000

14)

0.000000

0.000000

15)

0.000000

0.000000

16)

0.000000

0.000000

17)

0.000000

0.000000

18)

0.000000

0.000000

19)

0.000000

0.000000

20)

0.000000

0.000000

Page | 706 21)

0.000000

0.000000

22)

0.000000

0.000000

23)

0.000000

-6458.000000

24)

43.500000

0.000000

25)

0.000000

0.000000

26)

0.000000

0.000000

NO. ITERATIONS= BRANCHES=

125

3 DETERM.= 1.000E

0

Page | 707

Study 4 – Demand Increase LP OPTIMUM FOUND AT STEP

26

OBJECTIVE VALUE = 15181.0000 FIX ALL VARS.(

4) WITH RC > 960.000

NEW INTEGER SOLUTION OF

15181.0000

AT BRANCH

0 PIVOT

BOUND ON OPTIMUM: 15181.00 ENUMERATION COMPLETE. BRANCHES=

0 PIVOTS=

LAST INTEGER SOLUTION IS THE BEST FOUND RE-INSTALLING BEST SOLUTION... OBJECTIVE FUNCTION VALUE 1)

15181.00

VARIABLE

VALUE

REDUCED COST

Y11

1.000000

0.000000

Y12

0.000000

1600.000000

Y13

0.000000

2100.000000

Y14

0.000000

1450.000000

Y15

0.000000

1200.000000

Y16

0.000000

1600.000000

Y17

1.000000

1050.000000

Y21

0.000000

0.000000

Y22

0.000000

1600.000000

Y23

0.000000

2100.000000

Y24

0.000000

1450.000000

Y25

0.000000

1200.000000

Y26

0.000000

1600.000000

34

34

Page | 708 Y27

0.000000

1050.000000

Y31

0.000000

6600.000000

Y32

1.000000

0.000000

Y33

1.000000

700.000000

Y34

1.000000

450.000000

Y35

1.000000

400.000000

Y36

1.000000

800.000000

Y37

0.000000

2450.000000

S2

0.000000

5323.000000

S3

1.000000

5323.000000

T12

0.000000

1500.000000

T13

0.000000

2250.000000

Q1

0.000000

960.000000

S1

1.000000

0.000000

ROW SLACK OR SURPLUS

DUAL PRICES

2)

0.000000

0.000000

3)

0.000000

0.000000

4)

0.000000

0.000000

5)

0.000000

0.000000

6)

0.000000

0.000000

7)

0.000000

0.000000

8)

0.000000

0.000000

9)

0.000000

0.000000

10)

0.000000

0.000000

11)

0.000000

0.000000

Page | 709 12)

0.000000

0.000000

13)

0.000000

0.000000

14)

0.000000

0.000000

15)

0.000000

0.000000

16)

1.000000

0.000000

17)

0.000000

0.000000

18)

0.000000

0.000000

19)

0.000000

0.000000

20)

0.000000

0.000000

21)

0.000000

0.000000

22)

1.000000

0.000000

23)

0.000000

-6458.000000

24)

2.000000

0.000000

25)

0.000000

0.000000

26)

62.000000

0.000000

NO. ITERATIONS= BRANCHES=

34

0 DETERM.= 1.000E

0

Page | 710

Appendix (P): Safety and Human Factors Checklist

Page | 711

Page | 712

Page | 713

Page | 714

Page | 715

Page 716 of 297

Page | 717

Page | 718

Page | 719

Page | 720

Page 721 of 297

Page | 722

Page | 723

Page | 724

Page | 725

Appendix (Q): Pictures of Workers in Uncomfortable Postures

Page | 726 Picture

Finding #

2

4

6,7

19

Page | 727

20

21

23

Page | 728

29

Blocked emergency exits

Page | 729

33

34

42

Page | 730

Appendix (R): RULA Score Sheet

Page | 731

Page | 732

Page | 733

Page | 734

Appendix (S): NIOSH Lifting Equation

Appendix (D): NIOSH Lifting Equation

Page | 735

Page | 736

Page | 737

Page | 738

Page | 739

Page | 740

Appendix (T): SNOOK Push/Pull Tables

Page | 741

Using the Snook Push/Pull Tables The Hazard Analysis Tool generally called the "Snook Tables" was developed at Liberty Mutual Insurance Company and is described in Snook, S. H. and Ciriello, V. M., "The design of manual handling tasks: revised tables of maximum acceptable weights and forces", Ergonomics, 34,9,1991. These tables are based on controlled experiments using psychophysical evaluation, and can be used to find the percent of an industrial population capable of sustaining the efforts tabulated in lifting, lowering, pushing, pulling, and carrying. Accordingly, they are of more general use than the Revised NIOSH Lifting Equation because they apply to a broader variety of tasks, but less precise because they are based on psychophysical measures rather than biomechanical. This is less a disadvantage than a guide to use. While the NIOSH equation establishes a recommended weight limit for lifting, the Snook tables provide guidance as to the proportion of the population that should be able to do the tasks as a regular part of daily work. Both are intended to assist in control of low back pain. The guidelines below are intended to assist in use of the tables in analysis of hazards that might exist in jobs involving lifting, lowering, pushing, pulling and carrying. Lifting and lowering tables:  Select width of object (outward from body) in the tables closest to that encountered in the task  Select closest distance of lift  Select lifting zone (floor to knuckle, knuckle to shoulder, shoulder to arm reach)  Select gender of worker  Find closest weight in table corresponding to width, distance, zone, gender, and repetition  Find the corresponding percent of population who can perform this task without stress Push and pull tables:  Select height of application of force (floor to hands)  Select push or pull distance  Find closest force in table corresponding to height, distance, gender and repetition; note that both initial force and sustained force may be limiting  Find the corresponding percent of population who can perform this task without stress Carry tables:  Select height of grip (floor to hands)  Select carry distance  Find closest weight in table corresponding to height, distance, gender and repetition  Find the corresponding percent of population who can perform this task without stress

Page | 742

Application considerations:  When lifting, lowering or carrying boxes without handles, reduce weights by 15%  When lifting or lowering with extended reach in knee to shoulder zone, reduce weights by 50%  Tables apply to single tasks; when used with multiple tasks (combination of lifting, lowering, push/pull and/or carrying), the authors of the tables recommend use of the weight or force corresponding to the smallest population percent for the tasks combined. Some combined tasks may exceed recommended physiological limits for an eight hour shift.  Some weights may exceed recommended physiological limits during an 8 hour shift, as noted by italics in the tables.  For weights and forces between table entries, a conservative approach would use the higher weight or force.  It may be helpful to review the tables before starting the analysis

Page 743 of 297

Page | 744

Page | 745

Page | 746

Page | 747

Page | 748

Page | 749

Page | 750

Appendix (U): Discomfort Survey

Page | 751

Page | 752

Appendix (V): Breakeven Points for Each Product.

Page | 753 a) Baked Beans Breakeven Point

Table V1: Baked beans breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 50000 100000 150000 200000 250000 300000 350000 400000 450000 500000 550000 600000 650000 700000 750000 800000 850000 900000 950000 1000000 1050000 934878

KD/Year 43004.35 47454.35 51904.35 56354.35 60804.35 65254.35 69704.35 74154.35 78604.35 83054.35 87504.35 91954.35 96404.35 100854.3 105304.3 109754.3 114204.3 118654.3 123104.3 127554.3 132004.3 136454.3 126208.5

KD/Year 0 6750 13500 20250 27000 33750 40500 47250 54000 60750 67500 74250 81000 87750 94500 101250 108000 114750 121500 128250 135000 141750 126208.53

KD/Year -43004.35 -40704.35 -38404.35 -36104.35 -33804.35 -31504.35 -29204.35 -26904.35 -24604.35 -22304.35 -20004.35 -17704.35 -15404.35 -13104.35 -10804.35 -8504.348 -6204.348 -3904.348 -1604.348 695.652 2995.652 5295.652 0.04

Page | 754

Total Cost Total Revenue

Baked Beans 160000 140000 120000

80000 60000 40000 20000

Production Figure V1: Baked beans breakeven point.

0 10 00 00

90 00 00

80 00 00

70 00 00

60 00 00

50 00 00

40 00 00

30 00 00

20 00 00

10 00 00

0 0

KD

100000

Page | 755 b) Black Eye Beans Breakeven Point

Table V2: Black eye beans breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year

KD/Year

KD/Year

KD/Year

0

6099.468

0

-6099.468

10000

6989.468

1300

-5689.468

20000

7879.468

2600

-5279.468

30000

8769.468

3900

-4869.468

40000

9659.468

5200

-4459.468

50000

10549.468

6500

-4049.468

60000

11439.468

7800

-3639.468

70000

12329.468

9100

-3229.468

80000

13219.468

10400

-2819.468

90000

14109.468

11700

-2409.468

100000

14999.468

13000

-1999.468

110000

15889.468

14300

-1589.468

120000

16779.468

15600

-1179.468

130000

17669.468

16900

-769.468

140000

18559.468

18200

-359.468

150000

19449.468

19500

50.532

160000

20339.468

20800

460.532

170000

21229.468

22100

870.532

180000

22119.468

23400

1280.532

190000

23009.468

24700

1690.532

200000

23899.468

26000

2100.532

210000

24789.468

27300

2510.532

148768

19339.82

19339.84

0.02

Page | 756

Black Eye Beans

Total Cost Total Revenue

30000

25000

15000

10000

5000

Production Figure V2: Black eye beans breakeven point.

20 00 00

18 00 00

16 00 00

14 00 00

12 00 00

10 00 00

80 00 0

60 00 0

40 00 0

20 00 0

0

0

KD

20000

Page | 757 c) Broad Beans Breakeven Point

Table V3: Broad beans breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year

KD/Year

KD/Year

KD/Year

0

61002.836

0

-61002.836

100000

69602.836

12000

-57602.836

200000

78202.836

24000

-54202.836

300000

86802.836

36000

-50802.836

400000

95402.836

48000

-47402.836

500000

104002.836

60000

-44002.836

600000

112602.836

72000

-40602.836

700000

121202.836

84000

-37202.836

800000

129802.836

96000

-33802.836

900000

138402.836

108000

-30402.836

1000000

147002.836

120000

-27002.836

1100000

155602.836

132000

-23602.836

1200000

164202.836

144000

-20202.836

1300000

172802.836

156000

-16802.836

1400000

181402.836

168000

-13402.836

1500000

190002.836

180000

-10002.836

1600000

198602.836

192000

-6602.836

1700000

207202.836

204000

-3202.836

1800000

215802.836

216000

197.164

1900000

224402.836

228000

3597.164

2000000

233002.836

240000

6997.164

2100000

241602.836

252000

10397.164

1794202

215304.208

215304.24

0.032

Page | 758

Total Cost

Broad Beans

Total Revenue 300000

250000

150000

100000

50000

Figure V3: Broad beans breakeven point.

0 20 00 00

0

0 18 00 00

0

Production

16 00 00

14 00 00

0 12 00 00

0 10 00 00

80 00 00

60 00 00

40 00 00

20 00 00

0

0

KD

200000

Page | 759 d)

Chick Peas Breakeven Point

Table V4: Chick peas breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year

KD/Year

KD/Year

KD/Year

0

81104.997

0

-81104.997

150000

93104.997

18000

-75104.997

300000

105104.997

36000

-69104.997

450000

117104.997

54000

-63104.997

600000

129104.997

72000

-57104.997

750000

141104.997

90000

-51104.997

900000

153104.997

108000

-45104.997

1050000

165104.997

126000

-39104.997

1200000

177104.997

144000

-33104.997

1350000

189104.997

162000

-27104.997

1500000

201104.997

180000

-21104.997

1650000

213104.997

198000

-15104.997

1800000

225104.997

216000

-9104.997

1950000

237104.997

234000

-3104.997

2100000

249104.997

252000

2895.003

2250000

261104.997

270000

8895.003

2400000

273104.997

288000

14895.003

2550000

285104.997

306000

20895.003

2700000

297104.997

324000

26895.003

2850000

309104.997

342000

32895.003

3000000

321104.997

360000

38895.003

3150000

333104.997

378000

44895.003

2027625

243314.997

243315

0.003

Page | 760

Total Cost

Chick Peas

Total Revnue 400000 350000 300000

200000 150000 100000 50000

Figure V4: Chick peas breakeven point.

0

0 30 00 00

27 00 00

0

0

Production

24 00 00

0

0

0

21 00 00

18 00 00

15 00 00

12 00 00

90 00 00

60 00 00

30 00 00

0

0

KD

250000

Page | 761 e)

Chick Peas 10mm Breakeven Point

Table V5: Chick peas 10mm breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year

KD/Year

KD/Year

KD/Year

0

10554.896

0

-10554.896

50000

18104.896

8500

-9604.896

100000

25654.896

17000

-8654.896

150000

33204.896

25500

-7704.896

200000

40754.896

34000

-6754.896

250000

48304.896

42500

-5804.896

300000

55854.896

51000

-4854.896

350000

63404.896

59500

-3904.896

400000

70954.896

68000

-2954.896

450000

78504.896

76500

-2004.896

500000

86054.896

85000

-1054.896

550000

93604.896

93500

-104.896

600000

101154.896

102000

845.104

650000

108704.896

110500

1795.104

700000

116254.896

119000

2745.104

750000

123804.896

127500

3695.104

800000

131354.896

136000

4645.104

850000

138904.896

144500

5595.104

900000

146454.896

153000

6545.104

950000

154004.896

161500

7495.104

1000000

161554.896

170000

8445.104

1050000

169104.896

178500

9395.104

555521

94438.567

94438.57

0.003

Page | 762

Chick Peas 10mm

Total Cost Total Revnue

200000 180000 160000 140000

100000 80000 60000 40000 20000

Production Figure V5: Chick peas 10mm breakeven point

0 10 00 00

90 00 00

80 00 00

70 00 00

60 00 00

50 00 00

40 00 00

30 00 00

20 00 00

10 00 00

0

0

KD

120000

Page | 763 f)

Chick Peas with Chili Breakeven Point

Table V6: Chick peas with chili breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year

KD/Year

KD/Year

KD/Year

0

567.888

0

-567.888

1000

647.888

135

-512.888

2000

727.888

270

-457.888

3000

807.888

405

-402.888

4000

887.888

540

-347.888

5000

967.888

675

-292.888

6000

1047.888

810

-237.888

7000

1127.888

945

-182.888

8000

1207.888

1080

-127.888

9000

1287.888

1215

-72.888

10000

1367.888

1350

-17.888

11000

1447.888

1485

37.112

12000

1527.888

1620

92.112

13000

1607.888

1755

147.112

14000

1687.888

1890

202.112

15000

1767.888

2025

257.112

16000

1847.888

2160

312.112

17000

1927.888

2295

367.112

18000

2007.888

2430

422.112

19000

2087.888

2565

477.112

20000

2167.888

2700

532.112

21000

2247.888

2835

587.112

10326

1393.968

1394.01

0.042

Page | 764

Chick PeasWith with Chili Chick Peas Chilli

Total Cost Total Revnue

3000

2500

1500

1000

500

Production Figure V6: Chick peas with chili breakeven point.

0 20 00

0 18 00

0 16 00

0 14 00

0 12 00

0 10 00

80 00

60 00

40 00

20 00

0

0

KD

2000

Page | 765 g) Fava Beans Breakeven Point

Table V7: Fava beans breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year

KD/Year

KD/Year

KD/Year

0

65127.834

0

-65127.834

150000

76527.834

16500

-60027.834

300000

87927.834

33000

-54927.834

450000

99327.834

49500

-49827.834

600000

110727.834

66000

-44727.834

750000

122127.834

82500

-39627.834

900000

133527.834

99000

-34527.834

1050000

144927.834

115500

-29427.834

1200000

156327.834

132000

-24327.834

1350000

167727.834

148500

-19227.834

1500000

179127.834

165000

-14127.834

1650000

190527.834

181500

-9027.834

1800000

201927.834

198000

-3927.834

1950000

213327.834

214500

1172.166

2100000

224727.834

231000

6272.166

2250000

236127.834

247500

11372.166

2400000

247527.834

264000

16472.166

2550000

258927.834

280500

21572.166

2700000

270327.834

297000

26672.166

2850000

281727.834

313500

31772.166

3000000

293127.834

330000

36872.166

3150000

304527.834

346500

41972.166

1915525

210707.734

210707.75

0.016

Page | 766

Fava Beans

Total Cost Total Revenue

400000 350000 300000

200000 150000 100000 50000

Production

Figure V7: Fava beans breakeven point.

00 0 30 00

00 0 27 00

00 0 24 00

00 0 21 00

00 0 18 00

00 0 15 00

00 0 12 00

00 90 00

00 60 00

30 00

00

0

0

KD

250000

Page | 767 h) Fava Beans with Chili Breakeven Point

Table V8: Fava beans with chili breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year

KD/Year

KD/Year

KD/Year

0

825.211

0

-825.211

150000

12975.211

18000

5024.789

300000

25125.211

36000

10874.789

450000

37275.211

54000

16724.789

600000

49425.211

72000

22574.789

750000

61575.211

90000

28424.789

900000

73725.211

108000

34274.789

1050000

85875.211

126000

40124.789

1200000

98025.211

144000

45974.789

1350000

110175.211

162000

51824.789

1500000

122325.211

180000

57674.789

1650000

134475.211

198000

63524.789

1800000

146625.211

216000

69374.789

1950000

158775.211

234000

75224.789

2100000

170925.211

252000

81074.789

2250000

183075.211

270000

86924.789

2400000

195225.211

288000

92774.789

2550000

207375.211

306000

98624.789

2700000

219525.211

324000

104474.79

2850000

231675.211

342000

110324.79

3000000

243825.211

360000

116174.79

3150000

255975.211

378000

122024.79

21160

2539.171

2539.2

0.029

Page | 768

Fava Beans Beans with with Chilli Fava Chili

Total Cost Total Revenue

400000 350000 300000

200000 150000 100000 50000

Production Figure V8: Fava beans with chili breakeven point.

30 00 00 0

27 00 00 0

24 00 00 0

21 00 00 0

18 00 00 0

15 00 00 0

12 00 00 0

90 00 00

60 00 00

30 00 00

0 0

KD

250000

Page | 769 i)

Green Peas Breakeven Point

Table V9: Green peas breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year

KD/Year

KD/Year

KD/Year

0

89,628.64

0.00

-89,628.64

500,000

123,628.64

42,500.00

-81,128.64

1,000,000

157,628.64

85,000.00

-72,628.64

1,500,000

191,628.64

127,500.00

-64,128.64

2,000,000

225,628.64

170,000.00

-55,628.64

2,500,000

259,628.64

212,500.00

-47,128.64

3,000,000

293,628.64

255,000.00

-38,628.64

3,500,000

327,628.64

297,500.00

-30,128.64

4,000,000

361,628.64

340,000.00

-21,628.64

4,500,000

395,628.64

382,500.00

-13,128.64

5,000,000

429,628.64

425,000.00

-4,628.63

5,500,000

463,628.64

467,500.00

3,871.37

6,000,000

497,628.64

510,000.00

12,371.36

6,500,000

531,628.64

552,500.00

20,871.36

7,000,000

565,628.64

595,000.00

29,371.36

7,500,000

599,628.64

637,500.00

37,871.36

8,000,000

633,628.64

680,000.00

46,371.36

8,500,000

667,628.64

722,500.00

54,871.36

9,000,000

701,628.64

765,000.00

63,371.36

9,500,000

735,628.64

807,500.00

71,871.37

10,000,000

769,628.64

850,000.00

80,371.37

10,500,000

803,628.64

892,500.00

88,871.37

5,272,273

448,143.20

448,143.21

0.01

Page | 770

Green Peas

Total Cost Total Revenue

1,000,000 900,000 800,000 700,000

500,000 400,000 300,000 200,000 100,000 0

0 1, 00 0, 00 0 2, 00 0, 00 0 3, 00 0, 00 0 4, 00 0, 00 0 5, 00 0, 00 0 6, 00 0, 00 0 7, 00 0, 00 0 8, 00 0, 00 0 9, 00 0, 00 0 10 ,0 00 ,0 00

KD

600,000

Production Figure V9: Green peas breakeven point.

Page | 771 j)

Hummus Tahineh - Chick Peas 7mm Breakeven Point

Table V10: Hummus tahineh - 7mm breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 900,000 1,000,000 1,100,000 1,200,000 1,300,000 1,400,000 1,500,000 1,600,000 1,700,000 1,800,000 1,900,000 2,000,000 2,100,000 1,179,795

KD/Year 48,371.60 55,271.60 62,171.60 69,071.60 75,971.60 82,871.60 89,771.60 96,671.60 103,571.60 110,471.60 117,371.60 124,271.60 131,171.60 138,071.60 144,971.60 151,871.60 158,771.60 165,671.60 172,571.60 179,471.60 186,371.60 193,271.60 129,777.47

KD/Year 0.00 11,000.00 22,000.00 33,000.00 44,000.00 55,000.00 66,000.00 77,000.00 88,000.00 99,000.00 110,000.00 121,000.00 132,000.00 143,000.00 154,000.00 165,000.00 176,000.00 187,000.00 198,000.00 209,000.00 220,000.00 231,000.00 129,777.47

KD/Year -48,371.60 -44,271.60 -40,171.60 -36,071.60 -31,971.60 -27,871.60 -23,771.60 -19,671.60 -15,571.60 -11,471.60 -7,371.60 -3,271.60 828.40 4,928.40 9,028.40 13,128.40 17,228.40 21,328.40 25,428.40 29,528.40 33,628.40 37,728.40 0.00

Page | 772

Hummus Tahineh - Chick Peas 7mm Hummus Taheina Chick Peas

Total Cost Total Revenue

250,000.00

200,000.00

KD

150,000.00

100,000.00

50,000.00

0 20 0, 00 0 40 0, 00 0 60 0, 00 0 80 0, 00 0 1, 00 0, 00 0 1, 20 0, 00 0 1, 40 0, 00 0 1, 60 0, 00 0 1, 80 0, 00 0 2, 00 0, 00 0

0.00

Production Figure V10: Hummus tahineh breakeven point.

Page | 773 k) Hummus Tahineh with Garlic Breakeven Point

Table V11: Hummus tahineh with garlic breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 500 1,000 1,500 2,000 2,500 3,000 3,500 4,000 4,500 5,000 5,500 6,000 6,500 7,000 7,500 8,000 8,500 9,000 9,500 10,000 10,500 6,528

KD/Year 332.92 367.42 401.92 436.42 470.92 505.42 539.92 574.42 608.92 643.42 677.92 712.42 746.92 781.42 815.92 850.42 884.92 919.42 953.92 988.42 1,022.92 1,057.42 783.34

KD/Year 0.00 60.00 120.00 180.00 240.00 300.00 360.00 420.00 480.00 540.00 600.00 660.00 720.00 780.00 840.00 900.00 960.00 1,020.00 1,080.00 1,140.00 1,200.00 1,260.00 783.34

KD/Year -332.92 -307.42 -281.92 -256.42 -230.92 -205.42 -179.92 -154.42 -128.92 -103.42 -77.92 -52.42 -26.92 -1.42 24.08 49.58 75.08 100.58 126.08 151.58 177.08 202.58 0.00

Page | 774

Hummus Tahineh with Garlic Hummos Tehina Garlic

Total Cost Total Revenue

1,400 1,200

800 600 400 200

Production Figure V11: Hummos tahineh with garlic breakeven point.

9, 00 0 10 ,0 00

8, 00 0

7, 00 0

6, 00 0

5, 00 0

4, 00 0

3, 00 0

2, 00 0

1, 00 0

0 0

KD

1,000

Page | 775 l)

Lima Beans Breakeven Point

Table V12: Lima beans breakeven point.

Annual Production Cans/Year 0 10000 20000 30000 40000 50000 60000 70000 80000 90000 100000 110000 120000 130000 140000 150000 160000 170000 180000 190000 200000 210000 61273

Total Cost KD/Year 1164.17 4274.17 7384.17 10494.17 13604.17 16714.17 19824.17 22934.17 26044.17 29154.17 32264.17 35374.17 38484.17 41594.17 44704.17 47814.17 50924.17 54034.17 57144.17 60254.17 63364.17 66474.17 20220.073

Total Revenue KD/Year 0 3300 6600 9900 13200 16500 19800 23100 26400 29700 33000 36300 39600 42900 46200 49500 52800 56100 59400 62700 66000 69300 20220.09

Total Profit KD/Year -1164.17 -974.17 -784.17 -594.17 -404.17 -214.17 -24.17 165.83 355.83 545.83 735.83 925.83 1115.83 1305.83 1495.83 1685.83 1875.83 2065.83 2255.83 2445.83 2635.83 2825.83 0.017

Page | 776

Lima Beans

Total Cost Total Revenue

250,000

200,000

KD

150,000

100,000

50,000

20 0, 00 0 40 0, 00 0 60 0, 00 0 80 0, 00 0 1, 00 0, 00 0 1, 20 0, 00 0 1, 40 0, 00 0 1, 60 0, 00 0 1, 80 0, 00 0 2, 00 0, 00 0

0

0

Production Figure V12: Lima beans breakeven point.

Page | 777 m) Mixed Vegetables Breakeven Point

Table V13: Mixed vegetables breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 200,000 220,000 240,000 260,000 280,000 300,000 320,000 340,000 360,000

KD/Year 4,337.24 7,397.24 10,457.24 13,517.24 16,577.24 19,637.24 22,697.24 25,757.24 28,817.24 31,877.24 34,937.24 37,997.24 41,057.24 44,117.24 47,177.24 50,237.24 53,297.24 56,357.24 59,417.24

KD/Year 0.00 3,700.00 7,400.00 11,100.00 14,800.00 18,500.00 22,200.00 25,900.00 29,600.00 33,300.00 37,000.00 40,700.00 44,400.00 48,100.00 51,800.00 55,500.00 59,200.00 62,900.00 66,600.00

KD/Year -4,337.24 -3,697.24 -3,057.24 -2,417.24 -1,777.24 -1,137.24 -497.24 142.76 782.76 1,422.76 2,062.76 2,702.76 3,342.76 3,982.76 4,622.76 5,262.76 5,902.76 6,542.76 7,182.76

380,000 400,000

62,477.24 65,537.24

70,300.00 74,000.00

7,822.76 8,462.76

420,000 135,539

68,597.24 25,074.68

77,700.00 25,074.68

9,102.76 0.00

Page | 778

Mixed Vegetables Mix Vegetables

Total Cost Total Revenue

90,000 80,000 70,000

50,000 40,000 30,000 20,000 10,000 12 0, 00 0 16 0, 00 0 20 0, 00 0 24 0, 00 0 28 0, 00 0 32 0, 00 0 36 0, 00 0 40 0, 00 0

80 ,0 00

40 ,0 00

0 0

KD

60,000

Production Figure V13: Mixed vegetables breakeven point.

Page | 779 n) Mushroom Pieces and Stems Breakeven Point

Table V14: Mushroom pieces and stems breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 5,000 10,000 15,000 20,000 25,000 30,000 35,000 40,000 45,000 50,000 55,000 60,000 65,000 70,000 75,000 80,000 85,000 90,000 95,000 100,000 105,000 49,990

KD/Year 2,249.54 3,524.54 4,799.54 6,074.54 7,349.54 8,624.54 9,899.54 11,174.54 12,449.54 13,724.54 14,999.54 16,274.54 17,549.54 18,824.54 20,099.54 21,374.54 22,649.54 23,924.54 25,199.54 26,474.54 27,749.54 29,024.54 14,996.93

KD/Year 0.00 1,500.00 3,000.00 4,500.00 6,000.00 7,500.00 9,000.00 10,500.00 12,000.00 13,500.00 15,000.00 16,500.00 18,000.00 19,500.00 21,000.00 22,500.00 24,000.00 25,500.00 27,000.00 28,500.00 30,000.00 31,500.00 14,996.93

KD/Year -2,249.54 -2,024.54 -1,799.54 -1,574.54 -1,349.54 -1,124.54 -899.54 -674.54 -449.54 -224.54 0.46 225.46 450.46 675.46 900.46 1,125.46 1,350.46 1,575.46 1,800.46 2,025.46 2,250.46 2,475.46 0.00

Page | 780

Mushroom Pieces and Stems

Total Cost

Mushroom Pcs with Stems

Total Revenue

35,000 30,000

20,000 15,000 10,000 5,000

Production Figure V14: Mushroom pieces and stems breakeven point.

0 0, 00

0

10

90

,0 0

0 80

,0 0

0 ,0 0

0 70

60

,0 0

0 50

,0 0

0 40

,0 0

0 30

,0 0

0 ,0 0 20

10

,0 0

0

0

0

KD

25,000

Page | 781 o) Whole Mushrooms Breakeven Point

Table V15: Whole mushrooms breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 5,000 10,000 15,000 20,000 25,000 30,000 35,000 40,000 45,000 50,000 55,000 60,000 65,000 70,000 75,000 80,000 85,000 90,000 95,000 100,000 105,000 55,663

KD/Year 2,894.46 4,134.46 5,374.46 6,614.46 7,854.46 9,094.46 10,334.46 11,574.46 12,814.46 14,054.46 15,294.46 16,534.46 17,774.46 19,014.46 20,254.46 21,494.46 22,734.46 23,974.46 25,214.46 26,454.46 27,694.46 28,934.46 16,698.78

KD/Year 0.00 1,500.00 3,000.00 4,500.00 6,000.00 7,500.00 9,000.00 10,500.00 12,000.00 13,500.00 15,000.00 16,500.00 18,000.00 19,500.00 21,000.00 22,500.00 24,000.00 25,500.00 27,000.00 28,500.00 30,000.00 31,500.00 16,698.78

KD/Year -2,894.46 -2,634.46 -2,374.46 -2,114.46 -1,854.46 -1,594.46 -1,334.46 -1,074.46 -814.46 -554.46 -294.46 -34.46 225.54 485.54 745.54 1,005.55 1,265.55 1,525.55 1,785.55 2,045.55 2,305.55 2,565.55 0.00

Page | 782

Total Cost

Whole Mushrooms

Mushroom Whole

Total Revenue

35,000 30,000

20,000 15,000 10,000 5,000

Production Figure V15: Whole mushrooms breakeven point.

0 0, 00

0

10

90

,0 0

0 ,0 0

0 80

70

,0 0

0 ,0 0

0 60

50

,0 0

0 40

,0 0

0 30

,0 0

0 ,0 0 20

10

,0 0

0

0

0

KD

25,000

Page | 783 p) Peas and Carrots Breakeven Point

Table V16: Peas and carrots breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 1,000 2,000 3,000 4,000 5,000 6,000 7,000 8,000 9,000 10,000 11,000 12,000 13,000 14,000 15,000 16,000 17,000 18,000 19,000 20,000 21,000 12,635

KD/Year 631.78 711.78 791.78 871.78 951.78 1,031.78 1,111.78 1,191.78 1,271.78 1,351.78 1,431.78 1,511.78 1,591.78 1,671.78 1,751.78 1,831.78 1,911.78 1,991.78 2,071.78 2,151.78 2,231.78 2,311.78 1,642.61

KD/Year 0.00 130.00 260.00 390.00 520.00 650.00 780.00 910.00 1,040.00 1,170.00 1,300.00 1,430.00 1,560.00 1,690.00 1,820.00 1,950.00 2,080.00 2,210.00 2,340.00 2,470.00 2,600.00 2,730.00 1,642.61

KD/Year -631.78 -581.78 -531.78 -481.78 -431.78 -381.78 -331.78 -281.78 -231.78 -181.78 -131.78 -81.78 -31.78 18.22 68.22 118.23 168.23 218.23 268.23 318.23 368.23 418.23 0.00

Page | 784

Total Cost

Peas and Carrots

Total Revenue

3,000 2,500

1,500 1,000 500

Production Figure V16: Peas and carrots breakeven point.

0 20

,0 0

0 18

,0 0

0 16

,0 0

0 14

,0 0

0 12

,0 0

0 ,0 0 10

0 8, 00

0 6, 00

0 4, 00

2, 00

0

0

0

KD

2,000

Page | 785 q) Peeled Fava Beans with Chili Breakeven Point

Table V17: Peeled fava beans with chili breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 90,000 100,000 110,000 120,000 130,000 140,000 150,000 160,000 170,000 180,000 190,000 200,000 210,000 129,356

KD/Year 2,845.82 4,325.82 5,805.82 7,285.82 8,765.82 10,245.82 11,725.82 13,205.82 14,685.82 16,165.82 17,645.82 19,125.82 20,605.82 22,085.82 23,565.82 25,045.82 26,525.82 28,005.82 29,485.82 30,965.82 32,445.82 33,925.82 21,990.44

KD/Year 0.00 1,700.00 3,400.00 5,100.00 6,800.00 8,500.00 10,200.00 11,900.00 13,600.00 15,300.00 17,000.00 18,700.00 20,400.00 22,100.00 23,800.00 25,500.00 27,200.00 28,900.00 30,600.00 32,300.00 34,000.00 35,700.00 21,990.44

KD/Year -2,845.82 -2,625.82 -2,405.82 -2,185.82 -1,965.82 -1,745.82 -1,525.82 -1,305.82 -1,085.82 -865.82 -645.82 -425.82 -205.82 14.18 234.18 454.18 674.18 894.18 1,114.18 1,334.18 1,554.18 1,774.18 0.00

Page | 786

Peeled Fava Beans with Chili

Peeled Foul with Chilli

Total Cost Total Revenue

40,000 35,000 30,000

20,000 15,000 10,000 5,000

10 0, 00 0 12 0, 00 0 14 0, 00 0 16 0, 00 0 18 0, 00 0 20 0, 00 0

80 ,0 00

60 ,0 00

40 ,0 00

20 ,0 00

0

0

KD

25,000

Production Figure V17: Peeled fava beans with chili breakeven point.

Page | 787 r) Red Kidney Beans Breakeven Point

Table V18: Red kidney beans breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 30,000 60,000 90,000 120,000 150,000 180,000 210,000 240,000 270,000 300,000 330,000 360,000 390,000 420,000 450,000 480,000 510,000 540,000 570,000 600,000 630,000 297,675

KD/Year 9,525.60 13,215.60 16,905.60 20,595.60 24,285.60 27,975.60 31,665.60 35,355.60 39,045.60 42,735.60 46,425.60 50,115.60 53,805.60 57,495.60 61,185.60 64,875.60 68,565.60 72,255.60 75,945.60 79,635.60 83,325.60 87,015.60 46,139.63

KD/Year 0.00 4,650.00 9,300.00 13,950.00 18,600.00 23,250.00 27,900.00 32,550.00 37,200.00 41,850.00 46,500.00 51,150.00 55,800.00 60,450.00 65,100.00 69,750.00 74,400.00 79,050.00 83,700.00 88,350.00 93,000.00 97,650.00 46,139.63

KD/Year -9,525.60 -8,565.60 -7,605.60 -6,645.60 -5,685.60 -4,725.60 -3,765.60 -2,805.60 -1,845.60 -885.60 74.40 1,034.40 1,994.40 2,954.40 3,914.40 4,874.40 5,834.40 6,794.40 7,754.40 8,714.40 9,674.40 10,634.40 0.00

Page | 788

Red Kidney Beans

Total Cost Total Revenue

120,000 100,000

‘

60,000 40,000 20,000

12 0, 00 0 18 0, 00 0 24 0, 00 0 30 0, 00 0 36 0, 00 0 42 0, 00 0 48 0, 00 0 54 0, 00 0 60 0, 00 0

60 ,0 00

0 0

KD

80,000

Production Figure V18: Red kidney beans breakeven point.

Page | 789 s)

Red Kidney Beans with Chili Breakeven Point

Table V19: Red kidney beans with chili breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 40,000 80,000 120,000 160,000 200,000 240,000 280,000 320,000 360,000 400,000 440,000 480,000 520,000 560,000 600,000 640,000 680,000 720,000 760,000 800,000 840,000 432,982

KD/Year 9,525.60 15,445.60 21,365.60 27,285.60 33,205.60 39,125.60 45,045.60 50,965.60 56,885.60 62,805.60 68,725.60 74,645.60 80,565.60 86,485.60 92,405.60 98,325.60 104,245.60 110,165.60 116,085.60 122,005.60 127,925.60 133,845.60 73,606.91

KD/Year 0.00 6,800.00 13,600.00 20,400.00 27,200.00 34,000.00 40,800.00 47,600.00 54,400.00 61,200.00 68,000.00 74,800.00 81,600.00 88,400.00 95,200.00 102,000.00 108,800.00 115,600.00 122,400.00 129,200.00 136,000.00 142,800.00 73,606.91

KD/Year -9,525.60 -8,645.60 -7,765.60 -6,885.60 -6,005.60 -5,125.60 -4,245.60 -3,365.60 -2,485.60 -1,605.60 -725.60 154.40 1,034.40 1,914.40 2,794.40 3,674.40 4,554.40 5,434.40 6,314.40 7,194.40 8,074.40 8,954.40 0.00

Page | 790

KidneyBeans Beans with ChiliChilli RedRed Kidney with

Total Cost Total Revenue

160,000 140,000 120,000

80,000 60,000 40,000 20,000

Production Figure V19: Red kidney beans with chili Breakeven Point.

840,000

800,000

760,000

720,000

680,000

640,000

600,000

560,000

520,000

480,000

440,000

400,000

360,000

320,000

280,000

240,000

200,000

160,000

120,000

80,000

40,000

0

0

KD

100,000

Page | 791 t)

Sweet Corn Breakeven Point

Table V20: Sweet corn breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 30,000 60,000 90,000 120,000 150,000 180,000 210,000 240,000 270,000 300,000 330,000 360,000 390,000 420,000 450,000 480,000 510,000 540,000 570,000 600,000 630,000 189,740

KD/Year 7,779.35 11,499.35 15,219.35 18,939.35 22,659.35 26,379.35 30,099.35 33,819.35 37,539.35 41,259.35 44,979.35 48,699.35 52,419.35 56,139.35 59,859.35 63,579.35 67,299.35 71,019.35 74,739.35 78,459.35 82,179.35 85,899.35 31,307.12

KD/Year 0.00 4,950.00 9,900.00 14,850.00 19,800.00 24,750.00 29,700.00 34,650.00 39,600.00 44,550.00 49,500.00 54,450.00 59,400.00 64,350.00 69,300.00 74,250.00 79,200.00 84,150.00 89,100.00 94,050.00 99,000.00 103,950.00 31,307.12

KD/Year -7,779.35 -6,549.35 -5,319.35 -4,089.35 -2,859.35 -1,629.35 -399.35 830.65 2,060.66 3,290.66 4,520.66 5,750.66 6,980.66 8,210.66 9,440.66 10,670.66 11,900.66 13,130.66 14,360.66 15,590.66 16,820.66 18,050.66 0.00

Page | 792

Sweet Corn

Total Cost Total Revenue

120,000 100,000

60,000 40,000 20,000

60 ,0 00 12 0, 00 0 18 0, 00 0 24 0, 00 0 30 0, 00 0 36 0, 00 0 42 0, 00 0 48 0, 00 0 54 0, 00 0 60 0, 00 0

0

0

KD

80,000

Production

Figure V20: Sweet corn breakeven point.

Page | 793 u) Foul Medames Breakeven Point

Table V21: Foul medames breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 6,000 12,000 18,000 24,000 30,000 36,000 42,000 48,000 54,000 60,000 66,000 72,000 78,000 84,000 90,000 96,000 102,000 108,000 114,000 120,000 126,000 67,022

KD/Year 2,144.69 3,002.69 3,860.69 4,718.69 5,576.69 6,434.69 7,292.69 8,150.69 9,008.69 9,866.69 10,724.69 11,582.69 12,440.69 13,298.69 14,156.69 15,014.69 15,872.69 16,730.69 17,588.69 18,446.69 19,304.69 20,162.69 11,728.76

KD/Year 0.00 1,050.00 2,100.00 3,150.00 4,200.00 5,250.00 6,300.00 7,350.00 8,400.00 9,450.00 10,500.00 11,550.00 12,600.00 13,650.00 14,700.00 15,750.00 16,800.00 17,850.00 18,900.00 19,950.00 21,000.00 22,050.00 11,728.76

KD/Year -2,144.69 -1,952.69 -1,760.69 -1,568.69 -1,376.69 -1,184.69 -992.69 -800.69 -608.69 -416.69 -224.69 -32.69 159.31 351.31 543.31 735.31 927.31 1,119.31 1,311.31 1,503.31 1,695.31 1,887.31 0.00

Page | 794

FoulFoul Medames

Total Cost Total Revnue

25,000

20,000

KD

15,000

10,000

5,000

Figure V21: Foul medames breakeven point.

12 0, 00 0

Production

10 8, 00 0

84 ,0 00 96 ,0 00

72 ,0 00

60 ,0 00

36 ,0 00 48 ,0 00

24 ,0 00

12 ,0 00

0

0

Page | 795 v) White Beans Breakeven Point

Table V22: White beans breakeven point.

Annual Production

Total Cost

Total Revenue

Total Profit

Cans/Year 0 15,000 30,000 45,000 60,000 75,000 90,000 105,000 120,000 135,000 150,000 165,000 180,000 195,000 210,000 225,000 240,000 255,000 270,000 285,000 300,000 315,000 93,785

KD/Year 1,594.34 5,539.34 9,484.34 13,429.34 17,374.34 21,319.34 25,264.34 29,209.34 33,154.34 37,099.34 41,044.34 44,989.34 48,934.34 52,879.34 56,824.34 60,769.34 64,714.34 68,659.34 72,604.34 76,549.34 80,494.34 84,439.34 26,259.67

KD/Year 0.00 4,200.00 8,400.00 12,600.00 16,800.00 21,000.00 25,200.00 29,400.00 33,600.00 37,800.00 42,000.00 46,200.00 50,400.00 54,600.00 58,800.00 63,000.00 67,200.00 71,400.00 75,600.00 79,800.00 84,000.00 88,200.00 26,259.67

KD/Year -1,594.34 -1,339.34 -1,084.34 -829.34 -574.34 -319.34 -64.34 190.66 445.66 700.66 955.66 1,210.66 1,465.66 1,720.66 1,975.66 2,230.66 2,485.66 2,740.66 2,995.66 3,250.66 3,505.66 3,760.66 0.00

Page | 796

White Beans

Total Cost Total Revnue

100,000 90,000 80,000 70,000

50,000 40,000 30,000 20,000 10,000

Production Figure V22: White breakeven point.

30 0, 00 0

24 0, 00 0 27 0, 00 0

21 0, 00 0

18 0, 00 0

15 0, 00 0

12 0, 00 0

90 ,0 00

60 ,0 00

30 ,0 00

0

0

KD

60,000

Appendix (W): Filling Weight Data for the Month of October 2008

Page 797 of 297

Page | 798

Page | 798

Page | 799

Page | 799

Page | 800

Page | 800

Page | 801

Page | 801

Page | 802

Page | 802

Page | 803

Page | 803

Page | 804

Page | 804

Page | 805

Page | 805

Page | 806

Page | 806

Page | 807

Page | 807

Page | 808

Page | 808

Page | 809

Page | 809

Page | 810

Page | 810

Page | 811

Page | 811

Page | 812

Page | 812

Page | 813

Page | 813

Page | 814

Page | 814

Page | 815

Page | 815

Page | 816

Page | 816

Page | 817

Page | 817

Page | 818

Page | 818

Page | 819

Page | 819

Page | 820

Page | 820

Page | 821

Page | 821

Page | 822

Page | 822

Page | 823

Page | 823

Page | 824

Page | 824

Page | 825

Page | 825

Page | 826

Page | 826

Page | 827

Page | 827

Page | 828

Page | 828

Page | 829

Page | 829

Page | 830

Page | 830

Page | 831

Page | 831

Page | 832

Page | 832

Page | 833

Page | 833

Page | 834

Page | 834

Page | 835

Page | 835

Page | 836

Page | 836

Page | 837

Page | 837

Page | 838

Page | 838

Page | 839

Page | 839

Page | 840

Page | 840

Page | 841

Page | 841

Page | 842

Page | 842

Page | 843

Page | 843

Page | 844

Page | 844

Page | 845

Page | 845

Page | 846

Page | 846

Page | 847

Page | 847

Page | 848

Page | 848

Page | 849

Page | 849

Final Appendix

Overview

More details

Related Documents

Final Appendix

Admin Savings Appendix -- Final

Appendix

Appendix

Appendix

Appendix