What is the planned value of the entire project

Assignment Help Project Management
Reference no: EM13948823

Question 1:

Your company is doing well and has a profit of about $50,000. You want to make your profit work harder so you have looked at some investment opportunities available. They are

• To insulate the current company offices at a cost of $18,000 which will provide a fuel savings of $1,600 per year over the next 10 years.

• To pay the lump sum of $30,000 to the mortgage of $40,000 that has a loan term of 10 years at 6.5% interest per annum.

• To invest $20,000 into a new business, which has been estimated to return the double amount
in 6 years' time.

• To keep the profit $50,000 in an iSaver account earning a fixed interest of 4.5% per annum for 8 years. After 8 years, there will be no interest for this iSaver account.

Assumptions:
- If only a part of the profit $50,000 is invested in a project, the remaining amount is still kept in the pocket (i.e. no investment).
- The investment/cost occurs at the beginning of a year, and the investment benefits are ob- tained at the end of a year.
- iSaver account calculates the compound interest.

(a) Given the profit you have and assuming a discount rate of 4.8%, perform and document appropri- ate NPV calculations for 10 years for all possible investment options you identified. Graph the re- sults to show the payback analysis of each investment option.

You must use Microsoft Excel or an equivalent spreadsheet program to perform and present your calculations.

Do not use the Excel NPV function and demonstrate you understand the formulas by calculating the NPV. You may confirm the calculated NPV using the Excel NPV function.

Ensure you format the spreadsheets so they use references rather than hard coding data. This al- lows experimenting with the data, e.g., if I change the discount rate the data should react and change accordingly.

Use bolding, colors etc. to ensure the data is easy to interpret.

(b) From your calculations in (a), which investment would you take up and why?

Use a Weighted Scoring Model (see an example on pages 154-155 of the textbook) to discuss the results and explain in detail why you have chosen one option over the others. It is not always just the figures that determine the final decision.

Create a report in Word or PDF format to present the outcomes of (a) and (b).

Use the data, graphs etc. created within the spreadsheet program to present the outcomes.

Question 2:

You are in charge of building a new office for your company. After some discussion with your builder, you identified some of the key tasks, the duration and the costs to complete the building. As you are a project manager you have decided to monitor the building progress using Earned Value Management (EVN). Answer the following questions using the following information

ID

Task Name

Cost ($)

Start Date

Duration

1

Lay foundations

18,000

November 1

2 weeks

2

Build frame

34,000

November

4 weeks

3

Install pipes and electrical

10,000

December

6 weeks

4

Make office water-tight

15,000

February

8 weeks

5

Install internal walls and bathroom

20,000

April

12 weeks

6

Install cabinetries

14,000

July

4 weeks

7

Paint office

8,000

August

2 weeks

8

Install light fixtures and appliances

9,000

August

2 weeks

NOTE: Assume that no task is scheduled to run concurrently, e.g., Task 2 starts after Task 1 com- pletes, Task 3 starts only when Task 2 completes, and so on. Also, assume that each month is made up of exactly four weeks.

(a) What is the planned value of the entire project?

(b) The project manager has managed to keep cost to what was originally budgeted above. At this point, the project has completed Task 4. Up to this point,

i. What is the planned value of the project?

ii. What is the actual cost (AC) of the project? Briefly explain how you derive the actual cost.

iii. What is the rate of performance (RP) for each task? Using the RPs obtained, calculate the Earned Value (EV), Schedule Variance (SV), Cost Performance Index (CPI), and Schedule Performance Index (SPI) of the project.

(c) Unfortunately, two trades resigned after Task 5 was completed and this caused the remaining tasks to exceed its original cost and schedule by 25%, 30%, 40% respectively. At the end of the project,

i. What are the CPI and SPI?

ii. How is the performance with respect to cost and time?

iii. Represent the Planned Value (PV), Earned Value (EV) and Actual Cost (AC) in a chart like the example below.

Attachment:- Template.rar

Reference no: EM13948823

Questions Cloud

What weight should be placed on the preferred stock : A firm has 12,000 shares of common stock outstanding with a book value of $20 per share and a market value of $39. There are 5,000 shares of preferred stock with a book value of $10 and a market value of $26. There is a $400,000 face value bond issue..
Estimating plant wide loss and for comparing departments : The operations manager of a large plant with four departments wants to estimate the person-hours lost per month due to accidents. Describe a sampling plan that would be suitable for estimating the plant wide loss and for comparing departments.
Explain the accrual-cash-modified cash bases of accounting : Throughout this course we have been using the accrual basis of accounting to complete our work. However, there are two other methods of accounting, the cash and the modified cash bases. Explain the accrual, cash, and modified cash bases of accounting..
Determine the maximum angular velocity : The wheel is made from a 5-kg thin ring and two 2-kg slender rods. If the torsional spring attached to the wheel's center has a stiffness k= 2 N # m>rad, and the wheel is rotated until the torque M = 25 N # m is developed, determine the maximum angu..
What is the planned value of the entire project : What is the planned value of the entire project - What is the rate of performance (RP) for each task? Using the RPs obtained, calculate the Earned Value (EV), Schedule Variance (SV), Cost Performance Index (CPI), and Schedule Performance Index (SPI..
What are other inverse relationships can identify associated : An inverse relationship that was identified is that as the number of treatments increased, the existence of the cancer decreased. What are other inverse relationships you can identify associated with this study?
How these principles helped the group or team succeed : Think about a positive experience when you worked in a group or team and identify the principles that were presented in the articles that were exhibited by your group or team. Explain how these principles helped the group or team succeed
Based on dividend growth model-price of stock will constant : Based on the dividend growth model, the price of a stock will remain constant if the dividend is cut, provided that the: Dividends tend to fluctuate in direct relation to changes in annual earnings. Managers are less concerned with the change in the ..
Problems legibly on a separate piece of paper : Please answer the following problems legibly on a separate piece of paper. List any other members of the class you worked with on this assignment. You will not be penalized for listing classmates' names, rather, group-work is encouraged. Remember ..

Reviews

Write a Review

Project Management Questions & Answers

  Project managementwhat are the differences among milestones

project managementwhat are the differences among milestones deliverables objectives and goals?what is the relationship

  Develop a budget for your project

Explain the process for identifying and managing risk in a project - Draft an email to your project sponsor to gain their approval of your project budget - BSBPMG522

  Calculate the expected time and variance of each activity

Calculate the expected time and variance of each activity and draw a network diagram and identify critical path and project completion time?

  Organizational communication conflict styles and

organizational communication conflict styles and tacticslook at specific conflicts and examine the conflict styles and

  About the problems arising from the assumptions of

about the problems arising from the assumptions of cpmcritical path analysis is recognized as a significant aid in

  Organize your project team to identify and manage the risk

However; not all risks have an equal probability of occurrence, nor are they all equal in potential impact. It is important to sort out the highly probable and the high impact risks so that you can concentrate on them rather than the low impact an..

  What would you do if you were in a position at nike

What would you do if you were in a position at Nike to decide whether to continue or revise your labor practices in a foreign country?

  According to carroll the responsibility that management

According to Carroll, the responsibility that management of a business organization has to produce goods and services of value to society

  What options does shirley have to shorten the project

Shirley is also asked to develop a risk plan for the project. Describe how the risk plan should be used and what information must be included in the risk plan.

  Closing process of a project

The closing process of a project is the last stage of the life cycle of a project, is to finalize all activities across all process groups of project management established in the PMBOK.

  Describe the key fundamentals of systems theory

Describe the key fundamentals of systems theory. This should include a brief historical background, but more focus must be of key ideas/components of systems theory

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd