answer the case study on management department


intro to bussiness

American College of California

Question Description

the case study need two files word and excel .

i will attached the case study with the instructions .

Unformatted Attachment Preview

THE CATHOLIC UNIVERSITY OF AMERICA School of Engineering Engineering Management Department CMGT 575-Systems Analysis Final Case Study Spring 2020 Sections 01 (On campus) and 02 (Online) Lecturer - José R. Febres Name: _________________________________ Date: __________________ Examination Rules and Instructions: 1. The case study is OPEN SOURCE; you may use any source of information available. 2. The analysis must be the result of your own effort, and no other person must contribute to your answers and/or research to answer the questions in case study. 3. There is no standard format for the final document but make sure you treat this case study as a professional technical report. 4. Make sure to include any analysis, tables, spreadsheets as part of your report. 5. Make sure to provide any reference when you cite work performed and/or published by others. 6. Include this first page as the second page of your report (after the front page) with your name, date, and signature. I pledge on my honor that I have not given or received any unauthorized assistance on this examination. Signature: _________________________________ Evaluation Rubric: Criterion Wt (%) Content and Context 70% Organization 20% Grammar 10% Novice 50%: Two or more required elements of the question missing or not fully addressed. 50%: Answers not clearly organized; contains several logical errors. 50%: Major grammar or spelling errors or contains significant grammar errors. Level of Achievement Competent 75%: Answers organized but may contain one minor logical argument error. Proficient 100%: All required elements of question addressed fully and clearly. 100%: Answer clearly organized and contains no logical argument errors. 75%: Multiple minor grammar or spelling errors. 100%: 5 or fewer grammar or spelling errors. 75%: One required element of question missing or not fully addressed. 1 THE CATHOLIC UNIVERSITY OF AMERICA School of Engineering Engineering Management Department After two successful analyses (Task Orders 1 and 2), 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 THE CATHOLIC UNIVERSITY OF AMERICA School of Engineering Engineering Management Department 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 jurisdiction 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 (no more than 7 pages including the graphs) including your analysis, graphs interpretation, and you conclusions and recommendation to WMATA. 3 ...
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