ANSWER QUESTION 3 AND 4 PLEASE
ipboard Font Paragraph 2 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 Business Case/Value Cost ROI Category Corporate Services HR System Uprade $ 250,000 196 Better Information Corporate Services $ 115,000 196 Better Information Corporate Services $ 120,000 196 Better Integration Corporate Services $ 375,000 2896 Cut Costs Corporate Services $ 450,000 1196 Cut Costs Corporate Services $ 550,000 396 Cut Costs Corporate Services $ 435,000 196 Out Costs Corporate Services Expense System Reporting General Ledger Enhancements HR Application Process Automation Payroll System enhancement E-mail Records Betection automation Legal Document Repository Billing system improvements Active Directory Enhancement Server Farm Improvement Recovery System Replacement Disaster Recovery improvements Exchange Server upgrades Oracle upgrade Dell Server Replacement $ 415,000 296 Increase Throughput Infrastructure $ NA Business Flexibility 125,000 350,000 Infrastructure $ NA Reduce IT Costs Infrastructure $ 355,000 NA Reduce IT Costs Infrastructure $ 765,000 NA Standardization Infrastructure $ NA Standardization Infrastructure $ 375,000 645,000 735,000 NA Standardization Infrastructure $ NA Standardization Standardization Infrastructure $ 225,000 NA Marketing $ 1296 Increased Sales Marketing $ 375,000 420,000 650,000 896 Increased Sales Procurement $ 1496 Better Information Procurement $ 450,000 996 Better Information Procurement $ 160,000 596 Increased Control Cloud Pilot Business Intelligence Program Social Media Tracking Order Tracking System Upgrade Purchasing System Order Management System Client Profile Upgrade New Underwriting System features Enhanced Performance Reporting Mobile Enablement Cross LOB Real-time policy premium vs claim analytics Reduce Application inventory Agencies $ 825,000 496 Faster Cycle Time Agencies $ 725,000 896 Competitive Advantage Agencies $ 750,000 796 Competitive Advantage Agencies $ 925,000 596 Competitive Advantage Corporate Management $ 580,000 1296 Better Information Corporate Management $ 165,000 396 Better Integration 9 1267 words 3 lo Styles Editing Voice Sensitivity 2 3 1 6 7 Question 1 (2 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 Average Industry Percent Allocation Infrastructure Transactional Informational Strategic Total 100% Question 2 [2 points]: Based on an $8.5 million dollar annual budget calculate how many dollars should be allocated to each category: Category Budget Allocation in USD Infrastructure Transactional Informational Strategic Total $8,500,000 Question 3 [5 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. Category Request List totals in USD Infrastructure Transactional Informational Strategic Total 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: Focus 00 + 100% ipboard Font Paragraph 2 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 Business Case/Value Cost ROI Category Corporate Services HR System Uprade $ 250,000 196 Better Information Corporate Services $ 115,000 196 Better Information Corporate Services $ 120,000 196 Better Integration Corporate Services $ 375,000 2896 Cut Costs Corporate Services $ 450,000 1196 Cut Costs Corporate Services $ 550,000 396 Cut Costs Corporate Services $ 435,000 196 Out Costs Corporate Services Expense System Reporting General Ledger Enhancements HR Application Process Automation Payroll System enhancement E-mail Records Betection automation Legal Document Repository Billing system improvements Active Directory Enhancement Server Farm Improvement Recovery System Replacement Disaster Recovery improvements Exchange Server upgrades Oracle upgrade Dell Server Replacement $ 415,000 296 Increase Throughput Infrastructure $ NA Business Flexibility 125,000 350,000 Infrastructure $ NA Reduce IT Costs Infrastructure $ 355,000 NA Reduce IT Costs Infrastructure $ 765,000 NA Standardization Infrastructure $ NA Standardization Infrastructure $ 375,000 645,000 735,000 NA Standardization Infrastructure $ NA Standardization Standardization Infrastructure $ 225,000 NA Marketing $ 1296 Increased Sales Marketing $ 375,000 420,000 650,000 896 Increased Sales Procurement $ 1496 Better Information Procurement $ 450,000 996 Better Information Procurement $ 160,000 596 Increased Control Cloud Pilot Business Intelligence Program Social Media Tracking Order Tracking System Upgrade Purchasing System Order Management System Client Profile Upgrade New Underwriting System features Enhanced Performance Reporting Mobile Enablement Cross LOB Real-time policy premium vs claim analytics Reduce Application inventory Agencies $ 825,000 496 Faster Cycle Time Agencies $ 725,000 896 Competitive Advantage Agencies $ 750,000 796 Competitive Advantage Agencies $ 925,000 596 Competitive Advantage Corporate Management $ 580,000 1296 Better Information Corporate Management $ 165,000 396 Better Integration 9 1267 words 3 lo Styles Editing Voice Sensitivity 2 3 1 6 7 Question 1 (2 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 Average Industry Percent Allocation Infrastructure Transactional Informational Strategic Total 100% Question 2 [2 points]: Based on an $8.5 million dollar annual budget calculate how many dollars should be allocated to each category: Category Budget Allocation in USD Infrastructure Transactional Informational Strategic Total $8,500,000 Question 3 [5 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. Category Request List totals in USD Infrastructure Transactional Informational Strategic Total 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: Focus 00 + 100%
