Suggested Budget Template.xlsx

XLSX spreadsheet 37 KB Posted Jun 20, 2019

Attached to: Design And Implementation Of The English Access Microscholarship Program, 2020-2021
Opportunity number: DOS-PTA-201914
Issued by: Department of State

About this file

From the source

Suggested Budget Template

View the file

Other files

File	Type	Posted
Suggested Results Framework Template.xlsx	XLSX spreadsheet	Jun 20, 2019
Suggested Award Proposal Template.docx	DOCX document	Jun 20, 2019
Suggested Applicant Organizational Information Sheet.docx	DOCX document	Jun 20, 2019
SF424B.pdf	PDF	Jun 20, 2019
SF424A.pdf	PDF	Jun 20, 2019
SF424.pdf	PDF	Jun 20, 2019
DOS-PTA-201914 English Access Microscholarship Program, 2020-2021.pdf	PDF	Jun 20, 2019

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

INSTRUCTIONS

	INSTRUCTIONS
	1. DO NOT CHANGE FORMULAS OR EXCHANGE RATE
	2. DO NOT ADD INFORMATION TO THIS TAB. Use the other tab.
	3. For costs in Rand, enter the information in the green cells only.
	4. For costs in US Dollars, use the currency rate provided to calculate costs in Rand and enter that amount.
	5. The yellow cells are summations. DO NOT CHANGE FORMULAS.
	6. The GO/GOR will check the summations in yellow but applicants should check that all of the appropriate cells are included.
	7. If you need to add additional line items to a category, simply insert a line above item 5 in the appropriate section. You can then drag the formula down from the cell above.
	8. Unless the applicant organization has a NICRA, the maximum admin/overhead is 10%, which is calculated automatically in item 8.
	9. DO NOT CHANGE FORMULAS.
U.S. Embassy Pretoria Budget Template

Project Name:

Emmonskl: Emmonskl:

Enter this informtion Grantee:

Exchange rate at time of approval: 13.35 Emmonskl: Emmonskl:

Embassy will enter the official exchange rate at time of approval

	Approved Budget	Actual Expenses (Reporting Period of xx to xx)
Description

Emmonskl: Emmonskl:

In the description category, include a clear and distinguishable description of what it is. These categories are legal requirements and cannot be changed. Cost (Rand) Emmonskl: Emmonskl:

Cost each unit Quantity Emmonskl: Emmonskl:

How many units Total (Rand) Cost ($) Quantity Total ($) Expenses (R) Emmonskl: Emmonskl:

These are reporting cells, and expense amounts are added for each line item once the project is already underway. For an application, leave these blank.	Expenses ($)		Balance (R)	Balance ($)
		1	Personnel
		1.1	Project Director (consultant)		200	100	20,000.00	$ 14.98	100	$ 1,498.13		$ - 0	20,000.00	$ 1,498.13
		1.2	Project Accountant		150	50	7,500.00	$ 11.24	50	$ 561.80		$ - 0	7,500.00	$ 561.80
		1.3	Honoraria for artists (2 people x 1 day)		1200	2	2,400.00	$ 89.89	2	$ 179.78		$ - 0	2,400.00	$ 179.78
		1.4					- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
		1.5					- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
			SUBTOTAL				29,900.00			$ 2,239.70	- 0	$ - 0	29,900.00	$ 2,239.70

2	Travel
2.1	Transport from Limpopo to Pretoria (2 people x 4 trips)	150	8	1,200.00	$ 11.24	8	$ 89.89		$ - 0	1,200.00	$ 89.89
2.2	Plane ticket for U.S. artist (JFK to JNB)	16000	1	16,000.00	$ 1,198.50	1	$ 1,198.50		$ - 0	16,000.00	$ 1,198.50
2.3				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
2.4				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
2.5				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL			17,200.00			$ 1,288.39	- 0	$ - 0	17,200.00	$ 1,288.39

3	Equipment (per unit cost of $5,000 or more)
3.1		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
3.2		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
3.3		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
3.4		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
3.5		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL	- 0			$ - 0	- 0	$ - 0	- 0	$ - 0

4	Supplies/Materials (per unit cost of less than $5,000)
4.1	Pencils (box)	100	5	500.00	$ 7.49	5	$ 37.45		$ - 0	500.00	$ 37.45
4.2	Notebooks (each)	15	200	3,000.00	$ 1.12	200	$ 224.72		$ - 0	3,000.00	$ 224.72
4.3	Snacks for workshop (2 snacks per day x 3 days)	1000	6	6,000.00	$ 74.91	6	$ 449.44		$ - 0	6,000.00	$ 449.44
4.4	Point-and-shoot camera	900	5	4,500.00	$ 67.42	5	$ 337.08		$ - 0	4,500.00	$ 337.08
4.5				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL			14,000.00			$ 1,048.69	- 0	$ - 0	14,000.00	$ 1,048.69

