Borger Management Accounting System Upgrade: Real-Time Financial Reporting

This assignment involves developing an Acquisition Strategy Statement for a project to hire a software designer to create new accounting software. The statement outlines the goals, requirements, and risks associated with the project. It also provides an economic analysis of alternative solutions, including hiring an employee, using software as a service (SaaS), and creating patches for needs not met by SaaS. The assignment requires the development of a WBS (Work Breakdown Structure) for each alternative solution, as well as a Gantt chart to illustrate the project timeline. Additionally, it involves preparing a Performance Requirements Summary (PRS) for the recommended solution.

Organization:
Component:
Submitted By:
Date:
Borger Management, Inc.
Accounting Department
Markeeda Guest-Spencer
September 17, 2016
Description of the
Problem
A Property Management Company uses many different accounting
systems that don’t communicate with one another. The 1 person
accounts payable department uses… Timberline Software. The 2 person
accounts receivable department (as well as the 40 on-site property
managers) uses Rentroll Software. The General Ledger and Financial
Statements are maintained on MRI. None of the software is compatible
to the other. Borger Management faces a problem of gathering
information from different platforms and converting them to a single
platform to create the financial statements.
Business Activities
and Processes
Affected by the
Problem
Preparing monthly financial statements for the property owners is a
tedious week-long process. Outside consultants were hired to convert the
data from all of the various software packages so that it could then be
imported into MRI. This process resulted in many errors every month.
The monthly expenses for the consultants are massive. The system
errors became more frequent and the 1-person IT department was unable
to handle the increased system problems. Additionally, due to the
multiple systems---true and accurate financial data is never available
until month end.
Actual
Performance (e.g.,
current baseline)
Presently, consultant fee expenses that are passed on to property owners
are averaging $17,000 per month.
Target
Performance
Saving time, man hours and money will drastically increase property
owner profit, management fee revenue and owner satisfaction &
retention.
Performance Gap Currently, it takes 7 days to prepare reports working 10 hours a day i.e.,
70 hours. So if we have a simple and combined software, it will reduce
the work to 2 days i.e. 20 hours. Thus this will also reduce the cost.
Hence all three time, man hours and money will be saved.
Organizational
KPI’s Affected
Management Fee Revenue
Principle
Stakeholders
CFO; Accounts Receivable department; Accounts Payable Department;
IT Department; Property Owners.
Tentative Solution
Strategy
Creating/Designing/Purchasing a single system with different modules
(A/P, GL, A/R) that are able to communicate and produce data/reports in
real time.
Acquisition We/I confirm that this problem can only be solved through the

