You are helping the IT team at Game Technology study several software acquisition options for

their Customer Contact Care system $(C^3).$ First, you review Chapter $7$ of your systems analysis

textbook and the material on financial analysis tools $($templates are available on Moodle$).$ The IT

team is considering two commercial software packages and an in$-$house development option.

They prepared the following summary:

$(15$ pts$)$ Perform ROI and NPV $($Use an $8\%$ discount factor$)$ analysis of all three

software development options. Please use the Excel templates on Moodle; each

calculation should be on a single worksheet. Provide SIX worksheets with

appropriate titles on the tabs; highlight the result on each worksheet.

$(5$ pts$)$ Use the results to make two BAR$/$Line charts $-$ one for ROI, one for the NPV;

both charts should contain the comparisons of the three options.

$(5$ pts$)$ Based on the charts, draw a conclusion on the FIRST WORKSHEET $($i$.$e$.,$ ROI

and NPV$)$ of which option to choose from SSI, CRM Corp, or $C^3.$