I need help creating financial statements based on the attached files.

Financial Data 1 Revenues Total Revenue 2 Expenses a Rent b c d e Personnel Total Expenses Surplus Deficit 2010 2011 2012 2013 2014 2015 2016 OSIEA Budget Template Please use the following to guide your budget. You will notice that the lines have been categorized according to activity. While this presents a generic budget form and may not capture the entirety of our project budget lines, its important that you maintain the concept of having your budget defined according to the specific objectives and activities defined within each objective. NAME OF ORGANIZATION: SOUTH SUDAN WOMEN'S EMPOWERMENT NETWORK PROJECT TITLE: Advancing Women's Political Participation PROJECT PERIOD: Other Donors Support/ OSF Network Program support (please indicate partner(s) name(s)) Amount requested from OSIEA Line Items Unit Qty Unit Cost Total Cost in US$ Lobbying Non-Lobbying Qty Total Cost in US$ 1 Contribution to Staff salaries (Please use thisNo. format: Title - Full monthly salary x project period in months x % of salary requested from OSIEA) 3,300.00 59,400.00 1.1 Executive Director 1 18 2,200.00 39,600.00 1.2 Program Coordinator 1 18 1,800.00 32,400.00 1.3 Admin and logstic officer 1 18 500.00 9,000.00 1.4 Driver 1 18 1,800.00 32,400.00 1.5 Finance Officer 1 18 Sub-total 172,800 29,376.00 202,176.00 Employee Fringe Benefit 17% Total 2 Women leadership training 2.1 venue 2.2 Meals and Refreshment 2.3 Transport Refund 2.4 Stationaries Days 4 Each 100 Each 100 Lumpsum 1 200.00 20.00 10.00 20.00 Sub-total 3 MEDIA CAMPAIGNS 3.1 RADIO TALKSHOWS 3.2 TV SHOWS 3.3 NEWS PAPERS ARTICLE Each Each Each Each 3 3 2 800.00 2,000.00 1,000.00 20.00 3,820 - - Sub-total 950.00 Page 1 - Qty - - 18.00 18.00 18.00 18.00 18.00 - - - 4.00 100.00 100.00 1.00 - - 3.00 3.00 2.00 - - 420.00 450.00 80.00 140.00 150.00 40.00 Total Project Cost - OSIEA 4 Debates 4.1 Venue 4.2 Refreshment and snacks 4.3 Ground transport 4.4 Communication airtime Each Days each Each Each 4 4 4 4 100.00 150.00 20.00 5.00 Sub-total 5 Public Rallies Campaign 5.1 van hire 5.2 sound system 5.3 Poster and flyers printing 5.4 Media representative Each Days Each Each Each 6 6 600 6 100.00 150.00 5.00 100.00 Sub-total 6 Follow-up meetings 6.1 Meetings 600.00 900.00 3,000.00 600.00 5,100.00 lumpsum 12 100.00 1,200.00 1,200.00 lumpsum 4 250.00 1,000.00 1,000.00 Days Each Each 4 4 4 150.00 100.00 70.00 600.00 400.00 280.00 Sub-total 7 Action plans 7.1 Action plans activities sub-total 400.00 600.00 80.00 20.00 1,100.00 - - - - 4.00 4.00 4.00 4.00 - - - 6.00 6.00 600.00 6.00 12.00 - 4.00 8 Community Dialogue 8.1 Hall hire 8.2 Refreshments 8.3 Sound system 1,280.00 Subtotal 9 Women Network meetings subtotal 10 Networking and strategy Meetings subtotal TOTAL PROJECT COSTS 4.00 4.00 4.00 - lumpsum 3 150.00 450.00 450.00 3.00 lumpsum 4 80.00 320.00 320.00 4.00 217,396.00 6 Administrative/ overhead costs Page 2 OSIEA Administrative costs (should not exceed 15% of total direct costs) Sub-total GRAND TOTAL 32,604.00 32,604 250,000.00 Currency Used Exchange Rate Used Date of Exchange Page 3 OSIEA may not capture the entirety of our ective. Total Project Cost Total Cost in US$ 59,400.00 39,600.00 32,400.00 9,000.00 32,400.00 172,800 29,376.00 202,176.00 800.00 2,000.00 1,000.00 20.00 3,820 420.00 450.00 80.00 950.00 Page 4 OSIEA 400.00 600.00 80.00 20.00 1,100.00 600.00 900.00 3,000.00 600.00 5,100.00 1,200.00 1,200.00 1,000.00 1,000.00 600.00 400.00 280.00 1,280.00 450.00 450.00 320.00 320.00 217,396.00 32,609.40 Page 5 OSIEA 32,604.00 32,604 250,000.00 Page 6 ak Gender and Transitional Justice Budget Line Item Budget Detail Base of Calculation I. Personel Program coordinator 50% Finance and Admin Assistant 100% Driver 50% M&E officer Sub-Total Personel Months Months Months Months Sound System hire Van Hire drama group incentive Refreshment Sub-total Unit unit Pax Pax Hall hire Meals and Refreshments Transport refund Consultation fee return airticket stay permit perdiem and accomodation stationaries Sub-total Unit pax pax pax pax pax pax lumpsum Peace Building activities Sub-total Lumpsums Public Consultation Subtotal for Public consultation on TJ Lumpsum Venue Refreshments Transport refund Sub-total Unit pax pax 4 Theatre Performances awareness raising Training on SGBV Documentation 2 Peace Building activities Public consultation on TJ Dialogue on TJ with local authorities 1 Training for social workers Venue Meals and Refreshments Transport refund SW's Incentives Sub-Total 4 workplan advocacy plan work plan advocacy plan sub-total 4 follow-up meeting Followup meeting with local authorities Sub-Total MEDIA CAMPAIGN AND PUBLICATION Radio talkshows on ch 5 3 Radio jingles sub-total IEC MATERIALS T-shirts Banners Posters Sub-total XIII: Other Operating Costs Communication cost Stationary contribution Internet Connectivity contribution Sub-total Total Bank Charges 2% Grand Total Lumpsums No of units Unit cost (USD) 700 500 200 1200 TOTAL (US$) Frequency 1 1 1 1 8 8 8 4 5,600 4,000 1,600 4,800 16,000 50 50 10 50 1 1 10 10 4 4 4 4 200 200 400 200 1,000 200 20 10 4500 600 350 165 500 1 35 35 1 1 1 1 1 5 5 5 1 1 1 6 1 1,000 3,500 1,750 4,500 600 350 990 500 13,190 1000 1 2 2,000 2,000 1000 1 2 2,000 2,000 200 20 10 1 25 25 1 1 1 200 500 250 700 200 20 10 50 1 25 25 25 1 1 1 4 200 500 250 5,000 5,950 200 1 4 800 800 100 1 4 400 400 148 50 1 1 4 3 592 150 742 20 50 10 140 4 30 1 1 1 2,800 200 300 3,300 138 150 200 1 1 1 1 8 8 138 1,200 1,600 2,938 45,020 980 50,000 NPA BUDGET FOR 2017 ( Amadi State) Line Items Budget Details Base of Calculation Personnel Project Officer 100% Community Mobilizer 100% Finance and Admin Assistant Sub-Total Personel Months Months months Events 16 days of activism - T shrts wth peace messages No of t-shrts Banners wth peace messages No of banners Sub-total 6 Community Events on GBV Awareness Refreshments public Address system Sub-total no of partcpants No of times IEC MATERIALS Banners T-shirts Sub-Total IEC Material No of banners No of t-shrts Travels Perdiem Accomodation Communication cost Ground transport Sub-total for the introduction meetings Flights Days Nights No No venue refreshments/food transport refund Act group incentives stationaries Unit pax pax pax unit Inception Meeting ACT GROUP TRAINING one day ) Sub-total for act group training 2 days Social Workers Training Travels Unit Perdiem Unit Accomodation Venue refreshments/food Transport refund Social Workers incentives Stationaries Sub-total for social worker training Unit unit pax pax pax unit Stationaries transport refund Subtotal for counselling unit pax Travels Unit Perdiem Unit Accomodation Venue Refreshments transport refund stationaries Subtotal know your right Unit unit pax pax unit Refreshment pax transport refund pax Incentives for the trained women leaders Stationaries pax Counseling sessions for 150 clients 1 TOT TRANNG FOR WOMEN LEADERS 5 Intergenerati onal Dialogue Subtotal for intergerational Dialogue Two radio Talkshow Radio talkshows Subtotal for follow up meeting Unit Capactity Building for staff & Board Members staff capacity building on area of specialization Board accommodation Board members meetings Flight cost for Board subtotal Office OPERATING COST Fuel and Maintenance Internet connectivity contribution Stationaries contribution Bank Charges Subtotals Total Budget Grant Total Unit cost (USD) No of units Frequency TOTAL (US$) 700 400 800 1900 1 1 1 9 9 5 6300 3600 4000 13900 10 30 75 1 1 1 750 30 780 3 30 100 1 6 6 1800 180 1980 30 10 2 100 1 1 60 1000 1060 275 35 20 5 5 2 2 2 2 2 2 10 2 2 3 1100 700 80 20 30 1930 30 10 5 10 40 1 36 36 36 1 1 1 1 6 1 30 360 180 2160 40 2770 275 2 1 550 35 1 4 140 20 30 10 5 15 40 1 1 6 6 6 1 3 3 3 3 6 1 60 90 180 90 540 40 1690 40 2 1 10 1 6 40 120 160 275 1 2 550 35 1 4 140 20 30 10 5 30 1 1 20 20 1 2 2 2 2 1 40 60 400 200 30 1420 3 150 5 2250 5 150 5 3750 10 20 5 1000 40 1 1 40 `` 7040 100 1 2 200 200 1000 500 1200 100 1 1 1 1 2 1 1 4 2000 500 1200 400 4100 80 150 50 50 1 1 1 1 9 9 9 9 720 1350 450 450 2970 40000 40,000.00