ITS77 Rate Calculator V5.xls
XLS spreadsheet 37 KB Posted
- Attached to
- IT Staff Augmentation
- Contract number
- ITS77
- Issued by
- Massachusetts
About this file
The document is an Excel-based rate calculator for the ITS77 state contract, which details pricing and markup calculations for various IT staffing and vendor augmentation services. The contract involves multiple IT service providers including ARK Solutions, Inc., Appsboat, Inc., Digit Outsource Inc, Acro Service Corp, McInnis Consulting Services, Inc., M & R Consultants Corporation, Lancesoft, Overture Partners, LLC, Rose, and SoftHQ, Inc.
The rate calculator provides two primary calculation methodologies: ITS77StaffAugCat2a for vendors employing resources directly, and ITS77StaffAugCat2b for vendors subcontracting with third-party resource employers. The document outlines vendor-specific markup rates ranging from 11.27% to 15%, which are used to determine bill rates and pay rates for IT resources. Vendors can calculate either the resource pay rate from a known bill rate or the bill rate from a known pay rate, with each vendor having a specific maximum markup percentage. The calculator enables precise financial calculations for IT staffing services, allowing state agencies to accurately budget and compensate vendors and resources.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ITS77.pdf | ||
| Employee Certification Form~1.doc | DOC document | |
| ITS77 Contract User Guide 2023.08.03.docx | DOCX document | |
| ITS77 Vendor Spreadsheet Listing All Vendors - 2024.05.10.xlsx | XLSX spreadsheet | |
| Statement of Work - SOW - Template~1.doc | DOC document | |
| Candidate Bid Sheet Submission Form~1.xls | XLS spreadsheet | |
| ITS77 RFR IT STAFF AUGMENTATION v2 - including amendments.docx | DOCX document | |
| Representations By Resources~2.doc | DOC document | |
| Specifications for ITS77 IT Staff Augmentation Posting.docx | DOCX document | |
| Rate Card 7 and Rate Card 3.xlsx | XLSX spreadsheet |
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
LO_PayRate_Calc
| ITS77 Lower Overhead Rate Calculator | ||||||
| To determine which calculation applies: | ||||||
| Choose whether you will be calculating the pay rate from the bill rate or vice versa. For example, if you have budgeted for a certain | ||||||
| number of hours based on paying the ITS77 vendor a specific dollar amount per hour, you will need to determine Resource Pay Rate | ||||||
| from your known bill rate to see what pay rate you can offer the resource. If you and the Resource have already negotiated the pay | ||||||
| rate, you will need to determine a bill rate from the known pay rate to determine what you will pay the ITS77 vendor. | ||||||
| ITS77StaffAugCat2a - ITS77 Vendor Employs Resource and Supplies W2 | ||||||
| Enter Vendor Bill Rate to Commonwealth in the green column to determine Resource Pay Rate from Vendor. | ||||||
| ITS77 Vendor | Max Markup | Enter Vendor Bill Rate | Divider | Calculated Resource Pay Rate | ||
| ARK Solutions, Inc. | 0.1127 | 1.1127 | ||||
| Appsboat, Inc | 0.12 | 1.12 | ||||
| Digit Outsource Inc | 0.13 | 1.13 | ||||
| Acro Service Corp | 0.1306 | 1.1306 | ||||
| McInnis Consulting Services, Inc. | 0.1312 | 1.1312 | ||||
| M & R Consultants Corporation | 0.134 | 1.134 | ||||
| Lancesoft | 0.1435 | 1.1435 | ||||
| Overture Parnters, LLC | 0.145 | 1.145 | ||||
| Rose | 0.15 | 1.15 | ||||
| OR | ||||||
| Enter Resource Pay Rate from vendor in the green column to determine Vendor Bill Rate to Commonwealth | ||||||
| ITS77 Vendor | Max Markup | Calculated Vendor Bill Rate | Multiplier | Enter Resource Pay Rate | ||
| ARK Solutions, Inc. | 0.1127 | 1.1127 | ||||
| Appsboat, Inc | 0.12 | 1.12 | ||||
| Digit Outsource Inc | 0.13 | 1.13 | ||||
| Acro Service Corp | 0.1306 | 1.1306 | ||||
| McInnis Consulting Services, Inc. | 0.1312 | 1.1312 | ||||
| M & R Consultants Corporation | 0.134 | 1.134 | ||||
| Lancesoft | 0.1435 | 1.1435 | ||||
| Overture Partners, LLC | 0.145 | 1.145 | ||||
| Rose | 0.15 | 1.15 | ||||
| ITS77StaffAugCat2b - ITS77 Vendor Subcontracts with Resource employer | ||||||
| Enter Vendor Bill Rate to Commonweath in green column to calcuate Pay Rate to 3rd party vendor | ||||||
| ITS77 Vendor | Enter Vendor Bill Rate | Max Markup | 1% of Max Markup | Markup + Markup Admin Fee | Vendor Bill Rate Minus Markup and Markup 1% Fee | Calculated Pay Rate (to 3rd party vendor) |
| SoftHQ, Inc | $0.30 | 0.003 | $0.303 | |||
| Acro Service Corp | $0.38 | 0.004 | $0.384 | |||
| Appsboat Inc | $0.45 | 0.005 | $0.455 | |||
| LanceSoft Inc | $0.45 | 0.005 | $0.455 | |||
| McInnis Consulting Services, Inc. | $0.45 | 0.005 | $0.455 | |||
| OR | ||||||
| Enter Pay Rate to 3rd party vendor in green column to calcuate ITS77 Vendor's Bill Rate to Commonwealth | ||||||
| ITS77 Vendor | Calculated Vendor Bill Rate | Max Markup | 1% of Max Markup | Markup + Markup Admin Fee | Markup on Third Party Vendor Pay Rate | Enter Pay Rate (to 3rd party vendor) |
| SoftHQ, Inc | $0.30 | 0.0030 | $0.30 | |||
| Acro Service Corp | $0.38 | 0.0038 | $0.38 | |||
| Appsboat Inc | $0.45 | 0.0045 | $0.45 | |||
| LanceSoft Inc | $0.45 | 0.0045 | $0.45 | |||
| McInnis Consulting Services, Inc. | $0.45 | 0.0045 | $0.45 |
File details come from the government source that posted it. Updated .