Created by : SME Team
Date : November 2007
The Excel tool for operations management has been developed on the request of SME. This tool allows a better follow up of the production operation time. The information can be sorted by production number, date, employee’s name or simply by operation. The tools also include performance indicators covering a limited period of time to simplify the user interface.
Based on the principle that nothing can be improved unless it has been measured, the Excel tool for operations management was developed to help businesses improve evaluation of their operating times. Production time data are very useful in operations planning, operation chain balancing, project profitability, and manufacturing cost implementation. The tool helps to define non-value added operations and those that could be improved.
As needed, the Excel tool for operations management can be used to manage the whole production system or specific projects.
The document requires the use of macros. To activate macros, select “tools” in the top menu, then “macros” then “security”. The recommended security setting is “medium”. Open the document and then click on “activate macros” while the document is opening.