Create Your Excel Bill Sheet for Product Quality Effortlessly

Excel bill sheet for Product quality

[Music] hi this is ivan with simplesheets in this video we're going to do a step-by-step tutorial of our cost of quality template this is one of over a hundred pre-built and smart templates that we offer click the link in the description and try five 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 at the bottom we have a short guide on using our templates with compatible online services this template would allow you to see how much of your money goes into preventing products being sold that are of poor quality by doing this you could gain insights into what potential savings you could have from implementing process improvements the only sheet you have to worry about really is the raw data sheet you can expand the source list by pressing the plus sign on the left input the different items as well as all the pertinent details concerning the material costs per item and hourly rates for the appraisal costs internal costs external costs and prevention costs you can collapse the tables when done in the raw data table input the date and fill up the columns with the yellow headings those are the failure type issue quantity and task hours if applicable you should get the item cost material cost hourly rate hours cost and amount automatically once you're done you can move on to the master sheet in the master sheet we have reports for each type of cost and a rundown of the totals that you've logged in the raw data table at the end of each table you have the cost of quality percentage with an indicator color generally the lower the better and for higher values you might want to take a look into them more because there might be process improvements that you can work on on the right hand side you have some analysis tools to help you visualize your data you have a bar chart which shows you your totals per cost type you have a donut chart to give you the divisions from the totals of each type and you have a line chart showing your cost trend over time this template comes with slicers to help you better tailor your charts above we have a timeline slicer so you can filter by date then we have slicers which allow you to filter based on failure type and issue that's all for this template if you want to automate your xl 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