Automobile Spare Parts List In Excel 100%

One rainy Tuesday, his niece, Priya, a business student, walked in. "Kaka," she said, holding a laptop. "Your garage is leaking money. Let me show you something."

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

His profits are up 22%. His stress is down by half. automobile spare parts list in excel

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

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. One rainy Tuesday, his niece, Priya, a business

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

Priya built a spreadsheet with seven critical columns. She explained each one as Rajiv watched over her shoulder. Let me show you something

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.