Need/Confirmation acquisition of IT services (and IT products as needed) from a contractor
selected in open competition.
Activity 2
OBJECTIVE OF THE REQUIREMENTS:
Reduce the amount of time and money required to
prepare financial statements, as stated in the
Performance Gap document
REQUIREMENTS CATEGORY REQUIREMENTS DEFINITION
1. Stakeholder Considerations that Need to be
Reflected in the Solution (including the expectations
and satisfaction managers, internal users, and external
customers) and factors related to the business
environment)
CFO seeks increased profit resulting from increased management
revenue. Property owners benefit from having increased rent
revenue as well as real-time financial statement available.
2. Factors to Take Into Account Related to the
Business Environment (including legal factors,
regulations, competition, and business cycles)
Competitors have the capabilities described here
3. New Capabilities and/or Functionality Required
by a Solution (including requirements for ease of use,
quality, interoperability, and data sharing)
A software solution is needed that will eradicate the
cumbersome data conversion process which will in turn increase
the quality and accuracy of financial statement preparation.
System must be able to capture data, integrate with other
management functions (i.e. payroll imports) and produce
accurate and reliable real-time financial reports. System must be
user friendly, fast and flexible, and able to cross function with all
accounting department needs.
4. Existing Business Process Shortfalls (why current
business process and/or systems cannot meet the needs
or be changed to meet the needs)
Current software being used is dependent on outside consultant
help for converting data into a useful format. The multiple
accounting software modules cannot interface with one another.
5. Cost Limitations (may be stated in terms of
preferred cost range; may specify a maximum cost; cost
figures need to include associated overhead costs; may
be specified as an annual limit or life cycle limit or
both)
Expected cost is $100,000 for software system design. Total
project cost, including implementation and training and
overhead, is expected to be between $250,000 to $300,000.
6. Other Limitations or Constraints (e.g., availability
of key personnel, such as subject matter experts,
training methods and time available for training,
limitations related to maintenance or to external
support).
Must be easy to learn. Off-site resident managers (end users) are
not overly familiar with computerized systems. Additionally,
due to the small size of the IT department, the new software must
also have high reliability with automatic online updates, reducing
dependence on IT staff.
7. Security & Privacy Requirements (any
requirements beyond those currently being used by the
organization for non-critical and non-sensitive
applications)
Upgraded server room with the highest security to avoid theft
and damage. Updated firewalls to protect server data.
8. Number to be Implemented (e.g., specify the
number of places the solution will need to be
implemented and whether they are at different
geographical locations)
The solution must be provided for four workstations in the
corporate office, and 25 work stations at off-site resident
manager offices throughout the Washington, DC area.
9. Schedule (explain any schedule constraint, whether
for financial or non-financial reasons--e.g., if the
solution be in place as of a certain date, specify the date
Acquire and implement within next six months (01/01/17 -
06/30/17). Doing so within three months brings quicker financial
benefits.

and why)
10. Other Requirements Not Specified Above (e.g.,
any related to vendors, consultants, partnerships with
other entities, unique user interface requirements,
documentation needs, special certification
requirements)
Due to IT department size and expertise, the new software must
require minimal in-house support; online training and tech
support is necessary.
Activity 3
OBJECTIVE:
Reduce the amount of time and money required to prepare
financial statements, as stated in the Performance Gap
document
Name of Solution Alternative Summary Description of Solution That Meets the Stated
Requirements
Alternative Solution #1: Acquire
an In-house staff position to
replace consultants
Hire an employee/employees whose major responsibility would be
to take on the duties of the current consulting firm.
Alternative Solution #2: Hire
Software Designer to create new
accounting software
Hire software designer to create a single accounting system which
will have different modules yet in the same format. In other words,
the new process will have different modules like: Accounts
payable, Accounts receivable and general ledger.
Alternative Solution #3: Use
Software as a Service
Contract with a Software as a Service (SaaS) provider such as
Quickbooks or Sage to obtain the functionality required via the
Web.
Alternative Solution #4: Re-
negotiate with consultants
Re-negotiate contract with consultants. Perhaps they can train
current staff to perform some of their duties to reduce consultant
expenses.
IT Acquisition Confirmation
Each alternative solution described above requires the acquisition
of IT services from an external IT service provider selected in
open competition.

Activity 4
Alternative
Solution
Responsiveness
to Requirements
Feasibility
(Capable of
Being
Successful)
Enterprise
Architecture
Risks and
Constraints Affordability New
Opportunities
Rank
Order
Altern. #1
Acquire In-
house position
to replace
consultants
Potentially could
meet all
requirements
Feasible Supports; no
conflict
Employee
knowledge-
constraint
Relatively low,
affordable cost,
assuming employee
can complete
required tasks.
None beyond
meeting the
current
objectives
2
Altern. #2 Hire
software
designer to
create new
accounting
software
.Can meet all
requirements Feasible Supports; no
conflict
No experience with
software design and
implementation
Likely greater
initial cost, but
affordable if
consultant
expenses are
reduced
Increased
opportunities
with potential
owners once
they see
advanced tech
1
Altern. #3
Use Software
as a Service
(SaaS)
Potentially could
meet all
requirements
Probably
Feasible
Depends on
interface
requirements of
the host
organization
May not meet all of
the requirements.
Possibly quick
implementation
with least initial
and on-going cost,
depending on the
host's interface
requirements
Host may offer
access to
valuable new
capabilities at
relatively low
cost
3
Altern. #4
Re-negotiate
with
consultants
.Can meet all
requirements
Not Likely
feasible
Supports; no
conflict .
Take risk in asking
consultants to train
staff. Increased
costs if staff isn’t
able to comply.
Likely highest cost
with no real
solutions to the
objectives
None 4
Activity 5

