KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
1 Cash On Hand Hand Enanu Asfaw Almaz Brehanu Brehanu Gebre
1101-0002 1101-0005 1101-0006
694619.37 1623.67 26495.04 722738.08
2 Cash At Bank Bank CBE.Akaki Branch C/A - 7 CBE.Kaliti Branch C/A - 29 CBE. Awassa Branch C/A -1266 CBE.Teklehaymanot Br.C/A -3409 Wegagen Bank Tekelehymanot Br. C/A 285
1104-0001 1104-0002 1104-0003 1104-0004 1104-0005
47442.90
3 Trade Debtors Debtors Ethiopian Pharmatical & Medical Supplies Ethiopian Iron and Steel Foundry Nile Coffee Export Nile International Akaki Sparepart Factory Ethiopian Air Force 4 Provision of Trade Debtors Ethiopian Pharmaticals & Medical Supplies
Nile Coffee Export Nile International 5 Other Debtors EDDC Akaki Pump Factory Maritime and Transit 6 Provision For Other Debtors EDDC Akaki Pump Factory Maritime and Transit 7 Prepayment Prepayment Leave Pay Deposit for Cylinder De osit for C linder Addis Gas&Plastic Factor Telecomunication Authoirity MTSE Imported Division Bid Bond EELPA Insurance Claim Sales Shop Rent -T/haimanot Inland Revenue Authority for VAT.-Local TBA Engineering Halleta Advertising Media & Enterprise PLC
1401-0035 1401-0112 1401-0117 1401-0118 1401-0119 1401-0120
11281400.06 15641.55 1000.00 1000.00 65084.45
50.06 569646.98 471985.68 1041682.72 315038.65 174150.48 110367.43 599556.56
1403-01-0001 1403-01-0006 1403-01-0007
1404-0001 1404-0002 1404-0003 1404-0004 1404-0005 1404-0007 1404-0009 1404-0012 1404-0018 1404-0021 1404-0025 1404-0026
11281400.06
50.06 2803.86 569646.98 471985.68 1010129.06 233902.99 2288518.63
1401-01-0035 1401-01-0117 1401-01-0118
1403-0001 1403-0006 1403-0007
CREDIT
315038.65 174150.48 110367.43 599556.56 7351.96 6500.00 3900.00 47035.63 405557.03 301062.09 14000.00 21737.40 132100.00 13191.80 15052.80 7590.00 13
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Container Rent 8 Contra-Acc Contra-Account ount MTSE- Contra Account
9 Staff Debtors Debtors Hailu Mengestu Lemma Mekonnen Merawi Gebru Menebere Yirga Mengestu Tefera Mulu Assegdom Masseresh Lemma Mitiku Merga Rukia Hussen Solomon Assefa Seyefu Sebhat Sirage Adem Sirage Jemal Senedu Sebelu Sherefa Abdo Belachew G/Yes Belay Bekele Belay Deme Belihu Zeleke Bekele Gebisa Beyene Reta Bahiru Muzeyen Betelhem Mamo Berhanu Shene Birhanue Menegeste Bezuneh Belachew Teshome Ketema Tenagne Alemayhu Teku Chenke Tadelech T/Michael Tadesse H/Mariam Tadessa Abera Tegist Desalgen Negasse Getaneh Negest Assemelash Amerga Zerga Amina Sherefa Amde Anbese Assefa Yigletu Asefa Tilahun
1404-0027
10000.00 985078.71
1404-04-0001
1405-0001 1405-0006 1405-0019 1405-0020 1405-0022 1405-0026 1405-0032 1405-0034 1405-0041 1405-0044 1405-0050 1405-0055 1405-0056 1405-0059 1405-0062 1405-0067 1405-0068 1405-0069 1405-0072 1405-0076 1405-0082 1405-0084 1405-0087 1405-0090 1405-0096 1405-0097 1405-0101 1405-0112 1405-0114 1405-0125 1405-0130 1405-0131 1405-0136 1405-0144 1405-0149 1405-0154 1405-0155 1405-0158 1405-0163 1405-0165
CREDIT
169042.15 169042.15
202.00 1019.00 739.46 561.00 1304.00 1273.00 768.52 1227.00 597.00 85.00 590.00 182.00 242.00 684.00 1639.00 776.00 1146.00 278.00 187.00 84.00 567.23 91.00 1043.00 935.00 1146.00 405.30 590.00 1694.00 892.00 1160.00 684.00 74.00 1359.00 85.00 600.00 199.00 978.00 728.00 587.00 781.00 14
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Aschalew Worku Abayneh Agaza Abe Alemu Ayneye Sheferaw Ethiopia Belete Elfenesh N/Work Etatu Nuguse Enanu Asefaw Enatenesh Mekuria Endale Gurmu Kedir Halid Wonyenshet Gebre Wassie Tesfa Zeleke Muluneh Zedamu Hige Egziabher Yeshi Haile Yassin Abduleselam Yared Eferem Yai Degifie Yedenekachew Adera Desta Kelil Derissa Diksisa Degefa Hundie G/Michael Feyessa Gennen Bayessa Gezahgn Syoum Gezahgn Eshete Getu Tefera Gossaye Seyoum Tilahun Lema Tebebe Solomon Fekadu Nida Fekadu Girma Hiwot G/Michael Germamie Tufa Addis Gorfu Mohamed Said Tasew Tebebu Dechasa Solomon Mulugeta Abebe Seferaw Mindayie Getachew Mehamed Yimam Hailu Sume Mimi G/Yes Hailu Belda Meron Getenet Hana Legesse
1405-0170 1405-0176 1405-0177 1405-0189 1405-0198 1405-0200 1405-0203 1405-0205 1405-0206 1405-0208 1405-0214 1405-0232 1405-0234 1405-0236 1405-0241 1405-0242 1405-0243 1405-0244 1405-0245 1405-0247 1405-0254 1405-0259 1405-0264 1405-0273 1405-0278 1405-0280 1405-0282 1405-0288 1405-0294 1405-0298 1405-0300 1405-0311 1405-0312 1405-0317 1405-0323 1405-0326 1405-0327 1405-0329 1405-0342 1405-0343 1405-0344 1405-0345 1405-0347 1405-0351 1405-0357 1405-0361 1405-0364
CREDIT
1016.00 253.00 199.00 604.85 597.00 400.00 871.00 1043.00 1133.70 1078.00 364.00 397.00 12291.00 144.00 371.00 74.00 1948.00 183.00 765.00 315.00 452.00 510.00 587.00 975.00 638.00 200.00 257.00 546.00 672.00 199.00 63881.76 684.00 6740.00 257.00 704.30 179.00 339.00 361.64 739.00 94.00 186.00 278.00 956.45 242.00 45.00 728.00 28.00 15
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Endeshaw Zenebe Fassil Andargie Tamene Kedida Tegabnesh Haile Mulat Sulutan Abebe Bogale Adane Alemseged Seleshe Tekale Desalegn Zewde Getahun Haye Melaku Luelseged Brehanu G/Abe Kalid Yasin Brehanu Getahun Fasica Hailu Bahiru Nurega Desalegn Haile Zeinu Sefa Samueal Demake Abebe H/Gebreal Ashagre Betele Begna Tadesse Dereje G/Sellassie
1405-0365 1405-0369 1405-0371 1405-0373 1405-0383 1405-0385 1405-0390 1405-0392 1405-0394 1405-0395 1405-0396 1405-0401 1405-0409 1405-0410 1405-0411 1405-0412 1405-0413 1405-0414 1405-0415 1405-0416 1405-0417 1405-0418 1405-0423
2146.00 1232.00 667.00 113.00 954.00 45.00 79.00 147.00 385.00 215.00 351.00 144.00 731.00 835.00 155.00 155.00 155.00 155.00 155.00 155.00 155.00 92.00 1273.00 144203.21
10 Sundry Debtor Debtorss Akaki Spare Parts Factory
1406-0003
1248.20 1248.20
11 Purchase and Trip Advance Advance Mossa Abdo Zeleke Muluneh Almaze Brehanu Abebe Beru Tebebu Dechasa
1409-0002 1409-0003 1409-0013 1409-0008 1409-0072
7561.95 1243.00 1000.00 77378.72 232.25 87415.92
12 Purchase Advance Petty Cash Abebe Beru
1409-01-0008
1522.97 1522.97
13 Stock Stock Finished Products -Black - Galvanized - Aluminum -Stainless Steel - Precoated - G-Mill &Other Products - Mobile Kitchen -Metal & Aspalt Washer
1501-01-1001 1501-02-1001 1501-03-1001 1501-04-1001 1501-05-1001 1501-06-1001 1501-07-1001 1501-08-1001
6780618.72 2988871.90 14995.00 11669.00 142.00 39745.96 28842.00 8139.03
CREDIT
16
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
- Various Under Product. - Pipes Beam eams Bars Angels - At Awasa -Black " - Galvanized - At Teklehymanot - Black " - Galvanized
1501-09-1001 1501-10-10 -1001 1501-20-1001 1501-21-1001 1501-40-1001 1501-41-1001
340988.29 100007.06 .06 85451.95 31548.20 320073.24 84326.00 10835418.35
1502-01-1001
361863.71
1513-01-1001 1513-02-1001 1513-09-1001
5174026.65 19059454.80 299177.70 24532659.15
16 Indirect Indirect Materials Materials Electrode
1514-01-1001
64718.12 64718.12
17 Spare Parts Various Type Machnery Spare Parts Grain Mill Products and Machinary SP. Mobile Kitchen Products Spare Parts
1515-01-1001 1515-02-1001 1515-03-1001
4119919.14 1362695.04 268089.57 5750703.75
14 Work In In Process Process 15 Raw Material Materialss At RM-Store -
Black Steel Coils Galvanized Steel Coils Under Production Floor - Black Steel
18 Stock Obsolescenc Obsolescencee 19 Stock Indirect Materials - Imported Fitting, Screw, Bolts,Nuts & Others Beam U Channel Bars & Angle Iron Black Flat Sheet
1515-00-1001 1516-01-1001 1516-02-1001 1516-03-1001
2218969.43 1754732.92 606853.80 1784.36 2363371.08
1516-00-1001
148956.11
20 Stock Obsolecence-for Obsolecence-for Indirect Materials 21 Other Materials Materials Stock Stock Stationary and Printing Cleaning And Sanitation Fuel And Lubricant Medicen Others
1517-01-1001 1517-02-1001 1517-03-1001 1517-04-1001 1517-05-1001
58726.77 22427.65 62379.09 14117.56 25229.50 182880.57
22 Goods In Transit Transit L/C 09/50/1861/97 L/C KAL /23/101/04 L/C KAL /23/031/05 L/C KAL/23/039/05 L/C KAL/23/013/05 L/C KAL/23/046/05
1601-01-1002 1601-01-1067 1601-01-1071 1601-01-1073 1601-01-1074 1601-01-1075
2505618.75 7111689.90 1046467.72 261882.66 250.93 10885331.50 21811241.46
23 Provision For For Doubtful GIT GIT 24 Fixed Assets Assets Buildings
2505618.75
1601-00-1001 1700-01-1001
CREDIT
3457831.88 17
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Machineries Office Equipments Specialized Equipments Motor Vehicles Hand Tools Railway Line Computer & Software
25 Accumulated Depreciation Building Machineries Office Equipments Specalized Equipments Motor Vehicles Hand Tools Rail Way Line Computer & Software
1700-01-1002 1700-01-1003 1700-01-1004 1700-01-1005 1700-01-1006 1700-01-1007 1700-01-1008
CREDIT
19702142.38 582624.26 487665.52 6563465.94 911980.62 24581.20 555567.17 32285858.97
2603169.06 15188612.77 445304.13 418725.47 5393844.02 911980.62 24571.20 340951.04 25327158.31
1701-01-1001 1701-01-1002 1701-01-1003 1701-01-1004 1701-01-1005 1701-01-1006 1701-01-1007 1701-01-1008
26 Construction In Progress
Car Parking &Garage Clinic Extention
1801-01-1003 1801-01-1004
29397.26 7651.58 37048.84
27 Fixed Assets Assets In Transit Mobile Crane
1802-01-1015
433796.37 433796.37
28 Trade Creditor Creditorss Haile Etay Zuber Mohammed Ahmed Mohammed TBA Enginnering Mukeber
29 Sundry Creditor Creditorss Stock Suspense Court Order Payable Casher Allowance -Enanu Asfaw -Ethiopia Belete - Berhane Mengiste -Sendu Seblu Labour Union A.A. Rail Way Custom Kotebe Metal Tools Factory
2101-0002 2101-0004 2101-0019 2101-0046 2101-0058 2101-0062 2101-0063 2101-0064
5000.00 5900.00 5000.00 4945.92 636.00 500.00 420.00 500.00 22901.92
2102-0001 2102-0002 2102-0003 2102-0004 2102-0005 2102-0006 2102-0007 2102-0008 2102-0012
33.89 1235.00 480.65 480.00 445.00 335.00 118908.06 3548044.80 235.36 18
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Unclaimed Salary Abay Technical Services Kombolcha Textile Genet Wedajo Casher Allowance -Almaz Berhanu Asin Micro Finance Casher Allowance -Brehanu Gebre Insurance Solomon Kassa International Stationary Kaliti Feed Processing 30 Customers Customers Advance Advance Abay Technical Service Enterprise Addis Ababa Cement Factory Akaki Metal Products Factory Awash Construction Awash Tannery Ayta PLC. Addis Metal Processing Addis ababa Police Commission Akaki Spare Parts Anbessa City Bus A.A City Gover.Env. Protection Authority AAC.Gov.R. Authority Abdulesemed Ahmed Abebe Zeleke Addis Ababa Abattoris Adil Mohammed Bulding Construction Addis Ababa University Science Faculty Alemayehu K/Mariame Adiss Ketema K/Ketema Ahemed Basha Berta Construction Bini Leather Shoe Sole Factory Dim Kidanemihiret Cherch Dinku Sileshe Debebe Ero Delema DH Geda Blanket EELPA Ethiopian Iron Steel Industry Engineering Design Tools Ethio Rental House Ethiopian Airlines Ethiopian Crowen Corck & Can Manufacturing ETHIOF
CREDIT
2102-0014 2102-0016 2102-0017 2102-0018 2102-0020 2102-0031 2102-0032 2102-0035 2102-0036 2102-0037 2102-0038
1657.98 1115.50 53.00 1049.70 443.56 202.00 585.00 78.45 2353.58 2024.00 404.25 3680164.78
6 10 16 29 30 32 46 48 49 58 62 70 109 140 180 197 228 229 230 231 7 11 2104-04-0001 8 11 14 40 3 4 6 10 12 14 21
1723.97 55039.57 91.80 2358.74 5039.31 33512.17 4092.67 22100.62 137808.00 10.22 4090.89 1848.89 66400.00 45414.45 5339.54 28000.00 3007.90 7000.00 62910.75 3815.01 3871.26 3564.96 2831.71 3551.52 1168.40 2500.00 5000.00 5250.06 8042.12 2004.46 2774.88 55885.42 1528.46 8608.88 19
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Ermias Mergia Emenet Endeshaw Equatorial Business Group Eyerusalem Memorial Association Ethiopian Metal Products Finfine Construction PLC. Fafa Food Factory Gad Construction Guna Sets General Trading G/Mariam Gizaw G.C Gonder Ketema Ageslot Haregewoin Desta Harar Brewery Sh. Company Imter PLC IC S Kaliti Food Industry Sh. Co. kassa G/Tsadik PLC. B.C. Konolke Construction K.C.M.P.E Kebede Diriba KOSPI Kangaro Plastic PLC K. Subcity Housing Project /Kirkos K/Ketema/ Lalibela Enginerring Constrction Lideta Sub-City Housing Development Lome Woreda Education Capacity Building Maritime And Transit Service Enterprise Maru Metal Industry Mekanisa Mekaneyesus Church Midroc Construction Ministry of Agriculture Mobil Oil East African LTD. Moha Soft Drink Mohamed Abdurahiman Mohmed zabir Mohmed Yimer son Ltd Co. Motor Truck Company Mozvold PLC Muger Cement Factory Minicipality of Planning & Project Mohmed Abdulahie Agsedy Menco Meta Abo Brewary Mewit A.A region Misac G.C Matador-Addis Tyer Sh.Co. Melak Tadesse Modern Office
25 74 77 104 105 2104-06-0001 2 5 15 33 81 6 16 11 15 2 3 6 8 9 2104-11-16 23 62 2104-12-0001 16 17 2 3 2104-13-0007 12 13 18 21 22 23 24 25 26 27 29 31 35 40 41 55 76 107
CREDIT
1997.21 28000.00 1276.78 673.79 3660.95 2948.50 3494.92 32472.67 5000.00 23000.00 22257.69 1500.00 8360.73 104258.00 26802.96 1317.78 1626.24 1030.40 68464.37 6731.61 105248.23 1000.00 72884.69 57296.90 37746.45 7000.00 59303.04 15349.04 2288.00 37768.99 21169.52 4938.67 30995.49 1162.69 912.00 1700.73 3235.01 2198.45 1018.47 24891.77 52907.91 2820.13 56633.99 40697.85 1480.95 2148.66 3422.54 20
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Magon Construction National Alcohol & Liker Factory National Enginers Nile Coffee Export Nazeret Tractor Megetatemia(Assembly) Sc. National Enginers Contractors Nigiru Keberet B.C Nefase Silk Laftao Housing Dev. Project Omedad Pvt. Limited co. Oromia Dev. Association PBPPE Police Force Referal Hospital Quality And Standared Authority Red sea Construction Rokon Construction Sentic Ethiopia PLC. Social Security Sur Construction Selam & Technical Vocational Center Sebeta agro Industry Star Busines Group St. Georges Church Tesfaye Yifiru General Contractor Teck tra enginering Teklebrihan Ambaye B.c. Tana Diriba Tamiru Yohannes Tenalem Trading Varnero Constrction Walta Ethiopia Wuluta Andeshe Yirga Import Interprise Ziqala Steel Rolling Mill Zuber Mohamed 31 Accured Accured Payable Payable Audit Fee
Accrued Others Accrued Interest Payable Accrued Annual Incentive fund Accured Annual Leave 32 Taxation & Pension Income Tax Payable
CREDIT
125 3 5 7 10 12 20 48 52 2 11 3 4 2104-17-0001 14 15 6 7 12 24 28 71 104 4 8 11 17 26 92 2104-22-0001 2104-23-0001 34 3 4 7
20174.22 56594.41 3887.86 20871.19 6145.55 1356.52 27866.00 6646.39 28938.95 1250.79 4868.64 5490.36 17560.50 1075.89 83596.95 62544.11 6434.86 3802.42 94785.20 79010.97 18444.80 7863.24 1000.00 7633.91 1064.91 82697.30 2553.61 4395.21 60000.00 1953.89 1282.16 8201.06 1317.35 1625.25 2289.49 2324505.36
2107-0001 2107-0003 2107-0005 2107-0006 2107-0008 2107-0009 2107-0011
7391.30 593.84 662583.36 38253.27 53341.24 11981.37 632644.87 1406789.25
2201-0001
391.21 21
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
4% Pension Payable 6% Pension Payable V.A.T Payable
CREDIT
2201-0002 2201-0003 2201-0006 0.00
33 Financial Financial Obligation Obligation Profit Tax State Dividend
2301-0001 2301-0002
64.62 96.93 392408.38 392961.14
796916.28 796916.28
51332.91 51332.91
34 Short Term Term Loan Loan Short Term Loan-1 st
2401-0001
2660740.21
Short Term Loan-2 nd
2401-0002
3242964.88 5903705.09
35 Long Term Loan - For Grain Mill Factory From Principal Interest
2611 2611-0002
36 State Capita Capitall
3101-0001
7500000.00 10365303.32 17865303.32 9677918.83
37 Reserv Reservee Legal Reserve Retained Profit
3201-0001 3201-0002
976288.44 1885697.64 0.00
38 Cash Sales Of Products - Flat Sheet -Tube & Angle Iron - Secco Profile - Press EGA & U Channel - Structural & Furniture Unit - Other Sales
2861986.08
4101-0001 4101-0002 4101-0003 4101-0004 4101-0005 4101-0006 4101-0007
13068132.86 27962304.14 949482.92 16140709.52 8405611.26 534091.71 408283.45 67468615.86
4102-0001 4102-0002 4102-0005 4102-0006
1936502.52 3133221.52 2370.00 4605.00 5076699.04
40 Cash Sales Of Products At At Awassa Branch Flat Sheet Tube And Angle Iron Secco Profile Pressed Sheet, EGA & U-Channal Structural Unit
4101-01-0001 4101-01-0002 4101-01-0003 4101-01-0004 4101-01-0005
34233.94 656173.29 74071.44 16453.31 4644.36 785576.34
41 Cash Sales of Products At T/Haymanot Branch Flat Sheet
4101-02-0001
475.24
- Imported Materials for Resale
39 Credit Credit Sales Sales Flat Sheet Tube And Angle Iron Structural and Furniture Unit Other Sales
22
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Tube and Angle Iron Secco Profile Pressed Sheet, EGA & U-Channal Structural and Furniture Unit Other Sales
4101-02-0002 4101-02-0003 4101-02-0004 4101-02-0005 4101-02-0006
42 Sales Returns Returns & Discount Discount
4103-0001
43 Other Income Income
4104-0001
44 Direct Materials Materials Consumption Consumption Manufacturing - Black -Galvanized -Aluminum
CREDIT
4113894.95 676981.33 445.68 27858.10 1243.20 4820898.50 185252.71 111979.74
5101-01-1001 5101-02-1001 5101-04-1001
28626256.65 13469541.99 733.58 42096532.22
5102-01-1001 5102-02-1001
1505037.37 79448.85 1584486.22
46 Indirect Materials Consumption-Manuf. Fittings Beams & Bars Spare Parts Electrode Grain Mill Items Mobile Cookers Items
5201-01-1001 5201-02-1101 5201-04-1301 5201-05-1401 5201-06-1501 5201-07-1601
296816.10 32134.29 1235867.90 5071.27 17850.00 4854.05 1592593.61
47 Indirect Materials Consumption -Structural Fittings Deformed Bars Spare Parts Electrods Grain mill Spare Parts
52 5 202-01-1001 5202-02-1101 5202-04-1301 5202-05-1404 5202-06-1501
52225.19 41250.21 34050.01 37300.09 1694.00 166519.50
48 Salary and Wages Wages at Cost Centers Cutting and Slitting Salary Overtime Annual Leave
5301-01-1001 5301-01-1101 5301-01-1201
198999.61 31325.08 454.04 230778.73
49 OME and and SECCO SECCO Salary Overtime Annual Leave
5302-01-1001 5302-01-1101 5302-01-1102
281760.18 72300.85 9831.91 363892.94
45 Direct Materials Consumption
Carpentery - Black - Galvanized
23
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
50 EGA. U Channal & Press Salary Overtime Annual Leave
5303-01-1001 5303-01-1101 5303-01-1201
216311.82 34733.76 1546.43 252592.01
51 Structu Structural ral & Furniture Unit Salary Overtime Annual Leave
5304-01-1001 5304-01-1101 5304-01-1202
886182.30 65010.84 32033.46 983226.60
6101-0021 6101-0022 6101-0023 6101-0024
746495.01 57968.16 184091.23 29289.66
Funeral Expense
6101-0031 6101-0032 6101-0033 6101-0034 6101-0035 6101-0036 6101-0037
139354.02 85417.70 135373.20 5145.50 1125.22 389012.08 2000.00
Depreciation Building & Land Improvement Machinery Hand Tools
6101-0041 6101-0042 6101-0043
85981.31 1128382.40 1640.00
Repair and Maintenance Machinery Work Shop Spare Parts and Other Material Truck Mobile Crane Forklift
6101-0051 6101-0052 6101-0053
27572.83 113245.40 48898.53
Electricity and Water Consumption Factory Supplies Stationary Printing Office Supplies Cleaning and Sanitery Supplies Paint Electrical Supplies
6101-0061
238160.81
6101-0063 6101-0064 6101-0068 6101-0066
14333.37 13672.23 27895.63 37239.65
Training Expense
6101-0070
26450.00
Fuel Lubricant & Greese
6101-0071
108314.26
52 Factory Factory Overhead Overhead Salary & Wage Salary Wage Overtime Annual Leave Employees Benefit 6% Pension Medical Uniform Tution Fee Milk Expense
CREDIT
24
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Insurance
6101-0072
100725.00
Others Food Accomodation Perdium,Transport Entertaining Customs Inspection Fee Cylinder Rent Machinary Rent Consultancy Fee
6101-0062 6101-0065 6101-0067 6101-0074 6101-0079 6101-0080
31950.17 17044.95 1790.00 825.00 1715.58 1179.64 3802288.54
7102-01-1001 7102-02-1001 7105-01-1001
520267.91 6710.54 526978.45 390392.37
8101-0021 8101-0022 8101-0023 8101-0024
547604.94 15887.42 45508.63 11221.18
8101-0031 8101-0032 8101-0033 8101-0034 8101-0035
40953.77 17531.46 5473.18 17313.50 109158.56
Building & Repair Charge Repair Charge Furniture & Equipments
8101-0054 8101-0055
568.63 2179.98
Food Accomodation and Perdium
8101-0062
26649.58
Stationary & Office Supplies Cleaning and Sanitary Supplies
8101-0063 8101-0064
43612.80 3955.95
Entertaining
8101-0065
515.55
Advertizing and Publicity
8101-0066
277574.32
Bid Announcement Training Expense Stock Obsolecence
8101-0070 8101-0071 8101-0074
3594.00 6242.41 376676.21 1552222.07
CREDIT
53 Cost Of Goods Sold
Fitting & Others Grain Mill & Mobile Cooker 54 Cost Of Goods Sold Main Products 55 Selling & Distribution Expense Salary and Wage Salary Wage Overtime Annual Leave
Employees Benefit 6% Pension Medical Uniform Education Fee
25
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
CREDIT
56 Selling & Distribution Expense Awasa Branch
Salary Wage Leave Pay
81 8 101-01-0021 8101-01-0022 8101-01-0024
32311.50 9740.30 5331.36
Employees Pension Medical Expense School Fee Building Repair Charge
8101-01-0031 8101-01-0032 8101-01-0034 8101-01-0054
1221.42 1043.36 2035.00 71.00
Electric and Water Consumption
8101-01-0061
783.48
Transport Allowance
8101-01-0062
9948.98
Stationary Printing & Office Supplies Cleaning & Sanitary Supplies
8101-01-0063 8101-01-0064
140.00 224.00
Advertising and Publicity Telephone Expense Bank Charge Rent of Sales Shop Municipality Tax
8101-01-0066 8101-01-0067 8101-01-0070 8101-01-0073 8101-01-0074
4503.50 350.24 1508.91 8400.00 2625.00 80238.05
Salary Wage Overtime Annual Leave
8101-02-0021 8101-02-0022 8101-02-0023 8101-02-0024
85779.31 9961.82 3141.93 15173.51
Medical Expense Uniform School Fee
8101-02-0032 8101-02-0033 8101-02-0034
277.77 1300.74 3718.00
Building Repair Charge
8101-02-0054
351.30
Electricity And Water
8101-02-0061
1133.30
Food Accomodation and Perdium
8101-02-0062
7826.96
Stationary & Printing Cleaning & Saniary Supplies Postage Telephone Expense
8101-02-0063 8101-02-0064 8101-02-0066
310.40 979.10 3146.61
57 Selling and Distribution -T/haymanot Branch Salary and Wage
26
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Bank Charge Rent Of Sales Shop
8101-02-0070 8101-02-0073
600.50 120000.00 253701.25
Wage
8102-0021 8102-0022
1276558.45 73004.35
Overtime Annual Leave
8102-0023 8102-0024
219075.55 49923.79
6% Pension Medical Uniform Education & Tution Fee Bonus Funeral
8102-0031 8102-0032 8102-0033 8102-0034 8102-0035 8102-0036
81717.86 50130.33 26945.30 31006.00 174498.85 2500.00
Employees Prize
8102-0037
4000.00
8102-0041 8102-0045 8102-0046 8102-0047 8102-0090
8168.46 34330.04 290768.35 17235.01 71538.83
Furniture and Office Equipment
8102-0054 8102-0055
23875.73 15412.78
Food Accomodation Perdium & Transport
8102-0062
64897.44
Stationary,Printing Office Supplies Cleaning &Sanitary Supplies
8102-0063 8102-0064
99358.53 10752.05
Entertaining Expense
8102-0065
7780.55
Postage Telephone Telex
8102-0066
72058.82
Training Expense
8102-0067
26854.96
8102-0068 8102-0069
1021033.92 1154032.28
58 Administration Expense Salary and Wage Salary
CREDIT
Employees Benefit
Depreciation
Building & Land Improvement Office Equipment Vechicle Specialised Equipments Computer& Software
Repair Charge Building
Interest
Interest On Overdraft Interest On Long Term Loan
27
KALITI METAL PRODUCTS FACTORY SCHEDULE OF ACCOUNTS FOR THE YEAR ENDED JUNE 30 2005 Item No.
DESCRIPTION
ACCT. No.
SUBSIDARY LEDGER DEBIT
Bank Charge Repair Charge Of Vehicles
8102-0070 8102-0071
71633.39 203304.25
Fuel & Lubricants
8102-0072
271493.17
Insurance
8102-0073
77577.30
Municipality Tax & Relted Expense Mess Hall Material Expense
8102-0074 8102-0075
71693.20 1885.94
Board Men & Perdium Allowance
8102-0076
26625.00
Annual Incentive Fund Car Parking Expense Legal Case Expense
8102-0077 8102-0078 8102-0079
21367.40 2073.00 4870.20
Audit Fee
8102-0081
7391.30
Vacant Annoncement & Examination fee
8102-0083
2272.00
Employees Federation Rent Expense Donation Expense Provision for Bad Debt
8102-0086 8102-0088 8102-0089 8102-0090
3350.00 4000.00 12000.00 1641189.22 7330183.60
CREDIT
28
KALITI METAL PRODUCTS FACTORY WORK SHEET FOR THE YEAR ENDED OF JUNE 30, 2005
DESCRIPTION Cash on Hand Cash at Bank Trade Debtors Provision For Doubtful Trade Debtors Other Trade Debtors Provision For Doubtful Other Trade Debtors
Prepayments MTSC Contra Account Staff Debtors Sundary Debtors Purchase and Trip Advance Purchase Advance On Petty Cash Finished Goods. Work In Process Direct Materials Imported Packing Materials Imported Spare Parts Imported Stock Obsolescence Other Direct Materials Imported Stock Obsolecence Stationary Materials Goods In Transit Provision For Goods In Transit Fixed Assets Accumulated Deprecations Fixed Assets Construction In Progress Fixed Assets In Transit Trade Creditors Sundary Creditors Custmors Advance Payment Accrued Liabilities Tax Payables Financial Obiligations Short Term Loans Long Term Loans State Capital General Reserve Cash Sales Main Products Credit Sales Main Production Sales Return Other Income Direct Materials Consumed MFG. Direct Materials Consumed Structural Indirect Materials Consumed CSC. Indirect Materials Consumed Structurals Direct Labour CSC. "
"
OME & SECCO
"
"
EGA & PRESS
"
"
CONSTRUCTION
Factory Overhead Cost Of Goods Sold Fittings,Beam,G/Mill Parts "
"
" Various Finished Products
Selling and Distribution Expense -Head Office Selling and Distribution Expense-Awassa Branch Selling and Distribution Expense-Teklehaymanot
General Administration Expense
TOTA TO TAL L BALA BALANC NCE E NET INCOME (LOSS) GRAND TO T OTAL
ACCT NO.
1101 1104 1401 1401-01 1403 1403-01 1404 1404-04 1405 1406 1409 1409-01 150 1501 1502 151 1513 1514 1515 1515-00 1516 1516-00 1517 160 1601 1601-00 170 1700 1700-00 1801 1802 2101 2102 2104 2107 2201 2301 2401 2611 3101 3201 4101 4102 4103 4104 510 5101 5102 5201 5202 5301 5302 5303 5304 6101 7102 7105 8101 8101-01 8101-02 8102
TRIAL BALANCE DEBIT CREDIT
INCOME STATEMENT DEBIT CREDIT
BALANCE SHEET DEBIT CREDIT
722738.08
722738.08
11216315.61
11216315.61
2288518.63
2288518.63
1041682.72
1041682.72
599556.56
599556.56
599556.56
599556.56
985078.71
985078.71
169042.15
169042.15
144203.21 1248.20 87415.92 1522.97 10835418.35 361863.71 24532659.15 64718.12 5750703.75
144203.21 1248.20 87415.92 1522.97 108 10835418. 18.35 361863.71 245 24532659. 59.15 64718.12 5750703.75
2218969.43
2218969.43
2363371.08
2363371.08
148956.11
148956.11
182880.57 21811241.46
182880.57 218 21811241. 41.46
2505618.75
2505618.75
32285858.97
322 32285858. 58.97
25327158.31
25327158.31
37048.84 433796.37
37048.84 433796.37
796916.28
0.00
22901.92 3680164.78 2324505.36 1406789.25 392961.14
22901.92 3680164.78 2324505.36 1406789.25 392961.14 51332.91 5903705.09 17865303.32 9677918.83 2861986.08 73075090.70 5076699.04
745583.37 5903705.09 17865303.32 9677918.83 2861986.08 73075090.70 5076699.04 185252.71
185252.71 111979.74
111979.74
42096532.22 420 42096532. 32.22 1584486.22 1584486.22 1592593.61 1592593.61 166519.50 166519.50 230778.73 230778.73 363892.94 363892.94 252592.01 252592.01 983226.60 983226.60 3802288.54 3802288.54 526978.45 526978.45 390392.37 390392.37 1552222.07 1552222.07 80238.05 80238.05 253701.25 253701.25 7330183.60 7330183.60 1656 165678 7863 637. 7.80 80 1656 165678 7863 637. 7.80 80 6139 613918 1878 78.8 .87 7 7826 782637 3769 69.4 .48 8 1042 104235 3542 426. 6.02 02 8736 873635 3535 35.4 .41 1 16871890.61 16871890.61 165678637.80 165678637.80 78263769.48 78263769.48 104235426.02 104235426.02
KALITI METAL PRODUCTS FACTORY TRIAL BALANCE AS AT JUNE 30 2005 DESCRIPTION
Cash on Hand Petty Cash Fund Payroll Fund Cash at Bank Trade Debtors Provision For Doubtful Trade Debtors Other Trade Debtors Provision For Doubtful Other Trade Debtors Prepayments MTSC Contra Account Staff Debtors Sundary Debtors Provision For Doubtful Sundary Debtors Withholding Tax Purchase and Trip Advance Purchase Advance On Petty Cash Finished Goods Manuf. & Construc.Prod. Work In Process Direct Materials Imported Packing Materials Imported Spare Parts Imported Stock Obsolescence Other Direct Materials Imported Stock Obsolecence Stationary Materials Goods In Transit Provision For Goods In Transit Fixed Assets Accumulated Deprecations Fixed Assets Construction In Progress Fixed Assets In Transit Trade Creditors Sundary Creditors Custmors Advance Payment Accrued Liabilities Tax Payables
ACCT NO. 1101 1102 1103 1104 1401 1401-01 1403 1403-1 1404 1404-04 1405 1406 1406-06 1408 1409 1409-01 1501 1502 1513 1514 1515 1515-00 1516 1516-00 1517 1601 1601-00 1700 1700-00 1801 1802 2101 2102 2104 2107 2201
TRIAL BALANCE DEBIT CREDIT
1041632.66 599556.56 61323.08
211.54
3855.00 416936.72
484966.35 1994.10
12057.00 6637.37 119652.92
816.27 90587.09 16402.99 700353.28 110.08
KALITI METAL PRODUCTS FACTORY TRIAL BALANCE AS AT JUNE 30 2005 DESCRIPTION ACCT NO. Financial Obiligations 2301 Short Term Loans 2401 Long Term Loans 2611 State Capital 3101 General Reserve 3201 Cash Sales Main Products 4101 Credit Sales Main Production 4102 Sales Return 4103 Other Income 4104 Direct Materials Consumed MFG. 5101 Direct Materials Consumed Structural 5102 Indirect Materials Consumed CSC. 5201 Indirect Materials Consumed Structurals 5202 Direct Labour CSC. 5301 " " OME & SECCO 5302 " " EGA & PRESS 5303 " " CONSTRUCTION 5304 Factory Overhead 6101 Cost Of Goods Sold Fittings,Beam,G/Mill Parts 7102 " " " Various Finished Products 7105 Selling and Distribution Expense -Head Office 8101 Selling and Di Distribution Ex Expens ense-A e-Awassa Br Branc 8101-0 1-01 Sell elling and and Dist Distrribut ibutio ion n Expe Expens nsee-Te Tekl kleh ehay ayma mano no 8101 8101--02 General Administration Expense 8102 TOTAL BALANCE
TRIAL BALANCE DEBIT CREDIT 87700.00
534.00 91154.83
101197.00
109370.14 28981.00
394809.33 416902.83 487660.54
1806977.00 3541 541189.5 9.55
3541 541190.1 0.13
KALITI METAL PRODUCTS FACTORY TRIAL BALANCE AS AT JUNE 30 2005 DESCRIPTION
Cash on Hand Petty Cash Fund Payroll Fund Cash at Bank Trade Debtors Provision For Doubtful Trade Debtors Other Trade Debtors Prepayments MTSC Contra Account Staff Debtors Sundary Debtors Provision For Doubtful Sundary Debtors Purchase and Trip Advance Purchase Advance On Petty Cash Finished Goods Manuf. & Construc.Prod. Work In Process Direct Materials Imported Packing Materials Imported Spare Parts Imported Stock Obsolescence Other Direct Materials Imported Stock Obsolecence Stationary Materials Goods In Transit Provision For Goods In Transit Fixed Assets Accumulated Deprecations Fixed Assets Construction In Progress Fixed Assets In Transit Trade Creditors Sundary Creditors Custmors Advance Payment Accrued Liabilities Tax Payables Financial Obiligations Short Term Loans
ACCT NO. 1101 1102 1103 1104 1401 1401-01 1403 1404 1404-04 1405 1406 1406-06 1409 1409-01 1501 1502 1513 1514 1515 1515-00 1516 1516-00 1517 1601 1601-00 1700 1700-00 1801 1802 2101 2102 2104 2107 2201 2301 2401
TRIAL BALANCE DEBIT CREDIT 722738
11216316 2288519 50 599557 985079 169042 144203 1248 87416 1523 10835418 361864 24532659 64718 5750704 2218969 2363371 148956 182881 21811241 2505619 32285859 25327158 37049 433796 22902 3680165 2324505 1406789 392961 745583 5903705
KALITI METAL PRODUCTS FACTORY TRIAL BALANCE AS AT JUNE 30 2005 DESCRIPTION ACCT NO. Long Term Loans 2611 State Capital 3101 General Reserve 3201 Cash Sales Main Products 4101 Credit Sales Main Production 4102 Sales Return 4103 Other Income 4104 Direct Materials Consumed MFG. 5101 Direct Materials Consumed Structural 5102 Indirect Materials Consumed CSC. 5201 Indirect Materials Consumed Structurals 5202 Direct Labour CSC. 5301 " " OME & SECCO 5302 " " EGA & PRESS 5303 " " CONSTRUCTION 5304 Factory Overhead 6101 Cost Of Goods Sold Fi F ittings,Beam,G/Mill Parts 7102 " " " Various Finished Products 7105 Selling and Distribution Expense -Head Office 8101 Selling and Distribution Expense-Awassa Branc 8101-01 Selling and Distribution Expense-Teklehaymano 8101-02 General Administration Expense 8102 TOTAL BALANCE
TRIAL BALANCE DEBIT CREDIT 17865303 9677919 2861986 73075091 5076699 185253 111980 42096532 1584486 1592594 166520 230779 363893 252592 983227 3802289 526978 390392 1552222 80238 253701 7330184 165627305 163986116
KALITI METAL PRODUCTS FACTORY TRIAL BALANCE AS AT JUNE 30 2005 DESCRIPTION
Cash on Hand Petty Cash Fund Payroll Fund Cash at Bank Trade Debtors Provision For Doubtful Trade Debtors Other Trade Debtors Provision For Doubtful Other Trade Debtors Prepayments MTSC Contra Account Staff Debtors Sundary Debtors Provision For Doubtful Sundary Debtors Purchase and Trip Advance Purchase Advance On Petty Cash Finished Goods Manuf. & Construc.Prod. Work In Process Direct Materials Imported Packing Materials Imported Spare Parts Imported Stock Obsolescence Other Direct Materials Imported Stock Obsolecence Stationary Materials Goods In Transit Provision For Goods In Transit Fixed Assets Accumulated Deprecations Fixed Assets Construction In Progress Fixed Assets In Transit Trade Creditors Sundary Creditors Custmors Advance Payment Accrued Liabilities Tax Payables Financial Obiligations Short Term Loans Long Term Loans
ACCT NO. 1101 1102 1103 1104 1401 1401-01 1403 1403-1 1404 1404-04 1405 1406 1406-06 1409 1409-01 1501 1502 1513 1514 1515 1515-00 1516 1516-00 1517 1601 1601-00 1700 1700-00 1801 1802 2101 2102 2104 2107 2201 2301 2401 2611
TRIAL BALANCE DEBIT CREDIT 722738
11216316 2288519 50 599557 985079 169042 144203 1248 87416 1523 10835418 361864 24532659 64718 5750704 2218969 2363371 148956 182881 21811241 2505619 32285859 25327158 37049 433796 22902 3680165 2324505 1406789 392961 745583 5903705 17865303
KALITI METAL PRODUCTS FACTORY TRIAL BALANCE AS AT JUNE 30 2005 DESCRIPTION
ACCT NO. State Capital 3101 General Reserve 3201 Cash Sales Main Products 4101 Credit Sales Main Production 4102 Sales Return 4103 Other Income 4104 Direct Materials Consumed MFG. 5101 Direct Materials Consumed Structural 5102 Indirect Materials Consumed CSC. 5201 Indirect Materials Consumed Structurals 5202 Direct Labour CSC. 5301 " " OME & SECCO 5302 " " EGA & PRESS 5303 " " CONSTRUCTION 5304 Factory Overhead 6101 Cost Of Goods Sold Fi F ittings,Beam,G/Mill Parts 7102 " " " Various Finished Products 7105 Selling and Distribution Expense -Head Office 8101 Selling and Distribution Expense-Awassa Branc 8101-01 Selling and Distribution Expense-Teklehaymano 8101-02 General Administration Expense 8102 TOTAL BALANCE
TRIAL BALANCE DEBIT CREDIT 9677919 2861986 73075091 5076699 185253 111980 42096532 1584486 1592594 166520 230779 363893 252592 983227 3802289 526978 390392 1552222 80238 253701 7330184 165627305 163986116
KALITI METAL PRODUCTS FACTORY PROFIT AND LOSS STATEMENT FOR THE YEAR ENDED JUNE 30 2005
NOTES
JUNE 30 2005
JUNE 30. 2004
REVENUE
Sales (Net) Cost of Goods Sold Gross Operating Profit
16 17
77966537 51990282 25976255
48073704 34355311 13718393
Other Income
18
111980
217879
19 20 21
1509485 3479912 2175066 7391 26625 1641189 376676 9216345
1262443 3355074 2151041 9000 49621 140802 6967981
16871890 5666927 11204964 560248 10644716
6968291 2102488 4865803 243290 4622513
10644716
4622513
EXPENSES
Selling & Distribution Administration Expense Bank Loan Interest Audit Fee Boardmen Allowance Provision for For Bad Debt Provision for Stock Obsolecence Total Expense NET PROFIT BEFORE TAX PROVISION FOF TAXATION NET PROFIT AFTER TAX TRANSFERED TO LEGAL RESERVE
TRANSFERED TO STATE DIVIDENED RETAINED PROFIT
-
-
.2.
KALITI METAL PRODUCTS FACTORY BALANCE SHEET AS AT JUNE 30 2005
ASSETS EMPLOYED
NOTES
JUNE 30 2005
JUNE 30 2004
FIXED ASSETS (NET)
2
7429546
8372407
3 4 6 5
61029312 2297263 787823 64114397
52355305 2543351 159461 55058117
7 8 9 10 11
7827322 11281400 5903705 4870010 10696049 40578486
9924250 14581568 4252339 1235932 3633928 33628017
NET CURRENT ASSETS
23535911
21430100
NET TOTAL ASSETS
30965457
29802507
9677919 1536537 1885698 17865303 30965457
9677919 973587 1885698 17265303 29802507
CURRENT ASSETS
Stock and Goods in Transit Debtors and Prepayments With Holding Tax Receivable Cash and Bank Balances
CURRENT LIABILITES
Creditors and Accruals Bank Overdraft Short Term Loan Provision For Taxation State Dividend Payable
FINANCED BY
Paid up Capital Legal Reserve Retained Profit Long Term Loan
13 12 14 15
.1. KALITI METAL PRODUTS PRODUTS FACTORY FACTORY CASH FLOW STATEMENT FOR THE YEAR ENDED JUNE 30 2005 June 30 2005 Birr Cash Flow From Operating Activities Net Profit Before Tax
Adjustment for: Depreciation Interest
June 30 2004 Birr
16871890
69682
1638044 2175066
1966791 2151041
-8674007 246088 -2096928 36098 10196253
-15375725 399560 3205510 -1469459 -2153991
-1235932 -778980 8181341
-600995 -434526 -3189512
-854684
-560985
-854684
-560985
Short Term Loan Received Short Term Loan Repaid Interest Paid State Dividened Paid Net Cash Out Flow From Financing Activities
3242965 -1591599 -1575066 -3633928 3769029
4252339 -1551041 -1003777 -2052976
Net Increase (Decrease) in Cash & Cash Equivalent Cash and Cash Equivalent at the Begining of the Year
14422107
12369131
-10493578
-14422107
3928529
-2052976
787823
159461
Oper.Pr.Before Working Capital Change Decrease (Increase) in Stock
Decrease(Increase) in Debtors Increase (Decrease) in Creditors Prior Year Adjustments Cash Generated From Operation Net Cash Flow From Oper. Activities Profit Tax Paid
Withholding Tax Paid Net Cash Flow From Operation Activities Cash Flow from Investing Activities
Purchase of Fixed Asset Proceed From Disposal of Fixed Assets Net Cash Out Flow From Investing Activities Cash Flow From Financing Activities
Cash and Cash Equivalent at the End of the Year Components of Cash & Cash Equvalent
Cash in Hand and At Bank
Bank Overdraft
-11281400 10493578
-14581568 -14422107 .3.
KALITI METAL PRODUCTS FACTORY NOTES TO THE ACCOUNTS FOR THE YEAR ENDED JUNE 30,2005
1. ACCOUNTING POLICIES
The principal accounting policies adopted by by the factory which are consistent with the polices applied in the preceding years are stated below. a)
Depreciation Fixed assets are stated at cost less accumulated depreciation.Depreciation is charged on
straight-line basis for building & roads at the following and for the rest it is charged on net book value on reducing balance basis as per the proclamation no- 286/20. %
Building and Roads Plant Machanery Motor Vehicles Hand Tools and Equipment Water Well Rail way line Specialised Equipments Computers,software products
5 20 20 20 20 20 20 25
b) Stocks are valued as follows:
I) Finished products and work work in process at production production cost on weighted weighted average basis. ll) Raw materials, spare parts, materials imported for resale and other other materials at moving moving average cost. lll) Supplies are directly expensed up on on purchase and later on recorded to stock account based on physical inventory taken at year end and valued at latest purchase price. C) Sales are stated net of value added tax and discount. d) Provision for doubtful debts and stock obsolecence are made for specific debtors and stock
balances as and when management considers it appropriate.
Account No.
June 30 2005 Birr
.4. June 30 2004 Birr
4. DEBTORS & PREPAYMENTS
Trade Debtors Prepayment & Deposit Staff Debtors Sundry Debtors Purchase Advance Inland Revenue Authority Other Debtors
1401 1404 1405 1406 1409 1408 1403
Less:- Provision For Doubtful Acct.Rec.
2288519 816037 144203 1248 88939 0 599557 3938502
1135156 252131 138782 8214 147804 261757 599557 2543401
1641239 2297263
50.00 2543351
722738
72208
65084 787823
87253 159461.00
40128 738852 778980 -778980 NIL
279308 654619 933927 -933927 NIL
2324505 22902 3680165 392961 1406789 7827322
3760347 17109 3928317 1069209 1149268 9924250
5.CASH & BANK BALANCE
Cash on Hand Petty Cash Cash at Bank
1101 1102 1104
6.WITHHOLDING TAX Withholding Tax-Foreign Purchase -Sales Sub Total Less Transferred to Provision for Profit Tax
7.CREDITORS & ACCRUALS
Advance Received From Customers Trade Creditors Sundry Creditors Tax Payables Accruals
2104 2101 2102 2201 2107
.6.
June 30 2005 B i rr
8. BANK OVERDRAFT
June 30 2004 Birr
11281400
14581568
The Bank overdraft facility obtained from Commercial Bank of Ethiopia Kaliti Branch on the security of the building and motor vechicles of the factory which has a maximum limit of Birr 25,000,000.
9. SHORT&MEDIUM TERM LOAN
Short & Medium Term Loan
5903705
4252339
1235932 -17936 5666927 -1235932 -778980 4870010
597810 -428845 2102488 -600995 -434526 1235932
3633928 51333 -3633928 10644716 10696049
806960 -791769 -1003777 4622514 3633928.00
973587 560248 2702 1536537
782327 243290 -52030.00 973587
9677919
9677919
1885698
2082514
1885698
-196816 1885698.00
10.PROVISION FOR TAXATION
Balance Brought Forward Less Prior Year Adjustment Add Profit Tax of the Year Less Profit Tax Paid During the Year Transferred From Withholding Tax
11.STATE DIVIDEND PAYABLE Opening Balance Brought forward
Less Prior Year Adjustement Less Payment During the Year Add Current Year Dividened Payable 12.LEGAL RESERVE
Balance Brought Forward Add Approration for the Year Prior Year Adjustment
13. STATE CAPITAL 14.RETAINED PROFIT Balance Brought Forward
Add Transferred From Profit of the Year Less Prior Year Adjustment
15. LONG TERM LOAN
DBE Loan Principal Accured Interest Capitalized
7500000 10365303 17865303
7500000.00 9765303.00 17265303
.7. 15.1 This long term loan was received by the factory through the former National Metal Works corporation from the Agricultural and Industrial Development Bank (Now Development Bank of Ethiopia) on the bases of promissory note issued by the Ministry of Finance in favour of the bank. The loan was received on 17 Mar ch 1988 for the construction of Grain Mill Factory and bear interest at the rate of 8% per annum. A formal loan agreement has not yet been signed with the bank and the date of commencement of the repayment of the loan and the repayment period has not yet been fixed. Interest accured on the the loan to date has been capitalized.
16. SALES
Structural Tubes and Angle Iron Black Galvanized and Black Flat Sheet Window and Door Profiles Ribbed Sheet EGA & "U" Channel Structural Unit and Window and Door Other Sales Imported Materials For Resales Less Sales Return and Discount
35865594 15039345 1700536 16157609 8440484 539940 408283 -185253 77966537
20774003 8656862 2414865 10221246 4748366 562537 695825
259484 43681018 1759113 1830490 1017844 1216004 757428 238161 100725 26450 93141 189717 108314 54505 51332394 361864 50970530
62891 27067242 519162 1683616 784107 1483945 588081 219131 85795 6560 22432 124139 102926 119203 32869230 259484 32609746
48073704
17.COST OF GOODS SOLD
Work In Process Begining Direct Raw Material Consumed Indirect Material Consumed Direct Labour Indirect Labour Depreciation Employees Benefit Electricity & Water Consumption Insurance Training Supplies Used Repair and Maintenance Fuel and Lubricant Others Less Work In Process Ending Cost of Goods Produced During The Year
Add:Cost of Finished Goods Inventory Beg. Less Cost of Finished Goods Inventory Ending Add Cost of Imported Mat.For Resale Begining Add Purchase of Imported Mat. For Resale Less Cost of Imported Mat.For Resale Ending COST OF GOODS SOLD
11328157 10835418 51463269 1554595 1335789 2363371 51990282
12651735 11328157 33933324 1818434 158147 1554595 34355311 .8.
18. OTHER INCOME
Insurance claim Sales of Bid Document Creditors Balance Written Off Others
30129 15300 59595
10331 0 100800
6956 111980
106748 217879
781662 200027 49222 44426 282078 6242 128400 1917 3497 12015 1509485
659008 142642 22125 30682 254765 5920.00 128400.00 1689.00 5695 11517 1262443
1618562 370798 72059 99359 71693 77577 71633 64897 271493 242593 10752 26855 422041
1518828 342852 67220 100344 44408 83414 53299 68287 225692 238408 18775 14617 482846
19.SELLING AND DISTRIBUTION EXPENSE
Salary and Wages Employees Benefit Stationary and Office Supplies Perdium and Travelling Expense Advertizing and Publicity Training Rent of Sales shop Electricity & Water Postage and Telephone Others
20. ADMINISTRATION ADMINISTRATION EXPENSE
Salaries and Wages Employees Benefit Postage, Telephone and Fax Stationary and Office Supplies Muniucipality Tax Insurance Bank Charge Traveling and Perdium Car Running Repair and Maintanance Cleaning and Sanitary Supplies Training Deperciation
Bad Debt Expense Others
59599 3479912
5158 90926 3355074
1021034 600000 554032 2175066
1109695 600000 441346 2151041
21. INTEREST
Interest on Bank Over Draft Interest on Long Term Bank Loan Interest on Short Term Bank Loan Total
.9.
KALITY METAL PRODUCTS FACTORY BANK RECONCILATION STATEMENT AS AT JUNE 30,2005 BANK :COMMERCAL BANK OF ETHIOPIA AKAKI BRANCH A/C NO C/A - 7 BALANCE PER BANK STATEMENT 47442.90 ADD: (DEPOSIT IN TRANSIT)
D/S
DATE
DESCRIPTION
GRAND TOTAL
AMOUNT
REMARK
47442.90
.38.
KALITY METAL PRODUCTS FACTORY BANK RECONCILATION STATEMENT AS AT JUNE 30,2005 BANK :COMMERCIAL BANK OF ETHIOPIA KALITI BRANCH A/C NO C/A 29 BALANCE PER BANK STATEMENT -11836547.12 ADD: (DEPOSIT IN TRANSIT) D/S DATE DESCRIPTION AMOUNT 1988 23/06/05 DEPOSIT IN TRANSIT 82000.00 2013 29/06/05 " 62910.75 2014 " " 1092.27 2015 " " 719.61 2016 " " 222028.05 2017 " " 779.00 2018 " " 32946.73 2020 " " 3043.74 2021 " " 60000 2022 " " 18414.48 2037 " " 37746.45 2043 " " 39389.09 2044 30/06/05 " 33438.96 2045 " " 22414.79 231888.96 SUB TOTAL 848812.88 GRAND TOTAL -10987734.24
REMARK
.39. LESS OUTSTANDING CHECK DATE CPV Checque No DESCRIPTION 9/5/2005 20540 EG53155891 PURCHASE OF UNIFORM 24/05/05 20595 EG5315955 " " " 1/6/2005 20638 PAYABLE TO LABOUR UNIOUN 6/6/2005 20652 EG5318518 PAID TO WITHHOLDING TAX 8/6/2005 20664 EG5318529 REFUND OF REMAINING BALANCE 13/06/05 20680 EG5318544 PAYAMENT O REMAINING BALANCE 17/06/05 20703 EG5315867 PAID TO ADVERTISING 20/06/05 20709 EG5318571 ANNUAL LEAVE PAY 23/06/05 20716 EG5315878 PAYMENT TO SPONSERSHIP 23/06/05 20718 EG5318580 PURCHASE OF GUEST CHAIR 24/06/05 20726 EG5318588 PURCHASE OF EYE GOGLE 24/06/05 20727 EG5318589 MESSHALL DEDUCTION 24/06/05. 20728 EG5318590 EDIR DEDUCTION " 20729 EG5318591 PAYMENT TO TESFA LEGOJO " 20730 EG5318592 PAYMENT TO KOLFE HOUSEHOLD " 20731 EG5318593 PAID TO ADVERTISING " 20732 EG5318594 PURCHASE ADVANCE " 20734 EG5318596 PAYMENT TO PRINTING " 20735 EG5318597 PURCHASE OF CLEANING MATERIALS " 20736 EG5318598 PURCHASE OF SPRING WIRE " 20737 EG5318599 PURCHASE OF WIPER SPRING " 20738 EG5318600 PURCHASE ADVANCE " 20742 EG5318603 REPAIR CHARGE " 20744 EG5318605 OCEAN FREIGHT CHARGE 27/06/05 20745 EG5318606 SCHOOL FEE " 20748 EG5318609 REFUND OF REMAINING BALANCE " 20749 EG5318610 PERSONAL INCOME TAX " 20751 EG5318611 PAID TO WITHHOLDING TAX 27/06/05 20752 EG5318612 SCHOOL FEE 30/06/05 20753 EG5318613 PENSION CONTRIBUTION " 20754 EG5318614 PERSONAL INCOME TAX " 20755 EG5318615 PAYMENT OF WITHHOLDING TAX " 20756 EG5318616 " '' " 20757 EG5318617 OCEAN FREIGHT CHARGE " 20758 EG5318618 DAILY WORKERS WAGE " 20759 EG5318619 SCHOOL FEE " 591 PAYMENT TO OROMIA MEHABER " 592 PAYABLE TO LABOUR UNIOUN " 593 PAYMENT TO CREDIT ASSOCIATION " SUB TOTAL GRAND TOTAL
AMOUNT REMARK 540.00 NOT YET CASHED 5520 " 1938.42 " 504.50 " 1230.08 " 2500.00 " 1085.61 " 10000 " 2592 " 540 " 1926.40 " 1330 " 1495.33 " 1250.00 " 3334.00 " 6863.6 " 845.85 " 11602.84 " 12275.19 " 600.00 " 852.61 " 560 " 3951.36 " 37728.86 " 1150 " 1110.46 " 6995.44 " 7548.63 " 1240 " 35422.22 " 50276.39 " 518.36 " 292.03 " 5000.00 " 1098.73 " 880.00 " 39.00 " 1284.26 " 69743.65 " " 293665.82 -11281400.06
.40.
KALITY METAL PRODUCTS FACTORY BANK RECONCILATION STATEMENT AS AT JUNE 30,2005 BANK :COMMERCIAL BANK OF ETHIOPIA AWASSA BRANCH A/C NO C/A 1266 BALANCE PER BANK STATEMENT 15641.55 ADD: (DEPOSITS IN TRANSIT) D/S DATE DESCRIPTION AMOUNT
SUB TOTAL GRAND TOTAL
REMARK
15641.55
.41.
KALITY METAL PRODUCTS FACTORY BANK RECONCILATION STATEMENT AS AT JUNE 30,2005 BANK :COMMERCAL BANK OF ETHIOPIA T/ HAIMANOT BRANCH A/C NO 3409 BALANCE PER BANK STATEMENT 1000 ADD: (DEPOSIT IN TRANSIT) D/S DATE DESCRIPTION AMOUNT REMARK
GRAND TOTAL
1000
.42.
KALITY METAL PRODUCTS FACTORY BANK RECONCILATION STATEMENT AS AT JUNE 30,2005 BANK: COMMERCIAL BANK OF ETHIOPIA WEGAGEN BRANCH. BALANCE PER BANK STATEMENT ADD: (DEPOSIT IN TRANSIT) D/S DATE DESCRIPTION AMOUNT
GRAND TOTAL
1000 REMARK
1000
.43.
2 FIXED ASSETS
Balance
Additions
June 30,2004 Birr
Transfer /
Balance
Disposal
June 30,2005
Birr
Birr
COST
Buildings Computers and Softwares Other Business Assets Fixed Asset In Transit Construction in Progress
3193094
264737
3457831
506438
49129
555567
28105060
326901
2190
431605
254738 32061521
47048 854684
2509020
94150
2603170
269412.00
71539
340951
20910682 23689114
1472356 1638044
22383038 25327158
-159500
28272462 433795
-264737 -159500
37049 32756705
DEPRECIATION
Buildings Computers and Softwares Other Business Assets
NET BOOK VALUE
8372407
Acc't No
7429546 Balance
Balance
June 30 2005
June 30 2004
Birr
Birr
3.STOCKS
Finished Goods Work in Process Raw Materials Spare Parts Materials Imported for Resale Other Materials
1501
10835418.35
11328157
1502
361863.71
259484
1513
24532659.15
24977377
1515
5750703.75
3956124
1516
2363371.08
1554595
247598.69 44091614.73 2367925.54
158696 42234433 1991249
21811241.46 63534930.65 2505618.75 61029311.90
14617740 54860924 2505619 52355305
Less Provision For Stock Obsolesence
Add Goods In Transit Sub Total Less Provision for Goods Lost At Asseb
1601
.5.
KALITI METAL PRODUCTS FACTORY POST CLOSING TRIAL BALANCE AS AT JUNE 30 2005 DESCRIPTION
Cash on Hand Cash At Bank Trade Debtors Provision For Doubtful Trade Debtors Other Trade Debtors Provision For Other Trade DebtorsDoubtful Prepayments MTSC Contra Account Staff Debtors Sundary Debtors Purchase And Trip Advance Purchase Advance Petty Cash Finished Goods Manuf. & Const Product. Work In Process Direct Materials Imported Packing Materials Imported Spare Parts Imported Stock Obsolescence Other Direct Materials Imported Stock Obsolecence Stationary & Other Materials Goods In Transit Provision For Goods In Transit Fixed Assets Accumulated Deprecations Fixed Assets Construction In Progress Fixed Assets In Transit Trade Creditors Sundary Creditors Custmers Advance Payment Accrued Liabilities Tax Payables Financial Obiligations Short Term Loan Long Term Loans State Capital Retained Profit TOTAL
ACCT NO. 1101 1104 1401 1401-01 1403 1403-01 1404 1404-04 1405 1406 1409 1409-01 1501 1502 1513 1514 1515 1515-00 1516 1516-00 1517 1601 1601-00 1700 1700-00 1801 1802 2101 2102 2104 2107 2201 2301 2401 2611 3101 3201
TRIAL BALANCE DEBIT CREDIT 722738 11216316 2288519 1041683 599557 599557 985079 169042 144203 1248 87416 1523 10835418 361864 24532659 64718 5750704 2218970 2363371 148956 182881 21811241 2505619 32285859 25327158 37049 433796 22902 3680165 2324505 1406789 392961 15566059 5903705 17865303 9677919 3422234 103489843 103489843
.12.
KALITI METAL PRODUCTS FACTORY PURCHASE SCHEDULE FOR THE YEAR ENDEED JUNE 30,2005 ORDERED QTY
DESCRIPTIONS
L/C NO.
NO COILS
NET WEIGHT
RECEIVED IN PRIVOUS YEAR
NO COILS
NET WEIGHT
RECEIVED DURING THE YEAR
NO COILS
NET WEIGHT
EXPECTED IN THE COMING YEAR
VALUE
BLACK COILS BLACK COILS
KAL/023/022/2004
BLACK COILS
KAL/023/055/2004
BLACK COILS
KAL/023/073/2004
TOTAL
1200MT 1200MT 1440MT
169
1134870
7441611.87
171
1165000
8199999.57
267
1418847
9358105.31
3840MT
607
3718717
24999716.75
300MT 480MT 360MT 360MT 360MT 300MT
41
304400
2702312.64
78
470575
3396681.59
64
355175
2949811.03
60
358605
3351526.75
64
357650
3137542.62
48
297035
2753806.20
2160MT
355
2143440
18291680.83
GALVANIZED COILS GALVANIZED COILS
KAL/023/022/2004
GALVANIZED COILS
KAL/023/055/2004
GALVANIZED COILS
KAL/023/078/2004
GALVANIZED COILS
KAL/023/087/2004
GALVANIZED COILS
KAL/023/094/2004
GALVANIZED COILS
KAL/023/0100/2004
TOTAL SPAREPARTS & FITTINGS VARIOUS TYPES OF BEARING
KAL/023/044/2004
482
1063033.63
VARIOUS TYPES OF BEARING
KAL/023/046/2004
1672
2018075.89
VARIOUS TYPES OF BEARING
KAL/023/060/2004
141
130302.90
FITTINGS
KAL/023/069/2004
943000
184290.00
TYRISTRER
KAL/023/016/2004
6
13891.38
VARIOUS VARIOUS TYPES TYPES OF BALL BALL BEARI BEARING NG
KAL/02 KAL/023/0 3/076/ 76/200 2004 4
627
170583.82
VARIOUS TYPES OF BELT
KAL/023/018/2004
66
9730.27
CERAMIC METAL TRIODE
KAL/023/022/2004
1
185767.11
CIRCULAR HIGH SPEED
KAL/023/035/2004
50
40648.00
CERAMIC METAL TRIODE
KAL/023/003/2004
1
121904.25
TOTAL
946046
3938227.25
FIXED ASSETS MINIBUS 12 SEAT
TOTAL
KAL/023/054/2004
1
283544.24
NOCOILS
NET WEIGHT
VALUE
UNIT COST
6.56 7.04 6.6 6.72267256422
8.88 7.22 8.31 9.35 8.772662156 9.27 8.53379652801
.35.
KALITI METAL PRODUCTS FACTORY PURCHASE OF FITTINGS JUNE 30,2005 Item
DESCRIPTIONS
No.
FITTING AND SPARET GRM
QUANTITY Pcs
VALUE
NO
Date
Kg
LOCAL PURCHASE 1 Ventilation Lock
002901
22/7/2004
1000
9000.00
2 Window Handle 3 Galvanized Hooks and Washer 4 Secco Fitting
" 002902 002905
" 26/7/2004 28/7/2004
412 200000 1000
24896.00 110000.00 17310.00
5 Normal Hinge 110X55 6 Door Lock "ZANI" Italy 7 Hexagonal Bolt 14X70 8 Hexagonal Bolt 14X80 9 Hexagonal Bolt 16X80 10 Hexagonal Bolt 16X100 11 Normal Hinge 140X160 12 Fitting 13 Fitting 14 Galvanized Bolt with Nuts (8X16)
002912 " " " " " " 002924 " 002934
4/8/2004 " " " " " " 18/8/2004 " 24/08/2004
200 30 100 100 200 200 200 200 200 10000
468.00 2135.10 477.00 527.00 1194.00 1332.00 468.00 1731.00 1731.00 2951.90
15 Allen Bolt 16X90 16 Allen Bolt 16X120 17 Hi Hight Latch for Bottom Hinge with Plate 18 Le Left Hand Galvanized Butt Hinge Hunkle 19 Right Hand Galvanized butt Hinge Hunkle 20 Normal Hinges 110X55x1.5 21 Normal hinge 140X60X2.5 22 Galvanized Bolt with Nuts (8X16) 23 Window Handle 24 Hidden Locker 25 Allen Bolt 10X30 26 Allen Bolt 6X20 27 Allen Bolt 6X30 28 Allen Bolt 8X20 29 Hexagonal Bolt 8X25 30 Hexagonal Bolt 10X30 31 Hexagonal Bolt 14X50 32 Hexagonal Bolt 18X50 33 Hexagonal Bolt 20X40 34 Hexagonal Bolt 20X90 35 L- Iron 28X 1.2 36 Diformed Bar 37 Diformed Bar 38 Diformed Bar 39 Diformed Bar 40 Diformed Bar 41 Diformed Bar SUB TOTAL
002973 " 002998 003007
5/10/2005 " 14/10/2004 18/10/2004
003013 003031 003035 002906 003126 003263 " " " " " " " " " 002077 002094 002135 002136 " " "
21/10/2004 1/11/2004 4/11/2004 28/7/2004 17/1/2005 8/6/205 " " " " " " " " " 16/8/2005 11/11/2004 28/11/2004 28/1/2005 " " "
100 150 2500 2500 2500 350 600 20000 88 200 30 50 30 50 30 20 30 20 20 30 130 20 15 35 100 10 5 243455
1900.00 3170.17 20475.00 42475.00 42475.00 654.50 1836.00 6832.20 5104.00 2138.00 48.60 26.00 19.80 48.00 12.60 16.60 74.40 85.00 101.00 270.00 11589.50 4579.96 1846.80 4309.20 19331.80 655.60 154.25 344449.98
594.80 665 2965 110 25 4359.80
KALITI METAL PRODUCTS FACTORY PURCHASE OF FITTINGS JUNE 30,2005 Item
DESCRIPTIONS
No.
FITTING AND SPARET GRM
NO
Date
QUANTITY Pcs
VALUE
Kg
.36. IMPORTED PURCHASE L\C KAL 23/69/2004
42 Galvanized Bolt with Nuts (8X16) 43 Asphalt Washer Ø 6 44 Galvanized Nuts Ø 6 45 Round Bar 400 M/M 46 Round Bar 300 M/M 47 Round Bar 130 M/M 48 Round Bar 150 M/M 49 Round Steel Bar 280 M/M 50 Round Steel Bar 190 M/M
003030 " 003033 002104 " " " " "
1/11/2004 " 3/11/2004 4/1/2005 " " " " "
500000 323000 120000 2 3 1 1 2 1
165000.00 9690.00 9600.00 249035.02 273938.52 11759.06 13236.11 116405.64 49212.16
51 Round Steel Bar 150 M/M 52 Round Steel Bar 90 M/M
" "
" "
2 2
60447.10 22672.70
53 Round Steel Bar 60 M/M SUB TOTAL GRAND TOTAL
"
"
2 943016 1186471
10342.68 991338.99 1335788.97
4359.80
KALITI METAL PRODUCTS FACTORY PURCHASE OF FITTINGS JUNE 30,2005 Item No.
DESCRIPTIONS
FITTING AND SPARET GRM
NO
Date
QUANTITY Pcs
VALUE
Kg
.37.
KALITY METAL PRODUCTS FACTORY DEPARTMENT PROFITABILITY ANALYSIS JUNE 30,2005 ITEM NO. PRODUCTION DEPARTMENTS
1 C.S.C 2 OME & SECCO 3 EGA & PRESS 4 STRUCTURAL 5 IMPORTED SALES 6 OTHER INCOME 7 EX-GRAINMILL GRAND TOTAL
SALES QTY.IN TONS VALUE IN BIRR 1538 15039344.56 3815 37450864.34 1819 16178775.88 836 8980423.63 2177.55pcs 408283.45
8008
COST OF SALES 10028658.30 24973290.56 10788463.18 5988399.27 272254.90
77966537.03
OPERATING EXPENSE 1662048.69 4138821.33 1787971.09 992456.90 45120.78
PROFIT/LOSS BEFORE TAX 3348637.57 8338752.45 3602341.61 1999567.46 90907.77 111980.00 600000.00 -600000.00 9216344.97 16871890.47
51990281.59
DEPARTEMENT PROFITABILITY 10000000.00 )
TI F O R P
S S O C(
8000000.00 6000000.00 4000000.00 2000000.00 0.00 -2000000.00 1
2
3
4
COST CENTERS
5
6
7
RANK
3 1 2 4 6 5 7
PROFIT CONTRIBUTION 19% 49% 21% 12% 1% 1% -4% 100%
1-C.S.C 2-OME & SECCO 3-EGA & PRESS 4-STRUCTURAL 5-IMPORTED SALES 6-OTHER INCOME 7-EX-GRAIN MILL
KALITI METAL PRODUCTS FACTORY FINANCIAL RATIOS FOR THE YEAR ENDED JUNE 30 2005 BUDGET No
Performance Indicators
Measure
Plan 2005
Actual 2005
Actual 2004
Remark
CA/CL
1.80
1.58
1.64
Time
(CA-I)/CL
0.96
0.55
0.44
“
TD/TA
78.00
81.69
80.23
%
I) LIQUIDITY RATIOS
a) Current Ratio b) Quick Ratio II) LEVERAGE RATIOS a) Total Debt/Total Assets b) Long Term Debit/Net Assets c) Current Liabilities /Total Debt
LTD/NA
58.00
57.69
57.93
“
CL/TD
60.00
69.43
66.08
“
CA/TA
84.00
89.62
86.80
“
III) ASSET STRUCTURAL ANALYSIS a) Current Asset/Total Assets b) Fixed Assets/ Total Assets c) Stock Inventory/Current Assets d) Debtors Receivables/Current Assest
FA/TA
15.59
10.38
13.20
“
I/CA
47.00
65.08
73.09
“
DR/CA
6.00
3.58
4.62
“
(S-CGS)/S
30.00
33.32
28.54
“
IV) PROFITABILITY RATIOS a) Gross Margin b) Profit Margin c) Return on Total Assets (ROA) d) Profit/Capital V) PRODUCTIVITY
NIBT/S
8.00
21.64
14.50
“
NIBT/TA
5.06
23.58
10.99
“
NIBT/C
32.00
128.79
55.58
“
PQ/KG M.Hr
11.29
21.12
11.54
“
KALITY METAL PRODUCTS FACTORY INPUT-OUTPUT RELATIONSHIP ANALYSIS JUNE 30,2005 ITEM NO.
DESCRIPTIONS
1 PRODUCTION DURING THE YEAR,2005
PLAN 2005 JUNE 30,2005
3900000
JUNE 30,2004
7725063
5048922
-99734
-130092
3 ADD : FG COUNTED UNDER PROD. ENDING
45212
99734
4 ADD : WORK IN PROCESS ENDING
57238
167330
-323888
-210980
3900000
7403890
4974915
4050000
7691523
4853380
6920.00
324094
-46552.00
-6920
7651891
5170554
2 LESS: FG COUNTED UNDER PROD. BEGINNING
5 LESS: FG PRODUCED BY CONSTRUCTION 6
ACTUAL PRODUCTION QUANTITIES
7 RA RAW MATERIAL CONSUMPTION DURING THE YEAR 2005 8 RAW MATERIAL COUNTED UNDER PROD. BEGINNING 9 RA RAW MATERIAL COUNTED UNDER PRODUCTION ENDING 10
ACTUAL CONSUMPTION QUANTITIES
4050000
CTUAL PRODUCTION QUANTITY=ACTUAL CONSUMPTION QUANTIT
12 ACTUAL CONSUMPTION QUANTITIES
4050000
7651891
4974915
13 LESS: ACTUAL PRODUCTION QUANTITIES
-3900000
-7403890
-5235098
150000
248001
-260183
4%
3%
5%
14 WASTAGE (SCRAP) 15 PERCENTAGE
KALITI METAL PRODUCTS FACTORY Raw Materials,Finished Products & WIP Report 2005 PARTICULARS
KG
2004 VALUE
KG
VALUE
5215259.00 1777035.00 6992294.00
30509265.15 13505466.00 44014731.15
3229709.00 1782583.00 5012292.00
14469096.32 11889828.61 26358924.93
Raw Material Counted Under Production
46552.00
299177.70
6920.00
31001.60
Finished Product Counted Under Production
45211.78
340991.41
99734.16
600711.00
57237.99 7141295.77
361863.71 45016763.97
167330.12 5286276.28
259483.54 27250121.07
Raw Material Consumed During the Year -Black ''
''
''
''
- Galvanized
Sub Total
Finished Products-Work in Process GRAND TOTAL
FINISHED GOODS PRODUCTION FINISHED GOODS ENDING BALANCE FINISHED GOODS PRODUCTION-UNDER CONSTRUCTION
7725062.63
5048922.39 10418481.63
11328157.00
323888
N0. of Production Workers Including Technical Workers 163 N0. of Hours to be Worked in a Month= 187 TOTAL ANNUAL MAN HOUR (163X187)X (163X187)X12= 12= 365772 PRODUCTIVITY YIELD/HR = YIELD/HR =
Production Quantity Total hrs. Worked in a Year
7725063 365772
21.12