Question: Week 7 Exercise Make a check sheet (simply count the number of occurrences for each type of repair and put them in a table) and

Week 7 Exercise

Make a check sheet (simply count the number of occurrences for each type of repair and put them in a table) and then a Pareto chart for the following car service repair shop data. Please note that there is a total of 30 repairs, called Work (each one with its own ticket number). Do your calculations in Excel and submit your complete file including the chart.

Ticket Ticket Ticket No. Work No. Work No. Work 1 Tires 11 Brakes 21 Lube & oil 2 Lube & oil 12 Lube & oil 22 Brakes 3 Tires 13 Battery 23 Transmission 4 Battery 14 Lube & oil 24 Brakes 5 Lube & oil 15 Lube & oil 25 Lube & oil 6 Lube & oil 16 Tires 26 Battery 7 Lube & oil 17 Lube & oil 27 Lube & oil 8 Brakes 18 Brakes 28 Battery 9 Lube & oil 19 Tires 29 Brakes 10 Tires 20 Brakes 30 Tires

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please show Excel formulas and any other necessary calculations. Make a check sheet (simply count the number of occurrences for each type of repair and put them in a table) and then create a Pareto...

Hello! Please send pictures of the excel file and the calculations done. Thank you in advance! Make a check sheet (simply count the number of occurrences for each type of repair and put them in a...

Make a check sheet (simply count the number of occurrences for each type of repair and put them in a table) and then a Pareto chart for the following car service repair shop data. Please note that...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

Please help with the following in excel or something similar. I am very lost and what like to see how to do this. Please explain so I can understand this in further instructions. There are four...

1. What is ERP architecture? And what is necessary for ERP implementations to be Successful? 2. List 5 types of major functional modules of ERP and explain why it is necessary to have Good enterprise...

Preeti bought 8 kg of sugar for 242 Find the price of sugar per kg. 2. 4 If the cost of a notebook ie 7 27 how r

Exercise 3.12 Floating-point multiplication is even more complicated and challenging than fl oating-point addition, and both pale in comparison to fl oating-point division. A B a. 5.66015625 x 100...

11.15 Management has stated that it will tolerate one stockout per year. The forecast of annual demand for a particular SKU is 100,000 units, and it is ordered in quantities of 10,000 units. The lead...

2. What types of information are we collecting?

5. How quickly can we manage to collect the information?

3. Tactical/strategic information.