Gray cells contain calculations that should not be altered.
BIG D CUSTOM SCREEN PRINTING
Technology Budgeting Tool
April 18th 2017
Company Data
Required rate of return
Tax rate
Initial Investment
Hardware costs (e.g., servers, networking hardware, PC upgrades)
10%
30%
YEAR
1
Purchased software costs / licenses (e.g., e-commerce, ERP, CRM software)
$15.000
Development costs (e.g., systems design and configuration / development)
Training costs (e.g., develop and conduct initial training)
Conversion costs (e.g., initial data conversion from existing systems being
replaced)
Website Domain Cost
[Other initial investments]
Total Initial Investments
$27.000
$15.000
Benefits from Technology Strategy
Increased sales and revenue
Reduced personnel costs
Reduced product costs
Reduced distribution costs
Reduced advertising and marketing costs
[Other benefits]
[Other benefits]
3
$6.000
$6.000
$16.000
$225.000
YEAR
1
Total Benefits
Costs (Excluding Initial Capital Investments)
2
$140.000
YEAR
2
3
$30.000.000
$37.000
$18.000
$300.000
$150.000
$88.000
$15.000
$35.000.000
$35.000
$20.000
$200.000
$140.000
$50.000
$17.000
$40.000.000
$16.000
$25.000
$150.000
$170.000
$90.000
$13.000
$30.608.000
$35.462.000
$40.464.000
1
2
3
Depreciation on capital expenditures (calculation uses three-year period)
Software licensing fees
$50.000
$7.000
$75.000
$6.000
$90.000
$8.000
Ongoing user support and training (e.g., help desk and training personnel)
Ongoing systems support (e.g., IT maintenance)
Hosting / Cloud computing
General and administrative
$120.000
$30.000
$17.000
$20.000
$130.000
$25.000
$14.000
$18.000
$150.000
$25.000
$15.000
$15.000
Total Costs
$244.000
$268.000
$303.000
Totals
Net Benefits (Costs)
Tax
Value after tax
Depreciation added back
Cash flow
Cumulative cash flow
Evaluation Metrics
Net present value (NPV)
Internal rate of return (IRR)
Payback period (in years)
Three-year total ROI: (total benefits before taxes - total costs)/total costs
YEAR
1
($225.000)
($225.000)
$60.754.255
9484,75%
0,01
12971,66%
2
$30.364.000
$9.109.200
$21.254.800
$50.000
$21.304.800
$21.079.800
3
$35.194.000
$10.558.200
$24.635.800
$75.000
$24.710.800
$45.790.600
$40.161.000
$12.048.300
$28.112.700
$90.000
$28.202.700
$73.993.300
Running head: IT STRATEGY
1
IT Strategy for [Company Name]
[Student Name]
[Course and Instructor]
IT STRATEGY
2
IT Strategy for [Company Name]
[To introduce your IT strategy, provide an executive summary that clearly describes what
you are recommending and why it will benefit the business. Include a brief summary of the
financial benefits. This introduction should be a paragraph or more, but less than a page.]
Description of the Business
[In one or more paragraphs provide a description of the business and the issues /
opportunities associated with the business. This section should include what is known about the
products, customers, competitors, and financial situation for the case study. The description of
the business should be less than a page.]
IT Strategy Proposal
[In one or more paragraphs, introduce the IT initiatives you are proposing. You must have
at least three initiatives, but you can have more than that.]
[Heading for Initiative One]
[Describe initiative one in detail. Make sure you include how the initiative will benefit
the business. Any technical terms need to be explained so that a business person can understand
what you are proposing. Each initiative should be less than one page.]
[Heading for Initiative Two]
[Describe initiative two in detail.]
[Heading for Initiative Three]
[Describe initiative three in detail.]
Sourcing Strategy
[In one or more paragraphs, describe your sourcing strategy. Will the implementation of
the initiatives be done with in-house or outside resources, or a combination of the two? Will
IT STRATEGY
3
ongoing support be done with in-house or outside resources, or a combination? In other words,
who (what organization) will do the work? You will need to explain why are proposing a certain
strategy. For instance, outside expertise may be needed to supplement the internal personnel
regarding the use of certain technologies. Make sure the financials reflect the costs in your
sourcing strategy.]
Financial Case
[Describe the cost / benefit analysis in one or more paragraphs. Be very clear about how
much the IT initiatives will cost and what the expected benefits will be. Cite resources that you
used to develop your cost / benefit analysis. For instance, you may have found an article on
another company that was able to achieve a 20% increase in sales with an initiative similar to
what you are recommending. The more concrete examples you can cite, the more believable the
financial case will be. After summarizing the financial reasons for your proposal, refer the reader
to Table 1. Update Table 1 on the next page with the data from your return on investment
spreadsheet.]
.
Running head: IT STRATEGY
4
Table 1
Return on Investment
[Company Name]
Initial Investment
Hardware costs
Purchased software costs / licenses
Development costs
Training costs
Conversion costs
[Other initial investments]
[Other initial investments]
Total Initial Investments
Year
1
2
3
$0
$0
$0
$0
$0
$0
$0
$0
Benefits from Technology Strategy
Increased sales and revenue
Reduced personnel costs
Reduced product costs
Reduced distribution costs
Reduced advertising and marketing costs
[Other benefits]
[Other benefits]
[Other benefits]
Total Benefits
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Costs (Excluding Initial Capital Investments)
Depreciation on capital expenditures
Software licensing fees
Ongoing user support and training
$0
$0
$0
$0
$0
$0
$0
$0
$0
IT STRATEGY
5
Ongoing systems support
Hosting / Cloud computing
General and administrative
[Other costs]
[Other costs]
[Other costs]
Total Costs
Totals
Net Benefits (Costs)
Tax
Value after tax
Depreciation added back
Cash flow
Cumulative cash flow
Evaluation Metrics
Net present value (NPV)
Internal rate of return (IRR)
Payback period (in years)
Three-year total ROI
($0)
($0)
$0
0.0%
0.0
0.00%
$0
$0
$0
$0
$0
$0
$333
$0
$0
$0
$0
$0
$0
$333
$0
$0
$0
$0
$0
$0
$333
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Running head: IT STRATEGY
6
Implementation Timeline
[Describe the timeline and sequencing of the IT initiatives in one or more paragraphs.
Make sure the timeline is consistent with the financials. For instance, if initiative three does not
go live until year two, you cannot show any benefits for that initiative in year one. Be very clear
about when the initiatives will be implemented. Will all initiatives be implemented at the same
time or will the initiatives be implemented one at a time? Explain why you are proposing a
specific sequence. In addition to describing the timeline, you can include an APA figure for the
timeline, if that is additive.]
Plan for Sustaining the IT Initiatives
[In one or more paragraphs describe your plan for ongoing operations and support of the
IT investments you are proposing. If you plan to use a particular governance model and / or a
portfolio management approach, describe it here. Include the KPIs (key performance indicators)
that you will use to measure the value of the IT work.]
Summary
[Provide a one- or two-paragraph summary of your IT strategy and how it will add value
to the business.]
IT STRATEGY
7
References
Last Name, F. M. (Year). Article Title 1. Journal Title 1, Pages From - To.
Last Name, F. M. (Year). Article Title 2. Journal Title 2, Pages From - To.
Last Name, F. M. (Year). Article Title 3. Journal Title 3, Pages From - To.
Last Name, F. M. (Year). Article Title 4. Journal Title 4, Pages From - To.
Last Name, F. M. (Year). Article Title 5. Journal Title 5, Pages From - To.
Last Name, F. M. (Year). Book Title. City Name: Publisher Name.
Gray cells contain calculations that should not be altered.
BIG D CUSTOM SCREEN PRINTING
Technology Budgeting Tool
April 18th 2017
Company Data
Required rate of return
Tax rate
Initial Investment
Hardware costs (e.g., servers, networking hardware, PC upgrades)
10%
30%
YEAR
1
Purchased software costs / licenses (e.g., e-commerce, ERP, CRM software)
$15.000
Development costs (e.g., systems design and configuration / development)
Training costs (e.g., develop and conduct initial training)
Conversion costs (e.g., initial data conversion from existing systems being
replaced)
Website Domain Cost
[Other initial investments]
Total Initial Investments
$27.000
$15.000
Benefits from Technology Strategy
Increased sales and revenue
Reduced personnel costs
Reduced product costs
Reduced distribution costs
Reduced advertising and marketing costs
[Other benefits]
[Other benefits]
3
$6.000
$6.000
$16.000
$225.000
YEAR
1
Total Benefits
Costs (Excluding Initial Capital Investments)
2
$140.000
YEAR
2
3
$30.000.000
$37.000
$18.000
$300.000
$150.000
$88.000
$15.000
$35.000.000
$35.000
$20.000
$200.000
$140.000
$50.000
$17.000
$40.000.000
$16.000
$25.000
$150.000
$170.000
$90.000
$13.000
$30.608.000
$35.462.000
$40.464.000
1
2
3
Depreciation on capital expenditures (calculation uses three-year period)
Software licensing fees
$50.000
$7.000
$75.000
$6.000
$90.000
$8.000
Ongoing user support and training (e.g., help desk and training personnel)
Ongoing systems support (e.g., IT maintenance)
Hosting / Cloud computing
General and administrative
$120.000
$30.000
$17.000
$20.000
$130.000
$25.000
$14.000
$18.000
$150.000
$25.000
$15.000
$15.000
Total Costs
$244.000
$268.000
$303.000
Totals
Net Benefits (Costs)
Tax
Value after tax
Depreciation added back
Cash flow
Cumulative cash flow
Evaluation Metrics
Net present value (NPV)
Internal rate of return (IRR)
Payback period (in years)
Three-year total ROI: (total benefits before taxes - total costs)/total costs
YEAR
1
($225.000)
($225.000)
$60.754.255
9484,75%
0,01
12971,66%
2
$30.364.000
$9.109.200
$21.254.800
$50.000
$21.304.800
$21.079.800
3
$35.194.000
$10.558.200
$24.635.800
$75.000
$24.710.800
$45.790.600
$40.161.000
$12.048.300
$28.112.700
$90.000
$28.202.700
$73.993.300
Purchase answer to see full
attachment
