Appliance Repair Tech Diagnostic Fee & Part Markup Calculator + 14pt Waiver | Excel PDF
Appliance Repair Tech Diagnostic Fee & Part Markup Calculator + 14pt Waiver | Excel PDF
By Snowfield * Author: Jordan Masopust, Indianapolis, IN
Instant Digital Download * Price: $15.00
Tiered OEM part markup calculator, $99 diagnostic trip fee crediting workbook, van stock warranty tracker, and 14pt appliance pull-out / water-line liability waiver pack for independent appliance repair technicians.
Stop under-marking wholesale control boards and sealed system parts, eliminate lost time on uncredited diagnostic calls, and protect your business before pulling a 400-lb refrigerator across hardwood or luxury vinyl flooring or shutting off a corroded copper water valve.
What is included in your download (.zip archive):
- 1-Appliance-Repair-Diagnostic-and-Part-Profit.xlsx: Dual-tab auto-calculating workbook for Microsoft Excel and Google Sheets (zero macros, zero merged cells).
- Tab 1 (1-Service-Call-and-Part-Markup): Tracks 12 residential and commercial repairs across refrigerators, washers, dryers, dishwashers, ranges, and Sub-Zero/induction units. Automates tiered OEM part markups (3.0x up to $30, 2.5x up to $75, 2.0x up to $150, 1.75x over $150), $99 diagnostic trip fee crediting toward approved repairs, core return credits ($25-$50), untaxed flat-rate labor, editable sales tax on retail parts (7.0% in cell N5), and net profit margin.
- Tab 2 (2-Van-OEM-Part-and-Warranty-Log): Tracks 12 high-turn truck stock parts (drain pumps, dryer elements, glow-bar igniters, shift actuators, water valves, thermal cut-offs, compressor relays, evaporator fans, door switches) with par reorder flags and 90-day distributor warranty expiration tracking (editable in M5/N5).
- 2-Appliance-Pullout-Waiver-and-Repair-Estimate.pdf: Exact 2-page high-contrast 14pt printable US Letter document.
- Page 1: Heavy Appliance Pull-Out Hardwood/Vinyl Floor Scratch Waiver, Corroded Saddle-Valve / Brittle Copper Water Line Leak Release, and Perishable Food Spoilage Exclusion.
- Page 2: 50% Repair vs Replace Rule Evaluation, Itemized Diagnostic Fee Credit Estimate, and 90-Day Parts & Workmanship Warranty Receipt.
- START-HERE-BUYER-GUIDE.txt: Quick-start onboarding guide, spreadsheet setup instructions, and commercial usage license.
Product Highlights:
- Universal Compatibility: Works cleanly in Microsoft Excel 2016+, Office 365, Google Sheets, LibreOffice Calc, and Apple Numbers.
- Print-Ready Typography: High-contrast 14pt layouts with safe margins (>= 28pt) for service clipboards.
- Complete Privacy & Ownership: 100% offline files with zero monthly subscription fees, zero macros, and zero cloud lock-in.
- Direct Author Support: Created by Jordan Masopust, Indianapolis, IN (jordan.masopust@gmail.com).