Alternative Solution #1 (Tentative Solution Rank Order #2): Acquire In-
house Position to Replace Consultants - Hire an employee/employees whose major
responsibility would be to take on the duties of the current consulting firm. Alternative
Solution #1 (Tentative Solution Rank Order #2): Acquire In House Staff
Position to Replace Consultants – Hire an employee/employees whose major
responsibility would be to take on the duties of the current accounting firm.
.
Risk Category Proba
bility
Impact If
Occurs Mitigation Strategy
Approx.
Risk
Exposure
Risk
Priority
Organizational Risk
a. New hire may not be
able to fulfill the extensive
duties of the consultant
Scope creep (users may
increase functionality
requirements)
b. Users may resist use of
new system
c. Possible loss of
executive support during
project due to new
priorities
a. 250%
b.50%
c. 20%
a. $10,000-
30,00020,000 -
$50,000
b. $5,000 -
$20,000
c. $10,000 -
$30,000
a. Seek and hire top level candidates,
ensure thorough training is available
by consulting firm. As a last resort,
maintain relationship with current
consultants until employee is Use of
representative IPT; frequent
meetings with users to inform and
prevent misunderstandings
b. Pre-sell new system, provide
training; remove old systems as of a
specified date
c. Frequent executive briefings;
stress link to the organization's key
performance indicators
a. $2,500-
7,500 -
$10,000
b.$2,500 -
$10,000
c. $2,000 -
$6,000
a. MM
b. M
c. M
Information Security and
Privacy Risk
Potential loss of control of
proprietary graphics
20% $15,000 -
$50,000
Identify proprietary graphics at
outset; establish and test security
measures to safeguard them
$3,000 -
$10,000 M2
Complexity Risk
a. Possible unrecognized
assumptions
b. Accuracy in forecasting
costs and benefits
a. 20%
b. 10%
a. $5,000 -
$20,000.
b. $5,000 -
$10,000
Require all estimates and
assumptions to be justified; obtain
independent verifications of
assumptions and estimates; assign
responsibility for specific
assumptions and estimates to
individuals by name and hold them
accountable for their accuracy.
a. $1,000 -
$4,000
b. $500 -
$1,000
a. L
b. L
Infrastructure Risk
Possible interoperability
Problem
. 15% .$2,000 -
$10,000
May require onsite tech support by
vendors of current software to
identify and address potential
problems
$300 -
$1,500 L
External Risk Contractor
underperformance in
training
20% $10,000 -
$20,000
Requires current consulting firm to
adequately train new employee.
$2,000 -
$4,000 L
. Average
Probability
. Total Approximate Risk Exposure: $8,800 -
$28,000 .

18.33%
Alternative Solution #2 (Tentative Solution Rank Order #1): Hire Software
Designer to Create New Software - Hire software designer to create a single
accounting system which will have different modules yet in the same format. In other words,
the new process will have different modules like: Accounts payable, Accounts receivable
and general ledger.
.
Risk Category Proba
bility
Impact
If
Occurs
Mitigation Strategy
Approx.
Risk
Exposure
Risk
Priority
Organizational Risk
a. Scope creep (users may
increase functionality
requirements)
b. Users may resist use of
new system
c. Possible loss of IT
support during project
due to new priorities
a. 20%
b.20%
c. 30%
a. $20,000 -
$50,000
b. $5,000 -
$20,000
c. $10,000 -
$30,000
a. Use of representative IPT; frequent
meetings with users to inform and
prevent misunderstandings
b. Pre-sell new system, provide
training; remove old systems as of a
specified date
c. Frequent executive briefings;
trainings, brainstorming sessions
a. $4,000 -
$10,000
b.$1,000 -
$4,000
c. $3,000 -
$9,000
a. M
b. L
c. M
Information Security
and Privacy Risk
Potential loss of
accounting functions
15% $10,000 -
$30,000
Identify proprietary accounting
functions and design needs at outset;
establish and test security measures to
safeguard them
$1,500 -
$4,500 L
Complexity Risk
a. Possible unrecognized
assumptions
b. Accuracy in
forecasting costs and
benefits
a. 20%
b. 10%
a. $1,000 -
$10,000.
b. $5,000 -
$10,000
Outline all requirements. Have task
sessions with design team to make sure
all deliverables are covered. Extensive
testing prior to implementation with end
user input.
a. $200 -
$2,000
b. $500 -
$1,000
a. L
b. L
Infrastructure Risk
Possible interoperability
Problem
. 10% .$2,000 -
$5,000
Require design team to identify and
address potential problems $200 - $500 L

