Still loading...
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | FINANCIAL REPORT AND FORECAST | ||||||||
2 | Agency: | ||||||||
3 | Period Covered: | Currency: US$ | |||||||
4 | Contract No: | ||||||||
5 | Line Item | Contract Amount | Expenditure Cumulative Up to April | Expenditure May to July | August to October | Total Balance | Means of verification (e.g contract, PV) | Next period Estimates | |
6 | A | Income from Client | $998,232 | ||||||
7 | Balance b/f from | $13,386 | |||||||
8 | Funds received this period | $734,616 | $271,836 | ||||||
9 | Total | $285,222 | |||||||
10 | B | EXPENDITURE FOR THE PERIOD | |||||||
11 | Line Item | Total Budget Estimates | |||||||
12 | Message harmonisation | $1,840 | $1,587 | $0 | $0 | $253 | |||
13 | Training of the gatekeepers (LGA staff - regional & district) | $29,764 | $29,764 | $0 | $0 | $0 | |||
14 | Training of the gatekeepers (distrtict LGA) | $8,905 | $8,905 | $0 | $0 | $0 | |||
15 | Training of journalist and editors | $11,430 | $11,931 | $0 | $0 | -$501 | |||
16 | Develop and Print training manual/ kit | $0 | $0 | $0 | |||||
17 | Develop and produce low literacy print & IEC materials | $100,440 | $82,200 | $48,720 | $30,790 | -$61,270 | |||
18 | Produce Point of sale and Outdoor material | $47,300 | $1,500 | $12,000 | $33,800 | $24,882 | |||
19 | Produce and place Radio and TV spots (addition of interactive radio shows for 1 month in 5 stations) | $405,000 | $188,793 | $50,650 | $114,825 | $50,732 | $151,875 | ||
20 | Engage Social Media | $3,000 | $1,500 | $0 | $2,250 | -$750 | $2,250 | ||
21 | Orient food vehicle manufactures' sales team on ..... | $2,545 | $625 | $0 | $0 | $1,920 | |||
22 | SMS Campaign | $9,000 | $0 | $0 | $9,000 | ||||
23 | Mid media activities | $95,940 | $96,750 | $40,000 | -$40,810 | $13,985 | |||
24 | Press Launch | $12,800 | $21,677 | $0 | $0 | -$8,877 | |||
25 | Publicity | $5,000 | $5,000 | $0 | $0 | $0 | $1,250 | ||
26 | Regional/ district activities with CBOs (subcontract + training volunteers) | $62,320 | $31,160 | $18,800 | $9,860 | ||||
27 | Evaluation of the campaign through Omnibus survey | $10,000 | $0 | $10,000 | $0 | $10,000 | |||
28 | Mass media and activity monitoring | $35,000 | $6,480 | $2,532.50 | $2,565.00 | $23,423 | $8,750 | ||
29 | Subtotal Programs | $840,284 | $358,462 | $231,313 | $231,230 | $222,852 | |||
30 | |||||||||
31 | Administration | ||||||||
32 | Staff salaries | $61,800 | $42,800 | $15,450 | $5,622 | $27,350 | $12,875 | ||
33 | Campaign Management costs | $5,400 | $2,554 | $1,416 | $1,138 | $1,125 | |||
34 | Subtotal | $67,200 | $45,354 | $16,866 | $5,622 | $28,488 | $14,000 | ||
35 | |||||||||
36 | Sub Total B | $907,484 | $403,816 | $248,179 | $255,490 | $236,852 | |||
37 | Agency fee @ 10% | $90,748 | $40,382 | $24,818 | $25,549 | $23,685 | |||
38 | TOTAL EXPENDITURE | $998,232 | $444,198 | $272,996 | $281,038 | $260,537 | |||
39 | C | BALANCE (Surplus/Deficiency) for the reporting period | $4,184 | ||||||
40 | |||||||||
41 | |||||||||
42 | D | NEXT PERIOD ESTIMATES (August and October 2016) | $260,537 | ||||||
43 | |||||||||
44 | |||||||||
45 | E | FUNDS REQUESTED FOR THE PERIOD FROM AUGUST to OCTOBER 2016 | $256,354 | ||||||
46 | |||||||||
47 | |||||||||
48 | Prepared by: ................. | Approved by: .......................... | |||||||
49 | |||||||||
50 | Signature ………………………………………………… | Signature ………………………………………………… | |||||||
51 | Date: | Date: | |||||||
52 | |||||||||
Loading...