Automobile Spare Parts List In Excel Today
| 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 |
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.
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. automobile spare parts list in excel
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." | Part ID | Part Name | Vehicle
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."
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." Bolts were in biscuit tins
She opened Microsoft Excel. "This," she said, "is your new brain."
Download the Philippines’ biggest travel marketplace to your phone to manage your entire trip in one place
Scan this QR code with your phone camera and press the link that appears to add the Philippines’ biggest travel marketplace into your pocket. Enter your phone number or email address to receive an SMS or email with the download link.
