MTDC Calculation Table.xlsx

This file is a Modified Total Direct Costs (MTDC) calculation worksheet for XYZ Organization detailing the budget breakdown for a federal grant proposal. The total direct costs sum to $830,000 across seven categories: personnel ($100,000), fringe benefits ($50,000), travel ($55,000), equipment ($15,000), supplies ($6,000), contractual subawards ($509,000 distributed across four subawards ranging from $39,000 to $200,000), and other direct costs ($95,000 including venue rental and participant support). The worksheet applies $408,000 in exemptions, primarily from participant support costs ($73,000) and the portion of subawards exceeding $50,000 each ($320,000), resulting in a Modified Total Direct Costs base of $422,000. Using a NICRA/15% de minimis indirect cost rate, the calculated indirect costs are $63,300.

The budget is associated with the DRL Transshipment Supply Chain Tracing opportunity, a Department of State Bureau of Democracy, Human Rights and Labor cooperative agreement soliciting proposals up to $1,973,359 to strengthen detection and disruption of transshipment practices evading U.S. forced labor import prohibitions. This opportunity falls under the International Programs to Support Democracy, Human Rights and Labor program (CFDA 19.345), which funds targeted democracy and human rights initiatives globally with annual audit requirements per 2 CFR Subpart F and a seven-year record retention period.