Automobile Spare Parts List In Excel (2024)

She counted the pads on the shelf. "Six sets." She typed 6 . Then she added a column for Minimum Stock Level . She set it to 4 . "If you hit 4," she explained, "Excel can turn the cell red. You'll know to reorder before you run out."

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

Priya built a spreadsheet with seven critical columns. She explained each one as Rajiv watched over her shoulder. She counted the pads on the shelf

If you were to build one today, your headers should look like this: She set it to 4

His profits are up 22%. His stress is down by half.

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