12-Attachment 11 REQ-0002500 QBS Chart - Task Cost Matrix.xlsx

The document is a Qualifications-Based Selection (QBS) Task Cost Matrix spreadsheet for the Great Lakes Water Authority (GLWA) related to the Southwest Water Treatment Plant Flocculation Improvements project in Michigan. The contract (0002500) outlines eight primary tasks including project kickoff meeting, project management, preliminary (30%) design, final design, bid and award, construction administration, resident project representation, and system operations & maintenance with training. The project involves replacing existing walking beam flocculators with vertical flocculators and requires comprehensive consulting services for project management, engineering, design, construction support, and training.

The cost matrix includes a provisional allowance of $400,000.00 established and controlled by GLWA, with detailed cost breakdown sections for each task that allow for tracking direct labor hours, indirect costs, overhead, other direct costs, subconsultant expenses, and contract markups. The spreadsheet provides a template for consultants to estimate and document project costs across various project phases, with specific columns for tracking labor hours, costs, and additional expenses. A notable supplemental requirement is the calculation of a composite rate for Resident Project Representation (RPR) that can be used for future billing purposes.