Attachment_14_-_Breakdown_of_Proposed_Estimated_Costs.xlsx
XLSX spreadsheet 362 KB Posted
- Solicitation number
- 75N91019R00029
About this file
This document provides details for a federal solicitation seeking proposals for the Surveillance, Epidemiology, and End Results (SEER) Program. The National Cancer Institute's Surveillance Research Program and Prevention, Control and Population Sciences Branch are soliciting proposals to ramp up additional cancer registries for the SEER Program. Interested offerors should provide epidemiological surveillance of cancer incidence and survival in geographic areas throughout the United States. Proposals are due by the date specified in solicitation number 75N91019R00029. The SEER Program is managed by the Department of Health and Human Services National Institutes of Health National Cancer Institute.
Attachment 14 - Breakdown of Proposed Estimated Costs
View the file
Other files
Show 40 more
Latest 50 of 61 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
INSTRUCTIONS
How to use this Excel file:
This is the mandatory worksheet for submitting your cost proposal. We understand that one spreadsheet format can not fit every situation; however, we have attempted to create a simple model that fits most circumstances that arise in Government contracting. You may need to modify the spreadsheet to fit your circumstances. There are more specific instructions on specific cost element pages where applicable.
To ensure mathematical accuracy the spreadsheet contains formulas to the maximum extent practicable. Do not overwrite the formulas with hardcoded numbers. However, you may edit the formulas as necessary to fit your circumstances. You are responsible for ensuring all numbers are accurate and complete prior to proposal submission.
Historical Actual Costs: Complete Tab
| Summary Pages |
| The totals from each cost element page are automatically carried forward to the Summary worksheets. However, the offeror is responsible for ensuring all formulas are mathematically accurate prior to proposal submission. |
The Government-Share Summary worksheet includes the totals from each Government-Share cost element page. The offeror is responsible for ensuring all formulas are mathematically accurate prior to proposal submission. (Blue Tabs)
The Contractor Share Summary includes the totals from each funding source Summary page (Source #1, Source #2, etc.). The Source Summary worksheets include the total from each funding source cost element page. The offeror may need to add Tabs for additional funding sources. The offeror is responsible for ensuring all formulas are mathematically accurate prior to proposal submission. (Orange Tabs)
The Total Cost Summary includes the Government-Share Summary plus the Contractor-Share Summary and calculates the Contractor-Share contribution percentage. The offeror is responsible for ensuring all formulas are mathematically accurate prior to proposal submission. (Green Tab)
Please immediately contact John Turner (240-276-7756) email at john.turner@nih.gov if you discover any formula errors.
| Direct Labor |
| Use the Labor - Salary worksheet if you track labor on a percent of effort basis. Generally, Universities, Hospitals, and Non-Profit Organizations track labor by percent of effort. |
| Use the Labor - Hourly worksheet if you track labor on an hourly basis. Commercial organizations track labor on an hourly basis. |
| Use both pages if you track some employees by each method. Please do not put any employee on both pages. Consultants should be proposed on the consultants worksheet, not the labor worksheets. |
| The proposed amounts must be based on current payroll information which shows hourly, monthly, or annual rate/salary for each proposed (named) individuals. Acceptable documentation includes any one of the following: 1) personnel action forms, or 2) most recent payroll register showing name, pay rate, and percent of effort if applicable, or 3) copy of pay stub. |
| If the proposed positions have not been filled or are to be named or hired, then acceptable documentation includes the following: 1) letter of intent to hire including salary rate and title, or 2) position descriptions and salary scales or organizational wage table showing salary range and a copy of hiring policy, or 3) a comparable employee's payroll document. Increases for the to be named or hired are not eligible for increases in the first period. |
| Indirect Rates Including Fringe Benefit Rate(s) for Commercial Organizations |
| If your organization does not have negotiated rates, the following website contains information which will assist you in computing indirect rates: http://oamp.od.nih.gov/dfas/IdCSubmission.asp |
| Please do not submit your indirect proposal to the Division of Financial Advisory Services at this time. |
| Points of Contact |
| If you have any questions regarding this Excel file, please contact John Turner (240-276-7756) email at john.turner@nih.gov. |
| If you have contracting questions, please call the NIH Contracting Official who is listed in the RFP. |
Historical Actual Costs
| FY 2018 | FY 2017 | ||||||
| Non Federal (i.e., Home Institution, State, Univ, Cancer Center, Hospital, Other Private) | Federal (CDC) | Other Federal | TOTAL | Non Federal (i.e., Home Institution, State, Univ, Cancer Center, Hospital, Other Private) | Federal (CDC) | Other Federal | TOTAL |
| EXPENSE CATEGORY | ||||||||
| Direct Labor | $ - | $ - | ||||||
| Fringe Benefits | $ - | $ - | ||||||
| Total Labor | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Equipment | $ - | $ - | ||||||
| Materials & Supplies | $ - | $ - | ||||||
| Consultants | $ - | $ - | ||||||
| Travel | $ - | $ - | ||||||
| Subcontracts | $ - | $ - | ||||||
| Other | $ - | $ - | ||||||
| Total Other Direct Costs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
Subtotal: $ - $ - $ - $ - $ - $ - $ - $ -
F&A $ - $ -
Total Expenditures $ - $ - $ - $ - $ - $ - $ - $ -
Total Cost Summary
| CONTRACTOR NAME | |||||||||
| BASE PERIOD | OPTION PERIOD 1 | OPTION PERIOD 2 | OPTION PERIOD 3 | OPTION PERIOD 4 | OPTION PERIOD 5 | OPTION PERIOD 6 | OPTION PERIOD 7 | TOTAL | |
| 5/1/20 | 5/1/21 | 5/1/22 | 5/1/23 | 5/1/24 | 5/1/25 | 5/1/26 | 5/1/27 | ||
| Through | Through | Through | Through | Through | Through | Through | Through | ||
| 4/30/21 | 4/30/22 | 4/30/23 | 4/30/24 | 4/30/25 | 4/30/26 | 4/30/27 | 4/30/28 | ||
| Direct Labor - Percent of Effort | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Fringe Benefits - Percent of Effort | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Direct Labor - Hourly | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Fringe Benefits - Hourly | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Total Direct Labor & Fringe Benefits | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Overhead (Note 1) 0% $0 0% $0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0
| Materials and Supplies | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Professional Travel & Routine Local Travel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Equipment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Consultants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other Direct Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Patient Care Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Subcontracts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Other Direct Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal: Direct Labor, Fringe Benefits, Overhead & Other Directs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Exclusion(s) From Base For G&A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Adjusted Base for G&A | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| G&A (Note 2) | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | $0 |
| Total Proposed Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Contractor Share - Source #1 - Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Contractor Share - Source #2 - Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| (Add Source Tabs as Required) | |||||||||
| TOTAL Contractor Share | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Contractor Share % ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
| 1. | Not all organizations allocate indirect cost in the same way. It is important that you use the indirect rate structure applicable to your organization. |
| For example, if you have a two tier indirect rate structure, then you will use a two tier structure when proposing indirect costs. | |
| Generally, Universities and Non-Profits have fringe benefit and G&A (or sometimes called F&A) rates, while For-Profit Companies can have | |
| various indirect rates such as fringe benefits, overhead, G&A, etc. |
| The base for overhead costs includes direct labor and fringe benefits. Please modify if your base is different. |
| If applicable, insert exclusions to the G&A base in row 25. |
| 2. | If you have questions regarding indirect (F&A) rates see website: http://oamp.od.nih.gov/dfas/IdCSubmission.asp |
| This website also contains definitions, examples, and training. |
Gov-Share Summary
GOVERNMENT SHARE - SUMMARY
| BASE PERIOD | OPTION PERIOD 1 | OPTION PERIOD 2 | OPTION PERIOD 3 | OPTION PERIOD 4 | OPTION PERIOD 5 | OPTION PERIOD 6 | OPTION PERIOD 7 | TOTAL | ||||||||||
| 11/1/20 | 5/1/21 | 5/1/22 | 5/1/23 | 5/1/24 | 5/1/25 | 5/1/26 | 5/1/27 | |||||||||||
| Through | Through | Through | Through | Through | Through | Through | Through | |||||||||||
| 4/30/21 | 4/30/22 | 4/30/23 | 4/30/24 | 4/30/25 | 4/30/26 | 4/30/27 | 4/30/28 | |||||||||||
| Direct Labor - Salary | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Fringe Benefits - Salary | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Direct Labor - Hourly | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Fringe Benefits - Hourly | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Total Direct Labor & Fringe Benefits | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| $0 | ||||||||||||||||||
| Overhead (Note 1) | 0% | $0 | 0% | $0 | 0% | $0 | 0% | $0 | 0% | $0 | 0% | $0 | 0% | $0 | $0 | $0 | ||
| $0 | ||||||||||||||||||
| Materials and Supplies | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Travel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Equipment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Consultants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Other Direct Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Subcontracts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Total Other Direct Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| $0 | ||||||||||||||||||
| Subtotal: | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Exclusion(s) From Base For G&A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Adjusted Base for G&A | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| G&A (Note 2) | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | $0 |
| Total Proposed Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| NOTES: | |
| 1. | Not all organizations allocate indirect cost in the same way. It is important that you use the indirect rate structure applicable to your organization. |
| For example, if you have a two tier indirect rate structure, then you will use a two tier structure when proposing indirect costs. | |
| Generally, Universities and Non-Profits have fringe benefit and G&A (or sometimes called F&A) rates, while For-Profit Companies can have | |
| various indirect rates such as fringe benefits, overhead, G&A, etc. |
| The base for overhead costs includes direct labor and fringe benefits. Please modify if your base is different. |
| If applicable, insert exclusions to the G&A base in row 24. |
| 2. | If you have questions regarding indirect (F&A) rates see website: http://oamp.od.nih.gov/dfas/IdCSubmission.asp |
| This website also contains definitions, examples, and training. |
Gov-Share Salary
GOVERNMENT SHARE - DIRECT LABOR - SALARY
| BASE PERIOD | OPTION PERIOD 1 | OPTION PERIOD 2 | OPTION PERIOD 3 | OPTION PERIOD 4 | OPTION PERIOD 5 | OPTION PERIOD 6 | OPTION PERIOD 7 | |||||||||||||||||||||||||||||||||||||||||
| 11/1/20 | Through | 4/30/21 | 5/1/21 | Through | 4/30/22 | 5/1/22 | Through | 4/30/23 | 5/1/23 | Through | 4/30/24 | 5/1/24 | Through | 4/30/25 | 5/1/25 | Through | 4/30/26 | 5/1/26 | Through | 4/30/27 | 5/1/27 | Through | 4/30/28 | TOTAL | TOTAL | |||||||||||||||||||||||
| CURRENT | ADJUSTED | PERCENT | ||||||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | SALARY | FRINGE | ||||||||||||||||||||||||||||||||||||||||||
| EMPLOYEE | POSITION | BASE SALARY | BASE SALARY | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | COST | COST | |||
| 1 | 0 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | $0 | $0 | |||||||||||||||
| 2 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 3 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 4 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 5 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 6 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 7 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 8 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 9 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 10 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 11 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 12 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 13 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 14 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 15 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 16 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 17 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 18 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 19 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 20 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 21 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 22 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 23 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 24 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 25 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 26 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 27 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 28 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 29 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 30 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 31 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 32 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 33 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 34 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 35 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| SUBTOTALS = | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | $0 | $0 |
| THE FOLLOWING BOXES IN COLUMN "D" BELOW SHALL BE USED TO |
| CALCULATE THE ADJUSTED BASE SALARY, AS INDICATED: |
| (Use of these cells will affect all of the adjusted base salary column; if individual |
| anniversary dates differ, the adjusted base salaries must be entered individually |
| in Column "E" of the spreadsheet and explained in the budget justification) |
| ANNUAL INCREASE FACTOR: | - | Insert annual cost of living % and/or merit increases |
| as applicable and explain the % in the budget justification |
ANNUAL INCREASE DATE: - Insert annual increase date.
NUMBER OF MONTHS AT NEXT ANNUAL INCREASE - Insert number of months at the new salary.
Gov-Share Hourly
GOVERNMENT SHARE - DIRECT LABOR - HOURLY
| BASE PERIOD | OPTION PERIOD 1 | OPTION PERIOD 2 | OPTION PERIOD 3 | OPTION PERIOD 4 | OPTION PERIOD 5 | OPTION PERIOD 6 | OPTION PERIOD 7 | |||||||||||||||||||||||||||||||||||||||
| 11/1/20 | Through | 4/30/21 | 5/1/21 | Through | 4/30/22 | 5/1/22 | Through | 4/30/23 | 5/1/23 | Through | 4/30/24 | 5/1/24 | Through | 4/30/25 | 5/1/25 | Through | 4/30/26 | 5/1/26 | Through | 4/30/27 | 5/1/27 | Through | 4/30/28 | TOTAL | TOTAL | |||||||||||||||||||||
| CURRENT BASE | ADJUSTED | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | SALARY | FRINGE | |||
| EMPLOYEE | POSITION | HOURLY RATE | HOURLY RATE | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | COST | COST | |
| 1 | $0.00 | $0.00 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | $0 | $0 | ||
| 2 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 3 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 4 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 5 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 6 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 7 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 8 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 9 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 10 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 11 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 12 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 13 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 14 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 15 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 16 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 17 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 18 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 19 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 20 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 21 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 22 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 23 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 24 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 25 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 26 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 27 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 28 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 29 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 30 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 31 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| SUBTOTALS = | 0.00 | $0 | $0 | 0.00 | $0 | $0 | 0.00 | $0 | $0 | 0.00 | $0 | $0 | 0.00 | $0 | $0 | 0.00 | $0 | $0 | 0.00 | $0 | $0 | 0.00 | $0 | $0 | $0 | $0 |
| THE FOLLOWING BOXES IN COLUMN "D" BELOW MAY BE USED TO |
| CALCULATE THE ADJUSTED BASE SALARY, AS INDICATED: |
| (Use of these cells will affect all of the adjusted base salary column; if individual |
| anniversary dates differ, the adjusted base salaries must be entered individually in |
| Column "D" of the spreadsheet and explained in the budget justification) |
NUMBER OF HOURS FOR FULL TIME EQUIVALENT: 0 -- Insert your direct work year.
| Insert annual cost of living % and/or merit increases | |||
| ANNUAL INCREASE FACTOR: | 0.00% | -- | as applicable and explain the % in the budget |
| justification |
ANNUAL INCREASE DATE: 00/00/00 -- Insert annual increase date.
NUMBER OF MONTHS AT NEXT ANNUAL INCREASE 0 -- Insert number of months at the the new hourly rate.
*Adjust the number of months per period as recommended in the RFP.
Gov-Share Materials
GOVERNMENT SHARE - MATERIALS AND SUPPLIES
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | Option Period 7 | |||||||||||||||||||
| Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | |||||||||||
| ITEM | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | TOTAL | |
| 1 | 0.00 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | |
| 2 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 3 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 4 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 5 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 6 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 7 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 8 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 9 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 10 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 11 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 12 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 13 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 14 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 15 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 16 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 17 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 18 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 19 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 20 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 21 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 22 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 23 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 24 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 25 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 26 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 27 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 28 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 29 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 30 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| TOTAL = | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| NOTES: |
| 1. The spreadsheet carries Unit Quantity into Option Periods, adjust as necessary to match proposal |
| 2. The spreadsheet applies a 2% escalation factor in Option Periods, adjust as necessary to match proposal. Reference RFP for limitations. |
&24&USUMMARY OF MATERIALS AND SUPPLIES
Gov-Share Travel
GOVERNMENT SHARE - TRAVEL
| Cost Element | Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | Option Period 7 | TOTAL |
| Trip # | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| Site | |||||||||
| Reason | |||||||||
| Airfare | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Lodging | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Meals | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Incidentals | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Ground Transport | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Per Trip | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| No. of persons | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| SUBTOTAL = | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Cost Element | Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | Option Period 7 | TOTAL |
| Trip # | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Site | |||||||||
| Reason | |||||||||
| Airfare | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Lodging | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Meals | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Incidentals | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Ground Transport | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Per Trip | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| No. of persons | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| SUBTOTAL = | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Cost Element | Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | Option Period 7 | TOTAL |
| Trip # | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Site | |||||||||
| Reason | |||||||||
| Airfare | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Lodging | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Meals | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Incidentals | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Ground Transport | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Per Trip | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| No. of persons | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| SUBTOTAL = | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
INSERT ADDITIONAL TRIPS HERE
TOTAL COST BY PERIOD = $0 $0 $0 $0 $0 $0 $0 $0 $0
| NOTES: |
| 1. Cost elements (Airfare, Lodging, Meals, Incidentals, Transportation, Etc.) may be adjusted to match your organization's travel policy. Add or delete rows as required. |
| 2. For additional trips, copy rows 4 through 15 and insert copied cells in row 43. Repeat for all trips proposed. |
| 3. Ensure the formulas for "Total Cost By Period", currently row 45, are updated as additional trips are added. |
| 4. Please review the RFP for the recommended number of trips and destinations if applicable. |
| 5. Please use the company or institutional travel policy unless current Government Per Diem rates are utilized. Please use current vendor quotes for airfare and other travel costs. |
Gov-Share Equipment
GOVERNMENT SHARE - EQUIPMENT
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | Option Period 7 | |||||||||||||||||||
| Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | |||||||||||
| ITEM | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | TOTAL | |
| 1 | 0.00 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | |
| 2 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 3 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 4 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 5 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 6 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 7 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 8 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 9 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 10 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 11 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 12 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 13 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 14 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 15 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 16 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 17 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 18 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 19 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 20 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 21 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 22 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 23 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 24 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 25 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 26 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 27 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 28 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 29 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 30 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| TOTAL = | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| NOTES: |
| 1. The spreadsheet carries Unit Quantity into Option Periods, adjust as necessary to match proposal |
| 2. The spreadsheet applies a 2% escalation factor in Option Periods, adjust as necessary to match proposal. Reference RFP for limitations. |
&24&USUMMARY OF MATERIALS AND SUPPLIES
Gov-Share Consultants
GOVERNMENT SHARE - CONSULTANTS
| BASE PERIOD | OPTION PERIOD 1 | OPTION PERIOD 2 | OPTION PERIOD 3 | OPTION PERIOD 4 | OPTION PERIOD 5 | OPTION PERIOD 6 | OPTION PERIOD 7 | |||||||||||||||||||||||||||||||||||
| 11/1/20 | Through | 4/30/21 | 5/1/21 | Through | 4/30/22 | 5/1/22 | Through | 4/30/23 | 5/1/23 | Through | 4/30/24 | 5/1/24 | Through | 4/30/25 | 5/1/25 | Through | 4/30/26 | 5/1/26 | Through | 4/30/27 | 5/1/27 | Through | 4/30/28 | |||||||||||||||||||
| CONSULTANT | Rate | # Hours | # Days | Travel | Subtotal | Rate | # Hours | # Days | Travel | Subtotal | Rate | # Hours | # Days | Travel | Subtotal | Rate | # Hours | # Days | Travel | Subtotal | Rate | # Hours | # Days | Travel | Subtotal | Rate | # Hours | # Days | Travel | Subtotal | Rate | # Hours | # Days | Travel | Subtotal | Rate | # Hours | # Days | Travel | Subtotal | TOTAL | |
| (1) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||||
| (2) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||||||||||
| (3) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||||||||||
| (4) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||||||||||
| (5) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||||||||||
| (6) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||||||||||
| (7) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||||||||||
| (8) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||||||||||
| (9) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||||||||||
| (10) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||||||||||
| TOTAL = | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Please provide a complete breakdown for each consultant with rates for the number hours or days plus any proposed travel |
| costs. Please obtain a signed letter of commitment which shows the base rate for each consultant. |
Gov-Share ODC
GOVERNMENT SHARE - OTHER DIRECT COSTS
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | Option Period 7 | |||||||||||||||||||
| Description | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | ||||||||||
| Computer Hardware Items | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | TOTAL | |
| 1 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | |
| 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 4 | (Add Rows as Required) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Computer Hardware Subtotal = | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | Option Period 7 | |||||||||||||||||||
| Description | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | ||||||||||
| Computer Software and Licenses | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | TOTAL | |
| 1 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | |
| 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 4 | (Add Rows as Required) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Computer Software and Licenses Subtotal = | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | Option Period 7 | |||||||||||||||||||
| Description | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit | ||||||||||
| Other ODCs | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | Price | Quantity | Subtotal | TOTAL | |
| 1 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | 0 | $0 | $0 | |
| 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 4 | (Add Rows as Required) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other ODCs Subtotal = | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| TOTAL ODCS | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| NOTES: | |||||||||
| 1. The Description for each item must be clear for the reviewer to easily identify what the item is. Recommend using both brand/prodcut names AND general item descriptions, such as "Azure (Virtual Server)". | |||||||||
| 2. The Description for each item should clearly map back to the supporting documentation provided in the Budget Narrative. | |||||||||
| 3. The Budget Narrative must include copies of supporting documentation (e.g. one (1) quote, copy of price list, or catalogue price(s)) for all ODCs with a unit price greater than $500. | |||||||||
| 4. Ensure all Subtotal and Total formulas are mathmatically accurate. |
Gov-Share Subcontracts
GOVERNMENT SHARE - SUMMARY OF SUBCONTRACTS
| SUBCONTRACT # | Base | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | Option Period 7 | TOTAL | |
| (1) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| (2) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| (3) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| (4) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| (5) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| (6) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| (7) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| (8) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| (9) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| (10) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| TOTAL = | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| A complete breakdown and summary sheet for each proposed subcontract must |
| be included with the prime proposal. The same format should be used for both |
| the prime and subcontract proposals. |
Contractor-Share Summary
CONTRACTOR SHARE - SUMMARY
| BASE PERIOD | OPTION PERIOD 1 | OPTION PERIOD 2 | OPTION PERIOD 3 | OPTION PERIOD 4 | OPTION PERIOD 5 | OPTION PERIOD 6 | OPTION PERIOD 7 | TOTAL | |
| 11/1/20 | 5/1/21 | 5/1/22 | 5/1/23 | 5/1/24 | 5/1/25 | 5/1/26 | 5/1/27 | ||
| Through | Through | Through | Through | Through | Through | Through | Through | ||
| 4/30/21 | 4/30/22 | 4/30/23 | 4/30/24 | 4/30/25 | 4/30/26 | 4/30/27 | 4/30/28 | ||
| Direct Labor - Salary | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Fringe Benefits - Salary | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Direct Labor - Hourly | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Fringe Benefits - Hourly | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Total Direct Labor & Fringe Benefits | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Overhead (Note 1) 0% $0 0% $0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0
| Materials and Supplies | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Travel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Equipment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Consultants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Other Direct Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Subcontracts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Total Other Direct Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal: | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Exclusion(s) From Base For G&A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Adjusted Base for G&A | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| G&A (Note 2) | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | $0 |
| Total Proposed Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| NOTES: | |
| 1. | Not all organizations allocate indirect cost in the same way. It is important that you use the indirect rate structure applicable to your organization. |
| For example, if you have a two tier indirect rate structure, then you will use a two tier structure when proposing indirect costs. | |
| Generally, Universities and Non-Profits have fringe benefit and G&A (or sometimes called F&A) rates, while For-Profit Companies can have | |
| various indirect rates such as fringe benefits, overhead, G&A, etc. |
| The base for overhead costs includes direct labor and fringe benefits. Please modify if your base is different. |
| If applicable, insert exclusions to the G&A base in row 24. |
| 2. | If you have questions regarding indirect (F&A) rates see website: http://oamp.od.nih.gov/dfas/IdCSubmission.asp |
| This website also contains definitions, examples, and training. |
Source #1 Summary
| CONTRACTOR SHARE - SOURCE #1 - SUMMARY | ||||||||||||||||
| Contractor Share - Source #1 - Name | ||||||||||||||||
| BASE PERIOD | OPTION PERIOD 1 | OPTION PERIOD 2 | OPTION PERIOD 3 | OPTION PERIOD 4 | OPTION PERIOD 5 | OPTION PERIOD 6 | OPTION PERIOD 7 | TOTAL | ||||||||
| 11/1/20 | 5/1/21 | 5/1/22 | 5/1/23 | 5/1/24 | 5/1/25 | 5/1/26 | 5/1/27 | |||||||||
| Through | Through | Through | Through | Through | Through | Through | Through | |||||||||
| 4/30/21 | 4/30/22 | 4/30/23 | 4/30/24 | 4/30/25 | 4/30/26 | 4/30/27 | 4/30/28 | |||||||||
| Direct Labor - Salary | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||
| Fringe Benefits - Salary | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||
| Direct Labor - Hourly | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||
| Fringe Benefits - Hourly | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||
| Total Direct Labor & Fringe Benefits | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||
| $0 | ||||||||||||||||
| Overhead (Note 1) | 0% | $0 | 0% | $0 | 0% | $0 | 0% | $0 | 0% | $0 | 0% | $0 | 0% | $0 | $0 | $0 |
| Materials and Supplies | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Travel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Equipment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Consultants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Other Direct Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Subcontracts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Total Other Direct Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal: | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Exclusion(s) From Base For G&A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | |||||||||
| Adjusted Base for G&A | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| G&A (Note 2) | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | 0 | 0% | $0 |
| Total Proposed Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| NOTES: | |
| 1. | Not all organizations allocate indirect cost in the same way. It is important that you use the indirect rate structure applicable to your organization. |
| For example, if you have a two tier indirect rate structure, then you will use a two tier structure when proposing indirect costs. | |
| Generally, Universities and Non-Profits have fringe benefit and G&A (or sometimes called F&A) rates, while For-Profit Companies can have | |
| various indirect rates such as fringe benefits, overhead, G&A, etc. |
| The base for overhead costs includes direct labor and fringe benefits. Please modify if your base is different. |
| If applicable, insert exclusions to the G&A base in row 24. |
| 2. | If you have questions regarding indirect (F&A) rates see website: http://oamp.od.nih.gov/dfas/IdCSubmission.asp |
| This website also contains definitions, examples, and training. |
Source #1 Salary
CONTRACTOR SHARE - SOURCE #1 - DIRECT LABOR - SALARY
| BASE PERIOD | OPTION PERIOD 1 | OPTION PERIOD 2 | OPTION PERIOD 3 | OPTION PERIOD 4 | OPTION PERIOD 5 | OPTION PERIOD 6 | OPTION PERIOD 7 | |||||||||||||||||||||||||||||||||||||||||
| 11/1/20 | Through | 4/30/21 | 5/1/21 | Through | 4/30/22 | 5/1/22 | Through | 4/30/23 | 5/1/23 | Through | 4/30/24 | 5/1/24 | Through | 4/30/25 | 5/1/25 | Through | 4/30/26 | 5/1/26 | Through | 4/30/27 | 5/1/27 | Through | 4/30/28 | TOTAL | TOTAL | |||||||||||||||||||||||
| CURRENT | ADJUSTED | PERCENT | ||||||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | PERCENT | |||||||||||||||||||||||||||||||||||||||||||
| OF | NUMBER | SALARY | FRINGE | FRINGE | SALARY | FRINGE | ||||||||||||||||||||||||||||||||||||||||||
| EMPLOYEE | POSITION | BASE SALARY | BASE SALARY | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | EFFORT | MONTHS | COST | RATE | COST | COST | COST | |||
| 1 | 0 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | 0% | 12.00 | $0 | $0 | $0 | $0 | |||||||||||||||
| 2 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 3 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 4 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 5 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 6 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 7 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 8 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 9 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 10 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 11 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 12 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 13 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 14 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 15 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 16 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 17 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 18 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 19 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 20 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 21 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 22 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 23 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 24 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 25 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 26 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 27 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 28 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 29 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 30 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 31 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 32 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 33 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 34 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| 35 | 0 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0% | 12.00 | 0 | 0 | 0 | 0 | |||||||||||||||
| SUBTOTALS = | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | 0% | $0 | $0 | $0 | $0 |
| THE FOLLOWING BOXES IN COLUMN "D" BELOW SHALL BE USED TO |
| CALCULATE THE ADJUSTED BASE SALARY, AS INDICATED: |
| (Use of these cells will affect all of the adjusted base salary column; if individual |
| anniversary dates differ, the adjusted base salaries must be entered individually |
| in Column "E" of the spreadsheet and explained in the budget justification) |
| ANNUAL INCREASE FACTOR: | - | Insert annual cost of living % and/or merit increases |
| as applicable and explain the % in the budget justification |
ANNUAL INCREASE DATE: - Insert annual increase date.
NUMBER OF MONTHS AT NEXT ANNUAL INCREASE - Insert number of months at the new salary.
Source #1 Hourly
CONTRACTOR SHARE - SOURCE #1 - DIRECT LABOR - HOURLY
| BASE PERIOD | OPTION PERIOD 1 | OPTION PERIOD 2 | OPTION PERIOD 3 | OPTION PERIOD 4 | OPTION PERIOD 5 | OPTION PERIOD 6 | OPTION PERIOD 7 | |||||||||||||||||||||||||||||||||||||||
| 11/1/20 | Through | 4/30/21 | 5/1/21 | Through | 4/30/22 | 5/1/22 | Through | 4/30/23 | 5/1/23 | Through | 4/30/24 | 5/1/24 | Through | 4/30/25 | 5/1/25 | Through | 4/30/26 | 5/1/26 | Through | 4/30/27 | 5/1/27 | Through | 4/30/28 | TOTAL | TOTAL | |||||||||||||||||||||
| CURRENT BASE | ADJUSTED | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | NUMBER | NUMBER | SALARY | FRINGE | FRINGE | SALARY | FRINGE | |||
| EMPLOYEE | POSITION | HOURLY RATE | HOURLY RATE | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | HOURS | MONTHS | COST | RATE | COST | COST | COST | |
| 1 | $0.00 | $0.00 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | 0.00 | 12.00 | $0 | 0% | $0 | $0 | $0 | ||
| 2 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 3 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 4 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 5 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 6 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 7 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 8 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 9 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 10 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 11 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 12 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 13 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 14 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 15 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 16 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 | ||
| 17 | 0.00 | 0.00 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0.00 | 12.00 | 0 | 0% | 0 | 0 | 0 |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .