PLEASE ONLY ANSWER PART 2! Susans Consulting Company (SCC) - Problem Overview

Susans Consulting Company (SCC) has been in business for ten years and has experienced a significant turnover in the project management group, which has prompted senior leadership to investigate.

A preliminary review by senior leadership has determined that Project Managers are frustrated with the amount of required project management documentation, which has impacted their ability to manage projects successfully.

A recent review of the project management process has determined that SCC has spent between 30-40% of its total project budget on projects' overhead costs to include project management costs. A review of industry standards is between 5-15% higher than most companies. In addition, senior leaders found that projects are being delivered between 25% and 50% over budget and late 95% of the time.

Note: Project Management overhead includes the PM's time managing the project, attending meetings, and developing the required documentation.

SCC Request:SCC has reached out to your team because you are experts in defining project management processes and delivering projects on time. The SCC request includes the following:

• The development of a new project management process which at a minimum should include the following:
• • The ability to track issues, risks, changes
  • The ability to view project activities consists of a view of what has been completed and what activities the team is working on over the next reporting period
  • The company must have a view into total life cycle project costs to include what has been spent to date, baseline budget, any changes to the budget, remaining budget, and cost of the project at completion
• In addition, to the new process request, SCC has a new project they need to complete by the end of the year with a limited budget and no project management staff.

Assignment

Part 2: Project Description

• Project Description: Develop algorithm(s) to monitor user activity on the internet, the algorithms should work on the following applications used by the business today.
  • Application A
  • Application B
  • Application C
  • Application X
  • Application Y
  • Application Z
• Project Costs:

Given the critical nature of the project, the company has provided the following information in terms of cost for each application.

• Year 0 is the projected cost the company has estimated for the build of the component. This includes a 15% overhead cost for project management work
• Year 1-Year 5 is the amount of revenue the company has estimated for the product
• The Acceptable Rate of Return for all projects with the company is 10%

Application Application A Year 0 4 2 3 4 5 Total Nominal Amount $ (1,75,000.00) $ 50,000.00 $ 55,000.00 $ 60,500.00 $ 56,550.00 $ 73,205.00 Acceptable Rate of Return 10% 5 Present Value 6 Pay Back Period Net Present Value 8 Internal Rate of Return 10 Application Application B 11 Year 0 1 2 3 4 5 Total 12 Nominal Amount $ 1,20,000.00) $ 60,000.00 $ 66,000.00 $ 72,600.00 $ 79,860.00 $ 87,846.00 13 Acceptable Rate of Return 10% 14 Present Value 15 Pay Back Period 16 Net Present Value 17 Internal Rate of Return 18 19 Application Application C 20 Year 0 2 3 4 5 Total Colum 21 Nominal Amount $ (2,00,000.00) $ 65,000.00 $ 71,500.00 $ 78,650.00 $ 86,515.00 $ 95,166.50 22 Acceptable Rate of Return 10% 23 Present Value 24 Pay Back Period 25 Net Present Value 26 Internal Rate of Return 27 28 Application Application X 29 Year 0 2 3 4 5 Total Colum 30 Nominal Amount $ (1,50,000.00) $ 60,000.00 $ 63,000.00 $ 66,150.00 $ 69,457.50 $ 72,930.38 31 Acceptable Rate of Return 10% $ 32 Present Value 33 Pay Back Period 34 Net Present Value 35 Internal Rate of Return 36 37 Application Application Y 38 Year V 0 A 2 3 4 5 Total Colum 39 Nominal Amount $ (2,20,000.00) $ 40,000.00 $ 48,000.00 $ 57,600.00 $ 59,120.00 $ 82,944.00 40 Acceptable Rate of Return 10% 41 Present Value 42 PayBack Period 43 Net Present Value 44 Internal Rate of Return 45 46 Application Application 47 Year 0 2 3 4 5 Total Colum 48 Nominal Amount $ (2,20,000.00) $ 40,000.00 $ 48,000.00 $ 57,600.00 $ 69,120.00 $ 82,944.00 49 Acceptable Rate of Return 10% 50 Present Value 51 PayBack Period 52 Net Present Value 53 Internal Rate of Return