EKT Annual Business Plan For 2016-2017

EKT Trade and Investment P.L.C.
Sales Plan - Demostic in Quantity

For the Budget Year Ending June 30, 2017
S/N Ceramics and Tiles UOM Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total
1.1 Internal wall tile 20x30 M2 4150 4433 4610 5008 5202 5415 5,576 5,699 5,821 5,945 6,074 6,197 64,130
1.2 Rustic Floor Tile M2 5487 6960 6709 6622 6878 7160 7,373 7,535 7,697 7,861 8,032 8,194 86,508
300x300x10mm
1.3 Rustic Floor Tile M2 2210 2467 2573 2667 2770 2884 2,969 3,035 3,100 3,166 3,234 3,300 34,375
300x300x8mm
1.4 Porcelain Floor Tile M2 2960 3205 3446 3572 3710 3862 3,977 4,065 4,152 4,240 4,332 4,420 45,941
(Polished)
1.5 Porcelain Floor Tile M2 4010 4275 4567 4839 5027 5232 5,388 5,506 5,625 5,745 5,835 5,980 62,029
(Matt)
1.6 External Wall Tile M2 4110 4188 4685 4961 5151 5362 5,524 5,644 5,767 5,890 6,018 6,139 63,439
(Clicker)
1.7 PVC Tile M2 1213 1355 1413 1464 1521 1583 1,630 1,666 1,702 5,215 5,328 5,436 29,526
Door Locks
2.1 Door Lock Pcs 1817 1989 2030 2193 2278 2371 2,442 2,495 2,549 2,604 2,660 2,714 28,142
2.2 Hinge Set 650 890 1100 784 813 848 871 894 911 929 949 968 10,607
Sanitary Ware and
Fixtures
3.1 Hand Wash Basin W/Full Set 233 246 253 281 292 304 309 318 325 329 334 339 3,563
Accessories
3.2 Water Closet W/Full Set 162 185 196 195 203 211 214 220 225 228 231 234 2,504
Accessories
3.3 WC Turkish Type With Set 115 140 146 139 144 155 145 156 161 161 155 161 1,778
Plastic Cistern
3.4 Urinals Pcs 152 167 177 183 191 198 204 208 213 218 222 227 2,360
3.5 Soft Holder Pcs 179 202 212 216 224 235 239 245 251 255 260 266 2,784
3.6 Soap Holder Pcs 179 202 211 215 225 235 239 245 250 255 260 266 2,782
3.7 Crystal Glass Mirror Pcs 181 202 212 216 227 236 239 246 251 255 260 266 2,791
3.8 Shower Tray W/Full Pcs 350 391 405 422 439 457 470 480 491 501 511 522 5,439
Accessories
3.9 Bath Tub W/Full Pcs 43 48 50 52 54 56 58 59 60 62 63 64 669
Accessories
3.1 Kitchen Sink W/Full Pcs 45 50 52 54 56 59 60 61 63 64 65 67 696
Accessories
3.11 Fire Extenguisher Pcs 64 73 76 77 80 84 86 88 90 92 94 96 1,000
3.12 Water Heater 50Ltr. Pcs 150 162 171 181 188 196 199 205 210 214 216 221 2,313
3.13 Water Heater 80Ltr. Pcs 60 67 67 72 75 78 80 82 84 85 87 89 926
3.14 Water Heater 100Ltr. Pcs 35 39 41 42 44 46 47 48 49 50 51 52 544
3.15 Shower Box Pcs 12 13 14 14 15 16 16 16 16 17 17 17 183
3.16 Shower Panel Pcs 20 31 23 24 25 26 27 27 27 29 29 30 318
3.17 Bathroon Cabinet Pcs 15 16 17 18 19 20 20 20 21 22 22 22 232
3.18 Jacuzzi Pcs 4 4 5 5 5 5 6 6 6 6 7 7 66
Plywood
4.1 Plywood Pcs 1442 1611 1678 1741 1808 1882 1,938 1,981 2,024 2,066 2,111 2,154 22,436
PPR-C
PPR-C and HDPE Pipes
and Fittings
Sales Plan - Demostic in Birr
Unit
S/N Ceramics and Tiles Selling
UOM Price Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total
1.1 Internal wall tile 20x30 M2 152.17 631,506 674,570 701,504 762,067 791,588 824,001 848,500 867,217 885,782 904,651 924,281 942,997 9,758,662
1.2 Rustic Floor Tile 300x300x10mm M2 266.09 1,460,036 1,851,986 1,785,198 1,762,048 1,830,167 1,905,204 1,961,882 2,004,988 2,048,095 2,091,733 2,137,235 2,180,341 23,018,914
1.3 Rustic Floor Tile 300x300x8mm M2 243.48 538,091 600,665 626,474 649,361 674,440 702,196 722,892 738,962 754,788 770,858 787,414 803,484 8,369,625
1.4 Porcelain Floor Tile (Polished) M2 326.96 967,802 1,047,907 1,126,704 1,167,901 1,213,022 1,262,720 1,300,320 1,329,092 1,357,538 1,386,310 1,416,391 1,445,163 15,020,869
1.5 Porcelain Floor Tile (Matt) M2 365.22 1,464,532 1,561,316 1,667,960 1,767,300 1,835,961 1,910,831 1,967,805 2,010,901 2,054,363 2,098,189 2,131,059 2,184,016 22,654,231
1.6 External Wall Tile (Clicker) M2 208.70 857,757 874,036 977,760 1,035,361 1,075,014 1,119,049 1,152,859 1,177,903 1,203,573 1,229,243 1,255,957 1,281,209 13,239,719
1.7 PVC Tile M2 182.61 221,506 247,437 258,028 267,341 277,750 289,072 297,654 304,228 310,802 952,311 972,946 992,668 5,391,743
Door Locks
2.1 Door Lock Pcs 750.00 1,362,750 1,491,750 1,522,500 1,644,750 1,708,500 1,778,250 1,831,500 1,871,250 1,911,750 1,953,000 1,995,000 2,035,500 21,106,500
2.2 Hinge Set 182.60 118,690 162,514 200,860 143,158 148,454 154,845 159,045 163,244 166,349 169,635 173,287 176,757 1,936,838
Sanitary Ware and Fixtures

3.1 Hand Wash Basin W/Full Accessories Set 1,577.04 367,450 387,952 398,991 443,148 460,496 479,420 487,305 501,499 512,538 518,846 526,731 534,617 5,618,994
3.2 Water Closet W/Full Accessories Set 2,149.04 348,144 397,572 421,212 419,063 436,255 453,447 459,895 472,789 483,534 489,981 496,428 502,875 5,381,196
3.3 WC Turkish Type With Plastic Cistern Set 1,391.31 160,001 194,783 203,131 193,392 200,349 215,653 201,740 217,044 224,001 224,001 215,653 224,001 2,473,749
3.4 Urinals Pcs 1,300.00 197,600 217,100 230,100 237,900 248,300 257,400 265,200 270,400 276,900 283,400 288,600 295,100 3,068,000
3.5 Soft Holder Pcs 118.00 21,122 23,836 25,016 25,488 26,432 27,730 28,202 28,910 29,618 30,090 30,680 31,388 328,512
3.6 Soap Holder Pcs 118.00 21,122 23,836 24,898 25,370 26,550 27,730 28,202 28,910 29,500 30,090 30,680 31,388 328,276
3.7 Crystal Glass Mirror Pcs 304.35 55,087 61,479 64,522 65,740 69,087 71,827 72,740 74,870 76,392 77,609 79,131 80,957 849,441
3.8 Shower Tray W/Full Accessories Pcs 1,254.57 439,100 490,537 508,101 529,429 550,756 573,338 589,648 602,194 615,994 628,540 641,085 654,886 6,823,606
3.9 Bath Tub W/Full Accessories Pcs 3,373.91 145,078 161,948 168,696 175,443 182,191 188,939 195,687 199,061 202,435 209,182 212,556 215,930 2,257,146
3.1 Kitchen Sink W/Full Accessories Pcs 2,549.38 114,722 127,469 132,568 137,667 142,765 150,413 152,963 155,512 160,611 163,160 165,710 170,808 1,774,368
3.11 Fire Extenguisher Pcs 817.00 52,288 59,641 62,092 62,909 65,360 68,628 70,262 71,896 73,530 75,164 76,798 78,432 817,000
3.12 Water Heater 50Ltr. Pcs 3,214.39 482,159 520,731 549,661 581,805 604,305 630,020 639,664 658,950 675,022 687,879 694,308 710,380 7,434,884
3.15 Shower Box Pcs 6,869.57 82,435 89,304 96,174 96,174 103,044 109,913 109,913 109,913 109,913 116,783 116,783 116,783 1,257,131
3.16 Shower Panel Pcs 7,130.43 142,609 221,043 164,000 171,130 178,261 185,391 192,522 192,522 192,522 206,782 206,782 213,913 2,267,477
3.17 Bathroon Cabinet Pcs 12,173.91 182,609 194,783 206,956 219,130 231,304 243,478 243,478 243,478 255,652 267,826 267,826 267,826 2,824,347
3.18 Jacuzzi Pcs 68,695.65 274,783 274,783 343,478 343,478 343,478 343,478 412,174 412,174 412,174 412,174 480,870 480,870 4,533,913
Plywood
4.1 Plywood Pcs 913.04 1,316,604 1,470,907 1,532,081 1,589,603 1,650,776 1,718,341 1,769,472 1,808,732 1,847,993 1,886,341 1,927,427 1,966,688 20,484,965
5 PPR-C
PPR-C and HDPE Pipes and Fittings 3,127,552 3,492,352 3,638,272 3,774,464 3,920,384 4,080,896 4,202,496 4,294,912 4,387,328 4,479,744 4,577,024 4,669,440 48,644,864
6 Others 493,824 551,424 574,464 595,968 619,008 644,352 663,552 678,144 692,736 707,328 722,688 737,280 7,680,768
Total 16,017,391 17,886,964 18,633,052 19,331,109 20,078,084 20,900,216 21,522,874 21,996,652 22,470,039 23,577,373 24,089,504 24,575,523 251,078,781
Export Sales Plan - in Metric Ton
Description Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total
1 Sesame seeds - - - - 114 133 114 114 114 114 - - 703
2 Niger Seeds - - - - 133 152 152 152 152 152 133 - 1,026
3 Flax - - - - - - 38 38 38 19 - - 133
4 Castor seeds - - - - - - - - 192 192 192 192 768
5 Desi chickpeas - - - - - 336 336 336 336 336 336 312 2,328
6 Kabuli chickpeas - - - - - 144 168 168 168 168 144 144 1,104
7 Soya beans - - - - - 336 336 252 336 252 168 - 1,680
8 Red kidney beans - - 168 168 168 168 168 - - - - - 840
9 Red Speckled beans 264 288 288 264 - - - 264 264 264 - - 1,896
10 Pinto 144 168 144 144 - - - 144 144 144 - - 1,032
11 Light speckled k.beans 72 72 72 72 - - - 72 72 72 - - 504
12 Green Mag - - - - 72 96 - - 96 96 - - 360
13 Lupin - - - - - - 144 216 216 144 - - 720
14 Vetch - - - - - - 96 144 144 96 - - 480
15 Black cumin - - - - 24 24 24 24 - - - - 96
16 Others - - - - - - 72 72 - - - - 144
480 528 672 648 511 1,389 1,648 1,996 2,272 2,049 973 648 13,814
Export Sales Plan - in Birr
Unit
Selling
Description Price Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
1 Sesame seeds 23,471 - - - - 2,675,643 3,121,638

2,675,643 2,675,643 2,675,643 2,675,643 - -
2 Niger Seeds 24,123 - - - - 3,208,375 3,666,750

3,666,750 3,666,750 3,666,750 3,666,750 3,208,375 -
3 Flax 20,676 - - - - - -
785,695 785,695 785,695 392,861 - -
4 Castor seeds 14,323 - - - - - -

- - 2,750,000 2,750,000 2,750,000 2,750,000
5 Desi chick peas 16,538 - - - - - 5,556,705

5,556,705 5,556,705 5,556,705 5,556,705 5,556,705 5,159,770
6 Kabuli chick peas 20,924 - - - - - 3,012,999

3,515,204 3,515,204 3,515,204 3,515,204 3,012,999 3,012,999
7 Soya beans 9,167 - - - - - 3,080,001

3,080,001 2,310,001 3,080,001 2,310,001 1,540,001 -
8 Red kidney beans 12,833 - - 2,156,000 2,156,000 2,156,000 2,156,000

2,156,000 - - - - -
9 Red Speckled beans 14,620 3,859,735 4,210,670 4,210,670 3,859,735 - -

- 3,859,735 3,859,735 3,859,735 - -
10 Pinto 10,446 1,504,155 1,754,901 1,504,155 1,504,155 - -

- 1,504,155 1,504,155 1,504,155 - -
15,278 1,100,044 1,100,044 1,100,044 1,100,044 - -

11 Light speckled k.beans - 1,100,044 1,100,044 1,100,044 - -
12 Green Mag 21,389 - - - - 1,540,015 2,053,380

- - 2,053,380 2,053,380 - -
13 Lupin 8,556 - - - - - -
1,232,000 1,848,000 1,848,000 1,232,000 - -
14 Vetch 12,833 - - - - - -
1,232,000 1,848,000 1,848,000 1,232,000 - -
15 Black cumin 57,292 - - - - 1,374,999 1,374,998

1,374,998 1,374,999 - - - -
16 Others 19,097 - - - - - - 1,375,000 1,375,000 - - - -
6,463,934 7,065,616 8,970,869 8,619,933 10,955,032 24,022,470 26,649,995 31,419,930 34,243,311 31,848,477 16,068,079 10,922,769
Total
16,499,853
24,750,498
2,749,945
11,000,000
38,499,998
23,099,814
15,400,006
10,779,998
27,720,013
10,779,832
7,700,309
7,700,154
6,160,000
6,160,000
5,499,995
2,750,000
217,250,415
Local Sales in Birr for the Year Ending June 30, 2017
Jul Aug Sep Oct Nov
1 Ceramics and Tiles 6,141,229 6,857,916 7,143,627 7,411,379 7,697,941
2 Sanitary Wares and Fixtures 3,456,742 3,860,101 4,021,248 4,171,787 4,333,020
3 Door Locks 1,481,440 1,654,264 1,723,360 1,787,908 1,856,954
4 PPR-C and HDPE Pipes and Fittings 3,127,552 3,492,352 3,638,272 3,774,464 3,920,384
5 Plywood 1,316,604 1,470,907 1,532,081 1,589,603 1,650,776
6 Others 493,824 551,424 574,464 595,968 619,008
16,017,391 17,886,964 18,633,052 19,331,109 20,078,084
Export Sales in Birr for the Year Ending June 30, 2017
S/N Description Jul Aug Sep Oct Nov
1 6,463,934 7,065,616 8,970,869 8,619,933 10,955,032
6,463,934 7,065,616 8,970,869 8,619,933 10,955,032
Dec Jan Feb Mar Apr May Jun Total
8,013,073 8,251,912 8,433,292 8,614,940 9,433,295 9,625,282 9,829,879 97,453,764
4,510,459 4,644,898 4,747,078 4,848,943 4,948,030 5,068,796 5,159,979 53,771,082
1,933,095 1,990,545 2,034,494 2,078,099 2,122,635 2,168,287 2,212,257 23,043,338
4,080,896 4,202,496 4,294,912 4,387,328 4,479,744 4,577,024 4,669,440 48,644,864
1,718,341 1,769,472 1,808,732 1,847,993 1,886,341 1,927,427 1,966,688 20,484,965
644,352 663,552 678,144 692,736 707,328 722,688 737,280 7,680,768
20,900,216 21,522,874 21,996,652 22,470,039 23,577,373 24,089,504 24,575,523 251,078,781
Dec Jan Feb Mar Apr May Jun Total

