Expert answer:this is a technology solution assignment for IfSM

  

Solved by verified expert:The instructions for the Individual Assignment, Technology Solution,an example network diagram, the ROI Calculator and Cost Spreadsheet, and instructions for using the spreadsheet are attached. Please let me know if you have any additional question and reach out to me if there is additional document needed.
roi_calculator_and_cost_spreadsheet__1_.xls

instructions_for_using_the_roi_calculator_spreadsheet__1_.docx

Don't use plagiarized sources. Get Your Custom Essay on
Expert answer:this is a technology solution assignment for IfSM
Just from $10/Page
Order Essay

technology_solution.docx

example_network_diagram.doc

team_omega_ifsm_495_sections_v_and_vi.docx

Unformatted Attachment Preview

ROI Calculator – for IT system projects
2015 Version (v1.04)
SCROLL TO THE TOP to see all entries
Published by Axia Consulting Ltd, 17 New Road Avenue, Chatham, Kent ME4 6BA, United Kingdom.
Web: www.axia-consulting.co.uk Email: info@axia-consulting.co.uk
Axia Consulting Ltd gives no warranty (either expressed or implied) in relation to the quality, accuracy, performance and fitness for purpose of this
‘ROI Calculator’. Axia Consulting Ltd will not be liable for any loss or damage (whether directly or indirectly suffered), or any consequential loss
arising from the use of this ‘ROI Calculator’.
Copyright © 2015 Axia Consulting Ltd. All rights reserved.
This ‘ROI Calculator’ is free for personal use and to help you with projects internally within your organisation. However, you are not permitted to
display this ‘ROI Calculator’ on the Internet, whether in part or whole, whether modified or not, nor to advertise, resell or obtain a commercial
benefit from it.
ROI Calculator objective: to quickly calculate ROI (return on investment) and payback year for IT system projects
INSTRUCTIONS are below (click the tab at the bottom of the screen to access the ROI Calculator Example)
Note: The ROI Calculator includes some fictitious data in the ROI Calculator Example, for illustration purposes. On the Costs and Services and ROI
Calculations tabs you will enter data about your specific project. The notation $’000 means that the data are shown in thousands of dollars.
All calculated figures are in coloured in orange, with totals in blue, to assist in easy recognition. The worksheet uses simple Excel calculations which
should not be altered.
Graphs show analyses of project cash flows, income / cost savings and implementation costs. The graphs in your ROI Calculations will change
depending on the headings and data you enter into the spreadsheet.
Instructions
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
Date: 5/9/2019
Page: 1
1. Review the ROI Calculator Example
2. Go to the Costs and Sources tab and enter the costs associated with your technology solution.
3. Go to the ROI Calculations tab and enter the categories of savings and amount to be saved each year – for your solution. Edit the
entries and delete the rows where excess entries are shown. Use ‘insert row’ if you need to add rows. This will retain the formulas
correctly.
4. On the ROI Calculations page enter the categories of costs (initial investment costs and ongoing costs) and the amounts for each of the
first 5 years of use of your solution using the data you entered on the Costs and Sources tab. Edit the entries and delete the rows where
excess entries are shown. Use ‘insert row’ if you need to add rows. This will retain the formulas correctly.
5. Review the totals that are calculated by the spreadsheet formulas and make sure they are correct.
6. Review the two rows in Section 3 below the costs and examine how the cash flow and cumulative cash flow are calculated.
7. In section 4, enter any assumptions that affected the costs recorded; some examples are shown
8. Review the 4 charts at the top of the page to see how the categories of savings and costs break out.
9. The top right chart shows the Return on Investment (ROI) for your project and the Payback Year. These will be included in your written
narrative that explains your technology solution.
10. Your written narrative will also include the total investment (one-time) costs and the annual ongoing cost amounts.
11. Your written nattative will also discuss the categories and amounts of savings expected from implementing your solution.
Further information about software selection may be found at:
http://www.axia-consulting.co.uk/html/resources.html
Downloaded from:
http://www.axia-consulting.co.uk/html/roi_calculator.html
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
Date: 5/9/2019
Page: 2
ROI Calculator – for IT system projects
Project name:
Results Summary
$/£’000
Project cash flows
Total project cost savings/income $’000
Total project expenditures
$’000
Net project savings / income
$’000
500
400
300
200
100
0
-100
-200
-300
Cash flow (Savings Expenditure)
Cumulative cash flow (previous
yr cumulative
ROI (return on investment – after 5 years)
2
3
4
108.6%
Year 3
Payback year
1
845
-405
440
5
Years
Analysis of project
cost savings / income
Analysis of project implementation costs
Improved invoice preparation
Contingency
10%
Training
10%
Reduced storage costs
Reduced
consumables
4%
Existing software
annual
maintenance
27%
Time saved
manually
creating basic
reports
12%
Improved invoice
preparation
17%
Reduced
storage costs
40%
Software
Software
29%
Database
Additional licences
Hardware
Time saved manually creating basic
reports
Existing software annual
maintenance
Other labour
costs
13%
System
configuration
10%
Network Hardware
22%
3%
Network
Database
1%
System configuration
Other labour costs
Additional
licences
2%
Training
Contingency
Reduced consumables
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
Date: 5/9/2019
Page: 3 of 14
ROI Input
Description
Ref
Year:
0
1
2
3
4
5
Total
$’000
$’000
$’000
$’000
$’000
$’000
$’000
1 Project cost savings / income
1.1
1.2
1.3
1.4
1.5
Improved invoice preparation
Reduced storage costs
Time saved manually creating basic reports
Existing software annual maintenance
Reduced consumables
Total cost savings / income
40
25
0
65
20
60
15
50
5
150
40
80
30
50
10
210
40
80
30
50
10
210
40
80
30
50
10
210
140
340
105
225
35
845
2 Project expenditures
2.1 Selection costs
2.1.1
2.1.2
2.1.3
2.1.4
Shown in year 0; prior to star
Software selection staff costs
Travel and expenses
Selection tools / programs
Consultancy costs
10
2
1
7
Sub total selection costs
20
10
2
1
7
0
0
55
5
5
70
10
15
20
15
20
35
215
95
0
0
0
20
2.2 Implementation costs
2.2.1
2.2.2
2.2.3
2.2.4
2.2.5
2.2.6
2.2.7
2.2.8
2.2.9
Software
Database
Additional licences
Hardware
Network
System configuration
Other labour costs
Training
Contingency
Sub total implementation costs
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
0
90
5
5
70
10
30
40
30
30
15
20
15
10
Date: 5/9/2019
0
0
0
310
Page: 4 of 14
2.3 Ongoing costs
Annual maintenance / service charges for
software, hardware, database, network (either
the total annual cost, or listed by each item of the
2.3.1 annual cost)
Sub total ongoing costs
Total expenditure
15
15
15
15
15
75
0
15
15
15
15
15
75
20
230
110
15
15
15
405
-20
-20
-165
-185
40
-145
195
50
195
245
195
440
440
3 Cash Flow
Cash flow (Savings – Expenditure)
Cumulative cash flow (previous yr cumulative
cash flow + current year cash flow)
4 Assumptions
list any assumptions here – examples might be:
number of licenses needed
growth in number of users
growth in amount of data/transactions
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
Date: 5/9/2019
Page: 5 of 14
Note: $’000 means the amounts are shown in thousands
of dollars
Net = Savings – Project Expenditure
ROI = Net Savings/Project Expenditure
Payback year = year in which the accumulated savings
exceeds the project expenditures
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
Date: 5/9/2019
Page: 6 of 14
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
Date: 5/9/2019
Page: 7 of 14
INSTRUCTIONS: List each item separately and use Excel functions to calculate total
item costs, subtotals, and total expenditure. Enter costs in appropriate columns and
show the source (URL) of the cost of each item. Edit the items in Column B to match
your solution, inserting rows as needed.
Implementation costs
Unit Cost Number of Units Total Item Cost
Software
Software
Database
Additional licences
Other software costs
Hardware
(list each hardware component)
Network
(list each network component
and connectivity/communication
costs)
Labor/Service Costs
Contingency
System configuration
Other labour costs (specify)
Training
Contingency
Sub total implementation
costs
Ongoing costs
Annual Cost
(List Annual maintenance /
service charges for software,
hardware, database,
communications/connectivity)
Sub total ongoing costs
Total expenditure
Source of cost (website, etc)
Total annual cost
ROI Calculator – for IT system projects
Project name:
NOTE: Everything looks messed up, but will look correct after you enter your data
Results Summary
$/£’000
Project cash flows
Total project cost savings/income $’000
Total project expenditures
$’000
Net project savings / income
$’000
1
1
1
1
1
1
0
0
0
0
0
Cash flow (Savings Expenditure)
Cumulative cash flow (previous
yr cumulative
ROI (return on investment – after 5 years)
Payback year
1
2
3
4
0
0
0
#DIV/0!
Year 1
5
Years
Analysis of project
cost savings / income
Existing
software
Time saved
annual
Reduced
manually
Improved
invoice
Reduced
maintenance
storage
costs
creating
basic
preparation
consumables
0%
reports
0%
0%
0%
Analysis of project implementation costs
Improved invoice preparation
System
Additional
Training
configuration
Database
Other
labour
Network
Software
Hardware
licences
Contingency
0%
0%
0%
costs
0%
0%
0%
0%
0%
Reduced storage costs
Software
Database
Additional licences
Hardware
Time saved manually creating basic
reports
Network
System configuration
Other labour costs
Existing software annual
maintenance
Training
Contingency
Reduced consumables
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
Date: 5/9/2019
Page: 10 of 14
ROI Workings
Year:
Description
Ref
0
1
2
3
4
5
Total
$’000
$’000
$’000
$’000
$’000
$’000
$’000
1 Project cost savings / income
1.1
1.2
1.3
1.4
1.5
Improved invoice preparation
Reduced storage costs
Time saved manually creating basic reports
Existing software annual maintenance
Reduced consumables
Total cost savings / income
0
0
0
0
0
0
0
0
0
0
0
0
Edit the headings for YOUR
Delete rows that remain and
Enter the amounts you estim
Below, enter the costs from y
2 Project expenditures
2.1 Selection costs
2.1.1
2.1.2
2.1.3
2.1.4
Shown in year 0; prior to star
Software selection staff costs
Travel and expenses
Selection tools / programs
Consultancy costs
Sub total selection costs
0
0
0
0
0
0
0
0
0
0
0
2.2 Implementation costs
2.2.1
2.2.2
2.2.3
2.2.4
2.2.5
2.2.6
2.2.7
2.2.8
2.2.9
Software
Database
Additional licences
Hardware
Network
System configuration
Other labour costs
Training
Contingency
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
0
0
0
0
0
0
0
0
0
Date: 5/9/2019
Page: 11 of 14
Sub total implementation costs
0
0
0
0
0
0
0
2.3 Ongoing costs
Annual maintenance / service charges for
software, hardware, database, network (either
the total annual cost, or listed by each item of the
2.3.1 annual cost)
0
Sub total ongoing costs
0
0
0
0
0
0
0
Total expenditure
0
0
0
0
0
0
0
Cash flow (Savings – Expenditure)
Cumulative cash flow (previous yr cumulative
cash flow + current year cash flow)
0
0
0
0
0
0
0
0
0
0
0
0
0
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
Date: 5/9/2019
Page: 12 of 14
Note: $’000 means the amounts are shown in thousands
of dollars
Net = Savings – Project Expenditure
ROI = Net Savings/Project Expenditure
Payback year = year in which the accumulated savings
exceeds the project expenditures
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
Date: 5/9/2019
Page: 13 of 14
Copyright © 2015 Axia Consulting Ltd www.axia-consulting.co.uk
Date: 5/9/2019
Page: 14 of 14
INSTRUCTIONS FOR USING THE ROI CALCULATOR SPREADSHEET
The ROI Calculator spreadsheet is to be included with the individual technology solution description and
with the group assignment for Section VIII of the business case. This allows each member of the team
to specify costs and savings and be able to see how the Return on Investment (ROI) and payback period
are calculated, and for the information to be presented in both documents. The individual assignment is
due prior to Section VIII. The team members will share their technology solutions and spreadsheets with
each other and determine which ones to use (with possible modifications) for the business case.
HOW THE CALCULATOR WORKS
First, it would be helpful to understand how the ROI Calculator works. Open the ROI Calculator
spreadsheet and click on the “Instructions” tab. Read the instructions and then click on the “ROI
Calculator Example” tab. At the top you will see 4 charts; scroll down to the data and come back to the
charts later. In the data area, you will note that savings and costs are identified for the first 5 years of
the project, and you will see the following:
1.
Project Cost Savings/Income. These are areas where savings are expected to be achieved, and
the amounts that are projected to be saved over each of the first 5 years. Total yearly savings are
shown in blue.
2. Project Expenditures.
2.1. Selection Costs. Note that these are shown in year 0, as they occur prior to starting the
project. The subtotals by item and by year are in orange.
2.2. Implementation Costs. These are one-time costs, but may occur in more than one year. For
example, training may be done at the beginning and then again the next year. (It may even
need to be done at some minimal level every year after the initial training; if that is the case the
recurring training costs go below.) Hardware and software may be purchased incrementally,
depending on the implementation schedule. It is possible that all one-time costs for a small
project will occur in year 1. Part of the implementation cost is an amount that should be set
aside for contingencies. It may only be needed in year 1, and the amount depends on the
project. The subtotals by item and by year are in orange.
2.3. Ongoing Costs. These are costs that will recur year after year. They may not be the same
every year. For example if a business is growing in employees, additional software licenses may
be needed in year 3 for those employees. However, for purposes of these assignments, the
same annual ongoing costs will be used for each year, including year 1. The subtotals by item
and by year are in orange.
Total Project Expenditures are shown in blue.
3. The next two lines on this tab of the spreadsheet show the calculated Cash Flow and the calculated
Cumulative Cash.
3.1. Cash Flow. Cash Flow by year is automatically calculated by the spreadsheet. Cash Flow is
calculated by subtracting the expenditures for the year from the savings for that year. For
example, in Year 1 (not year 0), the savings are projected to be $65,000 and the total
expenditures are $230,000, with a net negative cash flow of $-165,000.
3.2. Cumulative Cash Flow. Cumulative Cash Flow by year is automatically calculated by the
spreadsheet. It is calculated by taking the previous year’s cash flow amount and adding the
current year’s cash flow amount. The cumulative cash flow for year 1 takes the $-20,000 cash
flow from year 0 ($-20,000) and adds the cash flow from year 1 ($-165,000) for a total negative
cumulative cash flow for year 1 of $-185,000. Note that in year 2, the Cash Flow is positive
(savings exceed costs for that year) and in year 3 the cash flow is very positive and the
cumulative cash flow is now positive. Take a quick look at the chart at the top right side of the
sheet and you will see that the “Payback Period” is Year 3 – the year that the accumulated
savings exceed the accumulated expenses.
4. Section 4 provides a place to record any assumptions that have an impact on the cost data.
Examples might be assumptions about how the number of users or transactions might grow over
time, how the business might change over the 5 year period, which users would be given access to
the system (affecting the number of licenses, etc.).
5. Then, scroll to the top of the page on the “ROI Calculations” tab, and you will see 4 charts.
5.1. The lower two charts show the categories of costs and the expenditures in pie charts; this
shows at a glance where the largest savings and the highest costs are.
5.2. The chat in the top left shows the costs and savings by year. Notice what happens in year 3
– the cumulative cash flow (in purple) is above zero.
5.3. The chart in the upper right is the most important one. It shows the calculated Return on
Investment (ROI) for the project. The ROI is calculated by computing the Net Savings (Total
Savings over the 5 year period minus the costs incurred during the 5 year period) and dividing
the Net Savings by the Total Expenditure. Then the payback period is calculated to determine
in which year the accumulated savings exceed the project costs.
HOW TO USE THE CALCULATOR
After reviewing the ”Instructions” tab and the “ROI Calculator Example” tab, and the information above,
open the tab “Costs and Sources.” Here you will enter the list of all components that need to be
acquired (either by purchase, lease, subscription, etc.), the quantity of each required and a unit cost and
a total cost associated with each item. These general cost estimates may be obtained from any source,
but the sources should be cited – for this you should complete the “Source of Cost” column in the
spreadsheet inserting the URL where you found the cost. The categories listed are to help you be sure to
include everything; you may add rows as needed in the spreadsheet. Note that one-time implementation
costs are separated from ongoing repeated costs. Enter your items in the appropriate area. For
example, software costs that are a one-time startup fee would go in the Implementation Costs, while
monthly or annual subscription costs for software would go in the Ongoing Costs. Every item in your
description of resources and your graphical representation needs to be included on the cost spreadsheet.
Next, using the “ROI Calculations” tab on the spreadsheet, transfer the one-time costs to that tab, in item
2.2 under year 1. Copy the recurring annual costs for those items and enter the annual cost in item 2.3;
enter the annual cost in the columns for years 1-5. Then, go to item 2.1 and enter estimates for the
costs of selecting and documenting the proposed solution; use reasonable cost estimates for each
category; note these are entered in the “year 0” column, since they are incurred prior to the acquisition
of the system.
Finally, go to section 1 on the spreadsheet tab and enter several areas where the organization in the
Case Study will realize savings by implementing the system. You should refer to Section IV of your
group’s business case for areas where savings may be realized. You can add other areas where savings
could be expected to come up with a list of four or five areas. The total savings over the five year period
must exceed the total cost of the system, or it will not be approved by the decision-makers. So, think
carefully about all the ways your system will save money for the organization and be sure your total
savings if more than the total costs.
If you use the spreadsheet as it is and use “Insert Row” to add rows where you need them and “Delete
Row” where needed, the spreadsheet will calculate the total savings and the total costs by year for
the first 5 years. The totals are displayed in blue in bold font.
Technology Solution – Individual Assignment
Before you begin this assignment, be sure you have read the Case Study and completed at least
the first three Sections of the Business Case with your group.
Purpose of this Exercise
This activity allows you to demonstrate your understanding of the components of a technology
solution and demonstrate your grasp of the concepts covered in the IFSM curriculum (hardware,
software, data, networks, etc.). This assignment specifically addresses the following course
outcomes to enable you to:

Evaluate, select, and apply appropriate analytical and measurement me …
Purchase answer to see full
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP