Production Management Excel Dashboards

Production KPIs / Metrics Control And Management Excel Dashboards

This example risk assessment shows the kind of approach a small business might take. It can be used as a guide to think through some of the hazards in your business and the steps you need to take to control the risks. Please note that it is not a generic risk assessment that you can just put your company name on and adopt wholesale without any thought. This would not satisfy the law – and would not be effective in protecting people.

Where possible, maintenance work at the factory is done in-house by the fitter. His main job is to support production by, for example, maintaining plant, machinery and tools and undertaking minor jobs on the building fabric. The company also uses outside contractors, for example for most building repairs, detailed repairs to machinery, and most electrical work and work on the LEV system. The fitter’s job includes the selection of contractors and, with the works manager, the oversight of their work.

The fitter works out of a small workshop, which has some basic engineering machinery, a welding kit and secure storage for solvents and flammables. His work, however, takes him to all parts of the factory.

Related: Project Management

walked around all the areas where he and contractors may go, noting things that might pose a risk, and taking into account both HSE’s guidance and those jobs that he or contractors may be required to do.

For each hazard, the fitter wrote down what was already being done to manage these, taking HSE’s guidance into account. Where he did not consider existing controls good enough, he wrote down what else needed to be done to control the risk.
This example risk assessment shows the kind of approach a small business might take. Use it as a guide to think through some of the hazards in your business and the steps you need to take to control the risks. Please note that it is not a generic risk assessment that you can just put your company name on and adopt wholesale without any thought. This would not satisfy the law – and would not be effective in protecting people.

Excel dashboard templates for production control and management metrics and KPIs

For each hazard identified, the manager recorded what controls, if any, were in place to manage these. She then compared these controls to the good practice guidance laid out in Warehousing and storage: A guide to health and safety and the Health and safety toolbox site. Where existing controls did not meet good practice, the manager wrote down what further actions were needed to manage the risk.

The risk management plan identifies the risks that can be defined at this stage of the project life cycle, evaluates them, and outlines mitigation actions. Your risk management plan should be periodically updated and expanded throughout the life cycle of your project, as the project increases in complexity and risks become more defined.


Additional Resources:

Free Business Management Templates

Project Management

More on Operations

Mr Dashboard