USD Pert Method on Excel Case Study
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
USD Pert Method on Excel Case Study
RISK ANALYSIS CASE ESTABLISHING A PERFORMANCE MANAGEMENT OFFICE
Introduction
An individual was recently hired as an organization’s new Chief Information Officer (CIO). This is a large IT organization, and has two sites of about 50 people each where software is developed continuously throughout the year. Much of this software is enhancements to reflect changing government regulations, laws, company policies, and customer requirements, and much of this software is new development. The IT organization also has cybersecurity, hardware, and help desk components. After being in the office for a few weeks, he realizes that although the IT team is very talented in their technology, the operation of the business side of the IT organization needs significant improvement.
USD Pert Method on Excel Case Study
The CIO wants to consider establishing a Performance Management Office (PMO). This office would be tasked to measure the return on investment of IT investments, to measure the quality of software, to perform internal audits to ensure that software development money is being spent wisely, measure productivity rates of project teams, measure the CIO’s contribution to the organization’s Strategic Plan, collect and publish IT statistics, etc. The proposed organization will include a PMO manager, a senior Operations Research (Analytics) Analyst, a senior Business Case/Financial Analyst, and an experienced Admin Assistant. The purpose of this case study is to recommend to the CIO a 95% confidence interval for the first year costs of running the kind of PMO he is considering. Assume that the PMO people needed have been identified from the parent organization and would start together at the start of the calendar year.
When building the risk analysis model, assume that all probabilistic costs are modeled by the PERT method.
Office Space
Existing organizational office space will be used, so there will be no expense incurred for this.
Salaries
Those forming the PMO would retain their current salaries. The PMO manager salary is $160,000, the Operations Research Analyst salary is $145,000, the Business Case/Financial Analyst salary is $130,000, and the Admin Assistant salary is $85,000. The Admin Assistant is senior to the position and may leave the PMO due to promotion at any time after the PMO is started up. The replacement salary could run anywhere between $67,500 and $82,500. Staff performance awards are expected to be $8300, with a range of between $6000 and $9000.
Travel Expenses
There are two software development sites. One is on the main property of where the PMO will be located, and the other is about 100 miles away. There is a standard automobile mileage rate, which is $.465 per mile. There is a daily per diem travel expense of $172 for that location which includes meals, personal items, and hotel room. The PMO Manager probably will make between 7 and 12 trips to the offsite location, expecting to make 10 trips. These trips will take an average 3 days each. The Operations Research Analyst will make between 5 and 10 trips to the off-site location, expecting to make 6; these should average 2 days each. The Business Case/Financial Analyst probably will make between 5 and 10 trips to the off-site location, expecting to make 7; these trips should average 2 days each. The Admin Assistant is not expected to make any trips to the off-site location.
Training/Conferences
All organizational employees are expected to attend about two weeks of conference or training session annually for professional development. These are usually out of town. Although there may be multiple sessions to take up all or most of the two weeks, each session should cost (tuition/conference fees) an average of $2200. Travel expenses (air fare, taxi, etc.) average $550 per trip. Trip lengths should average 5 days. The PMO Manager will take between 0 and 2 sessions, most likely taking 2. The Operations Research Analyst will take either 1 or 2 sessions, expecting to take 2; the same goes for the Business Case/Financial Analyst. The Admin Assistant will usually obtain professional development locally, with a travel reimbursement of $14 for each leg of the trip each day. Therefore, there is no other per diem expense incurred. Tuition/conference fees should average $1850. The number of sessions should be 2. The number of days per session should run 2 days.
New Software
Several version of a new software type are currently being tested, and will be bought during the forecast year. Each version will be installed at 4 seats in the PMO, and costs range from a low of $450, to a high of $1000, with an expected cost of $650.
USD Pert Method on Excel Case Study
Requirements
- Recommend to the CIO a 95% confidence interval for the first year costs of running the kind of PMO his is considering. Develop a spreadsheet showing all logic and calculations.
- Also explain why this probabilistic approach was used instead of the traditional single estimate for each line item and the added value it brings.
- I Need two documents. One is the Excel spreadsheet with forecast model, and the second is a Word file with the answer to question 2 and any further explanatory material for the model. Explain your decision(s) on how to interpret any “gray areas” in the model.
- USD Pert Method on Excel Case Study
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow
USD Pert Method on Excel Case Study
USD Pert Method on Excel Case Study