Loading...
HomeMy WebLinkAboutReports - 2023.08.17 - 40481 AGENDA ITEM: Amendment #6 to the 2018-7216 EGLE qPCR Methods for Oakland County Beaches Agreement DEPARTMENT: Health & Human Services MEETING: Board of Commissioners DATE: Thursday, August 17, 2023 7:39 PM - Click to View Agenda ITEM SUMMARY SHEET COMMITTEE REPORT TO BOARD Resolution #2023-3166 Motion to approve and authorize the Chair to sign Amendment #6 to the qPCR Methods for Oakland County Beaches Grant Contract, in the amount of $60,000 through December 31, 2024, further to amend the FY 2024 budget as detailed in the attachment A. ITEM CATEGORY SPONSORED BY Grant Penny Luebs INTRODUCTION AND BACKGROUND The Oakland County Health Division has received Amendment #6 to the Michigan Department of Environmental Quality Beach Grant Contract for the qPCR Methods for Oakland County Beaches Project to continue using source tracking methods to determine sources of fecal contamination. Amendment #6 extends the end date from September 30, 2023 to December 31, 2024 and increases the funding from $ $291,889.85 to 351.889.85, which is an increase of $60,000 with no additional match required. BUDGET AMENDMENT REQUIRED: Yes Committee members can contact Michael Andrews, Policy and Fiscal Analysis Supervisor at 248.425.5572 or andrewsmb@oakgov.com, or the department contact persons listed for additional information. CONTACT Leigh-Anne Stafford, Director Health & Human Services-APP ITEM REVIEW TRACKING Aaron Snover, Board of Commissioners Created/Initiated - 8/17/2023 AGENDA DEADLINE: 08/27/2023 7:39 PM ATTACHMENTS 1. PH&S_Health qPCR Methods for OC Beaches_Amend#6_Sch.A 2. Grant Amendment #6 Sign-Off 3. 2018-7216 Oakland County Amendment 6 revised 4. 2018-7216 QPCR Amendment 6 through Dec 2024 COMMITTEE TRACKING 2023-08-03 Public Health & Safety - Recommend to Board 2023-08-17 Full Board - Approve Motioned by: Commissioner Robert Hoffman Seconded by: Commissioner Brendan Johnson Yes: David Woodward, Michael Spisz, Penny Luebs, Karen Joliat, Kristen Nelson, Christine Long, Robert Hoffman, Philip Weipert, Gwen Markham, Angela Powell, Marcia Gershenson, William Miller III, Yolanda Smith Charles, Charles Cavell, Brendan Johnson, Ajay Raman (16) No: None (0) Abstain: None (0) Absent: Gary McGillivray, Michael Gingell (2) Passed Oakland County, Michigan HEALTH AND HUMAN SERVICES DEPARTMENT/HEALTH DIVISION - QPCR METHODS FOR OAKLAND COUNTY BEACHES 2018-7216 AMENDMENT #6 Schedule "A" DETAIL R/E Fund Name Division Name Fund # (FND)Cost Center (CCN) # Account # (RC/SC) Program # (PRG)Grant ID (GRN) # Project ID # (PROJ) Region (REG) Budget Fund Affiliate (BFA) Ledger Account Summary Account Title FY 2023 Amendment FY 2024 Amendment FY 2025 Amendment R Human Service Grants Health FND11007 CCN1060212 RC615571 PRG134185 GRN-0000840 615000 State Operating Grants $60,000 $-$- Total Revenues $60,000 $-$- E Human Service Grants Health FND11007 CCN1060212 SC702010 PRG134185 GRN-0000840 702000 Salaries $20,000 $-$- E Human Service Grants Health FND11007 CCN1060212 SC722740 PRG134185 GRN-0000840 722000 Fringe Benefits 5,000 -- E Human Service Grants Health FND11007 CCN1060212 SC730926 PRG134185 GRN-0000840 730000 Indirect Costs 3,455 -- E Human Service Grants Health FND11007 CCN1060212 SC732018 PRG134185 GRN-0000840 730000 Travel and Conference 9,000 -- E Human Service Grants Health FND11007 CCN1060212 SC750280 PRG134185 GRN-0000840 750000 Laboratory Supplies 21,045 -- FND11007 CCN1060212 SC760157 PRG134185 GRN-0000840 760000 Equipment 1,500 Total Expenditures $60,000 $-$- GRANT REVIEW SIGN-OFF – Health & Human Services/Health GRANT NAME: qPCR Methods for Oakland County Beaches 2018-7216 FUNDING AGENCY: Michigan Department of Environment, Great Lakes, and Energy (EGLE) DEPARTMENT CONTACT PERSON: Stacey Sledge STATUS: Amendment # 6 (Greater than 15% Variance from Current Award) DATE: 07/13/2023 Original grant contract authorized by MR #18300 SUMMARY: Amendment #6 to the 2018-7216 EGLE grant agreement extends the project end date from 09/30/2023 to 12/31/2024 and increases the project budget to $351,889.85, with no additional in-kind match requirements. Please be advised the captioned grant materials to have completed internal grant review. Below are the returned comments. The Board of Commissioners’ liaison committee resolution and grant amendment package (which should include this sign-off email and the grant amendment with related documentation) may be requested to be placed on the agenda(s) of the appropriate Board of Commissioners’ committee(s) for grant amendment by Board resolution. DEPARTMENT REVIEW Management and Budget: Approved–Sheryl Johnson (07/11/2023) Human Resources: Approved by Human Resources. No position impact. – Heather Mason (07/06/2023) Risk Management: Approved. – Robert Erlenbeck (07/06/2023) Corporation Counsel: Approved. – Sharon Kessler (07/07/2023) Michigan.gov/EGLE Page 1 of 3 EQP9241 (Rev. 03/2022) EGLE Tracking Code/Project Number: 2018-7216 Amendment Request Number: 6 REAL TIME BEACH TESTING AND SOURCE TRACKING GRANT AGREEMENT AMENDMENT BETWEEN THE MICHIGAN DEPARTMENT OF ENVIRONMENT, GREAT LAKES, AND ENERGY AND THE OAKLAND COUNTY HEALTH DIVISION This Amendment modifies the Grant Agreement (Agreement) between the Michigan Department of Environment, Great Lakes, and Energy, Water Resources Division (State), and the Oakland County Health Division (Grantee) signed by the State on September 4, 2018, for the qPCR Methods for Oakland County Beaches Project. This Amendment does not take effect until signed by both parties. The revisions to the Agreement are limited to those specified below. All other provisions of the Agreement remain in effect. The State and Grantee agree to the revisions indicated below. PROJECT SCOPE (WORK PLAN) There are no project scope changes. AGREEMENT PERIOD (END DATE) The State and Grantee agree to extend the end date of the Agreement from September 30, 2023, to December 31, 2024. The Grantee will complete all obligations under the Agreement no later than the amended end date. Costs incurred after the amended end date are not eligible for reimbursement under the Agreement. COMPENSATION (BUDGET) The State and the Grantee agree to add $60,000 as shown in Appendix A. Michigan.gov/EGLE Page 2 of 3 EQP9241 (Rev. 03/2022) AUTHORIZED SIGNATURES The individuals signing below certify by their signatures that they are authorized to sign this Amendment on behalf of their agencies and that the parties will fulfill the terms of this Amendment, including any attached appendices, as set forth herein. FOR THE GRANTEE: Signature David T. Woodward, Chairman Date Name and Title FOR THE STATE: Signature Teresa Seidel, Director, Water Resources Division Date Name and Title Michigan.gov/EGLE Page 3 of 3 EQP9241 (Rev. 03/2022) Appendix A Amendment 6 GRANTEE'S NAME: PROJECT NAME: EFFECTIVE DATE OF REVISION: TRACKING CODE NUMBER:2018-7216 DATE SUBMITTED:4/1/2023 Budget Categories Proposed Revised Project Approved Proposed Revised Local Change Grant Funds Local Match Change Match Funds TOTAL Staffing 84,746.55$ 20,000.00$ 104,746.55$ -$ -$ -$ 104,746.55$ Fringes 19,598.62$ 5,000.00$ 24,598.62$ -$ -$ -$ 24,598.62$ SUBTOTAL: SALARY & FRINGE 104,345.17$ 25,000.00$ 129,345.17$ -$ -$ -$ 129,345.17$ CONTRACTUAL COST registration for conferences 1,025.00$ 500.00$ 1,525.00$ -$ -$ -$ 1,525.00$ 0 -$ -$ -$ -$ -$ -$ -$ Contractual Subtotal 1,025.00$ 500.00$ 1,525.00$ -$ -$ -$ 1,525.00$ SUPPLIES and MATERIALS qPCR supplies 140,274.35$ 21,045.00$ 161,319.35$ 7,000.00$ -$ 7,000.00$ 168,319.35$ 0 -$ -$ -$ -$ -$ -$ -$ 0 -$ -$ -$ -$ -$ -$ -$ Supplies and Materials Subtotal 140,274.35$ 21,045.00$ 161,319.35$ 7,000.00$ -$ 7,000.00$ 168,319.35$ EQIUPMENT(any item over $1000) Equipment 8,500.00$ 1,500.00$ 10,000.00$ -$ -$ -$ 10,000.00$ Automated Pippetor -$ -$ -$ -$ -$ -$ -$ Multi-channel Pippetor -$ -$ -$ -$ -$ -$ -$ Homogenizer 7,265.55$ -$ 7,265.55$ -$ -$ -$ 7,265.55$ high sample volume pippettor -$ -$ -$ -$ -$ -$ -$ EQUIPMENT Subtotal 15,765.55$ 1,500.00$ 17,265.55$ -$ -$ -$ 17,265.55$ Supplies, Materials & Equipment Subtotal 156,039.90$ 22,545.00$ 178,584.90$ 7,000.00$ -$ 7,000.00$ 185,584.90$ TRAVEL MILEAGE 9,119.65$ 3,500.00$ 12,619.65$ -$ -$ -$ 12,619.65$ LODGING/NIGHTS/RATE 456.27$ 2,000.00$ 2,456.27$ -$ -$ -$ 2,456.27$ MEALS 570.40$ 1,000.00$ 1,570.40$ -$ -$ -$ 1,570.40$ OTHER (itemize) Airfare 456.60$ 2,000.00$ 2,456.60$ -$ -$ -$ 2,456.60$ parking 40.00$ -$ 40.00$ -$ -$ -$ 40.00$ Travel Subtotal 10,642.92$ 8,500.00$ 19,142.92$ -$ -$ -$ 19,142.92$ Project Subtotal 272,052.99$ 56,545.00$ 328,597.99$ 7,000.00$ -$ 7,000.00$ 335,597.99$ INDIRECT (not to exceed 20% Staffing and Fringe Benefits)13.8200% Indirect Costs 12,836.86$ 3,455.00$ 16,291.86$ -$ -$ -$ 16,291.86$ TOTAL GRANT AND MATCH BUDGET 284,889.85$ 60,000.00$ 344,889.85$ 7,000.00$ -$ 7,000.00$ 351,889.85$ Project Budget EGLE WATER RESOURCES DIVISION Oakland County Health Division qPCR methods for Oakland County beaches MICHIGAN DEPARTMENT of ENVIRONMENTAL QUALITY WATER RESOURCES DIVISION PROJECT BUDGET FORM (Authorized by the Clean Water Act; completion is required to obtain payment) Grantee Name: Oakland County Health Division Project Name: qPCR methods for Oakland County beaches Tracking Code Number: 2018-7216 GRANT LOCAL AMOUNT MATCH TOTAL Staffing $746.55 $746.55 Fringes $298.62 $-$298.62 STAFFING AND FRINGE BENEFITS Subtotal $1,045.17 $-$1,045.17 HOURS or RATE or CONTRACTUAL SERVICES UNITS TOTAL registration for conferences 1 $600.00 $600.00 $600.00 $-$-$-$- CONTRACTUAL SERVICES Subtotal $600.00 $-$600.00 SUPPLIES, MATERIALS AND EQUIPMENT SUPPLIES & MATERIALS (itemize)QUANTITY COST qPCR supplies 1 $55,273.35 $48,273.35 $7,000.00 $55,273.35 $-$-$-$- $-$-$-$- SUPPLIES AND MATERIALS Subtotal $48,273.35 $7,000.00 $55,273.35 EQUIPMENT (any item over $1000) PCR Hood $7,000.00 $7,000.00 $7,000.00 Automated Pippetor $3,500.00 $3,500.00 $3,500.00 Multi-channel Pippetor $3,500.00 $3,500.00 $3,500.00 Homogenizer $12,000.00 $12,000.00 EQUIPMENT Subtotal $26,000.00 $-$26,000.00 SUPPLIES, MATERIALS AND EQUIPMENT Subtotal $74,273.35 $7,000.00 $81,273.35 TRAVEL MILEAGE $-$-$- LODGING $1,600.00 $1,600.00 MEALS $600.00 $600.00 OTHER TRAVEL (itemize) Airfare $-$1,000.00 $1,000.00 $-$-$-$- TRAVEL Subtotal $3,200.00 $3,200.00 PROJECT Subtotal $79,118.52 $7,000.00 $86,118.52 INDIRECT RATE 12.290% INDIRECT COSTS on salary only per grantee $91.75 $-$128.45 TOTAL GRANT AND MATCH BUDGET $79,210.27 $7,000.00 $86,246.97 Grant portion requiring NO local match $58,210.27 $-$58,210.27 CMI portion requiring local match $21,000.00 $7,000.00 $28,000.00 CMI Project Percentage Split 75.00%25.00% SUMMARY OF INDIRECT CHARGES: Admin costs include accounting (payroll, purchasing, accounts payable) STAFFING DETAILS Grantee Name Oakland County Health Division Project Name qPCR methods for Oakland County beaches Tracking Code 2018-7216 Hourly Rate Range Name Position Title Estimated Hours Current * Projected Highest ** Fringe Rate (Max. 40%) Barb Webeman Lab Manager 0.00 $29.86 40.00% Jenna DeWitte Sanitarian 15.00 $24.63 40.00% Richard Peresky Senior Sanitarian 10.00 $37.71 40.00% * Current hourly rate is the rate for each position when the contract starts. ** Projected highest hourly rate is the anticipated maximum rate for each position during the contract period. MICHIGAN DEPARTMENT OF ENVIRONMENTAL QUALITY WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:May-June 2018 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$-$746.55 $746.55 $-$-$-$- Fringes $-$-$298.62 $298.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$-$1,045.17 $1,045.17 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$-$600.00 $600.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$-$600.00 $600.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$-$48,273.35 $48,273.35 $-$-$7,000.00 $7,000.00 0 $-$-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$-$48,273.35 $48,273.35 $-$-$7,000.00 $7,000.00 EQUIPMENT (any item over $1,000) PCR Hood $-$-$7,000.00 $7,000.00 $-$-$-$- Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$-$12,000.00 $12,000.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$-$26,000.00 $26,000.00 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$-$74,273.35 $74,273.35 $-$-$7,000.00 $7,000.00 TRAVEL:Miles:Rate:$0.00 Mileage $-$-$-$-$-$-$-$- Lodging:$-$-$1,600.00 $1,600.00 $-$-$-$- Meals:$-$-$600.00 $600.00 $-$-$-$- Other:$-$-$1,000.00 $1,000.00 $-$-$-$- $-$-$-$-$-$-$-$- Subtotal:$-$-$3,200.00 $3,200.00 $-$-$-$- PROJECT SUBTOTAL Grant Amount $79,118.52 Local Match $7,000.00 EQP-5847 (5/04) Local Match Percentage Split from CMI 75.00%for CMI grant 25.00% INDIRECT COSTS $-$-$91.75 $91.75 $-$-$-$- GRAND TOTAL $-$-$79,210.27 $79,210.27 $-$-$7,000.00 $7,000.00 By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) MICHIGAN DEPARTMENT OF ENVIRONMENTAL QUALITY WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:July-Sept 2018 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$-$746.55 $746.55 $-$-$-$- Fringes $-$-$298.62 $298.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$-$1,045.17 $1,045.17 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$-$600.00 $600.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$-$600.00 $600.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$-$48,273.35 $48,273.35 $-$7,000.00 $7,000.00 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$-$48,273.35 $48,273.35 $-$-$7,000.00 $7,000.00 EQUIPMENT (any item over $1,000) PCR Hood $-$-$7,000.00 $7,000.00 $-$-$-$- Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$-$12,000.00 $12,000.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$-$26,000.00 $26,000.00 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$-$74,273.35 $74,273.35 $-$-$7,000.00 $7,000.00 TRAVEL:Miles Rate 0.000 Mileage $-$-$-$-$-$-$-$- Lodging:$-$-$1,600.00 $1,600.00 $-$-$-$- Meals:$-$-$600.00 $600.00 $-$-$-$- Other:$-$-$1,000.00 $1,000.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- Subtotal:$-$-$3,200.00 $3,200.00 $-$-$-$- EQP-5847 (5/04) PROJECT SUBTOTAL Grant Amount $79,118.52 Local Match $7,000.00 Local Match Percentage Split from CMI 75.00%for CMI grant 25.00% INDIRECT COSTS $-$-$91.75 $91.75 $-$-$-$- GRAND TOTAL $-$-$79,210.27 $79,210.27 $-$-$7,000.00 $7,000.00 By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- 0 $-$-$- 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) MICHIGAN DEPARTMENT OF ENVIRONMENTAL QUALITY WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:Oct-Dec 2018 Date Submitted:4/8/2019 Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$-$746.55 $746.55 $-$-$-$- Fringes $-$-$298.62 $298.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$-$1,045.17 $1,045.17 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$-$600.00 $600.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$-$600.00 $600.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $95.88 $95.88 $48,273.35 $48,177.47 $31.96 $31.96 $7,000.00 $6,968.04 SUPPLIES AND MATERIALS SUBTOTAL $95.88 $95.88 $48,273.35 $48,177.47 $31.96 $31.96 $7,000.00 $6,968.04 EQUIPMENT (any item over $1,000) PCR Hood $-$-$7,000.00 $7,000.00 $-$-$-$- Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$-$12,000.00 $12,000.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$-$26,000.00 $26,000.00 $-$-$-$- Supplies, Materials and Equipment Subtotal $95.88 $95.88 $74,273.35 $74,177.47 $31.96 $31.96 $7,000.00 $6,968.04 TRAVEL:Miles Rate 0.000 Mileage $-$-$-$-$-$-$-$- Lodging:$-$-$1,600.00 $1,600.00 $-$-$-$- Meals:$-$-$600.00 $600.00 $-$-$-$- Other:$-$-$1,000.00 $1,000.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- Subtotal:$-$-$3,200.00 $3,200.00 $-$-$-$- PROJECT SUBTOTAL Grant Amount $79,118.52 Local Match $7,000.00 Local Match Percentage Split from CMI 75.00%for CMI grant 25.00% INDIRECT COSTS $-$-$91.75 $91.75 $-$-$-$- GRAND TOTAL $95.88 $95.88 $79,210.27 $79,114.39 $31.96 $31.96 $7,000.00 $6,968.04 By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. EQP-5847 (5/04) MICHIGAN DEPARTMENT OF ENVIRONMENTAL QUALITY WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:Jan-March 2019 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$-$746.55 $746.55 $-$-$-$- Fringes $-$-$298.62 $298.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$-$1,045.17 $1,045.17 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$-$600.00 $600.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$-$600.00 $600.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR Supplies ($268.14)$20,183.59 $20,279.47 $48,273.35 $27,993.88 $31.96 $7,000.00 $6,968.04 Colilert ($9350)$-$-$-$-$-$-$- Mastermix ($10,565.45)$-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $20,183.59 $20,279.47 $48,273.35 $27,993.88 $-$31.96 $7,000.00 $6,968.04 EQUIPMENT (any item over $1,000) PCR Hood $-$-$7,000.00 $7,000.00 $-$-$-$- Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$-$12,000.00 $12,000.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$-$26,000.00 $26,000.00 $-$-$-$- Supplies, Materials and Equipment Subtotal $20,183.59 $20,279.47 $74,273.35 $53,993.88 $-$31.96 $7,000.00 $6,968.04 TRAVEL:Miles 138.00 Rate 0.545 Mileage $75.21 $75.21 $-$(75.21)$-$-$-$- Lodging:$-$-$1,600.00 $1,600.00 $-$-$-$- Meals:$389.85 $389.85 $600.00 $210.15 $-$-$-$- Other:$-$-$1,000.00 $1,000.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- Subtotal:$465.06 $465.06 $3,200.00 $2,734.94 $-$-$-$- EQP-5847 (5/04) PROJECT SUBTOTAL Grant Amount $79,118.52 Local Match $7,000.00 Local Match Percentage Split from CMI 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$-$91.75 $91.75 $-$-$-$- GRAND TOTAL $20,648.65 $20,744.53 $79,210.27 $58,465.74 $-$31.96 $7,000.00 $6,968.04 By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) MICHIGAN DEPARTMENT OF ENVIRONMENTAL QUALITY WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:April-June 2019 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $115.35 $115.35 $746.55 $631.20 $-$-$-$- Fringes $41.53 $41.53 $298.62 $257.09 $-$-$-$- SALARY & FRINGE SUBTOTAL $156.88 $156.88 $1,045.17 $888.29 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $525.00 $525.00 $600.00 $75.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $525.00 $525.00 $600.00 $75.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies see list below $26,997.71 $48,273.35 $21,275.64 $31.96 $7,000.00 $6,968.04 qpcr supplies (culture tubes)$125.78 $-$-$-$-$-$- qpcr supplies (wipes, pipettes, decontaminant)$3,623.26 $-$-$-$-$-$- qpcr supplies (PCR cooler starter set)$171.06 $-$-$-$-$-$- qpcr supplies (bottles)$364.89 $-$-$-$-$-$- qpcr supplies (glass beads)$356.40 $-$-$-$-$-$- qpcr supplies (15-well cooler)$164.72 $-$-$-$-$-$- qpcr supplies (15-well cooler)$127.39 $-$-$-$-$-$- qpcr supplies (micro tubes)$255.60 $-$-$-$-$-$- qpcr supplies (pipettes)$203.92 $-$-$-$-$-$- qpcr supplies (mech cryogenic)$112.80 $-$-$-$-$-$- qpcr supplies (caps)$27.71 $-$-$-$-$-$- qpcr supplies (alcohol)$34.36 $-$-$-$-$-$- qpcr supplies (burners)$14.31 $-$-$-$-$-$- qpcr supplies (bottles)$390.90 $-$-$-$-$-$- qpcr supplies (Vacuum Pump)$745.14 $-$-$-$-$-$- $- SUPPLIES AND MATERIALS SUBTOTAL $6,718.24 $26,997.71 $48,273.35 $21,275.64 $-$31.96 $7,000.00 $6,968.04 EQUIPMENT (any item over $1,000) PCR Hood $3,409.09 $3,409.09 $7,000.00 $3,590.91 $-$-$-$- EQP-5847 (5/04) Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $7,265.55 $7,265.55 $12,000.00 $4,734.45 $-$-$-$- 0 $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $10,674.64 $10,674.64 $26,000.00 $15,325.36 $-$-$-$- Supplies, Materials and Equipment Subtotal $17,392.88 $37,672.35 $74,273.35 $36,601.00 $-$31.96 $7,000.00 $6,968.04 TRAVEL:Miles Rate 0.000 Mileage $44.44 $119.65 $-$(119.65)$-$-$-$- Lodging:$456.27 $456.27 $1,600.00 $1,143.73 $-$-$-$- Meals:$180.55 $570.40 $600.00 $29.60 $-$-$-$- Other: Airfare $456.60 $456.60 $1,000.00 $543.40 $-$-$-$- parking $40.00 $40.00 $-$(40.00)$-$-$-$- Subtotal:$1,177.86 $1,642.92 $3,200.00 $1,557.08 $-$-$-$- PROJECT SUBTOTAL Grant Amount $79,118.52 Local Match $7,000.00 Local Match Percentage Split from CMI 75.00%for CMI grant 25.00% INDIRECT COSTS 12.29% on salary $14.18 $14.18 $91.75 $77.57 $-$-$-$- GRAND TOTAL $19,266.80 $40,011.33 $79,210.27 $39,198.94 $-$31.96 $7,000.00 $6,968.04 By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian 4.33 $26.64 $115.35 $-$115.35 0 $-$-$-$- 0 $-$-$-$- Totals 4.33 $115.35 $-$115.35 Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Jenna DeWitte, Sanitarian 36%$41.53 $-$41.53 0 $-$-$- 0 $-$-$- Total Fringes $41.53 $-$41.53 EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION AMENDMENT 1 GRANTEE'S NAME: Oakland County Health Division PROJECT NAME: qPCR methods for Oakland County beaches EFFECTIVE DATE OF REVISION: TRACKING CODE NUMBER:2018-7216 DATE SUBMITTED: Budget Categories Approved Proposed Revised Project Approved Proposed Revised Local Project Budget Change Grant Funds Local Match Change Match Funds TOTAL Staffing $746.55 $-$746.55 $-$-$-$746.55 Fringes $298.62 $-$298.62 $-$-$-$298.62 SUBTOTAL: SALARY & FRINGE $1,045.17 $-$1,045.17 $-$-$-$1,045.17 CONTRACTUAL COST registration for conferences $600.00 $-$600.00 $-$-$-$600.00 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- Contractual Subtotal $600.00 $-$600.00 $-$-$-$600.00 SUPPLIES and MATERIALS qPCR supplies $48,273.35 $-$48,273.35 $7,000.00 $-$7,000.00 $55,273.35 0 $-$-$-$-$-$-$- Supplies and Materials Subtotal $48,273.35 $-$48,273.35 $7,000.00 $-$7,000.00 $55,273.35 EQIUPMENT(any item over $1000) PCR Hood $7,000.00 $-$7,000.00 $-$-$-$7,000.00 Automated Pippetor $3,500.00 $-$3,500.00 $-$-$-$3,500.00 Multi-channel Pippetor $3,500.00 $-$3,500.00 $-$-$-$3,500.00 Homogenizer $12,000.00 $-$12,000.00 $-$-$-$12,000.00 high sample volume pippettor $-$11,475.00 $11,475.00 $-$-$-$11,475.00 0 $-$-$-$-$-$-$- EQUIPMENT Subtotal $26,000.00 $11,475.00 $37,475.00 $-$-$-$37,475.00 Supplies, Materials & Equipment Subtotal $74,273.35 $11,475.00 $85,748.35 $7,000.00 $-$7,000.00 $92,748.35 TRAVEL MILEAGE $-$-$-$-$-$-$- LODGING/NIGHTS/RATE $1,600.00 $-$1,600.00 $-$-$-$1,600.00 MEALS $600.00 $-$600.00 $-$-$-$600.00 OTHER (itemize) Airfare $1,000.00 $-$1,000.00 $-$-$-$1,000.00 0 $-$-$-$-$-$-$- Travel Subtotal $3,200.00 $-$3,200.00 $-$-$-$3,200.00 Project Subtotal $79,118.52 $11,475.00 $90,593.52 $7,000.00 $-$7,000.00 $97,593.52 INDIRECT (not to exceed 20% Staffing and Fringe Benefits) Indirect Costs $95.48 $-$95.48 $-$-$-$95.48 TOTAL GRANT AND MATCH BUDGET $79,214.00 $11,475.00 $90,689.00 $7,000.00 $-$7,000.00 $97,689.00 EQP-3592b (11/02) MICHIGAN DEPARTMENT OF ENVIRONMENTAL QUALITY WATER RESOURCES DIVISION BUDGET REVISION (2) GRANTEE'S NAME: Oakland County Health Division PROJECT NAME: qPCR methods for Oakland County beaches EFFECTIVE DATE OF REVISION: TRACKING CODE NUMBER:2018-7216 DATE SUBMITTED: Budget Categories Approved Proposed Revised Project Approved Proposed Revised Local Project Budget Change Grant Funds Local Match Change Match Funds TOTAL Staffing $746.55 $-$746.55 $-$-$-$746.55 Fringes $298.62 $298.62 $-$-$-$298.62 SUBTOTAL: SALARY & FRINGE $1,045.17 $-$1,045.17 $-$-$-$1,045.17 CONTRACTUAL COST registration for conferences $600.00 $-$600.00 $-$-$-$600.00 0 $-$-$-$-$-$-$- Contractual Subtotal $600.00 $-$600.00 $-$-$-$600.00 SUPPLIES and MATERIALS qPCR supplies $48,273.35 $-$48,273.35 $7,000.00 $-$7,000.00 $55,273.35 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- Supplies and Materials Subtotal $48,273.35 $-$48,273.35 $7,000.00 $-$7,000.00 $55,273.35 EQIUPMENT(any item over $1000) PCR Hood $7,000.00 $-$7,000.00 $-$-$-$7,000.00 Automated Pippetor $3,500.00 $-$3,500.00 $-$-$- Multi-channel Pippetor $3,500.00 $-$3,500.00 $-$-$- Homogenizer $12,000.00 $-$12,000.00 $-$-$- high sample volume pippettor $11,475.00 $-$11,475.00 $-$-$-$11,475.00 EQUIPMENT Subtotal $37,475.00 $-$37,475.00 $-$-$-$18,475.00 Supplies, Materials & Equipment Subtotal $85,748.35 $-$85,748.35 $7,000.00 $-$7,000.00 $73,748.35 TRAVEL MILEAGE $-$119.65 $119.65 $-$-$-$119.65 LODGING/NIGHTS/RATE $1,600.00 $-$1,600.00 $-$-$-$1,600.00 MEALS $600.00 $-$600.00 $-$-$-$600.00 OTHER (itemize) Airfare $1,000.00 $(159.65)$840.35 $-$-$-$840.35 parking $-$40.00 $40.00 $-$-$-$40.00 Travel Subtotal $3,200.00 $-$3,200.00 $-$-$-$3,200.00 Project Subtotal $90,593.52 $-$90,593.52 $7,000.00 $-$7,000.00 $78,593.52 INDIRECT (not to exceed 20% Staffing and Fringe Benefits)0.00% Indirect Costs $95.48 $-$95.48 $-$-$-$95.48 TOTAL GRANT AND MATCH BUDGET $90,689.00 $-$90,689.00 $7,000.00 $-$7,000.00 $78,689.00 EQP-3592b (11/02) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:July-Sept 2019 Date Submitted:10/18/19 Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $631.18 $746.53 $746.55 $0.02 $-$-$-$- Fringes $252.47 $294.00 $298.62 $4.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $883.65 $1,040.53 $1,045.17 $4.64 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $600.00 $75.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $600.00 $75.00 $-$-$-$- Supplies, Material and Equipment suplies listed below total of supplies total to date in budget remain qPCR supplies $112.80 $32,193.80 $48,273.35 $16,079.55 $31.96 $7,000.00 $0.00 Bottles $361.96 $- VWR Tube Micro 2.0 $255.60 $- Colilert $-$6,160.00 $6,160.00 towards $7,000 $- Filter Memb $1,286.80 $- Caps $39.24 $- Bottles $379.24 $- Cell Divider $39.60 $- Pipettes $118.16 $808.04 $808.04 towards $7,000 $- 120 mL vessels $675.00 $- Microplate $311.68 $- Bottles $131.31 $- Supplies $1,484.70 $-$-$- $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $5,196.09 $32,193.80 $48,273.35 $16,079.55 $6,968.04 $7,000.00 $7,000.00 $- EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$-$- EQP-5847 (5/04) Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$7,265.55 $12,000.00 $4,734.45 $-$-$-$- high sample volume pippettor $-$-$11,475.00 $11,475.00 $-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $37,475.00 $26,800.36 $-$-$-$- Supplies, Materials and Equipment Subtotal $5,196.09 $42,868.44 $85,748.35 $42,879.91 $6,968.04 $7,000.00 $7,000.00 $- TRAVEL:Miles Rate 0.000 Mileage $-$119.65 $119.65 $-$-$-$-$- Lodging:$-$456.27 $1,600.00 $1,143.73 $-$-$-$- Meals:$-$570.40 $600.00 $29.60 $-$-$-$- Other: airfare $-$456.60 $840.35 $383.75 $-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$1,642.92 $3,200.00 $1,557.08 $-$-$-$- PROJECT SUBTOTAL Grant Amount $90,593.52 Local Match $7,000.00 Local Match Percentage Split from CMI 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS 12.29% on salary $77.57 $91.75 $95.48 $3.73 $-$-$-$- GRAND TOTAL $6,157.31 $46,168.64 $90,689.00 $44,520.36 $6,968.04 $7,000.00 $7,000.00 $- By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian 18.64 $26.64 $496.57 $496.57 Richard Peresky 3.50 $38.46 $134.61 $-$134.61 Totals 22.14 $631.18 $-$631.18 Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Jenna DeWitte, Sanitarian 40%$198.63 $-$198.63 Richard Peresky 40%$53.84 $-$53.84 Total Fringes $252.47 $-$252.47 EQP-5847 (5/04) MICHIGAN DEPARTMENT OF ENVIRONMENTAL QUALITY WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:Oct-Dec 2019 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$746.53 $746.55 $0.02 $-$-$-$- Fringes $-$294.00 $298.62 $4.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$1,040.53 $1,045.17 $4.64 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $600.00 $75.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $600.00 $75.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$37,372.65 $48,273.35 $10,900.70 $13,385.62 $7,000.00 $(6,385.62) Kwik-stiks $137.42 $- Master mix $5,041.43 $6,385.62 $6,385.62 towards $7000 $- $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $5,178.85 $37,372.65 $48,273.35 $10,900.70 $6,385.62 $19,771.24 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$-$- Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$7,265.55 $12,000.00 $4,734.45 $-$-$-$- high sample volume pippettor $-$-$11,475.00 $11,475.00 $-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $37,475.00 $26,800.36 $-$-$-$- Supplies, Materials and Equipment Subtotal $5,178.85 $48,047.29 $85,748.35 $37,701.06 $6,385.62 $19,771.24 $7,000.00 $(6,385.62) TRAVEL:Miles Rate 0.000 Mileage $-$119.65 $119.65 $-$-$-$-$- Lodging:$-$456.27 $1,600.00 $1,143.73 $-$-$-$- Meals:$-$570.40 $600.00 $29.60 $-$-$-$- Other:$-$456.60 $840.35 $383.75 $-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$1,642.92 $3,200.00 $1,557.08 $-$-$-$- PROJECT SUBTOTAL Grant Amount $90,593.52 Local Match $7,000.00 Local Match Percentage Split from CMI 75.00%for CMI grant 25.00% INDIRECT COSTS 12.29% on salary $-$91.75 $95.48 $3.73 $-$-$-$- GRAND TOTAL $5,178.85 $51,347.49 $90,689.00 $39,341.51 $6,385.62 $13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Jenna DeWitte, Sanitarian $-$-$- Richard Peresky $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:Jan March 2020 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$746.53 $746.55 $0.02 $-$-$-$- Fringes $-$294.00 $298.62 $4.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$1,040.53 $1,045.17 $4.64 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $600.00 $75.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $600.00 $75.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$37,372.65 $48,273.35 $10,900.70 $13,385.62 $7,000.00 $(6,385.62) $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$37,372.65 $48,273.35 $10,900.70 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$-$- Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$7,265.55 $12,000.00 $4,734.45 $-$-$-$- high sample volume pippettor $-$-$11,475.00 $11,475.00 $-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $37,475.00 $26,800.36 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$48,047.29 $85,748.35 $37,701.06 $-$13,385.62 $7,000.00 $(6,385.62) EQP-5847 (5/04) TRAVEL:Miles Rate 0.000 Mileage $-$119.65 $119.65 $-$-$-$-$- Lodging:$-$456.27 $1,600.00 $1,143.73 $-$-$-$- Meals:$-$570.40 $600.00 $29.60 $-$-$-$- Other:$-$456.60 $840.35 $383.75 $-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$1,642.92 $3,200.00 $1,557.08 $-$-$-$- PROJECT SUBTOTAL Grant Amount $90,593.52 $39,337.78 Local Match $7,000.00 Project Total Percentage Split from CMI 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$91.75 $95.48 $3.73 $-$-$-$- GRAND TOTAL $-$51,347.49 $90,689.00 $39,341.51 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Jenna DeWitte, Sanitarian $-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:April June 2020 Date Submitted:July 2020 Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$746.53 $746.55 $0.02 $-$-$-$- Fringes $-$294.00 $298.62 $4.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$1,040.53 $1,045.17 $4.64 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $600.00 $75.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $600.00 $75.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$46,004.33 $48,273.35 $2,269.02 $13,385.62 $7,000.00 $(6,385.62) Glass beads $470.06 Micro tubes, filters, extraction tubes $1,807.86 500 ml bottles and caps $369.31 Filters $1,744.70 Filters $279.54 120 ml bottles, Quanti-tray $1,775.00 500 ml bottles and caps $747.71 120 ml bottles, Quanti-tray $1,437.50 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $8,631.68 $46,004.33 $48,273.35 $2,269.02 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$-$- Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$7,265.55 $12,000.00 $4,734.45 $-$-$-$- high sample volume pippettor $-$-$11,475.00 $11,475.00 $-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $37,475.00 $26,800.36 $-$-$-$- Supplies, Materials and Equipment Subtotal $8,631.68 $56,678.97 $85,748.35 $29,069.38 $-$13,385.62 $7,000.00 $(6,385.62) EQP-5847 (5/04) TRAVEL:Miles Rate 0.000 Mileage $-$119.65 $119.65 $-$-$-$-$- Lodging:$-$456.27 $1,600.00 $1,143.73 $-$-$-$- Meals:$-$570.40 $600.00 $29.60 $-$-$-$- Other:$-$456.60 $840.35 $383.75 $-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$1,642.92 $3,200.00 $1,557.08 $-$-$-$- EQP-5847 (5/04) PROJECT SUBTOTAL Grant Amount $90,593.52 $30,706.10 Local Match $7,000.00 Project Total Percentage Split from CMI 75.00%for CMI grant 25.00% INDIRECT COSTS $-$91.75 $95.48 $3.73 $-$-$-$- GRAND TOTAL $8,631.68 $59,979.17 $90,689.00 $30,709.83 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Jenna DeWitte, Sanitarian $-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- 0 $-$-$- 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:July Sept 2020 Date Submitted:Oct 2020 Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$746.53 $746.55 $0.02 $-$-$-$- Fringes $-$294.00 $298.62 $4.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$1,040.53 $1,045.17 $4.64 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $600.00 $75.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $600.00 $75.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$49,537.38 $48,273.35 $(1,264.03)$13,385.62 $7,000.00 $(6,385.62) 120 ml Bottles, Quanti-tray $1,775.00 500 ml bottles and caps $369.42 HEPA filters $887.00 Marking pens $38.68 Microplate $462.95 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $3,533.05 $49,537.38 $48,273.35 $(1,264.03)$-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$-$- Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$7,265.55 $12,000.00 $4,734.45 $-$-$-$- high sample volume pippettor $-$-$11,475.00 $11,475.00 $-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $37,475.00 $26,800.36 $-$-$-$- Supplies, Materials and Equipment Subtotal $3,533.05 $60,212.02 $85,748.35 $25,536.33 $-$13,385.62 $7,000.00 $(6,385.62) TRAVEL:Miles Rate 0.000 Mileage $-$119.65 $119.65 $-$-$-$-$- Lodging:$-$456.27 $1,600.00 $1,143.73 $-$-$-$- EQP-5847 (5/04) Meals:$-$570.40 $600.00 $29.60 $-$-$-$- Other:$-$456.60 $840.35 $383.75 $-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$1,642.92 $3,200.00 $1,557.08 $-$-$-$- EQP-5847 (5/04) PROJECT SUBTOTAL Grant Amount $90,593.52 $27,173.05 Local Match $7,000.00 Project Total Percentage Split from CMI 75.00%for CMI grant 25.00% INDIRECT COSTS $-$91.75 $95.48 $3.73 $-$-$-$- GRAND TOTAL $3,533.05 $63,512.22 $90,689.00 $27,176.78 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Jenna DeWitte, Sanitarian $-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- 0 $-$-$- 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION Amendment 3 GRANTEE'S NAME: Oakland County Health Division PROJECT NAME: qPCR methods for Oakland County beaches EFFECTIVE DATE OF REVISION: TRACKING CODE NUMBER:2018-7216 DATE SUBMITTED:September 4,2020, signed by EGLE Sept. 11, 2020 Budget Categories Approved Proposed Revised Project Approved Proposed Revised Local Project Budget Change Grant Funds Local Match Change Match Funds TOTAL Staffing $746.55 $30,000.00 $30,746.55 $-$-$-$30,746.55 Fringes $298.62 $10,000.00 $10,298.62 $-$-$-$10,298.62 SUBTOTAL: SALARY & FRINGE $1,045.17 $40,000.00 $41,045.17 $-$-$-$41,045.17 CONTRACTUAL COST registration for conferences $600.00 $-$600.00 $-$-$-$600.00 0 $-$-$-$-$-$-$- Contractual Subtotal $600.00 $-$600.00 $-$-$-$600.00 SUPPLIES and MATERIALS qPCR supplies $48,273.35 $15,256.00 $63,529.35 $7,000.00 $-$7,000.00 $70,529.35 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- Supplies and Materials Subtotal $48,273.35 $15,256.00 $63,529.35 $7,000.00 $-$7,000.00 $70,529.35 EQIUPMENT(any item over $1000) PCR Hood $7,000.00 $-$7,000.00 $-$-$-$7,000.00 Automated Pippetor $3,500.00 $-$3,500.00 $-$-$-$3,500.00 Multi-channel Pippetor $3,500.00 $-$3,500.00 $-$-$-$3,500.00 Homogenizer $12,000.00 $-$12,000.00 $-$-$-$12,000.00 high sample volume pippettor $11,475.00 $-$11,475.00 $-$-$-$11,475.00 EQUIPMENT Subtotal $37,475.00 $-$37,475.00 $-$-$-$37,475.00 Supplies, Materials & Equipment Subtotal $85,748.35 $15,256.00 $101,004.35 $7,000.00 $-$7,000.00 $108,004.35 TRAVEL MILEAGE $119.65 $-$119.65 $-$-$-$119.65 LODGING/NIGHTS/RATE $1,600.00 $-$1,600.00 $-$-$-$1,600.00 MEALS $600.00 $-$600.00 $-$-$-$600.00 OTHER (itemize) Airfare $840.35 $-$840.35 $-$-$-$840.35 parking $40.00 $-$40.00 $-$-$-$40.00 Travel Subtotal $3,200.00 $-$3,200.00 $-$-$-$3,200.00 Project Subtotal $90,593.52 $55,256.00 $145,849.52 $7,000.00 $-$7,000.00 $152,849.52 INDIRECT (not to exceed 20% Staffing and Fringe Benefits) Indirect Costs $95.48 $4,744.00 $4,839.48 $-$-$-$4,839.48 TOTAL GRANT AND MATCH BUDGET $90,689.00 $60,000.00 $150,689.00 $7,000.00 $-$7,000.00 $157,689.00 EQP-3592b (11/02) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division Project Name:qPCR methods for Oakland County beaches NO ACTIVITY DEQ Tracking Code:2018-7216 Period Covered:Oct Dec 2020 Date Submitted:1/28/2021 Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$746.53 $30,746.55 $30,000.02 $-$-$-$- Fringes $-$294.00 $10,298.62 $10,004.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$1,040.53 $41,045.17 $40,004.64 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $600.00 $75.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $600.00 $75.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$49,537.38 $63,529.35 $13,991.97 $13,385.62 $7,000.00 $(6,385.62) 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$49,537.38 $63,529.35 $13,991.97 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$7,265.55 $12,000.00 $4,734.45 $-$-$-$- high sample volume pippettor $-$-$11,475.00 $11,475.00 $-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $37,475.00 $26,800.36 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$60,212.02 $101,004.35 $40,792.33 $-$13,385.62 $7,000.00 $(6,385.62) TRAVEL:Miles Rate 0.000 Mileage $-$119.65 $119.65 $-$-$-$-$- Lodging:$-$456.27 $1,600.00 $1,143.73 $-$-$-$- Meals:$-$570.40 $600.00 $29.60 $-$-$-$- Other:$-$456.60 $840.35 $383.75 $-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$1,642.92 $3,200.00 $1,557.08 $-$-$-$- PROJECT SUBTOTAL Grant Amount $145,849.52 $82,429.05 Local Match $7,000.00 EQP-5847 (5/04) Project Total Percentage Split from CMI 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$91.75 $4,839.48 $4,747.73 $-$-$-$- GRAND TOTAL $-$63,512.22 $150,689.00 $87,176.78 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Jenna DeWitte, Sanitarian $-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division NO ACTIVITY Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:Jan March 2021 Date Submitted:4/29/2021 Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$746.53 $30,746.55 $30,000.02 $-$-$-$- Fringes $-$294.00 $10,298.62 $10,004.62 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$1,040.53 $41,045.17 $40,004.64 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $600.00 $75.00 $-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $600.00 $75.00 $-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$49,537.38 $63,529.35 $13,991.97 $13,385.62 $7,000.00 $(6,385.62) 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$49,537.38 $63,529.35 $13,991.97 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Multi-channel Pippetor $-$-$3,500.00 $3,500.00 $-$-$-$- Homogenizer $-$7,265.55 $12,000.00 $4,734.45 $-$-$-$- high sample volume pippettor $-$-$11,475.00 $11,475.00 $-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $37,475.00 $26,800.36 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$60,212.02 $101,004.35 $40,792.33 $-$13,385.62 $7,000.00 $(6,385.62) TRAVEL:Miles Rate 0.000 Mileage $-$119.65 $119.65 $-$-$-$-$- Lodging:$-$456.27 $1,600.00 $1,143.73 $-$-$-$- Meals:$-$570.40 $600.00 $29.60 $-$-$-$- Other:$-$456.60 $840.35 $383.75 $-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$1,642.92 $3,200.00 $1,557.08 $-$-$-$- PROJECT SUBTOTAL Grant Amount $145,849.52 $82,429.05 Local Match $7,000.00 EQP-5847 (5/04) Project Total Percentage Split from CMI 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$91.75 $4,839.48 $4,747.73 $-$-$-$- GRAND TOTAL $-$63,512.22 $150,689.00 $87,176.78 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Jenna DeWitte, Sanitarian $-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Pam LaFoy-Wolff Medical Technologist 68.00 $35.16 $2,390.88 $-$2,390.88 Aimee Martek Medical Technologist 52.00 $33.84 $1,759.68 $-$1,759.68 Jolly Shah Medical Technologist 68.00 $33.84 $2,301.12 $-$2,301.12 Anna Autstin student 8.00 $16.08 $128.64 $-$128.64 Alison Bartholomew Student 32.00 $11.88 $380.16 $-$380.16 Jessica Woodman Student 32.00 $11.88 $380.16 $-$380.16 Samantha Southern Student 24.00 $15.02 $360.48 $-$360.48 Bonnie Carter Laboratory Supervisor 10.00 $39.17 $391.70 $-$391.70 Jeanine McCloskey EH Supervisor 14.25 $46.56 $663.48 $-$663.48 Richard Peresky Senior Sanitarian 23.25 $42.23 $981.85 $-$981.85 Christen Hayes Sanitarian 27.25 $36.48 $994.08 $-$994.08 Paige Peterson Student 27.00 $15.92 $429.84 $-$429.84 Alex Hines Student 31.00 $15.92 $493.52 $-$493.52 Neel Naik Student 28.00 $15.92 $445.76 $-$445.76 Chiara Nava Student 24.00 $15.92 $382.08 $-$382.08 Valance Washington Student 26.00 $15.92 $413.92 $-$413.92 0 $-$-$-$- 0 $-$-$-$- Totals 494.75 $12,897.35 $-$12,897.35 Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Pam LaFoy-Wolff Medical Technologist 40%$956.35 $-$956.35 Aimee Martek Medical Technologist 40%$703.87 $-$703.87 Jolly Shah Medical Technologist 40%$920.45 $-$920.45 Anna Autstin student 5%$6.92 $-$6.92 Alison Bartholomew Student 5%$20.45 $-$20.45 Jessica Woodman Student 5%$20.45 $-$20.45 Samantha Southern Student 5%$19.39 $-$19.39 Bonnie Carter Laboratory Supervisor 40%$156.68 $-$156.68 Jeanine McCloskey EH Supervisor 5%$33.17 $-$33.17 Richard Peresky Senior Sanitarian 40%$392.74 $-$392.74 Christen Hayes Sanitarian 40%$397.63 $-$397.63 Paige Peterson Student 5%$21.49 $-$21.49 Alex Hines Student 5%$24.68 $-$24.68 Neel Naik Student 5%$22.29 $-$22.29 Chiara Nava Student 5%$19.10 $-$19.10 Valance Washington Student 5%$20.70 $-$20.70 0 $-$-$- 0 $-$-$- Total Fringes $3,736.36 $-$3,736.36 EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION Amendment 4 GRANTEE'S NAME: Oakland County Health Division PROJECT NAME: qPCR methods for Oakland County beaches EFFECTIVE DATE OF REVISION: 5/1/2021 TRACKING CODE NUMBER:2018-7216 DATE SUBMITTED:4/26/2021 Budget Categories Approved Proposed Revised Project Approved Proposed Revised Local Project Budget Change Grant Funds Local Match Change Match Funds TOTAL Staffing $30,746.55 $34,000.00 $64,746.55 $-$-$-$64,746.55 Fringes $10,298.62 $4,300.00 $14,598.62 $-$-$-$14,598.62 SUBTOTAL: SALARY & FRINGE $41,045.17 $38,300.00 $79,345.17 $-$-$-$79,345.17 CONTRACTUAL COST registration for conferences $600.00 $(75.00)$525.00 $-$-$-$525.00 0 $-$-$-$-$-$-$- Contractual Subtotal $600.00 $(75.00)$525.00 $-$-$-$525.00 SUPPLIES and MATERIALS qPCR supplies $63,529.35 $49,700.00 $113,229.35 $7,000.00 $-$7,000.00 $120,229.35 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- Supplies and Materials Subtotal $63,529.35 $49,700.00 $113,229.35 $7,000.00 $-$7,000.00 $120,229.35 EQIUPMENT(any item over $1000) Equipment $7,000.00 $-$7,000.00 $-$-$-$7,000.00 Automated Pippetor $3,500.00 $(3,500.00)$-$-$-$-$- Multi-channel Pippetor $3,500.00 $(3,500.00)$-$-$-$-$- Homogenizer $12,000.00 $(4,734.45)$7,265.55 $-$-$-$7,265.55 high sample volume pippettor $11,475.00 $(11,475.00)$-$-$-$-$- EQUIPMENT Subtotal $37,475.00 $(23,209.45)$14,265.55 $-$-$-$14,265.55 Supplies, Materials & Equipment Subtotal $101,004.35 $26,490.55 $127,494.90 $7,000.00 $-$7,000.00 $134,494.90 TRAVEL MILEAGE $119.65 $5,500.00 $5,619.65 $-$-$-$5,619.65 LODGING/NIGHTS/RATE $1,600.00 $(1,143.73)$456.27 $-$-$-$456.27 MEALS $600.00 $(29.60)$570.40 $-$-$-$570.40 OTHER (itemize) Airfare $840.35 $(383.75)$456.60 $-$-$-$456.60 parking $40.00 $-$40.00 $-$-$-$40.00 Travel Subtotal $3,200.00 $3,942.92 $7,142.92 $-$-$-$7,142.92 Project Subtotal $145,849.52 $68,658.47 $214,507.99 $7,000.00 $-$7,000.00 $221,507.99 INDIRECT (not to exceed 20% Staffing and Fringe Benefits) Indirect Costs $4,839.48 $4,542.38 $9,381.86 $-$-$-$9,381.86 TOTAL GRANT AND MATCH BUDGET $150,689.00 $73,200.85 $223,889.85 $7,000.00 $-$7,000.00 $230,889.85 EQP-3592b (11/02) QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Pamela Lafoy-Wolff Medical Technologist 76.00 $35.16 $-$2,672.16 $2,672.16 Aimee Martek Medical Technologist 72.00 $33.84 $-$2,436.48 $2,436.48 Jolly Shah Medical Technologist 100.00 $33.84 $-$3,384.00 $3,384.00 Alison Bartholomew Student 48.00 $11.88 $-$570.24 $570.24 Jessica Woodman Student 48.00 $11.88 $-$570.24 $570.24 Samantha Southern Student 48.00 $15.02 $-$720.96 $720.96 Bonnie Carter Laboratory Supervisor 10.00 $39.17 $-$391.70 $391.70 Jeanine McCloskey EH Supervisor 15.25 $46.56 $-$710.04 $710.04 Richard Peresky Senior Sanitarian 39.25 $42.23 $-$1,657.53 $1,657.53 Christen Hayes Sanitarian 34.25 $36.48 $-$1,249.44 $1,249.44 Paige Peterson Student 34.00 $15.92 $-$541.28 $541.28 Alex Hines Student 34.00 $15.92 $-$541.28 $541.28 Neel Naik Student 46.00 $15.92 $-$732.32 $732.32 Chiara Nava Student 32.00 $15.92 $-$509.44 $509.44 Valance Washington Student 35.00 $15.92 $-$557.20 $557.20 Amy Plevinski Senior Saniarian 4.00 $42.23 $-$168.92 $168.92 0 $-$-$-$- 0 $-$-$-$- Totals 675.75 $-$17,413.23 $17,413.23 Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Pamela Lafoy-Wolff Medical Technologist 40%$-$1,068.86 $1,068.86 Aimee Martek Medical Technologist 40%$-$974.59 $974.59 Jolly Shah Medical Technologist 40%$-$1,353.60 $1,353.60 Alison Bartholomew Student 5%$-$28.51 $28.51 Jessica Woodman Student 5%$-$28.51 $28.51 Samantha Southern Student 5%$-$36.05 $36.05 Bonnie Carter Laboratory Supervisor 40%$-$156.68 $156.68 Jeanine McCloskey EH Supervisor 5%$-$35.50 $35.50 Richard Peresky Senior Sanitarian 40%$-$663.01 $663.01 Christen Hayes Sanitarian 40%$-$499.78 $499.78 Paige Peterson Student 5%$-$27.06 $27.06 Alex Hines Student 5%$-$27.06 $27.06 Neel Naik Student 5%$-$36.62 $36.62 Chiara Nava Student 5%$-$25.47 $25.47 Valance Washington Student 5%$-$27.86 $27.86 Amy Plevinski Senior Sanitarian 40%$-$67.57 $67.57 0 $-$-$- 0 $-$-$- Total Fringes $-$5,056.73 $5,056.73 EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division DUE DATE January 31, 2022 Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:Oct Dec 2021 Date Submitted:January 28, 2022 Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $74.06 $31,131.17 $64,746.55 $33,615.38 $74.06 $74.06 $-$(74.06) Fringes $29.62 $9,116.71 $14,598.62 $5,481.91 $29.62 $29.62 $-$(29.62) SALARY & FRINGE SUBTOTAL $103.68 $40,247.88 $79,345.17 $39,097.29 $103.68 $103.68 $-$(103.68) CONTRACTUAL SERVICES: registration for conferences $-$525.00 $525.00 $-$-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $525.00 $-$-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$86,136.52 $113,229.35 $27,092.83 $13,385.62 $7,000.00 $(6,385.62) Environmental Master Mix $9,318.70 $-$-$-$- 50 ml PCV basins $92.15 $92.15 $-$(92.15)$-$-$- 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $9,410.85 $86,228.67 $113,229.35 $27,000.68 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$-$- Homogenizer $-$7,265.55 $7,265.55 $-$-$-$-$- high sample volume pippettor $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $14,265.55 $3,590.91 $-$-$-$- Supplies, Materials and Equipment Subtotal $9,410.85 $96,903.31 $127,494.90 $30,591.59 $-$13,385.62 $7,000.00 $(6,385.62) TRAVEL:Miles 277.20 Rate 0.560 Mileage $155.23 $3,002.64 $5,619.65 $2,617.01 $-$-$-$- Lodging:$-$456.27 $456.27 $-$-$-$-$- Meals:$-$570.40 $570.40 $-$-$-$-$- Other:$-$456.60 $456.60 $-$-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$155.23 $4,525.91 $7,142.92 $2,617.01 $-$-$-$- PROJECT SUBTOTAL Grant Amount 13.820%$214,507.99 $72,305.89 Local Match $7,000.00 Project Total Percentage Split from CMI indirect rate 75.00%for CMI grant 25.00% INDIRECT COSTS $14.33 $4,377.13 $9,381.86 $5,004.73 $12.74 $12.74 $-$(12.74) GRAND TOTAL $9,684.09 $146,579.23 $223,889.85 $77,310.62 $116.42 $13,502.04 $7,000.00 $(6,502.04) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Christen Hayes Sanatarian 2.00 $37.03 $-$74.06 $74.06 Richard Peresky Senior Sanitarian $-$-$-$- 0 $-$-$-$- Totals 2.00 $-$74.06 $74.06 Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr Christen Hayes Sanatarian 40%$-$29.62 $29.62 Richard Peresky Senior Sanitarian $-$-$- 0 $-$-$- Total Fringes $-$29.62 $29.62 EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division DUE DATE April 2022 Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:Jan March 2022 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$31,131.17 $64,746.55 $33,615.38 $-$-$-$- Fringes $-$9,116.71 $14,598.62 $5,481.91 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$40,247.88 $79,345.17 $39,097.29 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $525.00 $-$-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $525.00 $-$-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$86,136.52 $113,229.35 $27,092.83 $13,385.62 $7,000.00 $(6,385.62) 0 $-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$86,136.52 $113,229.35 $27,092.83 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$-$- Homogenizer $-$7,265.55 $7,265.55 $-$-$-$-$- high sample volume pippettor $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $14,265.55 $3,590.91 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$96,811.16 $127,494.90 $30,683.74 $-$13,385.62 $7,000.00 $(6,385.62) TRAVEL:Miles Rate 0.000 Mileage $-$3,002.64 $5,619.65 $2,617.01 $-$-$-$- Lodging:$-$456.27 $456.27 $-$-$-$-$- Meals:$-$570.40 $570.40 $-$-$-$-$- Other:$-$456.60 $456.60 $-$-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$4,525.91 $7,142.92 $2,617.01 $-$-$-$- PROJECT SUBTOTAL Grant Amount 13.820%$214,507.99 $72,398.04 Local Match $7,000.00 EQP-5847 (5/04) Project Total Percentage Split from CMI indirect rate 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$4,377.13 $9,381.86 $5,004.73 $-$-$-$- GRAND TOTAL $-$146,487.08 $223,889.85 $77,402.77 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 40%$-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION Amendment 6 GRANTEE'S NAME: Oakland County Health Division PROJECT NAME: qPCR methods for Oakland County beaches EFFECTIVE DATE OF REVISION: TRACKING CODE NUMBER:2018-7216 DATE SUBMITTED:4/1/2023 Budget Categories Project Budget Proposed Revised Project Approved Proposed Revised Local Change Grant Funds Local Match Change Match Funds TOTAL Staffing $64,746.55 $20,000.00 $84,746.55 $-$-$-$84,746.55 Fringes $14,598.62 $5,000.00 $19,598.62 $-$-$-$19,598.62 SUBTOTAL: SALARY & FRINGE $79,345.17 $25,000.00 $104,345.17 $-$-$-$104,345.17 CONTRACTUAL COST registration for conferences $525.00 $500.00 $1,025.00 $-$-$-$1,025.00 0 $-$-$-$-$-$-$- Contractual Subtotal $525.00 $500.00 $1,025.00 $-$-$-$1,025.00 SUPPLIES and MATERIALS qPCR supplies $113,229.35 $27,045.00 $140,274.35 $7,000.00 $-$7,000.00 $147,274.35 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- Supplies and Materials Subtotal $113,229.35 $27,045.00 $140,274.35 $7,000.00 $-$7,000.00 $147,274.35 EQIUPMENT(any item over $1000) Equipment $7,000.00 $1,500.00 $8,500.00 $-$-$-$8,500.00 Automated Pippetor $-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$- Homogenizer $7,265.55 $-$7,265.55 $-$-$-$7,265.55 high sample volume pippettor $-$-$-$-$-$-$- EQUIPMENT Subtotal $14,265.55 $1,500.00 $15,765.55 $-$-$-$15,765.55 Supplies, Materials & Equipment Subtotal $127,494.90 $28,545.00 $156,039.90 $7,000.00 $-$7,000.00 $163,039.90 TRAVEL MILEAGE $5,619.65 $3,500.00 $9,119.65 $-$-$-$9,119.65 LODGING/NIGHTS/RATE $456.27 $-$456.27 $-$-$-$456.27 MEALS $570.40 $-$570.40 $-$-$-$570.40 OTHER (itemize) Airfare $456.60 $-$456.60 $-$-$-$456.60 parking $40.00 $-$40.00 $-$-$-$40.00 Travel Subtotal $7,142.92 $3,500.00 $10,642.92 $-$-$-$10,642.92 Project Subtotal $214,507.99 $57,545.00 $272,052.99 $7,000.00 $-$7,000.00 $279,052.99 INDIRECT (not to exceed 20% Staffing and Fringe Benefits)13.8200% Indirect Costs $9,381.86 $3,455.00 $12,836.86 $-$-$-$12,836.86 TOTAL GRANT AND MATCH BUDGET $223,889.85 $61,000.00 $284,889.85 $7,000.00 $-$7,000.00 $291,889.85 EQP-3592b (11/02) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division DUE DATE July 2022 Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:April June 2022 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$31,131.17 $64,746.55 $33,615.38 $-$-$-$- Fringes $-$9,116.71 $14,598.62 $5,481.91 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$40,247.88 $79,345.17 $39,097.29 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $525.00 $-$-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $525.00 $-$-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$86,136.52 $113,229.35 $27,092.83 $13,385.62 $7,000.00 $(6,385.62) 0 $-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$86,136.52 $113,229.35 $27,092.83 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$-$- Homogenizer $-$7,265.55 $7,265.55 $-$-$-$-$- high sample volume pippettor $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $14,265.55 $3,590.91 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$96,811.16 $127,494.90 $30,683.74 $-$13,385.62 $7,000.00 $(6,385.62) EQP-5847 (5/04) TRAVEL:Miles Rate 0.000 Mileage $-$3,002.64 $5,619.65 $2,617.01 $-$-$-$- Lodging:$-$456.27 $456.27 $-$-$-$-$- Meals:$-$570.40 $570.40 $-$-$-$-$- Other:$-$456.60 $456.60 $-$-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$4,525.91 $7,142.92 $2,617.01 $-$-$-$- PROJECT SUBTOTAL Grant Amount 13.820%$214,507.99 $72,398.04 Local Match $7,000.00 Project Total Percentage Split from CMI indirect rate 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$4,377.13 $9,381.86 $5,004.73 $-$-$-$- GRAND TOTAL $-$146,487.08 $223,889.85 $77,402.77 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 40%$-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division DUE DATE EARLY REPORTING Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:July Sept 2022 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$31,131.17 $64,746.55 $33,615.38 $-$-$-$- Fringes $-$9,116.71 $14,598.62 $5,481.91 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$40,247.88 $79,345.17 $39,097.29 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $525.00 $-$-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $525.00 $-$-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$86,136.52 $113,229.35 $27,092.83 $13,385.62 $7,000.00 $(6,385.62) 0 $-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$86,136.52 $113,229.35 $27,092.83 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$-$- Homogenizer $-$7,265.55 $7,265.55 $-$-$-$-$- high sample volume pippettor $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $14,265.55 $3,590.91 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$96,811.16 $127,494.90 $30,683.74 $-$13,385.62 $7,000.00 $(6,385.62) EQP-5847 (5/04) TRAVEL:Miles Rate 0.000 Mileage $-$3,002.64 $5,619.65 $2,617.01 $-$-$-$- Lodging:$-$456.27 $456.27 $-$-$-$-$- Meals:$-$570.40 $570.40 $-$-$-$-$- Other:$-$456.60 $456.60 $-$-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$4,525.91 $7,142.92 $2,617.01 $-$-$-$- PROJECT SUBTOTAL Grant Amount 13.820%$214,507.99 $72,398.04 Local Match $7,000.00 Project Total Percentage Split from CMI indirect rate 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$4,377.13 $9,381.86 $5,004.73 $-$-$-$- GRAND TOTAL $-$146,487.08 $223,889.85 $77,402.77 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 40%$-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division DUE DATE Jan 2023 Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:Oct Dec 2022 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$31,131.17 $64,746.55 $33,615.38 $-$-$-$- Fringes $-$9,116.71 $14,598.62 $5,481.91 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$40,247.88 $79,345.17 $39,097.29 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $525.00 $-$-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $525.00 $-$-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$86,136.52 $113,229.35 $27,092.83 $13,385.62 $7,000.00 $(6,385.62) 0 $-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$86,136.52 $113,229.35 $27,092.83 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$-$- Homogenizer $-$7,265.55 $7,265.55 $-$-$-$-$- high sample volume pippettor $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $14,265.55 $3,590.91 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$96,811.16 $127,494.90 $30,683.74 $-$13,385.62 $7,000.00 $(6,385.62) EQP-5847 (5/04) TRAVEL:Miles Rate 0.000 Mileage $-$3,002.64 $5,619.65 $2,617.01 $-$-$-$- Lodging:$-$456.27 $456.27 $-$-$-$-$- Meals:$-$570.40 $570.40 $-$-$-$-$- Other:$-$456.60 $456.60 $-$-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$4,525.91 $7,142.92 $2,617.01 $-$-$-$- PROJECT SUBTOTAL Grant Amount 13.820%$214,507.99 $72,398.04 Local Match $7,000.00 Project Total Percentage Split from CMI indirect rate 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$4,377.13 $9,381.86 $5,004.73 $-$-$-$- GRAND TOTAL $-$146,487.08 $223,889.85 $77,402.77 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 40%$-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division DUE DATE April 2023 Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:Jan March 2023 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$31,131.17 $64,746.55 $33,615.38 $-$-$-$- Fringes $-$9,116.71 $14,598.62 $5,481.91 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$40,247.88 $79,345.17 $39,097.29 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $525.00 $-$-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $525.00 $-$-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$86,136.52 $113,229.35 $27,092.83 $13,385.62 $7,000.00 $(6,385.62) 0 $-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$86,136.52 $113,229.35 $27,092.83 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$-$- Homogenizer $-$7,265.55 $7,265.55 $-$-$-$-$- high sample volume pippettor $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $14,265.55 $3,590.91 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$96,811.16 $127,494.90 $30,683.74 $-$13,385.62 $7,000.00 $(6,385.62) EQP-5847 (5/04) TRAVEL:Miles Rate 0.000 Mileage $-$3,002.64 $5,619.65 $2,617.01 $-$-$-$- Lodging:$-$456.27 $456.27 $-$-$-$-$- Meals:$-$570.40 $570.40 $-$-$-$-$- Other:$-$456.60 $456.60 $-$-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$4,525.91 $7,142.92 $2,617.01 $-$-$-$- PROJECT SUBTOTAL Grant Amount 13.820%$214,507.99 $72,398.04 Local Match $7,000.00 Project Total Percentage Split from CMI indirect rate 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$4,377.13 $9,381.86 $5,004.73 $-$-$-$- GRAND TOTAL $-$146,487.08 $223,889.85 $77,402.77 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 40%$-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION Amendment 6 GRANTEE'S NAME: Oakland County Health Division PROJECT NAME: qPCR methods for Oakland County beaches EFFECTIVE DATE OF REVISION: TRACKING CODE NUMBER:2018-7216 DATE SUBMITTED:4/1/2023 Budget Categories Project Budget Proposed Revised Project Approved Proposed Revised Local Change Grant Funds Local Match Change Match Funds TOTAL Staffing $84,746.55 $20,000.00 $104,746.55 $-$-$-$104,746.55 Fringes $19,598.62 $5,000.00 $24,598.62 $-$-$-$24,598.62 SUBTOTAL: SALARY & FRINGE $104,345.17 $25,000.00 $129,345.17 $-$-$-$129,345.17 CONTRACTUAL COST registration for conferences $1,025.00 $500.00 $1,525.00 $-$-$-$1,525.00 0 $-$-$-$-$-$-$- Contractual Subtotal $1,025.00 $500.00 $1,525.00 $-$-$-$1,525.00 SUPPLIES and MATERIALS qPCR supplies $140,274.35 $21,045.00 $161,319.35 $7,000.00 $-$7,000.00 $168,319.35 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- Supplies and Materials Subtotal $140,274.35 $21,045.00 $161,319.35 $7,000.00 $-$7,000.00 $168,319.35 EQIUPMENT(any item over $1000) Equipment $8,500.00 $1,500.00 $10,000.00 $-$-$-$10,000.00 Automated Pippetor $-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$- Homogenizer $7,265.55 $-$7,265.55 $-$-$-$7,265.55 high sample volume pippettor $-$-$-$-$-$-$- EQUIPMENT Subtotal $15,765.55 $1,500.00 $17,265.55 $-$-$-$17,265.55 Supplies, Materials & Equipment Subtotal $156,039.90 $22,545.00 $178,584.90 $7,000.00 $-$7,000.00 $185,584.90 TRAVEL MILEAGE $9,119.65 $3,500.00 $12,619.65 $-$-$-$12,619.65 LODGING/NIGHTS/RATE $456.27 $2,000.00 $2,456.27 $-$-$-$2,456.27 MEALS $570.40 $1,000.00 $1,570.40 $-$-$-$1,570.40 OTHER (itemize) Airfare $456.60 $2,000.00 $2,456.60 $-$-$-$2,456.60 parking $40.00 $-$40.00 $-$-$-$40.00 Travel Subtotal $10,642.92 $8,500.00 $19,142.92 $-$-$-$19,142.92 Project Subtotal $272,052.99 $56,545.00 $328,597.99 $7,000.00 $-$7,000.00 $335,597.99 INDIRECT (not to exceed 20% Staffing and Fringe Benefits)13.8200% Indirect Costs $12,836.86 $3,455.00 $16,291.86 $-$-$-$16,291.86 TOTAL GRANT AND MATCH BUDGET $284,889.85 $60,000.00 $344,889.85 $7,000.00 $-$7,000.00 $351,889.85 EQP-3592b (11/02) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division DUE DATE July 2023 Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:April June 2023 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$31,131.17 $64,746.55 $33,615.38 $-$-$-$- Fringes $-$9,116.71 $14,598.62 $5,481.91 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$40,247.88 $79,345.17 $39,097.29 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $525.00 $-$-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $525.00 $-$-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$86,136.52 $113,229.35 $27,092.83 $13,385.62 $7,000.00 $(6,385.62) 0 $-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$86,136.52 $113,229.35 $27,092.83 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$-$- Homogenizer $-$7,265.55 $7,265.55 $-$-$-$-$- high sample volume pippettor $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $14,265.55 $3,590.91 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$96,811.16 $127,494.90 $30,683.74 $-$13,385.62 $7,000.00 $(6,385.62) EQP-5847 (5/04) TRAVEL:Miles Rate 0.000 Mileage $-$3,002.64 $5,619.65 $2,617.01 $-$-$-$- Lodging:$-$456.27 $456.27 $-$-$-$-$- Meals:$-$570.40 $570.40 $-$-$-$-$- Other:$-$456.60 $456.60 $-$-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$4,525.91 $7,142.92 $2,617.01 $-$-$-$- PROJECT SUBTOTAL Grant Amount 13.820%$214,507.99 $72,398.04 Local Match $7,000.00 Project Total Percentage Split from CMI indirect rate 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$4,377.13 $9,381.86 $5,004.73 $-$-$-$- GRAND TOTAL $-$146,487.08 $223,889.85 $77,402.77 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 40%$-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division DUE DATE Early Reporting Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:July Sept 2023 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$31,131.17 $64,746.55 $33,615.38 $-$-$-$- Fringes $-$9,116.71 $14,598.62 $5,481.91 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$40,247.88 $79,345.17 $39,097.29 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $525.00 $-$-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $525.00 $-$-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$86,136.52 $113,229.35 $27,092.83 $13,385.62 $7,000.00 $(6,385.62) 0 $-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$86,136.52 $113,229.35 $27,092.83 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$-$- Homogenizer $-$7,265.55 $7,265.55 $-$-$-$-$- high sample volume pippettor $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $14,265.55 $3,590.91 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$96,811.16 $127,494.90 $30,683.74 $-$13,385.62 $7,000.00 $(6,385.62) EQP-5847 (5/04) TRAVEL:Miles Rate 0.000 Mileage $-$3,002.64 $5,619.65 $2,617.01 $-$-$-$- Lodging:$-$456.27 $456.27 $-$-$-$-$- Meals:$-$570.40 $570.40 $-$-$-$-$- Other:$-$456.60 $456.60 $-$-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$4,525.91 $7,142.92 $2,617.01 $-$-$-$- PROJECT SUBTOTAL Grant Amount 13.820%$214,507.99 $72,398.04 Local Match $7,000.00 Project Total Percentage Split from CMI indirect rate 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$4,377.13 $9,381.86 $5,004.73 $-$-$-$- GRAND TOTAL $-$146,487.08 $223,889.85 $77,402.77 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 40%$-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04) EGLE WATER RESOURCES DIVISION FINANCIAL STATUS REPORT (Authorized by 1994 P.A. 451) Grantee Organization Name:Oakland County Health Division DUE DATE January 2024 Project Name:qPCR methods for Oakland County beaches DEQ Tracking Code:2018-7216 Period Covered:Oct Dec 2023 Date Submitted: Column 1 BUDGET CATEGORIES Column 2 Grant Funds Expended This Quarter Column 3 Grant Funds Incurred to Date Column 4 Grant Funds in Project Contract Column 5 Grant Funds Balance to Date Column 6 Local Match Earned This Quarter Column 7 Local Match Earned to Date Column 8 Local Match in Project Contract Column 9 Local Match Balance Due Staffing $-$31,131.17 $64,746.55 $33,615.38 $-$-$-$- Fringes $-$9,116.71 $14,598.62 $5,481.91 $-$-$-$- SALARY & FRINGE SUBTOTAL $-$40,247.88 $79,345.17 $39,097.29 $-$-$-$- CONTRACTUAL SERVICES: registration for conferences $-$525.00 $525.00 $-$-$-$-$- 0 $-$-$-$-$-$-$-$- CONTRACTUAL SERVICES SUBTOTAL $-$525.00 $525.00 $-$-$-$-$- Supplies, Material and Equipment Supplies, Materials (Itemize) qPCR supplies $-$86,136.52 $113,229.35 $27,092.83 $13,385.62 $7,000.00 $(6,385.62) 0 $-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- 0 $-$-$-$-$-$-$- SUPPLIES AND MATERIALS SUBTOTAL $-$86,136.52 $113,229.35 $27,092.83 $-$13,385.62 $7,000.00 $(6,385.62) EQUIPMENT (any item over $1,000) PCR Hood $-$3,409.09 $7,000.00 $3,590.91 $-$-$- Automated Pippetor $-$-$-$-$-$-$-$- Multi-channel Pippetor $-$-$-$-$-$-$-$- Homogenizer $-$7,265.55 $7,265.55 $-$-$-$-$- high sample volume pippettor $-$-$-$-$-$-$-$- EQUIPMENT SUBTOTAL $-$10,674.64 $14,265.55 $3,590.91 $-$-$-$- Supplies, Materials and Equipment Subtotal $-$96,811.16 $127,494.90 $30,683.74 $-$13,385.62 $7,000.00 $(6,385.62) EQP-5847 (5/04) TRAVEL:Miles Rate 0.000 Mileage $-$3,002.64 $5,619.65 $2,617.01 $-$-$-$- Lodging:$-$456.27 $456.27 $-$-$-$-$- Meals:$-$570.40 $570.40 $-$-$-$-$- Other:$-$456.60 $456.60 $-$-$-$-$- parking $-$40.00 $40.00 $-$-$-$-$- Subtotal:$-$4,525.91 $7,142.92 $2,617.01 $-$-$-$- PROJECT SUBTOTAL Grant Amount 13.820%$214,507.99 $72,398.04 Local Match $7,000.00 Project Total Percentage Split from CMI indirect rate 75.00%for CMI grant 25.00% EQP-5847 (5/04) INDIRECT COSTS $-$4,377.13 $9,381.86 $5,004.73 $-$-$-$- GRAND TOTAL $-$146,487.08 $223,889.85 $77,402.77 $-$13,385.62 $7,000.00 $(6,385.62) By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant. QUARTERLY STAFF COSTS (SALARY PLUS FRINGE) Name/Position Title Hours worked for the Qtr Rate of Pay Grant Total Match Total Total Wages for the Qtr Jenna DeWitte, Sanitarian $-$-$-$- Richard Peresky $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- 0 $-$-$-$- Totals 0.00 $-$-$- Name/Position Title Fringe Rate (Max. 40%)Grant Total Match Total Total Fringes for the Qtr 0 40%$-$-$- Richard Peresky $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- 0 $-$-$- EQP-5847 (5/04) 0 $-$-$- Total Fringes $-$-$- EQP-5847 (5/04)