Case $1$: Introducing the Cyan Card at University of BlueGreen

for on campus services and local vendors. $($Like how Crimson Card can be used by you$).$ All $10,000$ student IDs will automatically be enabled with this payment facility at the beginning of the academic year

the tech has given you the following assumptions based on analysis of their internal data from partnerships with colleges like UofBG.

Only $50\%$ of a cohort end up using the feature in the first month

For each subsequent month $15\%$ of current active users discontinue the card $($e$.$g$.,$ in month $2,15\%$ of month $1$ discontinue using, in month $3,15\%$ of month $2$ users discontinue etc.$)$

There are also some additional new users every month. This is assumed to be $5\%$ of the total student body.

Average Monthly spending for active users is $$50$ in the first month and expected to grow at $3\%$ every month.

Your task:

Part $1$

Develop a spreadsheet model to calculate the total payments for the $6-$month period.

Part $2$

The number in assumption #$1$ varied between $30\%$ and $60\%$ in increments of $10\%$

The number assumption #$2$ varied between $5\%$ and $25\%$ in increments of $10\%$

$\{$Hint: Think of which K$-201$ analysis summary would give you such a table and set it up$\}$