Attachment D - Lot 2 Pricing.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
Migration Services
Solicitation number
5400029942
Issued by
Richland County, South Carolina

About this file

Summary: Attachment D - Lot 2 Pricing Schedule

This document is a pricing worksheet for Solicitation 5400029942, issued by the State Department of Administration, Office of Technology & Information Services, for migration services under Lot 2 (Shared Service Adoption and Migration - Technical Implementations). Vendors must propose comprehensive technical implementation services including planning and design, inventory assessment, security and compliance work, Active Directory and Entra ID integration, support planning, domain consolidation, email migration, SharePoint and Teams implementation, OneDrive migration, security and compliance implementation, decommissioning, and post-migration support. The pricing structure is organized by six agency size bands based on user counts: Band 1 (1-25 users), Band 2 (26-100 users), Band 3 (101-500 users), Band 4 (501-1,500 users), Band 5 (1,501-4,000 users), and Band 6 (4,001+ users). Vendors must price fixed-price modules for each band, core unit prices for scalable items (users, mailboxes, endpoints, servers, SharePoint sites, Teams, OneDrive accounts, repositories, and other infrastructure components), and data migration costs based on gigabytes or terabytes migrated. The document does not specify response dates, due dates, site visits, or award dates.

Pricing terms require all costs to be fully burdened and to exclude hardware, software, subscriptions, cloud consumption, licenses, and third-party tools unless separately procured or approved by the State. Band 6 pricing shall be calculated as the Band 5 base price plus incremental unit prices for quantities exceeding Band 5 baselines. Vendors must also price workstream additions (such as Entra ID configuration, Exchange Online migration, Teams migration, decommissioning, and endpoint protection), complexity modifiers (applicable to regulated data, multiple tenants, legacy applications, high data volumes, and other factors, capped at 35% cumulative adjustment unless approved), and post-migration support for up to twelve months, including hypercare, stabilization, and transition support. Vendors must disclose all assumptions, exclusions, exceptions, dependencies, and minimum charges in the Assumptions worksheet, and payment must be tied to accepted deliverables, completed milestones, validated migrations, and accepted documentation. No incumbent vendor or set-asides are identified in this pricing document, and no specific funding amounts or sources are stated.

View the file

Other files

File Type Posted
Attachment E - Lot 3 Pricing.xlsx XLSX spreadsheet
Solicitation.docx DOCX document
Attachment C - Lot 1 Pricing.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

1 Instructions

Solicitation 5400029942
Migration Services - Dept of Admin, Office of Technology & Information Services
Attachment D - Lot 2 Pricing Schedule - Instructions to Offerors
This workbook is intended to be completed by vendors proposing technical implementation services for Shared Service Adoption and Migration projects. Yellow cells are intended for vendor response. Vendors must choose a response from the options provided in the endor Response Column. If an Offeror selects "Exception Taken" as the Vendor Response, the Offeror shall provide a complete explanation in the Vendor Comments field. Failure to provide a complete explanation may result in the State treating the selection as "nonresponsive" or as taking no exception, at the State's discretion. mulas or calculated values.
ItemInstructionVendor Response RequiredVendor ResponseComments
1Complete all yellow response cells. Do not delete rows, columns, formulas, or worksheets.Vendor must comply
2All pricing shall be fully burdened unless otherwise stated in the solicitation or work order.Confirm Yes/No
3Prices shall exclude hardware, software, subscriptions, cloud consumption, licensing, and third-party tools unless separately procured or authorized by the State.Confirm Yes/No
4Fixed-price modules apply to standard planning, design, setup, validation, documentation, and closeout work.Acknowledge
5Unit prices apply to user, mailbox, endpoint, domain, server, site, Team, repository, printer, and other scalable quantities.Acknowledge
6Data migration prices apply to migrated or processed GB/TB for email, SharePoint, Teams, OneDrive, file shares, archives, eDiscovery, and DLP-sensitive data.Acknowledge
7Complexity modifiers require written State approval and may not be applied automatically.Acknowledge
8Hourly labor rates are for approved change orders, optional services, unusual work, and emergency support only unless the State expressly authorizes time-and-materials work.Acknowledge
9Payment should be tied to accepted deliverables, completed implementation milestones, validated migrations, and accepted documentation.Acknowledge
10Vendor shall disclose all assumptions, exclusions, exceptions, dependencies, minimum charges, and price escalators in the Assumptions tab.Acknowledge
Scope basis: Lot 2 Shared Service Adoption and Migration - Technical Implementations, including planning/design, inventory/assessment, security/compliance, AD/Entra integration, support planning, domain consolidation, email, SharePoint, Teams, OneDrive, security/compliance implementation, decommissioning, and post-migration support.

