What are the irr the roi and the payback period

Reference no: EM131223186

Make-Or-Buy Analysis Assignment

For this assignment, you have two options: use Microsoft Project or use Microsoft Excel. The assignments are slightly different depending on which option you select, so be sure to read the assignment descriptions carefully. Complete only one option.

If You Are Using Microsoft Project

Continuing the theme of pharmaceutical product development that we started in Module 1, the senior management is pleased with your work, but they require more information than the project update has provided thus far.

Your deliverables for this assignment are two-fold; first use Microsoft (MS) Project to develop a make-or-buy analysis for a pharmaceutical component assuming costs and then answer the following questions in the notes feature in Microsoft Project or Excel.

If the expected profits after the drug development were $2 billion for the first year, the growth rate for the next five years is predicted to be 15 percent, and the growth rate for the following 10 years is predicted to be 5 percent, is this a good project or not? What are the IRR, the ROI, and the payback period?

Explain your responses in 1-2 pages. Ensure your work is well written and adheres to APA GUIDLINES

If You Are Using Microsoft Excel

A make-or-buy analysis is part of a larger series of processes called a Procurement Management Plan. The plan's purpose is to determine whether or not to acquire outside support for the success of the project and how much support is needed (Project Management Institute, 2013). A make or buy analysis is a report that considers several variables related to project costs and is used to gauge at what point it makes more sense to export a product or resource than to keep it internal.

The complexity of a make-or-buy analysis is dependent on the project scope, deliverables and the values each company holds dear. When using Excel, a make-or-buy analysis ranges from a simple two column dichotomous comparison to an extensive macro spreadsheet with multiple pages and links. The design complexity (form) is dependent on the use (function) of the data.

For a pharmaceutical development project you will need to include the following pieces in your Excel Spreadsheet. The more detailed information the better, but at a minimum you need to include the following four requirements:

Cost Estimates
Schedule
Project Requirements (variables)
Risk (very detailed)

Additional information that could be useful depending on the level of analysis desired:

Project Plan

Estimate of Activity Resources

Stakeholders

Organizational Values (as a numerical value)

In Module 1, you were required to explain to senior management the project's viability and answer the following questions.

The projects ability to succeed

Difficulties you envision in the project and why?

The average total value of this project

Consider the average output rate out of the FDA review if there are 200 projects in the pipeline for basic research, how does this project fare?

What kind of performance is required to warrant a financial investment?

Refer back to the answers to these questions that were created in Module 1 as they will help you in this Critical Thinking assignment as well.

Your deliverable for this assignment is to construct an Excel spreadsheet that demonstrates your understanding of cost estimates, schedule, project requirements, and risk. Once you complete this spreadsheet you will determine the cut off points and make your analysis. The final piece of this assignment is to describe in detail your rationale for the spreadsheet's numbers, determining your cut-off points (break-analysis) for the project, and to write a description of how you believe the project will trend (make-analysis). Your rationale should be at 1-2 pages and adhere to the APA GUIDELINE Below you will find a sample spreadsheet and description. Please note that this sample is meant to give you a small taste of what the assignments entails. To receive full credit you will need to go into significantly more detail.

Reference no: EM131223186

Questions Cloud

How are the advertising costs accounted for : How are the advertising costs accounted for? Where would deferred advertising costs be reported in the financial statements? Using the element definition from the conceptual frame work, should these deferred advertising costs be recorded as assets in..

Find the maximum of 3 numbers and print : 1). Write a program to scan 3 integer numbers from user, then find the maximum of these 3 numbers and print it. 2). Write a program to scan 2 integer numbers from user, then check for below conditions:

What if expected inflation rose by only 2 percent : What will happen to the demand for money? - What if expected inflation rose by only 2 percent? What if the yield on non money assets rose by 4 percent?

Risk assessment procedure in financial statement audit : Which of the following is least likely to be considered a risk assessment procedure in a financial statement audit? Which of the following is most likely to be included in an auditor’s inquiry of management while obtaining information to identify the..

What are the irr the roi and the payback period : If the expected profits after the drug development were $2 billion for the first year, the growth rate for the next five years is predicted to be 15 percent, and the growth rate for the following 10 years is predicted to be 5 percent, is this a go..

What does the quantity theory imply for inflation : What does the quantity theory imply for inflation in the long run in an economy with growing output and stable velocity?

Identifying five different categories of application : Can someone create a simple a PowerPoint presentation at least five slides in length identifying five different categories of application software?

What is the company plantwide overhead rate : K Company estimates that overhead costs for the next year will be $3,900,000 for indirect labor and $980,000 for factory utilities. The company uses direct labor hours as its overhead allocation base. If 100,000 direct labor hours are planned for thi..

Introduction to computing : Research at least three different executive support systems using a web search. Review each, and then answer the following questions: 1. Which ESSs did you review? Include a link to information about it.

User Account

All Pages