Appendix B - Cost Submittal Worksheet.xlsx

XLSX spreadsheet 40 KB Posted

Attached to
Learning Management System
Solicitation number
25-RFP-12233
Issued by
Pennsylvania

About this file

Cost Submittal Worksheet Summary

This is a Cost Submittal Worksheet (Appendix B) for the Management of the MyDHS Learning Management System contract opportunity with the Pennsylvania Department of Human Services (DHS), specifically involving three operational divisions: the Office of Developmental Programs (ODP), the Office of Mental Health and Substance Abuse Services (OMHSAS), and the Office of Long-Term Living (OLTL). The contract encompasses maintenance, hosting, technical support, medication administration tasks, modifications and enhancements to the existing Learning Management System and WordPress Content Management System, and transition and turnover services. The statement of work is organized into discrete service categories across a base contract period of three years with two optional renewal years.

Pricing for the contract is structured on an all-inclusive fixed monthly fee basis for maintenance, hosting, technical support, and medication administration tasks, with an all-inclusive blended hourly rate applied to modification and enhancement work. The ODP division accounts for 460 estimated annual hours for modifications, while OMHSAS and OLTL each account for 105 annual hours. Software and hardware costs for modifications and enhancements are to be reimbursed as pass-through costs with prior departmental approval. Deliverable-based transition and turnover costs are incorporated into Year One pricing. The Cost Verification section requires detailed breakdown of all costs including direct labor, labor overhead, travel and subsistence, consultant costs, subcontract costs, supplies and materials, other direct costs, general overhead costs, audit costs, and fee or profit margins across all contract years and option periods.

View the file

Other files

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 Appendix B Management of the MyODP Learning Mangement System Cost Submittal Worksheet

ODP, OMHSAS, OLTL Tabs
1. The ODP/OMHSAS/OLTL Tabs must be completed in their entirety by completing all boxes shaded in yellow. Please note that the sum of entries will reflect as totals on the MyDHS Overall TOTAL Tab.
2. The Department is requesting an all-inclusive fixed monthly fee to perform the Maintenance, Hosting, Technical Support and Medication Administration tasks and deliverables, as identified and detailed in Parts I-2 and I-6.B.1-8 of the Technical Submittal. NOTE: all-inclusive means all costs associated with completing the tasks and deliverables per the requirements of the RFQ, to include, but not limited to, travel, overhead, and profit.
3. The Department is requesting an all-inclusive blended hourly rate to perform the Modification and Enhancement task and deliverables, as identified and detailed in Part I-6.B.9 of the Technical Submittal. The Blended Hourly Rate must be an all-inclusive, fully loaded rate that will be used to price all hours used in performing the modification tasks identified in the Technical Submittal. All-inclusive and fully loaded means all costs associated with completing the requirements and tasks identified, to include travel, overhead, profit, etc.
4. The Department will pay as a pass-through cost, any software or hardware costs needed for modifications and enhancements as long as prior approval is obtained from the Department. For purposes of evaluation, the indivdual estimated costs indicated in the ODP/OMHSAS/OLTL Tabs will be added to the total cost of pricing for each year. The sum of these figures will total back to the MyDHS Overall TOTAL tab. Please make sure your figures reflect your efforts accurately.
5. For purposes of evaluation, the deliverable-based Transition and Turnover costs will be added to the Year One pricing.
6. For purposes of evaluation, any costs associated with OMAP/PCCRC will be reflected under the hours on the ODP tab.
Cost Verification Tab
1. Show all costs associated with the quote.
2. It is only necessary to list position titles in the worksheet, not individual names.
3. Include all information used to price the per month fee on the MyDHS Overall tab. This is the sum total calculated across all three - ODP, OMHSAS, and OLTL tabs.
4. The total cost should equal the total proposed cost.
5. Additional rows may be added to the Cost Verification Tab, as necessary.

MyDHS Overall TOTAL Appendix B Management of the MyDHS Learning Management System Cost Submittal Worksheet

Part I, Section I-6.A. TRANSITION
Fixed Fee
Year 1$0.00
Part I, Sections I-2 and I-6.B-E. MAINTENANCE, HOSTING, TECHNICAL SUPPORT AND MEDICATION ADMINISTRATION TASKS
Fixed Monthly FeeTotals
Year 1$0.00$0.00
Year 2$0.00$0.00
Year 3$0.00$0.00
Option Year 1$0.00$0.00
Option Year 2$0.00$0.00
Part I, Section I-6.F. MODIFICATION AND ENHANCEMENT TASKS
Estimated HoursBlended Hourly RateTotals
Year 1670$0.00$0.00
Year 2670$0.00$0.00
Year 3670$0.00$0.00
Option Year 1670$0.00$0.00
Option Year 2670$0.00$0.00
Part I, Section I-6.G. TURNOVER
Fixed Fee
Year 3$0.00
TOTAL PURCHASE ORDER PRICING
Year 1$0.00
Year 2$0.00
Year 3$0.00
TOTAL BASE YEAR$0.00
Option Year 1$0.00
Option Year 2$0.00
GRAND TOTAL$0.00

ODP

Appendix B Management of the MyODP Learning Management System Cost Submittal Worksheet

