See the file it has the question.
I need a report, 6 pages including your analysis (for 3 years), graphs interpretation, and your conclusions and recommendation to WMATA.
Please use the Excel Sheet to Write your Analysis and get the graphs.
Read it carefully and Answer the Deliverable part. It is down here.
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:
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.
0 comments