Please finish task 1.

Scenario: 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 35 85 105 130 Probability 40% 35% 20% 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. License Costs Minimum Number of Users Per Tier Monthly Per User License Fee Annual System Access Fee T4 100 $6.50 $5,750 T3 75 $7.50 $5,500 T2 50 $9.50 $5,250 T1 25 $15.50 $5,000 Expected Annual Cash Outflows Forecasted Number of Total Users 35 85 105 - 130 Service Tiers Tier 1 Tier 2 Tier 3 Tier 4 Scenario: 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 35 85 105 130 Probability 40% 35% 20% 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. License Costs Minimum Number of Users Per Tier Monthly Per User License Fee Annual System Access Fee T4 100 $6.50 $5,750 T3 75 $7.50 $5,500 T2 50 $9.50 $5,250 T1 25 $15.50 $5,000 Expected Annual Cash Outflows Forecasted Number of Total Users 35 85 105 - 130 Service Tiers Tier 1 Tier 2 Tier 3 Tier 4