Spreadsheet: 888078d1738433139-import-data-per-year-per-category-annex-1-excel-test-ssm-mykolaiv-drc-ukraine
Sheet: 1. Financial report - DRC 001

AREA | Kharkiv - Ukraine
Donor | DRC 001
Start date | 2024-01-01 00:00:00
Ending date | 2024-12-31 00:00:00
 |  |  |  |  |  |  |  | ACTUAL PER MONTH
Activity number | Cost Category | Unit Quantity | Unit of Measure | Unit Quantity | Unit of Measure | Unit cost | Total Amount (Euros) | 1_2024 | 2_2024 | 3_2024 | 4_2024 | 5_2024 | 6_2024 | 7_2024 | 8_2024 | 9_2024 | 10_2024 | 11_2024 | 12_2024 | Total | BALANCE | %
 | 1. Salaries
 | 1.1 Field Staff
 | Expatriates
UKR-004823 | Area Manager | 1 | person | 1 | Months | 5970
UKR-004824 | Project Manager [NAME] | 1 | person | 3 | Months | 4567
 | SUBTOTAL: Expatriate Field Staff
 | Local Staff
UKR-004826 | Support Services Manager | 1 | person | 1 | Months | 2750
UKR-004827 | Livelihood Team Leader | 1 | person | 1 | Months | 5525
UKR-004828 | Livelihood Assistants | 4 | person | 6 | Months | 1282
[NAME] | ME Officer | 1 | person | 3 | Months | 2722
UKR-004830 | ME Assistant | 1 | person | 3 | Months | 1367
UKR-004831 | Supply Chain Officer | 1 | person | 3 | Months | 2140
UKR-004832 | Supply Chain Asistants (Warehouse & Logistics) | 1 | person | 3 | Months | 1270
UKR-004833 | Finance Officer | 1 | person | 3 | Months | 1726
UKR-004834 | Finance & Administration Assistant | 1 | person | 3 | Months | 1290
UKR-004835 | Security Officer | 1 | person | 3 | Months | 2137
UKR-004836 | Cleaners/Cooks | 1 | person | 1 | Months | 710
UKR-004837 | [NAME] | 2 | person | 3 | Months | 841
UKR-004838 | Finance & Administration Assistant | 1 | person | 1 | Months | 1361
UKR-004839 | Drivers | 2 | person | 1 | Months | 861
UKR-004840 | National Staff Capacity Building | 1 | Lumpsum | 1 | Forfait | 569
 | SUBTOTAL: Local Field Staff
 | 1.1 – SUBTOTAL: Field Staff
 | TOTAL: SALARIES
 | 2. [NAME]
UKR-004771 | International Staff | 1 | person |  | Months
UKR-004772 | National Staff | 1 | person | 57 | Months | 50
UKR-004773 | R&R Allowance (international) | 1 | person | 1 | travel
 | TOTAL: FRINGE BENEFITS
 | 4. Program Supplies, Materials, and Equipment less than $5,000
UKR-004774 | Unconditional Food vouchers transfer in rural areas | 800 | transfer | 4 | Months | 90
UKR-004775 | Community based awareness, training and meeting sessions | 1 | session | 1 | time | 150
[NAME] | Programme materials | 1 | lumpsum | 1 | time | 5000
UKR-004777 | Monitoring and Evaluation surveys | 1 | lumpsum | 2 | survey | 1800
 | TOTAL: PROGRAM SUPPLIES
 | 5. Travel and Transport
 | 5.1 International and Regional Air Travel
UKR-004792 | International Travel | 1 | person | 1 | travel | 1000
 | 5.1 – SUBTOTAL: International/Regional  Air Travel
 | 5.2 In-Country Air Travel
UKR-004793 | International Staff In-Country Travel | 3 | person | 2 | travel | 180
UKR-004794 | National Staff In-Country Travel | 5 | person | 1.667 | travel | 180
UKR-004795 | Regional Staff In-Country Travel | 1 | person | 2 | travel | 180
 | 5.2 – SUBTOTAL: In-Country Air Travel
 | 5.4 In-Country Per Diem
UKR-004796 | Staff travel & accomodation | 15 | persons | 8 | days | 15
 | 5.4  – SUBTOTAL: In-Country Per Diem
 | 5.5 In-Country Ground Transportation
UKR-004797 | Vehicle Depreciation | 2 | vehicle | 3 | Months | 3000
[NAME] | Vehicle Fuel & Maintenance | 2 | vehicle | 3 | months | 300
UKR-004799 | Vehicle Rental - Coordination | 1 | vehicle | 1 | Months
UKR-004800 | Vehicle Depreciation | 1 | vehicle | 1 | Months | 100
UKR-004801 | Vehicle Fuel & Maintenance | 1 | vehicle | 1 | months | 2500
 | 5.5 – SUBTOTAL:  In-Country Ground Transportations
 | TOTAL: TRAVEL, PER DIEM & TRANSPORT
 | 9. Contractual/Sub-Awards
UKR-004782 | Financial Services Provider charges/fees (3%) of transfer value | 1800 | person | 1 | Lumpsum | 2.8
UKR-004783 | Enumerators - M&E Data Collection for surveys | 5 | person | 5 | Days | 35
 | TOTAL: CONTRACTUAL/SUB-AWARDS
 | 10. Other Direct Costs
 | 10.1 Office Operation Costs
UKR-004802 | Office | 1 | office | 1 | Months | 4500
UKR-004803 | Premises Rentals-Office & guest house | 1 | Base | 2 | Months | 4000
UKR-004804 | Premises Rentals guest house | 1 | office | 1 | Months | 2000
UKR-004805 | Supplies and utilities | 1 | office | 1 | Months | 400
UKR-004806 | Supplies and utilities - Sub-office | 1 | offices | 2 | Months | 3400
UKR-004807 | Office Furniture | 1 | Lumpsum | 1 | Lumpsum | 2800
UKR-004808 | Internet and communication | 1 | office | 1 | Months | 850
UKR-004809 | Internet and communication - Sub-office | 1 | office | 2 | Months | 2300
UKR-004810 | Programme annual review and coordination meetings | 1 | lumpsum | 1 | trainings | 350
UKR-004811 | Computer hardwares and licenses | 1 | Laptops | 1 | pieces | 2500
UKR-004812 | IT Equipment Repair and supplies | 1 | Lumpsum | 2 | months | 40
UKR-004813 | IT Dynamics Licences | 1 | Lumpsum | 2 | Months | 800
UKR-004814 | Communication support items (phones, tablets, etc.) | 1 | Lumpsum | 1 | Lumpsum | 1820
UKR-004815 | Office maintenance | 1 | Lumpsum | 2 | months | 400
UKR-004816 | Bank /administrative charges | 1 | account | 2 | months | 200
[NAME] | Security related costs | 2 | offices | 2 | months | 50
UKR-004818 | Visas, work permits and legal fees | 3 | person | 1 | Renewals | 350
UKR-004819 | Legal fees - Lawyer | 1 | person | 1 | months | 50
 | 10.1 – SUBTOTAL: Office Operation Costs
 | 10.3 Branding and Marking
UKR-004820 | Project site and staff visibility | 1 | Voucher | 1 | Lumpsum | 100
 | 10.3 – SUBTOTAL: BRANDING AND MARKING
 | TOTAL: OTHER DIRECT COSTS
 | 12. 2 Audit participation Costs
UKR-004786 | TOTAL: Audits | 1 | lumpsum | 0.5 | Audit | 1500
 | TOTAL DIRECT COSTS
 | 13. Indirect Costs
 | Indirect Costs |  |  |  | 0.07
 | TOTAL