Your company is implementing a new Expense Management system that can automate the process of employees...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Business and Administrative Communication
ISBN: 978-0073403182
10th edition
Authors: Kitty o. locker, Donna s. kienzler
Posted Date:
Students also viewed these general management questions
-
A delivery company is implementing a system to compare the costs of purchasing and operating different vehicles in its fleet. Truck 415 is driven 125,000 miles per year at a variable cost of $0.13...
-
Home Service Company offers monthly service plans to provide prepared meals that are delivered to customers' homes and need only be heated in a microwave or conventional oven. Home Service offers two...
-
Implementing an environmental management accounting (EMA) system can have several challenges. To follow are several implementation scenarios. For each scenario, identify which type of implementation...
-
JinsAppliances has a return-on-assets (investment) ratio of 8 percent. a. If the debt-to-total-assets ratio is 40 percent, what is the return on equity? b. If the firm had no debt, what would the...
-
If a motion picture company wanted to find specific guidance on how to recognize revenue related to its film licensing rights, would it find more specific industry guidance under U.S. GAAP or IFRS?...
-
Explain why feminist economists criticize the use of GDP as a measure of well-being.
-
For the chemical reaction \[ \mathrm{N}_{2} \mathrm{O} ightarrow \mathrm{N}_{2}+\frac{1}{2} \mathrm{O}_{2} \] \(\Delta H=-20000\) cal and \(\Delta S=18\) e.u. Will the reaction be spontaneous at...
-
Inventoriable CostsPerpetual Bradford Machine Company maintains a general ledger account for each class of inventory, debiting such accounts for increases during the period and crediting them for...
-
The LOL Company had the following items in its complex capital structure on December 31, 2023: Preferred stock, $8 par value, $1 dividend, 10,000 shares issued and outstanding. Common stock, $5...
-
Find RAB in the network in figure. ww- 6 kn 6 kN 2 kn RAB 6 B
-
Problem #3: If, in 12 years, $1000 increased to $2200, what is the effective monthly rate, as a percentage? Percentage, correct to 2 decimals. (Do not include the '%' sign in your answer.) Problem...
-
56. If the maximum concentration of PbCl2 in water is 0.01M at 298 K. Its maximum concentration in 0.1M NaCl will be : (1) 4 103 M x (3) 4 102 M (2) 0.4 10M x (4) 410 M
-
84. Which is incorrect order of -I (1) F>Cl> Br>I (2) NR,>-NH3>-NO (3) OCH3>-OH>NH, > -C = CH>H (4) 85. Which of the following compounds is most basic? (1) CH3NH2 (3) CH,-N-CH3 CH (2) CH3-NH-CH3 (4)...
-
Exercise 1 Motion on a Ramp In this exercise you will roll a marble down a ramp and calculate its linear acceleration and velocity. You will then create graphs to illustrate the motion of the marble.
-
1. Your program asks the user how many bananas they want to buy, and what the price is. This information is then passed to getTotal to calculate the total cost. System.out.println("How many bananas...
-
_____ redirects a user from a legitimate website to a malicious website by changing hosts files on a DNS server. A. Exploitation framework B. ARP poisoning C. DDoS DNS attack D. DNS...
-
36. Trabant Co purchased all of the ordinary share capital of Skoda Co during 20X8. On this date the fair value of the net assets of Skoda Co was $15 million. The terms of the purchase agreement...
-
Perform the operation by first converting the numerator and denominator to scientific notation. Write the answer in scientific notation. 7,200,00/0.000009
-
What are four good beginnings for sales and fund-raising messages?
-
What are some techniques for making meetings effective?
-
How can you adapt good style to organization preferences?
-
What happens if a classification tree is grown to its fullest extent? a. Each leaf node will be 100% pure (all Class 1 observations or all Class 0 observations) b. The best predictive performance on...
-
Which of the following statements about bagging is false? a. Bagging generates a composite prediction by weighting the votes of the individual classifiers by their individual accuracies. b. Bagging...
-
It is known that tree-based learning is unstable. What does this mean? a. Trees are poor predictive models. b. The predictive performance of the tree varies dramatically based on the training data...
Study smarter with the SolutionInn App