Formula Dump Tip
Hi, I wanted to share how I quickly learned a formula dump to remember estimate at completion and estimate to complete and an easy way to understand when to use one or the other with the given information.
· FIRST write down EAC four times
· Then write down ETC three times
· With smaller letters..spell out RATS and RAT
· Practice memorizing the order of formulas many times
· Practice writing it down more
· Then understand why we use one or the other
EACR AC+ETC Flawed estimate the “R” means Rebase line
EACA AC+ (BAC-EV) “Atypical” estimate at budgeted rate
EACT BAC/CPI “Typical” no variances in future
EACS AC+ ((BAC-EV)/ (CPI*SPI)) meet “Schedule” or deadline
ETCR EAC-AC “Recommended” when no other info is given
ETCA BAC-EV “Atypical” variances detected
ETCT (BAC-EV)/CPI “Typical” assuming no variances in future