Part I, Section I-6.A. TRANSITION
Fixed Fee
Year 1$0.00
Part I, Sections I-2 and I-6.B. MAINTENANCE, HOSTING, TECHNICAL SUPPORT AND MEDICATION ADMINISTRATION TASKS
Fixed Monthly FeeTotals
Year 1$0.00$0.00
Year 2$0.00$0.00
Year 3$0.00$0.00
Option Year 1$0.00$0.00
Option Year 2$0.00$0.00
Part I, Section I-6.B.9. MODIFICATION AND ENHANCEMENT TASKS
Estimated HoursBlended Hourly RateTotals
Year 1460$0.00$0.00
Year 2460$0.00$0.00
Year 3460$0.00$0.00
Option Year 1460$0.00$0.00
Option Year 2460$0.00$0.00
Part I, Section I-6.B.10. TURNOVER
Fixed Fee
Year 3$0.00
TOTAL PURCHASE ORDER PRICING
Year 1$0.00
Year 2$0.00
Year 3$0.00
TOTAL BASE YEAR$0.00
Option Year 1$0.00
Option Year 2$0.00
GRAND TOTAL$0.00

OMHSAS

Appendix B Management of the MyOMHSAS Learning Management System Cost Submittal Worksheet

Part I, Section I-6.A. TRANSITION
Fixed Fee
Year 1$0.00
Part I, Sections I-2 and I-6.B. MAINTENANCE, HOSTING, TECHNICAL SUPPORT AND MEDICATION ADMINISTRATION TASKS
Fixed Monthly FeeTotals
Year 1$0.00$0.00
Year 2$0.00$0.00
Year 3$0.00$0.00
Option Year 1$0.00$0.00
Option Year 2$0.00$0.00
Part I, Section I-6.B.9. MODIFICATION AND ENHANCEMENT TASKS
Estimated HoursBlended Hourly RateTotals
Year 1105$0.00$0.00
Year 2105$0.00$0.00
Year 3105$0.00$0.00
Option Year 1105$0.00$0.00
Option Year 2105$0.00$0.00
Part I, Section I-6.B.10. TURNOVER
Fixed Fee
Year 3$0.00
TOTAL PURCHASE ORDER PRICING
Year 1$0.00
Year 2$0.00
Year 3$0.00
TOTAL BASE YEAR$0.00
Option Year 1$0.00
Option Year 2$0.00
GRAND TOTAL$0.00

OLTL

Appendix B Management of the MyOLTL Learning Management System Cost Submittal Worksheet

Part I, Section I-6.A. TRANSITION
Fixed Fee
Year 1$0.00
Part I, Sections I-2 and I-6.B. MAINTENANCE, HOSTING, TECHNICAL SUPPORT AND MEDICATION ADMINISTRATION TASKS
Fixed Monthly FeeTotals
Year 1$0.00$0.00
Year 2$0.00$0.00
Year 3$0.00$0.00
Option Year 1$0.00$0.00
Option Year 2$0.00$0.00
Part I, Section I-6.B.9. MODIFICATION AND ENHANCEMENT TASKS
Estimated HoursBlended Hourly RateTotals
Year 1105$0.00$0.00
Year 2105$0.00$0.00
Year 3105$0.00$0.00
Option Year 1105$0.00$0.00
Option Year 2105$0.00$0.00
Part I, Section I-6.B.10. TURNOVER
Fixed Fee
Year 3$0.00
TOTAL PURCHASE ORDER PRICING
Year 1$0.00
Year 2$0.00
Year 3$0.00
TOTAL BASE YEAR$0.00
Option Year 1$0.00
Option Year 2$0.00
GRAND TOTAL$0.00

Cost Verification

Management of the MyDHS Learning Mangement System
Year 1Year 2Year 3Option Year 1Option Year 2TOTAL COST
Hourly Rate# of HoursTotal# of HoursTotalHourly Rate# of HoursTotalHourly Rate# of HoursTotalHourly Rate# of HoursTotal
Direct Labor Costs
(List by category)
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL0$0.000$0.000$0.000$0.000$0.00$0.00
Labor Overhead
(Indicate what is included and rate used)
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL0$0.000$0.000$0.000$0.000$0.00$0.00
Travel and Subsistence$0.00
TOTAL$0.00$0.00$0.00$0.00$0.00$0.00
Consultant Cost
(List by category)
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL0$0.000$0.000$0.000$0.000$0.00$0.00
Subcontract Cost
(List by category)
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL0$0.000$0.000$0.000$0.000$0.00$0.00
Cost of Supplies and Materials
(Itemize)
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
TOTAL$0.00$0.00$0.00$0.00$0.00$0.00
Other Direct Costs
(Itemize)
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
TOTAL$0.00$0.00$0.00$0.00$0.00$0.00
General Overhead Costs
Operational Overhead$0.00
General Administrative Overhead$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL$0.00$0.00$0.00$0.00$0.00$0.00
Audit Costs$0.00
TOTAL$0.00$0.00$0.00$0.00$0.00$0.00
Fee or Profit$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL COST$0.00$0.00$0.00$0.00$0.00$0.00

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