2 Size Baselines

Agency Size Bands and Baseline Quantities
This sheet defines agency size by band and provides the relative sizes for the 6 bands defined. Offerors will use these definitions in succeeding worksheets to price their services. Band 5 and Band 6 are defined equally for size. Band 6 efforts shall be priced using the Band 5 base price plus the awarded unit prices for individual items above the Band 5 baseline. For example, an agnecy with 4,325 mailboxes would be priced using the fixed price for a Band 5 agencie plus the individual pricing for 325 additional users, mailboxes, etc.
BandAgency SizeUser CountTypical UsePricing ApproachColumn1Vendor NotesVendor Notes2
Band 1Micro1-25Small boards, commissions, officesFixed band pricing
Band 2Small26-100Small agenciesFixed band pricing
Band 3Medium101-500Typical agencyFixed band pricing
Band 4Large501-1,500Large agencyFixed band pricing
Band 5Very Large1,501-4,000Enterprise agencyFixed band pricing
Band 6Mega / Enterprise4,001+Largest agencies or multi-agency projectsBand 5 + incremental unit prices
Baseline ItemBand 1Band 2Band 3Band 4Band 5Band 6 TreatmentVendor Notes
Users2510050015004000Band 5 + units
Mailboxes3012562518755000Band 5 + units
Endpoints3515075022506000Band 5 + units
Mobile devices10502507502000Band 5 + units
Physical locations1251530Band 5 + units
Servers31040125300Band 5 + units
Applications51550150300Band 5 + units
AD forests11235Band 5 + units
AD domains124815Band 5 + units
M365 tenants11248Band 5 + units
SharePoint sites520100300750Band 5 + units
Teams520100300750Band 5 + units
OneDrive accounts2510050015004000Band 5 + units
Network file repositories31030100250Band 5 + units
Printers / print queues31575250600Band 5 + units
DNS zones251540100Band 5 + units
DHCP scopes251540100Band 5 + units
Compliance frameworks11234Band 5 + units
Third-party integrations382575150Band 5 + units

3 Base Fixed Prices

Base Fixed-Price Modules by Agency Band
The pricing matrix below mirrors the phases and activities in the Lot 2 lifecycle. Offerors shall comple the blank pricing cells for each band. This pricing fixes a baseline quantity (See Sheet 2) for each component of the Lot 1 lifecycle. Band 6 efforts shall be priced using the Band 5 base price plus the awarded unit prices for users, endpoints, mailboxes, SharePoint sites, Active Directory forests, and other applicable units above the Band 5 baseline.Offerors will price incremental units above the baseline quantities supplied here in Sheet 4. This pricing model avoids unfair pricing where a 50-user agency and a 50-user agency both fall into the same project type, but have drastically different asset and user counts. Vendor shall enter firm fixed prices for standard technical implementation modules by agency size band. Band 6 may be priced as Band 5 plus incremental units unless the State requests a separate fixed price.
ModuleDescriptionBand 1 PriceBand 2 PriceBand 3 PriceBand 4 PriceBand 5 PriceBand 6 Formula/PriceIncluded AssumptionsVendor Notes
0Mobilization, kickoff, project setup, stakeholder identificationIncludes initial project setup, communications cadence, and project logistics
BCommunication plan and stakeholder engagement planIncludes notification channels, approval process, points of contact
CInventory and technical assessment packageIncludes baseline inventory coordination and assessment documentation
DFormal design documentIncludes scalable design for AD, Entra, M365, MDM, DNS/DHCP, certificate, EPP, DLP
ESupport plan, SLOs, escalation processes, help desk workflowIncludes support model and support-process documentation
FMigration runbook and cutover planIncludes technical sequencing, rollback plan, validation steps
GPilot migration setup and executionIncludes pilot group preparation, execution, validation, defect remediation planning
HTesting and validation planIncludes UAT approach and technical acceptance criteria
ITraining plan and standard training materialsIncludes standard user-facing training content and IT staff orientation
JFinal documentation and closeout packageIncludes final architecture, runbooks, final state, lessons learned, handoff documentation

