act5
docx
keyboard_arrow_up
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
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
Related Documents
Related Questions
I need answers to questions 1, 2, and 3 pertaining to the print provided.
Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.
arrow_forward
I need answers to problems 7, 8, and 9.
NOTE: Please stop wasting my time and yours by rejecting my question because it DOES NOT REQUIRE YOU TO DRAW anything at all. They are simple questions pertaining to the print provided. READ THE INSTRUCTIONS of the assignment before you just reject it for a FALSE reason or leave it for someone to answer that actually wants to do their job. Thanks.
arrow_forward
The first photo is the question, where the 2nd shows some problem solving strategies
arrow_forward
Help me solve this ENGINEERING GRAPHICS question
Use 0.25 cartesian paper or 0.25 Isometric paper please.
arrow_forward
Please solve the following parts a) b) c) and show the detail work for each part.
arrow_forward
I asked for problems 6 and 7 to be answered, but I did not get a properly structured answered as the example shows on problem number 1. Here is the link to the questions I already had answered, could you please rewrite the answer so its properly answered as the example shows (Problem 1)?
https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/cadc3f7b-2c2f-4471-842b-5a84bf505857
arrow_forward
I need answers for problems 13, 14, and 15 pertaining to the print provided.
NOTE: If you refuse to answers all 3 parts and insist on wasting my question by breaking down 1 simple question into 3 parts, then just leave it for someone else to answer. Thank you.
arrow_forward
Directions: modify the standard SolidWorks ANSI B Landscape layout for your own engineering
consulting company. Include a logo, change the legal notice, and make other changes as you see fit.
Be creative! Save this as a SolidWorks drawing layout template and use in subsequent submissions.
Usual DRAWN BY.
Deliverable: screenshot of your personalized layout/template without any drawings on it.
arrow_forward
I need answers to questions 13, 14, and 15 pertaining to the print provided.
Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.
arrow_forward
Job costing and process costing are two primary costing systems used in a workshop environment. Provide a brief explanation of each, including the key differences between these two systems
key differences between these two systems. (50-80 words)
arrow_forward
Draw it on the graph provided please!
arrow_forward
You are assigned as the head of the engineering team to work on selecting the right-sized blower that will go on your new line of hybrid vehicles.The fan circulates the warm air on the inside of the windshield to stop condensation of water vapor and allow for maximum visibility during wintertime (see images). You have been provided with some info. and are asked to pick from the bottom table, the right model number(s) that will satisfy the requirement. Your car is equipped with a fan blower setting that allow you to choose between speeds 0, 1,2 and 3. Variation of the convection heat transfer coefficient is dependent upon multiple factors, including the size and the blower configuration.You can only use the following parameters:
arrow_forward
You are a biomedical engineer working for a small orthopaedic firm that fabricates rectangular shaped fracture
fixation plates from titanium alloy (model = "Ti Fix-It") materials. A recent clinical report documents some problems with the plates
implanted into fractured limbs. Specifically, some plates have become permanently bent while patients are in rehab and doing partial
weight bearing activities.
Your boss asks you to review the technical report that was generated by the previous test engineer (whose job you now have!) and used to
verify the design. The brief report states the following... "Ti Fix-It plates were manufactured from Ti-6Al-4V (grade 5) and machined into
solid 150 mm long beams with a 4 mm thick and 15 mm wide cross section. Each Ti Fix-It plate was loaded in equilibrium in a 4-point bending
test (set-up configuration is provided in drawing below), with an applied load of 1000N. The maximum stress in this set-up was less than the
yield stress for the Ti-6Al-4V…
arrow_forward
Keep the same colors the same graph, basically keep everything the same just make the line with a small curve just as shown on the picture
Keep everything the same just make the line less curvy please do not change the colors of the line and the circles do not change anything besides the curve of the line.
Use this code on MATLAB and fix it.
% Sample data for Diesel and Petrol cars
carPosition = linspace(1, 60, 50); % Assumed positions of cars
% Use the 'seed' function instead of 'rng'
seed = 50; % Define your seed here
rand('seed',seed);
% Assumed CO2 emissions for Diesel and Petrol
CO2Diesel = 25 + 5*cos(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Diesel
CO2Petrol = 20 + 5*sin(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Petrol
% Fit polynomial curves with a reduced degree of 2
pDiesel = polyfit(carPosition, CO2Diesel, 2);
pPetrol = polyfit(carPosition, CO2Petrol, 2);
% Generate points for best fit lines
fitDiesel = polyval(pDiesel, carPosition);…
arrow_forward
I need parts 3 and 4 answered pertaining to the print provided.
I asked this question previously on here and I received the wrong answers to the 2 parts Im asking about, so I am reposting the question again to have another tutor answer it.
Part 3: I need to tell what was ommited.
Part 4: I need to tell what the triangle equals? Lower right or J1 zone has the answer.
arrow_forward
HRP
FRP
1. In isometric drawing, isometric lines are those that are parallel to any of the isometric axes.
Given below the Multiview drawing of an object, how many of the object's visible and hidden
edges are isometric in the isometric drawing?
a. 0
b. 7
c. 5
d. 6
2. Given the figure that shows front and top views of the object, how many of its visible and
hidden faces are isometric planes in the isometric drawing?
a. 4
b. 3
c. 5
d. 2
arrow_forward
LESSON: AUTODESK AUTOCAD
Choose from the choices:
arrow_forward
Do not give answer in image and hand writing
arrow_forward
Question 3
The activity relation chart for NOFRILLS departmental store in Richmond Hill is shown in the figure below.
The space requirements are in square feet. Construct the relationship diagram and develop a block layout
using the systematic layout planning (SLP) method. Your solution must include flow-between chart,
activity relationship chart, value chart, nodal relationship, block calculations, and grid representation, as
covered in class.
Dept A
400 (sq. ft)
0
Dept B
1,000
12
Dept C
2,600
Dept D
176 212
136 132
240 216 16
400
140 180
36
184
Dept E
144
172
2,400
220
188
108
20
Dept F
1,000
192
168
24
248
204
124
Dept G
3,600
228
112 156
120
Dept H
1,200
160
224
148
Dept I
152
400
108
200
Dept J
2,400
arrow_forward
Can someone please help to solve all of the following problem showing all work and include a load chart. Thank you!
arrow_forward
Hello I’m trying to make the graph that you see in the picture but I am having trouble on make the two lines that you see on the graph to over lap each other, I don’t want the two lines to be separate I want the two lines on top of eachother like you see in the picture please fix the code so that the Diesel line is on top of the Petrol line as seen on the picture.
% Sample data for Diesel and Petrol cars
carPosition = linspace(1, 60, 50); % Assumed positions of cars
% Fix the random seed for reproducibility
rng(45);
% Assumed positions of cars
CO2Diesel = 25 + 5*cos(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Diesel
CO2Petrol = 20 + 5*sin(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Petrol
% Fit polynomial curves
pDiesel = polyfit(carPosition, CO2Diesel, 3);
pPetrol = polyfit(carPosition, CO2Petrol, 3);
% Generate points for best fit lines
fitDiesel = polyval(pDiesel, carPosition);
fitPetrol = polyval(pPetrol, carPosition);
% Plotting the data
figure;
hold on;…
arrow_forward
I need help solving this problem.
arrow_forward
Please make the exact graph that you see in the picture, along with the graph are numbers that are data. Please make the exact graph do not make anything thing different, the blue and orange circles should be there and the lines should be the same including the titles. Please make sure everything is exactly the same. Use MATLAB, and send the code and please make sure no error signs comes up. Take your time please I need help.
arrow_forward
4. Documents business requirements use-case narratives.for only one process
note: please i want Documents like this in pic
arrow_forward
I need parts 1, 2, and 3 answered pertaining to the print provided.
NOTE: If you refuse to answers all 3 parts and insist on wasting my question, then just leave it for someone else to answer. I've never had an issue until recently one single tutor just refuses to even read the instructions of the question and just denies it for a false reasons or drags on 1 part into multiple parts for no reason.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
Related Questions
- I need answers to questions 1, 2, and 3 pertaining to the print provided. Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.arrow_forwardI need answers to problems 7, 8, and 9. NOTE: Please stop wasting my time and yours by rejecting my question because it DOES NOT REQUIRE YOU TO DRAW anything at all. They are simple questions pertaining to the print provided. READ THE INSTRUCTIONS of the assignment before you just reject it for a FALSE reason or leave it for someone to answer that actually wants to do their job. Thanks.arrow_forwardThe first photo is the question, where the 2nd shows some problem solving strategiesarrow_forward
- Help me solve this ENGINEERING GRAPHICS question Use 0.25 cartesian paper or 0.25 Isometric paper please.arrow_forwardPlease solve the following parts a) b) c) and show the detail work for each part.arrow_forwardI asked for problems 6 and 7 to be answered, but I did not get a properly structured answered as the example shows on problem number 1. Here is the link to the questions I already had answered, could you please rewrite the answer so its properly answered as the example shows (Problem 1)? https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/cadc3f7b-2c2f-4471-842b-5a84bf505857arrow_forward
- I need answers for problems 13, 14, and 15 pertaining to the print provided. NOTE: If you refuse to answers all 3 parts and insist on wasting my question by breaking down 1 simple question into 3 parts, then just leave it for someone else to answer. Thank you.arrow_forwardDirections: modify the standard SolidWorks ANSI B Landscape layout for your own engineering consulting company. Include a logo, change the legal notice, and make other changes as you see fit. Be creative! Save this as a SolidWorks drawing layout template and use in subsequent submissions. Usual DRAWN BY. Deliverable: screenshot of your personalized layout/template without any drawings on it.arrow_forwardI need answers to questions 13, 14, and 15 pertaining to the print provided. Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.arrow_forward
- Job costing and process costing are two primary costing systems used in a workshop environment. Provide a brief explanation of each, including the key differences between these two systems key differences between these two systems. (50-80 words)arrow_forwardDraw it on the graph provided please!arrow_forwardYou are assigned as the head of the engineering team to work on selecting the right-sized blower that will go on your new line of hybrid vehicles.The fan circulates the warm air on the inside of the windshield to stop condensation of water vapor and allow for maximum visibility during wintertime (see images). You have been provided with some info. and are asked to pick from the bottom table, the right model number(s) that will satisfy the requirement. Your car is equipped with a fan blower setting that allow you to choose between speeds 0, 1,2 and 3. Variation of the convection heat transfer coefficient is dependent upon multiple factors, including the size and the blower configuration.You can only use the following parameters:arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University PressMechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSONThermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
- Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEYMechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage LearningEngineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY