An equipment desk reports the share of eligible loans due in a month that came back on time. If 20 are eligible and 18 were on time, the result is 90%. Write the rules needed to rebuild both counts.
Define the time window and the success test
Name the date field and time zone that determine the reporting month. Say which return timestamp is compared with the deadline. Specify how cancellations and due-date extensions affect eligibility and on-time status.

Illustrated calculation for a fictional equipment desk.
Compare decisions one record at a time
Give a colleague a small sample with an on-time return, a late return, a cancellation and an extension. Ask them to mark eligibility and outcome before they compute the percentage. Record the data source, owner and effective date with the agreed definition.

Illustrated rule check before calculating the final rate.



