Perform a payback analysis for given project

Assignment Help Database Management System
Reference no: EM13645984

Part -1: Project management tools

14_Project management tools.png

Using the information in the table above, draw a PERT chart of the project to determine the earliest completion time for the project and identify the critical path for the project. You must submit the following:

a) GANTT chart
b) PERT chart
c) Date for the Earliest Completion Time of the project
d) Critical Path

Part 2A:

Working as a Systems Analyst on a project, your analysis reveals that it will cost $35000 to establish the new computer system (in year 0), and that the recurring costs for the next 5 years will increase by 5% each year. The benefits in year 0 will be $25,000 and these are expected to rise by 25% each year for the next 5 years. Assuming an 8% discount rate undertake the tasks below.

1. Perform a Payback Analysis for this project.
2. Using the Payback Analysis table, determine the payback period for the system by drawing the associated graph. Clearly indicate on the graph the payback period.
3. What is the ROI for this project over the five (Year 0+ the following 5 years) year period? You must show the formula and the values used to arrive at your answer.
4. Assuming an 8 per-cent discount rate, determine the Net Present Value (NPV) for this project (discount factor tables can be found in the text or through the Internet)

Part 2B:

You need to explain the results of the financial analysis performed in Part 2A above in a cover sheet to your CEO. You are to provide a brief description explaining the implications for the CEO to enable him/her to understand and to be able to make appropriate decisions regarding the project feasibility. What decision do you recommend?

Part 3 - Decision Table and DFD fragment

Scenario:

The discount given to the car insurance customer is determined from three different conditions. Firstly, whether the customer is Young (18-24), or Mature (25 or older). Secondly, the customer's home address is considered to be Low (L), Medium (M), or High (H) risk. Finally, whether the customer has made any claims within the last two years (Y or N).

A mature person gets a 20% discount while a young person gets no discount for their age. Someone who has a low risk address gets a 10% discount whereas a person with a medium risk address gets a 7% discount, and those with high risk addresses get no discount for their address.

Those who have made no claims in the last two years receive a 5% discount. All discounts are cumulative. In other words the discounts based on age, location and previous claims are added together. So for example, a mature person living at a low risk address who has made no claims in the last 2 years would receive a 35% discount.

1. Draw a decision table that shows all possible rules for the above scenario.

2. Draw the DFD fragment described by the decision table (I recommend you use Microsoft Visio or other similar tool).

3. You are then required to write the Structured English for the Determine the discounts process described in the decision table.

Reference no: EM13645984

Questions Cloud

Compute the number of grains of aspirin in the tablet : Determine its composition, an aspirin tablet was crushed and dissolved in water. It took 12.25 mL of 0.1466 M NaOH to neutralize the solution. Calculate the number of grains of aspirin in the tablet (one grain = 0.0648 g).
Evaluate the mass of the precipitate formed ba(oh)2 : Calculate the mass of the precipitate formed when 2.27 L of 0.0820 M Ba(OH)2 is mixed with 3.06 L of 0.0664 M Na2SO4.
How to evaluate the molar mass of the acid : A 3.664-g sample of a monoprotic acid was dissolved in water. It took 20.27 mL of a 0.1578 M NaOH solution to neutralize the acid. Calculate the molar mass of the acid.
Determine the molar formula of procaine : Complete combustion of a 3.54-g sample of procaine with excess O2 formed 8.58 g CO2 and 2.70 g H2O . Another sample of mass 2.35 g was found to contain 0.279 g of N . The molar mass of procaine was found to be 236.
Perform a payback analysis for given project : Perform a Payback Analysis for given project - Draw a decision table that shows all possible rules for the above scenario.
What is the total power delivered to the resistors : The drawing shows a circuit that contains a battery, two resistors, and a switch. What is the total power delivered to the resistors when the switch is open
Explain how much energy are we loosing to the ocean : We all know that a day at the beach leaves us worn-out. Assuming our body looses its heat energy to the water, and on a typical day of swimming at the beach we encounter 135.0kL of water at a constant Temperature. How much energy are we loosing to..
Evaluate the tension in the supporting cable : An elevator cab and its load have a combined mass of 1600kg. Find the tension in the supporting cable when the cab, originallymoving downward at 12m/s
Evaluate the percentages by mass of caco3 and baco3 : A mixture of calcium carbonate, CaCO3, and barium carbonate, BaCO3, weighing 5.4 g reacts fully with hydrochloric acid, HCl (aq), to generate 1.39 L CO2 (g), measured at 50°C and 0.904 atm pressure. Calculate the percentages by mass of CaCO3 and B..

Reviews

Write a Review

Database Management System Questions & Answers

  Logical entity relationship diagram

How can turn a conceptual entity relationship diagram into a logical entity relationship diagram

  Describe a minimum of three heuristics to optimize queries

Your supervisors and customers are very impressed with the database you have put together. Describe a minimum of three heuristics to optimize Queries.

  Explain the following terms brie?y attribute domain entity

Explain the following terms brie?y: attribute, domain, entity, relation-ship, entity set, relationship set, one-to-many relationship, many-to-many relationship, participation constraint, overlap constraint, covering constraint, weak entity set, aggre..

  Create 3 rows of data for each table ensuring

Write SELECT statements for the following (include a screenshot of the SQL and its execution, including the resulting data).

  Clustered versus unclustered indexes

Choice of search key for the index. What is a composite search key, and what considerations are made in choosing composite search keys? What are index-only plans, and what is the in?uence of potential index-only evaluation plans on the choice of sear..

  Write a memorandum to sam jones

Write a memorandum to Sam Jones (CIO) and present your research findings. Your memorandum should be no longer than 500 words.

  Explain the idea for database and partitioned view

Explain the idea for the database along with the thoughts for partitioned view. How would you utilize this partitioned view?

  Develop view for sum of number ordered multiplied by price

Develop a view named OrdTot. It comprises the order number and order total for each order presently on file. (Order total is sum of the number ordered multiplied by quoted price.

  Identify five different it systems that have affected

identify five different it systems that have affected business in the past few years i.e. business software

  Define the term use case

Explain the difference between the > and > relationships in use case diagrams?

  Discussed and implemented the mvc design pattern

Find another design pattern which could be used for web based development and write a synopsis on it, pointing out whether it would be applicable for use within your project or not. Comment as applicable on design patterns that other class members..

  Find all governors general of australia

Find all Governors General of Australia who were Barons at the time and Restrict your query to Governors General who were Barons at the time of their appointment

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