4 Core Unit Pricing

Core Unit Pricing for Technical Implementation
Offerors shall use this worksheet to show their per unit pricing for the items in "Unit". This pricing will be constitute the pricing for additional units above the baseline Band pricing in Sheet 3. This level of specificity is required to keep pricing fair between efforts of differing size. For example, a small agency of 15 individuals may have upwards of 30 mailboxes when group and special use mailboxes are counted. Vendor shall provide fully burdened unit prices for each scalable implementation item. These unit prices govern quantities above baseline and work-order-specific quantities.
UnitDescriptionAdditional Unit PriceUnit BasisVendor Notes
Per userGeneral implementation impact, user mapping, account transition, support readinessIndividual user
Per user accountAD/Entra account mapping, conflict resolution, synchronization validationEach account
Per mailboxMailbox, calendar, contacts, rules, aliases, and validationEach mailbox
Per shared mailboxShared mailbox migration and validationEach shared mailbox
Per distribution groupDistribution list/group migration, mapping, validationEach group
Per Microsoft 365 GroupGroup, membership, site association, and policy mappingEach group
Per guest accountGuest account mapping, policy configuration, validationEach guest account
Per endpointWorkstation/laptop/tablet endpoint configuration or migration supportEach endpoint
Per mobile deviceiOS/Android MDM enrollment, validation, and supportEach mobile device
Per serverPhysical, Hyper-V, or Broadcom/VMware server migrationEach server
Per application dependencyAD, LDAP, Kerberos, SSO, service account, or integration dependencyEach dependency
Per physical locationSite-specific coordination, DNS/DHCP/print/network supportEach location
Per domainCustom domain transfer, verification, DNS updates, validationEach domain
Per AD forestForest-level assessment, trust, synchronization, and consolidation tasksEach forest
Per AD domainDomain-level configuration, mapping, GPO, OU, policy, synchronization workEach domain
Per domain controllerDC planning, configuration, validation, or field-office supportEach DC
Per DNS zoneDNS review, authoring, update, and validationEach zone
Per DHCP scopeDHCP update, validation, issue resolutionEach scope
Per certificate service itemCertificate validation, troubleshooting, coordinationEach item
Per printer / print queuePrinter mapping, queue validation, configuration supportEach printer/queue
Per SharePoint siteSite migration, permissions, validation, URL/link updatesEach site
Per Teams teamTeam, channel, files, apps, policies, validationEach Team
Per OneDrive accountOneDrive migration, sync validation, user confirmationEach account
Per file repositoryShared drive or data repository migrationEach repository
Per third-party integrationReintegration, validation, and coordinationEach integration
Per Power Platform artifactPower App, Power Automate flow, Power BI workspace/report, or related artifactEach artifact

5 Data Migration

Data Migration Pricing
Vendor shall provide pricing for data movement, processing, validation, and migration-related remediation. Use both object-based and data-volume pricing where applicable.
Data TypePricing UnitUnit PriceData Validation IncludedAssumed ToolingVendor Notes
Mailbox dataPer GB migrated
Mailbox dataPer TB migrated
SharePoint Online dataPer GB migrated
SharePoint Online dataPer TB migrated
Teams files and related SharePoint dataPer GB migrated
Teams files and related SharePoint dataPer TB migrated
OneDrive dataPer GB migrated
OneDrive dataPer TB migrated
Network file share dataPer GB migrated
Network file share dataPer TB migrated
Archive / retention dataPer GB processed
Archive / retention dataPer TB processed
Litigation hold / eDiscovery dataPer GB configured or migrated
DLP-sensitive data repositoryPer repository or per TB

