Project fees, phase budgets, utilization, and billing milestones
Industry
Architecture & Engineering
Company size
Fictional mid-size design firm with about 90 architects, engineers, and designers across five disciplines and four studios.
Project portfolio
120 fictional projects spanning commercial, residential, civic, institutional, and industrial work, carrying roughly $209M in total contract value.
Packaged scale
About 66,000 rows across 10 Standard-tier tables, including 58,000 time entries, 600 project-phases, 2,400 milestone invoices, 2,000 change orders, and 2,160 monthly utilization snapshots.
Annual fee volume
Billed labor runs about $27M a year, while milestone invoices come to roughly $52M a year.
Average utilization
Staff run near 72 percent average monthly utilization across the snapshot window, a little under the firm's blended target.
Disciplines
Architecture, Structural, MEP, Civil, and Interiors, organized into Harbor, Riverside, Uptown, and Foundry studios.
Brindlemark Architects is a fictional mid-size architecture and engineering firm used for synthetic BI analysis. The company story is built around a portfolio of design projects, the delivery phases each project moves through, the architects and engineers who staff them, and the day-to-day flow of time entries, change orders, fees, and billing milestones. Everything here is invented for analytics practice. No real firm, owner, client, staff member, or project is represented.
These are the operating questions this kit is optimized to answer first.
Billed labor rises through spring and eases around midsummer and the holidays, instead of following a flat line.
Phase fees sum to the contracted fee sitting inside the window, so a project fee breakdown adds up.
Institutional and civic projects carry the larger contracts while residential and industrial work balances the book.
Owner scope changes add fee, value engineering reduces it, and approval rates differ sharply by reason.
Clients pay at different speeds, so invoices age into real buckets and a small disputed tail is written off.