| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Implementing Unit: | Technical Education and Skills Development Authority | ||||||||||||||||||||||||
2 | NCA Utilization Report | CY 2022 | ||||||||||||||||||||||||
3 | CONSOLIDATED REPORT | |||||||||||||||||||||||||
4 | NCA of P700,000,000 | PO LEVEL | Disbursement is consistst of: | |||||||||||||||||||||||
5 | Month | Beg. Balance | Receipts | Available NCAs | Disbursements | Balance | Lapsed/ Adjustments | Carry-Over Balance | Cumulative Utilization Rate | Obligations | Obligations paid Charged to common fund | |||||||||||||||
6 | 1 | 2 | 3 | 4=2+3 | 5 | 6=4-5 | 7 | 8=6-7 | Prior Years | Continuing | Current | Other Payables/Regular Payables | Total | |||||||||||||
7 | January | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
8 | February | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
9 | March | 0.00 | 0.00 | 0.00 | 2,520.00 | -2,520.00 | 0.00 | -2,520.00 | #DIV/0! | 0.00 | 0.00 | 2,520.00 | 0.00 | 2,520.00 | ||||||||||||
10 | April | -2,520.00 | 0.00 | -2,520.00 | 172,880.00 | -175,400.00 | 0.00 | -175,400.00 | -6860.32% | 0.00 | 0.00 | 172,880.00 | 0.00 | 172,880.00 | ||||||||||||
11 | May | -175,400.00 | 0.00 | -175,400.00 | 1,200,800.00 | -1,376,200.00 | 0.00 | -1,376,200.00 | -684.61% | 0.00 | 0.00 | 1,200,800.00 | 0.00 | 1,200,800.00 | ||||||||||||
12 | June | -1,376,200.00 | 0.00 | -1,376,200.00 | 3,043,960.00 | -4,420,160.00 | 0.00 | -4,420,160.00 | -221.19% | 0.00 | 0.00 | 3,043,960.00 | 0.00 | 3,043,960.00 | ||||||||||||
13 | July | -4,420,160.00 | 0.00 | -4,420,160.00 | 2,316,800.00 | -6,736,960.00 | 0.00 | -6,736,960.00 | -52.41% | 0.00 | 0.00 | 2,316,800.00 | 0.00 | 2,316,800.00 | ||||||||||||
14 | August | -6,736,960.00 | 59,146,995.00 | 52,410,035.00 | 7,658,280.00 | 44,751,755.00 | 0.00 | 44,751,755.00 | 14.61% | 0.00 | 0.00 | 7,658,280.00 | 0.00 | 7,658,280.00 | ||||||||||||
15 | September | 44,751,755.00 | 0.00 | 44,751,755.00 | 14,680,128.00 | 30,071,627.00 | 0.00 | 30,071,627.00 | 32.80% | 0.00 | 0.00 | 14,680,128.00 | 0.00 | 14,680,128.00 | ||||||||||||
16 | October | 30,071,627.00 | 1,382,080.00 | 31,453,707.00 | 8,286,952.00 | 23,166,755.00 | 0.00 | 23,166,755.00 | 26.35% | 0.00 | 0.00 | 8,286,952.00 | 0.00 | 8,286,952.00 | ||||||||||||
17 | November | 23,166,755.00 | 0.00 | 23,166,755.00 | 10,082,108.00 | 13,084,647.00 | 0.00 | 13,084,647.00 | 43.52% | 0.00 | 0.00 | 10,082,108.00 | 0.00 | 10,082,108.00 | ||||||||||||
18 | December | 13,084,647.00 | 0.00 | 13,084,647.00 | 6,323,469.00 | 6,761,178.00 | 0.00 | 6,761,178.00 | 48.33% | 0.00 | 0.00 | 6,323,469.00 | 0.00 | 6,323,469.00 | ||||||||||||
19 | Total as of 2022 | 60,529,075.00 | 60,529,075.00 | 53,767,897.00 | 6,761,178.00 | 0.00 | 6,761,178.00 | 88.83% | 0.00 | 0.00 | 53,767,897.00 | 0.00 | 53,767,897.00 | |||||||||||||
20 | January | 6,761,178.00 | 0.00 | 6,761,178.00 | 421,311.00 | 6,339,867.00 | 0.00 | 6,339,867.00 | 6.23% | 197,871.00 | 223,440.00 | 0.00 | 0.00 | 421,311.00 | ||||||||||||
21 | February | 6,339,867.00 | 0.00 | 6,339,867.00 | 1,702,240.00 | 4,637,627.00 | 0.00 | 4,637,627.00 | 26.85% | 657,600.00 | 1,044,640.00 | 0.00 | 0.00 | 1,702,240.00 | ||||||||||||
22 | March | 4,637,627.00 | 0.00 | 4,637,627.00 | 967,600.00 | 3,670,027.00 | 0.00 | 3,670,027.00 | 20.86% | 967,600.00 | 0.00 | 0.00 | 0.00 | 967,600.00 | ||||||||||||
23 | April | 3,670,027.00 | 0.00 | 3,670,027.00 | 238,965.00 | 3,431,062.00 | 0.00 | 3,431,062.00 | 6.51% | 110,885.00 | 128,080.00 | 0.00 | 0.00 | 238,965.00 | ||||||||||||
24 | May | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
25 | June | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
26 | July | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
27 | August | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00 | 3,431,062.00 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
28 | September | 3,431,062.00 | 0.00 | 3,431,062.00 | 1,323.00 | 3,429,739.00 | 0.00 | 3,429,739.00 | 0.04% | 1,323.00 | 0.00 | 0.00 | 0.00 | 1,323.00 | ||||||||||||
29 | October | 3,429,739.00 | 0.00 | 3,429,739.00 | 0.00 | 3,429,739.00 | 0.00 | 3,429,739.00 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
30 | November | 3,429,739.00 | 0.00 | 3,429,739.00 | 0.00 | 3,429,739.00 | 0.00 | 3,429,739.00 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
31 | December | 3,429,739.00 | 0.00 | 3,429,739.00 | 0.00 | 3,429,739.00 | 0.00 | 3,429,739.00 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
32 | Total as of 2023 | 0.00 | 0.00 | 3,331,439.00 | -3,331,439.00 | 0.00 | -3,331,439.00 | 94.33% | 1,935,279.00 | 1,396,160.00 | 0.00 | 0.00 | 3,331,439.00 | |||||||||||||
33 | TOTAL AS TO DATE | 60,529,075.00 | 0.00 | 57,099,336.00 | -3,331,439.00 | 0.00 | -3,331,439.00 | 0.94333733 | 1,935,279.00 | 1,396,160.00 | 53,767,897.00 | 0.00 | 57,099,336.00 | |||||||||||||
34 | ||||||||||||||||||||||||||
35 | ||||||||||||||||||||||||||
36 | additional NCA of P328,237,500 | PO LEVEL | Disbursement is consistst of: | |||||||||||||||||||||||
37 | Month | Beg. Balance | Receipts | Available NCAs | Disbursements | Balance | Lapsed/ Adjustments | Carry-Over Balance | Cumulative Utilization Rate | Obligations | Obligations paid Charged to common fund | |||||||||||||||
38 | 1 | 2 | 3 | 4=2+3 | 5 | 6=4-5 | 7 | 8=6-7 | Prior Years | Continuing | Current | Other Payables/Regular Payables | Total | |||||||||||||
39 | January | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
40 | February | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
41 | March | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
42 | April | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
43 | May | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
44 | June | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
45 | July | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
46 | August | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
47 | September | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
48 | October | 0.00 | 22,804,320.00 | 22,804,320.00 | 195,160.00 | 22,609,160.00 | 0.00 | 22,609,160.00 | 0.86% | 0.00 | 0.00 | 195,160.00 | 0.00 | 195,160.00 | ||||||||||||
49 | November | 22,609,160.00 | 5,934,505.00 | 28,543,665.00 | 1,017,685.00 | 27,525,980.00 | 0.00 | 27,525,980.00 | 3.57% | 0.00 | 0.00 | 1,017,685.00 | 0.00 | 1,017,685.00 | ||||||||||||
50 | December | 27,525,980.00 | 0.00 | 27,525,980.00 | 6,004,975.80 | 21,521,004.20 | 0.00 | 21,521,004.20 | 21.82% | 0.00 | 0.00 | 6,004,975.80 | 0.00 | 6,004,975.80 | ||||||||||||
51 | Total as of 2022 | 50,135,140.00 | 28,738,825.00 | 78,873,965.00 | 7,217,820.80 | 71,656,144.20 | 0.00 | 71,656,144.20 | 9.15% | 0.00 | 0.00 | 7,217,820.80 | 0.00 | 7,217,820.80 | ||||||||||||
52 | January | 21,521,004.20 | 0.00 | 21,521,004.20 | 1,739,169.00 | 19,781,835.20 | 0.00 | 19,781,835.20 | 8.08% | 1,714,169.00 | 25,000.00 | 0.00 | 0.00 | 1,739,169.00 | ||||||||||||
53 | February | 19,781,835.20 | 0.00 | 19,781,835.20 | 3,017,500.00 | 16,764,335.20 | 0.00 | 16,764,335.20 | 15.25% | 2,404,490.00 | 613,010.00 | 0.00 | 0.00 | 3,017,500.00 | ||||||||||||
54 | March | 16,764,335.20 | 0.00 | 16,764,335.20 | 4,291,134.00 | 12,473,201.20 | 0.00 | 12,473,201.20 | 25.60% | 2,798,000.00 | 1,493,134.00 | 0.00 | 0.00 | 4,291,134.00 | ||||||||||||
55 | April | 12,473,201.20 | 0.00 | 12,473,201.20 | 5,700,436.00 | 6,772,765.20 | 0.00 | 6,772,765.20 | 45.70% | 4,457,776.00 | 1,242,660.00 | 0.00 | 0.00 | 5,700,436.00 | ||||||||||||
56 | May | 6,772,765.20 | 0.00 | 6,772,765.20 | 2,739,360.00 | 4,033,405.20 | 0.00 | 4,033,405.20 | 40.45% | 1,242,000.00 | 1,497,360.00 | 0.00 | 0.00 | 2,739,360.00 | ||||||||||||
57 | June | 4,033,405.20 | 0.00 | 4,033,405.20 | 947,565.80 | 3,085,839.40 | 0.00 | 3,085,839.40 | 23.49% | 627,200.00 | 320,365.80 | 0.00 | 0.00 | 947,565.80 | ||||||||||||
58 | July | 3,085,839.40 | 0.00 | 3,085,839.40 | 568,400.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 18.42% | 0.00 | 568,400.00 | 0.00 | 0.00 | 568,400.00 | ||||||||||||
59 | August | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
60 | September | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
61 | October | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
62 | November | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
63 | December | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00 | 2,517,439.40 | 0.00% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
64 | Total as of 2023 | 0.00 | 0.00 | 19,003,564.80 | -19,003,564.80 | 0.00 | -19,003,564.80 | #DIV/0! | 13,243,635.00 | 5,759,929.80 | 0.00 | 0.00 | 19,003,564.80 | |||||||||||||
65 | TOTAL AS TO DATE | 28,738,825.00 | 0.00 | 26,221,385.60 | -19,003,564.80 | 0.00 | -19,003,564.80 | 0.9124028418 | 13,243,635.00 | 5,759,929.80 | 7,217,820.80 | 0.00 | 26,221,385.60 | |||||||||||||
66 | ||||||||||||||||||||||||||
67 | REMARKS | |||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | Prepared by: | Certified by: | Noted by: | |||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||