Hands-on Assignment 3: Project Planning and Integration Management with performing Net Present Value

Hands-on Assignment 3: Project Planning and Integration Management with performing Net Present Value Analysis, Weighted Scoring Model, Payback Analysis and Financial AnalysisBased on the Running case scenario on page 182 from Schwalbe’s text please complete the following five tasks:1. Summarize each of the four proposed in the case projects in a simple table format suitable for presentation. Include each project’s name, identify how each one supports business strategy, assess the potencial benefits of each project, provide your initial assessment of the value of each project. Create a page memo to the top management including appropriate back-up information and calculations.2. Create a Weighted Scoring Model using the template provided on the companion website to evaluate these four projects. In the spreadsheet develop at least four criteria, assign weights to each criterion, assign scores, and then calculate the weighted scores. Visualize with a bar chart diagram the scoring results. Write a pagereport describing the weighing score model, the weights you utilize and what the results show.3. Organize a business case for the Recreation and Wellness Intranet Project. Assume the project will take six months to complete and cost about $200,000.Perform a Financial Analysis fortheRecreation and Wellness Intranet project with following parameters:a. Project costs and benefits are spread over four years as follows: estimated costs are $200,000 in Year 1 and $40,000 each year in Year 2, 3 and 4; estimated benefits are $0 in Year 1, and $600,000 each year in Year 2, 3 and 4. Use a 10 percent discount rate.b. Create a spreadsheet to calculate and display the Net Present Value Analysis, andROIyear in which Payback occurs-Payback Analysis. You could use the business case financials template provided from the companion website forSchwalbe’s textbook as a prototype.c. Write a paragraph memo whether you will recommend investing in this project, based on completed financial analysis.4. Prepare aProjectCharter for the Recreation and Wellness Intranet Project.Use the project charter template provided in the Schwalbe’s text and the sample in Table 4-1 as a guide.5. Prepare a Change Request for this project, using the template provided in the companion Schwalbe’s text web site.