act5

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 DrTarsierPerson1021

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? b. Fule tank | 95 | c. | Tire repair | 74 | d. | Tire replacement | 66 | e. | Windshield replacement | 63 | f. | Battery replacement | 56 | g. | Wheel Arch | 55 | h. | Fender replacement | 54 | i. | Rocker Panel | 53 | j. | Brake line replacement | 52 | k. | Struts | 51 | l. | Cab corner panel | 49 | m. | Shocks | 47 | n. | Dent Repair Left Fender | 37 | o. | Transmission | 28 | | Dent Repair Rear p. Is there a region of the country that experiences more part failures and replacements than others? i. Identify region: 1. Midwest ii. How might the fleet maintenance team use the information to update its maintenance schedule? The fleet maintenance team could use this information by updating its scheduling for maintenance and identifying the higher volume regions and parts needed for each region by the volume of repairs in the five regions across the country. The data should show more need for fuel tanks and customer service agents. The fleet maintenance team should have more repair stations and technicians in the Midwest than any other region. The data should point out a course of action to maximize what parts are needed to buy and help with inventory control levels. q. Which parts are being replaced most due to corrosion or rust? i. Wheel arch, fender replacement, rocker panel and brake line replacement r. Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield? i. I could not find a command that worked for mechanical failure, tire replacement is 73 and windshield replacement is 64. 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.
The data maintenance shows that the Mid-West Region has the most vehicle repairs, with the fuel tank being replaced as the most frequently needed part. The data shows that rust and corrosion plays a significant part of the fuel tanks life cycle. This makes sense because of the amount of precipitation that the Mid-West gets on a yearly basis. With this being said, keep a more extensive inventory of fuel tanks and maintain more customer service technicians so that customers can receive the service needed to get back on the road faster and go about their normal day-to-day activities. 3. Outline the approach that you took to conduct the analysis. What queries did you use to identify trends or themes in the data? UPDATE PartsMaintenance SET Region = 'Southwest' WHERE State = 'AZ' OR State = 'NM' OR State = 'TX' OR State = 'OK'; UPDATE PartsMaintenance SET Region = 'Southeast' WHERE State = 'AR' OR State = 'LA' OR State ='MS' OR State = 'AL' OR State ='GA' OR State ='FL' OR State = 'KY' OR State = 'TN' OR State = 'SC' OR State = 'NC' OR State = 'VA' OR State = 'WV' OR State ='DE' OR State= 'MD'; UPDATE PartsMaintenance SET Region = 'Northeast' Where State = 'PA' OR State ='NJ' OR State ='NY' OR State ='CT' OR State ='RI' OR State ='MA' OR State ='VT' OR State ='NH' OR State ='ME'; UPDATE PartsMaintenance SET Region = 'Midwest' Where State = 'ND' OR State ='SD' OR State ='SD' OR State ='KS' OR State ='NE' OR State ='MN' OR State ='WI' OR State ='IA' OR State ='MO' OR State ='MI' OR State ='IN' OR State ='IL' OR State = 'OH'; UPDATE PartsMaintenance SET Region = 'West' WHERE State = 'Wa' OR State ='ID' OR State ='MT' OR State='WY' OR State='CO' OR State ='UT' OR State ='NV' OR State ='CA'; SELECT repair as PART_REPAIR, Count(*) AS NUMBER_OF_REPAIRS FROM PartsMaintenance WHERE UPPER (reason) in ('CORROSION', 'RUST') GROUP BY Part_Repair ORDER BY COUNT(Repair) DESC; SELECT repair as PART_REPAIR, Count(*) AS NUMBER_OF_REPAIRS FROM PartsMaintenance
WHERE UPPER (repair) in ('TIRE REPAIR', 'WINDSHIELD REPLACEMENT') GROUP BY Part_Repair ORDER BY COUNT(Repair) DESC; SELECT Region, COUNT(Repair) AS MOST_FREQUENT PartsMaintenance GROUP BY Region ORDER BY COUNT(Region) DESC; 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? The results of these queries show precisely where the stakeholders needed to spend their resources to maintain inventory and labor costs and maintain customer service levels. The data will allow them to make any adjustments as needed. I can show a visual and practical approach to their business model to help increase profits and productivity and maintain customer satisfaction. 4. Explain how the functions in the analysis tool allowed you to organize the data and retrieve records quickly. a. Using the query commands, I could show the stakeholders an accurate world snapshot of their business model and specific examples of what is needed in each region to increase profits. Displaying the data in a way a nontechnical person understands will allow them to adjust based on the data rather than intuition or hypotheticals. Making decisions based on factual data will allow them to make prudent decisions with increased confidence to assist the overall decision-making process.
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