Parts and status inventory

I want to create a spreadsheet to keep control of a machine's parts which some have the same part number but different serial numbers and they are constantly swapped. (one part is installed then repl...