I manage a restaurant supply store that sells new and used. For most of what we do, RMS is perfect. However, the one continual problem is our used equipment and accounting for the costs of repairs and labor before something is in condition to sell.
Example:
If we buy a used refrigerator for $100 and replace a compressor ($250) and gaskets ($75). The cleaning crew puts 3 man-hours into it ($30 value/hr), and the service guy spends 2 hours ($60 value/hr). This makes our total cost $635.
Right now, our solution (albeit a clumsy one) is to go to the Notes field in the Special tab for the refrigerator and enter the following:
11/05/14 Purchased from Crowl Mechanical $100
11/10/14 Compressor Replaced (Supplier ABC inv# 123) $250 NEW COST: $350
11/10/14 Gaskets Replaced (Supplier XYZ inv# 456) $75 NEW COST: $425
11/10/14 Repair Labor (2 hr) $120 NEW COST: $545
11/12/14 Cleaning Labor (3 hr) $90 NEW COST: $635
With each entry, we change the cost on the General tab.
Aside from the simple possibility of human error, this process also leaves a lot of room for the possibility of deceit (a sales person could easily delete the line about the compressor and reduce cost by $250, which would increase commissions). It's a time consuming process and getting the 4 people who enter these things to use the same format is a problem as well.
Any ideas?
