Report · Chapter 12

Coordination

The third Power BI page: who submits the RFIs, who is tasked to answer, and where the eight open RFIs sit.

Page: Origin, assignment, and outstanding workload 8 open, all with CT 8 October 2026
A collage of site photographs, drawings, and coordination notes.

Section 1The page

The page title is RFI Origin, Assignment & Outstanding Workload. The question on the header is who is generating RFIs, who is responsible for responding, and where the unresolved workload is concentrated. The counts are the unfiltered page.

Coordination dashboard with five KPI cards, submitter and tasked-party columns, open-RFI charts, a response-rate chart, a submitter table, and a discipline stack by tasked party.
Origin, assignment, and outstanding workload: 6 submitters, 10 tasked parties, 8 open RFIs.

Section 2Live report

The published report is rif_vis. The bar under the frame switches pages: executive, Drawing & Specification Change Analysis, COORDINATION & RESPONSIBILITY, and RFI Register.

Live rif_vis report. Open the report.

This chapter is dashboard 3. Use the arrows beside 3 of 4 to open COORDINATION & RESPONSIBILITY. Page 1 is the executive dashboard. Page 2 is Drawing & Specification Change Analysis. Page 4 is RFI Register.

A red circle around the report page control that reads 3 of 4, with a previous arrow and a next arrow.
The page control for COORDINATION & RESPONSIBILITY.

Section 3Two roles, one party list

The originating party is who asked. The responsible party is who must answer.

In the workbook those are the FROM and TASKED columns. In the star schema they are two keys on the same RFI, both pointing at dim_party: from_party_key for the submitter and tasked_party_key for the party tasked to respond.

On this register the two roles do not share a name. Six contractors submit the questions. Ten government or design parties are asked to answer them.

RoleSource columnWho they are hereWhat the register shows
Originating party FROM The organisation that submitted the RFI DAVID BOLAND, INC submitted 71 of 107. The 8 open RFIs came from Dobco, Inc., Richard Group LCC, and Willdan.
Responsible party TASKED The party assigned to review and respond AE was tasked with 66, and all 66 are answered. CT was tasked with 15, and all 8 open RFIs sit with CT.

Power BI keeps the roles apart. The active relationship is the originating party, so a normal chart of party_name counts submitters. The responsible-party charts turn on the inactive tasked_party_key relationship for that measure only. That is why this page can show both who generated the questions and who still owes the answer.

The received date is on every row. There is no answered date, so this page does not show days open or a response-time target.

Section 4Who submits

The cards read 6 originating parties, 10 responsible parties, 8 open RFIs, a 92.52% response rate, and 107 RFIs. DAVID BOLAND, INC submitted 71 of the 107, about 66%. All 71 are answered. The eight open RFIs were submitted by Dobco, Inc. (4), Richard Group LCC (3), and Willdan (1).

SubmitterRFIsAnsweredOpenResponse rateDocument update rate
DAVID BOLAND, INC71710100.00%21.13%
Carbon Recall Chattanooga11110100.00%18.18%
Willdan87187.50%12.50%
Richard Group LCC85362.50%12.50%
Dobco, Inc.84450.00%0.00%
Schweitzer Engineering Laboratories, Inc.110100.00%0.00%
Total10799892.52%17.76%

This table follows the submitter. A 50% response rate for Dobco, Inc. means four of its eight RFIs are still open. It does not mean Dobco, Inc. was tasked to answer them.

Section 5Who is tasked

AE is tasked with 66 of 107 RFIs, about 62%, and all 66 are answered. CT is tasked with 15. Seven of those are answered and eight are open, a response rate of 46.67%. Every other tasked party is at 100%: PM 9, JBMDL 8, AE/JBMDL 4, and one each for AE/JBMDL/PM, AE/PM, CT/PM, JBMDL/AE, and USACE DB.

The open-RFI bar for the tasked party is a single bar: CT, 8. The discipline stack shows what each tasked party was given. Electrical is 38 of AE’s 66, about 58%. All 15 of CT’s RFIs are Other. General is 6 of JBMDL’s 8. Other is 5 of PM’s 9.

Section 6The eight open RFIs

All eight open RFIs are tasked to CT, and all eight are discipline Other.

RFISubmitterTasked party
RFI-086WilldanCT
RFI-092Dobco, Inc.CT
RFI-093Dobco, Inc.CT
RFI-095Dobco, Inc.CT
RFI-096Dobco, Inc.CT
RFI-100Richard Group LCCCT
RFI-106Richard Group LCCCT
RFI-107Richard Group LCCCT

Section 7How to read it

Three different parties lead the three questions on the header. DAVID BOLAND, INC submitted the most RFIs, and none of them are open. AE holds the most assignments, and none of them are open. CT holds all eight open RFIs, at a response rate of 46.67%. Those eight were submitted by Dobco, Inc., Richard Group LCC, and Willdan.

This coordination page stops at assignment and the eight open RFIs. The next chapter is the register, where those eight rows can be filtered and read with the start of each question.