24,022,470 26,649,995 31,419,930 34,243,311 31,848,477 16,068,079 10,922,769 217,250,415
24,022,470 26,649,995 31,419,930 34,243,311 31,848,477 16,068,079 10,922,769 217,250,415
Total Export Commodities Purchase for the Year 2016/2017
Total purhase
Average Buying
Product name
Total in Birr Price / MT
Quantity in
No. MT
1 Sesame Seeds 745 14,271,977.55 19,152.58
2 Niger 1,108 22,539,198.09 20,340.56
3 Flax 142 2,460,743.58 17,291.60
4 Castor seeds 783 9,804,651.19 12,516.15
5 Desi chick peas 2,444 33,848,682.80 13,847.44
6 Kabuli chick peas 1,159 20,708,787.81 17,865.26
7 Soya beans 1,781 12,275,066.19 6,893.01
8 Red kidney beans 924 9,131,084.01 9,882.13
9 Red Speckled beans 1,962 23,891,919.57 12,175.10
10 Pinto 1,068 8,820,126.81 8,257.87
11 LSKB 522 6,524,807.24 12,508.01
12 Green Mag 378 6,847,174.09 18,114.04
13 Lupin 763 4,740,555.58 6,211.42
14 Vetch 509 5,161,739.13 10,144.93
15 Black Cumin 115 4,941,529.79 42,895.25
16 Others 179 2,407,058.82 13,480.39
Total 14,583 188,375,102.24

13
Average
Sales Qty PC / MT
Sales
702.99 20,301.74
1,026.01 21,967.81
133.00 18,502.02
768.00 12,766.47
2,328.00 14,539.81
1,103.97 18,758.52
1,680.00 7,306.59
840.00 10,870.34
1,896.00 12,601.22
1,031.97 8,546.89
504.01 12,945.79
360.00 19,019.74
720.00 6,584.10
480.00 10,753.62
96.00 51,474.29
144.00 16,715.69
Forcasted Unit Cost of Sales - for Export (Birr)
Average
Description Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun UCOS
1 Sesame seeds 22,139 22,139 22,139 22,139 22,139 22,139 22,139 22,139 22,139 22,139 22,139 22,139 22,139
2 Niger Seeds 23,805 23,805 23,805 23,805 23,805 23,805 23,805 23,805 23,805 23,805 23,805 23,805 23,805
3 Flax 20,339 20,339 20,339 20,339 20,339 20,339 20,339 20,339 20,339 20,339 20,339 20,339 20,339
4 Castor seeds 14,604 14,604 14,604 14,604 14,604 14,604 14,604 14,604 14,604 14,604 14,604 14,604 14,604
5 Desi chickpeas 16,377 16,377 16,377 16,377 16,377 16,377 16,377 16,377 16,377 16,377 16,377 16,377 16,377
6 Kabuli chickpeas 20,596 20,596 20,596 20,596 20,596 20,596 20,596 20,596 20,596 20,596 20,596 20,596 20,596
7 Soya beans 9,144 9,144 9,144 9,144 9,144 9,144 9,144 9,144 9,144 9,144 9,144 9,144 9,144
8 Red kidney beans 12,707 12,707 12,707 12,707 12,707 12,707 12,707 12,707 12,707 12,707 12,707 12,707 12,707
9 Red Speckled Beans 14,438 14,438 14,438 14,438 14,438 14,438 14,438 14,438 14,438 14,438 14,438 14,438 14,438
10 Pinto 10,384 10,384 10,384 10,384 10,384 10,384 10,384 10,384 10,384 10,384 10,384 10,384 10,384
11 Light speckled K.beans 14,783 14,783 14,783 14,783 14,783 14,783 14,783 14,783 14,783 14,783 14,783 14,783 14,783
12 Green Mag 20,857 20,857 20,857 20,857 20,857 20,857 20,857 20,857 20,857 20,857 20,857 20,857 20,857
13 Lupin 8,421 8,421 8,421 8,421 8,421 8,421 8,421 8,421 8,421 8,421 8,421 8,421 8,421
14 Vetch 12,591 12,591 12,591 12,591 12,591 12,591 12,591 12,591 12,591 12,591 12,591 12,591 12,591
15 Black Cumin 53,311 53,311 53,311 53,311 53,311 53,311 53,311 53,311 53,311 53,311 53,311 53,311 53,311
16 Others 18,553 18,553 18,553 18,553 18,553 18,553 18,553 18,553 18,553 18,553 18,553 18,553 18,553
Forcasted Cost of Sales - for Export (Birr)
Description Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
1 Sesame seeds - - - - 2,523,787 2,944,470 2,523,787 2,523,787 2,523,787 2,523,787 -
2 Niger Seeds - - - - 3,166,054 3,618,382 3,618,382 3,618,382 3,618,382 3,618,382 3,166,054
3 Flax - - - - - - 772,872 772,872 772,872 386,450 -
4 Castor seeds - - - - - - - - 2,803,874 2,803,874 2,803,874
5 Desi chickpeas - - - - - 5,502,626 5,502,626 5,502,626 5,502,626 5,502,626 5,502,626
6 Kabuli chickpeas - - - - - 2,965,652 3,459,965 3,459,965 3,459,965 3,459,965 2,965,652
7 Soya beans - - - - - 3,072,258 3,072,258 2,304,194 3,072,258 2,304,194 1,536,129
8 Red kidney beans - - 2,134,839 2,134,839 2,134,839 2,134,839 2,134,839 - - - -
9 Red Speckled Beans 3,811,687 4,158,254 4,158,254 3,811,687 - - - 3,811,687 3,811,687 3,811,687 -
10 Pinto 1,495,233 1,744,493 1,495,233 1,495,233 - - - 1,495,233 1,495,233 1,495,233 -
11 Light speckled K.beans 1,064,385 1,064,385 1,064,385 1,064,385 - - - 1,064,385 1,064,385 1,064,385 -
12 Green Mag - - - - 1,501,688 2,002,276 - - 2,002,276 2,002,276 -
13 Lupin - - - - - - 1,212,645 1,818,967 1,818,967 1,212,645 -
14 Vetch - - - - - - 1,208,703 1,813,055 1,813,055 1,208,703 -
15 Black Cumin - - - - 1,279,472 1,279,471 1,279,471 1,279,472 - - -
16 Others - - - - - - 1,335,796 1,335,796 - - -

6,371,305 6,967,131 8,852,711 8,506,144 10,605,839 23,519,973 26,121,344 30,800,421 33,759,367 31,394,206 15,974,334
Jun Total
- 15,563,402
- 24,424,018
- 2,705,067
2,803,874 11,215,496
5,109,554 38,125,307
2,965,652 22,736,817
- 15,361,290
- 10,674,196
- 27,374,944
- 10,715,893
- 7,450,693
- 7,508,514
- 6,063,223
- 6,043,517
- 5,117,885
- 2,671,592
10,879,080 213,751,856
Import Plan - (Amount in Birr)
I. Ceramics
1 Internal wall tile 20x30 976,528 524,501 569,784 591,856 616,090 634,408 648,402 662,283 676,391 691,068 705,062 474,243 7,770,614
2 Rustic Floor Tile 300x300x10mm 2,035,334 1,376,517 1,358,667 1,411,192 1,469,051 1,512,753 1,545,992 1,579,230 1,612,879 1,647,964 1,681,202 1,130,747 18,361,529
3 Rustic Floor Tile 300x300x8mm 983,328 445,650 461,931 479,771 499,516 514,239 525,670 536,928 548,359 560,137 571,569 384,462 6,511,562
4 Porcelain Floor Tile (Polished) 1,765,945 823,136 853,233 886,197 922,505 949,975 970,995 991,776 1,012,797 1,034,772 1,055,793 710,158 11,977,280
5 Porcelain Floor Tile (Matt) 2,026,055 1,095,937 1,161,208 1,206,322 1,255,516 1,292,951 1,321,267 1,349,823 1,378,620 1,400,217 1,435,012 966,508 15,889,436
6 External Wall Tile (Clicker) - 156,029 892,647 926,834 964,800 993,949 1,015,541 1,037,673 1,059,805 1,082,836 1,104,608 742,778 9,977,499
7 PVC Tile 1,073,841 563,723 584,341 606,953 631,827 650,583 664,949 679,181 693,680 708,711 723,077 486,310 8,067,176
Sub Total 8,861,030 4,985,494 5,881,811 6,109,126 6,359,306 6,548,857 6,692,815 6,836,895 6,982,530 7,125,705 7,276,322 4,895,205 78,555,096
II. Sanitary Wares and Fixtures
12 Hand Wash Basin W/Full Accessories - - - 286,411 410,703 417,458 429,617 439,074 444,478 451,233 457,988 316,167 3,653,130
13 Water Closet W/Full Accessories - - 412,112 366,924 381,384 386,806 397,652 406,689 412,112 417,534 422,957 294,105 3,898,273
16 WC Turkish Type With Plastic Cistern 296,145 142,697 135,855 140,742 151,493 141,719 152,471 157,358 157,358 151,493 157,358 112,893 1,897,581
17 Urinals 210,205 93,483 96,652 100,877 104,574 107,743 109,856 112,497 115,137 117,250 119,891 80,632 1,368,797
18 Soft Holder - - - - - - - - - - 27,273 18,503 45,777
19 Soap Holder - - - - - - - - - - 3,859 17,347 21,206
20 Crystal Glass Mirror - - - - - - 24,834 32,130 32,642 33,282 34,050 23,271 180,209
24 Shower Tray W/Full Accessories - - - - - - 55,220 444,475 453,527 462,580 472,537 318,230 2,206,569
28 Bath Tub W/Full Accessories 351,666 141,406 147,062 152,719 158,375 164,031 166,859 169,687 175,344 178,172 181,000 122,144 2,108,466
32 Kitchen Sink W/Full Accessories - - - - 92,481 108,801 110,615 114,241 116,055 117,868 121,495 81,960 863,516
33 Fire Extenguisher 219,693 53,860 54,569 56,695 59,530 60,947 112,074 63,782 65,199 66,617 68,034 45,556 926,557
34 Water Heater 50Ltr. 990,006 427,503 452,503 470,003 490,003 497,503 512,503 525,003 535,003 540,003 552,503 376,652 6,369,190
35 Water Heater 80Ltr. 832,833 197,173 211,887 220,716 229,544 235,430 241,316 247,201 250,144 256,030 261,916 177,349 3,361,539
36 Water Heater 100Ltr. 935,838 136,546 139,876 146,537 153,198 156,528 159,858 163,189 166,519 169,850 173,180 117,076 2,618,196
37 Shower Box 1,200,335 65,134 65,134 69,787 74,439 74,439 74,439 74,439 79,092 79,092 79,092 56,075 1,991,499
38 Shower Panel 1,656,061 143,193 149,419 155,645 161,871 168,096 168,096 168,096 180,548 180,548 186,774 125,064 3,443,412
39 Bathroon Cabinet 1,867,507 121,638 128,794 135,949 143,104 143,104 143,104 150,259 157,414 157,414 157,414 107,800 3,413,502
40 Jacuzzi 9,095,856 181,917 181,917 181,917 181,917 218,301 218,301 218,301 218,301 254,684 254,684 146,174 11,352,269
Sub Total 17,656,146 1,704,551 2,175,780 2,484,921 2,792,617 2,880,908 3,076,814 3,486,422 3,558,873 3,633,650 3,732,005 2,537,000 49,719,688
III. Door Locks
41 Door Lock 679,765 1,184,484 1,279,593 1,329,189 1,383,454 1,424,882 1,455,807 1,487,315 1,519,407 1,552,082 1,583,591 1,064,866 15,944,434
42 Hinge 299,238 155,338 110,714 114,809 119,752 123,000 126,248 128,648 131,190 134,015 136,698 92,195 1,671,845
Sub Total 979,004 1,339,822 1,390,307 1,443,998 1,503,206 1,547,881 1,582,054 1,615,963 1,650,597 1,686,097 1,720,289 1,157,060 17,616,279
43 Plywood 2,319,037 1,274,597 1,322,451 1,373,344 1,429,554 1,472,091 1,504,754 1,537,416 1,569,319 1,603,501 1,636,163 1,100,152 18,142,379
44 PPR Pipes and Fittings 2,738,363 2,738,363 - - 2,738,363 - - 2,738,363 - - 2,750,412 13,703,866
IV. Other Fixtures 370,368 413,568 430,848 446,976 464,256 483,264 497,664 508,608 519,552 530,496 542,016 552,960 5,760,576
V. Tender goods 25,100,824 45,100,824 45,850,824 3,000,000 4,500,000 6,000,000 6,000,000 4,500,000 3,000,000 2,250,000 1,500,000 1,500,000 148,302,472
Less VAT (9.84% of the Total Cost) (5,709,638) (5,394,175) (5,883,374) (1,462,063) (1,677,615) (2,132,462) (1,904,444) (1,818,954) (1,969,893) (1,656,018) (1,614,429) (1,426,091) (32,649,155)
Less Withholding Tax (1.97% of the Total
Cost) (1,143,088) (1,079,931) (1,177,871) (292,710) (335,864) (426,926) (381,276) (364,160) (394,379) (331,540) (323,214) (285,508) (6,536,467)
51,172,047 48,344,749 52,729,140 13,103,593 15,035,458 19,111,977 17,068,382 16,302,190 17,654,963 14,841,890 14,469,152 12,781,192 292,614,733
Import Plan - (Amount in Birr)
Description Qtr - 1 Qtr - 2 Qtr - 3 Qtr - 4 Total
I. Ceramics
1 Internal wall tile 20x30 2,070,813 1,842,354 1,987,075 1,870,372 7,770,614
2 Rustic Floor Tile 300x300x10mm 4,770,518 4,392,997 4,738,101 4,459,913 18,361,529
3 Rustic Floor Tile 300x300x8mm 1,890,910 1,493,526 1,610,958 1,516,168 6,511,562
4 Porcelain Floor Tile (Polished) 3,442,314 2,758,676 2,975,568 2,800,723 11,977,280
5 Porcelain Floor Tile (Matt) 4,283,200 3,754,789 4,049,710 3,801,737 15,889,436
6 External Wall Tile (Clicker) 1,048,676 2,885,583 3,113,018 2,930,222 9,977,499
7 PVC Tile 2,221,905 1,889,364 2,037,810 1,918,097 8,067,176
Sub Total 19,728,336 19,017,289 20,512,240 19,297,232 78,555,096

12 Hand Wash Basin W/Full Accessories - 1,114,573 1,313,169 1,225,388 3,653,130
Water Closet W/Full Accessories
13 412,112 1,135,114 1,216,452 1,134,595 3,898,273
16 WC Turkish Type With Plastic Cistern 574,697 433,955 467,186 421,744 1,897,581
17 Urinals 400,340 313,195 337,490 317,773 1,368,797
18 Soft Holder - - - 45,777 45,777
19 Soap Holder - - - 21,206 21,206
20 Crystal Glass Mirror - - 89,606 90,604 180,209
24 Shower Tray W/Full Accessories - - 953,222 1,253,347 2,206,569
28 Bath Tub W/Full Accessories 640,135 475,125 511,890 481,316 2,108,466
32 Kitchen Sink W/Full Accessories - 201,282 340,911 321,323 863,516
33 Fire Extenguisher 328,123 177,172 241,056 180,206 926,557
34 Water Heater 50Ltr. 1,870,012 1,457,509 1,572,510 1,469,159 6,369,190
35 Water Heater 80Ltr. 1,241,893 685,690 738,661 695,295 3,361,539
36 Water Heater 100Ltr. 1,212,260 456,263 489,567 460,106 2,618,196
37 Shower Box 1,330,604 218,666 227,971 214,259 1,991,499
38 Shower Panel 1,948,674 485,612 516,741 492,386 3,443,412
39 Bathroon Cabinet 2,117,939 422,157 450,777 422,629 3,413,502
40 Jacuzzi 9,459,690 582,135 654,902 655,542 11,352,269
Sub Total 21,536,477 8,158,446 10,122,110 9,902,655 49,719,688
III. Door Locks

41 Door Lock 3,143,842 4,137,525 4,462,529 4,200,539 15,944,434
42 Hinge 565,290 357,561 386,086 362,907 1,671,845
Sub Total 3,709,132 4,495,085 4,848,615 4,563,446 17,616,279
43 Plywood 4,916,085 4,274,989 4,611,489 4,339,816 18,142,379

