Attach 14_IT_Worksheets.pdf

PDF 162 KB Posted Apr 1, 2024

Attached to: Technical Support for Drug Free Workplace Federal contract opportunity
Solicitation number: 277-24-0621
Issued by: Department of Health and Human Services Substance Abuse and Mental Health Services Administration

About this file

Written by GovTribe AI · Apr 1, 2024

This document appears to be an IT Cost Estimate Worksheet for a federal contract opportunity. The key details are:

The contract is for Technical Support for the Drug-Free Workplace Program (DFWP) administered by the Substance Abuse and Mental Health Services Administration (SAMHSA), Center for Substance Abuse Prevention (CSAP), Division of Workplace Programs (DWP). The worksheet requires prime contractors and subcontractors to provide detailed cost estimates for IT-related labor, hardware/equipment, software, services, and supplies over a 5-year period. The contract has a Solicitation Number of 277-24-0621. The worksheet provides specific instructions and categories for estimating IT costs, with a requirement to reconcile these costs with the overall proposal.

View the file

Other files for this federal contract opportunity

Other files attached to Technical Support for Drug Free Workplace, newest first.
File	Type	Posted
Amendment 2 Questions And Answers.pdf	PDF	Apr 25, 2024
RFP 277-24-0621 Amendment_1 TSDFW.pdf	PDF	Apr 4, 2024
Attach 5_Sealed_Proposal_Cover_Page Amend 1.docx	DOCX document	Apr 4, 2024
Attach 07_Proposal_Intent_Response.docx	DOCX document	Apr 4, 2024
Attachment 1b -IT OC Contract Technical Requirements Version 1.8.pdf	PDF	Apr 1, 2024
Attachment 02_QASP.pdf	PDF	Apr 1, 2024
Attach 5_Sealed_Proposal_Cover_Page.docx	DOCX document	Apr 1, 2024
Attachment 01a_PWS.pdf	PDF	Apr 1, 2024
Attachment 1c DTM OC General Requirements Deliverables v1.3 and Specific Requirements.pdf	PDF	Apr 1, 2024
Attach 04_Billing_Instructions.docx	DOCX document	Apr 1, 2024
Attach 07_Proposal_Intent_Response.docx	DOCX document	Apr 1, 2024
Attach 11 and 12_Client_Letter_and_Contractor_Perf_Form.docx	DOCX document	Apr 1, 2024
Attach 13_Breakdown_Estimated_Costs.docx	DOCX document	Apr 1, 2024
Attach 08_Packaging_and_Delivery_ of_Proposals_via_eCPS.docx	DOCX document	Apr 1, 2024
Attach 09_Government_Notice.docx	DOCX document	Apr 1, 2024
Attach 16_Section_508_Template.docx	DOCX document	Apr 1, 2024
Attachment 3 Reference Materials_Online ASR screens.pdf	PDF	Apr 1, 2024
Attach 06_Disclosure_of_Lobbying_Activities.pdf	PDF	Apr 1, 2024
Attach 10_Contact_Points.docx	DOCX document	Apr 1, 2024
Attach 15_Summary_of_Cost_and_Hours_Spreadsheet.xlsx	XLSX spreadsheet	Apr 1, 2024
RFP 277-24-0621 DFWP.pdf	PDF	Mar 29, 2024
RFP 277-24-0621 Cover Letter.pdf	PDF	Mar 29, 2024

Show all 22

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

INSTRUCTIONS

Enter costs or information in the cells with this color background ----------->

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.

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.

5. SUPPLIES: such as diskettes, printer cartridges, ribbons, paper, other consumable supplies, surge protectors, glare screens, etc.

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.

NOTE: This information corresponds to the Type of IT Cost column on the IT Summary

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.)

Contract Title:

SAMHSA Project Officer: Date:

SAMHSA Contract Specialist: Task Order No:

Prime Contractor Name: Contract No:

Sub Contractor Name: Solicitation No: 277-24-0621

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.

Technical Support for Drug-Free Workplace

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

Tracy Davidson

3/29/2024 12:54 PM 2 of 12

Date:

Task Order No:

Contract No:

Solicitation No: 277-24-0621

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 $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

Prime Contractor Name:

Sub Contractor Name:

Subtotal

Proposed OTHER IT DIRECT COSTS Year: 1

Description

Contract Title:

SAMHSA Project Officer:

Technical Support for Drug-Free Workplace

SAMHSA Contract Specialist: Tracy Davidson

3/29/2024 12:54 PM 3 of 12

SAMHSA Contract Specialist: Task Order No:

Prime Contractor Name: Contract No:

Sub Contractor Name: Solicitation No: 277-24-0621

Hours Rate Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Fringe Benefits @ 0.00% $0.00

$0.00

Overhead @ 0.00% $0.00

$0.00

G & A Expenses @ 0.00% $0.00

$0.00

Fixed Fee @ 0.00% $0.00

TOTAL IT (LABOR) SERVICES $0.00

Total IT (Director Labor, Fringe Benefits, and Overhead)

Proposed IT LABOR SERVICES Year: 1

Technical Support for Drug-Free Workplace

Tracy Davidson

Total IT Labor

Description

Subtotal

Total IT (Director Labor, Fringe Benefits, and Overhead) + G & A

3/29/2024 12:54 PM 4 of 12

SAMHSA Contract Specialist: Task Order No:

Prime Contractor Name: Contract No:

