Recently I met a client who runs a scrap yard. Has inventory in multiple locations. Client purchases scrap vehicles which no longer road worthy as they have been cancelled by the traffic department. Here is summarized business operation
a. Vehicles has a purchase value. Lets say X
b. Vehicle parts are sold individually or whole.
c. Parts can be consumed internally in garage (fixed to customer vehicles) or for client’s own vehicle.
d. Multiple locations (warehouses) for storing scrap.
Vehicles Rented (not scrapped vehicles)
a. Rented on hourly/daily basis
b. Rented with or without driver/operator
c. Depreciation for asset.
d. Sold off after life. Can be sold in full or in parts.
Scrap Valuation against market rate.
a. Daily scrap market gives price per ton etc.
b. Scrap inventory valuation to be updated
Client major pain points are
a. Does not have any track of current inventory.
b. Does not know if profit was made on a vehicle. Without proper tracking impossible to know which part was sold for what price. Assumes that parts are either being sold at any price by employee or maybe sold under the table (theft).
c. As current inventory is unknown hence market valuation cannot be updated to get asset value.
d. Vehicles have hundred of parts (cars, trucks, JCB etc.) difficult to know which part of which vehicle has been sold or available for sale.
e. No mechanism to track unsaleable parts. Vehicles are partial damaged goods hence some parts cannot be sold. Maybe possible by repairing/fixing them which is additional cost.
My idea is to create a new DocType to do the following
- use vehicle VIN & Chasis number for tracking.
- Input purchase cost of each vehicle.
- Create Items table and fill at time of purchase. This will track parts that are worthy of sales.
- Give each item/part a unique code (like a serial number). Maybe a combination of VIN number with Item Code.
- Give sales price per serial number. Probability of having 2 or more similar items in different wear & tear condition hence price cannot be standard.
- At sales time fetch item from vin number which will pull the item sale price set at time of purchase.
- Market scrap valuation is academic. Will only be possible if each item weight is added.
- Do material transfer to Job (repair in garage) and consume the item.
Rental part can be looked later as it is not the core business.
Looking forward to response from anyone who may have completed similar use case or has better idea on how to go about.
Thanks you for the input.