Friday, June 24, 2011

Creating 'Profit & Loss' Report Using Formulas pg 66

40	LESS : DIRECT EXPENSES

41	DEPRECIATION FACTORY			265.052.05
42	ELECTRICITY FACTORY			1,369.20
43	GUARANTEE CARD				3,031.55
44	INK SOLVENT				320.00
45	LABELLING				563.50
43	PALLET					797.99
46	MASTERBATCH				3,555.00
47	PACKING MATERIAL			2,780.02
49	UPKEEP OF PLANT				12,362.00
50
51	TOTAL DIRECT EXPENSES			289,831.31
52
53	GROSS PROFIT/(LOSS)			(6,668,711.58)
54
55 	LESS: ADMINISTRATIVE EXPENSES

56 	ACCOMODATION				34,473.62
57	ANNUAL DINNER				4,854.22
58 	ATTENDANCE ALLOWANCE-ADMIN		4,090.00
59 	AUDIT FEE				2,000.00
60	BANK CHARGE				7.889.05
61 	BONUS-ADMIN				56,200.00
62 	COMMITMENT FEE				503.55
63	CONTAINER ALLOWANCE			13,410.80
64	DEPRECIATION-ADMIN			72,976.72
65	DONATION				200.00
66 	ELECTRICITY-WORKER			544.22
67	ENTERTAINMENT				4,922.38
68	EX-GRATIA				5,000.00
69	INCOME TAX-EXPATRIATE			8,340.50
70 	INTEREST-HIRE PURCHASE			2,655.36
71	INTERNET				400.00
72	LEGAL FEE				3,197.10
73	LICENCE					30.00
74	MEDICAL					8,227.66
75	NEWSPAPER & MAGAZINE			326.00
76	PETROL ALLOWANCE			3,700.00
77	POSTAGE					240.00
78	PRINTING & STATIONERY			13,988.42
79	RECRUITMENT FEE				2,301.86
80	SALARY-ADMIN				287,896.38
81	SECRETARIAL FEE				400.00
82

Continued



No comments:

Post a Comment