6 Workstream Additions

Workstream Implementation Additions
The Lot 2 scope is organized by specific technical implementations, but it is within the scope of the services that additional tasks may be required to successfully execute the implementations in a work order. The pricing schedule should reflect that. The items below are anticipated workstreams that may occur in any migration or consolidation effort. Offerors shall price technical implementation workstreams that may be selected independently in a work order. Offerors shall identify identify whether the price is fixed or unit-based.
WorkstreamDescriptionFixed PriceUnit PriceUnit BasisVendor Notes
Entra ID configurationVanity domains, managed domains, users, conditional access, enterprise apps
Entra Connect configurationOn-prem AD to cloud synchronization
AD trust implementationForest/domain trust configuration and validation
AD consolidationOU, GPO, password policy, security groups, distribution groups
Legacy LDAP/Kerberos application supportLegacy app dependency remediation support
M365 tenant baseline configurationExchange, SharePoint, Teams, OneDrive, Groups, policies
Exchange Online migration packageMailbox migration and Exchange validation
SharePoint migration packageSite/library/list/content migration
Teams migration packageTeams/channels/files/apps/settings
OneDrive migration packageUser data and client configuration
Power Platform migration supportPower Apps, Power Automate, Power BI, Flows
Dynamics 365 migration supportEnvironment and integration support
MDM / Intune implementationMDM, app policies, configuration profiles, patching integration
Apple Business Manager implementationABM merge, iCloud service accounts, validation
Endpoint protection implementationEPP migration, configuration, automatic updates, validation
DLP implementationDLP configuration across cloud and network boundaries
Audit logging and monitoring implementationLogs, alerts, monitoring validation
DNS/DHCP/certificate services implementationDNS records, DHCP scopes, certificate validation
Printer services implementationNetwork printer mapping and print service validation
Decommissioning packageSource tenant, service, repository, and legacy service retirement

7 Complexity

Complexity Modifiers
It is anticipated that the various migration and consolidation efforts will have differing complexities based on specific agency requirements. This sheet identifies the most common of those complexities. Offerors shall supply the percentage modifier they will employ for each item. These percentage modifiers will apply against the baseline fixed prices in Sheet 3. However, Offerors shall be aware that, unless expressly approved in the work order approved through the Secondary Competition process (See Attachment A), cumulative complexity adjustments shall not exceed 35% of the applicable base fixed price.Complexity modifiers are not automatic. Vendor shall propose percentage adjustments and describe objective triggers. Application requires written State approval. The solicitation may cap cumulative modifiers.
ModifierTriggerProposed %Maximum %Applies ToRequired DocumentationVendor Notes
Regulated dataCJIS, IRS Pub. 1075, HIPAA, PCI-DSS, ARC-AMPE, MARS-E, or similar20%Affected modules/workstreamsIdentify applicable framework and affected systems/data
Multiple tenantsMore than one M365 tenant in scope20%Tenant-related workstreamsList tenants and workloads
Multiple AD forests/domainsMultiple forests, domains, trusts, or hybrid dependencies25%Identity and domain workstreamsList domains/forests and dependencies
Legacy application dependencyLDAP, Kerberos, hardcoded domains, unsupported apps25%Application/dependency workstreamsApplication inventory and dependency map
High data volumeData volume exceeds baseline by more than 50%20%Data migration workstreamsIdentify applicable data sets and data inventory.
High permission complexityNonstandard permissions, broken inheritance, sensitive repositories20%Data and collaboration workstreamsIdentify environments and describe requirements and activities
High downtime sensitivity24x7, public safety, health, revenue, or citizen-facing operations25%Cutover/migration workstreamsIdentify environments and provide justification
Geographic complexityMore than 10 locations or sites needing local support15%Location-dependent workstreamsIdenfity locations and dependencies
Compressed scheduleState-approved accelerated schedule25%Affected modules/workstreamsIdentify requirements and provide pricing justification
Significant remediationUnsupported, misconfigured, undocumented, or insecure environment30%Affected modules/workstreamsIdentify vulnerabilities, risks, and anticipated activities.
After-hours cutoversRequired evening, weekend, or holiday migration windows20%Cutover/migration workstreamsIdentify environments and anticipated timelines for each.

