4

ISM645 Business Initiative IT Planning Matrix Worksheet v 1.2

The following worksheet will help you develop a matrix of IT Systems or Initiatives required driven by the Business Initiatives as communicated in the Corporate Strategy. IT Strategic Plan to Support Business Initiatives Use the following matrix to list the IT systems that are required to support the planned business initiatives. Ensure to include any necessary notes. Business Initiative

IT System or Initiative Required

Year(s) this project will take place

Ball Park Estimates Time (# Days)

Resources (# FTE)

Cost ($)

Approved (Y/N)

Related Notes: Here is an Example of an IT Initiative to Business Initiative Matrix: Business Initiative

IT System or Initiative Required

Year(s) this project will take place

Ball Park Estimates

Time Resources Cost Approved

Loyalty Campaign

E-mail Distribution System

2014 n/a n/a n/a Yes

Mail Out Satisfaction Survey

E-mail Distribution System

2014 (See note 1)

40 days

2 FTE $10,000 No

10% Off “New Purchase” Campaign

E-mail Distribution System

2015 (See note 2)

20 days

1 FTE $5,000 Yes

All Campaigns

Campaign Reporting System

2014-2016 (See note 3)

200 days

2 FTE $10,000 Yes

Expand into Asia

Servers, Workstations

2016 40 days

3 FTE $50,000 Yes

Develop Related Product X

Product X 2016 200 days

10 FTE $100,000 Yes

Related Notes:

1. Survey Capable. Our current e-mail distribution system is not capable of handling in-line survey questions. We will need to add support for this capability. We are assuming we will go with the simplest solution (link to a survey Web page) and will create our own survey instead of purchasing a survey package.

2. Coupon Capable. Our current e-mail distribution system is not capable of handling attachments or coupons. We will need to add support for this capability. We are assuming we will go with the simplest solution (embedding the coupon in the e-mail).

3. The new Campaign Reporting system will consist of the following project components: a. Define brand/product performance metrics b. Develop data warehouse architecture c. Design/build data warehouse/data marts d. Design/build ETL mechanisms e. Design/build dashboards, queries, and reports