Automate the sales process for manufacturing

How to create outlook signature

[Music] hi this is ivan with simplesheets in this video we're going to do a step-by-step tutorial of our manufacturing kpi management template this is one of over 100 pre-built and smart samples that we offer click the link in the description and try 5 free templates before you buy let's get started the introduction sheet contains a short description about this template over here we have a customization difficulty an explanation of the sheets that come with this template and some instructions on how you can utilize this template and at the bottom we have a short guide on using our templates with compatible online services for any manufacturing business it's always important to set kpis in order to have a way to track and gauge the business's efficiency as well as a way to guide you in making strategic decisions to use this template we first head over to the database sheet it's here where we input the important company details like product details operating shifts failure root causes and operating line details once everything's set we can move over to the raw data sheet in this sheet keep in mind to only put data in the white cells as the gray cells contain automated formulas it's here where you can log the details about your production input the date shift line number the product actual runtime plan downtime the failure root cause if any the ok quantity defect quantity and the number of machinery breakdowns the other columns should be given to you automatically if you want to add a new entry simply place them at the bottom of the last line of data once you've got that filled out we can now go to the dashboard it's here where we can get a bird's-eye view of our production metrics on top we have some highlighted figures such as the total approved units total defects and defect rate the plan achieved percentage along with total run time lost time and average units per hour we have the total lose cost analysis with the defect cost and lost time cost as well as the total last on top is the overall equipment effectiveness rate in the middle area we have some visual tools to help you better grasp your data we have the plan achieved percentage versus the total approved units overtime product plan achieve percentage and defect percentage per product failure root cause analysis time analysis of hourly utilization over time oee analysis and mean time to repair analysis for your equipment in the visualization limits control it's here where you set the boundaries of your highlighted metrics to whatever value you want for both the warning level and accepted level if the value falls in between those two values it'll be highlighted in yellow this sheet is equipped with an array of slicers to help you filter these charts you can do so by date line shift product and failure root cause as standard you have a refresh data macro button to update the sheet whenever new data is added and a full screen macro button to hide your ribbons lastly we have a nifty tool in case you might want to test out different combinations of shift times down times breakdowns cycle times parts and scraps just input the data and see the results instantly here that's all for this template if you want to automate your excel processes and enhance your level of productivity simple sheets advanced templates and university is the best tool out there i'll see you guys on the next one