Scribd
Upload
15 views5 pages

Lapsing March 2024

The document outlines the lapsing schedule for the OWWA Fund and GAA Fund for the period of January to March 2023 and 2024, detailing the depreciation of various assets including office equipment, furniture, and vehicles. It includes information on total values, accumulated depreciation, and net book values for each asset. The document is prepared by Bella May Espino-Guarin and approved by Meriam T. Nicolas.

Uploaded by

28s2j5tp7w
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
15 views5 pages

Lapsing March 2024

The document outlines the lapsing schedule for the OWWA Fund and GAA Fund for the period of January to March 2023 and 2024, detailing the depreciation of various assets including office equipment, furniture, and vehicles. It includes information on total values, accumulated depreciation, and net book values for each asset. The document is prepared by Bella May Espino-Guarin and approved by Meriam T. Nicolas.

Uploaded by

28s2j5tp7w
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

REGIONAL WELFARE OFFICE - NATIONAL CAPITAL REGION

LAPSING SCHEDULE
FOR MONTH OF JAN-MAR 2023

Fund Cluster : OWWA FUND

DEPRECIATION
ESTIMATED NET BOOK TOTAL ACCUM DEP NET BOOK
DATE RESIDUAL DEPRECIABLE ACCUM DEP
ARTICLE DESCRIPTION TOTAL VALUE USEFUL LIFE VALUE DEPRECIATION PER BOOK VALUE
ACQUIRED VALUE AMOUNT 12/31/2022 JAN FEB MAR
(IN MONTHS) 12/31/2022 CY 2022 CY 2023 CY 2023

FURNITURES AND FIXTURES

PARTITION
Office Partition installed in RWO-NCR new office
PARTITION 28-Dec-18 85,388.80 4,269.44 81,119.36 120 31,807.33 53,581.47 684.89 684.89 684.89 2,054.67 33,862.00 51,526.80
(Additional) - 36

SIGNAGES
OWWA SIGNAGES OWWA SIGNAGES - 32 05-May-19 52,250.00 2,612.50 49,637.50 120 17,869.50 34,380.50 418.00 418.00 418.00 1,254.00 19,123.50 33,126.50
-
TOTAL 137,638.80 6,881.94 130,756.86 49,676.83 87,961.97 1,102.89 1,102.89 1,102.89 3,308.67 52,985.50 84,653.30

OFFICE EQUIPMENT

AIRCONDITION
Floor Standing Airconditioner "Carrier" (5TR Model
AIRCONDITION 07-Feb-12 115,800.00 5,790.00 110,010.00 120 110,010.00 5,790.00 - 110,010.00 5,790.00
ASBFE600BA) - 119
Floor Standing Airconditioner "Carrier" (5TR Model
AIRCONDITION 14-Feb-12 109,500.00 5,475.00 104,025.00 120 104,025.00 5,475.00 - 104,025.00 5,475.00
ASBFE600BA) - 119
Floor Mounted Split Type Airconditioner "Carrier"
AIRCONDITION 22-Oct-12 76,850.00 3,842.50 73,007.50 120 74,509.52 2,340.48 - 74,509.52 2,340.48
(Model FP-53ASFM360BA) - 110
Fujiair FE-60CRDB4W 5.0TR Floor Mounted Aircon -
AIRCONDITION 01-Feb-16 93,695.00 4,684.75 89,010.25 120 60,168.30 33,526.70 779.51 779.51 60,947.81 32,747.19
71

QUEUING SYSTEM
Automizer Queue Management System (AQMS) -
QUEUING SYSTEM with 1 set Dedicated PC for admin/server, 1 unit 17-Apr-18 146,536.00 7,326.80 139,209.20 60 129,370.34 17,165.66 2,459.71 2,459.71 131,830.05 14,705.95
Thermal Ticket Printer - 44

DIGITAL DUPLICATOR
DIGITAL DUPLICATOR Iwata EBR-SA4 Digital Duplicator - 43 08-Jun-18 74,000.00 3,700.00 70,300.00 60 64,112.11 9,887.89 1,237.59 1,237.59 65,349.70 8,650.30

TOTAL 702,733.00 35,136.65 667,596.35 624,229.67 78,503.33 4,476.81 - - 4,476.81 628,706.48 74,026.52

ER PLANT, PROPERTY AND EQUIPMENT (Other PPE)

CCTV CAMERA
CCTV CAMERA IP HD Security/CCTV Camera w/ TV - 35 11-Feb-19 191,965.00 9,598.25 182,366.75 60 141,561.25 50,403.75 3,138.89 3,138.89 144,700.14 47,264.86

TOTAL 191,965.00 9,598.25 182,366.75 141,561.25 50,403.75 3,138.89 - - 3,138.89 144,700.14 47,264.86

MOTOR VEHICLE

