Need help? We are here

# Whats this video https://youtu.be/C5o6U7zOebM A project manager is often tasked

Whats this video

A project manager is often tasked with reviewing different projects and choosing which project is best to pursue. To accomplish this task, a project manager would use different methods for project selection.

This assignment allows you to work through a few of these methods using Microsoft Excel.

2. Review the information provided in the Excel spreadsheet for choosing among the four project alternatives (labeled A, B, C, and D).  Each has been assessed according to four criteria:
1. Payoff potential
2. Lack of risk
3. Safety
3. Construct a project checklist model, using the Excel template, for screening these four alternatives.  Based on your model, which project is the best choice for your selection?  Why?  Which is the worst?  Why?
4. Create Scoring Model 1. Suppose the same information from the checklist in the first problem was supplemented by importance weights for each of the four assessment criteria, where 1 = low importance and 4 = high importance (see weights in the template). Assume, too, that evaluations of high received a score of 3, medium 2, and low 1. Create a scoring model (using the Excel template) and reassess the four project choices (A, B, C, and D). Now which project alternative is the best? Why?
5. Create Scoring Model 2.  Now assume that for Problem 3, the importance weight is altered (see weights in the template). How does this new information alter your decision? Which project now looks most attractive? Why? Base your response by filling in the graph within the Excel template.
6. Determine Discount Payback.  Your company is seriously considering investing in a new project opportunity, but cash flow is tight. Top management is concerned about how long it will take for this new project to pay back the initial investment of \$50,000. You have determined that the project should generate inflows of \$30,000, \$30,000, \$40,000, \$25,000, and \$15,000 for the next five years. Your firm’s required rate of return (or discount rate) is 15%. In what year are we able to pay back the initial investment? Respond based on filling in the graph within the Excel template.
7. Determine Net Present Value.  Assume that your firm wants to choose between two project options:
• Project A: \$500,000 invested today will yield an expected income stream of \$150,000 per year for 5 years, starting in Year 1.
• Project B: an initial investment of \$400,000 is expected to produce this revenue stream: Year 1 = 0, Year 2 = \$50,000, Year 3 = \$200,000, Year 4 = \$300,000, and Year 5 = \$200,000.

Assume that a required rate of return for your company is 10% and that inflation is expected to remain steady at 3% for the life of the project. Which is the better investment? Why? Respond based on filling in the graph within the Excel template.

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

Assignment Overview In this assignment, you will assess a current semi-direct or indirect nursing situation that is in need of change. Observe a healthcare environment,

### Assume that you are leading a staff development m

Assume that you are leading a staff development meeting on regulation for nursing practice at your healthcare organization or agency. Review the NCSBN and

### Case Study on Biomedical Ethics

Details: Write a 1,200-1,500 word analysis of “Case Study: Healing and Autonomy.” In light of the readings, be sure to address the following questions: Under

### Provide a description of the rationale and complexities that were

Provide a description of the rationale and complexities that were taken into account from the perspective of each company including the political, economic, socio-cultural, legal

### The DNP Project: Educating and Engaging Stakeholders Please discuss the

The DNP Project: Educating and Engaging Stakeholders Please discuss the importance of engaging and educating stakeholders on your quality improvement initiative. What is your

### Competency Analyze how Big Data and data collection from external sources can present opportunities for business intelligence. Instructions You work

CompetencyAnalyze how Big Data and data collection from external sources can present opportunities for business intelligence.InstructionsYou work for a tourism board at a top destination

### In many states, marijuana is now legal for certain medical

In many states, marijuana is now legal for certain medical purposes. What are your state’s laws regarding marijuana? Identify some clinical issues that may

### Part 1 (post this response in the main U2 DB

Part 1 (post this response in the main U2 DB thread “Unit 2 Discussion Board”)One common point of debate in law is whether laws should

### APA STYLE PLEASE AND REFERENCES AT THE END WITH IN TEXT CITATIONS 4 to 5 typewritten pages double spaced 12inch

APA STYLE PLEASE AND REFERENCES AT THE END WITH IN TEXT CITATIONS4 to 5 typewritten pages, double spaced, 12-inch font (can go up to 7

### Identifying the Ethical System You are an intern at an attorney’s

Identifying the Ethical System You are an intern at an attorney’s office and you have been asked to prepare a memo in response to the

### How would you select a test to measure vocational interests?

How would you select a test to measure vocational interests? How can the results of this test be used in working with your client? What

New questions

### HCI 314 The Principles of Public Health Informatics

Help me study for my Health & Medical class. I’m stuck and don’t understand. Describe the principles of public health informatics.

### Case Study: Havasupai Tribe vs. Arizona State University

Case Study: Havasupai Tribe vs. Arizona State University  link to video; https://www.nytimes.com/video/us/1247467672743/blood-journey.html?src=vidm PROMPT: Imagine that you are on the research ethics consultation service that must

### HCI 214 Health & Medical Electronic Healthcare Records

After watching the video, explain how does technology influence Healthcare.¿

### MDC Disaster Recovery Plan for Vila Health Community

– Develop a  disaster recovery plan to lessen health disparities and improve access  to community services after a disaster. Then, develop and record a 10-12

### Develop a literature map or a visual representation of the

Develop a literature map or a visual representation of the Public Health Informatics literature.  Also include a powerpoint presentation explaining the literature map with the slides Constructing