22-Final Draft Schedule B-4 River Skimmer PM.xlsx
XLSX spreadsheet 30 KB Posted
- Solicitation number
- P-3216
- Issued by
- Milwaukee County, Mattoon Village, Wisconsin
About this file
This document is an asset maintenance schedule and inventory spreadsheet for the Milwaukee Metropolitan Sewerage District (MMSD), focusing on water reclamation infrastructure equipment. The file details preventive maintenance (PM) protocols for four primary assets: two conveyor belt systems, one towable/trailer, and one river skimmer boat. The assets are categorized as active fleet and mechanical equipment, with specific maintenance tasks outlined for pre-season, mid-season, and post-season periods. The river skimmer boat (Asset ID 121,503) was originally acquired on 4/12/12 at a cost of $375,000, with an estimated useful life of 15 years, and is currently classified as a low-risk asset.
The document provides comprehensive maintenance checklists for each asset, including detailed inspection points for tires, electrical systems, hydraulic components, engines, and structural elements. The assets are valued at approximately $654,101 collectively, with replacement costs and in-service dates carefully documented. The maintenance schedule appears designed to ensure optimal operational readiness and extend the functional lifespan of critical water infrastructure equipment. The river skimmer boat and associated equipment are manufactured by Aquarius Systems from North Prairie, Wisconsin, and are integral to the district's water management operations.
View the file
Other files
Show all 27
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Vessel Asset Summary with PMs
| ASSET CLASS | ASSET TYPE | ASSET QTY | ACTIVITY | PM FREQUENCY | |
| CONVEYOR | CONVEYOR, BELT | 2 | |||
| CONVEYOR | CONVEYOR, BELT | PERFORM MSA. | A | ||
| CONVEYOR | CONVEYOR, BELT | POST-SEASON (AUTUMN) | A | ||
| CONVEYOR | CONVEYOR, BELT | CHANGE ENGINE OIL & FILTER | A | ||
| CONVEYOR | CONVEYOR, BELT | RECORD DATE & HOURS | A | ||
| CONVEYOR | CONVEYOR, BELT | REMOVE BATTERY (STORE IN BATTERY ROOM) | A | ||
| CONVEYOR | CONVEYOR, BELT | DRAIN FUEL FROM CARBURETOR | A | ||
| CONVEYOR | CONVEYOR, BELT | ADD FUEL STABILIZER TO FUEL TANK | A | ||
| CONVEYOR | CONVEYOR, BELT | CHANGE SPARK PLUGS (2) | A | ||
| CONVEYOR | CONVEYOR, BELT | CHECK TIRES & AIR PRESSURE IN TIRES | A | ||
| CONVEYOR | CONVEYOR, BELT | LUBE ALL BEARINGS | A | ||
| CONVEYOR | CONVEYOR, BELT | ADJUST CHAINS FOR CONVEYOR | A | ||
| CONVEYOR | CONVEYOR, BELT | INSPECT & REPLACE HYDRAULIC HOSES AS NEEDED | A | ||
| CONVEYOR | CONVEYOR, BELT | CHANGE HYDRAULIC FILTER & OIL YEARLY OR AS NEEDED | A | ||
| CONVEYOR | CONVEYOR, BELT | REPACK BEARINGS EVERY 3-4 YEARS | A | ||
| TOWABLE/TRAILER | TOWABLE/TRAILER | 1 | |||
| TOWABLE/TRAILER | TOWABLE/TRAILER | TRAILER, SKIMMER | Line 10 5 | RECORD DATE_________ | |
| 10 | INSPECT TIRES FOR PROPER INFLATION, WEAR, & DAMAGE_______ | ||||
| 15 | CHECK WHEEL LUGS FOR PROPER TORQUE________ | ||||
| 20 | INSPECT SUSPENSION COMPONENTS: SPRINGS, SHACKLES,BUSHINGS, MOUNTS,EQUALIZER BEAMS,AND AXLES.LUBRICATE AS REQUIRED______ | ||||
| 30 | CK BRAKE FLUID RESERVOIR & INSPECT SURGE COUPLER ( if applicable)________ | ||||
| 35 | INSPECT BRAKES FOR PROPER ADJUSTMENT & OPERATION___________ | ||||
| 40 | CHECK ALL LIGHTS, INSPECT ELEC CABLE & CONNECTION PLUG_________ | ||||
| 45 | INSPECT TRAILER COUPLING FOR WEAR OR DAMAGE________ | ||||
| 50 | INSPECT SAFETY CHAINS, MOUNTING & HOOKS FOR WEAR OR DAMAGE____ | ||||
| 55 | INSPECT BREAKAWAY CABLE/CONNECTOR (IF APPLICABLE)________ | ||||
| 60 | INSPECT TRAILER DECKING, SIDE BOARDS,AND FENDERS_________ | ||||
| 61 | INSPECT RAMPS,RAMP HINGES,AND LOCKS FOR WORN,DAMAGED, OR MISSING PARTS.__________ | ||||
| 65 | NOTE: FOR TRAILERS EQUIPPED WITH ELECTRIC BRAKES AND BATTERY | ||||
| 66 | OPERATED SAFETY BREAK AWAY SYSTEM. | ||||
| 67 | CLEAN AND CHARGE BATTERY______ | ||||
| 70 | PERFORM OPERATIONAL TEST OF EMERGENCY BRAKING SYSTEM______ Line 20 Appearance | ||||
| A | |||||
| WATERCRAFT | WATERCRAFT | 1 | |||
| WATERCRAFT | WATERCRAFT | BOAT, RIVER SKIMMER | Line 10 PRE-SEASON (SPRING) |
DATE:_______ HR. ______
VALVE ADJUSTMENT ______
LUBE STEERING LINKAGE & OUTDRIVE PIVOTS______
CHARGE, TEST & INSTALL BATTERIES, ____
TEST ENGINE CONTROLS______
INSPECT AND CLEAN ENG. SEA WATER INTAKE______
INSPECT LOWER UNIT, (2)______ ______
CK ENGINE STARTING/CHARGING SYSTEMS______
CHECK/ADJUST 3 CONVEYOR CHAINS
TEST RUNNING LIGHTS & CABIN LIGHTS______
TEST RUN ENGINES (CK WATER PUMP & THERMOSTAT OPERATION)______
TEST TRIM & TILT CONTROLS______
LUBE ALL PIVOTS & PILL BLOCK BEARINGS______
POST-SEASON (AUTUMN)
DRAIN FIRE HOSE PUMP
CHANGE ENGINE OIL AND FILTER______ ______
RECORD DATE _______ HR _______
REMOVE BATTERY (STORE IN BATTERY ROOM)______
CHECK/ADJUST 3 CONVEYOR CHAINS
INSPECT PROPELLERS FOR DAMAGE______ ______
ADD FUEL STABILIZER TO BOTH FUEL TANKS______ ______
LUBE ALL PIVOTS & PILL BLOCK BEARINGS_______
INSPECT ALL ANODES & REPLACE AS NECESSARY_________
INSPECT/REPLACE SIDE THRUSTER PROPS (4) & ANODES________
REPLACE FUEL FILTERS_____
TEST ENGINE COOLANT-RECORD PROTECTION________
ADD NALCOOL AS NEEDED
INSPECT/REPLACE HYDRAULIC HOSES AS NEEDED
REPLACE HYDRAULIC FILTERS (2) & OIL
| WRAP BOTH CABINS FOR POST-SEASON STORAGE | 4M | |||
| WATERCRAFT | WATERCRAFT | BOAT, RIVER SKIMMER | LINE 10 MID-SEASON PM |
10 COMPLETE VISUAL INSPECTION
15 CHECK INSIDE HULL FOR LEAKS OR DAMAGE
20 DRAIN WATER FROM HYDRAULIC TANK (OPEN PEPCOCK)
25 CHECK HYDRAULIC SYSTEM FOR LEAKS OR DAMAGE
30 CHECK HYDRAULIC CYLINDERS FOR HOSES, CRACKS OR DEFORMATIONS
40 CHECK HYDRAULIC FLUID LEVEL 50 CHECK RADIATOR FLUID LEVEL
55 REPLACE ALL HYDRAULIC SPIN-ON FILTERS
60 REPLACE HYDRAULIC OIL
65 CLEAN HYDRAULIC TANK MAGNET
70 MACHINE LUBRICATION (SEE MASTER LUBE CHART)
80 CHECK CONVEYOR BELTING FOR PROPER TENSION & DAMAGE
90 CHANGE ENGINE OIL AS NEEDED
100 CHECK NUTS & BOLTS FOR PROPER TENSIONING
110 CHECK MUFFLER & EXHAUST SYSTEM
120 CHECK STRUCTURAL MEMBERS & WELDS
130 CHECK BATTERIES AND STARTING SYSTEM
140 REPLACE EXTERNAL FUEL PRE-FILTER
150 REPLACE AIR FILTER
160 SERVICE PRIMARY AND SECONDARY FUEL FILTERS
170 DRAIN ENGINE BREATHER CANISTER LINE 20 APPEARANCE
| A | ||
| ASSET COUNT | 4 |
Assets With PMs
| Assets | Class | Asset Value | Asset Life | Asset Risk | Renewal Strategy | Other | |||||||||||||||||||||||||||||||||||||||||||
| MMSD Asset ID | Asset Description | Asset Status | Asset Category | Asset Class | Asset Type | Fixed Asset Class | Original Invoice Cost | Original Acquisition Cost | Current Year Replacement Cost | In Service Date | Initial Est Useful Life | Last Rehab Date | Rehab Useful Life | Governing Rehab Replace Year | Governing Next Inspection Due Yrs | Retire Date | In Open Risk | Asset Risk Level | Asset Risk Score | Governing LOF Score | LOF Score Driver | LOF Score Mortality | LOF Score Capacity | Governing COF Score | COF Score Driver | COF Score CMMS Criticality | COF Score Pipe Diameter | Asset COF | Next Renewal Type | Next Rehab Type | Next Renewal Cost (Current Yr $) | Next Investment Year | Recommended Action | Building | Field Location | Position | Municipality | CMMS Asset ID | Projects | Open Action Status in Project | Transmittal No. | P&ID or Equipment Tag No. | Unit Process | Control Loop | Serial No. | Manufacturer | Manufacturer Model No. | OWAM Comments | Previous Asset ID |
| 121,503 | BOAT, RIVER SKIMMER | ACTIVE | FLEET | WATERCRAFT | WATERCRAFT | 187 - TRANSPORTATION | $375,000.00 | $546,747.42 | 4/12/12 | 15 | 2/28/22 | 10 | 2,025 | N | Low | 10 | 5 | Mortality | FAILURE RATE | 2 | CMMS Criticality | 2 | # | BLDG102 | 10200000 | E-00053973 | MCRR1505,P.O.6403,MCRR1505a,MCRR1505b,MCRR1679 | Y | 2523 | UU172, ENGINE SN 68325852 | AQUARIUS SYSTEMS NORTH PRAIRIE, WI | TH-28SPL TRASH HUNTER |
DW 4/28/17
143,866 TRAILER, SKIMMER ACTIVE FLEET TOWABLE/TRAILER TOWABLE/TRAILER 187 - TRANSPORTATION 15 N 2 CMMS Criticality 2 # BLDG285 28500000 E-00057888 N 1D9T3L033WN202176 A FL WC 143866 TMINZLAFF 4/15/25 7:43 11/28/16 9:27 SYNERGEN UPDATED CATEGORY, CLASS, AND/OR TYPE
DW 5/22/17
121,504 CONVEYOR, OFF-LOADING, RIVER SKIMMER ACTIVE MECHANICAL CONVEYOR CONVEYOR, BELT 185 - MACHINERY & EQUPMENT $95,000.00 $138,509.35 4/12/12 20 2,032 N 2 CMMS Criticality 2 # BLDG102 10200000 E-00053974 P.O.6403 N UU174 AQUARIUS SYSTEMS NORTH PRAIRIE, WI PIER CONVEYOR A FL WC 121504 TMINZLAFF 8/23/23 13:40 UPDATED CLASS CATEGORY AND/OR TYPE
DW 4/28/17
152,875 CONVEYOR, OFF-LOADING, RIVER SKIMMER ACTIVE MECHANICAL CONVEYOR CONVEYOR, BELT 185 - MACHINERY & EQUPMENT $143,500.00 $169,844.63 7/8/20 20 2,040 N 2 CMMS Criticality 2 # BLDG102 10200000 E-00061603 M01038/PO 11150 N PO# 11150 AQUARIUS SYSTEMS NORTH PRAIRIE, WI MSC-34 Pier Conveyor A FL WC 152875 TMINZLAFF 8/23/23 13:47 4/26/21 17:27 TMINZLAFF
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .