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 | ||
| 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 | ||
| 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/Title | Name | Hourly Rate | Hours | # of Positions | FTEs | Total Request | Contractual Narrative |
| Call Line Manager | Example Jane | $ 42.00 | 2080 | 1 | 1 | $87,360.00 | This position oversees day to day operations of the line |
| Crisis Specialist | Example Various | $ 26.00 | 1040 | 4 | 2 |
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.00 | These 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 Component | Rate (%) |
| Example Health | 7% |
| Example Social Security/Medicare | 7% |
Total Fringe Rate 14%
| Contractual Supplies | |||||
| Item | Unit Cost | Quantity | Duration | Total Request | Contractual Supplies Narrative |
| Example Laptops | $1,500 | 7 | 1 | $10,500 | Example - laptops for crisis specialists |
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| $0 | |||||
| Total | $10,500 |
| Other | |||||
| Item | Unit Cost | Quantity | Duration | Total Request | Other 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 .