Spreadsheet: 721035d1614438763-weighted-average-for-technician-efficiency-efficiancy-forum
Sheet: FTU_stdrptTasksInProgressProduc

 | TECHNICIAN EFFICIANCY
 | DATE RANGE: XX/XX/XXXX - XX/XX/XXXX
 | SHOP EFFICIENCY:
 | Unit | Task Description | Total  Act Hrs | Planned Hrs | [NAME] | Eff %
 | FOREMAN: DARREN PFERDEHIRT |  |  |  | Avg. Tech Efficiancy:
 | [NAME]
 | COMPLETED TASKS
 | 1858-UPFIT1 YCI | 21.30A - New Foam Proportioner: Prepare the plumbing for the foam system. | 100 | 100
 | UNIT1969 HENDERSO | REWORK - Problem: pump boss will not control throttle | 2 | 4
 | UNIT1969 HENDERSO | REWORK - Problem: pump panel gauges inop | 5 | 4
 | UNIT1969 HENDERSO | REWORK - Problem: fuse box and associated harnesses in cab should be replaced | 85 | 80
 | UNIT1385-UPFIT1 FREE | CUSTOM - Inspect wiring & repair in cab. | 22 | 20
 | 1858-UPFIT1 YCI | CUSTOM - 20.62 Pump Panels: To accommodate new intakes, LDH discharges, and electronic valve controls, and foam eductor, all pump panels shall be replaced with new custom built pump panels. Pump panels to be aluminum & Vortexed black. Newly built pump panels to be vortexed! - Pump panel need to accommodate an external speaker mounted and radio hard wired and mounted to hear clearly. | 1 | 1
 | 1858-UPFIT1 YCI | CUSTOM - 21.40 New Foam Fill System: A new [NAME] system shall be installed. The foam tank shall be re-fillable from an offboard inlet automatically. The tank is automatically filled without overflowing from the ground. Customer requestd top fill. | 1 | 1
 | UNIT1969 HENDERSO | CUSTOM - Repair punch list items | 1 | 1
 |  |  |  |  | Avg Efficiancy
 | Lancen Abregano Current Punch
 | COMPLETED TASKS
 | UNIT1858-UPFIT1 | 20.33A - Drain valves shall be replaced with new. | 85 | 100
 | UNIT1858-UPFIT1 | 08.05C - Replace Muffler, Wrap, Flex, and Tip: Install the muffler. | 3.5 | 3
 | UNIT1924-UPFIT1 | CUSTOM - Complete punch list items | 14 | 12
 | UNIT1969 | REWORK - Problem: spec calls for new pump valves, not rebuilt ones | 7 | 6
 | UNIT1385-UPFIT1 | CUSTOM - Install Waterous 1250 pump and plumbing. | 7 | 8
 | UNIT1385-UPFIT | CUSTOM - Lube entire chassis. | 1.6 | 1
 | UNIT2063-UPFIT1 | CUSTOM - Replace brake treadle valve | 1.8 | 2
 | UNIT1858-UPFIT1 | 21.30B - New Williams Fire and [NAME] See notes for configuration. | 15 | 17
 | UNIT1858-UPFIT1 | CUSTOM - 20.59 Deluge Discharge: The deluge discharge valve shall be replaced with an Akron electric valve. | 6 | 4
 | UNIT1858-UPFIT1 | CUSTOM - 20.36 [NAME]: A new Task Force Tips MONSOON series Electrically controlled monitor, up to 2000 gpm shall be provided and installed on the deluge discharge. | 9 | 6
 | UNIT1858-UPFIT1 | 20.52A - The discharge caps and chains shall be replaced with new chrome/storz caps and vinyl covered cables. | 0.4 | 0.5
 | UNIT1385-UPFIT1 | ADLLBR - Additional Labor:  [NAME] damaged cross member and install LKQ cross member.  Reason for Add: Crossmember under rear of cab cracked both sides & Severely corroded. | 0.2 | 1
 |  |  |  |  | Avg Efficiancy
 | FOREMAN: CHRIS AKIN |  |  |  | Avg. Tech Efficiancy:
 | Eduardo Pacheco Current Punch
 | COMPLETED TASKS
 | UNIT1858-UPFIT1 | CUSTOM - Remove side windows so the trim can be replaced | 10 | 12
 | UNIT1385-UPFIT1 | CUSTOM - 14.40 Scene Lighting - 12-volt Surface Mount: Two (2) new Whelen 900 Series Opti Scene Light(s) with chrome bezels shall be installed in a location specified by the Purchaser. Clear lenses. | 16 | 15
 | UNIT1385-UPFIT1 | CUSTOM - 14.15 Mini Light Bars: Two (2) new [NAME] light bars shall be installed between main bar and where the cab goes up in height. All red light with clear lenses. | 4 | 6
 | UNIT1385-UPFIT1 | CUSTOM - Install LED primary lightbar. | 15 | 18
 | UNIT1385-UPFIT1 | CUSTOM - Install and wire through the cab unity spot lights | 18 | 22
 | UNIT1385-UPFIT1 | CUSTOM - Install marker lights | 7 | 5
 |  |  |  |  | Avg Efficiancy
 | Jarred Wiberg Current Punch
 | COMPLETED TASKS
 | UNIT2046 | 19.35A - Disassembly: (Tech 1/2) Remove all bolt on components including but not limited to; door handles, bezels, grab rails, steps, trim, front grill, side grills, mirrors, pump panels, diamond plate, fenderettes, D rings, rub rails, ladder rack, etc.. All electrical components should have already been removed at Station 3. If electrical components are still present on the unit, notify the Shop Foreman. | 100 | 100
 | UNIT2052-REFURBISHMENT | 01.10C - Break Down Apparatus: (Tech 2/2) The apparatus shall be disassembled including removal of lighting, bezels, ladder rack, body compartment accessories, mirrors. Does not include shelving or compartment doors. All items will be tagged, packaged, and routed. All tagged items will utilize the color coding system. | 0.1 | 1
 |  |  |  |  | Avg Efficiancy