44 PPR Pipes and Fittings 5,476,727 2,738,363 2,738,363 2,750,412 13,703,866
IV. Other Fixtures 1,214,784 1,394,496 1,525,824 1,625,472 5,760,576
V. Tender goods 116,052,472 13,500,000 13,500,000 5,250,000 148,302,472
Less VAT (9.84% of the Total Cost) (16,987,187) (5,272,141) (5,693,290) (4,696,537) (32,649,155)
Less Withholding Tax (1.97% of the Total Cost) (3,400,890) (1,055,500) (1,139,815) (940,262) (6,536,467)
152,245,936 47,251,028 51,025,535 42,092,234 292,614,733
Purchase Plan
UP
w/o/VAT
Description & WHT Jul Aug Sep Oct Nov Dec Jan Feb
1 Internal wall tile 119.16 1,022,757 549,331 596,757 619,874 645,256 664,441 679,097 693,635
2 Rustic Floor Tile 213.34 2,116,291 1,431,270 1,412,710 1,467,324 1,527,484 1,572,925 1,607,485 1,642,046
3 Porcelain Floor Tile (Polished) 235.81 1,338,799 606,752 628,918 653,207 680,090 700,134 715,698 731,026
4 Porcelain Floor Tile (Matt) 235.81 1,743,380 812,618 842,331 874,873 910,717 937,836 958,588 979,104
5 External Wall Tile (Clincker) 162.58 1,372,649 742,495 786,717 817,281 850,610 875,972 895,156 914,503
6 Adhesive (Maxi Fix) 11.25 - 9,751 55,787 57,924 60,297 62,119 63,468 64,851
7 Door locks 590.23 687,618 1,198,167 1,294,374 1,344,544 1,399,435 1,441,342 1,472,624 1,504,496
8 Hinges 0.00 - - - - - - - -
9 Hand wash basin 703.77 - - - 149,199 213,946 217,464 223,798 228,725
10 Water closet 1547.06 - - 352,731 314,054 326,431 331,072 340,354 348,090
11 WC Turkish Type 579.87 175,700 84,661 80,602 83,501 89,880 84,081 90,460 93,359
12 Urinals 932.64 371,189 165,076 170,672 178,133 184,662 190,258 193,988 198,651
13 Toilet Paper Holder 94.62 - - - - - - - -
14 Soap Holder 80.09 - - - - - - - -
15 Towel Hanger - - - - - - - -
16 Shower Tray 547.59 - - - - - - 33,403 268,866
17 Crystal Mirror 134.81 20,087 6,741 7,010 7,280 7,549 7,819 7,954 8,089
18 Kitchen sink 1547.31 - - - - 78,913 92,839 94,386 97,481
19 Floor Drain - - - - - - - -
20 Bath Tub 1,171.67 329,238 48,038 49,210 51,553 53,897 55,068 56,240 57,412
21 Angle Vave 1/2'' RC 74.91 19,326 1,049 1,049 1,124 1,198 1,198 1,198 1,198
22 Fire Extinguisher 839.58 223,328 19,310 20,150 20,989 21,829 22,669 22,669 22,669
23 Water Heater 3,077.95 803,345 52,325 55,403 58,481 61,559 61,559 61,559 64,637
24 Other Fixtures - - - - - - - -
25 Plywood 653.11 1,993,931 1,095,911 1,137,056 1,180,814 1,229,144 1,265,718 1,293,802 1,321,885
26 PPR Pipes and Fittings

Total 12,217,636 6,823,496 7,491,478 7,880,157 8,342,897 8,584,513 8,811,927 9,240,722
Mar Apr May Jun Total
708,411 723,783 738,439 494,517 8,136,299
1,677,033 1,713,513 1,748,073 1,170,573 19,086,726
746,590 762,625 778,189 521,151 8,863,182
999,855 1,021,550 1,042,302 698,012 11,821,166
934,013 948,645 972,219 651,939 10,762,200
66,234 67,674 69,034 46,218 623,357
1,536,959 1,570,012 1,601,884 1,072,448 16,123,903
- - - - -
231,540 235,059 238,577 163,978 1,902,286
352,731 357,372 362,013 250,625 3,335,472
93,359 89,880 93,359 66,685 1,125,525
203,315 207,045 211,708 141,761 2,416,459
- - 25,075 16,938 42,013
- - 3,204 14,336 17,540
- - - - -
274,342 279,818 285,842 191,656 1,333,928
8,358 8,493 8,628 5,797 103,804
99,028 100,575 103,670 69,629 736,519
- - - - -
58,583 59,755 60,927 41,008 920,929

1,273 1,273 1,273 899 32,060
24,348 24,348 25,187 16,792 464,286
67,715 67,715 67,715 46,169 1,468,182
- - - - -
1,349,316 1,378,705 1,406,789 941,778 15,594,849
9,433,002 9,617,840 9,844,108 6,622,909 104,910,685

Import Plan - (Quantity)
Description UOM Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total Quintal
1 Internal wall tile 20x30 M 8,583 4,610 5,008 5,202 5,415 5,576 5,699 5,821 5,945 6,074 6,197 4,150
2
68,280 0.108 7,374.24
Rustic Floor Tile
M2 9,920 6,709 6,622 6,878 7,160 7,373 7,535 7,697 7,861 8,032 8,194 5,487
2 300x300x10mm 89,468 0.18 16,104.24
3 Rustic Floor Tile 300x300x8mm M 5,677 2,573 2,667 2,770 2,884 2,969 3,035 3,100 3,166 3,234 3,300 2,210
2
37,585 0.18 6,765.36
4 Porcelain Floor Tile (Polished) M2 7,393 3,446 3,572 3,710 3,862 3,977 4,065 4,152 4,240 4,332 4,420 2,960 50,129 0.208333 10,443.54
5 Porcelain Floor Tile (Matt) M 8,443 4,567 4,839 5,027 5,232 5,388 5,506 5,625 5,745 5,835 5,980 4,010
2
66,197 0.208333 13,791.04
6 External Wall Tile (Clicker) M2 867 4,961 5,151 5,362 5,524 5,644 5,767 5,890 6,018 6,139 4,110 55,433 0.142105 7,877.34
7 PVC Tile M2 8,073 4,238 4,393 4,563 4,750 4,891 4,999 5,106 5,215 5,328 5,436 3,640 60,632 0.038571 2,338.66
8 Door Locks Pcs 1,165 2,030 2,193 2,278 2,371 2,442 2,495 2,549 2,604 2,660 2,714 1,817 27,318 0.038571 1,053.69
9 Hinges Pcs 2,119 1,100 784 813 848 871 894 911 929 949 968 650 11,836 0.038571 456.53
Hand Wash Basin W/Full
Set - - - 212 304 309 318 325 329 334 339 233
10 Accessories 2,703 0.27 729.81
Water Closet W/Full
Set - - 228 203 211 214 220 225 228 231 234 162
11 Accessories 2,156 0.54 1,164.24
WC Turkish Type With Plastic
Set 303 146 139 144 155 145 156 161 161 155 161 115
12 Cistern 1,941 0.54 1,048.14
13 Urinals Pcs 398 177 183 191 198 204 208 213 218 222 227 152 2,591 0.18 466.38
14 Soft Holder Pcs 265 179 444 0.09 39.96
15 Soap Holder Pcs 40 179 219 0.09 19.71
16 Crystal Glass Mirror Pcs 194 251 255 260 266 181 1,407 -
Shower Tray W/Full Accessories Set 61 491 501 511 522 350
17 2,436 0.135 328.86
18 Bath Tub W/Full Accessories Set 149 50 52 54 56 58 59 60 62 63 64 43 770 0.385714 297.00
Kitchen Sink W/Full
Set 51 60 61 63 64 65 67 45
19 Accessories 476 -
20 Fire Extenguisher Pcs 310 76 77 80 84 86 88 90 92 94 96 64 1,237 -
21 Water Heater 50Ltr. Pcs 396 171 181 188 196 199 205 210 214 216 221 150 2,547 1,080.00
22 Water Heater 80Ltr. Pcs 283 67 72 75 78 80 82 84 85 87 89 60 1,142 -
23 Water Heater 100Ltr. Pcs 281 41 42 44 46 47 48 49 50 51 52 35 786 -
24 Shower Box Pcs 258 14 14 15 16 16 16 16 17 17 17 12 428 -
25 Shower Panel Pcs 266 23 24 25 26 27 27 27 29 29 30 20 553 -
26 Bathroon Cabinet Pcs 261 17 18 19 20 20 20 21 22 22 22 15 477 -
27 Jacuzzi Pcs 250 5 5 5 5 6 6 6 6 7 7 4 312 -
28 Plywood Pcs 3,053 1,678 1,741 1,808 1,882 1,938 1,981 2,024 2,066 2,111 2,154 1,442 23,878 0.27 6,447.06
29 PPR Pipes and Fittings - 77,825.81
tons 7,782.58
Purchase Plan for Export - in Metric Ton
1 Sesame seeds - - - - 121 141 121 121 121 121 - - 745 16,497,206
2 Niger Seeds - - - - 144 164 164 164 164 164 144 - 1,108 26,377,939
3 Flax - - - - - - 41 41 41 20 - - 142 2,894,422
4 Castor seeds - - - - - - - - 196 196 196 196 783 11,439,806
5 Desi chickpeas - - - - - 353 353 353 353 353 353 328 2,444 40,031,573
6 Kabuli chickpeas - - - - - 151 176 176 176 176 151 151 1,159 23,873,658
7 Soya beans - - - - - 356 356 267 356 267 178 - 1,781 16,282,967
8 Red kidney beans - - 185 185 185 185 185 - - - - - 924 11,741,616
9 Red Speckled beans 273 298 298 273 - - - 273 273 273 - - 1,962 28,333,067
10 Pinto 149 174 149 149 - - - 149 149 149 - - 1,068 11,090,949
11 Light speckled k.beans 75 75 75 75 - - - 75 75 75 - - 522 7,711,467
12 Green Mag - - - - 76 101 - - 101 101 - - 378 7,883,940
13 Lupin - - - - - - 153 229 229 153 - - 763 6,427,016
14 Vetch - - - - - - 102 153 153 102 - - 509 6,406,128
15 Black cumin - - - - 29 29 29 29 - - - - 115 6,141,462
16 Others - - - - - - 89 89 - - - - 179 3,312,774
497 546 706 682 554 1,480 1,768 2,118 2,386 2,149 1,022 675 14,583 226,445,992
2,225,229 14,271,978
3,838,741 22,539,198
433,678 2,460,744
1,635,155 9,804,651
6,182,890 33,848,683
3,164,870 20,708,788
4,007,901 12,275,066
2,610,532 9,131,084
4,441,147 23,891,920
2,270,823 8,820,127
1,186,660 6,524,807
1,036,766 6,847,174
1,686,461 4,740,556
1,244,389 5,161,739
1,199,933 4,941,530
905,716 2,407,059
38,070,890 188,375,102
Purchase Plan for Export - in Birr
For the Budget Year Ending Sene 30, 2008 E.C.
Description Unit Cost Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
1 Sesame seeds - - - - 2,314,367 2,700,142

19,152.58 2,314,367 2,314,367 2,314,367 2,314,367 - -
2 Niger Seeds 20,340.56 - - - - 2,921,727 3,339,149 3,339,149 3,339,149 3,339,149 3,339,149 2,921,727 -
3 Flax - - - - - -
17,291.60 703,066 703,066 703,066 351,545 - -
4 Castor seeds - - - - - -
12,516.15 - - 2,451,163 2,451,163 2,451,163 2,451,163
5 Desi chickpeas - - - - - 4,885,380

13,847.44 4,885,380 4,885,380 4,885,380 4,885,380 4,885,380 4,536,400
6 Kabuli chickpeas - - - - - 2,701,128

17,865.26 3,151,351 3,151,351 3,151,351 3,151,351 2,701,128 2,701,128
7 Soya beans 6,893.01 - - - - - 2,455,013 2,455,013 1,841,260 2,455,013 1,841,260 1,227,507 -
8 Red kidney beans 9,882.13 - - 1,826,217 1,826,217 1,826,217 1,826,217 1,826,217 - - - - -

Red Speckled 3,326,711 3,629,183 3,629,183 3,326,711 - -
9 Beans 12,175.10 - 3,326,711 3,326,711 3,326,711 - -
10 Pinto 8,257.87 1,230,709 1,435,872 1,230,709 1,230,709 - - - 1,230,709 1,230,709 1,230,709 - -

Light speckled 932,115 932,115 932,115 932,115 - -
11 K.beans 12,508.01 - 932,115 932,115 932,115 - -
12 Green Mag - - - - 1,369,421 1,825,918

18,114.04 - - 1,825,918 1,825,918 - -
13 Lupin 6,211.42 - - - - - - 948,111 1,422,167 1,422,167 948,111 - -
14 Vetch - - - - - -
10,144.93 1,032,348 1,548,522 1,548,522 1,032,348 - -
15 Black Cumin - - - - 1,235,383 1,235,382

