2023 DTI LDN Funds Monitoring

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2			MONTHLY	TOTAL + 13TH MO.	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	13TM MO

3	Salary
4		Cabataña, Dannamae	16,200.00	199,400.00	16,200.00	16,200.00	16,200.00	16,200.00	16,200.00	16,200.00	16,200.00	16,200.00	16,200.00	16,200.00	16,200.00	16,200.00	5,000
5		Price Monitor	16,200.00	157,088.00	12,674.00	12,674.00	12,674.00	12,674.00	12,674.00	12,674.00	12,674.00	12,674.00	12,674.00	12,674.00	12,674.00	12,674.00	5,000
6		Driver	14,400.00	177,800.00	14,400.00	14,400.00	14,400.00	14,400.00	14,400.00	14,400.00	14,400.00	14,400.00	14,400.00	14,400.00	14,400.00	14,400.00	5,000
7		Utility - Iligan (agency)	12,000.00	185,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	5,000
8		Utility - Tubod (agency)	12,000.00	185,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	5,000
9	TOTAL		70,800.00	904,288.00	73,274.00	73,274.00	73,274.00	73,274.00	73,274.00	73,274.00	73,274.00	73,274.00	73,274.00	73,274.00	73,274.00	73,274.00
10
11	FIXED OH
12		Internet - Iligan	11,760.00	141,120.00	11,760.00	11,760.00	11,760.00	11,760.00	11,760.00	11,760.00	11,760.00	11,760.00	11,760.00	11,760.00	11,760.00	11,760.00
13		Internet - Tubod	1,700.00	20,400.00	1,700.00	1,700.00	1,700.00	1,700.00	1,700.00	1,700.00	1,700.00	1,700.00	1,700.00	1,700.00	1,700.00	1,700.00
14		Water	1,500.00	18,000.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00
15		Telephone	2,500.00	30,000.00	2,500.00	2,500.00	2,500.00	2,500.00	2,500.00	2,500.00	2,500.00	2,500.00	2,500.00	2,500.00	2,500.00	2,500.00
16		ILPI	42,000.00	504,000.00	42,000.00	42,000.00	42,000.00	42,000.00	42,000.00	42,000.00	42,000.00	42,000.00	42,000.00	42,000.00	42,000.00	42,000.00
17		LANECO	15,000.00	180,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00
18		Gasoline	25,000.00	300,000.00	25,000.00	25,000.00	25,000.00	25,000.00	25,000.00	25,000.00	25,000.00	25,000.00	25,000.00	25,000.00	25,000.00	25,000.00
19		Bldg Rental	68,697.66	824,371.92	68,697.66	68,697.66	68,697.66	68,697.66	68,697.66	68,697.66	68,697.66	68,697.66	68,697.66	68,697.66	68,697.66	68,697.66
20	TOTAL		168,157.66	2,017,891.92	168,157.66	168,157.66	168,157.66	168,157.66	168,157.66	168,157.66	168,157.66	168,157.66	168,157.66	168,157.66	168,157.66	168,157.66
21	GRANDTOTAL		238,957.66	2,922,179.92	241,431.66	241,431.66	241,431.66	241,431.66	241,431.66	241,431.66	241,431.66	241,431.66	241,431.66	241,431.66	241,431.66	241,431.66
22
23	INTERNET
24		Total 2023	161,520.00
25		Budget	-52,000.00	4,333.00
26		Balance	109,520.00
27
28		Monthly Charging:
29		NC
30		RAPID
31		Reg	4,333.00
32			4,333.00
33
34
35	ILPI & LANECO						RAPID Share of FOH
36		Total 2023	684,000.00				Rental	7,500.00	90,000.00	7,500.00
37		Budget	(80,000.00)	-6,666.67			Internet		90,000.00
38		Balance	604,000.00				Light & Power	3,750.00	45,000.00	3,750.00
39
40		Monthly Charging:	ILPI	LANECO
41		NC		8,000.00
42		Reg	6,666.67
43
44
45
46													0	0	0	0	0
47	GASOLINE
48		Total 2021	300,000.00	25,000.00
49		Budget	(60,000.00)	-5,000.00
50		Balance	240,000.00
51
52		Monthly Charging:
53		NC
54		Reg	15,000.00
55
56
57	BLDG RENTAL
58		Total 2023	824,371.92
59		Budget	(400,000.00)	-33,333.33
60		Balance	424,371.92
61
62		Monthly Charging:
63		Reg	33,333.33
64		NC	27,864.32
65		RAPID	7,500.00
66		Total	68,697.65
67
68
69
70	INTERNET/COMMUNICATION ALLOWANCE
71
72		NC	REG	SSF	CARP
73		LGG	MLST	JCMF	AMP
74		AAG	LCR	LBA
75		RBP	Driver	FKM
76				MWVD (Jan-Mar)
77		FCP	AAD
78		MWVD (Apr-Dec)	JEB
79
80
81
82		Monthly Charging:
83		NC	1,200.00	4 staff x 3 cards per month
84		Reg	2,100.00	6 staff x 3 cards per month + 1 driver x 1 card per month
85		SSF	900.00	3 staff x 3 cards per month
86		CARP	300.00
87
88		Total	4,500.00
89
90
91
92
93
94
95
96
97
98
99
100