Critical Communication

profileAndrewbtman20
unit7BudgetWorksheet.xlsx

Sheet1

Line Item Description Agency Expenses Grant Funding
1000 XX Naloxone Nasal Spray Devices $3500 $20,000
1001 nasal sprayer maintenance $2500
1002 waste removal $270
1003 water and sewer $600
1004 transportation expenses $860
1005 dry cleaning $350
1006 prescription $200
1007 drugs $1500
1008 wages $4500
1009 property taxes $230
1010 other $300
Total Agency Expenses (less grant funding) $14810
In-kind (donated equipment, labor, or services)
2000 insurance and association dues $790
2001 human labor $1200
2002 long term care $800
Total In-kind $2790
Number of devices purchased 5
Total Program Cost (grant funding + agency expenses + in-kind) $17600
Total Agency Cost (total agency expenses) $14,810

&"Arial,Bold"&12Sample Line Item Grant Budget

Nonprofit Works www.nonprofitworks.com (585) 454-4910

EMH311 Unit 7 Assignment: Budget Worksheet

Worksheet Instructions: • Column D should indicate agency expenses and in-kind expenses for the program. Remember, the grant only provides for the purchase of the Naloxone nasal spray devices, so Column F should remain unchanged at $20,000. There is no revenue (income) for this program. • For Line Item 1000, be sure to include the amount of devices being purchased by typing over the "XX". • Type in the description of each line item you choose to include and type in the expense. • If you don't use a line item, delete the text and leave the line item blank. Do not delete the entire line item, as doing this may corrupt the worksheet formula. • Once the worksheet is complete, save it to your computer or device. Then, upload it to the assignment link.

Sheet2

Sheet3