42,895.25 1,235,382 1,235,383 - - - -
16 Others - - - - - -
13,480.39 1,203,529 1,203,529 - - - -
5,489,535 5,997,169 7,618,224 7,315,752 9,667,115 20,968,329 23,093,913 27,133,709 29,585,631 27,630,127 14,186,905 9,688,691
Total
14,271,978
22,539,198
2,460,744
9,804,651
33,848,683
20,708,788
12,275,066
9,131,084
23,891,920
8,820,127
6,524,807
6,847,174
4,740,556
5,161,739
4,941,530
2,407,059
188,375,102
Purchase Plan for Export - in Birr
For the Budget Year Ending Sene 30, 2008 E.C.
Description Qtr - 1 Qtr - 2 Qtr - 3 Qtr - 4 Total
1 Sesame seeds - 5,014,509 6,943,101 2,314,367 14,271,978
2 Niger Seeds - 6,260,876 10,017,446 6,260,876 22,539,198
3 Flax - - 2,109,198 351,545 2,460,744
4 Castor seeds - - 2,451,163 7,353,488 9,804,651
5 Desi chickpeas - 4,885,380 14,656,141 14,307,161 33,848,683
6 Kabuli chickpeas - 2,701,128 9,454,052 8,553,607 20,708,788
7 Soya beans - 2,455,013 6,751,286 3,068,767 12,275,066
8 Red kidney beans 1,826,217 5,478,650 1,826,217 - 9,131,084
9 Red Speckled beans 10,585,076 3,326,711 6,653,422 3,326,711 23,891,920
10 Pinto 3,897,290 1,230,709 2,461,418 1,230,709 8,820,127
11 Light speckled k.beans 2,796,346 932,115 1,864,231 932,115 6,524,807
12 Green Mag - 3,195,339 1,825,918 1,825,918 6,847,174
13 Lupin - - 3,792,444 948,111 4,740,556
14 Vetch - - 4,129,391 1,032,348 5,161,739
15 Black cumin - 2,470,765 2,470,765 - 4,941,530
16 Others - - 2,407,059 - 2,407,059
19,104,929 37,951,197 79,813,253 51,505,724 188,375,102
Product Profitability - for Import - (ETB)
Total Cost AUC inc VAT &
Total GPM in
inc VAT & VAT & WHT (in Av NAUC SP GPM
Qty %
Description WHT WHT 11.81%)
I. Ceramics
1 Internal wall tile 20x30 7,770,614 68,280 113.81 13.44 100.36 152.17 51.81 51.62
Rustic Floor Tile
2 300x300x10mm 18,361,529 89,468 205.23 24.24 180.99 266.09 85.10 47.02
Rustic Floor Tile
3 300x300x8mm 6,511,562 37,585 173.25 20.46 152.79 243.48 90.69 59.36
Porcelain Floor Tile
4 (Polished) 11,977,280 50,129 238.93 28.22 210.71 326.96 116.25 55.17
Porcelain Floor Tile
5 (Matt) 15,889,436 66,197 240.03 28.35 211.68 365.22 153.54 72.53
External Wall Tile
6 (Clicker) 9,977,499 55,433 179.99 21.26 158.73 208.70 49.97 31.48
7 PVC Tile 8,631,878 60,632 142.37 16.81 125.55 182.61 57.06 45.45
Sub Total 79,119,798
Hand Wash Basin W/Full
12 Accessories 3,653,130 2,703 1,351.51 159.61 1,191.90 1,577.04 385.14 32.31
Water Closet W/Full
13 Accessories 3,898,273 2,156 1,808.10 213.54 1,594.57 2,149.04 554.47 34.77
WC Turkish Type With Plastic
16 Cistern 1,897,581 1,941 977.63 115.46 862.17 1,391.31 529.14 61.37
17 Urinals 1,368,797 2,591 528.29 62.39 465.90 1,300.00 834.10 179.03
18 Soft Holder 45,777 444 103.10 12.18 90.92 118.00 27.08 29.78
19 Soap Holder 21,206 219 96.83 11.44 85.40 118.00 32.60 38.18
20 Crystal Glass Mirror 180,209 1,407 128.08 15.13 112.95 304.35 191.40 169.45
Shower Tray W/Full
24 Accessories 2,206,569 2,436 905.82 106.98 798.84 1,254.57 455.73 57.05
Bath Tub W/Full
28 Accessories 2,108,466 770 2,738.27 323.39 2,414.88 3,373.91 959.03 39.71
Kitchen Sink W/Full
32 Accessories 863,516 476 1,814.11 214.25 1,599.86 2,549.38 949.52 59.35
33 Fire Extenguisher 926,557 1,237 749.04 88.46 660.57 817.00 156.43 23.68
34 Water Heater 50Ltr. 6,369,190 2,547 2,500.66 295.33 2,205.34 3,214.39 1,009.05 45.76
35 Water Heater 80Ltr. 3,361,539 1,142 2,943.55 347.63 2,595.92 3,739.13 1,143.21 44.04
36 Water Heater 100Ltr. 2,618,196 786 3,331.04 393.40 2,937.64 4,173.91 1,236.27 42.08
37 Shower Box 1,991,499 428 4,653.03 549.52 4,103.51 6,869.57 2,766.06 67.41
38 Shower Panel 3,443,412 553 6,226.79 735.38 5,491.40 7,130.43 1,639.03 29.85
39 Bathroon Cabinet 3,413,502 477 7,156.19 845.15 6,311.04 12,173.91 5,862.87 92.90
40 Jacuzzi 11,352,269 312 36,385.48 4,297.12 32,088.35 68,695.65 36,607.30 114.08
III. Door Locks
41 Door Lock 15,944,434 27,318 583.66 68.93 514.73 750.00 235.27 45.71
42 Hinge 1,671,845 11,836 141.25 16.68 124.57 182.60 58.03 46.59
43 Plywood 18,142,379 23,878 759.79 89.73 670.06 913.04 242.98 36.26
44 PPR Pipes and Fittings 13,703,866
IV. Other Fixtures 5,760,576
V. Tender goods 148,302,472
Less VAT (9.84% of the
Total Cost) (32,649,155)
Less Withholding Tax (1.97% of
the Total Cost) (6,536,467)
293,179,436
Product Profitability - for Export - (ETB)
Total
Average Total Total Total Total Annual
Total Annual Annual Average Average Average
Buying Annual Annual Annual Direct Total Cost of GPM in
Purchase Direct Unit Cost of Unit Selling Gross Profit
Price / Purchase Sales (Qty Wastage Operating Sales %
(Qty in MT) Material Sales Price Per Unit
MT Cost in MT) (Qty in MT) Cost
Description Cost
1 Sesame seeds 745 19,153 14,271,978 703 42 14,271,978 1,291,425 15,563,402 22,139 23,470.87 1,332 6.02
2 Niger Seeds 1,108 20,341 22,539,198 1,026 82 22,539,198 1,884,820 24,424,018 23,805 24,123.05 318 1.34
3 Flax 142 17,292 2,460,744 133 9 2,460,744 244,324 2,705,067 20,339 20,676.48 337 1.66
4 Castor seeds 783 12,516 9,804,651 768 15 9,804,651 1,410,845 11,215,496 14,604 14,322.92 (281) (1.92)
5 Desi chickpeas 2,444 13,847 33,848,683 2,328 116 33,848,683 4,276,624 38,125,307 16,377 16,537.80 161 0.98
6 Kabuli chickpeas 1,159 17,865 20,708,788 1,104 55 20,708,788 2,028,029 22,736,817 20,596 20,924.37 329 1.60
7 Soya beans 1,781 6,893 12,275,066 1,680 101 12,275,066 3,086,224 15,361,290 9,144 9,166.67 23 0.25
8 Red kidney beans 924 9,882 9,131,084 840 84 9,131,084 1,543,112 10,674,196 12,707 12,833.33 126 0.99
9 Red Speckled Beans 1,962 12,175 23,891,920 1,896 66 23,891,920 3,483,024 27,374,944 14,438 14,620.26 182 1.26
10 Pinto 1,068 8,258 8,820,127 1,032 36 8,820,127 1,895,766 10,715,893 10,384 10,445.89 62 0.60
11 Light speckled K.beans 522 12,508 6,524,807 504 18 6,524,807 925,886 7,450,693 14,783 15,278.09 495 3.35
12 Green Mag 378 18,114 6,847,174 360 18 6,847,174 661,340 7,508,514 20,857 21,389.10 532 2.55
13 Lupin 763 6,211 4,740,556 720 43 4,740,556 1,322,667 6,063,223 8,421 8,555.56 134 1.60
14 Vetch 509 10,145 5,161,739 480 29 5,161,739 881,778 6,043,517 12,591 12,833.33 243 1.93
15 Black Cumin 115 42,895 4,941,530 96 19 4,941,530 176,356 5,117,885 53,311 57,291.64 3,980 7.47
16 Others 179 13,480 2,407,059 144 35 2,407,059 264,533 2,671,592 18,553 19,097.22 544 2.93
14,583 188,375,102 13,814 769 188,375,102 25,376,754 213,751,856
PROJECTED BALANCE SHEET
For the Budget Year 2016/2017
30 June 2016
(Actual +
DESCRIPTION Estimate) 31-Jul-16 31-Aug-16 30-Sep-16 31-Oct-16 30-Nov-16 31-Dec-16 31-Jan-17 28-Feb-17 31-Mar-17 30-Apr-17 31-May-17 30-Jun-17
NON-CURRENT ASSETS
NET FIXED ASSETS ### ### ### ### ### ### ### ### ### 20,770,901 20,584,217 20,397,532 20,210,848
TOTAL FIXED ASSETS 19,459,260 20,741,276 20,655,691 20,510,007 21,704,323 21,517,638 21,330,954 21,144,270 20,957,585 20,770,901 20,584,217 20,397,532 20,210,848
CURRENT ASSETS
STOCKS ### ### ### ### ### ### ### ### ### 21,045,126 17,751,305 14,523,005 9,274,075
TRADE & OTHER RECEIVABLES ### ### ### ### ### ### ### ### ### 67,119,761 67,162,695 66,967,548 67,161,955
CASH ON HAND & AT BANK 6,792,256 4,017,087 1,186,565 184,873 ### ### 6,670,714 6,752,231 7,618,547 10,336,574 18,116,379 27,727,446 39,185,506
TOTAL CURRENT ASSETS 144,447,281 134,952,682 124,150,396 118,305,883 108,890,078 105,458,359 102,251,996 99,315,202 96,715,498 98,501,462 103,030,379 109,217,999 115,621,536
TOTAL ASSETS 163,906,541 155,693,958 144,806,087 138,815,891 130,594,400 126,975,998 123,582,950 120,459,472 117,673,083 119,272,363 123,614,596 129,615,532 135,832,384
CURRENT LIABILITIES
TRADE AND OTHER PAYABLES ### ### ### - - - - - - - - - -
SHORT TERM LOAN ### ### ### ### ### ### ### ### 6,160,000 1,160,000 - - -
SHARE HOLDERS ACCOUNT 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000
TAX PAYABLE/INCOME TAX PROVISION 6,122,356 7,655,800 9,286,657 ### ### ### ### ### ### 20,402,164 22,052,834 23,853,115 25,718,171
TOTAL CURRENT LIABILITIES 110,754,541 97,797,256 81,937,385 69,996,816 58,458,775 50,373,255 42,355,340 34,418,297 26,582,380 23,562,164 24,052,834 25,853,115 27,718,171
TOTAL ASSETS LESS CURRENT LIABILITIES 53,152,000 57,896,702 62,868,702 68,819,074 72,135,625 76,602,743 81,227,610 86,041,175 91,090,703 95,710,199 99,561,762 103,762,417 108,114,214
LONG TERM LIABILITIES
MEDIUM TERMLOANS - - - - - - - - - - - -
LONG TERM LOANS
TOTAL LONG TERM LIABILITIES - - - - - - - - - - - - -
NET ASSET 53,152,000 57,896,702 62,868,702 68,819,074 72,135,625 76,602,743 81,227,610 86,041,175 91,090,703 95,710,199 99,561,762 103,762,417 108,114,214
SHAREHOLDERS CAPITAL
PAID UP CAPITAL ### ### ### ### ### ### ### ### ### 23,165,000 23,165,000 23,165,000 23,165,000
GENERAL RESERVE ### ### ### ### ### ### ### ### ### 72,545,199 76,396,762 80,597,417 84,949,214
LEGAL RESERVE
UNALLOCATED PROFIT
TOTAL CAPITAL 53,152,000 57,896,702 62,868,702 68,819,074 72,135,625 76,602,743 81,227,610 86,041,175 91,090,703 95,710,199 99,561,762 103,762,417 108,114,214
(0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0)
PROJECTED BALANCE SHEET
For the Budget Year 2016/2017
30 June 2016
(Actual + Qtr 1 - as of 30 Qtr 2 - as of 31 Qtr 3 - as of 31 Qtr 4 - as of 30
DESCRIPTION Estimate) Sep, 2016 Dec, 2016 Mar, 2017 June, 2017
NON-CURRENT ASSETS
NET FIXED ASSETS 19,459,260 20,510,007 21,330,954 20,770,901 20,210,848
TOTAL FIXED ASSETS 19,459,260 20,510,007 21,330,954 20,770,901 20,210,848
CURRENT ASSETS
STOCKS 52,855,962 33,979,163 27,489,450 21,045,126 9,274,075
TRADE & OTHER RECEIVABLES 84,799,063 84,141,847 68,091,833 67,119,761 67,161,955
CASH ON HAND & AT BANK 6,792,256 184,873 6,670,714 10,336,574 39,185,506
TOTAL CURRENT ASSETS 144,447,281 118,305,883 102,251,996 98,501,462 115,621,536
TOTAL ASSETS 163,906,541 138,815,891 123,582,950 119,272,363 135,832,384
CURRENT LIABILITIES
TRADE AND OTHER PAYABLES 43,472,185 - - - -
SHORT TERM LOAN 59,160,000 56,160,000 26,160,000 1,160,000 -
INTEREST PAYABLE 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000
TAX PAYABLE/INCOME TAX PROVISION 6,122,356 11,836,816 14,195,340 20,402,164 25,718,171
TOTAL CURRENT LIABILITIES 110,754,541 69,996,816 42,355,340 23,562,164 27,718,171
TOTAL ASSETS LESS CURRENT LIABILITIES 53,152,000 68,819,074 81,227,610 95,710,199 108,114,214
LONG TERM LIABILITIES - - - -
MEDIUM TERMLOANS - - - -
LONG TERM LOANS - - - -
TOTAL LONG TERM LIABILITIES - - - - -
NET ASSET 53,152,000 68,819,074 81,227,610 95,710,199 108,114,214
SHAREHOLDERS CAPITAL
PAID UP CAPITAL 23,165,000 23,165,000 23,165,000 23,165,000 23,165,000
GENERAL RESERVE 29,987,000 45,654,074 58,062,610 72,545,199 84,949,214
LEGAL RESERVE
UNALLOCATED PROFIT
TOTAL CAPITAL 53,152,000 68,819,074 81,227,610 95,710,199 108,114,214
Forecasted Income Statement
Description Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total %age
1. Sales Revenues
1.1 Export Sales
Agricultural Products 6,463,934 7,065,616 8,970,869 8,619,933 10,955,032 24,022,470 26,649,995 31,419,930 34,243,311 31,848,477 16,068,079 10,922,769 217,250,415 32.89
Opal - -
Total Export Sales 6,463,934 7,065,616 8,970,869 8,619,933 10,955,032 24,022,470 26,649,995 31,419,930 34,243,311 31,848,477 16,068,079 10,922,769 217,250,415 32.89
1.2 Local Sales -
Ceramics and Tiles 6,141,229 6,857,916 7,143,627 ### ### ### ### ### ### ### ### ### 97,453,764 14.75
Door Locks 1,481,440 1,654,264 1,723,360 ### ### ### ### ### ### ### ### ### 23,043,338 3.49
Sanitary Wares and Fixtures 3,456,742 3,860,101 4,021,248 ### ### ### ### ### ### ### ### ### 53,771,082 8.14
Plywood 1,316,604 1,470,907 1,532,081 ### ### ### ### ### ### ### ### ### 20,484,965 3.10
PPR-C and HDPE Pipes and Fittings 3,127,552 3,492,352 3,638,272 ### ### ### ### ### ### ### ### ### 48,644,864 7.36
Tender Sales 49,392,200 49,392,200 50,392,200 ### ### ### ### ### ### ### ### ### 192,176,600 29.10
Others 493,824 551,424 574,464 595,968 619,008 644,352 663,552 678,144 692,736 707,328 722,688 737,280 7,680,768 1.16
Total Local Sales 65,409,591 67,279,164 69,025,252 23,331,109 26,078,084 28,900,216 29,522,874 27,996,652 26,470,039 26,577,373 26,089,504 26,575,523 443,255,381 67.11
Total Sales Revenues 71,873,525 74,344,780 77,996,121 31,951,043 37,033,116 52,922,687 56,172,869 59,416,582 60,713,349 58,425,850 42,157,584 37,498,292 660,505,796 100.00
2. Cost of Sales
2.1 COS - Export Sales
Agricultural Products 6,370,120 6,965,137 8,734,360 8,502,959 10,647,705 23,580,668 26,030,228 30,709,444 33,813,785 31,459,089 16,022,917 10,915,444 213,751,856 32.36
Opal
Total COS - Export Sales 6,370,120 6,965,137 8,734,360 8,502,959 10,647,705 23,580,668 26,030,228 30,709,444 33,813,785 31,459,089 16,022,917 10,915,444 213,751,856 32.36
2.2 COS - Local Sales
Ceramics and Tiles 4,349,319 4,859,617 5,062,085 5,248,901 5,451,799 5,674,994 5,844,190 5,972,626 6,101,302 6,821,749 6,961,896 7,108,847 69,457,326 10.52
Door Locks 1,016,234 1,134,665 1,181,928 1,226,465 1,273,830 1,326,060 1,365,471 1,395,616 1,425,529 1,456,082 1,487,398 1,517,560 15,806,838 2.39
Sanitary Wares and Fixtures 2,108,488 2,380,786 2,437,382 2,538,302 2,642,809 2,758,527 2,808,352 2,876,529 2,941,393 3,005,188 3,045,424 3,105,776 32,648,957 4.94
Plywood 966,231 1,079,471 1,124,366 1,166,580 1,211,474 1,261,059 1,298,582 1,327,395 1,356,208 1,384,350 1,414,503 1,443,316 15,033,533 2.28
PPR-C and HDPE Pipes and Fittings 1,876,531 2,095,411 2,182,963 2,264,678 2,352,230 2,448,538 2,521,498 2,576,947 2,632,397 2,687,846 2,746,214 2,801,664 29,186,918 4.42
Tender Goods 45,100,824 45,100,824 45,850,824 3,000,000 4,500,000 6,000,000 6,000,000 4,500,000 3,000,000 2,250,000 1,500,000 1,500,000 168,302,472 25.48
Others 370,368 413,568 430,848 446,976 464,256 483,264 497,664 508,608 519,552 530,496 542,016 552,960 5,760,576 0.87
Total COS - Local Sales 55,787,996 57,064,342 58,270,396 15,891,902 17,896,399 19,952,441 20,335,757 19,157,721 17,976,380 18,135,712 17,697,452 18,030,122 336,196,621 50.90
Total Cost of Sales 62,158,117 64,029,480 67,004,756 24,394,861 28,544,103 43,533,109 46,365,985 49,867,165 51,790,166 49,594,801 33,720,369 28,945,566 549,948,477 83.26
3. Gross Profit 9,715,408 10,315,300 10,991,365 7,556,181 8,489,013 9,389,578 9,806,884 9,549,417 8,923,184 8,831,049 8,437,215 8,552,726 110,557,319 16.74
4. Operating Expenses
4.1 Selling and Distribution Expenses
Salary 178,039 178,039 178,039 178,039 178,039 178,039 178,039 178,039 178,039 178,039 178,039 178,039 2,136,466 0.32
Salary Increment 15,330 15,330 15,330 15,330 15,330 15,330 15,330 15,330 15,330 15,330 15,330 15,330 183,956 0.03
Employer Pension Contribution 21,271 21,271 21,271 21,271 21,271 21,271 21,271 21,271 21,271 21,271 21,271 21,271 255,246 0.04
Bonus and Incentive - 50,000 87,016 - - 50,000 87,016 - 87,016 50,000 - 87,016 498,063 0.08
Uniform & Safety Matrials - - 30,000 - - - - - - - - - 30,000 0.00
Medical Expense 13,750 13,750 13,750 13,750 13,750 13,750 13,750 13,750 13,750 13,750 13,750 13,750 165,000 0.02
GPA Insurance 21,365 - - - - - - - - - - - 21,365 0.00
Accredetation Expense - - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 50,000 0.01
Promotional Expense 197,114 197,114 197,114 197,114 197,114 197,114 197,114 197,114 197,114 197,114 197,114 197,114 2,365,369 0.36
Sales Commission Expense 164,608 183,817 191,489 198,660 206,336 214,785 221,184 226,053 230,916 235,774 240,895 245,755 2,560,272 0.39
Business travel Expense - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 60,000 0.01
Loading and Unloading 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 18,000 0.00
Freight Expense 44,270 45,535 46,717 15,791 17,650 19,560 19,981 18,948 17,915 17,988 17,658 17,987 300,000 0.05
Fuel & Lubricant 21,582 21,582 21,582 21,582 21,582 21,582 21,582 21,582 21,582 21,582 21,582 21,582 258,984 0.04
Repair and Maintenance - Vehicles 14,542 14,542 14,542 14,542 14,542 14,542 14,542 14,542 14,542 14,542 14,542 14,542 174,500 0.03
Repair and Maintenance - Others 50,000 - - 50,000 - - 50,000 - - 50,000 - 50,000 250,000 0.04
Bid Bond Expense 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 0.00
Bank Service Charges 303,952 312,639 320,753 108,417 121,182 134,296 137,190 130,098 123,004 123,502 121,235 123,494 2,059,763 0.31
Water & Electricity Expense 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 0.00
Telephone Expense 13,700 13,700 13,700 13,700 13,700 13,700 13,700 13,700 13,700 13,700 13,700 13,700 164,400 0.02
Show Room Rent 478,560 - - 478,560 - - 478,560 - - 478,560 - - 1,914,240 0.29
Postal & Mail service expense 1,370 1,370 1,370 1,370 1,370 1,370 1,370 1,370 1,370 1,370 1,370 1,370 16,440 0.00
Description Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total %age
Miscellaneous expense 77,148 54,109 53,958 71,432 41,768 45,442 74,206 43,265 47,452 72,301 43,499 50,722 675,303 0.10
Total Sales and Distribution Expenses 1,620,099 1,136,297 1,220,130 1,413,057 877,133 954,280 1,558,334 908,561 996,500 1,518,322 913,484 1,065,171 14,181,368 2.15
4.2 General and Administrative Expenses