MOTOR VEHICLE TOYOTA HILUX 4x2 Pick-Up 29 Sep 2009 872,200.00 43,610.00 828,590.00 84 828,590.00 43,610.00 - 828,590.00 43,610.00
MOTOR VEHICLE ISUZU CROSSWIND XUV AT4X2AC - 56 3 May 2017 1,070,000.00 53,500.00 1,016,500.00 84 811,671.48 258,328.52 12,801.79 12,801.79 824,473.27 245,526.73
- - -
TOTAL 1,942,200.00 97,110.00 1,845,090.00 1,640,261.48 301,938.52 12,801.79 - - 12,801.79 1,653,063.27 289,136.73
- - -

GRAND TOTAL 2,974,536.80 148,726.84 2,825,809.96 - 2,455,729.23 518,807.57 21,520.38 1,102.89 1,102.89 23,726.16 2,479,455.39 495,081.41

Page 1 of 5
FOR MONTH OF JAN-MAR 2023

Fund Cluster : OWWA FUND

DEPRECIATION
ESTIMATED NET BOOK TOTAL ACCUM DEP NET BOOK
DATE RESIDUAL DEPRECIABLE ACCUM DEP
ARTICLE DESCRIPTION TOTAL VALUE USEFUL LIFE VALUE DEPRECIATION PER BOOK VALUE
ACQUIRED VALUE AMOUNT 12/31/2022 JAN FEB MAR
(IN MONTHS) 12/31/2022 CY 2022 CY 2023 CY 2023

JOURNAL ENTRY VOUCHER


Depreciation Expense - Office Equipment #REF!
Depreciation Expense - Furniture and Fixtures #REF!
Depreciation Expense- Motor Vehicles #REF!
Depreciation Expense- Other Property, Plant and
Equipment #REF!
Accumulated Depreciation - Office Equipment #REF!

#REF!
Accumulated Depreciation - Furniture and Fixtures
#REF!
Accumulated Depreciation - Motor Vehicles
Accumulated Depreciation - Other Property, Plant #REF! -
and Equipment
#REF! #REF!

Prepared By: Approved by:

BELLA MAY ESPINO- GUARIN MERIAM T. NICOLAS


OIC, AFD OIC, AFD

Page 2 of 5
OVERSEAS WORKERS WELFARE ADMINISTRATION
REGIONAL WELFARE OFFICE - NATIONAL CAPITAL REGION
GAA FUND LAPSING SCHEDULE 2023
FOR THE PERIOD JAN-MAR 2024

Fund Cluster : GAA FUND

ESTIMATED ACCUMULATED DEPRECIATION DEPRECIATION


DATE UNIT OF NET BOOK VALUE TOTAL NET BOOK VALUE
ARTICLE DESCRIPTION UNIT UNIT VALUE TOTAL VALUE RESIDUAL VALUE DEPRECIABLE AMOUNT USEFUL LIFE (IN DEPRECIATION EXPENSE FOR THE ACCUM DEP 2024
ACQUIRED MEASURE 12/31/2023 DEPRECIATION 2023 2024
MONTHS) 12/31/2023 QTR
JAN FEB MAR

IT EQUIPMENT AND SOFTWARE

LAPTOP

LAPTOP Lenovo IdeaPad 520-151KB(26) 29-Oct-19 4 piece 53,850.00 215,400.00 10,770.00 204,630.00 60 169,978.69 45,421.31 3,465.13 3,465.13 3,465.13 10,395.39 10,395.39 180,374.08 35,025.92

XITRIX TravelPro GL15 (i7)


LAPTOP 05-Oct-22 10 piece 74,000.00 740,000.00 37,000.00 703,000.00 60 175,750.00 564,250.00 11,716.67 11,716.67 11,716.67 35,150.01 35,150.01 210,900.01 529,099.99
(05 Oct 2022)

DESKTOP - - - -

Xitrix DeskFrame E-300 11G CFF


DESKTOP 05-Oct-22 35 piece 56,000.00 1,960,000.00 98,000.00 1,862,000.00 60 465,500.00 1,494,500.00 31,033.33 31,033.33 31,033.33 93,099.99 93,099.99 558,599.99 1,401,400.01
(05 Oct
2022)

2,915,400.00 145,770.00 2,769,630.00 180.00 811,228.69 2,104,171.31 46,215.13 46,215.13 46,215.13 138,645.39 138,645.39 949,874.08 1,965,525.92
TOTAL

JOURNAL ENTRY VOUCHER


138,645.39
Depreciation Expense - IT Equipment
138,645.39
Accumulated Depreciation - IT Equipment
138,645.39 138,645.39

Prepared By: Checked By:

BELLA MAY B. ESPINO-GUARIN LORNA OBEDOZA


SAO Chief, AFD

Page 3 of 5
REGIONAL WELFARE OFFICE - NATIONAL CAPITAL REGION
OWWA LAPSING SCHEDULE
FOR THE PERIOD JAN-MAR 2024

Fund Cluster : OWWA FUND

DEPRECIATION
ESTIMATED NET BOOK TOTAL ACCUM DEP NET BOOK
RESIDUAL DEPRECIABLE ACCUM DEP DEPRECIATION
ARTICLE DESCRIPTION DATE ACQUIRED TOTAL VALUE USEFUL LIFE VALUE DEPRECIATION PER BOOK VALUE
VALUE AMOUNT 12/31/2023 JAN FEB MAR EXPENSE
(IN MONTHS) 12/31/2023 CY 2024 CY 2024 CY 2024

