Your company is implementing a new Expense Management system that can automate the process of employees submitting home office or travel expenses and managers reviewing and approving them for payment. The new system is licensed from the vendor on a per-user and per-month basis, so when an employee submits an expense, your company is charged for that use of the system. However, the vendor offers a discount if a customer company signs a contract guaranteeing a minimum number of users according to a tiered user structure. For example, if the contract specifies at least 25 users will submit expenses in a month (Tier 1), the per user rate is $15.50; if the contract specifies at least 100 users (Tier 4), the per user rate drops to $6.50 per user. There is also an annual system access fee that is charged regardless the number of users, that differs according to the tier of service. In determining which tier to sign up for, you estimated the number of users who would regularly use the expense system. You found that 35 employees regularly submit expenses, but also found that the other 95 employees submit expenses occasionally. Tasks: 1. In the Cashflows-and-Payoff worksheet, complete the Expected Annual Cash Outflows by calculating the values of the shaded cells. These values should be derived from the License Costs range. Note: carefully review the tiered pricing structure when calculating these amounts. 2. Create a new worksheet titled "Decision-Heuristics" and copy the Expected Annual Cash Outflows to that worksheet. 3. Using the Expected Annual Cash Outflows, formulate a decision model that shows what decision to make using the Maximax, Maximin, and Averaging heuristics to decide which tier of service to subscribe to. Based on your model, answer the questions in the workbook. After reviewing prior expense claims, you estimate the following likelihoods for system usage: # of Users Probability 35 40% 85 35% 105 20% 130 5% 4. Based on this new information, formulate a decision model that shows what decision should be made based on the Expected Monetary Value (EMV) decision heuristic. Based on your model, answer the questions in the workbook. Minimum Number of Users Per Tier Monthly Per User License Fee Annual System Access Fee Service Tiers Tier 1 Tier 2 Tier 3 Tier 4 License Costs T4 100 $6.50 $5,750 T3 75 $7.50 $5,500 Expected Annual Cash Outflows 35 T2 50 $9.50 $5,250 Forecasted Number of Total Users 105 85 T1 25 $15.50 $5,000 130