Salary 302,030 302,030 302,030 302,030 302,030 302,030 302,030 302,030 302,030 302,030 302,030 302,030 3,624,365 0.55
Salary Increment 27,961 27,961 27,961 27,961 27,961 27,961 27,961 27,961 27,961 27,961 27,961 27,961 335,532 0.05
Employer Pension Contribution 33,223 33,223 33,223 33,223 33,223 33,223 33,223 33,223 33,223 33,223 33,223 33,223 398,680 0.06
Bonus and Incentive - 140,000 148,496 - - 140,000 148,496 - 148,496 140,000 - 148,496 1,013,985 0.15
Uniform & Safety Materials 17,500 - - - - - 17,500 - - - - - 35,000 0.01
Medical Expense 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 200,000 0.03
GPA Insurance 36,244 - - - - - - - - - - - 36,244 0.01
Training & Education - 50,000 - - 50,000 - - 50,000 - - 50,000 - 200,000 0.03
Bussiness Travel Expense - 182,583 - 182,583 - 182,583 - 182,583 - 182,583 182,583 - 1,095,500 0.17
Wages for Daily Labourers 10,000 10,000 - - 10,000 - - 10,000 - 10,000 - - 50,000 0.01
Freight Expense - 50,000 - - 50,000 - - 50,000 - - 50,000 - 200,000 0.03
Repair & Maintenance Vehicles 16,542 16,542 16,542 16,542 16,542 16,542 16,542 16,542 16,542 16,542 16,542 16,542 198,500 0.03
Repair & Maintenance Others 25,000 - - 25,000 - - 25,000 - - 25,000 - - 100,000 0.02
Fuel & Lubricants 26,554 26,554 26,554 26,554 26,554 26,554 26,554 26,554 26,554 26,554 26,554 26,554 318,648 0.05
Stationary & Office Supplies 30,000 - - 30,000 - - 30,000 - 30,000 - 30,000 - 150,000 0.02
Cleaning & Sanitary Expense 24,000 - - 24,000 - - 24,000 - 24,000 - 24,000 - 120,000 0.02
Bank Service Charge - - - - - - - - - - - - - -
Property Insurance - 86,000 - - - - - - - - - - 86,000 0.01
Water & Electricity expense 2,250 2,250 2,250 2,250 2,250 2,250 2,250 2,250 2,250 2,250 2,250 2,250 27,000 0.00
Telephone Expense 25,250 25,250 25,250 25,250 25,250 25,250 25,250 25,250 25,250 25,250 25,250 25,250 303,000 0.05
Office & Guest House Rent - 300,000 - - - 300,000 - - - 300,000 - - 900,000 0.14
Parking Expense 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 0.00
Advertisement Expense - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - - 25,000 0.00
Printing and Pbulishing 40,000 40,000 - - - - - - - - - - 80,000 0.01
License and Registration 10,000 - - 10,000 - - - - - - - - 20,000 0.00
Security Service Expense - 52,000 - - - 52,000 - - - - 52,000 - 156,000 0.02
Donation 12,500 12,500 12,500 12,500 12,500 12,500 12,500 12,500 12,500 12,500 12,500 12,500 150,000 0.02
Postal & Mail Service Expense 2,525 2,525 2,525 2,525 2,525 2,525 2,525 2,525 2,525 2,525 2,525 2,525 30,300 0.00
Subscribtion & Other service 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 0.00
Entertainment Expense 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 45,000 0.01
Legal & Court Fee 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 66,000 0.01
Professional Service Fee 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 0.00
Miscellaneous Expense 33,525 69,667 31,312 37,717 29,388 57,867 36,137 38,767 34,012 57,017 43,317 31,312 500,038 0.08
Depreciation Expense 186,684 186,684 186,684 186,684 186,684 186,684 186,684 186,684 186,684 186,684 186,684 186,684 2,240,212 0.34
Total General and Administrative Expenses 890,705 1,649,687 844,245 978,737 803,824 1,401,887 945,570 1,000,787 900,945 1,384,037 1,096,337 844,245 12,741,003 1.93
Total Operating Expenses 2,510,804 2,785,984 2,064,375 2,391,793 1,680,957 2,356,167 2,503,904 1,909,347 1,897,445 2,902,358 2,009,821 1,909,416 26,922,371 4.08
5. Operating Income 7,204,604 7,529,316 8,926,990 5,164,388 6,808,056 7,033,411 7,302,980 7,640,070 7,025,739 5,928,691 6,427,394 6,643,311 83,634,948 12.66
6. Other Income -
7. Other Expenses (Interest) 426,458 426,458 426,458 426,458 426,458 426,458 426,458 426,458 426,458 426,458 426,458 426,458 5,117,500 0.77
8. Net Income Before Tax 6,778,146 7,102,858 8,500,532 4,737,930 6,381,597 6,606,952 6,876,522 7,213,611 6,599,280 5,502,233 6,000,936 6,216,852 78,517,448 11.89
9. Income Tax (30%) 2,033,444 2,130,857 2,550,159 1,421,379 1,914,479 1,982,086 2,062,956 2,164,083 1,979,784 1,650,670 1,800,281 1,865,056 23,555,235 3.57
10. Net Income After Tax 4,744,702 4,972,000 5,950,372 3,316,551 4,467,118 4,624,867 4,813,565 5,049,528 4,619,496 3,851,563 4,200,655 4,351,797 54,962,214 8.32
EKT Import and Export
Description Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total %age
1. Sales Revenues
1.1 Export Sales 22,500,418 43,597,436 92,313,235 58,839,325 217,250,415 32.89
1.2 Local Sales 201,714,007 78,309,409 83,989,564 79,242,401 443,255,381 67.11
Total Sales Revenues 224,214,425 121,906,845 176,302,800 138,081,726 660,505,796 100.00
2. Cost of Sales
2.1 COS - Export Sales 22,069,617 42,731,331 90,553,458 58,397,450 213,751,856 32.36
2.2 COS - Local Sales 171,122,735 53,740,742 57,469,858 53,863,286 336,196,621 50.90
Total Cost of Sales 193,192,352 96,472,073 148,023,316 112,260,736 549,948,477 83.26
3. Gross Profit 31,022,073 25,434,772 28,279,484 25,820,990 110,557,319 16.74
4. Operating Expenses
4.1 Selling and Distribution Expenses 3,976,527 3,244,470 3,463,395 3,496,976 14,181,368 2.15
4.2 General and Administrative Expenses 3,384,636 3,184,447 2,847,301 3,324,618 12,741,003 1.93
Total Operating Expenses 7,361,163 6,428,917 6,310,696 6,821,594 26,922,371 4.08
5. Operating Income 23,660,910 19,005,855 21,968,788 18,999,396 83,634,948 12.66
6. Other Income
7. Other Expenses (Interest) 1,279,375 1,279,375 1,279,375 1,279,375 5,117,500 0.77
8. Net Income Before Tax 22,381,535 17,726,480 20,689,413 17,720,021 78,517,448 11.89
9. Income Tax (30%) 6,714,460 5,317,944 6,206,824 5,316,006 23,555,235 3.57
10. Net Income After Tax 15,667,074 12,408,536 14,482,589 12,404,015 54,962,214 8.32
Annual Business Plan for the Budget Year of 2016/2017
Ratios
Cumulative
Particular Formula Unit Ham Neh Mesk Tik Hid Tah Tir Yek Meg Miaz Ginb Sene 12 Months
1 LIQUIDITY RATIOS:
Current Assets Ratio 1.38 1.52 1.69 1.86 2.09 2.41 2.89 3.64 4.18 4.28 4.22 4.17 4.17
1.1 Current Ratio Current Liabilities
Current Assets-
Inventory Ratio 0.89 1.03 1.20 1.33 1.53 1.77 2.18 2.83 3.29 3.55 3.66 3.84 3.84
1.2 Quick Ratio Current Liabilities
Cash & Cash
Equivalents Ratio 0.04 0.01 0.00 0.20 0.20 0.16 0.20 0.29 0.44 0.75 1.07 1.41 1.41
1.3 Cash Position Ratio Current Liabilities
2 ASSETS MANAGEMENT/EFFECIENCY:
365 Days 420 410 394 752 660 470 444 416 404 420 580 654 37
2.1 Average Collection Period A/R Turnover
Sales Frequency 0.87 0.89 0.93 0.49 0.55 0.78 0.82 0.88 0.90 0.87 0.63 0.56 9.83
2.2 Accounts Receivable turnover Accounts Receivables

Cost of Sales Frequency 1.29 1.62 1.97 0.78 1.01 1.58 1.91 2.33 2.46 2.79 2.32 3.12 59.30
2.3 Inventory Turnover Inventory
365 Days 283 225 185 467 362 230 191 156 148 131 157 117 6
2.4 Average Age of Inventory Inventory Turnover
Sales Frequency 3.47 3.60 3.80 1.47 1.72 2.48 2.66 2.84 2.92 2.84 2.07 1.86 32.68
2.5 Fixed Asset Turnover Fixed Assets
Sales Frequency 0.46 0.51 0.56 0.24 0.29 0.43 0.47 0.50 0.51 0.47 0.33 0.28 4.86
2.6 Total Assets Turnover Total Assets
Sales Frequency 0.53 0.60 0.66 0.29 0.35 0.52 0.57 0.61 0.62 0.57 0.39 0.32 5.71
2.7 Current Assets Turnover Current Assets
Cost of Goods Slod Frequency 2.14 4.42 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
2.8 Accounts Payable Turnover Accounts Payable
365 Days 170 83 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
2.9 Averge Payment Period A/P Turnover
3 DEBT MANAGEMENT RATIOS:
Total Debt Ratio 0.63 0.57 0.50 0.45 0.40 0.34 0.29 0.23 0.20 0.19 0.20 0.20 0.20
3.1 Total Debt to Total Assets Ratio Total Assets
Owners Equity Ratio 0.37 0.43 0.50 0.55 0.60 0.66 0.71 0.77 0.80 0.81 0.80 0.80 0.80
Total Equity(Total
3.2 Total Owners Equity to Total Assets Ratio Assets)
EBIT Ratio 16.92 15.47 12.90 14.07 15.34
3.3 Interest Coverage(Times Interest Earned) Interest Expense
Annual Business Plan for the Budget Year of 2016/2017
Ratios
Cumulative
Particular Formula Unit Ham Neh Mesk Tik Hid Tah Tir Yek Meg Miaz Ginb Sene 12 Months
Total Debt Ratio 1.69 1.30 1.02 0.81 0.66 0.52 0.40 0.29 0.25 0.24 0.25 0.26 0.26
3.4 Debt Equity Ratio Owners Equity
Long-Term Debt
3.5 Long-term Debt Ratio Owners Equity
4 PROFITABILITY RATIOS
Gross Profit Percentage 13.52 13.87 14.09 23.65 22.92 17.74 17.46 16.07 14.70 15.11 20.01 22.81 16.74
4.1 Gross Profit Margin (%) Sales
Cost of Goods Sold Percentage 86.48 86.13 85.91 76.35 77.08 82.26 82.54 83.93 85.30 84.89 79.99 77.19 83.26
4.2 Cost of Goods Sold Margin Sales
Operating Expense Percentage 3.49 3.75 2.65 7.49 4.54 4.45 4.46 3.21 3.13 4.97 4.77 5.09 4.08
4.3 Operating Expense Margin Sales
Operating Profit Percentage 10.02 10.13 11.45 16.16 18.38 13.29 13.00 12.86 11.57 10.15 15.25 17.72 12.66
4.4 Operating Profit Margin Sales
Net income Percentage 6.60 6.69 7.63 10.38 12.06 8.74 8.57 8.50 7.61 6.59 9.96 11.61 8.32
4.5 Net Profit Margin Sales
4.6 Return on Investment/Total Assets Total Assets
4.7 Return on Owners Equity Owners Equity
5 CASH POSITION RATIOS
Cash Ratio 0.06 0.02 0.00 0.37 0.27 0.13 0.12 0.13 0.17 0.31 0.66 1.04 0.06
5.1 Cash Sales Ratios Sales
Cash Ratio 0.026 0.008 0.001 0.091 0.080 0.054 0.056 0.065 0.087 0.147 0.214 0.288 0.288
5.2 Cash Assets Ratio Assets
Forecasted Cost of Sales for Building Materials

