KPI Excel Template

gymclass14

New Member
Joined
Oct 4, 2009
Messages
12
I am looking for some KPI board templates in Excel. I have a two shift, 6 machine operation. I would like to track pieces, footage, and weight per man hour. I currently have 30 employees. Any help would be greatly appreciated!!!
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Welcome to the Board!

There are a lot of elements to consider on this one. Primarily is how do you intend to track performance data (i.e. collection method - barcode scan, paper or PC forms, etc.)?

What are your targets? I.E. do you have hourly production goals for a set/standardized product (let's say a newspaper, which would be fairly consistent with run time/PerM page count) or will you have varying measurement levels (let's say motorcycle tires in 10 different sizes/configurations, where each will have different assembly time components)?

What are your measurement goals? Do people get penalized for underperformace and/or rewarded for performance to goals? Are there salary increases/decreases to consider? Punitive measures? Training programs?

You might want to start by looking at the Microsoft Template Gallery and see if there's anything applicable.

I've had a ton of experience in performance management, so I'll tell you that from my perspective one of the most important things is to come up with reasonable goals that you can track (objective vs. subjective). Another thing that may or may not be applicable in your situation is to be able to set a performance target (e.g. Parts per Operator Hour) that takes breaks (lunch) into account, but not penalize for unplanned machinery downtime (which would go against the maintenance dept and their measurement system), which is again objective vs. subjective.

We actually dropped annual turnover in an operating unit from over 200% to 16% in one year by establishing realistic employee goals and making the keen differentiation between recognizing external issues and employee issues when evaluating goals.

You just need to figure out what you want to define and how to gather it. Once you do that we can help you set something up.


HTH,
 
Upvote 0
Thanks for helping me get this created. The daily production is reported on paper at the current time. Employees are turning in the paperwork at the end of the shift and the supervisor enters the numbers into a simple spreadsheet. The goals for 2010 have been set and will change in 2011. Currently pcs/mhr is 28, lbs/mhr is 750, lbs/mhr 6,000, and sqs/mhr 31. Sqs is calculated by total footage / 31.579. What other information can I provide that will help you help me??
 
Upvote 0
That's a good start.

In a production environment I'm assuming you have multiple shifts/supervisors, so a multi-user environment would be the best approach, which means you'll want to move to Access if you can. If you have to stick to Excel, then it's not necessarily a problem, but you'll want to consider moving to a database at some point in time (just to reiterate).

If you PM me your e-mail address I'll send you the board's HTML Maker, which will let you post screen shots and give us a better idea of what you're dealing with, just make sure to outline what you have now and what your desired outcome is. ;)
 
Upvote 0

Forum statistics

Threads
1,214,829
Messages
6,121,827
Members
449,051
Latest member
excelquestion515

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top