Att C - Indiana Economic Impact Form.xls
XLS spreadsheet 201 KB Posted
- Attached to
- Negotiated Bid 26-87559 DNR AmmunitionBid Documents State and local contract opportunity
- Solicitation number
- 26-87559
- Issued by
- Johnson County, Indiana
About this file
This is an Indiana Economic Impact Form (Attachment C) instruction document and template issued by the Indiana Department of Administration for use in state and local contract opportunities, specifically referenced in Negotiated Bid 26-87559 for ammunition provision by the Indiana Department of Natural Resources. The form is mandatory for all contractors and vendors seeking to do business with state agencies, regardless of business location, and serves to document the economic impact a project will have on Indiana and its residents. Respondents must complete 22 line items providing company information including legal name, address, federal tax identification number, state of incorporation, parent company details, workforce development and revenue department account numbers, employee counts from the most recent IRS Form W-2 distribution, total payroll information for both Indiana residents and all employees, and the total proposal or contract amount. The form requires detailed accounting of Indiana resident full-time equivalent (FTE) employees assigned specifically to the state contract, with separate sections for prime contractor and subcontractor company information.
The FTE calculation methodology is the primary focus of the form's detailed instructions, defining FTE as a measurement of employee productivity on a specific project where partial time allocations across multiple contracts must be fractionally represented. Respondents must populate the FTE Details worksheet with job titles and corresponding FTE contributions, accounting only for Indiana employees working exclusively or proportionally on the state contract. The form provides examples of FTE calculations for various scenarios, such as employees splitting time equally between two projects or working partial contract terms. The initial contract term is specified as 24 months for calculation purposes. Additionally, the total proposal amount entered on line 16 must correspond with the Cost Proposal Template (Attachment D) and be utilized when completing the MWBE Subcontractor Commitment Form (Attachment A). The form concludes with an affirmation section requiring signature and authorization by an official under penalties of perjury.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Att E - Q&A Template.xlsx | XLSX spreadsheet | |
| Att A - MWBE_Neg Bid.docx | DOCX document | |
| Att F - Attestation Form.docx | DOCX document | |
| Att G - Preferences.docx | DOCX document | |
| Att B - PO Terms.docx | DOCX document | |
| Negotiated Bid Main Document 26-87559.docx.pdf | ||
| Att H - Affidavit of Eligibility.docx | DOCX document | |
| Att D - Cost Proposal Template.xlsx | XLSX spreadsheet | |
| Att A1 - IVOSB_Neg Bid.docx | DOCX document |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| Indiana Economic Impact Form, Attachment C |
| Instructions |
| 1. Complete lines 1 - 15 with the information requested about the company in the Attachment C worksheet. |
All companies desiring to do business with state agencies must complete an “Indiana Economic Impact” form (Attachment C). The collection and recognition of the information collected with the Indiana Economic Impact form places a strong emphasis on the economic impact a project will have on Indiana and its residents regardless of where a business is located. The collection of this information does not restrict any company or firm from doing business with the state.
2. Line 16: Enter total amount of this proposal, bid, or current contract.
This figure is the respondent's total cost proposal to the the state (as sumitted in Attachment D, Cost Proposal Template). Additionally, this total shall be utilized when completing your Attachment A, MWBE Subcontractor Commitment Form.
3. Lines 18 and 21 measure the full-time equivalent (FTE) count of Indiana residents; this number will be auto-populated on Attachment C worksheet. Respondents shall populate the yellow-shaded cells in the FTE Details worksheet.
The state defines FTE as a measurement of an employee's productivity on a specific project or contract. An FTE of 1 would mean that there is one worker fully engaged on a project. If there are two employees each spending 1/2 of their working time on a project that would also equal 1 FTE.
Please populate the yellow-shaded cells in the FTE Details worksheet.
Respondents shall provide a job title for each of the FTE's proposed for The State of Indiana contract as well as the number of FTE that job title contributes to the total.
PROJECT MANAGER - 1 FTE
Please keep in mind that the only FTE's that should be included in this count are Indiana employees working on this contract ONLY. If there are 10 employees working on this contract but they are splitting their time with numerous other contracts as well, then these employees cannot be counted as 1 FTE. Instead, these employees should be counted as a fraction of an FTE. For example: 10 employees working on 4 contracts (1 of them being the State of Indiana contract) - each of the 10 employees would only count as 1/4 of an FTE or .25. Therefore, the total number of FTE's for this scenario would be 2.5.
Attachment C
| This information is required by the Indiana Department of Administration for all contractors, vendors/suppliers to the State of Indiana (complete all 22 items). | |||||
| 1 | Legal Name of firm: | ||||
| 2 | Address/City/State/Zip Code: | ||||
| 3 | Telephone #/Fax #/Website: | ||||
| 4 | Federal Tax Identification Number: | ||||
| 5 | State/Country of domicile/incorporation: | ||||
| 6 | Location of firm's headquarters or principal place of business: | ||||
| 7 | Name of parent company or holding company (if applicable): | ||||
| 8 | State/Country of domicile/incorporation of company listed in #7: | ||||
| 9 | Address of company listed in #7: | ||||
| 10 | IN Department of Workforce Development (DWD) account number: | ||||
| 11 | IN Department of Revenue (DOR) account number: | ||||
| 12 | Number of Indiana resident employees per most recently completed IRS Form W-2 distribution: | ||||
| 13 | Total number of employees per most recently completed IRS Form W-2 distribution: | ||||
| 14 | Total amount of payroll paid to Indiana resident employees per most recently completed IRS Form W-2 distribution: | ||||
| 15 | Total amount of payroll paid to all employees per the most recently completed IRS Form W-2 distribution: | ||||
| 16 | Total amount of this proposal, bid, or current contract: | ||||
| ACCOUNTING OF INDIANA RESIDENT EMPLOYEES | |||||
| 17 | Prime Contractor Company Name: | ||||
| 18 | Number of Full Time Equivalent (FTE) employees that are Indiana residents specifically for this proposal or contract: | 0.00 | |||
| 19 | Subcontractor Company Name: | ||||
| 20 | Address/Contact Person/Telephone Number/Tax ID Number: | ||||
| 21 | Number of Full Time Equivalent (FTE) employees that are Indiana residents specifically for this proposal or contract: | 0.00 | 0.00 | 0.00 | 0.00 |
| 22 | Affirmation by authorized official: I affirm under penalties of perjury that the foregoing representations are true to be the best of my knowledge and belief: | ||||
| Signature: | |||||
| Name of auththorized official: | |||||
| Title: | |||||
| Date: |
INDIANA ECONOMIC IMPACT - PROPOSALS AND CONTRACTS
State Form 51778 (R4 / 1-06)
DEPARTMENT OF ADMINISTRATION
Approved by State Board of Accounts, 2006
FTE Details
FTE DETAILS
Job Titles and Contributing FTE
- Populate the yellow-shaded cells; with all applicable job titles and the total FTE count.
- Respondents may insert additional rows to account for all job titles attributing to the total FTE count.
Please keep in mind that the only FTE's that should be included in this count are Indiana employees working on this contract ONLY. If there are 10 employees working on this contract but they are splitting their time with numerous other contracts as well, then these employees cannot be counted as 1 FTE. Instead, these employees should be counted as a fraction of an FTE. For example: The project length of the contract is 24 months. There are 10 employees working on the contract over the 24 month contract period. 5 employees are working solely on the project for 24 months. 3 employees are working equal time on 2 projects for 24 months. 2 employees are working solely on the project for 6 months.
The FTEs would be calculated as follows:
5 employees x 24 months (24 months working solely on this project) x 1 (time spent solely on this project) = 120 months / 24 months (length of contract) = 5 FTEs 3 employees x 24 months x .5 (splitting time equally between 2 projects) = 36 months / 24 months = 1.5 FTEs 2 employees x 6 months (6 months dedicated solely to this project) x 1 (time spent solely on this project) = 12 months / 24 months = .5 FTEs Column Title Definitions:
Number of Employees = Number of employees working on this State contract.
Duration (In Months) = Amount of time that the employee(s) will spend on the State contract.
Time Spent (Percentage) = Percentage of time the employee(s) will be working on the contract.
| Duration of Initial Contract Term (In Months) | 24 | *Number based on initial contract term | ||
| PRIME CONTRACTOR COMPANY | ||||
| EMPLOYEE JOB TITLE | Number of Employees | Duration (In Months) | Time Spent (Percentage) | NUMBER OF FTE |
| Example: Project Managers | 5 | 24 | 100% | 5.00 |
| Example: Project Coordinators | 3 | 24 | 50% | 1.50 |
| Example: Project Directors | 2 | 6 | 100% | 0.50 |
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| TOTAL FTE COUNT | 0.00 | |||
| SUB CONTRACTOR COMPANY NAME | (Enter Company Name Here) | |||
| JOB TITLE | Number of Employees | Duration (In Months) | Time Spent (Percentage) | NUMBER OF FTE |
| Example: Developer | 2 | 6 | 100% | 0.50 |
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| TOTAL FTE COUNT | 0.00 | |||
| SUB CONTRACTOR COMPANY NAME | (Enter Company Name Here) | |||
| JOB TITLE | Number of Employees | Duration (In Months) | Time Spent (Percentage) | NUMBER OF FTE |
| Example: Developer | 2 | 6 | 100% | 0.50 |
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| TOTAL FTE COUNT | 0.00 | |||
| SUB CONTRACTOR COMPANY NAME | (Enter Company Name Here) | |||
| JOB TITLE | Number of Employees | Duration (In Months) | Time Spent (Percentage) | NUMBER OF FTE |
| Example: Developer | 2 | 6 | 100% | 0.50 |
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| TOTAL FTE COUNT | 0.00 | |||
| SUB CONTRACTOR COMPANY NAME | (Enter Company Name Here) | |||
| JOB TITLE | Number of Employees | Duration (In Months) | Time Spent (Percentage) | NUMBER OF FTE |
| Example: Developer | 2 | 6 | 100% | 0.50 |
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| TOTAL FTE COUNT | 0.00 |
File details come from the government source that posted it. Updated .