S/N Ceramics and Tiles UOM AUC Hamle Nehase Meskerem Tikmt Hidar Tahsas Tir Yekatit Megabit Miaziya Genbot Sene Total
1.1 Internal wall tile 20x30 M2
100.36 416,514 444,917 462,681 502,627 522,097 543,475 559,634 571,979 584,223 596,668 609,615 621,960 6,436,391
1.2 Rustic Floor Tile 300x300x10mm M2
180.99 993,106 1,259,707 1,214,278 1,198,532 1,244,866 1,295,906 1,334,457 1,363,778 1,393,099 1,422,782 1,453,731 1,483,052 15,657,295
1.3 Rustic Floor Tile 300x300x8mm M2
152.79 337,659 376,925 393,121 407,483 423,220 440,637 453,624 463,708 473,639 483,723 494,113 504,197 5,252,050
1.4 Porcelain Floor Tile (Polished) M2
210.71 623,706 675,331 726,112 752,662 781,740 813,768 838,000 856,543 874,875 893,417 912,803 931,345 9,680,303
1.5 Porcelain Floor Tile (Matt) M2
211.68 848,856 904,952 966,764 1,024,342 1,064,139 1,107,534 1,140,557 1,165,536 1,190,727 1,216,129 1,235,180 1,265,875 13,130,591
1.6 External Wall Tile (Clicker) M2
158.73 652,399 664,780 743,671 787,482 817,642 851,135 876,850 895,898 915,422 934,947 955,265 974,471 10,069,962
1.7 PVC Tile M2
125.55 192,545 215,085 224,292 232,387 241,435 251,277 258,737 264,452 270,166 827,801 845,738 862,881 4,686,797
Sub Total 4,064,785 4,541,698 4,730,920 4,905,515 5,095,139 5,303,733 5,461,860 5,581,894 5,702,151 6,375,467 6,506,445 6,643,782 64,913,389
Door Locks -
2.1 Door Lock Pcs
514.73 935,265 1,023,798 1,044,902 1,128,803 1,172,555 1,220,425 1,256,971 1,284,252 1,312,047 1,340,357 1,369,182 1,396,977 14,485,534
2.2 Hinges Set
124.57 80,970 110,866 137,026 97,662 101,275 105,635 108,500 111,365 113,482 115,725 118,216 120,583 1,321,304
Sub Total
1,016,234 1,134,665 1,181,928 1,226,465 1,273,830 1,326,060 1,365,471 1,395,616 1,425,529 1,456,082 1,487,398 1,517,560 15,806,838
Sanitary Ware and Fixtures -
3.1 Hand Wash Basin W/Full Accessories Set
1,191.90 277,712 293,206 301,550 334,923 348,034 362,336 368,296 379,023 387,366 392,134 398,093 404,053 4,246,726
3.2 Water Closet W/Full Accessories Set
1,594.57 258,320 294,995 312,535 310,941 323,697 336,454 341,237 350,805 358,778 363,561 368,345 373,129 3,992,797
3.3 WC Turkish Type With Plastic Cistern
Set
862.17 99,150 120,704 125,877 119,842 124,153 133,637 125,015 134,499 138,810 138,810 133,637 138,810 1,532,943
3.4 Urinals Pcs
465.90 70,817 77,805 82,464 85,259 88,987 92,248 95,043 96,907 99,236 101,566 103,429 105,759 1,099,520
3.5 Soft Holder Pcs
90.92 16,276 18,367 19,276 19,640 20,367 21,367 21,731 22,277 22,822 23,186 23,640 24,186 253,135
3.6 Soap Holder Pcs
85.40 15,286 17,250 18,019 18,360 19,214 20,068 20,410 20,922 21,349 21,776 22,203 22,716 237,575
3.7 Crystal Glass Mirror Pcs
112.95 20,445 22,817 23,946 24,398 25,641 26,657 26,996 27,787 28,352 28,803 29,368 30,046 315,255
3.8 Shower Tray W/Full Accessories Pcs
798.84 279,594 312,346 323,530 337,110 350,691 365,070 375,455 383,443 392,230 400,219 408,207 416,994 4,344,888
3.9 Bath Tub W/Full Accessories Set
2,414.88 103,840 115,914 120,744 125,574 130,403 135,233 140,063 142,478 144,893 149,722 152,137 154,552 1,615,554
3.1 Kitchen Sink W/Full Accessories Set
1,599.86 71,994 79,993 83,193 86,393 89,592 94,392 95,992 97,592 100,791 102,391 103,991 107,191 1,113,504
3.11 Fire Extenguisher Pcs
660.57 42,277 48,222 50,204 50,864 52,846 55,488 56,809 58,131 59,452 60,773 62,094 63,415 660,574
3.12 Water Heater 50Ltr. Pcs
2,205.34 330,800 357,264 377,112 399,166 414,603 432,246 438,862 452,094 463,120 471,942 476,352 487,379 5,100,940
2,595.92 155,755 173,927 173,927 186,906 194,694 202,482 207,674 212,865 218,057 220,653 225,845 231,037 2,403,822
2,937.64 102,817 114,568 120,443 123,381 129,256 135,132 138,069 141,007 143,944 146,882 149,820 152,757 1,598,077
3.15 Shower Box Pcs
4,103.51 49,242 53,346 57,449 57,449 61,553 65,656 65,656 65,656 65,656 69,760 69,760 69,760 750,943
3.16 Shower Panel Pcs
5,491.40 109,828 170,233 126,302 131,794 137,285 142,776 148,268 148,268 148,268 159,251 159,251 164,742 1,746,266
3.17 Bathroon Cabinet Pcs
6,311.04 82,371 87,862 93,354 98,845 104,337 109,828 109,828 109,828 115,319 120,811 120,811 120,811 1,274,005
3.18 Jacuzzi Pcs
32,088.35 21,966 21,966 27,457 27,457 27,457 27,457 32,948 32,948 32,948 32,948 38,440 38,440 362,433
Sub Total 2,108,488 2,380,786 2,437,382 2,538,302 2,642,809 2,758,527 2,808,352 2,876,529 2,941,393 3,005,188 3,045,424 3,105,776 32,648,957
Plywood -
4.1 Plywood Pcs
670.06 966,231 1,079,471 1,124,366 1,166,580 1,211,474 1,261,059 1,298,582 1,327,395 1,356,208 1,384,350 1,414,503 1,443,316 15,033,533
PPR-C -
PPR-C and HDPE Pipes and Fittings
1,876,531 2,095,411 2,182,963 2,264,678 2,352,230 2,448,538 2,521,498 2,576,947 2,632,397 2,687,846 2,746,214 2,801,664 29,186,918
Others
370,368 413,568 430,848 446,976 464,256 483,264 497,664 508,608 519,552 530,496 542,016 552,960 5,760,576
Total 10,402,637 11,645,600 12,088,408 12,548,516 13,039,739 13,581,180 13,953,426 14,266,988 14,577,230 15,439,429 15,742,001 16,065,058 163,350,212
Forecasted Cash Flow Statement
For theBudget Year Ending June 30, 2017
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total
Beginning cash balance 6,792,256 4,017,087 1,186,565 184,873 11,835,034 10,165,466 6,670,714 6,752,231 7,618,547 10,336,574 18,116,379 27,727,446 6,792,256
Add: Receipts
Cash sales 45,709,688 47,433,114 50,386,020 22,618,599 26,601,883 41,362,600 44,363,719 48,217,921 50,125,334 47,794,901 31,721,782 26,868,083 483,203,644
Collection from credit sales 28,267,317 26,163,836 26,911,666 27,610,101 9,332,444 10,431,233 11,560,087 11,809,149 11,198,661 10,588,015 10,630,949 10,435,802 194,939,260
Other cash income
Total Cash available 80,769,261 77,614,038 78,484,251 50,413,573 47,769,360 61,959,300 62,594,520 66,779,302 68,942,542 68,719,491 60,469,110 65,031,331 684,935,159
Less: Cash Disbursements
Operating Costs
Settlement of Trade & Other Payables 14,490,728 14,490,728 14,490,728 43,472,185
Settlement of Tax Payables 500,000 500,000 2,959,420 3,959,420
Advance and Staff Loans -
Purchase of Goods 56,661,582 54,341,918 60,347,364 20,419,345 24,702,573 40,080,306 40,162,296 43,435,899 47,240,593 42,472,017 28,656,057 22,469,883 480,989,836
Operating Expenses for Export Activities 880,585 967,968 1,116,136 1,187,207 980,590 2,612,338 2,936,315 3,575,735 4,228,155 3,828,962 1,836,012 1,226,752 25,376,754
Selling and Distribution Expenses 1,620,099 1,136,297 1,220,130 1,413,057 877,133 954,280 1,558,334 908,561 996,500 1,518,322 913,484 1,065,171 14,181,368
General and Administrative Expenses 704,021 1,463,002 657,561 792,052 617,140 1,215,202 758,886 814,102 714,261 1,197,352 909,652 657,561 10,500,791
Other Expenses -
Sub Total 74,857,015 72,899,914 77,831,919 26,771,081 27,177,436 44,862,127 45,415,830 48,734,296 53,179,509 49,016,653 32,315,206 25,419,367 578,480,353
Fixed Assets Purchase
Motor Vehicles 1,290,000 - - 1,240,000 - - - - - - - - 2,530,000
Computers & Accessories 27,000 43,500 36,000 36,000 - - - - - - - - 142,500
Office Furniture, Fixture, & Equipment 151,700 57,600 5,000 105,000 - - - - - - - - 319,300
Others - - - - - - - - - - - - -
Sub Total 1,468,700 101,100 41,000 1,381,000 - - - - - - - - 2,991,800
Total Disbursements 76,325,715 73,001,014 77,872,919 28,152,081 27,177,436 44,862,127 45,415,830 48,734,296 53,179,509 49,016,653 32,315,206 25,419,367 581,472,153
Net Cash Balance (Surplus/Deficit) 4,443,546 4,613,024 611,332 22,261,492 20,591,925 17,097,172 17,178,690 18,045,005 15,763,033 19,702,837 28,153,904 39,611,964 103,463,006
Required Cash Balance 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000
Financing
Loan from Banks/Other Sources -
Equity Financing -
Sub Total - - - - - - - - - - - - -
Repayments
Principal 3,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 5,000,000 1,160,000 59,160,000
Interests 426,458 426,458 426,458 426,458 426,458 426,458 426,458 426,458 426,458 426,458 426,458 426,458 5,117,500
Sub Total 426,458 3,426,458 426,458 10,426,458 10,426,458 10,426,458 10,426,458 10,426,458 5,426,458 1,586,458 426,458 426,458 64,277,500
Total Financing (426,458) (3,426,458) (426,458) (10,426,458) (10,426,458) (10,426,458) (10,426,458) (10,426,458) (5,426,458) (1,586,458) (426,458) (426,458) (64,277,500)
Cash Balance Ending 4,017,087 1,186,565 184,873 11,835,034 10,165,466 6,670,714 6,752,231 7,618,547 10,336,574 18,116,379 27,727,446 39,185,506 39,185,506
Forecasted Cash Flow Statement
For theBudget Year Ending June 30, 2017
Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total
Beginning cash balance 6,792,256 184,873 6,670,714 10,336,574 6,792,256
Add: Receipts
Cash sales 143,528,822 90,583,082 142,706,974 106,384,766 483,203,644
Collection from credit sales 81,342,819 47,373,778 34,567,897 31,654,766 194,939,260
Other cash income -
Total Cash available 231,663,897 138,141,733 183,945,585 148,376,107 684,935,159
Less: Cash Disbursements
Operating Costs
Settlement of Trade & Other
Payables 43,472,185 - - - 43,472,185
Settlement of Tax Payables 1,000,000 2,959,420 - - 3,959,420
Advance and Staff Loans - - - - -
Purchase of Goods 171,350,865 85,202,225 130,838,788 93,597,958 480,989,836
Operating Expenses for Export Activ 2,964,689 4,780,135 10,740,204 6,891,726 25,376,754
Selling and Distribution Expenses 3,976,527 3,244,470 3,463,395 3,496,976 14,181,368
General and Administrative Expense 2,824,583 2,624,394 2,287,248 2,764,565 10,500,791
Other Expenses - - - - -
Sub Total 225,588,849 98,810,644 147,329,635 106,751,226 578,480,353
Fixed Assets Purchase
Motor Vehicles 1,290,000 1,240,000 - - 2,530,000
Computers & Accessories 106,500 36,000 - - 142,500
Office Furniture, Fixture, & Equipm 214,300 105,000 - - 319,300
Others - - - - -
Sub Total 1,610,800 1,381,000 - - 2,991,800
Total Disbursements 227,199,649 100,191,644 147,329,635 106,751,226 581,472,153
Net Cash Balance (Surplus/Deficit) 4,464,248 37,950,089 36,615,949 41,624,881 103,463,006
Required Cash Balance 250,000 250,000 250,000 250,000 250,000
Financing - - - -
Loan from Banks/Other Sources - - - - -
Equity Financing - - - - -
Sub Total - - - - -
Repayments
Principal 3,000,000 30,000,000 25,000,000 1,160,000 59,160,000
Interests 1,279,375 1,279,375 1,279,375 1,279,375 5,117,500
Sub Total 4,279,375 31,279,375 26,279,375 2,439,375 64,277,500
Total Financing (4,279,375) (31,279,375) (26,279,375) (2,439,375) (64,277,500)
Cash Balance Ending 184,873 6,670,714 10,336,574 39,185,506 39,185,506
Capital Budget for the Year Ending June 30, 2017
S. Description Qty Unit Price
No. (Birr) Hamle Nehase Meskerem Tikmt Hidar Tahsas Tir Yekatit Megabit Miazia Ginbot Sene Total Remark
Office Equipment
1 & Furniture:
Furnitures for
Management - for GM Office &
1.1 Replacement 100,000 100,000 200,000 to maintain std
Office Table
140x75x75 1 each for Sales
1.2 w/drawer 2 7,500 7,500 7,500 15,000 & Import
Office Table 3 for Import, 2

120x75x75 for HR, & 1 for
1.3 w/drawer 6 5,700 17,100 17,100 34,200 Business Dev't
Swivel Chair - for Sales &
1.4 Managerial Type 2 5,000 5,000 5,000 10,000 Import
3 for Import, 2
for Finance, 1 for
Admin, 1 for
Swivel Chair - Store, & 1 for
1.5 Medium Back 8 3,500 14,000 14,000 28,000 Business Dev't
1.6 Guest Chair 2 800 1,600 1,600 for Store
Book Shelf Shelf for Mini Store &

1.8 190x120x40 2 6,500 6,500 6,500 13,000 Business Dev't
2 for finance and

1.9 Dexion Shelf 7 2,500 7,500 5,000 5,000 17,500 5 for store
Sub-Total 151,700 57,600 5,000 105,000 - - - - - - - - 319,300

Capital Budget for the Year Ending June 30, 2017
S. Description Qty Unit Price
No. (Birr) Hamle Nehase Meskerem Tikmt Hidar Tahsas Tir Yekatit Megabit Miazia Ginbot Sene Total Remark
2 Computers and Other Electronic Equipment: -
Each 1 for
Desktop Computer Finance, Store, &
2.1 with UPS 9 12,000 12,000 36,000 36,000 36,000 120,000 Bus Dev't
2.6 Fax Machine 1 7,500 7,500 7,500 for Store
2.7 Printer 2 7,500 7,500 7,500 15,000 1 for Finance
Sub-Total 27,000 43,500 36,000 36,000 - - - - - - - - 142,500
-
3 Motor Vehicles -
for Sales &
3.1 Sedan Car 4 620,000 1,240,000 1,240,000 2,480,000 Export
3.2 Motor Cycle 1 50,000 50,000 50,000 for Export
Sub-Total 1,290,000 - - 1,240,000 - - - - - - - - 2,530,000
4 Civil Work and Construction:

4.1 Production/Warehouse Blocks -
4.2 Fence -
4.3 Office Building -
Sub-Total - - - - - - - - - - - - -
Grand Total 1,468,700 101,100 41,000 1,381,000 - - - - - - - - 2,991,800

Budget Preparation Worksheet for the Year Ending - June 30, 2017
Fuel, Lubricants, Tyre and Tube, and Maintenance for Vehicles and Motor Cycles
Total Tyre & Tube Cost Center Remark

Monthly Consump
Moter Vehicles Fuel for 12 Unit Lubricants Total Fuel & Preventive
S/N Plate No. Qty Consum. Months Price Total Fuel Exp (10%) Lubricants Maintenance Qty Unit Cost Total Cost
1 03-97405 Lifan 1 150 1800 17.00 30,600.00 3,060.00 33,660 15,000.00 4 3,500.00 14,000.00 Sales
2 03-96748 Addis Geely 1 150 1800 17.00 30,600.00 3,060.00 33,660 15,000.00 4 3,500.00 14,000.00 Sales
3 03-92960 Yaris 1 150 1800 17.00 30,600.00 3,060.00 33,660 15,000.00 4 3,500.00 14,000.00 Admin
4 03-88840 Vitz 1 150 1800 17.00 30,600.00 3,060.00 33,660 15,000.00 4 3,500.00 14,000.00 Admin
5 03-81211 Corolla 1 150 1800 17.00 30,600.00 3,060.00 33,660 15,000.00 4 3,500.00 14,000.00 Admin
6 03-05871 Dolphine 1 210 2520 14.50 36,540.00 3,654.00 40,194 15,000.00 4 3,500.00 14,000.00 Sales
7 03-A22365 RAV4 1 220 2640 17.00 44,880.00 4,488.00 49,368 15,000.00 4 3,500.00 14,000.00 Admin
8 03-A23354 Hyundai Eon 1 150 1800 17.00 30,600.00 3,060.00 33,660 15,000.00 4 3,500.00 14,000.00 Admin
9 03-A23355 Hyundai Eon 1 150 1800 17.00 30,600.00 3,060.00 33,660 15,000.00 4 3,500.00 14,000.00 Sales
10 New ISUZU Truck 1 300 3600 17.00 61,200.00 6,120.00 67,320 30,000.00 4 3,500.00 14,000.00 Sales
11 New Sedan Cars 2 150 1800 17.00 61,200.00 6,120.00 67,320 15,000.00 4 3,500.00 14,000.00 Sales
12 New Sedan Cars 2 150 1350 17.00 45,900.00 4,590.00 50,490 15,000.00 4 3,500.00 14,000.00 Admin 9 Months
13 03-1682 Motor Cycle 1 150 1800 17.00 30,600.00 3,060.00 33,660 5,000 Admin
14 03-2345 Motor Cycle 1 150 1800 17.00 30,600.00 3,060.00 33,660 5,000 Admin
Total 525,120.00 52,512.00 577,632.00 205,000.00 168,000.00 - -
Admin & General 289,680.00 28,968.00 318,648.00 107,500.00 91,000.00

Sales & Mkting 235,440.00 23,544.00 258,984.00 97,500.00 77,000.00
525,120.00 52,512.00 577,632.00 205,000.00 168,000.00
Worksheet for the Year Ending June 30, 2017 Budget Preparation
Communication
Unit Cost Postal Exp
S/N Description Qty Per Month Total Tel Exp (10%) Remark
1 GM Office
Fixed Tel Line 1,300.00 15,600.00 1,560.00
Mobile 3,000.00 36,000.00 3,600.00
Mobile
Sub-Total 4,300.00 51,600.00 5,160.00
2 DGM
Fixed Tel Line
Mobile 1,000.00 12,000.00 1,200.00
Sub-Total 1,000.00 12,000.00 1,200.00
3 Import
Fixed Tel Line -
Mobile 1 3,000.00 36,000.00 3,600.00
Mobile-Coordinator 1 300.00 3,600.00 360.00
Mobile-Tender & Customs 2 200.00 4,800.00 480.00
Mobile 3,000.00 36,000.00 3,600.00
Sub-Total 3,000.00 36,000.00 3,600.00
4 Export
Fixed Tel Line 1 300.00 3,600.00 360.00
Mobile 1 1,000.00 12,000.00 1,200.00
Mobile-Officers 3 300.00 10,800.00 1,080.00
Sub-Total 1,600.00 26,400.00 2,640.00
5 Sales and Marketing
Fixed Tel Line
Mobile 1 1,000.00 12,000.00 1,200.00
Mobile-Coordinators 3 600.00 21,600.00 2,160.00
Mobile-Project Sales 6 500.00 36,000.00 3,600.00
Mobile-Show Room Heads 3 300.00 10,800.00 1,080.00
Mobile-Drivers 3 100.00 3,600.00 360.00
Broadband 3 1,500.00 54,000.00 5,400.00
Sub-Total 4,000.00 138,000.00 13,800.00
6 HR & Resources
Fixed Tel Line 2 300.00 7,200.00 720.00
Mobile 1 1,000.00 12,000.00 1,200.00
Mobile-Finance 1 200.00 2,400.00 240.00
Mobile-Admin 1 200.00 2,400.00 240.00
Mobile-Store Head 1 200.00 2,400.00 240.00
Mobile-Genral Service 1 300.00 3,600.00 360.00
Mobile-Store Keeper 1 100.00 1,200.00 120.00
Mobile-Drivers 2 50.00 600.00 60.00
Broaband including Store 14,300.00 171,600.00 17,160.00
Sub-Total 16,650.00 203,400.00 20,340.00
Grand Total 30,550.00 467,400.00 46,740.00
Admin 303,000.00 30,300.00

Sales 164,400.00 16,440.00
467,400.00 46,740.00
Budget Preparation Worksheet for the Year Ending June 30, 2017
Perdiem and Traveling
Field Days Total No. of Total Total Perdiem

S/N Qty Daily Rate Per Trip Days Perdiem Bed Traveling Exp & Traveling Remark
1 GM
USA 1 5625 15 15 84,375.00 20,000.00 104,375.00
Dubai 3 5625 15 45 253,125.00 36,000.00 289,125.00
China 1 5625 30 30 168,750.00 35,000.00 203,750.00
-
2 DGM -
3 Export
Pakistan 1 5625 10 10 56,250.00 20,000.00 76,250.00 Customer Visit
Dubai 1 5625 10 10 56,250.00 12,000.00 68,250.00 Gulf Food Expo
Turkey/China 1 5625 10 10 56,250.00 35,000.00 91,250.00 Global Pulses
4 Dep't Mgrs 3 5250 30 30 157,500.00 105,000.00 262,500.00

5 Accountants -
6 Cashier -
7 Personnel -
832,500.00 - 263,000.00 1,095,500.00
Salary 1,372,155.99 457,385.33 1,829,541.32 2,136,466.00
Salary increment 183,956.40
Employer Pension Contribution 75,407.86 25,135.95 100,543.81 255,246.46
Bonus and Incentive 6,192.04 6,192.04 12,384.08 498,063.36
Uniform & Safety Matrials 800.34 1,000.00 1,800.34 30,000.00
Medical Expense 2,664.04 2,500.00 5,164.04 165,000.00
Insurance Expense (GPA) 14,678.71 4,892.90 19,571.61 21,364.66
Accredetation Expense 4,785.37 1,595.12 6,380.49 50,000.00
Promotional Expense 474,499.99 158,166.66 632,666.65 2,365,368.60
Sales Commission Expense 584,855.40 194,951.80 779,807.20 2,560,272.00
Business Travel Expense 191,679.78 63,893.26 255,573.04 60,000.00
Loading and Unloading 208,532.94 69,510.98 278,043.92 18,000.00
Freight Expense 222,192.97 74,064.32 296,257.29 300,000.00
Fuel & Lubricant 33,622.00 15,000.00 48,622.00 258,984.00
Repair and Maintenance-Vehicles 174,500.00
Repair and Maintenance-Others 250,000.00
Bid Bond Expense 5,950.00 1,983.33 7,933.33 12,000.00
Bank Service Charges 1,287,351.84 429,117.28 1,716,469.12 2,059,762.94
Water & Electricity Expense 1,889.38 629.79 2,519.17 12,000.00
Telephone Expense 6,102.62 7,500.00 13,602.62 164,400.00
Show Room Rent 629,439.15 538,500.00 1,167,939.15 1,914,240.00
Postal & Mail service expense 1,204.00 1,200.00 2,404.00 16,440.00
Miscellaneous expense 1483.45 1,500.00 2,983.45 675,303.23
Sub Total 5,125,487.87 2,054,718.78 7,180,206.65 14,181,367.66
July August September October November December January
178,038.83 178,038.83 178,038.83 178,038.83 178,038.83 178,038.83 178,038.83
15,329.70 15,329.70 15,329.70 15,329.70 15,329.70 15,329.70 15,329.70
21,270.54 21,270.54 21,270.54 21,270.54 21,270.54 21,270.54 21,270.54
50,000.00 87,015.84 50,000.00 87,015.84
30,000.00
13,750.00 13,750.00 13,750.00 13,750.00 13,750.00 13,750.00 13,750.00
21,364.66
10,000.00 10,000.00 10,000.00
197,114.05 197,114.05 197,114.05 197,114.05 197,114.05 197,114.05 197,114.05
164,608 183,817 191,489 198,660 206,336 214,785 221,184
10,000.00 10,000.00 10,000.00
1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00
44,269.91 45,535.26 46,717.03 15,790.75 17,649.93 19,559.98 19,981.40
21,582.00 21,582.00 21,582.00 21,582.00 21,582.00 21,582.00 21,582.00
14,541.67 14,541.67 14,541.67 14,541.67 14,541.67 14,541.67 14,541.67
50,000.00 50,000.00 50,000.00
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
303,951.76 312,639.47 320,753.37 108,417.31 121,182.22 134,296.38 137,189.81
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
13,700.00 13,700.00 13,700.00 13,700.00 13,700.00 13,700.00 13,700.00
478,560.00 478,560.00 478,560.00
1,370.00 1,370.00 1,370.00 1,370.00 1,370.00 1,370.00 1,370.00
77,147.58 54,109.40 53,957.82 71,432.02 41,768.24 45,441.93 74,206.37
1,620,099.15 1,136,297.47 ### 1,500,072.44 877,133.00 954,280.50 1,558,333.86
-
February March April May June
178,038.83 178,038.83 178,038.83 178,038.83 178,038.83
15,329.70 15,329.70 15,329.70 15,329.70 15,329.70
21,270.54 21,270.54 21,270.54 21,270.54 21,270.54
87,015.84 50,000.00 87,015.84
13,750.00 13,750.00 13,750.00 13,750.00 13,750.00
10,000.00 10,000.00
197,114.05 197,114.05 197,114.05 197,114.05 197,114.05
226,053 230,916 235,774 240,895 245,755
10,000.00 10,000.00 10,000.00
1,500.00 1,500.00 1,500.00 1,500.00 1,500.00
18,948.43 17,915.21 17,987.85 17,657.66 17,986.60
21,582.00 21,582.00 21,582.00 21,582.00 21,582.00
14,541.67 14,541.67 14,541.67 14,541.67 14,541.67
50,000.00 50,000.00
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
130,097.61 123,003.59 123,502.37 121,235.29 123,493.77
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
13,700.00 13,700.00 13,700.00 13,700.00 13,700.00
478,560.00
1,370.00 1,370.00 1,370.00 1,370.00 1,370.00
43,264.79 47,452.39 72,301.04 43,499.24 50,722.41
908,560.53 996,500.25 1,518,321.77 913,484.02 ###
General & Administrative expen
Salary 1,360,951.97 453,650.66 1,814,602.63 3,624,365.00
Salary Increment 335,532.00
Employer Pension Contribution 138,823.13 46,274.38 185,097.51 398,680.15
Bonus and Incentive 101,606.46 50,803.23 152,409.69 1,013,984.55
Uniform & Safety Materials 11,600.84 3,866.95 15,467.79 35,000.00
Medical Expense 1,110.60 5,000.00 6,110.60 200,000.00
GPA Insurance 36,243.65
Training & Education 2,173.91 30,000.00 32,173.91 200,000.00
Bussiness Travel Expense 88,421.67 29,473.89 117,895.56 1,095,500.00
Wage/Daily Labour Expense 16,011.00 5,337.00 21,348.00 50,000.00
Transportation Expense 190,606.66 10,000.00 200,606.66 200,000.00
Repair & Maintenance Vehicles 622,640.51 120,000.00 742,640.51 198,500.00
Repair & Maintenance Others 239,789.99 50,000.00 289,789.99 100,000.00
Fuel & Lubricants 99,118.63 33,039.54 132,158.17 318,648.00
Stationary & Office Supplies 13,108.92 10,000.00 23,108.92 150,000.00
Cleaning & Sanitary Expense 197,555.80 35,000.00 232,555.80 120,000.00
Bank Service Charge 131,035.10 43,678.37 174,713.47 -
Property Insurance 36,832.58 12,277.53 49,110.11 86,000.00
Water & Electricity expense 8,196.17 2,732.06 10,928.23 27,000.00
Telephone Expense 8,861.48 10,000.00 18,861.48 303,000.00
Office & Guest House Rent 564,175.00 180,000.00 744,175.00 900,000.00
Parking Expense 6,037.67 2,012.56 8,050.23 12,000.00
Advertisement Expense 176,863.07 5,000.00 181,863.07 25,000.00
Printing and Pbulishing 62,942.84 20,980.95 83,923.79 80,000.00
License and Registration 15,129.75 5,043.25 20,173.00 20,000.00
Security Service Expense 56,704.00 50,000.00 106,704.00 156,000.00
Donation 35,364.58 15,000.00 50,364.58 150,000.00
Postal & Mail Service Expense 95,000.00 30,000.00 125,000.00 30,300.00
Subscribtion & Other service 4,699.39 1,566.46 6,265.85 12,000.00
Entertainment Expense 3,437.82 15,000.00 18,437.82 45,000.00
Legal & Court Fee 98,050.79 32,683.60 130,734.39 66,000.00
Proffessional service 5,551.00 15,000.00 20,551.00 12,000.00
Miscellaneous Expense 91,155.50 30,385.17 121,540.67 500,037.67
Depreciation Expense - -
Penality & demurage - -
Total General and Admin Exp 4,483,556.83 1,353,805.57 5,837,362.40 10,500,791.02
39000
July August September October November December January
302,030.42 302,030.42 302,030.42 302,030.42 302,030.42 302,030.42 302,030.42
27,961.00 27,961.00 27,961.00 27,961.00 27,961.00 27,961.00 27,961.00
33,223.35 33,223.35 33,223.35 33,223.35 33,223.35 33,223.35 33,223.35
140,000.00 148,496.14 140,000.00 148,496.14
17,500.00 17,500.00
16,666.67 16,666.67 16,666.67 16,666.67 16,666.67 16,666.67 16,666.67
36,243.65
50,000.00 50,000.00
182,583.33 182,583.33 182,583.33
10,000.00 10,000.00 10,000.00
50,000.00 50,000.00
16,541.67 16,541.67 16,541.67 16,541.67 16,541.67 16,541.67 16,541.67
25,000.00 25,000.00 25,000.00
26,554.00 26,554.00 26,554.00 26,554.00 26,554.00 26,554.00 26,554.00
30,000.00 30,000.00 30,000.00
24,000.00 24,000.00 24,000.00
- -
86,000.00
2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 2,250.00
25,250.00 25,250.00 25,250.00 25,250.00 25,250.00 25,250.00 25,250.00
300,000.00 300,000.00
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
5,000.00 5,000.00 5,000.00
40,000.00 40,000.00
10,000.00 10,000.00
52,000.00 52,000.00
12,500.00 12,500.00 12,500.00 12,500.00 12,500.00 12,500.00 12,500.00
2,525.00 2,525.00 2,525.00 2,525.00 2,525.00 2,525.00 2,525.00
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
3,750.00 3,750.00 3,750.00 3,750.00 3,750.00 3,750.00 3,750.00
5,500.00 5,500.00 5,500.00 5,500.00 5,500.00 5,500.00 5,500.00
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
33,524.79 69,666.77 31,312.41 37,716.77 29,387.60 57,866.77 36,137.41
704,020.53 1,463,002.20 657,560.65 792,052.20 617,139.70 1,215,202.20 758,885.65

February March April May June
302,030.42 302,030.42 302,030.42 302,030.42 302,030.42 3,624,365.00 -
27,961.00 27,961.00 27,961.00 27,961.00 27,961.00 335,532.00 -
33,223.35 33,223.35 33,223.35 33,223.35 33,223.35 398,680.15 -
148,496.14 140,000.00 148,496.14 1,013,984.55 -
35,000.00 -
16,666.67 16,666.67 16,666.67 16,666.67 16,666.67 200,000.00 -
36,243.65 -
50,000.00 50,000.00 200,000.00 -
182,583.33 182,583.33 182,583.33 1,095,500.00 -
10,000.00 10,000.00 50,000.00 -
50,000.00 50,000.00 200,000.00 -
16,541.67 16,541.67 16,541.67 16,541.67 16,541.67 198,500.00 -
25,000.00 100,000.00 -
26,554.00 26,554.00 26,554.00 26,554.00 26,554.00 318,648.00 -
30,000.00 30,000.00 150,000.00 -
24,000.00 24,000.00 120,000.00 -
- - - -
86,000.00 -
2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 27,000.00 -
25,250.00 25,250.00 25,250.00 25,250.00 25,250.00 303,000.00 -
300,000.00 900,000.00 -
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00 -
5,000.00 5,000.00 25,000.00 -
80,000.00 -
20,000.00 -
52,000.00 156,000.00 -
12,500.00 12,500.00 12,500.00 12,500.00 12,500.00 150,000.00 -
2,525.00 2,525.00 2,525.00 2,525.00 2,525.00 30,300.00 -
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00 -
3,750.00 3,750.00 3,750.00 3,750.00 3,750.00 45,000.00 -
5,500.00 5,500.00 5,500.00 5,500.00 5,500.00 66,000.00 -
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00 -
38,766.77 34,012.41 57,016.77 43,316.77 31,312.41 500,037.67 -
- -
- -
814,102.20 714,260.65 1,197,352.20 909,652.20 657,560.65 10,500,791.02 -
2991800 19459260 (15,000,000) 7,451,060
750,000.00 1,490,212.02 2,240,212.02
EKT TRADE AND INVESTMENT PLCE
OPERATIONAL COST MONTHLY PLAN FOR 2016/2017
July August September October

No. DESCRIPTION
Total Value Total Value Total Value in Total Value
in Birr in Birr Birr in Birr
1 TRANSIT
2 TRANSPORT
3 BAGING & PACKING MATERIAL
4 CLEANING
5 FUMIGATION
6 INSPECTION
7 COMMISSION
8 WARE HOUSE
9 DOCUMETNATION FEE
10 PROMOTION
11 Operation costs
12 BANK INTEREST 7.5%
TOTAL OPRATION COST
19
Operation Cost 60% covered by loan - - - -

