Description
There are 5 problems that i need help to solve (i.e., to calculate the net present value and the simple payback, project priority matrix, project network, Gantt Chart, earliest, midpoint and latest estimated time, cost, BAC for the project). See attach for specific detials/description of the problems
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Nova Western should select Project Janus as budget is the main deciding factor in regard to selection of the best project, Project Janus requires only $250000 As compared to Project Gemini which requires $400000 As initial investment. Alap Project Janus is having a higher NPV as compared to Project Gemini which means that investment in Project Janis will yield higher profits when compared with project Gemini.Please refer attached word document for complete answer. All the workings have been included in a separate excel file.
Problem #1
Project Selection at Nova Western, Inc.
Phyllis Henry, vice president of new product development, sat at her desk, trying to make sense
of the latest new project proposals she had just received from her staff. Nova Western, Inc., a
large developer of business software and application programs, had been experiencing a
downturn in operating revenues over the past three quarters. Their consensus opinion was that
Nova Western needed some new product ideas, and fast.
The report Phyllis was reading contained project screenings conducted by two independent
groups within the new product development department. One project, code-named Janus, was
championed by the head of software development. The other project idea, Gemini, had the
support of the business applications organization. Phyllis’s original charge to her staff was to
prepare an evaluation of both projects in order to decide which one Nova Western should
support. Because of budget restrictions, there was no way that both projects could be funded.
The first evaluation team used a weighted scoring model, based on the key strategic categories at
Nova Western, to evaluate the two projects. However, Phyllis was also presented with financial
analyses of the two projects by her second team of evaluators. Their evaluation assumed a
required rate of return of 18%, including anticipated inflation, over the lives of the two projects.
Nova Western’s client is very concerned about being first to market after the successful
completion of this new project. They are very concerned about the project scope and
deliverables and are not interested in any changes. Budget is always a concern but there are
budget and management reserve funds available just in case additional resources are needed.
The data the project selection teams collected are shown on the next page:
Project Janus
Category
1. Strategic fit
2. Probability of technical success
3. Financial risk
4. Potential profit
5. Strategic leverage
Importance
3
2
2
3
1
Score
2
2
1
3
1
Total Score
Initial investment
Life of the project
Anticipated stream of future cash ...