MTDC Calculation Table.xlsx

This is a Modified Total Direct Costs (MTDC) calculation worksheet for XYZ Organization's budget submission to the Early Warning and Response in Nigeria program, a Cooperative Agreement opportunity funded by the Department of State Bureau of Democracy, Human Rights and Labor (BDHRL) under CFDA 19.345. The organization's total direct costs are $830,000, comprised of personnel ($100,000), fringe benefits ($50,000), travel ($55,000), equipment ($15,000), supplies ($6,000), contractual subawards ($509,000 across four awards), and other direct costs ($95,000 including venue and childcare for participants).

The MTDC calculation applies $408,000 in exemptions, reducing the modified total direct costs to $422,000. Exempted amounts include equipment ($15,000), participant support costs ($73,000), and the portion of each subaward exceeding $50,000 ($320,000 total across the four subawards). Using either a NICRA or 15% de minimis indirect cost rate, the resulting indirect costs total $63,300. This budget structure supports the DRL's initiative to pair civil society-led early warning networks with strengthened government rapid response capacity across Nigeria's Middle Belt through community monitors, secure communications systems, and joint coordination centers linking federal, state, and local responders to real-time threat data.