Schedule B - Pricing Schedule Template.xlsx

XLSX spreadsheet 22 KB Posted

Attached to
Michigan Crisis and Access Line RFP 260000000897
Solicitation number
RFP 171 260000000897 1
Issued by
Grand Traverse County, Lansing City, Michigan

About this file

This is a Schedule B Pricing Schedule Template for a state or local contract opportunity that details labor and supply costs for a crisis services operation. The contract requires two primary positions: a Call Line Manager at $42.00 per hour (2,080 annual hours, 1 position, 1 FTE) responsible for day-to-day operations, and Crisis Specialists at $26.00 per hour (1,040 annual hours, 4 positions, 2 FTEs) who handle calls, chats, and texts. The four Crisis Specialist positions represent four part-time (50%) employees equivalent to two full-time positions. The labor component totals $195,520.00 annually.

The pricing schedule includes a 14% fringe benefit rate composed of 7% for health insurance and 7% for Social Security and Medicare contributions. The contract also requests supply costs, specifically seven laptops at $1,500 each for a total of $10,500 to equip the crisis specialists. The combined total request for both personnel and supplies is $206,020.00. The template allows for additional contractual, supply, and other line items, though no other costs were itemized in the submitted version.

View the file

Other files

File Type Posted
SAMPLE BAA.doc DOC document
SOW A2 - Frontline Strong Together.docx DOCX document
Michigan 988 Center Protocols.pdf PDF
SOW A3 - MI Peer Warmline.docx DOCX document
SOW A1 - 988 MiCAL Crisis Line.docx DOCX document
Vibrant - The 988 Suicide Crisis Lifeline Network Agreement.pdf PDF
Proposal Instructions-VQW-Schedule A - Statement of Work.docx DOCX document
Hybrid Contract Terms.docx DOCX document

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

Schedule B - Pricing
Position/Role/TitleNameHourly RateHours# of PositionsFTEsTotal RequestContractual Narrative
Call Line ManagerExample Jane$ 42.00208011$87,360.00This position oversees day to day operations of the line
Crisis SpecialistExample Various$ 26.00104042

tc={317CBD1D-4078-40AE-8C9C-63A9C0C525AE}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Should this # match the # positions. I’m confused between these two columns Reply:

I'm not sure how these numbers were changed as they don't match what I had uploaded, my apologies. Updating the numbers. The difference in the two columns is number of positions (4 crisis specialists) and FTE is full time equivalent (2 full time positions). Meaning there are 4 50% time positions. It makes more sense with the correct numbers in there, sorry!$108,160.00These positions answer calls, chats, and texts
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total$195,520.00
Contractual Fringe ComponentRate (%)
Example Health7%
Example Social Security/Medicare7%

Total Fringe Rate 14%

Contractual Supplies
ItemUnit CostQuantityDurationTotal RequestContractual Supplies Narrative
Example Laptops$1,50071$10,500Example - laptops for crisis specialists
$0
$0
$0
$0
$0
Total$10,500
Other
ItemUnit CostQuantityDurationTotal RequestOther Narrative

Total $ - 0 Should this # match the # positions. I’m confused between these two columns

I'm not sure how these numbers were changed as they don't match what I had uploaded, my apologies. Updating the numbers. The difference in the two columns is number of positions (4 crisis specialists) and FTE is full time equivalent (2 full time positions). Meaning there are 4 50% time positions. It makes more sense with the correct numbers in there, sorry!

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