Programming Question

MIS 412 – Administration of the IT Function – Summer 2023Name:
Submit your answers in a MS Word document to the D2L dropbox for MIS 412. The dropbox folder is titled
‘Exam 2’.
Time took to complete this exam (hours) _________ (please do not spend more than 3 hours).
Part 1 – Investment Management – 20 Points
You have been asked to assist with preparing for a senior leadership meeting regarding the annual
budget. The ‘wish list’ of projects has been provided by various business units. Your manager has asked
you to consolidate the multiple lists into one and determine a way, in additional to ROI, to categorize
the ‘wish list’ that would aid in decision process of which projects to fund. No further recommendations
regarding categorization was made – you are on your own for this first pass.
Request List
Line of Business
Project
Cost
Corporate Services
HR System Upgrade
$
250,000
1%
Better Information
Corporate Services
Expense System Reporting
General Ledger
Enhancements
HR Application Process
Automation
Payroll System
enhancement
E-mail Records Retention
automation
Legal Document
Repository
Billing system
improvements
Active Directory
Enhancement
$
115,000
1%
Better Information
$
120,000
1%
Better Integration
$
375,000
28%
Cut Costs
$
450,000
11%
Cut Costs
$
550,000
3%
Cut Costs
$
435,000
1%
Cut Costs
$
415,000
2%
Increase Throughput
$
125,000
NA
Business Flexibility
$
350,000
NA
Reduce IT Costs
$
355,000
NA
Reduce IT Costs
Infrastructure
Server Farm Improvement
Recovery System
Replacement
Disaster Recovery
improvements
$
765,000
NA
Standardization
Infrastructure
Exchange Server upgrades
$
375,000
NA
Standardization
Infrastructure
Oracle upgrade
$
645,000
NA
Standardization
Infrastructure
Dell Server Replacement
$
365,000
NA
Standardization
Infrastructure
$
225,000
NA
Standardization
Marketing
Cloud Pilot
Business Intelligence
Program
$
375,000
Marketing
Social Media Tracking
$
Procurement
Order Tracking System
$
Corporate Services
Corporate Services
Corporate Services
Corporate Services
Corporate Services
Corporate Services
Infrastructure
Infrastructure
Infrastructure
MIS 412 – Exam 2
ROI
Business Case/Value
12%
Increased Sales
420,000
8%
Increased Sales
650,000
14%
Better Information
Category
Page 1 of 6
MIS 412 – Administration of the IT Function – Summer 2023
Procurement
Procurement
Agencies
Agencies
Agencies
Agencies
Corporate Management
Corporate Management
Upgrade Purchasing
System
Order Management
System
$
450,000
9%
Better Information
$
160,000
5%
Increased Control
Client Profile Upgrade
New Underwriting System
features
Enhanced Performance
Reporting
$
825,000
4%
Faster Cycle Time
$
750,000
8%
Competitive Advantage
$
750,000
7%
Competitive Advantage
Mobile Enablement
Cross LOB Real-time policy
premium vs claim analytics
Reduce Application
inventory
$
925,000
5%
Competitive Advantage
$
580,000
12%
Better Information
$
245,000
3%
Better Integration
Helpful hints
Question 1 [4 points]: After your initial shock wore off, you recall an article that you read in an
MIS class you took at Metropolitan State University with the title of “Generating Premium
Returns on Your IT Investments” by Weill and Aral. From the article, fill in the average
percentage allocations for the following investment categories:
Category
Infrastructure
Transactional
Informational
Strategic
Total
Average Industry Percent Allocation
100%
Question 2 [4 points]: Based on an $9 million dollar annual budget calculate how many dollars
should be allocated to each category:
Category
Infrastructure
Transactional
Informational
Strategic
Total
Budget Allocation in USD
$9,000,000
Question 3 [4 points]: Using the category recommendations from the article “Generating
Premium Returns on Your IT Investments” by Weill and Aral fill in the category column of the
Request List, and fill in the category totals in USD in this table.
MIS 412 – Exam 2
Page 2 of 6
MIS 412 – Administration of the IT Function – Summer 2023
Category
Infrastructure
Transactional
Informational
Strategic
Total
Request List totals in USD
Question 4: [8 points] Using APO05 and APO06 propose a four-step process to be used to
objectively determine which projects to fund. Be specific and reference management practices.
(Hint: APO06.02, APO06.03, APO05.01, APO05.02, APO05.03, APO05.05 could be important.)
Step 1:
Step 2:
Step 3:
Step 4:
Part 2: Outsourcing – 6 points
Referring to the slides for Globalization answer the following
Question 1 [6 points]: List 3 types of outsourcing models, and describe the risk to your company
for each model.
1. Model:
Who owns risk
2. Model
Who owns risk
3. Model
Who owns risk
MIS 412 – Exam 2
Page 3 of 6
MIS 412 – Administration of the IT Function – Summer 2023
Part 3: Process Improvement– 12 points
Victor, an IT Director, has chosen you to lead a process improvement effort. However as the effort
to introduce ‘DevOps’ to improve your company’s time to get applications into production some
people problems have surfaced. Some are resistant, some are anxious, and some are just plain
frustrated. You recall from the MIS 412 class that you took there are some methods that can be
utilized to address these problems. From slides ‘Change Management 102’ (that are in D2L (Hint:
SLIDE 11)), and the article “Choosing Strategies for Change” by Kotter and Schlesinger, you
determine some ways to address these problems:
Question 1 [4 points]: Describe, in your own words, why are people typically anxious and how
best to help them?
Question 2 [4 points]: Describe, in your own words, why are people typically frustrated and
how best to help them?
Question 3 [4 points]: Describe, in your own words, why are people typically observe false
starts and how best to help them?
MIS 412 – Exam 2
Page 4 of 6
MIS 412 – Administration of the IT Function – Summer 2023
Part 4: CEO Priorities for IT (6 points)
Based on these findings from CIO Magazine, you realize that a number of these challenges were covered
by the MIS 412 class that you took. Match the selected Priority Items to the MIS 412 topic that
addressed that concern.
MIS 412 Topic choices
A. Governance, Risk and Compliance (GRC)
B. Manage Innovation
C. Risk Management
D. COBIT
E. Is IT going the right thing? (Demand or Investment Management)
MIS 412 – Exam 2
Page 5 of 6
MIS 412 – Administration of the IT Function – Summer 2023
F. IT can always do better (Change Management)
Indicate the Best Match (A..F from above) to each priorities below:
1.
2.
3.
4.
5.
6.
Strengthen IT and Business Collaboration
Best Match:
Upgrade IT and Data security to reduce corporate risk
Best Match:
Lead digital business/digital transformation initiatives
Best Match:
Reduce or rationalize IT Spending
Best Match:
Lead a product innovation effort
Best Match:
Adhere to environmental, social, and governance (ESG) priorities Best Match:
MIS 412 – Exam 2
Page 6 of 6