5	Contractual
5.1	Rental of chairs for final ceremony	1500	1	1,500.00	$ 112.36	1	$ 112.36		$ - 0	1,500.00	$ 112.36
5.2	License for music	2400	1	2,400.00	$ 179.78	1	$ 179.78		$ - 0	2,400.00	$ 179.78
5.3				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
5.4				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
5.5				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL			3,900.00			$ 292.13	- 0	$ - 0	3,900.00	$ 292.13

6	Construction
6.1	PAS DOES NOT FUND CONSTRUCTION - DO NOT INCLUDE			- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
6.2				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
6.3				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
6.4				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
6.5				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL			- 0			$ - 0	- 0	$ - 0	- 0	$ - 0
				- 0						- 0	$ - 0
7	Other direct costs
7.1	WiFi fee for classroom (3 days)	250	3	750.00	$ 18.73	3	$ 56.18		$ - 0	750.00	$ 56.18
7.2				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
7.3				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
7.4				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
7.5				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL			750.00			$ 56.18	- 0	$ - 0	750.00	$ 56.18

TOTAL DIRECT COSTS 65,750.00 $ 4,925.09 - 0 $ - 0 65,750.00 $ 4,925.09

8 Indirect costs 65,750.00 10% 6,575.00 $ 4,925.09 10% $ 492.51 $ - 0 6,575.00 $ 492.51

PROJECT TOTAL	72,325.00	$ 5,417.60	- 0	$ - 0	72,325.00	$ 5,417.60
	5,417.60

Percents of total
Personnel	41.3%

Emmonskl: Emmonskl:

These wil automatically calculate

Emmonskl: Emmonskl:

Enter this informtion Emmonskl: Emmonskl:

These are reporting cells, and expense amounts are added for each line item once the project is already underway. For an application, leave these blank.	Travel	23.8%
		Equipment (per unit cost of $5,000 or more)	0.0%
		Supplies/Materials (per unit cost of less than $5,000)	19.4%
		Contractual	5.4%
		Construction	0.0%
		Other direct costs	1.0%
		Indirect costs	9.1%

&"Times New Roman,Regular"&12&A

&"Times New Roman,Regular"&12Page &P

Budget vs. Actual Format U.S. Embassy Pretoria Budget Template

Project Name:

Grantee:

Exchange rate at time of approval: 13.95

		Approved Budget						Actual Expenses (Reporting Period of xx to xx)
	Description	Cost (Rand)	Quantity	Total (Rand)	Cost ($)	Quantity	Total ($)	Expenses (R)	Expenses ($)	Balance (R)	Balance ($)
1	Personnel
1.1				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
1.2				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
1.3				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
1.4				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
1.5				- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL			- 0			$ - 0	- 0	$ - 0	- 0	$ - 0

2	Travel
2.1		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
2.2		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
2.3		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
2.4		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
2.5		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL	- 0			$ - 0	- 0	$ - 0	- 0	$ - 0

3	Equipment (per unit cost of $5,000 or more)
3.1		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
3.2		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
3.3		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
3.4		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
3.5		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL	- 0			$ - 0	- 0	$ - 0	- 0	$ - 0

4	Supplies/Materials (per unit cost of less than $5,000)
4.1		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
4.2		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
4.3		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
4.4		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
4.5		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL	- 0			$ - 0	- 0	$ - 0	- 0	$ - 0

5	Contractual
5.1		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
5.2		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
5.3		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
5.4		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
5.5		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL	- 0			$ - 0	- 0	$ - 0	- 0	$ - 0

6	Construction
6.1		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
6.2		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
6.3		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
6.4		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
6.5		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL	- 0			$ - 0	- 0	$ - 0	- 0	$ - 0
		- 0						- 0	$ - 0
7	Other direct costs
7.1		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
7.2		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
7.3		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
7.4		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
7.5		- 0	$ - 0	0	$ - 0		$ - 0	- 0	$ - 0
	SUBTOTAL	- 0			$ - 0	- 0	$ - 0	- 0	$ - 0

TOTAL DIRECT COSTS - 0 $ - 0 - 0 $ - 0 - 0 $ - 0

8 Indirect costs - 0 10% - 0 $ - 0 10% $ - 0 - 0 $ - 0 - 0 $ - 0

PROJECT TOTAL	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
	- 0

Percents of total
Personnel	ERROR:#DIV/0!
Travel	ERROR:#DIV/0!
Equipment (per unit cost of $5,000 or more)	ERROR:#DIV/0!
Supplies/Materials (per unit cost of less than $5,000)	ERROR:#DIV/0!
Contractual	ERROR:#DIV/0!
Construction	ERROR:#DIV/0!
Other direct costs	ERROR:#DIV/0!
Indirect costs	ERROR:#DIV/0!

&"Times New Roman,Regular"&12&A

&"Times New Roman,Regular"&12Page &P

File details come from the government source that posted it.