Shee Ann:

WORKING PAPER FOR MDP - Elementary Schools

Amounts in green font should not
be edited; formula sensitive
School Araneta ES
Total MOOE Based on NEP 304,000.00
Please check again=C

Allowable Object of Expenditures Amount Percentage Transfer from

Travelling Expenses - Local 50,000.00
Training Expenses 53,000.00
Office Supplies Expenses 120,000.00
Accountable Forms Expenses
Medical, Dental and Laboratory Supplies Expenses
Fuel, Oil and Lubricants Expenses
Other Supplies and Materials Expenses
Water Expenses
Electricity Expenses
Mobile 3,800.00
Landline
Internet Subscription Expenses
Cable, Satellite, Telegraph and Radio Expenses
Security Services Shee
Shee Ann:
Ann:
Copy
Copy values
values to
to BED
BED 33 MDP
MDP
Other General Services -- NEP
NEP
R & M School Buildings
R & M Office Equipment
Fidelity Bond Premiums
Representation Expenses
Other Maintenance and Operating Expenses
TOTAL 226,800.00 0% -
NCA

TRA
Transfer to Final Amount TRA Net Program Jan Feb
50,000.00 2,500.00 47,500.00
53,000.00 2,650.00 50,350.00
120,000.00 6,000.00 114,000.00
- - -
- - -
- - -
- - -
- - -
- - -
3,800.00 190.00 3,610.00
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -

- - -
- 226,800.00 11,340.00 215,460.00 - -
- -

- -
11,340.00 - -
Mar Apr May Jun Jul Aug

- - - - - -

- - - - - -
- - - - - -
Sep Oct Nov Dec
- Ooooppps! Check again...
- Ooooppps! Check again...
- Ooooppps! Check again...
- Very Good! =D
- Very Good! =D
- Very Good! =D
- Very Good! =D
- Very Good! =D
- Very Good! =D
- Ooooppps! Check again...
- Very Good! =D
- Very Good! =D
- Very Good! =D
- Very Good! =D
- Very Good! =D
- Very Good! =D
- Very Good! =D
- Very Good! =D

- Very Good! =D
- - - - - Ooooppps! Check again...
- Very Good! =D

- - - -
- - - - - Ooooppps! Check again...
- Very Good! =D
pps! Check again...
pps! Check again...
pps! Check again...

pps! Check again...

pps! Check again...

pps! Check again...

WORKING PAPER FOR MDP - Junior High Schools 37336.8421052632000000

School
Total MOOE Based on NEP

