RFP_283-15-0458_Attach_13_IT_Worksheet.xls

XLS spreadsheet 124 KB Posted

Attached to
Substance Abuse and Mental Health Data Archive (SAMHDA) Federal contract opportunity
Solicitation number
283-15-0458
Issued by
Department of Health and Human Services Substance Abuse and Mental Health Services Administration

About this file

RFP-15-0458 Attach 13 IT Worksheet

View the file

Other files for this federal contract opportunity

Other files attached to Substance Abuse and Mental Health Data Archive (SAMHDA), newest first.
File Type Posted
RFP_283-15-0458_Attach_17_Summary_of_Cost_and_Hours_Spreadsheet.xls XLS spreadsheet
RFP_283-15-0458_Attach_15-16_Client_Letter_ _Past_Performance.pdf PDF
RFP_283-15-0458_Attach_14_SubK_Plan_Format.pdf PDF
RFP_283-15-0458_SAMHDA.pdf PDF
RFP_283-15-0458_Attach_4-12.pdf PDF
RFP_283-15-0458_Attach_1-3_SOW _QASP _Deliverables.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

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.

Summary

Substance Abuse and Mental Health Services Administration (SAMHSA)
Office of Program Services (OPS), Division of Management Systems - Information Technology Team (DMS-IT)
Proposed IT Total Estimate Worksheet
Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Type of IT CostEstimated IT
Cost Year 1Estimated IT
Cost Year 2Estimated IT
Cost Year 3Estimated IT
Cost Year 4Estimated IT
Cost Year 5Estimated 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.

&RRFP No. 283-10-0324 Attachment 13

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.

Labor Year 1

Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Proposed IT LABOR SERVICES Year: 1
DescriptionHoursRateCost
$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 1

Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Proposed OTHER IT DIRECT COSTS Year: 1
DescriptionHardware & Other EquipmentFirmware/ Proprietary SoftwareSpecial (Non-Labor) Service CostIT 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 2

Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Proposed IT LABOR SERVICES Year: 2
DescriptionHoursRateCost
$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

Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Proposed OTHER IT DIRECT COSTS Year: 2
DescriptionHardware & Other EquipmentFirmware/ Proprietary SoftwareSpecial (Non-Labor) Service CostIT 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

Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Proposed IT LABOR SERVICES Year: 3
DescriptionHoursRateCost
$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

Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Proposed OTHER IT DIRECT COSTS Year: 3
DescriptionHardware & Other EquipmentFirmware/ Proprietary SoftwareSpecial (Non-Labor) Service CostIT 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

Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Proposed IT LABOR SERVICES Year: 4
DescriptionHoursRateCost
$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

Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Proposed OTHER IT DIRECT COSTS Year: 4
DescriptionHardware & Other EquipmentFirmware/ Proprietary SoftwareSpecial (Non-Labor) Service CostIT 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

Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Proposed IT LABOR SERVICES Year: 5
DescriptionHoursRateCost
$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

Solicitation No:283-15-0458
Contract Title:"Substance Abuse and Mental Health Data Archive (SAMHDA)"
Proposed OTHER IT DIRECT COSTS Year: 5
DescriptionHardware & Other EquipmentFirmware/ Proprietary SoftwareSpecial (Non-Labor) Service CostIT 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 .