DAD 220 Analysis and Summary Template (Sneed)

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Mechanical Engineering

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by ChefHeatAardvark16

DAD 220 Analysis and Summary Template Replace the bracketed text in this template with your responses and any supporting screenshots. Then submit it to the Module Five Activity for grading and feedback. Rename this document by adding your last name to the file name before you submit. 1. Analyze the data you’ve been provided with to identify themes : a. Which parts are being replaced most? Based on the screenshot above, the most parts being replaced are the Fuel Tank with 95, Tire Repair with 74 and Tire Replacement with 66. b. Is there a region of the country that experiences more part failures and replacements than others? i. Identify region:

Based on the screenshot above, the region with the most part failures is the Midwest with 260, followed by the Northeast with 208. ii. How might the fleet maintenance team use the information to update its maintenance schedule? 1. Given that the Midwest has the greatest number of repairs, the fleet maintenance team might utilize this information to change their maintenance schedule and send more personnel, parts, and resources there. They could also arrange for additional regular maintenance and inspections. This could assist in spotting any problems early on and avoid further repairs and component failures. c. Which parts are being replaced most due to corrosion or rust?

Based on the screenshot above, the parts being replaced most due to corrosion or rust is the Wheel Arch with 55, Fender Replacement with 54 and the Rocker Panel with 53. d. Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield? Based on the screenshot above, the parts being replaced due to mechanical failure or accident like a flat tire or rock through the windshield are Tire Repair with 74, Tire Replacement with 66, and Windshield Replacement with 63.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

2. Write a brief summary of your analysis that takes the information from Step 1 and presents it in a way that nontechnical stakeholders can understand. a. I discovered some information that is crucial for the business to comprehend the main problems and the areas on which they should concentrate most of their resources after reviewing all the data beginning at step 1. According to the data I've found, it's evident that the fuel tank needs to be changed the most. This information is useful for the company to know because it allows them to investigate the reasons behind the fuel tanks' frequent problems and potential solutions. Furthermore, according to my research, most repairs take place in the Midwest, which benefits the business by allowing them to allocate more specialists and repair parts to that area, speeding up services and lowering wait times for parts and repairs. I also discovered that, while not the most common repair, tire-related difficulties rank higher than other problems since they are most frequently caused by mechanical or accident failure, indicating a larger need for more frequent and thorough tire care. With this knowledge, the organization will be better equipped to handle any problems that may arise in the future and more effectively deploy its resources. 3. Outline the approach that you took to conduct the analysis. a. What queries did you use to identify trends or themes in the data? i. To find out what items required replacement most often, I executed the following command: SELECT repair AS PART_REPAIR, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance GROUP BY PART_REPAIR ORDER BY NUMBER_OF_REPAIRS DESC; ii. I utilized the following command to identify the area requiring the frequent maintenance: SELECT 'SOUTHWEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(state) IN ('AZ','NM','TX','OK') UNION SELECT 'SOUTHEAST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(state) IN ('AR','LA','MS','AL','GA','FL','KT','TN','SC','NC','VA','WV','DE','MD') UNION SELECT 'NORTHEAST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(state) IN ('PA','NJ','NY','CT','RI','MA','VT','ME','NH') UNION SELECT 'MIDWEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(state) IN ('ND','SD','KS','NE','MN','WI','IA','MO','MI','IN','IL','OH') UNION SELECT 'WEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(state) IN ('WA','ID','MT','OR','WY','CO','UT','NV','CA') ORDER BY NUMBER_OF_REPAIRS DESC;

iii. Using this command, I was able to find the parts that needed most frequent repairs because of rust or corrosion: SELECT repair AS PART_REPAIR, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(reason) IN ('CORROSION','RUST') GROUP BY PART_REPAIR ORDER BY NUMBER_OF_REPAIRS DESC; iv. Finally, I used this command to show the total number of fixes needed due to mechanical failures or accidents: SELECT repair AS PART_REPAIR, COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts_Maintenance WHERE UPPER(reason) LIKE '%FLAT%' OR UPPER(reason) LIKE '%CRACK%' GROUP BY PART_REPAIR ORDER BY NUMBER_OF_REPAIRS DESC; b. What are the benefits of using these queries to retrieve the information in a way that allows you to provide valuable information to your stakeholders? i. Using these queries to obtain information for the stakeholders has many advantages. To begin with, the organization can be prepared by keeping more stock of the goods they use frequently by using some of the commands I mentioned above to educate them about their most frequently fixed parts. By understanding which areas are more likely to require more maintenance, having this knowledge additionally lets them plan more regionally as it enables them to schedule more technicians and resources in advance. With this knowledge, they may operate more effectively and improve their process by making more informed and proactive decisions based on a deeper understanding of the information at their disposal. 4. Explain how the functions in the analysis tool allowed you to organize the data and retrieve records quickly. a. I was able to swiftly locate the records I wanted and organize all of my findings thanks to the analysis tool’s functions. This contributed to the process's increased efficiency. I repeatedly used the "SELECT" query to obtain information relevant to my search, ensuring prompt response speeds and effective displays of all the data. I arranged my data using the "GROUP BY" function according to the part titles, which made it simpler to display a lot of data in a compact style.