External Risk Designer
underperformance 10% $5,000 -
$10,000
Require certification of the software
design firm.
$500 -
$1,000 L
.
Average
Probability
16.87%
. Total Approximate Risk Exposure: $10,900 -
$32,000 .
Alternative Solution #3 (Tentative Solution Rank Order #3): Use Software as
a Service (SaaS) - Use Software as a Service (SaaS) .
Risk Category Proba
bility
Impact
If
Occurs
Mitigation Strategy
Approx.
Risk
Exposure
Risk
Priority
Organizational Risk
a. Scope creep (users
may increase
functionality
requirements)
b. Users may resist use
of new system
c. Possible loss of
executive support
during project due to
new priorities
a. 20%
b.50%
c. 30%
a. $20,000
- $50,000
b. $5,000 -
$20,000
c. $15,000
- $35,000
a. Use of representative IPT; frequent
meetings with users to inform and prevent
misunderstandings
b. Pre-sell new system, provide training;
remove old systems as of a specified date
c. Frequent executive briefings; stress link to
the organization's key performance indicators
a. $4,000 -
$10,000
b.$2,500 -
$10,000
c. $4,500 -
$10,500
a. M
b. M
c. M
Information Security
and Privacy Risk
Potential I/S risk with
online accounting
40% $25,000 -
60,000
Identify needs to provide more security and
firewalls for data security.
$10,000 -
$24,000 H
Complexity Risk
a. Possible
unrecognized
assumptions
b. Accuracy in
forecasting costs and
benefits
a. 20%
b. 10%
a. $5,000 -
$20,000.
b. $5,000 -
$10,000
Require all estimates and assumptions to be
justified; obtain independent verifications of
assumptions and estimates; assign
responsibility for specific assumptions and
estimates to individuals by name and hold
them accountable for their accuracy.
a. $1,000 -
$4,000
b. $500 -
$1,000
a. L
b. L
Infrastructure Risk
Possible
interoperability
Problem
. 40% .$15,000 -
$30,000
Identify needs and test from outset. Design
and create patches for needs not met by SaaS
$6,000 -
$12,000 M
External Risk No
experience with SaaS 15% $10,000 -
$20,000
Software has always been designed to
company specifications. Requirements
probably will not be met by SaaS
$1,500 -
$3,000 L

.
Average
Probability
28.12%
. Total Approximate Risk Exposure: $22,500 -
$74,500 .
Activity 6
WBS For Alternative #2
WBS For Alternative #3

Activity 7
Economic Analysis of Alternative Solutions
Introduction The purpose of the Acquisition Strategy
Statement is to serve as the roadmap for
guiding contractor solicitation, contractor
selection, and implementation project
activities from initiation of the
implementation project to its operations and
ultimate disposal at the end of its useful life.
This document will be approved by senior
management before it is being distributed. It
then becomes a "living document" in the
sense that it is updated as decisions are made
and new information will become available.
NPV versus ROI ROI will be more preferable for the
alternative solution 1, 2 and 3 as it will give
the value in percentage like 40% of ROI will
be achieved but for alternative 1, 2 and 3 ROI
and NPV both are required in order to get the
adequate financial data.
Providing data for the economic analysis For alternative solution 1, the total risk
exposure is $8,800-$28,000. And for
alternative solution 2, the total risk exposure
is $10, 900- $32, 000. And for the alternative
solution 3, the total risk exposure is $22,500-
$74,500. As it can be concluded that the

