I watched the show once and thought that it should be fairly straightforward to calculate the expected value of the remaining boxes and know how much of a good deal they might be offering you at any time. So I did.

Average value of active boxes:

Tested with: