DAD_220_5_2_Casey_Jackson

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

DAD-220-X3

Subject

Mechanical Engineering

Date

Dec 6, 2023

Type

docx

Pages

3

Uploaded by KidFogVulture23

Report
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? i. Fuel Tank with 95 repairs, Tire Repair with 74 repairs, and Tire replacement with 66 repairs. b. Is there a region of the country that experiences more part failures and replacements than others? i. Identify region: 1. MIDWEST region with 260 repairs. ii. How might the fleet maintenance team use the information to update its maintenance schedule?
1. The fleet team has the option to pre-order a part in advance for the region with the most repairs needed, which would result in a time savings. c. Which parts are being replaced most due to corrosion or rust? i. Wheel Arch has been replaced the most. d. Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield? i. Tire repairs are being replaced the most. 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. The Mid-West region accounted for the highest number of repairs, totaling 260 in all. Among these, the most frequent repair involved the fuel tank, with 95 instances, followed by tire repairs at 74. Additionally, common repairs included those for the wheel arch, fender replacement, and rocker panel. 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? SELECT repair AS part_repair, COUNT(*) AS number_of_repairs FROM Parts_Maintenance GROUP BY part_repair ORDER BY number_of_repairs DESC; SELECT "SOUTHWEST" AS REGION, COUNT(*) AS number_of_repairs FROM Parts_Maintenance WHERE UPPER(state) IN ('AZ' 'NH', 'TX', 'OK') 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 "SOUTHEAST" AS REGION, COUNT(*) AS number_of_repairs FROM Parts_Maintenance WHERE UPPER(state) IN ('AR', 'LA', 'MS', 'AL', 'GA', 'FL', 'KY', 'TN', 'SC', 'NC', 'VA', 'WV', 'DE', 'MD') ELECT "MIDWEST" AS REGION, COUNT(*) AS number_of_repairs
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