Exhibit A -Cost Sheet.xlsx.pdf
PDF 361 KB Posted
- Attached to
- Nursing Home Rate Setting
- Contract number
- 435400-O21-853NURHOMER-OO
- Issued by
- Wisconsin
About this file
This document is a completed Cost Worksheet (Attachment A) for RFP S-0853 DMS-21, submitted by Myers and Stauffer LC to the Department of Health Services, Division of Medicaid Services for Nursing Home Rate Setting services. The worksheet was digitally signed on September 9, 2020, and includes detailed cost breakdowns for personnel and non-personnel expenses across multiple contract periods.
The contract covers nursing home rate setting services with a total value of $4,298,050 over approximately five years. The cost structure includes an initial six-month transition period from January-June 2021 ($876,810), followed by Year 1 covering July-December 2021 ($370,854), and subsequent full years ranging from $740,400 to $785,088 annually. Personnel costs comprise the majority of expenses, with hourly rates ranging from $88 for Administrative Support to $450 for Actuary Consultants. The contract includes annual inflation adjustments of 2% and covers various professional roles including Project Directors, IT personnel, clinical staff, and analysts. Non-personnel costs are minimal at $10,200 per full year, primarily consisting of travel expenses for quarterly on-site meetings. The pricing structure demonstrates increasing costs over time due to the inflation factor, with optional renewal terms for Years 4 and 5.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 435400-O21-853NURHOMER-OO.pdf | ||
| Exhibit B - Scope of Work.docx.pdf |
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: Fully complete the Cost Worksheet. The entire Attachment "A' should be uploaded on eSupplier. All the yellow shaded boxes are self-populating based upon Vendor's inputs. Completion of the Cost Worksheet is mandatory.
Vendors may not alter the Worksheet in any way, other than adding additional lines as needed. Prices submitted shall be in U.S. dollars. Prices shall include all direct and indirect labor, insurance, travel and transition cost. Once completed sign and date at the bottom of the Cost Worksheet and post on eSupplier.
Department of Health Services
Division of Medicaid Services Nursing Home Rate Setting
RFP S-0853 DMS-21
Attachment A - Cost Worksheet
DocuSign Envelope ID: A7CC6132-0A34-45A8-B951-978230D6ADC8
Position Title Hourly Rate Number of Hours
Project Director $ 315.00 1,817
Quality Assurance Partner $ 315.00 695
Technical Advisors $ 305.00 345
Project Manager $ 250.00 2,213
Actuary Consultant $ 450.00 775
IT Manager $ 275.00 277
IT Developer $ 225.00 1,950
Clinical Staff $ 185.00 593
Project Leads/Data Manager/IT Business Liaison $ 175.00 3,250
Senior Accountant/Analyst $ 155.00 5,045
Staff Accountant/Analyst $ 130.00 2,190
Administrative Support $ 88.00 1,133
TOTAL PERSONNEL AND NON-PERSONNEL COST ALL YEARS
Sub-Total of Non-Personnel Costs
Total Personnel and Non-Personnel Cost PER YEAR
Sub-Total of Personnel Costs
(E.g. Rent, Travel, Software Purchases, insurance etc.)
Travel - Four (4) on-site meetings per year for three (3) staff
Direct Personnel Costs
Indirect Personnel Costs
ATTACHMENT "A" COST WORKSEET
Number of hours column represents total hours for all five (5) years. Initial Year
Cost For Transition assumes a six-month transition from January 1, 2021 - June 30, 2021. The Cost for the Initial Term - Year 1 represent six-months from July 1, 2021
- December 31, 2021. An annual inflation factor of 2% has been applied.
Signature of Authorized Proposer: ____________________________ Date: 9/9/2020___ Title/Role: Member ____________________________________________ Company Name: Myers and Stauffer LC
Initial Year
Cost For
Transition
Cost for the
Initial Term -
Year 1
Cost for the
Initial Term -
Year 2
Cost for the
Initial Term-
Year 3
Cost for the
Optional Renewal
Term - Year 1
$ 78,750.00 $ 55,125.00 $ 109,620.00 $ 111,812.00 $ 114,048.00
$ 34,650.00 $ 20,475.00 $ 40,950.00 $ 41,769.00 $ 42,604.00
$ 22,875.00 $ 9,150.00 $ 18,300.00 $ 18,666.00 $ 19,039.00
$ 75,000.00 $ 53,250.00 $ 106,250.00 $ 108,375.00 $ 110,542.00
$ 45,000.00 $ 33,750.00 $ 67,500.00 $ 68,850.00 $ 70,227.00
$ 51,425.00 $ 2,750.00 $ 5,500.00 $ 5,610.00 $ 5,722.00
$ 317,250.00 $ 13,500.00 $ 27,000.00 $ 27,540.00 $ 28,090.00
$ 13,875.00 $ 10,730.00 $ 21,275.00 $ 21,700.00 $ 22,134.00
$ 96,250.00 $ 52,500.00 $ 105,000.00 $ 107,100.00 $ 109,242.00
$ 104,625.00 $ 75,330.00 $ 150,505.00 $ 153,515.00 $ 156,585.00
$ 21,450.00 $ 29,250.00 $ 58,500.00 $ 59,670.00 $ 60,863.00
$ 10,560.00 $ 9,944.00 $ 19,800.00 $ 20,196.00 $ 20,599.00
$ 871,710.00 $ 365,754.00 $ 730,200.00 $ 744,803.00 $ 759,695.00
$ 5,100.00 $ 5,100.00 $ 10,200.00 $ 10,200.00 $ 10,200.00
$ 5,100.00 $ 5,100.00 $ 10,200.00 $ 10,200.00 $ 10,200.00
$ 876,810.00 $ 370,854.00 $ 740,400.00 $ 755,003.00 $ 769,895.00
TOTAL PERSONNEL AND NON-PERSONNEL COST ALL YEARS
Direct Personnel Costs
Indirect Personnel Costs
ATTACHMENT "A" COST WORKSEET
Cost for the
Optional Renewal
Term - Year 2
$ 116,329.00
$ 43,456.00
$ 19,420.00
$ 112,753.00
$ 71,631.00
$ 5,836.00
$ 28,652.00
$ 22,577.00
$ 111,426.00
$ 159,717.00
$ 62,080.00
$ 21,011.00
$ 774,888.00
$ 10,200.00
$ 10,200.00
$ 785,088.00
4,298,050.00$
Direct Personnel Costs
Indirect Personnel Costs
ATTACHMENT "A" COST WORKSEET
| 2021-01-05T05:32:05-0800 | |
| Digitally verifiable PDF exported from www.docusign.com |
File details come from the government source that posted it. Updated .