Attachment 2 Pricing Worksheet.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
| File | Type | Posted |
|---|---|---|
| Attachment 2 Pricing Worksheet_Rev1.xlsx | XLSX spreadsheet | |
| Attachment 4 Sole Source Justification_FAR 13.106(b)(1).pdf | ||
| Attachment 1_Lutron Lighting System_SOW.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
| 0001 | Lutron Lighting Preventive Maintenance Platinum Support Plan - Base Period | FFP | $ 3,041 | 12 | $ 36,492 |
| 0002 | Lutron Software Maintenance Agreement (SMA) - Base Period | FFP | $ 6,428 | 1 | $ 6,428 |
| 0003 | Additional Days of Service (Optional) | FFP | $ 1,350 | 5 | $ 6,750 |
| 1001 | Lutron Lighting Preventive Maintenance Platinum Support Plan - Option Period 1 | FFP | $ 3,041 | 12 | $ 36,492 |
| 1002 | Lutron Software Maintenance Agreement (SMA) - Option Period 1 | FFP | $ 6,428 | 1 | $ 6,428 |
| 1003 | Additional Days of Service (Optional) - Option Period 1 | FFP | $ 1,350 | 5 | $ 6,750 |
| 2001 | Lutron Lighting Preventive Maintenance Platinum Support Plan - Option Period 2 | FFP | $ 3,041 | 12 | $ 36,492 |
| 2002 | Lutron Software Maintenance Agreement (SMA) - Option Period 2 | FFP | $ 6,428 | 1 | $ 6,428 |
| 2003 | Additional Days of Service (Optional) - Option Period 2 | FFP | $ 1,350 | 5 | $ 6,750 |
| 3001 | Lutron Lighting Preventive Maintenance Platinum Support Plan - Option Period 3 | FFP | $ 3,041 | 12 | $ 36,492 |
| 3002 | Lutron Software Maintenance Agreement (SMA) - Option Period 3 | FFP | $ 6,428 | 1 | $ 6,428 |
| 3003 | Additional Days of Service (Optional) - Option Period 3 | FFP | $ 1,350 | 5 | $ 6,750 |
| 4001 | Lutron Lighting Preventive Maintenance Platinum Support Plan - Option Period 4 | FFP | $ 3,041 | 12 | $ 36,492 |
| 4002 | Lutron Software Maintenance Agreement (SMA) - Option Period 4 | FFP | $ 6,428 | 1 | $ 6,428 |
| 4003 | Additional Days of Service (Optional) - Option Period 4 | FFP | $ 1,350 | 5 | $ 6,750 |
| Proposed Grand Total | $ 248,350 |
| 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
| Electrician | 101.37 | 360 | $ 36,492 |
| Additional Days of Services | 101.37 | 67 | $ 6,750 |
| Service Mainenance Agreement (SMA) | $ 6,428 |
Proposed Grand Total Base Period 427 $ 49,670
OP 1
| Option Period 1 - LUTRON LIGHTNING MAINTENANCE AND SERVICES CONTRACT |
| September 25, 2022 - September 24, 2023 |
Labor Category Rate Hours Total
| Electrician | 101.37 | 360 | $ 36,492 |
| Additional Days of Services | 101.37 | 67 | $ 6,750 |
| Service Mainenance Agreement (SMA) | $ 6,428 |
Proposed Grand Total Option Period 1 427 $ 49,670
OP 2
| Option Period 2 - LUTRON LIGHTNING MAINTENANCE AND SERVICES CONTRACT |
| September 25, 2023 - September 24, 2024 |
Labor Category Rate Hours Total
| Electrician | 101.37 | 360 | $ 36,492 |
| Additional Days of Services | 101.37 | 67 | $ 6,750 |
| Service Mainenance Agreement (SMA) | $ 6,428 |
Proposed Grand Total Option Period 2 427 $ 49,670
OP 3
| Option Period 3 - LUTRON LIGHTNING MAINTENANCE AND SERVICES CONTRACT |
| September 25, 2024 - September 24, 2025 |
Labor Category Rate Hours Total
| Electrician | 101.37 | 360 | $ 36,492 |
| Additional Days of Services | 101.37 | 67 | $ 6,750 |
| Service Mainenance Agreement (SMA) | $ 6,428 |
Proposed Grand Total Option Period 3 427 $ 49,670
OP 4
| Option Period 4 - LUTRON LIGHTNING MAINTENANCE AND SERVICES CONTRACT |
| September 25, 2024 - September 24, 2025 |
Labor Category Rate Hours Total
| Electrician | 101.37 | 360 | $ 36,492 |
| Additional Days of Services | 101.37 | 67 | $ 6,750 |
| Service Mainenance Agreement (SMA) | $ 6,428 |
Proposed Grand Total Option Period 3 427 $ 49,670
Price Analysis
| Independent Government Cost Estimate | Vendor Proposal | ||||
| CLIN | Description | Type | Est. Total | Total | Delta |
| 0001 | Base Period | FFP | $199,638 | $304,963 | $105,325 |
| 1001 | Option Period 1 | FFP | $154,638 | $224,707 | $70,069 |
| 2001 | Option Period 2 | FFP | $159,278 | $229,203 | $69,925 |
| 3001 | Option Period 3 | FFP | $164,062 | $233,795 | $69,733 |
Estimated Grand Total $677,616 $992,669 $315,052
| Rate Analysis - PoP Average | |||||
| OPM | InteliPath | GSA FABS & Schedule 70 | |||
| Partner | $ 192.75 | IT Audit Director | $ 221.74 | GSA Average - Director | $ 226.00 |
| Manager | $ 136.45 | IT Audit Manager | $ 120.49 | GSA Average - Manager | $ 157.50 |
| IS Auditor | $ 134.87 | IT Audit Senior | $ 120.49 | GSA Average - Auditor | $ 139.00 |
| LOE Analysis - PoP Average | |||
| OPM | InteliPath | ||
| Partner | 31 | IT Audit Director | 125 |
| Manager | 158 | IT Audit Manager | 918 |
| IS Auditor | 1,056 | IT Audit Senior | 918 |
| Total Level of Effort (LOE) | |||
| OPM | InteliPath | ||
| Total LOE | 4980 | Total LOE | 7,840 |
File details come from the government source that posted it. Updated .