Budget-3.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Sheet 2: Application Budget and Financial Reporting
2	Sheet Objective	There are two parts in this Application Budget and Financial Reporting sheet:
3
4		Part A: Application Budget Template:
5		Applicant applying for any WMF Fund should use this template to state the requested budget and spending plan details
6		Part B: Financial Reporting
7		WMF Grantees ( applicants who received funds) , will use this part to periodically report the financial progress and actual spending of the fund.
8		Note: If you are applying for a WMF Fund , please keep this part empty
9
10	Applicant Name	Progress Gateway NGO
11	Project Title (stated in the Application Form)	Wikipedia Educational Development Outreach in Mongolia
12	WMF Fund Programme	Alliances Fund Programme
13	Local Currency (stated in the Application Form)	Mongolian Tugrik (MNT)
14
15	Part A: Application Budget												Part B: Financial Reporting
16	Part A: Application Budget												( If you are applying for a WMF Fund , please keep this part empty)
17	Total Budget Amount									Note: to only sum the subtotal cells	124,125,080	36,920	0	0	Mid-term report					Final report
18	Total Budget Amount									Note: to only sum the subtotal cells	124,125,080	36,920	0	0	(Please report the funds received and spending in the currency of your fund.)					(Please report the funds received and spending in the currency of your fund.)
19	Program or Strategy number	Program or strategy	Expense category	Expense Item number	Expense item	Description (of how this value is calculated or any other descriptions that are useful)	Unit	Unit Cost	Number of Units	Currency [ select local currency]	Total Cost in Local currency	Total Cost in US dollars	Amount received in Local Currency	Amount received in US dollars	Expense to date in Local currency	Expense to date in US Dollars	Difference in Local Currency	Difference in US Dollars	Explanation of variance and other comments	Final expense in Local Currency	Final expense in US dollars	Difference in Local Currency	Difference in US Dollars	Explanation of variance and other comments
20	Program or Strategy number	Program or strategy	Expense category	Expense Item number	Expense item		Unit	Unit Cost	(Quantity)	Currency [ select local currency]	Total Cost in Local currency	Total Cost in US dollars	Amount received in Local Currency	Amount received in US dollars	Expense to date in Local currency	Expense to date in US Dollars	Difference in Local Currency	Difference in US Dollars	Explanation of variance and other comments	Final expense in Local Currency	Final expense in US dollars	Difference in Local Currency	Difference in US Dollars	Explanation of variance and other comments
21	Place an item number as reference	Please state below the activity / strategy or program title that includes the different costs / expenses	Please choose one of the following categories. Please refer to the Guide (first tab/ Sheet) for definitions of each category and associated items. If there is anything that does not fit your proposal, please state other and describe this expense in detail.	Place an Expense item number as reference	Please select an expense item from the reference. If there is an expense item that does not fit into the following list, please describe the item.	Describe any details regarding this expense and how it is calculated. If you are referring to staff costs please explain each role and responsibility and how their costs are calculating. For instance full-time, part-time based on national salary scales or hourly costs. Please state if you are using any market rate references.	Please state the unit value, for instance a time unit (days, months), number of people, number of materials, etc.	If possible please state the cost of each Unit	State the number of units or requested quantity	Please indicate the currency that aligns with the proposal currency (local currency where the proposal will be developed)	The calculations are generated automatically by multiplying columns H & I	Please convert the total costs istated in column K per local currency to the US Dollars currency using OANDA Rate in this link https://www.oanda.com/currency-converter/en/?from=EUR&to=USD&amount=1	Please report here the received funds	Please convert the total received amount stated in column M per local currency to the US Dollars currency using OANDA Rate in this link https://www.oanda.com/currency-converter/en/?from=EUR&to=USD&amount=1	Please report here the expense to date for the Mid term report	Please convert column O per local currency to the US Dollars currency using OANDA Rate in this link https://www.oanda.com/currency-converter/en/?from=EUR&to=USD&amount=1	The cell calculation is automatically generated.	The cell calculation is automatically generated.	Describe any details regarding this expense difference / variance	Please report here the final expense for the final report	Please convert column T per local currency to the US Dollars currency using OANDA Rate in this link https://www.oanda.com/currency-converter/en/?from=EUR&to=USD&amount=1	The cell calculation is automatically generated.	The cell calculation is automatically generated.	Describe any details regarding this expense difference / variance
22		The activity / startegy or program should align with the program proposal in the application form															In case not please make sure to do deduct Expense to date from the amount received	In case not please make sure to do deduct Expense to date from the amount received				In case not please make sure deduct Final Expense in local currency from the amount received in column M	In case not please make sure to do deduct Final Expense in USD from the amount received in column N
23											In case the formula is missing, Please state the total amount, by multipliying Unit Cots by Number of Units. - Column H & Column I)	and state the conversion date here: OCT 10, 2022		and state the conversion date here:		and state the conversion date here:					and state the conversion date here:
24
25												In case the local currency is US Dollars, plase copy paste column K in Column L
26	Example! Strategy 1	Strategy 1: Organise more online and offline events to retain participants	Administrative	1	Social Media costs	This row represents the social media costs that will be dedicated to cover the activity XXXX under strategy 1 , ...... to outreach .....	Social Media posts per Month		12		0						0	0				0	0
27		Activity 1: Organise one online or offline meetup every month
28		( This strategy / activity mentionned here should be the same in the Grant proposal - in the application form)
29	Strategy 1	Strategy 1. To increase more offline Wikipedia usage which this automatically drives online Wikipedia usage and even expands local Wikipedia size. Activity: Distribute offline Wikipedia to offline communities hence to activite additional online Wikipedia usage	Wikipedia DVD	1	Providing access to offline Wikipedia and other educational free materials to offline students	Through online research and development the media is created	knowledge database per unit DVD	5,801	4580	MNT	26,568,580	7,903					0	0				0	0
30	Strategy 1	Strategy 1 To increase more offline Wikipedia usage and editing training which this automatically drives online Wikipedia usage and even expands local Wikipedia size. Activity: Distribute offline Wikipedia editing means to offline communities hence to activite additional online Wikipedia usage and editing	Editors user guide	2	Providing editing training to offline students who use Wikipedia and edit	Through team members experiences editing knowledge created and transformed into a guide	editing guide and training tool per unit	1,400	42000	MNT	58,800,000	17,490					0	0				0	0
31	Strategy 2,4,8,9	Allowing easier internet access for our internet connection requiring activities such as trainings and editing classes.	Mobile data router	3	This will allow internet connection to offline conditional training and editing events	Internet accessibility equipment	creation of internet access to hard to reach areas	350,000	1	MNT	350,000	104					0	0				0	0
32	Strategy 2,4,8,9	Allowing easier internet access for our internet connection requiring activities such as trainings and editing classes.	Mobile data access fee	4	This will allow internet connection to offline conditional training and editing events	Internet accessibility service	creation of internet access to hard to reach areas	70,000	12	MNT	840,000	250					0	0				0	0
33	Strategy 1-12		Project head	5	Part time		man/month	930,000	12	MNT	11,160,000	3,319					0	0				0	0
34	Strategy 1-12		Project staff 1	6	Full time		man/month	1,860,000	6	MNT	11,160,000	3,319					0	0				0	0
35	Strategy 1-12		Project staff 2	7	Part time		man/month	930,000	6	MNT	5,580,000	1,660					0	0				0	0
36			Social security tax	8	Social security tax for staffs pay			313,875	12	MNT	3,766,500	1,120					0	0				0	0
37	Sub Total										118,225,080	35,165					0	0				0	0
38	Strategy 2,4,8,9	Book development and distribution to expand Wikipedia effect in the educational communities: This creates newer Wikipedia value in the educational environment that multi parties will benefit	Book publishing 1	9	Private donor will cover book publishing	Newer form of educational tool that will open newer ways to learn		1,400,000	1	MNT	1,400,000	416					0	0				0	0
39	Strategy 1-12		Advisor 2	10	Advisor will contribute inkind job performance	Guidance		375,000	12	MNT	4,500,000	1,338					0	0				0	0
40	Sub Total										5,900,000	1,755					0	0				0	0
41
42
43		1. The private donor will donate English text book publishing cost.
44		2. The project advisor will donate/contribute 150 hours of work.
45		3. Attn: For currency conversion the OANDA rate was using one year old rate hence we used local national banks official rate from mongolbank.mn/eng
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100