Unit 03: Project Initiation and Selection

Lecture slides and video

Feasibility Study – Alans Best Chocolates

Business Case – Smith Consulting

1. Practice using the CalculateProjectNPV_B.xlsx spreadsheet to calculate costs and benefits for the Customer Tracking System (Pine Valley Furniture) as you read Chapter 5 in Modern Systems Analysis and Design (MSAD).  Apply the spreadsheet to illustrate cost/benefit analysis, including: Cash flow analysis, use of Net Present Value (NPV) in calculating Return on Investment (ROI), and break-even analysis
2. Apply the CalculateProjectNPV_B.xlsx spreadsheet to Case Study 1: Teradata Data Mart Consolidation Return on Investment at GST to illustrate cost/benefit analysis, including: Cash flow analysis, use of NVP in calculating ROI for the Data Mart Pilot Project, and break-even analysis
3. How does the project structure illustrated in the Microsoft Project Software Development Plan template (accessible in  zip file) compare with the project plan presented in Exhibit 10 of the Teradata Data Mart Consolidation ROI case study?

Post your answers to  all 3 questions in a single PDF file to Unit #3 Case  Study 1 in Canvas that you name: Unit-3_Assignment_My-Name.pdf where MyName is your name.  E.g. “Unit-3_Assignment_David-Lanter.pdf”.  Be sure to put your name in the top section of your document, include each question number and question and explain your answers in the body of your assignment document.

No comments are required for Unit #3 this week.

Use the CalculateProjectNPV_B.xlsx spreadsheet to calculate costs and benefits for the Customer Tracking System (Pine Valley Furniture) as you read Chapter 5 in Modern Systems Analysis and Design (MSAD).  Apply the spreadsheet to illustrate cost/benefit analysis, including: Cash flow analysis, use of Net Present Value (NPV) in calculating Return on Investment (ROI), and break-even analysis.

Include a copy of your spreadsheet (and answers to all questions this week) with your answers to this question in a PDF file that you name: Unit-3_Assignment_MyName.pdf where MyName is your name.  E.g. “Unit-3_Assignment_DavidLanter.pdf”

Apply the CalculateProjectNPV_B.xlsx spreadsheet to Case Study 1: Teradata Data Mart Consolidation Return on Investment at GST to illustrate cost/benefit analysis, including: Cash flow analysis, use of NVP in calculating ROI for the Data Mart Pilot Project, and break-even analysis

Include a copy of your spreadsheet (and answers to all questions this week) with your answers to this question in a PDF file that you name: Unit-3_Assignment_MyName.pdf where MyName is your name.  E.g. “Unit-3_Assignment_DavidLanter.pdf”

How does the project structure illustrated in the Microsoft Project Software Development Plan template (accessible in  zip file) compare with the project plan presented in Exhibit 10 of the Teradata Data Mart Consolidation ROI case study?