Here's one for the older accountants....way back in another life I was in retail and we used the "Retail Method of Inventory" whereby we tracked inventory at retail in order to estimate inventory and cost of sales on a perpetual basis. I have a client who could really use this system but my examples were discarded 30 years ago.
Back in the day we had a huge spiral bound book that we used to track activity (any old ARCO franchisees out there?). I developed a spreadsheet that replicated the manual system using a Commodore 64 and Multiplan (Damn that makes me feel old) and I would like to do the same for this client. Unfortunately, about 10 years ago I had to start forgetting old stuff in order to remember new stuff. This, apparently, is one of the things I have forgotten.
Does anyone have an example of this or remember how this was done. I know it's not a perfect system for tracking inventory or calculating cost of sales but it beats the hope and prayer system currently in use.