BoxPower — Master Cash Flow Dashboard

Cost(period) = sum of "Actual Cost" across the Procurement (Goods), Rentals & Travel (Logistics), and Subs (Services) tabs, bucketed by Bill Date. Includes forecast rows. Rows with no Bill Date can't be placed in any period, so they're excluded here and reported separately as "undated" (see Exceptions above).

Gross Profit(period) = ( Cost(period) ÷ Total Cost ) × ( Contract − Total Cost ). Total Cost is that same 3-tab cost total, summed across every period (incl. forecasts) -- i.e. the job's estimated cost at completion. This allocates the job's estimated profit in proportion to how much of its total cost has landed in each period: the standard percentage-of-completion ("cost-to-cost") method construction/EPC accounting uses to recognize profit on jobs still in progress.

Revenue(period) = Cost(period) + Gross Profit(period). Revenue is derived this way, not read from the CashFlow Summary tab's REVENUE row.

Contract comes from each workbook's Detailed Summary tab (Actual/Current Contract block, including change orders).