alternative solution 1 will be more
economically feasible.
Risk data and risk adjustments In all the three alternatives the organizational
risk, privacy risk, complexity risk,
infrastructure risk and external risk will be
adjusted by mitigating the various strategies
for each alternatives which will be
economically feasible.
benefits data and cost data The professional approach need to be
implemented for the cost data and the
alternative 2 is most suitable as can be seen in
the WBS of the alternatives.
Selecting a common life cycle period The common life cycle period will be of three
years as the selected alternative will give the
best output. As the software will work
without becoming obsolete.
Activity 9
Acquisition of new accounting software will reduce labor hours, time, errors and overall costs. Improved
business quality and maintenance of data are huge benefits. This acquisition could result in savings of
$200,000 annually.
Activity 10
Acquisition Strategy Statement
Name of IT Services Acquisition Project: Hire Software Designer to Create New Software
Submitted by: Markeeda Guest-Spencer Date Submitted: 10/29/16
ACQUISITION STRATEGY STATEMENT
1. Proposal Summary Purchasing a single system with different
modules (A/P, GL, A/R) that are able to
communicate and produce data/reports in real
time in order to issue to problem of errors and
reduces man hours and the money. Expected
cost is $100,000 for software system design.
Total project cost, including implementation

and training and overhead, is expected to be
between $250,000 to $300,000. The solution
must be provided for four workstations in the
corporate office, and 25 work stations at off-
site resident manager offices throughout the
Washington, DC area. Acquire and implement
within next six months (01/01/17 - 06/30/17).
Doing so within three months brings quicker
financial benefits.
2. System Life Cycle The SLC will include the following steps
from initiation to disposal in our project:
1. Defintion- issue of gathering information
from different platforms and converting them
to a single platform.
2. Investigation and analysis- the software are
not compatible enough on one another.
3. Design- a single system with various
modules which will be able to communicate
and produce data in real time.
4. Implementation- implementing a software
which will reduce man hours and money in
order to prepare financial statements.
5. Testing- the software will be tested in the
company itself in order to know its
effectiveness.
6. Installation- after clearing the testing
process, the software will be finally installed.
7. Documentation- documents will be
prepared which will include all the details like
cost, time, risk, etc.
8. Evaluation- the outcomes will be evaluated
of the new software as compared to the
previous one.
9. Maintenance- the software will be
maintained periodically in order to run
smoothly.
3. Basic Acquisition Approach
 Market Research
The alternatives like hiring an employee,
software designer, contract with the software
as a service will require the acquisition of IT
services from an external IT service provider
which will be selected in open competition.
The market research will be conducted by
gathering information from the surveys and
the information from the competitor’s reports.

 Use of Competition
 Potential Sources
 Contract Type
 Contract Incentives and Penalties
 Risk Assessment
The competition will be built between the
fixed price contractors and the reimbursement
contractors.
The potential sources will be identified on the
basis of interviews and they will be supposed
to fill the questionnaire.
Fixed price contract will be used as the
product has moderate risk and the contract
will provide for a price that will not be
subjected to any adjustment on the basis of
the cost experience of the contractor in
performing the contract.
Incentives can be provided when the
contractors will complete the work before the
agreed time and the penalties will be imposed
if they will fail to meet the agreed
commitments.
Risk that the user will not be fully satisfied
because of judgmental criteria of acceptance
i.e. uncertain contract labor or material
requirement. This risk can be managed by
identifying the cost of labor and material
adequately.
Activity 11.
Develop a Gantt
chart, using Microsoft Project, for the WBS you created for the alternative
solution you selected as best.
A discussion of Gantt charts and an illustration of a Gantt chart generated using Microsoft
Project are
provided at
http://www.iteconcorp.com/T11Gantt.html
.
The illustration is similar to what you will
produce for your Activity 11. It illustrates the level of detail appropriate for the Gantt chart you
prepare
for your project. Submit your Gantt chart as an .mpp file (a file produced by Microsoft Project

Activity 12
.
Prepare the Performance Requirements Summary for your recommended solution. Use the
PRS template in the IT Economics document (see link below) titled "Performance Work
Statements."
This statement will be the heart of your request for proposal, assuming you will prepare and
distribute
one to solicit proposals. (You will not be asked to prepare an RFP in this course.
USE THE FOLLOWING TEMPLATE FOR THIS….TEMPLATE IS LOCATED AT THIS
LINK…..
http://www.iteconcorp.com/T12PBWS.html