DAD 220 Module 5-2 Analysis and Summary Golda Smith

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Mechanical Engineering

Date

Feb 20, 2024

Type

docx

Pages

3

Uploaded by DeaconSwanPerson697

Report
DAD 220 Analysis and Summary Template DAD 220 Professor Brian Myers Golda Smith 24 November 2022 1. Analyze the data you’ve been provided with to identify themes : a. Which parts are being replaced most? i. The part that is being replaced the most is fuel tank. It had the most repairs at 95. This is followed by tire repair at 74 repairs and tire replacement at 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 maintenance team would use this information to ensure they have the appropriate number of supplies and the correct staffing to support with the various repairs. They would want to allocate more resource to areas with higher repairs. As the maintenance team, they may also want to consider scheduling more maintenance follow ups in areas with higher repairs to take more preventative actions. c. Which parts are being replaced most due to corrosion or rust? i. Wheel arch is being replaced the most due to corrosion or rust. It has 55 repairs. This is followed by fender replacement with 54 repairs and rocker panel with 53 repairs. d. Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield? i. Tire repair is being replaced the most with 74 repairs, then tire replacement at 66 repairs, and windshield replacement at 63 repairs. 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 West and Southwest regions have the least number of repairs and the Midwest and Northeast have the highest amount. When allocating resources to handle repairs, the Midwest and Northeast would need more than the West and Southwest. To support the higher number of repairs, more supplies/equipment, staffing, and possibly training of staff would be necessary.
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. I utilized UNION query to join multiple code statements together to receive data that is easier to read and understand. I used this query to look at the number of repairs in the region. 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. One benefit includes being able to access information regarding the number of repairs in each region. This allows for easier decision making and comparison. Another benefit is allowing easier analysis of the type of repairs that each region is experiencing in order to formulate a plan of action around fixing the repairs. 4. Explain how the functions in the analysis tool allowed you to organize the data and retrieve records quickly. a. The functions in the analysis tool allowed me to pull specific information regarding certain repairs and location of repairs. I was able to determine which regions experienced the most repairs. It also allowed me to locate specific repair results.
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