Create a cost-benefit analysis spreadsheet

Reference no: EM131465085

Accounting Information Systems Assessment: Excel Spreadsheet

Learning Outcomes

1. Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases.

2. Communicate with IT professionals, stakeholders and user groups of information systems.

Global Athletic Apparel Manufacturer (GAAM)

INFORMATION TECHNOLOGY PROPOSAL

Global Athletic Apparel Manufacturer's (GAAM) external consultant suggested that the company should have an inventory and sales database management system to help the company monitor its sales and products. GAAM's Chief Information Officer, Mr. John Norton, is yet to decide whether to have the system developed in-house or outsource the development. A cost-benefit analysis is needed to assist him in making this decision.

A cost-benefit analysis used to evaluate the total anticipated cost of a project compared to the total expected benefits in order to determine whether the proposed implementation is worthwhile for the company or project team.

GAAM needs a recommendation whether to develop the system in-house or outsourced based on the results of the cost-benefit analysis for 5 years.

Cost-Benefit Analysis Overview:

Conducting a Cost-Benefit Analysis

While it is important to provide decision-makers with a range of options, the process of developing and analysing these can be expensive and time consuming. For major investments, it may be necessary to outline various potential options and then to have decision-makers select, after a preliminary screening, a smaller number for detailed appraisal. In any case, an appropriate level of consultation should be undertaken as best practice, either formally or informally, in creating a set of alternatives.

Step 1: Identify, quantify and value the costs and benefits of each alternative

Step 2: Calculate the Net Present Value

Step 3: Sensitivity analysis and dealing with uncertainty

ASSESSMENT - EXCEL SPREADSHEET

General Instructions:

1. Create a cost-benefit analysis spreadsheet for both in-house and outsourced development:

Create s spreadsheet, format and use formulas to identify the cost-benefit analysis for alternatives.
Visually show comparison by using graphs and charts.
Give recommendations on which alternative is more beneficial to the organisation.

Note: students are required to input their own data.

Attachment:- Assignment File.rar

Reference no: EM131465085

Questions Cloud

Create a testing program thats achive five type of testing : Create a testing program that achive five type of testing which are : * equivalence coverage. *Data coverage. *error guessing. *branch coverage. *T way testing.

Explain the skills-knowledge-education and experience : Explain the skills, knowledge, education, and experience that you will require of the store employees.

Create the metric distance program : Create the Metric Distance (MD) Program. What is a "metric distance". Given a set of metrics, m1, m2, m3... mn, for a set of modules (records).

Structure of the building and construction industry : Identify the market structure of the building and construction industry in your country. Outline the solutions to the housing affordability problem.

Create a cost-benefit analysis spreadsheet : ACCT6001 Accounting Information Systems Assessment: Excel Spreadsheet. Create a cost-benefit analysis spreadsheet

What makes a good sales manager : Do you have any thoughts on what makes a good sales manager?

Describe specific qualitative methods : Describe specific qualitative methods and tools that could be used within your discipline to gather data. Within your description, evaluate their effectiveness.

How can infrastructure development from construction : How can infrastructure development from construction projects be used to advance and improve societal interests?

Graphs of dad-das space : Also discuss how the economy might transition to a LR equilibrium. Graphs of DAD/DAS space and written discussion are required.

Reviews

len1465085

4/17/2017 4:34:54 AM

Note: students are required to input their own data. Kindly provide your quote and also state what is the requirement of the assignment and how you will complete it to ensure that you have understood it correctly. All formulae, formatting and cell references are correct (No errors). Cells are excellently formatted and easy to understand. All data have been entered correctly. Graphs and pivot table are created with no errors. Excellent presentation of graphs and pivot table. Thorough explanation of the recommendations are provided and in-depth analysis is presented.

Write a Review

Required(*) Message

User Account

All Pages