- Before
- Keeps every gate date in a workbook, and answers the reviewer by searching email for the page behind each one.
- Now
- Sees every request on one rail with each date tied to its page, clears gates with a reason code, and has the reviewer's answers ready before they are asked.
One funding year, through E-Rate compliance to a certified Form 471
Wednesday, March 10, 2027. Marlow Bay Unified School District, 62 schools and 48,000 students, is filing funding year 2027: 14 funding requests, $4,100,000 before discount, at an 80% discount. The Form 471 window closes March 24. Here is the morning, screen by screen, in the working solution.
- 016:20 AM
Fourteen requests, each on its own rail
Seven agentsOvernight the agents read 418 documents in 10 bid files and 1,214 vendor emails. Each funding request runs left to right through 12 gates, from Form 470 posted to 10-year retention, and every dot is a date taken from a document. Three requests are filed, four are ready, five need a person, one is in its 28-day wait and one breaks a rule.
Form 471 window closes Wednesday, March 24, in 14 days.
- 029:02 AM
The Wi-Fi rail turns amber at the evaluation gate
Renee Castillo · E-Rate CoordinatorWi-Fi for 62 schools, FRN 2799000104, $1,486,000 before discount. The Form 470 was certified February 4, so the allowable contract date is March 4. The evaluation memo is dated March 3, day 27. If the vendor had been chosen that day, the reviewer would deny both requests on this bid, $1,265,440 in discounts.
- 03One click
The agent reads the rest of the bid file
Rule agentBids were opened March 4 at 2:00 PM, day 28. The memo was created March 3 from a blank template, and its scores were entered March 4 between 3:05 and 4:31 PM. Three evaluators signed the matrix at 4:40 PM, the Board chose Norvale Networks on March 5, day 29, and the contract was signed March 8.
No vendor was selected and no contract signed before March 4; the March 3 header is the date the memo was created from the template. Confidence 0.96.
- 04Every date
The date opens the page it came from
Renee CastilloRenee clicks March 5 and page 6 of the special meeting minutes opens with the award highlighted: item 7.2, carried 5–0. Opening it is logged, and the copy is kept with this year's bid file for 10 years.
"Motion to award RFP 27-014, wireless network refresh, to Norvale Networks, contingent on E-Rate funding."
- 059:03 AM
Gate cleared, and the answer written before the reviewer asks
Renee CastilloRenee accepts with reason E1, dates explained by the record. The evaluation gate turns green and both Wi-Fi requests are ready to file. The explanation goes into the review packet with five citations, and a memo to file correcting the header date goes to Hannah Lowe to sign.
- 069:05 AM
A firewall bid where price was not the primary factor
Hannah Lowe · Director of PurchasingRFP 27-017 weighted price 30%, tied with technical capability. The Rule agent lays out three ways forward: withdraw and re-bid for 2028, file with an explanation and expect a denial, or re-post a Form 470 today, whose allowable date of April 7 falls after the window. Hannah chooses to withdraw with reason P1; because it changes funding, Gregory Tan co-signs, and the requests total falls to $3,914,000.
Re-scored at price 40%, Ostrand still ranks first, but the rule judges the published weights.
- 079:07 AM
Vendor offers made during bidding, found and cleared with evidence
Gift-rule agentThe agent read 1,214 vendor emails, 86 calendar entries and 19 expense reports from February 4 to March 8. Two summit passes at $1,195 each were offered to the CTO and declined in writing the same day; a $38-a-person lunch at a vendor demonstration was repaid at cost, $228. Hannah clears both with reasons G1 and G2. A $45 holiday basket shared by six people is within the rule.
Separation of duties: Marcus Webb received this offer, so he cannot clear it.
- 089:09 AM
The discount from aggregate meal counts, with an error caught
Discount agentThe nutrition export applied the community eligibility multiplier twice at Driftwood Elementary and Keel Ridge Middle School. Corrected, the district share falls from 62.7% to 61.8%, still in the 50–74% band and still an 80% discount for an urban district. Renee applies the correction with reason D1. No student record is read or stored.
- 09Before review
41 answers waiting for the PIA reviewer
Responder agentThe agent predicts what the reviewer will ask for 12 requests and the district, and drafts each answer with its exhibits. The first, for the Wi-Fi request, explains the March 3 memo date with five exhibits: bid tabulation, memo properties, evaluation matrix, minutes page 6 and the memo to file. Renee approves, edits or rejects each one; nothing is sent until a question arrives.
- 109:12 AM
Prepared by the coordinator, certified by the business office
Gregory Tan · Assistant Superintendent for BusinessRenee prepares Form 471 #271008765 with eight requests, $2,422,000 before discount and $1,885,856 E-Rate share. Gregory reads the five certifications, including internet safety, now certified on the Form 471, and files it. With the three requests filed in February, 11 of 13 are filed 14 days before the window closes, $3,028,256 in discounts.
The person who prepares cannot certify.