Automobile Spare Parts List In Excel Apr 2026

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

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

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

Rajiv no longer keeps bolts in biscuit tins. He keeps them in bins labelled exactly as in Excel. And every evening at 7 PM, he spends five minutes updating the sheet. 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."

Bolts were in biscuit tins. Brake pads sat next to spark plugs. When a customer needed a specific water pump for a 2018 Hyundai i20, Rajiv would spend twenty minutes rummaging through shelves, mumbling to himself. Often, he'd order a part he already had, or worse, promise a repair he couldn't complete.

His profits are up 22%. His stress is down by half. She entered: Buy: ₹1,200 | Sell: ₹1,800

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

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.

Priya built a spreadsheet with seven critical columns. She explained each one as Rajiv watched over her shoulder. You actually made ₹600, not the ₹300 you thought

Rajiv was skeptical. "This looks like homework. How does this help me?"

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