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

  Edinburgh airport case study

Discuss why a relational database would be suitable for the organisation in the case study and provide three reasons for this recommendation and discuss using three advantages that a database management system provides to an organisation.

  Identify a relational algebra tree

Identify a relational algebra tree (or a relational algebra expression if you prefer) that reflects the order of operations a decent query optimizer would choose.

  Create an erd from a business problem

List all the business rules for the ABS ( Business rules are important because they define the conditions that the database must meet. For example, every Order must be associated with a valid Product.This prevents invalid Orders being entered into..

  Explain why is hashing all database inputs not considered

question 1 what are the similarities between an md5 hash and a fingerprint?question 2 how would you encrypt a web

  What is the role of the project manager

Discuss why many information technology professionals may overlook project cost managment and how this might affect completing projects within budget.

  Describe each database being compared

You should briefly describe each database being compared. Then compare the databases based on their scalability functionality, and interoperability. Finally, make your recommendation based on yo comparison.

  Please write down the sql statements to answer the given

please write sql statements to answer the following questions. your tables should still be on the oracle server. please

  Query using a literal character string

query specifying specific columns query using a column alias query using the concatenation operator query using a literal character string

  Asnbspyou approach thenbspend ofnbspthe class you have

asnbspyou approach thenbspend ofnbspthe class you have seen how a database can be set up and accessed.nbspnext you

  Produce an entity-relationship diagram

Produce an Entity-Relationship diagram which represents the above activities of the insurance company. Indicate the names and degrees of all the relationships. Give appropriate attributes for each entity shown, and identify the primary key for eac..

  Installing the ms-sql server on your computer

Use Hands-on Projects that are in the back of your Chapter to introduce you to the Microsoft SQL Server 2008.

  Write names and e-mail addresses showing foreign key columns

Illustrate all the data in each of four tables. Don't show foreign key columns. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

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