8 Post Migration

Post-Migration Support Pricing
Vendor shall price hypercare, stabilization, and support augmentation for up to 12 months following final migration and consolidation. Pricing should distinguish migration-related support from permanent managed services.
Support ModelDescriptionMonthly PriceDaily PriceHourly PriceCoverage/AssumptionsVendor Notes
Monthly support - Band 1Up to 25 users
Monthly support - Band 226-100 users
Monthly support - Band 3101-500 users
Monthly support - Band 4501-1,500 users
Monthly support - Band 51,501-4,000 users
Monthly support - Band 64,001+ users; Band 5 + per-user/resource units
Onsite technicianDaily onsite technical support
Remote support technicianRemote technical support
Tier 2 support engineerEscalated support
Identity/M365 engineerSpecialized post-migration troubleshooting
Security/compliance engineerPost-migration security or compliance remediation
First 30 days hypercareIntensive support immediately after cutover
Months 2-3 stabilizationStabilization support after hypercare
Months 4-12 transition supportSteady-state transition and escalated support

9 Support SLAs

Support Service Levels and Coverage Pricing
Vendor shall price support coverage options applicable to migration-related implementation and post-migration support. The State may select coverage levels by work order.
Support LevelCoverageMonthly PriceCutover PriceHourly PriceIncluded Response CommitmentsVendor Notes
Standard business hoursMonday-Friday, excluding State holidays
Extended business hoursEarly morning/evening support
Cutover supportNights/weekends during approved cutovers
24x7 critical supportCritical incident support only
Onsite supportNamed onsite support resources
Remote supportRemote support desk and technical escalation
Priority 1 incidentCritical outage or failed cutover support
Priority 2 incidentMaterial degradation or user-impacting issue
Priority 3 incidentNon-critical defect or service request

10 Labor Rates

Labor Category Rate Card
Fixed pricing as laid out in the prior sheets is the method that is used for pricing on this contract. However, the State requires Offerors to provide the fully burdened hourly rates for the personnel types indicated in the Resource Category column to account for approved change orders, optional services, unusual work, emergency support, or where the State expressly authorizes time-and-materials work. Offerors may only invoice for these services when formally approved in writing by the State.
Resource CategoryDescriptionHourly RateMinimum QualificationsOnsite/Remote Rate DifferenceVendor Notes
Technical Program ManagerOverall technical implementation leadership
Technical Project ManagerWorkstream scheduling, coordination, reporting
Solution ArchitectOverall migration/consolidation architecture
Identity ArchitectAD, Entra ID, Entra Connect, IAM, SSO
M365 ArchitectExchange, SharePoint, Teams, OneDrive, tenant services
Exchange EngineerMailbox migration and Exchange Online configuration
SharePoint EngineerSharePoint migration, permissions, workflows
Teams EngineerTeams migration, policies, channels, apps
OneDrive EngineerOneDrive migration and sync validation
Server EngineerPhysical, Hyper-V, Broadcom/VMware migration
Network EngineerDNS, DHCP, firewall coordination, certificates
Endpoint EngineerWorkstation, laptop, tablet, image/configuration support
MDM / Intune EngineerMobile device, Intune, ABM, app policies
Cybersecurity EngineerEPP, DLP, monitoring, audit, vulnerability remediation
GRC / Compliance SpecialistCJIS, IRS 1075, PCI-DSS, HIPAA, SCDIS-200
Data Migration SpecialistFile shares, repositories, storage, data validation
Power Platform SpecialistPower Apps, Power Automate, Power BI, Flows
Dynamics 365 SpecialistDynamics environment and integration support
Help Desk / Support TechnicianMigration-related user and endpoint support
Trainer / Change Enablement SpecialistTraining, user communications, adoption support
Technical WriterDocumentation, runbooks, final-state architecture