Bank interest 7.5 % of Operation costs - - - -
Bank interest 7.5 % of Purchase cost
Total bank inerest charge
CE
016/2017
November December
Total Value Total Value in

in Birr Birr
86,100.00 300.00 Decembe 287
157,850.00 550.00 January 430
41,615.00 145.00 February 855
71,750.00 250.00 March 695
5,740.00 20.00 April 652
22,960.00 80.00 May 448
17,794.00 62.00 June 224
24,682.00 86.00
4,305.00 15.00
8,610.00 30.00
441,406.00
17,324.85 28,781.80
17,324.85 470,187.80
- 264,843.60
- 1,655.27
17324.85 27,126.53
17,324.85 28,781.80
EKT TRADE AND INVESTMENT PLCE
OPERATIONAL COST MONTHLY PLAN FOR 2016/2017
January February March

No. DESCRIPTION
Total Value in Total Value in Total Value in
Birr Birr Birr
1 TRANSIT 129,000.00 250,800.00 181,200.00
2 TRANSPORT 236,500.00 459,800.00 332,200.00
3 BAGING & PACKING MATERIAL 62,350.00 121,220.00 87,580.00
4 CLEANING 107,500.00 209,000.00 151,000.00
5 FUMIGATION 8,600.00 16,720.00 12,080.00
6 INSPECTION 34,400.00 66,880.00 48,320.00
7 COMMISSION 26,660.00 51,832.00 37,448.00
8 WARE HOUSE 36,980.00 71,896.00 51,944.00
9 DOCUMETNATION FEE 6,450.00 12,540.00 9,060.00
10 PROMOTION 12,900.00 25,080.00 18,120.00
11 Operation costs 661,340.00 1,285,768.00 928,952.00

12 BANK INTEREST 7.5% 39,583.13 34,009.62 31,946.58
TOTAL peration costs 700,923.13 1,319,777.62 960,898.58
20
Operation Cost 60% covered by loan 396,804.00 771,460.80 557,371.20

Bank interest 7.5 % of Operation costs 2,480.03 4,821.63 3,483.57
Bank interest 7.5 % of purchase costs 37,103.10 29,187.99 28,463.01
Total bank inerest charge
NT PLCE
N FOR 2016/2017
April May June
Total Value in Total Value in Total Value

Birr Birr in Birr
166,800.00 127,200.00 67,200.00 300.00 December 287
305,800.00 233,200.00 123,200.00 550.00 January 430
80,620.00 61,480.00 32,480.00 145.00 February 855
139,000.00 106,000.00 56,000.00 250.00 March 695
11,120.00 8,480.00 4,480.00 20.00 April 652
44,480.00 33,920.00 17,920.00 80.00 May 448
34,472.00 26,288.00 13,888.00 62.00 June 224
47,816.00 36,464.00 19,264.00 86.00
8,340.00 6,360.00 3,360.00 15.00
16,680.00 12,720.00 6,720.00 30.00
855,128.00 652,112.00 344,512.00

20,600.58 2,445.42 9,822.03
875,728.58 654,557.42 354,334.03 5,353,732.01
z
513,076.80 391,267.20 206,707.20
3,206.73 2,445.42 1,291.92
17,393.85 - 8,530.11
32,591,252.00
5,281,713.60
37,872,965.60
41,775,690.00
3,902,724.40
Monthly Pension Insurance
S/N Name of Employee Salary Annual Salary (11%) Medical (1%)
GM Office
1 Kiros Teklu 41,870 502,440 55,268 5,000 5,024
2 Abiy Mesfin 35,806 429,672 47,264 5,000 4,297
3 Ato Abiyu Tesfaye 15,356 184,272 20,270 5,000 1,843
4 Sentayehu Merede 5,685 68,220 7,504 5,000 682
Sub Total 98,717 1,184,604 130,306 20,000 11,846
Export Department
5 Berket Teklu 4,195 50,340 5,537 5,000 503
6 Belayneh Mekuriaw 6,879 82,548 9,080 5,000 825
7 Mesfin Diro 9,157 109,884 12,087 5,000 1,099
8 Samrawit Wondifrawu 8,324 99,888 10,988 5,000 999
9 Elias Andualem 4,195 50,340 5,537 5,000 503
10 Andualem Baye 3,779 45,348 4,988 5,000 453
11 Michael W/mariam 3,405 40,860 4,495 5,000 409
Sub Total 39,934 479,208 52,713 35,000 4,792
Selling and Distribution
12 Kumnger Getachew 15,356 184,272 20,270 5,000 1,843
13 Matiyas melaku 5,685 68,220 7,504 5,000 682
14 Abedulakeder Aberar 5,685 68,220 7,504 5,000 682
15 Abiy Mulugeta 5,685 68,220 7,504 5,000 682
16 MelieteTsega Zenbe 5,169 62,028 6,823 5,000 620
17 Getnet Bekele 6,879 82,548 9,080 5,000 825
18 Wudalem Tadesse 9,157 109,884 12,087 5,000 1,099
19 Fasika Tesfaye 11,858 142,296 15,653 5,000 1,423
20 Biniam Alemaehu 11,858 142,296 15,653 5,000 1,423
21 Genet Belay 3,779 45,348 4,988 5,000 453
22 Nigist Kidane 3,779 45,348 4,988 5,000 453
23 Abera Gebre 6,869 82,428 9,067 5,000 824
24 Nahom Mesfin 3,779 45,348 4,988 5,000 453
25 Tsion Yosef 3,779 45,348 4,988 5,000 453
26 Selamawit Tesfaye 3,779 45,348 4,988 5,000 453
27 Esmael Nurhusen 2,763 33,156 3,647 5,000 332
28 Sitotawu Teshom 1,568 18,816 2,070 5,000 188
29 Dawed Abadura 1,568 18,816 2,070 5,000 188
30 Kokebe Geberu 1,568 18,816 2,070 5,000 188
31 Tsigereda Menda 1,400 16,800 1,848 5,000 168
32 Senayet Worku 1,400 16,800 1,848 5,000 168
Sub Total 113,363 1,360,356 149,639 105,000 13,604
Import Department
33 Haftom Teklu 16,585 199,020 21,892 5,000 1,990
34 NighisteSaba G/Egziabher 11,858 142,296 15,653 5,000 1,423
35 Kelemua Demisie 9,981 119,772 13,175 5,000 1,198
36 Dawit Aletaye 5,169 62,028 6,823 5,000 620
37 Eden Habte 6,879 82,548 9,080 5,000 825
38 Yenieneh Misganaw 2,763 33,156 3,647 5,000 332
Sub Total 53,235 638,820 70,270 30,000 6,388
Monthly Pension Insurance
S/N Name of Employee Salary Annual Salary (11%) Medical (1%)
General Administrative
39 Araya G/Egziabher 20,892 250,704 27,577 5,000 2,507
40 Samson Feleke 12,925 155,100 17,061 5,000 1,551
41 Kalkidan Getnet 9,157 109,884 12,087 5,000 1,099
42 Tsion Hagos 9,157 109,884 12,087 5,000 1,099
43 Genet Feyisa 7,567 90,804 9,988 5,000 908
44 Shewafre Ali 6,879 82,548 9,080 5,000 825
45 Yohannes Dinegede 9,981 119,772 13,175 5,000 1,198
46 Amanuel G/Senbet 6,879 82,548 9,080 5,000 825
47 H/Mariam Lema 6,254 75,048 8,255 5,000 750
48 Mastewal Setargie 3,779 45,348 4,988 5,000 453
49 Medhen Hailu 5,685 68,220 7,504 5,000 682
50 Berzaf Tesfaye 3,067 36,804 4,048 5,000 368
51 G/medhin G/michael 3,067 36,804 4,048 5,000 368
52 Bekele Tadese 3,067 36,804 4,048 5,000 368
53 Fikre Getaneh 2,763 33,156 3,647 5,000 332
54 Tadesse Haile 1,400 16,800 1,848 5,000 168
55 Gezachew Baheru 1,400 16,800 1,848 5,000 168
56 Gasha Endalmaw 1,568 18,816 2,070 5,000 188
57 Meskrem Gochele 2,203 26,436 2,908 5,000 264
58 Yeshi Mamo 1,400 16,800 1,848 5,000 168
59 Bezawit Alemu 1,400 16,800 1,848 5,000 168
60 Tersite Legess 1,400 16,800 1,848 5,000 168
61 Berhe Reda G/Medhin 1,568 18,816 2,070 5,000 188
62 Abel Girma 1,400 16,800 1,848 5,000 168
63 Store Assistant 1,400 16,800 1,848 5,000 168
64 Mahlet Atre 1,400 16,800 1,848 5,000 168
Sub Total 127,658 1,531,896 168,509 130,000 15,319
Grand Total 432,907 5,194,884 571,437 320,000 51,949
Selling & Distribution 153,297 1,839,564 202,352 140,000 18,396

Annual Salary Increment 15,330 183,956 20,235 1,840
Admin & General 279,610 3,355,320 369,085 180,000 33,553

Annual Salary Increment 27,961 335,532 36,909 18,000 3,355
Total
567,733
486,233
211,385
81,406
1,346,756
61,381
97,454
128,070
116,875
61,381
55,790
50,763
571,713
211,385
81,406
81,406
81,406
74,471
97,454
128,070
164,372
164,372
55,790
55,790
97,319
55,790
55,790
55,790
42,135
26,074
26,074
26,074
23,816
23,816
1,628,599
227,902
164,372
139,145
74,471
97,454
42,135
745,478
Total
285,788
178,712
128,070
128,070
106,700
97,454
139,145
97,454
89,054
55,790
81,406
46,220
46,220
46,220
42,135
23,816
23,816
26,074
34,608
23,816
23,816
23,816
26,074
23,816
23,816
23,816
1,845,724
6,138,270
2,200,312
206,031
3,937,958
393,796
Additional Manpower Requirement
For the Year 2016/2017
Minimum Requirement Employement Schedule

Work
Educational Experience Basic
S/No Description Qualification (Years) Qualification Qty Salary Date Remark
1 Store Keeper Diploma 4 and above Materials Management or Related 1 5,169 September HR & Res.
2 Project Sales Coordinator MA/BA 6/8 Marketing/Management 1 11,858 September Sales & Mkting
3 Disbursment and Stock Junior Accountant BA/Diploma 0/2 Accounting 1 3,779 Immidiate HR & Res.
4 Business Development Junior Officer BA/Diploma 0/2 Economics or Related 1 3,779 July Business Dev't
5 Tender Coordinator 1 11,858 Import
6 Import/Export Junior Officer 2 3,779 Export
7 Store Keeper for Adama 1 5,169 Export
8 Motor Man 1 2,763 Export
Total 9
Salary Pension Contri GPA
Selling and Distribution 296,902 32,659 2,969 25,000
Admin and General 269,045 29,595 2,690 20,000
565,947 62,254 5,659 45,000
Medical
Basic Pension Insurance (Br 5,000
Salary (11%) (1%) per Head)
51,690 5,686 517 5,000
118,580 13,044 1,186 5,000
45,348 4,988 453 5,000
41,569 4,573 416 5,000
130,438 14,348 1,304 5,000
83,138 9,145 831 10,000
62,028 6,823 620 5,000
33,156 3,647 332 5,000
565,947 62,254 5,659 45,000
Existing Loan Facilities
S/No Bank Type of Loan Limit (Amount) A Interest RaAnnual Interest Expense
1 LIB Export Term Loan 3,000,000.00 10.50% 315,000.00
Import Term Loan 2,000,000.00 13.50% 270,000.00
Import OD 6,000,000.00 13.00% 780,000.00
Import Merchandise Loan 6,000,000.00 16.00% 960,000.00
Sub Total 17,000,000.00 2,325,000.00
2 Wegagen Bank Import Term Loan 14,000,000.00 15.00% 2,100,000.00

Import OD 5,000,000.00 13.85% 692,500.00
Sub Total 19,000,000.00 2,792,500.00
Grand Total 36,000,000.00 5,117,500.00

EKT Annual Business Plan For 2016-2017

Uploaded by

Copyright:

Available Formats

EKT Annual Business Plan For 2016-2017

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

EKT Annual Business Plan For 2016-2017

Uploaded by

Copyright:

Available Formats

EKT Trade and Investment P.L.C.

Sales Plan - Demostic in Quantity

Sanitary Ware and Fixtures

1 Sesame seeds 23,471 - - - - 2,675,643 3,121,638

2 Niger Seeds 24,123 - - - - 3,208,375 3,666,750

4 Castor seeds 14,323 - - - - - -

5 Desi chick peas 16,538 - - - - - 5,556,705

6 Kabuli chick peas 20,924 - - - - - 3,012,999

7 Soya beans 9,167 - - - - - 3,080,001

8 Red kidney beans 12,833 - - 2,156,000 2,156,000 2,156,000 2,156,000

9 Red Speckled beans 14,620 3,859,735 4,210,670 4,210,670 3,859,735 - -

10 Pinto 10,446 1,504,155 1,754,901 1,504,155 1,504,155 - -

15,278 1,100,044 1,100,044 1,100,044 1,100,044 - -

12 Green Mag 21,389 - - - - 1,540,015 2,053,380

15 Black cumin 57,292 - - - - 1,374,999 1,374,998

16 Others 19,097 - - - - - - 1,375,000 1,375,000 - - - -

Dec Jan Feb Mar Apr May Jun Total

1 Sesame Seeds 745 14,271,977.55 19,152.58

2 Niger 1,108 22,539,198.09 20,340.56

3 Flax 142 2,460,743.58 17,291.60

4 Castor seeds 783 9,804,651.19 12,516.15

5 Desi chick peas 2,444 33,848,682.80 13,847.44

6 Kabuli chick peas 1,159 20,708,787.81 17,865.26

7 Soya beans 1,781 12,275,066.19 6,893.01

8 Red kidney beans 924 9,131,084.01 9,882.13

9 Red Speckled beans 1,962 23,891,919.57 12,175.10

10 Pinto 1,068 8,820,126.81 8,257.87

11 LSKB 522 6,524,807.24 12,508.01

12 Green Mag 378 6,847,174.09 18,114.04

13 Lupin 763 4,740,555.58 6,211.42

14 Vetch 509 5,161,739.13 10,144.93

15 Black Cumin 115 4,941,529.79 42,895.25

16 Others 179 2,407,058.82 13,480.39

Total 14,583 188,375,102.24

1 Sesame seeds - - - - 2,523,787 2,944,470 2,523,787 2,523,787 2,523,787 2,523,787 -

2 Niger Seeds - - - - 3,166,054 3,618,382 3,618,382 3,618,382 3,618,382 3,618,382 3,166,054

3 Flax - - - - - - 772,872 772,872 772,872 386,450 -

4 Castor seeds - - - - - - - - 2,803,874 2,803,874 2,803,874

5 Desi chickpeas - - - - - 5,502,626 5,502,626 5,502,626 5,502,626 5,502,626 5,502,626

6 Kabuli chickpeas - - - - - 2,965,652 3,459,965 3,459,965 3,459,965 3,459,965 2,965,652

7 Soya beans - - - - - 3,072,258 3,072,258 2,304,194 3,072,258 2,304,194 1,536,129

8 Red kidney beans - - 2,134,839 2,134,839 2,134,839 2,134,839 2,134,839 - - - -

10 Pinto 1,495,233 1,744,493 1,495,233 1,495,233 - - - 1,495,233 1,495,233 1,495,233 -

12 Green Mag - - - - 1,501,688 2,002,276 - - 2,002,276 2,002,276 -

13 Lupin - - - - - - 1,212,645 1,818,967 1,818,967 1,212,645 -

14 Vetch - - - - - - 1,208,703 1,813,055 1,813,055 1,208,703 -

15 Black Cumin - - - - 1,279,472 1,279,471 1,279,471 1,279,472 - - -

16 Others - - - - - - 1,335,796 1,335,796 - - -

II. Sanitary Wares and Fixtures

III. Door Locks

43 Plywood 4,916,085 4,274,989 4,611,489 4,339,816 18,142,379

9 Hand wash basin 703.77 - - - 149,199 213,946 217,464 223,798 228,725

10 Water closet 1547.06 - - 352,731 314,054 326,431 331,072 340,354 348,090

13 Toilet Paper Holder 94.62 - - - - - - - -

14 Soap Holder 80.09 - - - - - - - -

16 Shower Tray 547.59 - - - - - - 33,403 268,866

18 Kitchen sink 1547.31 - - - - 78,913 92,839 94,386 97,481

26 PPR Pipes and Fittings

1,677,033 1,713,513 1,748,073 1,170,573 19,086,726