Att M - VR Match Calculator.xlsx

This is a VR Match Calculator spreadsheet used by the Bureau of Rehabilitation Services (BRS) Vocational Rehabilitation program to calculate contractor cost-sharing requirements for federal funding awards. The document provides examples demonstrating how non-federal match funds are calculated based on the total bid amount submitted by contractors.

The calculator operates on a matching fund formula where contractors must provide non-federal match funds proportional to the federal funds awarded. Example 1 shows federal funding of $100,000.00 requiring a contractor match of $27,064.80, while Example 2 demonstrates federal funding of $500,000.00 with a required contractor match of $135,324.02. The spreadsheet contains adjustable fields in yellow that automatically calculate the required contractor match when the total bid amount is modified. The critical requirement is that the Total Bid Amount submitted on the Cost Proposal must align with the VR federal fund figure to ensure accurate match calculations and contract budget accuracy.