Attachment 2 Pricing Worksheet_Rev1.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
OPM/FSEM Lutron Lighting System Maintenance and Support Services Federal contract opportunity
Solicitation number
24322622Q0025
Issued by
Office of Personnel Management

View the file

Other files for this federal contract opportunity

Other files attached to OPM/FSEM Lutron Lighting System Maintenance and Support Services, newest first.
File Type Posted
Attachment 4 Sole Source Justification_FAR 13.106(b)(1).pdf PDF
Attachment 2 Pricing Worksheet.xlsx XLSX spreadsheet
Attachment 1_Lutron Lighting System_SOW.pdf PDF

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

Proposed Total

PRICING WORKSHEET
LUTRON LIGHTNING SYSTEM MAINTENANCE AND SUPPORT SERVICES

CLIN Description Type Monthly Rate QTY Total

0001Lutron Lighting Preventive Maintenance Platinum Support Plan - Base PeriodFFP12$ -
0002Lutron Software Maintenance Agreement (SMA) - Base PeriodFFP1$ -
0003Additional Days of Service (Optional)FFP5$ -
1001Lutron Lighting Preventive Maintenance Platinum Support Plan - Option Period 1FFP12$ -
1002Lutron Software Maintenance Agreement (SMA) - Option Period 1FFP1$ -
1003Additional Days of Service (Optional) - Option Period 1FFP5$ -
2001Lutron Lighting Preventive Maintenance Platinum Support Plan - Option Period 2FFP12$ -
2002Lutron Software Maintenance Agreement (SMA) - Option Period 2FFP1$ -
2003Additional Days of Service (Optional) - Option Period 2FFP5$ -
3001Lutron Lighting Preventive Maintenance Platinum Support Plan - Option Period 3FFP12$ -
3002Lutron Software Maintenance Agreement (SMA) - Option Period 3FFP1$ -
3003Additional Days of Service (Optional) - Option Period 3FFP5$ -
4001Lutron Lighting Preventive Maintenance Platinum Support Plan - Option Period 4FFP12$ -
4002Lutron Software Maintenance Agreement (SMA) - Option Period 4FFP1$ -
4003Additional Days of Service (Optional) - Option Period 4FFP5$ -
Proposed Grand Total$ -
The cost for this requirement was developed using information provided by AFM and some of my industry knowledge.

Preparer certifies that "This IGCE was developed independently and prior to seeking any formal proposals from contractors"

NOTE: The IGCE shall include:
* The name(s) of the preparer(s), approving reviewer (which is the preparer's supervisor), to include their titles
* The preparer & approving reviewer organization and contact information (phone & e-mail addresses)
* A signature and date - either hand signed or electronic signature for both preparer and approving reviewer
Preparer's Signature:Approver's Signature:
Preparer's Title:Approver's Title:
Date:Date:

Base Period

Base Period - LUTRON LIGHTNING MAINTENANCE AND SERVICES CONTRACT
January 25, 2022 - January 24, 2023

Labor Category Rate Hours Total

Electrician360$ - 0
Additional Days of Services67$ - 0
Service Mainenance Agreement (SMA)

Proposed Grand Total Base Period 427 $ - 0

OP 1

Option Period 1 - LUTRON LIGHTNING MAINTENANCE AND SERVICES CONTRACT
September 25, 2022 - September 24, 2023

Labor Category Rate Hours Total

Electrician360$ - 0
Additional Days of Services67$ - 0
Service Mainenance Agreement (SMA)

Proposed Grand Total Option Period 1 427 $ - 0

OP 2

Option Period 2 - LUTRON LIGHTNING MAINTENANCE AND SERVICES CONTRACT
September 25, 2023 - September 24, 2024

Labor Category Rate Hours Total

Electrician360$ - 0
Additional Days of Services67$ - 0
Service Mainenance Agreement (SMA)

Proposed Grand Total Option Period 2 427 $ - 0

OP 3

Option Period 3 - LUTRON LIGHTNING MAINTENANCE AND SERVICES CONTRACT
September 25, 2024 - September 24, 2025

Labor Category Rate Hours Total

Electrician360$ - 0
Additional Days of Services67$ - 0
Service Mainenance Agreement (SMA)

Proposed Grand Total Option Period 3 427 $ - 0

OP 4

Option Period 4 - LUTRON LIGHTNING MAINTENANCE AND SERVICES CONTRACT
September 25, 2024 - September 24, 2025

Labor Category Rate Hours Total

Electrician360$ - 0
Additional Days of Services67$ - 0
Service Mainenance Agreement (SMA)

Proposed Grand Total Option Period 3 427 $ - 0

Price Analysis

Independent Government Cost EstimateVendor Proposal
CLINDescriptionTypeEst. TotalTotalDelta
0001Base PeriodFFP$199,638$304,963$105,325
1001Option Period 1FFP$154,638$224,707$70,069
2001Option Period 2FFP$159,278$229,203$69,925
3001Option Period 3FFP$164,062$233,795$69,733

Estimated Grand Total $677,616 $992,669 $315,052

Rate Analysis - PoP Average
OPMInteliPathGSA FABS & Schedule 70
Partner$ 192.75IT Audit Director$ 221.74GSA Average - Director$ 226.00
Manager$ 136.45IT Audit Manager$ 120.49GSA Average - Manager$ 157.50
IS Auditor$ 134.87IT Audit Senior$ 120.49GSA Average - Auditor$ 139.00
LOE Analysis - PoP Average
OPMInteliPath
Partner31IT Audit Director125
Manager158IT Audit Manager918
IS Auditor1,056IT Audit Senior918
Total Level of Effort (LOE)
OPMInteliPath
Total LOE4980Total LOE7,840

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