Spare Parts List In Excel | Automobile

She added: Brake Pad Set – Front Axle . Then a note: Fits i20 1.2L Petrol (2015–2020). "Details matter," she said. "A millimeter difference, and it won't fit."

She typed: BRK-i20-F for "Brake pad, i20, Front." "Every part needs a unique ID," she said. "No more confusion between Santro and i20 pads."

Now, when a customer walks in and asks, "Can you fix my car by Friday?" Rajiv doesn't run to the shelf. He opens Excel. He checks the list. He gives an answer in ten seconds. automobile spare parts list in excel

| Part ID | Part Name | Vehicle Model(s) | OEM Number | Category | Current Stock | Min Stock | Location | Buy Price | Sell Price | Supplier | Last Updated | |---------|-----------|------------------|------------|-----------|---------------|-----------|----------|-----------|------------|----------|--------------| | BRK-CRV-2019 | Brake Pad Set | Honda CR-V 2019+ | 45022-T7A-000 | Brakes | 8 | 4 | Shelf B2 | ₹2,200 | ₹3,500 | ABC Auto | 20-May-2026 | | FLT-303 | Oil Filter | Maruti Suzuki 800 | 16510M68K01 | Engine | 2 | 5 | Bin D4 | ₹180 | ₹350 | XYZ Parts | 18-May-2026 |

And it all started with a blank Excel grid, a curious niece, and a simple list of spare parts. "The best inventory system isn't the most expensive one," Rajiv now tells young mechanics. "It's the one you actually use. For me, that's Excel." She added: Brake Pad Set – Front Axle

She opened Microsoft Excel. "This," she said, "is your new brain."

She entered: Buy: ₹1,200 | Sell: ₹1,800 . "Now you know your profit per part," she said. "That brake job you did yesterday? You actually made ₹600, not the ₹300 you thought." "A millimeter difference, and it won't fit

Rajiv had run "City Auto Care" for twelve years. He could diagnose a faulty alternator by ear and rebuild a gearbox blindfolded. But his spare parts inventory was chaos.