Helping nonprofits
and philanthropy achieve
breakthrough strategy,
leadership and results
Newsletters & Alerts

Enter your email address below to sign up for your choice of Bridgespan's knowledge, careers, and leadership newsletters and alerts.

Share |

Nonprofit Cost Analysis - Step #5: Check Your Data

Published Date: 2009-06-03
Author(s): Marta Garcia Abadia    Johnny Lin


Spend a few minutes double-checking the numbers to make sure that you haven’t missed any of the costs during the allocation, and that everything makes intuitive sense. Conduct these four simple checks:


1. Check to see that all costs have been allocated: 
To do this, sum up the allocated costs for all program areas and make sure that the sum is the same as the total original costs (direct plus indirect costs).

2. Check whether each cost item has been allocated correctly: 
For each cost item, make sure that the costs allocated to each program area sum up to the original cost item total. Ensure that there are no negative allocations. Finally, for cost categories where the allocation to a program is 0 (or 0%), make sure there is a legitimate reason for this.

Example:

Allocation
Framework

 

Cost

Education Program

Health Program

Housing Program

Check

Salaries/ benefits of executive director

 

20%

40%

40%

100%

Office rent and utilities

 

33%

33%

33%

100%

Contracting fees

 

0%

90%

10%

100%


Indirect Cost
Allocation

Salaries/ benefits of executive director

$200k

$40k

$80k

$80k

$40k
+$80k
+$80k
=$200k

Office rent and utilities

$20k

$6,667

$6,667

$6,667

$6,667
+$6,667
+$6,667
=$20k

Contracting fees

$5k

0%

$4.5k

$500

$0
+$4.5k
+$500
=$5k

 

3. Check job descriptions/rosters against your cost allocation:
Ensure that you have accounted for all staff members’ time (including part-time staff and contractors/consultants).

4. Verify the logic of your results:

  • For each program, do the biggest cost allocations make sense to you?
  • Across programs, do the relative proportions of each cost category make sense?

For a more detailed example, see:

Sense Check Sample Spreadsheet Excel-16 

Return to top of Check Your Data 


Share |

Comments:

Send us your comments!

 
 
 

« Top of page




Creative Commons License This work by The Bridgespan Group is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 United States License. Permissions beyond the scope of this license may be available at Bridgespan's Terms of Use page.

Special Sections
Government Innovation Initiatives

Explore tools, frameworks, and other resources related to Promise Neighborhoods, the Social Innovation Fund  and other government innovation initiatives.

Read more>>
Daniel StidMore Bang for the Bucks That Help the Neediest
By Daniel Stid

If things are going to change for government-funded nonprofits, we need to focus on what works and spend public money on programs that deliver results.

Read more>>
Matt Forti 80 x 100Refreshing Your Nonprofit Board Dashboard 
By Matt Forti

Here’s a New Year’s resolution you can easily keep: a refreshed dashboard for your board.

Read more>>