Automobile Spare Parts List In: Excel

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.

| 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 | automobile spare parts list in excel

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."

Finally: Supplier: Ganesh Auto Parts, Ph: 98765xxxxx . And a date: 15-May-2026 . She typed: BRK-i20-F for "Brake pad, i20, Front

Priya built a spreadsheet with seven critical columns. She explained each one as Rajiv watched over her shoulder.

Rajiv pulled an old box from the shelf. Printed on it was 58101-BYA11 . Priya entered it. "This is the manufacturer's code. Even if you forget the name, this number finds the part anywhere." He checks the list

If you were to build one today, your headers should look like this:

"Where do you keep i20 brake pads?" Rajiv pointed: "Top shelf, third row, blue bin." Priya typed: A-12 / Blue Bin . No more rummaging.