Spreadsheet: 879399d1726869821-mixed-up-data-mix-test
Sheet: Data2

account code/description | QTY | Parts | Labor | Selling Price | Cost |  | 2 |  | Store
4203 |  |  |  |  |  |  |  |  | 4203
25 - Tire Accessories
3003 - TPMS SENSOR | 11 | 479.94 | 133.95 | 613.89 | 105.3 |  |  |  |  | Select the Store in J2.  Click on Data, Refresh All.  Look at Sheet 1
3005 - TPMS REBUILD KIT | 30 | 149.7 | 0 | 149.7 | 0
96250 - RUBBER STEM | 38 | 323.09 | 211.93 | 535.02 | 0
25 - Tire Accessories | 79 | 952.73 | 345.88 | 1298.61 | 105.3
26 - Tire Labor
97012 - TIRE SERVICES PACKAGES | 32 | 0 | 0 | 0 | 0
99982 - TIRE LABOR | 220 | 0 | 1619.98 | 1619.98 | 0
99983 - NATIONAL TIRE LABOR | 43 | 306.37 | 189.49 | 495.86 | 0
26 - Tire Labor | 295 | 306.37 | 1809.47 | 2115.84 | 0
30 - Wheels Accessories
96830 - WHEEL TOOL | 1 | 0 | 0 | 0 | 24.35
30 - Wheels Accessories | 1 | 0 | 0 | 0 | 24.35
31 - Alignments
977 - ALIGNMENT SERVICES | 131 | 0 | 11085.66 | 11085.66 | 0
31 - Alignments | 131 | 0 | 11085.66 | 11085.66 | 0
32 - LOF Services
96054 - OIL FILTER | 123 | 996.11 | 0 | 996.11 | 403.76
96394 - OIL DRAIN PLUG | 3 | 33.09 | 0 | 33.09 | 16.85
96806 - FLUIDS AND OILS | 685.2 | 5273.91 | 0 | 5273.91 | 2464.07
97001 - LOF SERVICE PACKAGES | 123 | 672.37 | 177.72 | 850.09 | 0
97021 - LOF SERVICE [NAME] | 119 | 282.75 | 2755.88 | 3038.63 | 0
32 - LOF Services | 1053.2 | 7258.23 | 2933.6 | 10191.83 | 2884.68
33 - Tune-Up
96046 - AIR FILTER | 21 | 773.92 | 70.68 | 844.6 | 256.33
96095 - COIL (IGNITION) | 14 | 1366.6 | 0 | 1366.6 | 521.45
96170 - PCV VALVE | 3 | 90.97 | 0 | 90.97 | 20.67
96182 - SPARK PLUG | 41 | 1246.97 | 0 | 1246.97 | 583.92
96814 - ELECTRONIC IGNITION | 4 | 0 | 539.94 | 539.94 | 0
99971 - TUNE UP DESCRIPTIONS | 31 | 0 | 2723.94 | 2723.94 | 0
33 - Tune-Up | 114 | 3478.46 | 3334.56 | 6813.02 | 1382.37
34 - Cooling
96052 - HEATER HOSE | 4 | 0 | 0 | 0 | 41.44
96056 - RADIATOR | 3 | 1100.54 | 0 | 1100.54 | 378.91
96102 - COOL FAN SWITCH | 1 | 145.23 | 0 | 145.23 | 59.41
96196 - THERMOSTAT & GASKET | 6 | 688.31 | 0 | 688.31 | 229.59
96244 - THERMOSTAT GASKET | 3 | 26.98 | 0 | 26.98 | 76.38
96316 - HOSE CLAMP | 13 | 82.88 | 0 | 82.88 | 8.58
96358 - DRIVE BELT TENSIONER | 1 | 0 | 0 | 0 | 172.46
96469 - FAN & MOTOR | 2 | 1225.55 | 0 | 1225.55 | 591.77
96645 - COOLING RESERVOIR | 3 | 429.41 | 0 | 429.41 | 176.31
97022 - BELTS/COOLING DESCRIPTION | 21 | 0 | 5458.86 | 5458.86 | 0
34 - Cooling | 57 | 3698.9 | 5458.86 | 9157.76 | 1734.85
35 - Electrical
96069 - ALTERNATOR | 8 | 3846.72 | 0 | 3846.72 | 1688.53
96080 - BRAKE LIGHT SWITCH | 2 | 291.55 | 0 | 291.55 | 116.59
96143 - HEADLAMP | 3 | 59.98 | 0 | 59.98 | 23.47
96154 - LAMP BULB | 7 | 383.63 | 0 | 383.63 | 230.3
96503 - INSTRUMENT CLUSTER | 1 | 498.56 | 0 | 498.56 | 180
96700 - PIGTAIL CONNECTOR | 2 | 88.99 | 0 | 88.99 | 26.82
96769 - ELECTRICAL SOCKET | 1 | 32.99 | 0 | 32.99 | 17.58
97023 - ELECTRICAL DESCRIPTION | 25 | 0 | 5930.49 | 5930.49 | 0
99976 - BATTERY SERVICE | 32 | 0 | 2874.65 | 2874.65 | 0
35 - Electrical | 81 | 5202.42 | 8805.14 | 14007.56 | 2283.29
36 - Batteries
96047 - BATTERY | 27 | 4419.33 | 0 | 4419.33 | 3145.89
36 - Batteries | 27 | 4419.33 | 0 | 4419.33 | 3145.89
37 - Brakes
37000 -  NON STOCK BRAKES | 1 | 189.56 | 0 | 189.56 | 126
96020 - BRAKE CABLE | 3 | 509.52 | 0 | 509.52 | 279.59
96023 - BRAKE ROTOR | 14 | 1912.38 | 0 | 1912.38 | 534
96027 - PADS (DISC BRAKE) | 18 | 2301.96 | 0 | 2301.96 | 619.82
96029 - BRAKE BOOSTER | 1 | 198.56 | 0 | 198.56 | 97.37
96044 - WHEEL HUB (BRAKE) | 1 | 324.99 | 0 | 324.99 | 139.07
96277 - BR MISC | 8 | 36.52 | 0 | 36.52 | 12.5
97024 - BRAKES DESCRIPTION | 27 | 0 | 7253.28 | 7253.28 | 0
37 - Brakes | 73 | 5473.49 | 7253.28 | 12726.77 | 1808.35
38 - Fuel/Emissions
3803 - DRIVABILITY DIAGNOSTICS | 56 | 0 | 6010.97 | 6010.97 | 0
96066 - AIR FLOW MOTOR/SENSOR | 1 | 302.56 | 0 | 302.56 | 132.31
96083 - CAMSHAFT SENSOR | 1 | 89.56 | 0 | 89.56 | 30.82
96136 - FUEL PUMP | 1 | 0 | 0 | 0 | 196.79
96153 - KNOCK SENSOR | 1 | 285.69 | 0 | 285.69 | 121.25
96169 - OXYGEN SENSOR | 1 | 449.56 | 0 | 449.56 | 273.41
96370 - FUEL SYSTEM | 1 | 239.56 | 0 | 239.56 | 94.04
97005 - FUEL/EMISSION PACKAGES | 46 | 0 | 0 | 0 | 0
97025 - FUEL/EMISSION DESCRIPTION | 6 | 0 | 1462.5 | 1462.5 | 0
38 - Fuel/Emissions | 114 | 1366.93 | 7473.47 | 8840.4 | 848.62
39 - Heat/AC
96064 - AC COMPRESSOR | 1 | 1095.56 | 0 | 1095.56 | 752.86
96124 - AC EVAPORATOR CORE | 1 | 697.99 | 0 | 697.99 | 236.46
96220 - AC HOSE | 2 | 321.51 | 0 | 321.51 | 109.46
96297 - AC KIT | 0 | -2.16 | 0 | -2.16 | 0
96377 - HEAT AND AC SYSTEM | 1 | 0 | 0 | 0 | 39.93
96768 - CABIN FILTERS | 18 | 787.95 | 56.76 | 844.71 | 201.88
96815 - MISC AC | 4 | 0 | 711.96 | 711.96 | 0
97006 - HEAT/AC PACKAGES | 5 | 0 | 0 | 0 | 0
97026 - HEAT/AC DESCRIPTION | 21 | 0 | 2543.22 | 2543.22 | 0
39 - Heat/AC | 53 | 2900.85 | 3311.94 | 6212.79 | 1340.59
40 - Engine
40000 -  NON STOCK ENGINE | 1 | 7678.99 | 0 | 7678.99 | 4986
96086 - CAMSHAFT SEAL | 2 | 113.98 | 0 | 113.98 | 27.2
96121 - ENGINE MOUNT | 10 | 2033.16 | 0 | 2033.16 | 846.43
96123 - CAM/CRANK BOLT KIT | 1 | 42.56 | 0 | 42.56 | 18.71
96132 - FRONT CRANK SEAL | 1 | 89.56 | 0 | 89.56 | 26.36
96207 - VALVE COVER GASKET | 7 | 875.5 | 0 | 875.5 | 263.3
96234 - INTAKE MANIFOLD | 1 | 1211.11 | 0 | 1211.11 | 1211.11
96361 - ENGINE GASKET SET | 1 | 69.87 | 0 | 69.87 | 30.55
96404 - ENGINE REAR MAIN SEAL | 1 | 142.99 | 0 | 142.99 | 37.04
96517 - VALVE ADJUSTER | 1 | 259.85 | 0 | 259.85 | 156.18
96519 - VALVE COVER | 1 | 36.99 | 0 | 36.99 | 18.03
97027 - ENGINE DESCRIPTION | 35 | 0 | 10757.06 | 10757.06 | 0
40 - Engine | 62 | 12554.56 | 10757.06 | 23311.62 | 7620.91
41 - Drivetrain
4103 - DRIVETRAIN PACKAGES | 12 | 0 | 0 | 0 | 0
96259 - HALFSHAFT | 3 | 769.61 | 0 | 769.61 | 284.02
97028 - DRIVETRAIN DESCRIPTION | 22 | 0 | 5496.42 | 5496.42 | 0
41 - Drivetrain | 37 | 769.61 | 5496.42 | 6266.03 | 284.02
42 - Suspension/Steering
4602 - SHOCK/STRUT LABOR | 8 | 0 | 2973.54 | 2973.54 | 0
96003 - CONTROL ARM | 27 | 9225.11 | 0 | 9225.11 | 3507.04
96013 - SWAY BAR BUSHING | 1 | 0 | 0 | 0 | 12
96014 - SWAY BAR KIT | 2 | 0 | 0 | 0 | 48.46
96015 - TIE ROD END | 1 | 179.65 | 0 | 179.65 | 54.47
96254 - CONTROL ARM BUSHING | 1 | 0 | 0 | 0 | 10.36
96485 - REAR TRAILING ARM | 1 | 149.69 | 0 | 149.69 | 45.38
97029 - SUSPENSION/STEERING DESC | 17 | 0 | 7220.76 | 7220.76 | 0
42 - Suspension/Steering | 58 | 9554.45 | 10194.3 | 19748.75 | 3677.71
43 - Exhaust
96090 - CATALYTIC CONVERTER | 1 | 1417.1 | 0 | 1417.1 | 1091.2
96308 - CONVERTER | 1 | 0 | 0 | 0 | 478.23
97030 - EXHAUST DESCRIPTION | 1 | 0 | 330 | 330 | 0
43 - Exhaust | 3 | 1417.1 | 330 | 1747.1 | 1569.43
44 - Transmission
96330 - AUTOMATIC TRANS | 2 | 383.55 | 0 | 383.55 | 137.45
96618 - TRANSMISSION SHIFT CABLE | 1 | 1145.26 | 0 | 1145.26 | 882.72
96697 - OUTPUT SHAFT SEAL | 8 | 95.12 | 0 | 95.12 | 55.6
97008 - TRANSMISSION PACKAGES | 1 | 0 | 156 | 156 | 0
44 - Transmission | 12 | 1623.93 | 156 | 1779.93 | 1075.77
45 - Safety Inspections
99990 - SAFETY INSPECTIONS | 374 | 0 | 4287.32 | 4287.32 | 0
45 - Safety Inspections | 374 | 0 | 4287.32 | 4287.32 | 0
46 - Shocks & Struts
96057 - SHOCK | 8 | 1663.06 | 0 | 1663.06 | 529.44
96058 - STRUT ASSEMBLY | 11 | 3241.6 | 0 | 3241.6 | 1355.12
46 - Shocks & Struts | 19 | 4904.66 | 0 | 4904.66 | 1884.56
48 - Shop Supplies
99984 - SHOP SUPPLIES | 444 | 7942.12 | 0 | 7942.12 | 0
48 - Shop Supplies | 444 | 7942.12 | 0 | 7942.12 | 0
50 - Miscellaneous
5002 - HEADLIGHT RESTORATION | 1 | 579.86 | 0 | 579.86 | 277.7
96053 - MAINTENANCE | 1 | 0 | 32.02 | 32.02 | 0
96214 - WIPER BLADES | 33 | 799.09 | 0 | 799.09 | 251.97
96793 - MISC SEAL | 1 | 0 | 0 | 0 | 17.8
97031 - MISCELLANEOUS DESCRIPTION | 109 | 0 | 918.96 | 918.96 | 0
50 - Miscellaneous | 145 | 1378.95 | 950.98 | 2329.93 | 547.47
51 - Coupons/Discounts
5106 - TAXABLE COUPONS | 67 | -2017.31 | -1799.31 | -3816.62 | 0
51 - Coupons/Discounts | 67 | -2017.31 | -1799.31 | -3816.62 | 0
52 - Disposal and Environmental Fees
99970 - NATL OIL FILTER DISPOSAL FEES | 11 | 33.56 | 0 | 33.56 | 0
99992 - OTHER DISPOSAL FEES | 14 | 35 | 0 | 35 | 0
52 - Disposal and Environmental Fees | 25 | 68.56 | 0 | 68.56 | 0
55 - National Account Labor
5501 - NATIONAL ACCOUNT LABOR | 5 | 0 | 32.85 | 32.85 | 0
55 - National Account Labor | 5 | 0 | 32.85 | 32.85 | 0
60 - Outside Services
6002 - MISC SUBLET LABOR | 2 | 772.99 | 0 | 772.99 | 583
60 - Outside Services | 2 | 772.99 | 0 | 772.99 | 583
66 - Belts and Hoses
96055 - RADIATOR HOSE | 5 | 507.65 | 0 | 507.65 | 180.7
96117 - DRIVE BELT | 8 | 799.9 | 0 | 799.9 | 219.18
66 - Belts and Hoses | 13 | 1307.55 | 0 | 1307.55 | 399.88
67 - Fuel injection Services
3802 - FUEL INJECTOR CLEANER | 7 | 454.93 | 0 | 454.93 | 95.04
6701 - FUEL INJECTION SERVICE PACKAGE | 5 | 0 | 0 | 0 | 0
6702 - FUEL INJECTION SERVICE LABOR | 7 | 0 | 865 | 865 | 0
67 - Fuel injection Services | 19 | 454.93 | 865 | 1319.93 | 95.04
68 - Power Steering Flush
6801 - POWER STEERING FLUSH PACKAGE | 2 | 0 | 0 | 0 | 0
6802 - POWER STEERING FLUSH LABOR | 2 | 0 | 120 | 120 | 0
96441 - POWER STEERING FLUID | 2 | 149.98 | 0 | 149.98 | 55.38
68 - Power Steering Flush | 6 | 149.98 | 120 | 269.98 | 55.38
69 - Coolant Flush
6901 - COOLANT FLUSH PACKAGE | 27 | 0 | 0 | 0 | 0
6902 - COOLANT FLUSH LABOR | 28 | 0 | 2184.56 | 2184.56 | 0
96347 - ENGINE COOLANT | 84 | 2575.16 | 0 | 2575.16 | 606.18
69 - Coolant Flush | 139 | 2575.16 | 2184.56 | 4759.72 | 606.18
70 - Transmission Flush
7001 - TRANSMISSION FLUSH PACKAGE | 8 | 0 | 0 | 0 | 0
7002 - TRANSMISSION FLUSH LABOR | 8 | 0 | 752.96 | 752.96 | 0
96354 - DIFFERENTIAL OIL | 29 | 869.71 | 0 | 869.71 | 288.03
96419 - TRANS FLUID/CHEMICALS | 47 | 1615.53 | 0 | 1615.53 | 560.03
70 - Transmission Flush | 92 | 2485.24 | 752.96 | 3238.2 | 848.06
71 - Brake Fluid Flush
7101 - BRAKE FLUSH PACKAGE | 19 | 0 | 0 | 0 | 0
7102 - BRAKE FLUSH LABOR | 18 | 0 | 1746 | 1746 | 0
96440 - BRAKE FLUID | 22 | 1096.78 | 0 | 1096.78 | 167.42
71 - Brake Fluid Flush | 59 | 1096.78 | 1746 | 2842.78 | 167.42
72 - Freon and AC Chemicals
3903 - FREON | 660 | 573.23 | 0 | 573.23 | 112.65
72 - Freon and AC Chemicals | 660 | 573.23 | 0 | 573.23 | 112.65
group total: | 4319.2 | 82670.2 | 87886 | 170556.2 | 35085.77
4229
25 - Tire Accessories
3003 - TPMS SENSOR | 1 | 0 | 19.99 | 19.99 | 0
3005 - TPMS REBUILD KIT | 27 | 134.73 | 0 | 134.73 | 0
96251 - TIRE PATCH | 1 | 23.99 | 0 | 23.99 | 1
25 - Tire Accessories | 29 | 158.72 | 19.99 | 178.71 | 1
26 - Tire Labor
97012 - TIRE SERVICES PACKAGES | 44 | 0 | 0 | 0 | 0
99982 - TIRE LABOR | 97 | 54.86 | 1283.5 | 1338.36 | 0
26 - Tire Labor | 141 | 54.86 | 1283.5 | 1338.36 | 0
31 - Alignments
977 - ALIGNMENT SERVICES | 49 | 0 | 2914.75 | 2914.75 | 0
31 - Alignments | 49 | 0 | 2914.75 | 2914.75 | 0
32 - LOF Services
96054 - OIL FILTER | 87 | 751.2 | 0 | 751.2 | 323.79
96806 - FLUIDS AND OILS | 472.1 | 4318.7 | 0 | 4318.7 | 1784.22
97001 - LOF SERVICE PACKAGES | 84 | 0 | 0 | 0 | 0
97021 - LOF SERVICE [NAME] | 84 | 5.55 | 2185.32 | 2190.87 | 0
32 - LOF Services | 727.1 | 5075.45 | 2185.32 | 7260.77 | 2108.01
33 - Tune-Up
96046 - AIR FILTER | 11 | 481.89 | 0 | 481.89 | 192.15
96095 - COIL (IGNITION) | 4 | 426.96 | 0 | 426.96 | 158.56
96182 - SPARK PLUG | 34 | 1084.36 | 0 | 1084.36 | 367.91
96217 - SPARK PLUG WIRE | 1 | 132.99 | 0 | 132.99 | 50.01
99971 - TUNE UP DESCRIPTIONS | 22 | 0 | 2905.99 | 2905.99 | 0
33 - Tune-Up | 72 | 2126.2 | 2905.99 | 5032.19 | 768.63
34 - Cooling
96056 - RADIATOR | 1 | 400 | 0 | 400 | 161
96107 - COOLANT TEMP SENSOR | 1 | 76.99 | 0 | 76.99 | 23.75
96196 - THERMOSTAT & GASKET | 2 | 68.99 | 240 | 308.99 | 40.12
96212 - WATER PUMPS & GASKET | 1 | 283.99 | 0 | 283.99 | 111.01
96494 - COOLING BYPASS HOSE | 1 | 202.99 | 97.5 | 300.49 | 74.05
97022 - BELTS/COOLING DESCRIPTION | 4 | 0 | 2398.5 | 2398.5 | 0
34 - Cooling | 10 | 1032.96 | 2736 | 3768.96 | 409.93
35 - Electrical
35000 -  NON STOCK ELECTRICAL | 2 | 103.99 | 390 | 493.99 | 46.24
96069 - ALTERNATOR | 0 | -56.99 | 0 | -56.99 | -23.3
96143 - HEADLAMP | 7 | 1452.93 | 0 | 1452.93 | 527.87
96145 - HEADLAMP RELAY | 1 | 88.99 | 0 | 88.99 | 44.63
96747 - ALARM HORN | 1 | 375 | 0 | 375 | 236.6
97003 - ELECTRICAL PACKAGES | 1 | 0 | 0 | 0 | 0
97023 - ELECTRICAL DESCRIPTION | 5 | 0 | 1860.49 | 1860.49 | 0
99976 - BATTERY SERVICE | 8 | 0 | 248.45 | 248.45 | 0
35 - Electrical | 25 | 1963.92 | 2498.94 | 4462.86 | 832.04
36 - Batteries
96047 - BATTERY | 14 | 3043.87 | 284.97 | 3328.84 | 1969.43
36 - Batteries | 14 | 3043.87 | 284.97 | 3328.84 | 1969.43
37 - Brakes
37001 -  DEALER PART BRAKES | 3 | 551.09 | 390 | 941.09 | 126.57
96020 - BRAKE CABLE | 1 | 243.78 | 97.5 | 341.28 | 80.99
96023 - BRAKE ROTOR | 26 | 4582.32 | 160 | 4742.32 | 1564.68
96027 - PADS (DISC BRAKE) | 12 | 1108.21 | 0 | 1108.21 | 307.4
96044 - WHEEL HUB (BRAKE) | 1 | 248.99 | 292.5 | 541.49 | 82.64
96631 - BRAKE SENSOR | 2 | 96 | 0 | 96 | 56.51
97004 - BRAKES PACKAGES | 12 | 0 | 0 | 0 | 0
97024 - BRAKES DESCRIPTION | 12 | 0 | 2252.89 | 2252.89 | 0
37 - Brakes | 69 | 6830.39 | 3192.89 | 10023.28 | 2218.79
38 - Fuel/Emissions
3803 - DRIVABILITY DIAGNOSTICS | 34 | 0 | 3369.74 | 3369.74 | 0
96083 - CAMSHAFT SENSOR | 2 | 0 | 0 | 0 | 41.46
96767 - AIR CLEANER | 1 | 329.99 | 97.5 | 427.49 | 121.99
96782 - EMISSION CONTROL PARTS | 1 | 501.99 | 195 | 696.99 | 216
96783 - FUEL INJECTION PARTS | 4 | 283.96 | 0 | 283.96 | 72
97005 - FUEL/EMISSION PACKAGES | 38 | 0 | 0 | 0 | 0
97025 - FUEL/EMISSION DESCRIPTION | 2 | 0 | 565.5 | 565.5 | 0
38 - Fuel/Emissions | 82 | 1115.94 | 4227.74 | 5343.68 | 451.45
39 - Heat/AC
96064 - AC COMPRESSOR | 2 | 771.99 | 0 | 771.99 | 686.6
96220 - AC HOSE | 1 | 0 | 0 | 0 | 104.25
96768 - CABIN FILTERS | 9 | 615.52 | 0 | 615.52 | 148.04
96815 - MISC AC | 3 | 0 | 615.97 | 615.97 | 0
96816 - HEATER PARTS | 1 | 276.99 | 429 | 705.99 | 96.6
97006 - HEAT/AC PACKAGES | 4 | 0 | 0 | 0 | 0
97026 - HEAT/AC DESCRIPTION | 4 | 0 | 654.49 | 654.49 | 0
39 - Heat/AC | 24 | 1664.5 | 1699.46 | 3363.96 | 1035.49
40 - Engine
40001 -  DEALER PART ENGINE | 1 | 211.55 | 0 | 211.55 | 146.19
96084 - CAMSHAFT | 1 | 24.6 | 0 | 24.6 | 18.45
96085 - CAMSHFT GEAR | 4 | 80.08 | 0 | 80.08 | 20.48
96086 - CAMSHAFT SEAL | 1 | 23.99 | 0 | 23.99 | 1
96201 - TIMING COVER GASKET | 1 | 140.99 | 0 | 140.99 | 48
96202 - TIMING CHAIN | 1 | 959.99 | 0 | 959.99 | 510.53
96203 - TIMING GEAR | 4 | 923.96 | 0 | 923.96 | 344
96207 - VALVE COVER GASKET | 10 | 202.2 | 0 | 202.2 | 151.63
96222 - BALANCE SHAFT | 2 | 160 | 0 | 160 | 69.34
96234 - INTAKE MANIFOLD | 1 | 390 | 0 | 390 | 160.54
96318 - OIL PRESSURE SWITCH | 1 | 45.99 | 0 | 45.99 | 12.86
96361 - ENGINE GASKET SET | 1 | 21.99 | 0 | 21.99 | 5.56
96387 - MANIFOLD GASKET SET | 3 | 135.98 | 0 | 135.98 | 119.83
96476 - CAMSHAFT SEAL | 6 | 77.4 | 0 | 77.4 | 58.06
97027 - ENGINE DESCRIPTION | 9 | 0 | 6104.59 | 6104.59 | 0
40 - Engine | 46 | 3398.72 | 6104.59 | 9503.31 | 1666.47
41 - Drivetrain
96006 - DRIVE SHAFT | 1 | 1275.99 | 0 | 1275.99 | 745.74
96259 - HALFSHAFT | 1 | 249.99 | 0 | 249.99 | 94.99
97028 - DRIVETRAIN DESCRIPTION | 3 | 0 | 1189.5 | 1189.5 | 0
41 - Drivetrain | 5 | 1525.98 | 1189.5 | 2715.48 | 840.73
42 - Suspension/Steering
4602 - SHOCK/STRUT LABOR | 6 | 0 | 2106 | 2106 | 0
96003 - CONTROL ARM | 2 | 667.98 | 0 | 667.98 | 250.78
96012 - STEERING GEAR/RACK | 1 | 806.99 | 0 | 806.99 | 415.79
96014 - SWAY BAR KIT | 5 | 556.95 | 117 | 673.95 | 154.89
96015 - TIE ROD END | 3 | 413.97 | 0 | 413.97 | 120.31
96189 - POWER STEERING PUMP | 1 | 363.99 | 0 | 363.99 | 141.51
96722 - STRUT MOUNT | 2 | 877.98 | 0 | 877.98 | 291.98
97029 - SUSPENSION/STEERING DESC | 8 | 0 | 3256.5 | 3256.5 | 0
42 - Suspension/Steering | 28 | 3687.86 | 5479.5 | 9167.36 | 1375.26
43 - Exhaust
43001 -  DEALER PART EXHAUST | 1 | 72.35 | 0 | 72.35 | 54.26
43 - Exhaust | 1 | 72.35 | 0 | 72.35 | 54.26
45 - Safety Inspections
99990 - SAFETY INSPECTIONS | 140 | 0 | 1600 | 1600 | 0
45 - Safety Inspections | 140 | 0 | 1600 | 1600 | 0
46 - Shocks & Struts
96057 - SHOCK | 6 | 893.94 | 0 | 893.94 | 308.36
96058 - STRUT ASSEMBLY | 3 | 645.98 | 0 | 645.98 | 449.41
46 - Shocks & Struts | 9 | 1539.92 | 0 | 1539.92 | 757.77
48 - Shop Supplies
99984 - SHOP SUPPLIES | 222 | 3176.49 | 0 | 3176.49 | 0
48 - Shop Supplies | 222 | 3176.49 | 0 | 3176.49 | 0
50 - Miscellaneous
96214 - WIPER BLADES | 14 | 238.98 | 0 | 238.98 | 124.25
96457 - IGNITION LOCK CYLINDER | 2 | 161.99 | 0 | 161.99 | 126.86
96486 - WINDOW REGULATOR | 2 | 546.98 | 195 | 741.98 | 211.83
96586 - ADAPTER | 1 | 0 | 195 | 195 | 17.29
96670 - GEAR OIL | 1 | 19.85 | 0 | 19.85 | 18.04
96687 - MISC FLUID | 6 | 37.02 | 0 | 37.02 | 37.02
96689 - NOZZLE | 2 | 63.98 | 0 | 63.98 | 37.98
96754 - ASPIRATOR | 2 | 160 | 0 | 160 | 63.14
96793 - MISC SEAL | 1 | 154 | 0 | 154 | 98.99
96803 - ACCESSORIES | 1 | 175 | 58.5 | 233.5 | 86.86
97031 - MISCELLANEOUS DESCRIPTION | 242 | 0 | 1043.25 | 1043.25 | 0
99989 - MISC TEMP PART | 1 | 364.56 | 0 | 364.56 | 364.56
50 - Miscellaneous | 275 | 1922.36 | 1491.75 | 3414.11 | 1186.82
51 - Coupons/Discounts
5106 - TAXABLE COUPONS | 67 | -1884.72 | -3492.14 | -5376.86 | 0
51 - Coupons/Discounts | 67 | -1884.72 | -3492.14 | -5376.86 | 0
52 - Disposal and Environmental Fees
99992 - OTHER DISPOSAL FEES | 17 | 42.5 | 0 | 42.5 | 0
52 - Disposal and Environmental Fees | 17 | 42.5 | 0 | 42.5 | 0
63 - Freight & Delivery Fees
6302 - FREIGHT | 2 | 76.8 | 0 | 76.8 | 72
63 - Freight & Delivery Fees | 2 | 76.8 | 0 | 76.8 | 72
66 - Belts and Hoses
96117 - DRIVE BELT | 2 | 233.68 | 0 | 233.68 | 66.41
66 - Belts and Hoses | 2 | 233.68 | 0 | 233.68 | 66.41
67 - Fuel injection Services
3802 - FUEL INJECTOR CLEANER | 8 | 585.92 | 0 | 585.92 | 189.62
6701 - FUEL INJECTION SERVICE PACKAGE | 9 | 0 | 0 | 0 | 0
6702 - FUEL INJECTION SERVICE LABOR | 8 | 0 | 1294 | 1294 | 0
67 - Fuel injection Services | 25 | 585.92 | 1294 | 1879.92 | 189.62
68 - Power Steering Flush
6801 - POWER STEERING FLUSH PACKAGE | 1 | 0 | 0 | 0 | 0
6802 - POWER STEERING FLUSH LABOR | 1 | 0 | 65 | 65 | 0
96441 - POWER STEERING FLUID | 1 | 74.99 | 0 | 74.99 | 5.53
68 - Power Steering Flush | 3 | 74.99 | 65 | 139.99 | 5.53
69 - Coolant Flush
6901 - COOLANT FLUSH PACKAGE | 12 | 0 | 0 | 0 | 0
6902 - COOLANT FLUSH LABOR | 11 | 431.92 | 858.22 | 1290.14 | 0
96347 - ENGINE COOLANT | 24 | 560.76 | 0 | 560.76 | 206.67
69 - Coolant Flush | 47 | 992.68 | 858.22 | 1850.9 | 206.67
71 - Brake Fluid Flush
7101 - BRAKE FLUSH PACKAGE | 10 | 0 | 0 | 0 | 0
7102 - BRAKE FLUSH LABOR | 10 | 0 | 970 | 970 | 0
96440 - BRAKE FLUID | 10 | 529.9 | 0 | 529.9 | 57.1
71 - Brake Fluid Flush | 30 | 529.9 | 970 | 1499.9 | 57.1
72 - Freon and AC Chemicals
3903 - FREON | 502 | 344 | 0 | 344 | 76.78
72 - Freon and AC Chemicals | 502 | 344 | 0 | 344 | 76.78
group total: | 2663.1 | 39386.24 | 39509.97 | 78896.21 | 16350.19
4232
25 - Tire Accessories
3003 - TPMS SENSOR | 6 | 547.94 | 0 | 547.94 | 245.12
3005 - TPMS REBUILD KIT | 21 | 104.79 | 0 | 104.79 | 0
96250 - RUBBER STEM | 1 | 10.82 | 5.43 | 16.25 | 0
25 - Tire Accessories | 28 | 663.55 | 5.43 | 668.98 | 245.12
26 - Tire Labor
97012 - TIRE SERVICES PACKAGES | 38 | 0 | 0 | 0 | 0
99982 - TIRE LABOR | 83 | -13 | 1416.26 | 1403.26 | 0
99983 - NATIONAL TIRE LABOR | 7 | 34.8 | 66.33 | 101.13 | 0
26 - Tire Labor | 128 | 21.8 | 1482.59 | 1504.39 | 0
31 - Alignments
977 - ALIGNMENT SERVICES | 40 | 0 | 2779.77 | 2779.77 | 0
31 - Alignments | 40 | 0 | 2779.77 | 2779.77 | 0
32 - LOF Services
96054 - OIL FILTER | 104 | 1033.33 | 0 | 1033.33 | 415.89
96394 - OIL DRAIN PLUG | 12 | 582.91 | 44.99 | 627.9 | 4.62
96806 - FLUIDS AND OILS | 629.5 | 5695.91 | 0 | 5695.91 | 2458.82
97001 - LOF SERVICE PACKAGES | 108 | 503.95 | 122.88 | 626.83 | 0
97021 - LOF SERVICE [NAME] | 106 | -62.44 | 2950.42 | 2887.98 | 0
32 - LOF Services | 959.5 | 7753.66 | 3118.29 | 10871.95 | 2879.33
33 - Tune-Up
96046 - AIR FILTER | 14 | 574.7 | 48.58 | 623.28 | 197.09
96095 - COIL (IGNITION) | 5 | 271.96 | 0 | 271.96 | 147.57
96139 - GLOW PLUG | 8 | 384 | 0 | 384 | 170.24
96170 - PCV VALVE | 1 | 41.12 | 0 | 41.12 | 12.4
96182 - SPARK PLUG | 22 | 633.66 | 0 | 633.66 | 236.94
96814 - ELECTRONIC IGNITION | 0 | 0 | 214.2 | 214.2 | 0
99971 - TUNE UP DESCRIPTIONS | 2 | 0 | 117.49 | 117.49 | 0
33 - Tune-Up | 52 | 1905.44 | 380.27 | 2285.71 | 764.24
34 - Cooling
34001 -  DEALER PART BELTS/COOLING | 2 | 560.3 | 0 | 560.3 | 304.97
96056 - RADIATOR | 1 | 250 | 0 | 250 | 125.99
96196 - THERMOSTAT & GASKET | 5 | 296.22 | 0 | 296.22 | 166.78
96212 - WATER PUMPS & GASKET | 1 | 225 | 0 | 225 | 99.99
96244 - THERMOSTAT GASKET | 1 | 19.25 | 0 | 19.25 | 9.26
96358 - DRIVE BELT TENSIONER | 1 | 342.12 | 0 | 342.12 | 151.78
97022 - BELTS/COOLING DESCRIPTION | 3 | 0 | 838.5 | 838.5 | 0
34 - Cooling | 14 | 1692.89 | 838.5 | 2531.39 | 858.77
35 - Electrical
35000 -  NON STOCK ELECTRICAL | 1 | 295 | 0 | 295 | 144.51
35001 -  DEALER PART ELECTRICAL | 8 | 1952.97 | 0 | 1952.97 | 1267.21
96069 - ALTERNATOR | 3 | 1858.33 | 0 | 1858.33 | 812.03
96143 - HEADLAMP | 3 | 44.85 | 0 | 44.85 | 14.75
96154 - LAMP BULB | 6 | 55.46 | 0 | 55.46 | 6.33
96185 - STARTER | 1 | 493.99 | 0 | 493.99 | 171.38
97023 - ELECTRICAL DESCRIPTION | 15 | 0 | 4852.61 | 4852.61 | 0
99976 - BATTERY SERVICE | 12 | 0 | 422.48 | 422.48 | 0
35 - Electrical | 49 | 4700.6 | 5275.09 | 9975.69 | 2416.21
36 - Batteries
96047 - BATTERY | 15 | 3111.35 | 0 | 3111.35 | 1459.06
36 - Batteries | 15 | 3111.35 | 0 | 3111.35 | 1459.06
37 - Brakes
37000 -  NON STOCK BRAKES | 2 | 718 | 0 | 718 | 259.98
37001 -  DEALER PART BRAKES | 5 | 778.97 | 0 | 778.97 | 426.26
96018 - ABS WHEEL SENSOR | 3 | 499.47 | 0 | 499.47 | 236.37
96021 - CALIPERS (BRAKE) | 2 | 379.98 | 0 | 379.98 | 166.3
96023 - BRAKE ROTOR | 12 | 2256.2 | 0 | 2256.2 | 952.9
96027 - PADS (DISC BRAKE) | 4 | 464.99 | 0 | 464.99 | 181.72
96044 - WHEEL HUB (BRAKE) | 2 | 52.52 | 0 | 52.52 | 26.62
96247 - WHEEL SEAL | 2 | 121.98 | 0 | 121.98 | 28.84
96277 - BR MISC | 4 | 0 | 0 | 0 | 0
97004 - BRAKES PACKAGES | 2 | 0 | 0 | 0 | 0
97024 - BRAKES DESCRIPTION | 13 | 0 | 3960.78 | 3960.78 | 0
37 - Brakes | 51 | 5272.11 | 3960.78 | 9232.89 | 2278.99
38 - Fuel/Emissions
3803 - DRIVABILITY DIAGNOSTICS | 68 | 0 | 7090.5 | 7090.5 | 0
38000 -  NON STOCK FUEL/EMISSIONS | 6 | 1774.3 | 0 | 1774.3 | 801.68
38001 -  DEALER PART FUEL/EMISSIONS | 2 | 1084.98 | 0 | 1084.98 | 676.22
96050 - FUEL FILTER | 2 | 198.99 | 0 | 198.99 | 63.11
96136 - FUEL PUMP | 1 | 231.59 | 0 | 231.59 | 138.5
96169 - OXYGEN SENSOR | 1 | 252 | 0 | 252 | 113.45
96199 - THROTTLE BODY & GASKET | 1 | 166.5 | 0 | 166.5 | 149.94
96343 - EVAP PURGE SOLENOID | 1 | 235.99 | 0 | 235.99 | 65.46
96534 - FUEL WATER SEPERATOR | 2 | 282.98 | 0 | 282.98 | 73.52
96597 - FUEL RAIL | 1 | 1151.38 | 0 | 1151.38 | 1000.39
97005 - FUEL/EMISSION PACKAGES | 33 | 0 | 0 | 0 | 0
38 - Fuel/Emissions | 118 | 5378.71 | 7090.5 | 12469.21 | 3082.27
39 - Heat/AC
39001 -  DEALER PART HEAT/AC | 2 | 236.99 | 0 | 236.99 | 105
96124 - AC EVAPORATOR CORE | 2 | 505.99 | 0 | 505.99 | 171.52
96377 - HEAT AND AC SYSTEM | 5 | 1577.48 | 0 | 1577.48 | 599.22
96768 - CABIN FILTERS | 11 | 433.58 | 70.49 | 504.07 | 129.51
96815 - MISC AC | 3 | 0 | 405 | 405 | 0
97026 - HEAT/AC DESCRIPTION | 14 | 0 | 6396.66 | 6396.66 | 0
39 - Heat/AC | 37 | 2754.04 | 6872.15 | 9626.19 | 1005.25
40 - Engine
40001 -  DEALER PART ENGINE | 6 | 4044.26 | 0 | 4044.26 | 2488.06
96121 - ENGINE MOUNT | 1 | 120.99 | 0 | 120.99 | 42.69
96166 - OIL PAN GASKET | 2 | 110.98 | 0 | 110.98 | 26.16
96200 - TIMING BELT | 1 | 397.99 | 0 | 397.99 | 151.99
96207 - VALVE COVER GASKET | 2 | 203 | 0 | 203 | 71.75
96387 - MANIFOLD GASKET SET | 2 | 151.98 | 0 | 151.98 | 37.08
96392 - OIL [NAME] | 1 | 105.99 | 0 | 105.99 | 26.59
96538 - OIL COOLER | 1 | 647.01 | 0 | 647.01 | 293.54
97027 - ENGINE DESCRIPTION | 31 | 0 | 12619.87 | 12619.87 | 0
40 - Engine | 47 | 5782.2 | 12619.87 | 18402.07 | 3137.86
41 - Drivetrain
4103 - DRIVETRAIN PACKAGES | 1 | 0 | 0 | 0 | 0
41000 -  NON STOCK DRIVETRAIN | 1 | 412.5 | 0 | 412.5 | 94.04
96259 - HALFSHAFT | 5 | 1584.99 | 0 | 1584.99 | 687.33
97028 - DRIVETRAIN DESCRIPTION | 2 | 0 | 587.51 | 587.51 | 0
41 - Drivetrain | 9 | 1997.49 | 587.51 | 2585 | 781.37
42 - Suspension/Steering
4602 - SHOCK/STRUT LABOR | 1 | 0 | 429 | 429 | 0
42001 -  DEALER PART SUSPENSION/STEER | 2 | 981.98 | 0 | 981.98 | 577.62
96003 - CONTROL ARM | 4 | 835 | 0 | 835 | 374.7
96012 - STEERING GEAR/RACK | 1 | 627.82 | 0 | 627.82 | 308.82
96015 - TIE ROD END | 1 | 133.99 | 0 | 133.99 | 34.62
96045 - ALIGNMENT PARTS | 4 | 737.98 | 0 | 737.98 | 262.26
96189 - POWER STEERING PUMP | 1 | 300 | 0 | 300 | 196.01
97029 - SUSPENSION/STEERING DESC | 9 | 0 | 3996 | 3996 | 0
42 - Suspension/Steering | 23 | 3616.77 | 4425 | 8041.77 | 1754.03
44 - Transmission
44000 -  NON STOCK TRANSMISSION | 2 | 1284.99 | 0 | 1284.99 | 613.15
96049 - AUTO TRANS FILTER | 5 | 234.95 | 0 | 234.95 | 55
96618 - TRANSMISSION SHIFT CABLE | 1 | 499.99 | 0 | 499.99 | 224.84
97008 - TRANSMISSION PACKAGES | 4 | 0 | 1957.5 | 1957.5 | 0
44 - Transmission | 12 | 2019.93 | 1957.5 | 3977.43 | 892.99
45 - Safety Inspections
99990 - SAFETY INSPECTIONS | 92 | 0 | 988.17 | 988.17 | 0
45 - Safety Inspections | 92 | 0 | 988.17 | 988.17 | 0
46 - Shocks & Struts
96057 - SHOCK | 4 | 1128 | 0 | 1128 | 402.88
46 - Shocks & Struts | 4 | 1128 | 0 | 1128 | 402.88
48 - Shop Supplies
99984 - SHOP SUPPLIES | 247 | 3997.53 | 0 | 3997.53 | 0
48 - Shop Supplies | 247 | 3997.53 | 0 | 3997.53 | 0
50 - Miscellaneous
50001 -  DEALER PART MISCELLANEOUS | 1 | 292.99 | 0 | 292.99 | 172.26
96214 - WIPER BLADES | 12 | 296.48 | 0 | 296.48 | 71.11
96504 - WIPER ARMS AND PARTS | 3 | 59.97 | 0 | 59.97 | 26.46
96670 - GEAR OIL | 1 | 27.99 | 0 | 27.99 | 6.22
96770 - MISC LABOR | 25 | 0 | 2229 | 2229 | 0
97031 - MISCELLANEOUS DESCRIPTION | 80 | 0 | 1323.35 | 1323.35 | 0
50 - Miscellaneous | 122 | 677.43 | 3552.35 | 4229.78 | 276.05
51 - Coupons/Discounts
5102 - FLEET DISCOUNTS | 22 | -440 | -40 | -480 | 0
5106 - TAXABLE COUPONS | 45 | -2548.33 | -2186.71 | -4735.04 | 0
51 - Coupons/Discounts | 67 | -2988.33 | -2226.71 | -5215.04 | 0
52 - Disposal and Environmental Fees
3403 - COOLING DISPOSAL FEES | 1 | 22.99 | 0 | 22.99 | 17.33
4202 - STEERING/SUSP DISPOSAL FEES | 1 | 4 | 0 | 4 | 0
99992 - OTHER DISPOSAL FEES | 13 | 30 | 0 | 30 | 55
52 - Disposal and Environmental Fees | 15 | 56.99 | 0 | 56.99 | 72.33
55 - National Account Labor
5501 - NATIONAL ACCOUNT LABOR | 0 | 0 | -109.8 | -109.8 | 0
55 - National Account Labor | 0 | 0 | -109.8 | -109.8 | 0
60 - Outside Services
6002 - MISC SUBLET LABOR | 1 | 2860.99 | 0 | 2860.99 | 2200
60000 - TOWING | 2 | 300.95 | 0 | 300.95 | 211
60002 -  NON STOCK OUTSIDE SERVICES | 2 | 1075.99 | 0 | 1075.99 | 700
60 - Outside Services | 5 | 4237.93 | 0 | 4237.93 | 3111
66 - Belts and Hoses
96117 - DRIVE BELT | 3 | 217.99 | 0 | 217.99 | 126.86
66 - Belts and Hoses | 3 | 217.99 | 0 | 217.99 | 126.86
67 - Fuel injection Services
3802 - FUEL INJECTOR CLEANER | 11 | 714.89 | 0 | 714.89 | 285.23
6701 - FUEL INJECTION SERVICE PACKAGE | 11 | 0 | 0 | 0 | 0
6702 - FUEL INJECTION SERVICE LABOR | 11 | 0 | 1375 | 1375 | 0
67 - Fuel injection Services | 33 | 714.89 | 1375 | 2089.89 | 285.23
68 - Power Steering Flush
6801 - POWER STEERING FLUSH PACKAGE | 4 | 0 | 0 | 0 | 0
6802 - POWER STEERING FLUSH LABOR | 4 | 0 | 295.01 | 295.01 | 12.36
96441 - POWER STEERING FLUID | 5 | 260.95 | 0 | 260.95 | 100.73
68 - Power Steering Flush | 13 | 260.95 | 295.01 | 555.96 | 113.09
69 - Coolant Flush
6901 - COOLANT FLUSH PACKAGE | 15 | 0 | 0 | 0 | 0
6902 - COOLANT FLUSH LABOR | 15 | 0 | 1170.3 | 1170.3 | 0
96329 - ANTIFREEZE | 1 | 39.99 | 0 | 39.99 | 16.12
96347 - ENGINE COOLANT | 45 | 1370.66 | 0 | 1370.66 | 353.88
69 - Coolant Flush | 76 | 1410.65 | 1170.3 | 2580.95 | 370
70 - Transmission Flush
7001 - TRANSMISSION FLUSH PACKAGE | 2 | 0 | 0 | 0 | 0
7002 - TRANSMISSION FLUSH LABOR | 2 | 0 | 188.24 | 188.24 | 0
96354 - DIFFERENTIAL OIL | 2 | 59.98 | 0 | 59.98 | 18.16
96419 - TRANS FLUID/CHEMICALS | 16 | 229.56 | 0 | 229.56 | 80.24
70 - Transmission Flush | 22 | 289.54 | 188.24 | 477.78 | 98.4
71 - Brake Fluid Flush
7101 - BRAKE FLUSH PACKAGE | 10 | 0 | 0 | 0 | 0
7102 - BRAKE FLUSH LABOR | 10 | 0 | 970 | 970 | 0
96440 - BRAKE FLUID | 10 | 529.9 | 0 | 529.9 | 90
71 - Brake Fluid Flush | 30 | 529.9 | 970 | 1499.9 | 90
72 - Freon and AC Chemicals
3903 - FREON | 12 | 36 | 0 | 36 | 6.36
72 - Freon and AC Chemicals | 12 | 36 | 0 | 36 | 6.36
group total: | 2323.5 | 57240.01 | 57595.81 | 114835.82 | 26507.69
all parts grand total: | 9305.8 | part price grand total: | 179296.45 | labor price grand total: | 184991.78