I have a project recommendation analysis to complete.... I have all of the necessary calculations done and entered, but I need help putting them into an excel spreadsheet WITH FORMULAS to compute the metrics. Attached is the data figures, and the assignment info for your reference. I have all of the work done, I just need the excel spreadsheet with formulas to back it up.

Good afternoon Ray, It is nice to hear from you. As requested, I have analyzed these three project proposals for preparation in your PMO review. A breakdown of each project analysis is included below, along with a description of the five phases of a project, key deliverables, and our recommendation of which project Piper Industries should invest in. Project Juniper: $325,000, Critical Path: 6 months duration, project life 2-3 years Return on Investment: $250,000 yearly x 2 years = $500,000 Pros: Schedule risk is low Forecasting is predicted to be accurate Breakeven point is estimated at 1.5 years Would meet client's launching deadline of 12 months out Cons: The third year is forecasted to be the end of product life Project Stargazer: $1,025,000, 1 or more years duration, project life 7 years Return on Investment: Y1 - $300,000 Y2 - $550,000 Y3 - $750,000 = 1,600,000 Pros: The product is futuristic, as is the project Breakeven point is estimated at 2 years Cons: Schedule risk is high Forecasting has a high variance Would NOT meet client's launching deadline of 12 months out Project Palomino: $655,000, Critical Path: 9 months, Project life 7 years Return on Investment: $450,000 x 5 years total = $2,250,000 Pros: Schedule risk is medium Forecasting is predicted to be accurate Breakeven point is estimated at 1-2 years Would meet client's launching deadline of 12 months out Cons: No significant disadvantages Project Management E-Mail OPS/571 Version 5 University of Phoenix Material Project Management E-Mail Dear Project Manager: We have three project proposals to consider in next week's Project Management Office's (PMO) Review. Piper Industries Corp. needs the projects to be complete and to be generating revenue within 12 months of next week's PMO Review. Wendell Deirelein, our vice-president, has assigned your team to analyze the three projects below and make a recommendation on which project the company should invest in. The recommendation must include your team description of the five phases of the project and the key deliverables (project completion date and cost) for each project. Project Code Name: Juniper This is an enhancement of a current widget being offered by our company. Risk of completion of this project on time is low. Product plan shows the critical path to be 6 months at a cost of $325,000 to bring the product to market. Product is forecasted to have a ROI of $250,000 for a period of 2 to 3 years. The third year is forecasted to be the end of life for this product line due to advances projected in technology. This is a standard product line that marketing believes many customers will want to purchase. Project Code Name: Palomino This is a new line of widget products including enhancements using existing technology. Risk for completion of this project on time is medium. Production plan shows the critical path to be 9 months at a cost of $655,000 to bring the product to market. Product is forecasted to have a ROI of $450,000 for a period of 5 years. This product will be a custom part for one of your strategic customershistorically the forecasts from this customer have a 5% margin of error. The seventh year is forecasted to be the end of life for this product by the customer. Project Code Name: Stargazer Research and development has already started on our new widgets. The company has spent $450,000 on this product so far and the estimate to bring this product to market is $575,000. Risk of completing this project on time is high. Product is forecasted to have ROI of $300,000 first year; $550,000 the second year; and $750,000 the third year. The product life is forecasted to be 7 years for this product. (This forecast included derivative product which will cost more). By delivering such an innovative product to the market place first, your organization will be seen as a leader in this industry. Your sales and marketing teams have discussed this type of product with a few of your strategic customers; while some are interested, there are many questions about the business. Sincerely, Copyright 2012 by University of Phoenix. All rights reserved. 1 Project Management E-Mail OPS/571 Version 5 Ray Gritsch Piper Industries Corporation Copyright 2012 by University of Phoenix. All rights reserved. 2 \fProject Management Recommendation Grading Guide OPS/571 Version 5 Individual Assignment: Project Management Recommendation Purpose of Assignment The Project Management Recommendation assignment is designed to provide students with a context that is realistic in requiring them to develop an email response. The response allows students to convey the information in a less formal format but still including the relevant information as it pertains to actually selecting a project and determining the criteria for selection rather than going into the specifics of project management. Content 80 Percent Met Partially Met Not Met 0 Total Available Comments: Total Earned Paper is written as a professional email response Email includes a determination of which project is to be implemented and an explanation that incorporates a minimum of 3 methods of financial comparative analyses (breakeven analysis, npv, irr, etc.) of project options to substantiate why chosen. Email includes a description of the five phases of project management. Email includes a description of the deliverables to be associated with the recommended project implementation. The paper is no more than 750 words in length. /9 Writing Guidelines 20 Percent Met Partially Met Not Met 0 Total Available Total Earned Intellectual property is recognized with in-text citations and a reference page. Paragraph and sentence transitions are present, logical, and maintain the flow throughout the paper. Sentences are complete, clear, and concise. Rules of grammar and usage are followed including spelling and punctuation. /2 Assignment Total # /11 Additional comments: Copyright 2012 by University of Phoenix. All rights reserved. Comments: 1 Project Management Recommendation Grading Guide OPS/571 Version 5 Copyright 2012 by University of Phoenix. All rights reserved. 2