11 Eval Scenarios

Evaluation Pricing Scenarios
Vendor shall enter the total proposed price for each scenario using the awarded pricing schedule proposed in this workbook. The weighted evaluated total calculates automatically. Scenario details are illustrative and may be adjusted by the State before release.
InputScenario A MicroScenario B SmallScenario C MediumScenario D LargeScenario E Very LargeScenario F MegaNotes
Users2080350120035006000Affected users
Mailboxes25100425150045007500Includes shared as estimated
Endpoints25120500180050008500Workstations/laptops/tablets
Mobile devices53015060015002500iOS/Android devices
Locations125153050Physical sites
Servers152590250500Physical/virtual servers
AD domains11251020In-scope AD domains
M365 tenants1123610In-scope tenants
SharePoint sites315752506501200Sites/site collections
Teams315752506501200Teams objects
OneDrive accounts2080350120035006000OneDrive accounts
Data volume TB1525100350750Estimated total migrated data
Compliance complexityNoneIRS Publication 1075CJIS and IRSMultiple frameworks (>2)Multiple + high complexityMultiple + 24x7Pricing shall reflect stated complexity
ScenarioWeightVendor Scenario PriceWeighted PricePricing Notes / Crosswalk to WorkbookState Evaluation Notes
Scenario A Micro10%$0.00
Scenario B Small15%$0.00
Scenario C Medium25%$0.00
Scenario D Large25%$0.00
Scenario E Very Large15%$0.00
Scenario F Mega10%$0.00
Weighted Evaluated Total100%$0.00

12 Work Order Formula

Work Order Pricing Formula and Build-Up Template
This tab provides a standard build-up format for pricing work orders. Vendors may use this template to show how fixed modules, workstreams, unit quantities, data volume, modifiers, support, and optional services were applied.
Pricing ComponentQuantityUnit / BasisUnit PriceSubtotalSource Tab / ReferenceVendor Notes
Base Fixed-Price ModulesFixed module subtotal$0.003 Base Fixed Prices
Workstream Implementation AddersFixed/unit subtotal$0.006 Workstream Adders
Core Unit PricesUnits as applicable$0.004 Core Unit Pricing
Data-Volume ChargesGB/TB as applicable$0.005 Data Migration
Approved Complexity Modifiers% applied to approved subtotal$0.007 Complexity
Post-Migration SupportMonths/days/hours$0.008 Post Migration
Support SLA CoverageMonths/cutover/hours$0.009 Support SLAs
Approved Optional ServicesHours/units$0.0010 Labor Rates
Other State-Approved ChargesDescribe basis$0.00Assumptions/Work Order
Total Proposed Work Order Price$0.00
Suggested formula: Total Work Order Price = Base Fixed-Price Modules + Workstream Additions + Unit Prices + Data-Volume Charges + Approved Complexity Modifiers + Post-Migration Support + Approved Optional Services. For Band 6, use Band 5 base plus incremental unit prices above Band 5 baselines unless otherwise authorized.

13 Assumptions

Vendor Assumptions, Exceptions, and Clarifications
Vendor shall disclose all assumptions, exclusions, exceptions, dependencies, minimum charges, escalation terms, proposed deviations, and clarifications. Failure to disclose assumptions may result in the State treating the price as unconditional. The State will accept or decline Offeror assumptions, exceptions, and clarifications at its own discretion. Offerors must determine on their own if they wish to claim assumptions, exceptions, or clarifications since the State may deem Offeror proposals unresponsive as a result.
Item #CategoryAssumption / Exception / ClarificationPricing ImpactApplies ToVendor Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

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