FURNITURES AND FIXTURES

PARTITION
Office Partition installed in RWO-NCR new office
PARTITION 28-Dec-18 85,388.80 4,269.44 81,119.36 120 40,026.01 45,362.79 684.89 684.89 684.89 2,054.67 2,054.67 42,080.68 43,308.12
(Additional) - 36

SIGNAGES
OWWA SIGNAGES OWWA SIGNAGES - 32 05-May-19 52,250.00 2,612.50 49,637.50 120 22,885.50 29,364.50 418.00 418.00 418.00 1,254.00 1,254.00 24,139.50 28,110.50
-
TOTAL 137,638.80 6,881.94 130,756.86 62,911.51 74,727.29 1,102.89 1,102.89 1,102.89 3,308.67 3,308.67 66,220.18 71,418.62

OFFICE EQUIPMENT

AIRCONDITION
Fujiair FE-60CRDB4W 5.0TR Floor Mounted Aircon -
AIRCONDITION 01-Feb-16 93,695.00 4,684.75 89,010.25 120 69,522.42 24,172.58 779.51 779.51 779.51 2,338.53 2,338.53 71,860.95 21,834.05
71

QUEUING SYSTEM
Automizer Queue Management System (AQMS) -
QUEUING SYSTEM with 1 set Dedicated PC for admin/server, 1 unit 17-Apr-18 146,536.00 7,326.80 139,209.20 60 139,209.20 7,326.80 2,459.71 2,459.71 2,459.71 7,379.13 7,379.13 146,588.33 (52.33)
Thermal Ticket Printer - 44

DIGITAL DUPLICATOR
DIGITAL DUPLICATOR Iwata EBR-SA4 Digital Duplicator - 43 08-Jun-18 74,000.00 3,700.00 70,300.00 60 70,300.00 3,700.00 1,237.59 1,237.59 1,237.59 3,712.77 3,712.77 74,012.77 (12.77)

TOTAL 702,733.00 35,136.65 667,596.35 648,108.52 54,624.48 4,476.81 4,476.81 4,476.81 13,430.43 13,430.43 661,538.95 41,194.05

ER PLANT, PROPERTY AND EQUIPMENT (Other PPE)

CCTV CAMERA
CCTV CAMERA IP HD Security/CCTV Camera w/ TV - 35 11-Feb-19 191,965.00 9,598.25 182,366.75 60 179,227.93 12,737.07 3,138.89 3,138.89 3,138.89 9,416.67 9,416.67 188,644.60 3,320.40

TOTAL 191,965.00 9,598.25 182,366.75 179,227.93 12,737.07 3,138.89 3,138.89 3,138.89 9,416.67 9,416.67 188,644.60 3,320.40

MOTOR VEHICLE

MOTOR VEHICLE ISUZU CROSSWIND XUV AT4X2AC - 56 3 May 2017 1,070,000.00 53,500.00 1,016,500.00 84 965,292.96 104,707.04 12,801.79 12,801.79 12,801.79 38,405.37 38,405.37 1,003,698.33 66,301.67
- - - -
TOTAL 1,942,200.00 97,110.00 1,845,090.00 1,793,882.96 148,317.04 12,801.79 12,801.79 12,801.79 38,405.37 38,405.37 1,832,288.33 109,911.67
- - -

GRAND TOTAL 2,974,536.80 148,726.84 2,825,809.96 - 2,684,130.92 290,405.88 21,520.38 21,520.38 21,520.38 64,561.14 64,561.14 2,748,692.06 225,844.74

Page 4 of 5
FOR THE PERIOD JAN-MAR 2024

Fund Cluster : OWWA FUND

DEPRECIATION
ESTIMATED NET BOOK TOTAL ACCUM DEP NET BOOK
RESIDUAL DEPRECIABLE ACCUM DEP DEPRECIATION
ARTICLE DESCRIPTION DATE ACQUIRED TOTAL VALUE USEFUL LIFE VALUE DEPRECIATION PER BOOK VALUE
VALUE AMOUNT 12/31/2023 JAN FEB MAR EXPENSE
(IN MONTHS) 12/31/2023 CY 2024 CY 2024 CY 2024

JOURNAL ENTRY VOUCHER


Depreciation Expense - Office Equipment 13,430.43
Depreciation Expense - Furniture and Fixtures 3,308.67
Depreciation Expense- Motor Vehicles 38,405.37
Depreciation Expense- Other Property, Plant and
Equipment 9,416.67
Accumulated Depreciation - Office Equipment 13,430.43

3,308.67
Accumulated Depreciation - Furniture and Fixtures
38,405.37
Accumulated Depreciation - Motor Vehicles
Accumulated Depreciation - Other Property, Plant 9,416.67 -
and Equipment
64,561.14 64,561.14

Prepared By: Checked by:

BELLA MAY ESPINO- GUARIN LORNA OBEDOZA


OIC, AFD Chief, AFD

Page 5 of 5

You might also like