USD Pert Method on Excel Case Study
Order ID |
53563633773 |
Type |
Essay |
Writer Level |
Masters |
Style |
APA |
Sources/References |
4 |
Perfect Number of Pages to Order |
5-10 Pages |
Description/Paper 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.
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.
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.
RUBRIC
QUALITY OF RESPONSE |
NO RESPONSE |
POOR / UNSATISFACTORY |
SATISFACTORY |
GOOD |
EXCELLENT |
Content (worth a maximum of 50% of the total points) |
Zero points: Student failed to submit the final paper. |
20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. |
30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. |
40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. |
50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. |
Use of Sources (worth a maximum of 20% of the total points). |
Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. |
5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. |
10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. |
15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. |
20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. |
Grammar (worth maximum of 20% of total points) |
Zero points: Student failed to submit the final paper. |
5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors |
10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors |
15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. |
20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. |
Structure of the Paper (worth 10% of total points) |
Zero points: Student failed to submit the final paper. |
3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. |
5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper |
7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. |
10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper. |
|
|
GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
Also, you can place the order at www.collegepaper.us/orders/ordernow / www.phdwriters.us/orders/ordernow
|
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME]and Have It Done by Our PhD Qualified Writers!! |
|
|
PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!