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.
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.
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.
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.
| Role | Source column | Who they are here | What 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).
| Submitter | RFIs | Answered | Open | Response rate | Document update rate |
|---|---|---|---|---|---|
| DAVID BOLAND, INC | 71 | 71 | 0 | 100.00% | 21.13% |
| Carbon Recall Chattanooga | 11 | 11 | 0 | 100.00% | 18.18% |
| Willdan | 8 | 7 | 1 | 87.50% | 12.50% |
| Richard Group LCC | 8 | 5 | 3 | 62.50% | 12.50% |
| Dobco, Inc. | 8 | 4 | 4 | 50.00% | 0.00% |
| Schweitzer Engineering Laboratories, Inc. | 1 | 1 | 0 | 100.00% | 0.00% |
| Total | 107 | 99 | 8 | 92.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.
| RFI | Submitter | Tasked party |
|---|---|---|
| RFI-086 | Willdan | CT |
| RFI-092 | Dobco, Inc. | CT |
| RFI-093 | Dobco, Inc. | CT |
| RFI-095 | Dobco, Inc. | CT |
| RFI-096 | Dobco, Inc. | CT |
| RFI-100 | Richard Group LCC | CT |
| RFI-106 | Richard Group LCC | CT |
| RFI-107 | Richard Group LCC | CT |
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.