Allowable Object of Expenditures Transfer from Transfer to Final Amount TRA Net Program Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Travelling Expenses - Local 36,000.00 1,800 34,200.00 2,850.00 2,850.00 2,850.00 2,850.00 2,850.00 2,850.00 2,850.00 2,850.00 2,850.00 2,850.00 2,850.00 2,850.00 34,200.00 Very Good! =D
Training Expenses 43,600.00 2,180 41,420.00 2,420.00 15,000.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 41,420.00 Very Good! =D
Office Supplies Expenses 79,077.00 3,954 75,123.15 18,780.75 18,780.80 18,780.80 18,780.80 75,123.15 Very Good! =D
Accountable Forms Expenses 1,020.00 51 969.00 500.00 469.00 969.00 Very Good! =D
Medical, Dental and Laboratory Supplies Expenses 18,720.00 936 17,784.00 17,784.00 17,784.00 Very Good! =D
Fuel, Oil and Lubricants Expenses - - - - Very Good! =D
Other Supplies and Materials Expenses 12,814.00 641 12,173.30 12,173.30 12,173.30 Very Good! =D
Water Expenses 17,760.00 888 16,872.00 1,406.00 1,406.00 1,406.00 1,406.00 1,406.00 1,406.00 1,406.00 1,406.00 1,406.00 1,406.00 1,406.00 1,406.00 16,872.00 Very Good! =D
Electricity Expenses 54,200.00 2,710 51,490.00 4,300.00 4,290.00 4,290.00 4,290.00 4,290.00 4,290.00 4,290.00 4,290.00 4,290.00 4,290.00 4,290.00 4,290.00 51,490.00 Very Good! =D
Mobile 12,000.00 600 11,400.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 11,400.00 Very Good! =D
Landline - - - - Very Good! =D
Internet Subscription Expenses 35,000.00 1,750 33,250.00 2,780.00 2,770.00 2,770.00 2,770.00 2,770.00 2,770.00 2,770.00 2,770.00 2,770.00 2,770.00 2,770.00 2,770.00 33,250.00 Very Good! =D
Cable, Satellite, Telegraph and Radio Expenses - - - - Very Good! =D
Security Services - - - - Very Good! =D
Other General Services - - - - Very Good! =D
R & M School Buildings - - - - Very Good! =D
R & M Office Equipment - - - - Very Good! =D
Fidelity Bond Premiums 4,000.00 200 3,800.00 3,800.00 3,800.00 Very Good! =D
Printing and Publication Expense 35,470.00 1,774 33,696.50 8,424.50 8,424.00 8,424.00 8,424.00 33,696.50 Very Good! =D
Representation Expense 25,250.00 1,263 23,987.50 23,987.50 23,987.50 Very Good! =D
Other Maintenance and Operating Expenses 43,089.00 2,154 40,934.55 40,934.55 40,934.55 Very Good! =D
TOTAL - - 418,000 20,900 397,100.00 72,368.55 27,266.00 23,090.00 74,381.35 18,935.00 38,653.50 33,446.80 23,090.00 14,666.00 33,446.80 23,090.00 14,666.00 397,100.00 Very Good! =D
NCA - 418 21 397 72 27 47 74 19 15 34 23 15 33 23 15 397 Very Good! =D
Shee Ann:
Copy values to BED 3
MDP - NEP
76,177.42 28,701.05 24,305.26 78,296.16 19,931.58 40,687.89 35,207.16 24,305.26 15,437.89 35,207.16 24,305.26 15,437.89
20,900.0000 3,808.87 1,435.05 1,215.26 3,914.81 996.58 2,034.39 1,760.36 1,215.26 771.89 1,760.36 1,215.26 771.89 20900 Very Good! =D
TRA 21 4 1 2 4 1 1 2 1 1 2 1 1 21 Very Good! =D
Shee Ann:
Copy values to BED 3 MDP
- NEP
 -1231.58
WORKING PAPER FOR MDP - Senior High Schools

School Lourdes IS - HSD

Total MOOE Based on NEP 150,000.00 Very Good! =D

Allowable Object of Expenditures Amount Percentage Transfer from Transfer to Final Amount TRA Net Program Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Travelling Expenses - Local 12,631.58 12,000.00 600.00 11,400.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 950.00 11,400.00 Very Good! =D
Training Expenses 7,578.95 7,200.00 360.00 6,840.00 570.00 570.00 570.00 570.00 570.00 570.00 570.00 570.00 570.00 570.00 570.00 570.00 6,840.00 Very Good! =D
Office Supplies Expenses 20,842.11 27,300.00 1,365.00 25,935.00 25,935.00 25,935.00 Very Good! =D
Accountable Forms Expenses - - - - Very Good! =D
Medical, Dental and Laboratory Supplies Expenses - - - - Very Good! =D
Fuel, Oil and Lubricants Expenses - - - - Very Good! =D
Other Supplies and Materials Expenses 56,189.47 53,380.00 2,669.00 50,711.00 50,711.00 50,711.00 Very Good! =D
Water Expenses - - - - Very Good! =D
Electricity Expenses - - - - Very Good! =D
Mobile - - - - Very Good! =D
Landline - - - - Very Good! =D
Internet Subscription Expenses 31,578.95 30,000.00 1,500.00 28,500.00 2,375.00 2,375.00 2,375.00 2,375.00 2,375.00 2,375.00 2,375.00 2,375.00 2,375.00 2,375.00 2,375.00 2,375.00 28,500.00 Very Good! =D
Cable, Satellite, Telegraph and Radio Expenses 11,157.89 10,600.00 530.00 10,070.00 5,000.00 845.00 845.00 845.00 845.00 845.00 845.00 10,070.00 Very Good! =D
Security Services - - - - Very Good! =D
Other General Services - - - - Very Good! =D
R & M School Buildings - - - - Very Good! =D
R & M Office Equipment - - - - Very Good! =D
Fidelity Bond Premiums - - - - Very Good! =D
Printing and Publication Expense - - - - Very Good! =D
Representation Expense 10,021.05 9,520.00 476.00 9,044.00 9,044.00 9,044.00 Very Good! =D
Other Maintenance and Operating Expenses - - - - Very Good! =D
TOTAL 150,000.00 0% - - 150,000.00 7,500.00 142,500 29830.00 3895.00 3895.00 59606.00 3895.00 12939.00 4740.00 4740.00 4740.00 4740.00 4740.00 4740.00 142,500 Very Good! =D
NCA - 150 8 142 30 4 4 60 4 13 5 5 5 4 4 4 142 Very Good! =D

