The Energy, Utilities, and Waste Metrics (EUWM) Program is a web-based software and database application that facilitates the collection and reporting of wastes generated and the natural resources used for manufacturing operations worldwide. Ford Motor Company uses EUWM to monitor waste and quantities in support of internal Corporate citizenship improvement strategies. 'Wastes' are defined as anything that leaves a company facility that is not part of the product manufactured; the EUWM application is also capable of managing non-traditional wastes types like air emissions indicators and water effluent analyses.

 

 

Benefits Summary

Basic system functionality includes the ability to manually input, edit, and report on five data types:

  • Air emissions - emissions from fuel combustion, painting operations, and metal casting operations.
  • Material wastes - solid and liquid wastes associated with manufacturing processes.
  • Plant and production data - basic information used to normalize all other data types to a 'per unit of production' basis.
  • Utilities - quantities of energy used for manufacturing and cost information
  • Water and water discharge - water intake and discharge quantity and cost information



Standard reports are available to examine the data on an individual facility basis. Report types include:

  • Monthly data
  • Quarterly summaries including monthly values and annual (YTD and total) summations
  • Annual summaries
  • Tri-annual summaries (designated year and two previous years displayed side by side)



Online tools are included for designated system administrators. The tools include the following features and functions:

  • Add new users
  • Add new data input permissions for registered users
  • Basic database table maintenance including the ability to add, delete, and modify table entries
  • Administrative reports and pre-defined operations
    • Latest activity summary
    • Display of data completeness
    • Archive historical bulk data input files

Features

  • The system accommodates on-line data entry and editing.
  • Alternatively, data can be submitted electronically to the database. The data format (using Comma Separated Variable conventions) is easily generated by modern databases (like MS Access) or spreadsheet programs like (MS Excel) for automated processing.
  • The bulk data processing program evaluates the incoming data file and, if certain data quality criteria are met, purges any old data and inserts the new. A processing report with exceptions noted is then sent to the program administrators and the sender of the data.
    • The EUWM application, originally developed in 1996, was enhanced in late 2000 to include the following new features:
    • Country/region - specific waste codes and names are now supported
    • For material waste streams, waste disposition and ultimate use can now be tracked
    • For energy and utility data entry, cost information can be entered when quantity data is entered
    • A new data entry mode allows full year data entry by parameter
    • Web screen navigation has been improved.

     

Applications

This program is an enterprise-wide data management solution for medium/large scale organizations, including waste management companies.

Development Status

Implementation at Ford Motor Company began in 1996 and development is complete.

Licensee Support

Ford will provide an appropriate amount of hours in assistance, in order to help in launching the EUWM System at your facility and with your suppliers.

Patents

Energy, Utilities, and Waste Metrics (EUWM) System and software materials are protected by copyrighted.

 

  Licensing Manager
Technology Commercialization, FGTL

Name: Chris Danowski
Phone: 313-390-9453
Fax: 313-322-7162
Email: cdanowsk@ford.com
Technical Information Environmental Quality Office
Name: Bob Devlin
Phone: 313-594-7753
Email: bdevlin@ford.com
Technical Information Environmental Quality Office
Name: Carl Ozar
Phone: 313-337-5413
Email: cozar@ford.com