Personnel Table Name Responsibilities Total Hours Hourly Rate Fringe Total Cost EXAMPLE PERSONNEL Personnel Table Name Title Responsibilities Total Hours* Hourly Rate Fringe Total Cost Jane Smith MTS Project Director Manages the scope, budget, and schedule for the entire project 520 40.50 4576.23 $ 25,636.23 Chris Horwath Administrative Assistant Provides assistance with data entry and conversion 260 18.25 2288.69 $ 7,033.69 Joseph Davis Department of Information Technology Ensures the IT needs are met for MTS Responsible for installing and setting up workstations 260 25.26 4576.23 $ 11,143.83 Mike Petworth Contractor: System Integration Sets up computer networks 960 27.65 N/A $ 26,544.00 Julie Tierny Temporary Services Company Case data and clean-up 960 20.31 N/A $ 19,497.60 Max Yuelle Training Lead Receives training and ready to train additional staff Develops training materials as needed. 260 21.64 2288.69 $ 7,915.09
Budget – Tribal and Federal Funding Shares for FFY 20XX Budget Items FFQ 1 Oct. 1 31 FFQ 2 Jan. 1 – March 31 FFQ 3 April 1 – June 30 FFQ 4 July 1 – Sept. 30 Totals Tribal Share (X%) Federal Share (X%) TOTAL ALL LINE ITEMS The total budget amount as listed in the tables above CANNOT exceed the Tribal IV-D grant award for the same federal fiscal year. Please list your current Tribal IV-D grant award amount in the table below. Note that the Tribal IV-D grant award amount represents the federal share of the total tribal child support budget for the federal fiscal year in which this APD is submitted. Tribal Budget for FFY 20XX Total Tribal Program Budget for FFY 20XX EXAMPLE BUDGET TABLES Budget for Federal Fiscal Year 2014 Budget FFQ 1 Oct. 1 – 31 FFQ 2 Jan. 1 – March 31 FFQ 3 April 1 – June 30 FFQ 4 July 1 – Sept. 30 Totals Tribal 30,802.44 30,802.44 30,802.44 30,802.44 $123,209.76 Hardware 4,816.08 $4,816.08 Software 5,275.90 $5,275.90 Training 10,155.80 10,155.80 $20,311.60 Travel 13,000.00 $13,000.00 Contracts
Your project may have 20 or more activities depending on how you plan on breaking down each task. EXAMPLE PROJECT TASK Task 1: Train Staff REQUIREMENT: Tribal IT staff need to be trained to install, operate and maintain daily operational availability of the Model Tribal System, including: initial installation, component upgrades, security, data backup and restore, database and operating system restarts, document management, report generation and batch processing operations. All Tribal IT Staff will attend one two-week training course, then receive on-site follow-on training (On-The-Job or OJT Training.). Acme Inc. will perform training for staff. Training Facilities Rental: October 1, 2013 – October 13, 2013 Classroom Instruction: October 20, 2013 – November 12, 2013 On-Site Instruction: December 10, 2013 – December 12, 2013 Helpdesk Support: December 10, 2013 – February 28, 2014 Current Status: Pending approval of APD Once you have completed building out your schedule, you must then create a high level Gantt chart that outlines the timeframes for each task. This can be accomplished using a simple table as shown below. EXAMPLE CHART Chart for Project Tasks FFQ 1 Oct. 1 –Dec. 31 FFQ 2 Jan. 1 – March 31 FFQ 3 1 – June 30 FFQ 4 July 1 – Sept. 30 Task 1