RFP 277-20-0550 Attachment 14 IT Total Estimate Cost Sheet.xls
XLS spreadsheet 154 KB Posted
- Solicitation number
- 277-20-0550
About this file
This document provides templates for estimating information technology costs associated with a federal contract opportunity. The templates include worksheets for estimating IT labor costs, other direct IT costs, and total estimated IT costs over five fiscal years. Contractors must complete these worksheets to reconcile IT costs in their proposals with the estimated costs in the templates. The worksheets require entering detailed cost data for IT support services, hardware and equipment, firmware and proprietary software, special non-labor services, and supplies for each year. Total costs must be fully burdened to include overhead, G&A and fee. The related federal contract opportunity is a one-year cost reimbursement contract with four option years issued by the Substance Abuse and Mental Health Services Administration to produce reports on preventing underage drinking as required by the STOP Act. Proposals are due by March 25, 2020 in response to solicitation number 277-20-0550. The contract supports the Interagency Coordinating Committee on the Prevention of Underage Drinking.
View the file
Other files
Show all 25
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
| INSTRUCTIONS |
| Enter costs or information in the cells with this color background -----------> |
| Three types of worksheets are used to estimate IT Costs. The "Summary" worksheet captures contract and task information and summaries cost data from the "Labor" cost worksheets and "Other IT" cost worksheets. Five fiscal years are provided for the "Labor" and "Other IT" cost worksheets. Begin by entering cost data in both worksheets for each fiscal year. |
| NOTE: This information corresponds to the Type of IT Cost column on the IT Summary Worksheet. |
| 1. SUPPORT ( LABOR) SERVICES: such as management information systems development, computer programming, documentation of systems, statistical programming, data entry, computer training, maintaining personal computers, providing PC end user support services, supervision of IT functions, planning, etc. |
| 2. HARDWARE/EQUIPMENT: such as personal computers, computer monitors, document scanners, color plotters, computer-driven slide preparation, and projection equipment, compact storage devices, local area network (LAN) servers telecommunications equipment, LAN cabling, and related components (tape-to-tape, uninterruptible power supply devices), parts and peripheral devices (printer, keyboards, external storage devices, mice.) |
| 3. FIRMWARE & PROPRIETARY SOFTWARE: Packages such as Windows 2000/XP, MS Word, Ms Excel, MS Project, MS PowerPoint, MS Access, Oracle, SAS, SPSS. |
| 4. SPECIAL (NON LABOR) SERVICES: such as telephone, fax, electronic searches, purchasing computer time on mainframe computer, accessing on-line data bases such as JURIS, MEDLARS, MEDLINE, LEGISLATE, purchasing value-added services such as CompuServe and Time Net. |
| 5. SUPPLIES: such as diskettes, printer cartridges, ribbons, paper, other consumable supplies, surge protectors, glare screens, etc. |
| SPECIAL IT budget note/instructions for PRIME CONTRACTORS and SUBCONTRACTORS |
[a] The SAMHSA Business Proposal Instructions clearly specify in reference to the Proposed IT Budget [i.e. IT Total Estimate Worksheet (s)] that..."the Offerors are required to complete the IT Cost Estimate Worksheet(s) that is included as Attachment to the RFQ. Costs referenced on this form(s) have to be reconciled with IT Costs/Effort in the proposal in order that this office can readily identify one with the other."
[b] Prime Contractors and each of the Subcontractors are required to submit Individual IT Total Estimate Worksheets [including the cases where the IT Costs are zero] and a roll up or Grand Total IT Costs Worksheet that summarizes the total IT Costs for this procurement.
Summary
| Substance Abuse and Mental Health Services Administration (SAMHSA) | ||||
| Office of Management, Technology and Operations (OMTO), Division of Technology Management (DTM) | ||||
| Proposed IT Total Estimate Worksheet | ||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | |||
| SAMHSA Project Officer: | Date: | |||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | ||
| Prime Contractor Name: | Contract No: | |||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | ||
| Type of IT Cost | Estimated IT | |||
| Cost Year 1 | Estimated IT | |||
| Cost Year 2 | Estimated IT | |||
| Cost Year 3 | Estimated IT | |||
| Cost Year 4 | Estimated IT | |||
| Cost Year 5 | Estimated Total |
IT Cost
| Fiscal Year | ||||||
| 1. IT (Direct Labor) Support Services | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2. Hardware & Other Equipment | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3. Firmware/Proprietary Software | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4. Special (Non-Labor) Services | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 5. IT Supplies | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 6. Total IT Contract Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 7. Total Non-IT Contract Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 8. Total Contract Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Note: All estimated IT costs shown must be fully burdened appropriately to include Fringe, Benefits, Overhead, G & A, and Fee. | ||||||
| Note to offerors: Attach supporting detailed worksheets. |
&L&D &T&R&P of &N
1. SUPPORT ( LABOR) SERVICES: such as management information systems development, computer programming, documentation of systems, statistical programming, data entry, computer training, maintaining personal computers, providing PC end user support services, supervision of IT functions, planning, etc.
2. HARDWARE/EQUIPMENT: such as personal computers, computer monitors, document scanners, color plotters, computer-driven slide preparation, and projection equipment, compact storage devices, local area network (LAN) servers telecommunications equipment, LAN cabling, and related components (tape-to-tape, uninterruptible power supply devices), parts and peripheral devices (printer, keyboards, external storage devices, mice.)
3. FIRMWARE & PROPRIETARY SOFTWARE: Packages such as Windows 2000/XP, MS Word, Ms Excel, MS Project, MS PowerPoint, MS Access, Oracle, SAS, SPSS.
4. SPECIAL (NON LABOR) SERVICES: such as telephone, fax, electronic searches, purchasing computer time on mainframe computer, accessing on-line data bases such as JURIS, MEDLARS, MEDLINE, LEGISLATE, purchasing value-added services such as CompuServe and Time Net.
5. SUPPLIES: such as diskettes, printer cartridges, ribbons, paper, other consumable supplies, surge protectors, glare screens, etc.
Enter costs in worksheet: Labor Year 1.
Enter costs in worksheet: Labor Year 2.
Enter costs in worksheet: Labor Year 3.
Enter costs in worksheet: Labor Year 4.
Enter costs in worksheet: Labor Year 5.
Enter costs in worksheet: Other IT Year 1.
Enter costs in worksheet: Other IT Year 1.
Enter costs in worksheet: Other IT Year 1.
Enter costs in worksheet: Other IT Year 1.
Enter costs in worksheet: Other IT Year 2.
Enter costs in worksheet: Other IT Year 2.
Enter costs in worksheet: Other IT Year 2.
Enter costs in worksheet: Other IT Year 2.
Enter costs in worksheet: Other IT Year 3.
Enter costs in worksheet: Other IT Year 3.
Enter costs in worksheet: Other IT Year 3.
Enter costs in worksheet: Other IT Year 3.
Enter costs in worksheet: Other IT Year 4.
Enter costs in worksheet: Other IT Year 4.
Enter costs in worksheet: Other IT Year 4.
Enter costs in worksheet: Other IT Year 4.
Enter costs in worksheet: Other IT Year 5.
Enter costs in worksheet: Other IT Year 5.
Enter costs in worksheet: Other IT Year 5.
Enter costs in worksheet: Other IT Year 5.
Total IT costs of items 1-5.
Total IT costs of items 1-5.
Total IT costs of items 1-5.
Total IT costs of items 1-5.
Total IT costs of items 1-5.
Other IT Year 1
| Proposed OTHER IT DIRECT COSTS Year: 1 | ||||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | |||||
| SAMHSA Project Officer: | Date: | |||||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | ||||
| Prime Contractor Name: | Contract No: | |||||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | ||||
| Description | Hardware & Other Equipment | Firmware/ Proprietary Software | Special (Non-Labor) Service Cost | IT Supplies | ||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | ||
| G & A Expense @ | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | |
| Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Fixed Fee @ | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | |
| TOTAL COSTS | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Grand Total: | $0.00 |
&L&D &T&R&P of &N
Labor Year 1
| Proposed IT LABOR SERVICES Year: 1 | |||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | ||||
| SAMHSA Project Officer: | Date: | ||||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | |||
| Prime Contractor Name: | Contract No: | ||||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | |||
| Description | Hours | Rate | Cost | ||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| Total IT Labor | $0.00 | ||||
| Fringe Benefits @ | 0.00% | $0.00 | |||
| Subtotal | $0.00 | ||||
| Overhead @ | 0.00% | $0.00 | |||
| Total IT (Director Labor, Fringe Benefits, | $0.00 | ||||
| and Overhead) | |||||
| G & A Expenses @ | 0.00% | $0.00 | |||
| Total IT (Director Labor, Fringe Benefits, | $0.00 | ||||
| and Overhead) + G & A | |||||
| Fixed Fee @ | 0.00% | $0.00 | |||
| TOTAL IT (LABOR) SERVICES | $0.00 |
&L&D &T&R&P of &N
Labor Year 2
| Proposed IT LABOR SERVICES Year: 2 | |||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | ||||
| SAMHSA Project Officer: | Date: | ||||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | |||
| Prime Contractor Name: | Contract No: | ||||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | |||
| Description | Hours | Rate | Cost | ||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| Total IT Labor | $0.00 | ||||
| Fringe Benefits @ | 0.00% | $0.00 | |||
| Subtotal | $0.00 | ||||
| Overhead @ | 0.00% | $0.00 | |||
| Total IT (Director Labor, Fringe Benefits, | $0.00 | ||||
| and Overhead) | |||||
| G & A Expenses @ | 0.00% | $0.00 | |||
| Total IT (Director Labor, Fringe Benefits, | $0.00 | ||||
| and Overhead) + G & A | |||||
| Fixed Fee @ | 0.00% | $0.00 | |||
| TOTAL IT (LABOR) SERVICES | $0.00 |
&L&D &T&R&P of &N
Other IT Year 2
| Proposed OTHER IT DIRECT COSTS Year: 2 | ||||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | |||||
| SAMHSA Project Officer: | Date: | |||||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | ||||
| Prime Contractor Name: | Contract No: | |||||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | ||||
| Description | Hardware & Other Equipment | Firmware/ Proprietary Software | Special (Non-Labor) Service Cost | IT Supplies | ||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | ||
| G & A Expense @ | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | |
| Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Fixed Fee @ | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | |
| TOTAL COSTS | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Grand Total: | $0.00 |
&L&D &T&R&P of &N
Labor Year 3
| Proposed IT LABOR SERVICES Year: 3 | |||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | ||||
| SAMHSA Project Officer: | Date: | ||||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | |||
| Prime Contractor Name: | Contract No: | ||||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | |||
| Description | Hours | Rate | Cost | ||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| Total IT Labor | $0.00 | ||||
| Fringe Benefits @ | 0.00% | $0.00 | |||
| Subtotal | $0.00 | ||||
| Overhead @ | 0.00% | $0.00 | |||
| Total IT (Director Labor, Fringe Benefits, | $0.00 | ||||
| and Overhead) | |||||
| G & A Expenses @ | 0.00% | $0.00 | |||
| Total IT (Director Labor, Fringe Benefits, | $0.00 | ||||
| and Overhead) + G & A | |||||
| Fixed Fee @ | 0.00% | $0.00 | |||
| TOTAL IT (LABOR) SERVICES | $0.00 |
&L&D &T&R&P of &N
Other IT Year 3
| Proposed OTHER IT DIRECT COSTS Year: 3 | ||||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | |||||
| SAMHSA Project Officer: | Date: | |||||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | ||||
| Prime Contractor Name: | Contract No: | |||||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | ||||
| Description | Hardware & Other Equipment | Firmware/ Proprietary Software | Special (Non-Labor) Service Cost | IT Supplies | ||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | ||
| G & A Expense @ | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | |
| Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Fixed Fee @ | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | |
| TOTAL COSTS | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Grand Total: | $0.00 |
&L&D &T&R&P of &N
Labor Year 4
| Proposed IT LABOR SERVICES Year: 4 | |||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | ||||
| SAMHSA Project Officer: | Date: | ||||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | |||
| Prime Contractor Name: | Contract No: | ||||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | |||
| Description | Hours | Rate | Cost | ||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| Total IT Labor | $0.00 | ||||
| Fringe Benefits @ | 0.00% | $0.00 | |||
| Subtotal | $0.00 | ||||
| Overhead @ | 0.00% | $0.00 | |||
| Total IT (Director Labor, Fringe Benefits, | $0.00 | ||||
| and Overhead) | |||||
| G & A Expenses @ | 0.00% | $0.00 | |||
| Total IT (Director Labor, Fringe Benefits, | $0.00 | ||||
| and Overhead) + G & A | |||||
| Fixed Fee @ | 0.00% | $0.00 | |||
| TOTAL IT (LABOR) SERVICES | $0.00 |
&L&D &T&R&P of &N
Other IT Year 4
| Proposed OTHER IT DIRECT COSTS Year: 4 | ||||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | |||||
| SAMHSA Project Officer: | Date: | |||||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | ||||
| Prime Contractor Name: | Contract No: | |||||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | ||||
| Description | Hardware & Other Equipment | Firmware/ Proprietary Software | Special (Non-Labor) Service Cost | IT Supplies | ||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | ||
| G & A Expense @ | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | |
| Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Fixed Fee @ | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | |
| TOTAL COSTS | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Grand Total: | $0.00 |
&L&D &T&R&P of &N
Labor Year 5
| Proposed IT LABOR SERVICES Year: 5 | |||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | ||||
| SAMHSA Project Officer: | Date: | ||||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | |||
| Prime Contractor Name: | Contract No: | ||||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | |||
| Description | Hours | Rate | Cost | ||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| Total IT Labor | $0.00 | ||||
| Fringe Benefits @ | 0.00% | $0.00 | |||
| Subtotal | $0.00 | ||||
| Overhead @ | 0.00% | $0.00 | |||
| Total IT (Director Labor, Fringe Benefits, | $0.00 | ||||
| and Overhead) | |||||
| G & A Expenses @ | 0.00% | $0.00 | |||
| Total IT (Director Labor, Fringe Benefits, | $0.00 | ||||
| and Overhead) + G & A | |||||
| Fixed Fee @ | 0.00% | $0.00 | |||
| TOTAL IT (LABOR) SERVICES | $0.00 |
&L&D &T&R&P of &N
Other IT Year 5
| Proposed OTHER IT DIRECT COSTS Year: 5 | ||||||
| Contract Title: | Secretary of Health and Human Services Report to Congress on Preventing Underage Drinking Sober Truth on Preventing Underage Drinking Act | |||||
| SAMHSA Project Officer: | Date: | |||||
| SAMHSA Contract Specialist: | Carla Carter | Task Order No: | ||||
| Prime Contractor Name: | Contract No: | |||||
| Sub Contractor Name: | Solicitation No: | 277-20-0550 | ||||
| Description | Hardware & Other Equipment | Firmware/ Proprietary Software | Special (Non-Labor) Service Cost | IT Supplies | ||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | |||
| Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | ||
| G & A Expense @ | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | |
| Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Fixed Fee @ | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | |
| TOTAL COSTS | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Grand Total: | $0.00 |
&L&D &T&R&P of &N
File details come from the government source that posted it. Updated .