Example 1 — Order of computation
Show the steps and the answer
Draw an arrow from each variable to every formula that uses it: Price → Revenue, Units → Revenue, Units → Cost, Revenue → Profit, Cost → Profit.
means is computed directly from .
Find the nodes with no incoming arrows: Price and Units.
They depend on nothing in the sheet, so they must be known before anything else.
Compute Revenue and Cost next: every arrow into them starts at Price or Units.
A variable is ready as soon as all of its incoming arrows start at known values.
Compute Profit last, from Revenue and Cost.
It is the only node with no outgoing arrows, the final output.
Test with numbers: Price 5 and Units 30 give Revenue , Cost , Profit .
Following the order, each value is available exactly when it is needed.
Answer: Compute Price, Units → Revenue, Cost → Profit
Takeaway: Start from the nodes with no incoming arrows, and compute a node only when every arrow into it comes from a known value.