Shee Ann:
Copy values to BED 3 MDP 31,400.00 4,100.00 4,100.00 62,743.16 4,100.00 13,620.00 4,989.47 4,989.47 4,989.47 4,989.47 4,989.47 4,989.47
- NEP 7500.00 1,570.00 205.00 205.00 3,137.16 205.00 681.00 249.47 249.47 249.47 249.47 249.47 249.47 7,500.0 Ooooppps! Check again...
TRA 8 2 1 1 3 - 1 - - - - - 8 Very Good! =D

Shee Ann:
Copy values to BED 3 MDP
- NEP 1,570.00 205.00
 FY 2021 MONTHLY DISBURSEMENT PROGRAM
(In Thousand Pesos)
Department : Department of Education
Agency : Department of Education
Operating Unit : Division of Valencia City
School : Lourdes Integrated School - High School Department
Organization Code (UACS) : 70010810014

TAX FULL YEAR REQUIREMENT

TOTAL REM. NET
PARTICULARS UACS CODE PROGRA ADVIC PROGRA FULL
QUARTER 1 QUARTER 2 QUARTER 3 QUARTER 4
M YEAR
M E
(TRA) JAN FEB MAR TOTAL APR MAY JUN TOTAL JUL AUG SEPT TOTAL OCT NOV DEC TOTAL TOTAL
13=10+11 17=14+1
1 2 3 4 5 6 7 8 9=6+7+8 10 11 12 +12
14 15 16 5+16
18 19 20 21=18+19+20 22

Operations
310400000000
SUPPORT TO SCHOOLS AND LEARNERS 000
Operation of Schools - Elementary (Kinder to Grade 6)
MOOE 359 18 341 100 11 40 151 21 16 14 51 53 25 17 95 11 21 12 44 341

Operation of Schools - Junior High School (Grade 7 to Grade 10)

MOOE 418 21 397 79 38 48 165 29 49 18 96 15 27 22 64 27 24 21 72 397

Operation of Schools - Senior High School (Grade 11 to Grade 12)

MOOE 150 8 142 49 30 15 94 14 4 4 22 6 4 4 14 4 4 4 12 142

TOTAL NCA PROGRAM C

MOOE O 927 47 880 228 79 103 410 64 69 36 169 74 56 43 173 42 49 37 128 880

TAX REMITTANCE ADVICE C

MOOE O - 47 47 12 4 5 21 3 4 2 9 4 3 2 9 2 3 3 8 47

TOTAL DISBURSEMENT PROGRAM

C
MOOE O 927 - 927 240 83 108 431 67 73 38 178 78 59 45 182 44 52 40 136 927

Footnote: Please cite assumptions/parameters used

Prepared By: Certified Correct: Approved by:

RANILLO C. GAMUTAN SHEE ANN A. SIEM,CPA REBONFAMIL R. BAGUIO

School Head Accountant III Schools Division Superintendent
Date: Date: Date:

Page 8 of 8