I would add separate field for Retired and Surplus, that is set manually, capturing a date and name of the person doing the action. This field could be tied to make the status reflect these added status settings.
Is this kind of what you are trying to accomplish?
I added a radio button field, and modified the Status calculation, just as a quick idea. This does flow thru to the other calculations, so this is only a start.