Sub Contractor Name: Solicitation No: 277-24-0621

Hours Rate Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Fringe Benefits @ 0.00% $0.00

$0.00

Overhead @ 0.00% $0.00

$0.00

G & A Expenses @ 0.00% $0.00

$0.00

Fixed Fee @ 0.00% $0.00

TOTAL IT (LABOR) SERVICES $0.00

Description

Subtotal

Total IT (Director Labor, Fringe Benefits, and Overhead) + G & A

Proposed IT LABOR SERVICES Year: 2

Total IT (Director Labor, Fringe Benefits, and Overhead)

Total IT Labor

Tracy Davidson

Technical Support for Drug-Free Workplace

3/29/2024 12:54 PM 5 of 12

Contract No:

Solicitation No: 277-24-0621

Hardware & Other Equipment

Firmware/ Proprietary Software

Special (Non- Labor) Service

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

Prime Contractor Name:

Subtotal

Sub Contractor Name:

Proposed OTHER IT DIRECT COSTS Year: 2

Description

Technical Support for Drug-Free Workplace

SAMHSA Contract Specialist: Tracy Davidson SAMHSA Project Officer: 0

3/29/2024 12:54 PM 6 of 12

SAMHSA Contract Specialist: Task Order No:

Prime Contractor Name: Contract No:

Sub Contractor Name: Solicitation No: 277-24-0621

Hours Rate Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Fringe Benefits @ 0.00% $0.00

$0.00

Overhead @ 0.00% $0.00

$0.00

G & A Expenses @ 0.00% $0.00

$0.00

Fixed Fee @ 0.00% $0.00

TOTAL IT (LABOR) SERVICES $0.00

Proposed IT LABOR SERVICES Year: 3

Technical Support for Drug-Free Workplace

Tracy Davidson

Description

Total IT Labor

Subtotal

Total IT (Director Labor, Fringe Benefits, and Overhead) + G & A

Total IT (Director Labor, Fringe Benefits, and Overhead)

3/29/2024 12:54 PM 7 of 12

Contract No:

Solicitation No: 277-24-0621

Hardware & Other Equipment

Firmware/ Proprietary Software

Special (Non- Labor) Service

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

Subtotal

Proposed OTHER IT DIRECT COSTS Year: 3

Description

Contract Title: Technical Support for Drug-Free Workplace SAMHSA Project Officer: 0

SAMHSA Contract Specialist: Tracy Davidson Prime Contractor Name:

Sub Contractor Name:

3/29/2024 12:54 PM 8 of 12

SAMHSA Contract Specialist: Task Order No:

Prime Contractor Name: Contract No:

Sub Contractor Name: Solicitation No: 277-24-0621

Hours Rate Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Fringe Benefits @ 0.00% $0.00

$0.00

Overhead @ 0.00% $0.00

$0.00

G & A Expenses @ 0.00% $0.00

$0.00

Fixed Fee @ 0.00% $0.00

TOTAL IT (LABOR) SERVICES $0.00

Description

Subtotal

Total IT (Director Labor, Fringe Benefits, and Overhead) + G & A

Proposed IT LABOR SERVICES Year: 4

Total IT (Director Labor, Fringe Benefits, and Overhead)

Total IT Labor

Tracy Davidson

Technical Support for Drug-Free Workplace

3/29/2024 12:54 PM 9 of 12

Contract No:

Solicitation No: 277-24-0621

Hardware & Other Equipment

Firmware/ Proprietary Software

Special (Non- Labor) Service

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

Subtotal

Proposed OTHER IT DIRECT COSTS Year: 4

Description

Contract Title: Technical Support for Drug-Free Workplace SAMHSA Project Officer: 0

Sub Contractor Name:

SAMHSA Contract Specialist: Tracy Davidson Prime Contractor Name:

3/29/2024 12:54 PM 10 of 12

SAMHSA Contract Specialist: Task Order No:

Prime Contractor Name: Contract No:

Sub Contractor Name: Solicitation No: 277-24-0621

Hours Rate Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Fringe Benefits @ 0.00% $0.00

$0.00

Overhead @ 0.00% $0.00

$0.00

G & A Expenses @ 0.00% $0.00

$0.00

Fixed Fee @ 0.00% $0.00

TOTAL IT (LABOR) SERVICES $0.00

Proposed IT LABOR SERVICES Year: 5

Technical Support for Drug-Free Workplace

Description

Total IT Labor

Tracy Davidson

Subtotal

Total IT (Director Labor, Fringe Benefits, and Overhead) + G & A

Total IT (Director Labor, Fringe Benefits, and Overhead)

3/29/2024 12:54 PM 11 of 12

Contract No:

Solicitation No: 277-24-0621

Hardware & Other Equipment

Firmware/ Proprietary Software

Special (Non- Labor) Service

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

Proposed OTHER IT DIRECT COSTS Year: 5

Description

Sub Contractor Name:

Contract Title:

Tracy Davidson Prime Contractor Name:

Technical Support for Drug-Free Workplace SAMHSA Project Officer: 0

SAMHSA Contract Specialist:

Subtotal

3/29/2024 12:54 PM 12 of 12

Instructions

Summary

Other IT Year 1

Labor Year 1

Labor Year 2

Other IT Year 2

Labor Year 3

Other IT Year 3

Labor Year 4

Other IT Year 4

Labor Year 5

Other IT Year 5

File details come from the government source that posted it. Updated Apr 1, 2024.