Att C - Indiana Economic Impact Form.xls

XLS spreadsheet 201 KB Posted

Attached to
IDOA Dumpsters, compactors, and recycle binsBid Documents
Solicitation number
26-87805
Issued by
Indiana

About this file

This is an Indiana Economic Impact Form (State Form 51778) required by the Indiana Department of Administration for all contractors and vendors/suppliers seeking to do business with state agencies. The form serves as a standardized information collection tool to assess the economic impact of proposed projects and contracts on Indiana and its residents, regardless of the contractor's location. Completion of the form is mandatory for all companies desiring state contracts but does not restrict any firm from conducting business with the state.

The form requires respondents to provide comprehensive company information including legal name, federal tax identification number, state of incorporation, headquarters location, and parent company details if applicable. Critical requirements include documentation of Indiana resident employee counts based on the most recently completed IRS Form W-2 distribution, total payroll figures for both Indiana residents and all employees, and the total cost proposal for the contract. The form also mandates calculation of Full-Time Equivalent (FTE) employees who are Indiana residents working specifically on the state contract, with detailed accounting in a separate FTE Details worksheet. FTE calculations must account for employees splitting time across multiple projects, using fractional FTE allocations based on the percentage of time and duration spent on the specific state contract relative to the total contract term. The form includes space for documenting prime contractor and multiple subcontractor information, with specific fields for job titles, number of employees, duration in months, percentage of time spent, and resulting FTE counts. An authorized official must execute an affirmation under penalties of perjury confirming the accuracy of all provided representations.

View the file

Other files

File Type Posted
NB 26-87805 Att E - QA.xlsx XLSX spreadsheet
NB Addendum template 26-87805.docx DOCX document
Att A1 - IVOSB.docx DOCX document
Att B - Sample Contract.docx DOCX document
Att E - Q&A Template.xlsx XLSX spreadsheet
Att A - MWBE.docx DOCX document
Att H - Affidavit of Eligibility.docx DOCX document
Negotiated Bid Main Document 26-87805.docx DOCX document
Infrastructure Overview.docx DOCX document
Att F - Attestation Form.docx DOCX document
Att D - Cost Proposal.xlsx XLSX spreadsheet
Artificial Intelligence - Technical Proposal Questions.docx DOCX document
Att G - Preferences.docx DOCX document
Show all 13

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

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).
1Legal Name of firm:
2Address/City/State/Zip Code:
3Telephone #/Fax #/Website:
4Federal Tax Identification Number:
5State/Country of domicile/incorporation:
6Location of firm's headquarters or principal place of business:
7Name of parent company or holding company (if applicable):
8State/Country of domicile/incorporation of company listed in #7:
9Address of company listed in #7:
10IN Department of Workforce Development (DWD) account number:
11IN Department of Revenue (DOR) account number:
12Number of Indiana resident employees per most recently completed IRS Form W-2 distribution:
13Total number of employees per most recently completed IRS Form W-2 distribution:
14Total amount of payroll paid to Indiana resident employees per most recently completed IRS Form W-2 distribution:
15Total amount of payroll paid to all employees per the most recently completed IRS Form W-2 distribution:
16Total amount of this proposal, bid, or current contract:
ACCOUNTING OF INDIANA RESIDENT EMPLOYEES
17Prime Contractor Company Name:
18Number of Full Time Equivalent (FTE) employees that are Indiana residents specifically for this proposal or contract:0.00
19Subcontractor Company Name:
20Address/Contact Person/Telephone Number/Tax ID Number:
21Number of Full Time Equivalent (FTE) employees that are Indiana residents specifically for this proposal or contract:0.000.000.000.00
22Affirmation 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 TITLENumber of EmployeesDuration (In Months)Time Spent (Percentage)NUMBER OF FTE
Example: Project Managers524100%5.00
Example: Project Coordinators32450%1.50
Example: Project Directors26100%0.50
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL FTE COUNT0.00
SUB CONTRACTOR COMPANY NAME(Enter Company Name Here)
JOB TITLENumber of EmployeesDuration (In Months)Time Spent (Percentage)NUMBER OF FTE
Example: Developer26100%0.50
0.00
0.00
0.00
TOTAL FTE COUNT0.00
SUB CONTRACTOR COMPANY NAME(Enter Company Name Here)
JOB TITLENumber of EmployeesDuration (In Months)Time Spent (Percentage)NUMBER OF FTE
Example: Developer26100%0.50
0.00
0.00
0.00
TOTAL FTE COUNT0.00
SUB CONTRACTOR COMPANY NAME(Enter Company Name Here)
JOB TITLENumber of EmployeesDuration (In Months)Time Spent (Percentage)NUMBER OF FTE
Example: Developer26100%0.50
0.00
0.00
0.00
TOTAL FTE COUNT0.00
SUB CONTRACTOR COMPANY NAME(Enter Company Name Here)
JOB TITLENumber of EmployeesDuration (In Months)Time Spent (Percentage)NUMBER OF FTE
Example: Developer26100%0.50
0.00
0.00
0.00
TOTAL FTE COUNT0.00

File details come from the government source that posted it. Updated .