Question about Reliability, Availability, and Maintainability (RAM)

Business Finance

BogdanCauff

Question Description

check the file the attached file to read the Question

Read it carefully and Answer the Deliverable part.

I need a report, 6 pages including your analysis, graphs interpretation, and your conclusions and recommendation to WMATA.

Please use the Excel Sheet to Write your Analysis and get the graphs.

Unformatted Attachment Preview

WMATA hired you to complete TO-3. WMATA has hired you to perform a reliability and cost analysis to the rapid bus system with a fleet size of 1,200 units. WMATA provided you the following information for the past fiscal year (FY), to be used as the baseline for your analysis: I. Fleet Information The fleet has 1,200 units, all placed in service in a similar time, i.e., the useful life is considered within the same range. The availability of the units is between 95% to 99% per month, i.e., between 1,140 and 1,188 units are in-service simultaneously. The average traveling per unit is 5,500 miles/month, +/-500 miles/month. You as a consultant recommended WMATA to consider the miles traveled as a normal distribution, and WMATA accepted the recommendation as the assumption to conduct your analysis. WMATA also mentioned they monitor the speed limits and the minimum and maximum limits are 5 mph and 30 mph, respectively, per the WMATA’s policy. II. Reliability, Availability, and Maintainability (RAM) 1. Reliability - Performance Data WMATA provided to you the reliability data for the baseline fiscal year. Based on the data provided, 198 was the maximum failures in month-6, while the minimum failures they have repair were 95 failures in month-11. Based on a long-term historical database, the failures (average) are between 75-200 failures/month. Other formation provided include number of vehicles per month, the miles traveled, and the Mean Distance Between Failure (MDBF). 1 Fleet Size (No. of Vehicles) 1,108 2 1,109 5,469 6,065,432 198 30,633 3 1,126 5,916 6,661,622 97 68,677 4 1,092 5,670 6,191,872 102 60,705 5 1,093 5,222 5,707,557 103 55,413 6 1,086 5,440 5,907,664 199 29,687 7 1,131 5,161 5,837,128 124 47,074 8 1,145 6,078 6,959,615 147 47,344 9 1,135 5,314 6,031,343 179 33,695 10 1,164 6,005 6,989,551 174 40,170 11 1,166 6,098 7,110,262 95 74,845 12 1,085 5,906 6,408,504 97 66,067 FYI-1 Month Miles traveled per vehicle Fleet-miles Failures per moth MDBF 5,601 6,205,414 158 39,275 2. Maintainability The maintenance policy includes scheduled/planned maintenance and corrective/reactive maintenance, both categorized as preventive maintenance (PM) and corrective maintenance (CM). PM activates are a function of the fleet size in operation, while the CM activities are a function of the failure’s occurrence. The PM and CM cost for the baseline fiscal year were $1,500 and $2,750 per activity, respectively. WMATA mentioned you as the consultant that the PM meantime to repair (MTTR) is 4 hours +/- 1 hour, and the CM MTTR is 8 hours +/- 2 hours. The PMs are conducted quarterly, so normalize the preventive maintenance cost using a 0.25 factor. 3. Availability WMATA mentioned to you that the KPI (Key Performance Indicator) scorecard includes the availability metric, and that the goal is 98% average. This should be considered as part of your analysis. III. Deliverables WMATA is preparing the operational budget proposal for the next three fiscal years to be presented to the multiple jurisdictions approving it, i.e., DC, MD, VA, and the FTA (Federal Transit Administration). WMATA task order includes the following deliverables: 1. Develop a model considering the variables mentioned in sections 1 and 2 to forecast the budget needs for the next three fiscal years (i.e., three replications of the model). WMATA wants to see the result with at least three main plots: • Plot#1: Forecasted MDBF and AMDBF vs. the goal (over 40,000 miles between failure). • Plot#2: Forecasted availability vs. availability goal (98.5%). • Plot#3: Forecasted Maintenance cost. 2. An executive summary (you can include a table) with no more than 4 paragraphs including the results summary per year (three years) including the forecasted maintenance cost, availability and MDBF. Compare against the goals and provide any explanation if values are not as expected (e.g., below the goal, outlier, other). 3. A list of the underlying assumptions used to develop the model. The intention is to inform the stakeholders from the different jurisdiction about the model. 4. Provide a list of recommendations to improve reliability and availability, and to reduce maintenance cost. The recommendations shall be based on the analysis. 5. Submit the model (MS-Excel) worksheet and your report including your analysis, graphs interpretation, and you conclusions and recommendation to WMATA. 2 RELIABILTY FYI-1 Month Fleet Size (No. of Vehicles) Miles traveled per vehicle 1 2 3 4 5 6 7 8 9 10 11 12 1155 1155 1157 1144 1148 1156 1188 1170 1152 1160 1147 1164 6209,68 5863,61 4835,67 5876,35 5518,20 5926,70 5217,66 5760,52 5699,72 4792,79 5143,42 5680,82 Fleet-miles Failures per moth 7172178,28 6772471,63 5594874,40 6722548,96 6334891,78 6851267,40 6198578,63 6739813,65 6566074,73 5559641,33 5899505,61 6612469,32 163 117 200 189 194 137 155 157 163 103 142 170 RELIABILTY UPTIME MDBF AMDBF 44001,09 57884,37 27974,37 35569,04 32654,08 50009,25 39990,83 42928,75 40282,67 53977,10 41545,81 38896,88 44001,09 50942,73 43286,61 41357,22 39616,59 41348,70 41154,72 41376,47 41254,94 42527,16 42437,94 42142,85 DOWNTIME Time Traveled (HRS) MTTR-PM (HRS) MTTR-CM (HRS) 478145,22 615679,24 233119,77 1120424,83 791861,47 428204,21 295170,41 224660,45 252541,34 277982,07 294975,28 330623,47 2164,13 4751,93 4112,33 3843,56 4602,51 6538,65 5068,42 4861,04 3172,54 4624,91 3571,34 3775,20 1306,493085 427,9693385 1691,076189 1411,158485 2580,761488 1217,756564 1557,442507 1015,469915 1642,8111 613,51792 480,3376684 1248,612375 AVAILABILITY A(t) 99,28% 99,17% 97,57% 99,53% 99,10% 98,22% 97,80% 97,45% 98,13% 98,15% 98,65% 98,50% MAINTENANCE COST Cost-PM Cost-CM Total CM(%) $433.125 $433.125 $433.875 $429.000 $430.500 $433.500 $445.500 $438.750 $432.000 $435.000 $430.125 $436.500 $448.250 $321.750 $550.000 $519.750 $533.500 $376.750 $426.250 $431.750 $448.250 $283.250 $390.500 $467.500 $881.375 $754.875 $983.875 $948.750 $964.000 $810.250 $871.750 $870.500 $880.250 $718.250 $820.625 $904.000 50,86% 42,62% 55,90% 54,78% 55,34% 46,50% 48,90% 49,60% 50,92% 39,44% 47,59% 51,71% Fleet Size 1200 Availability Fleet Availability Mile Distribution Average Standard Dev. 95% 1140 Normal 5550 500 Miles/Month Miles/Month Time Traveled Min Velocity Max Velocity 5 30 Mph Mph Faailures Minimum Maximum 75 200 Failures/Months Failures/Months MTTR PM Distribution Average Standard Dev. Normal 4 1 Hrs Hrs Normal 8 2 Hrs Hrs 1500 2750 /bus /failure CM Distribution Average Standard Dev. Maintenance Cost PM Cost CM Cost 99% 1188 ...
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions
Related Tags