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...
-
It seems logical that restaurant chains with more units (restaurants) would have greater sales. This assumption is mitigated, however, by several possibilities: some units may be more profitable than...
-
You have just purchased a new warehouse. To finance the purchase, youve arranged for a 30-year mortgage for 80 percent of the $4,500,000 purchase price. The monthly payment on this loan will be...
-
Vector Manufacturing (VM) makes replacement parts for the automotive industry. One particular part can be manufactured at a unit cost of \($0.75\) for material and \($0.25\) for direct labor....
-
Five Satins Company purchased a piece of equipment at the beginning of 2011. The equipment cost $430,000. It has an estimated service life of 8 years and an expected salvage value of $70,000. The...
-
In 2022, Sheridan Company has net credit sales of $1,798,000 for the year. It had a beginning accounts receivable (net) balance of $108,000 and an ending accounts receivable (net) balance of...
-
The following selected accounts appear on the Balance Sheet of Examination Corporation as of December 31, 2021. Stockholders' Equity Preferred 5% Stock, $100 par (100,000 shares authorized, 25,000...
-
Mr. Ma operated a dry-cleaning plant. Even if there was no intention of harming anyone, he could still be sued by someone harmed by dry cleaning chemicals that escaped from his property. This is an...
-
17) (12 points) Eisenhower Enterprises has two mutually exclusive projects under consideration. Their cash flows are expected to be as follows: Year Project A -23,600 10,000 10,000 0 1 2 3 10,000...
-
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 71.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from...
-
Firms often evaluate a vendor based on its reputation or financial strength. How can a firm obtain this information?
-
A local community bank has requested foreign exchange quotes for the Swiss Franc from Citibank. Citibank quotes a bid rate of $1.0650/SF and an ask rate of $1.0713/SF. What is the bid-ask spread?...
-
Bulldog Acquirers has offered to buy the Gatorade Company for $20.80 per share, and will pay cash. Bulldog's stock traded for $32 per share before the announcement of the merger agreement was made...
-
What is the present value of $150000 to be received 8 years from today if the discount rate is 11 percent?
-
Convert the numeral to a HinduArabic numeral. A94 12
-
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?
-
Give a general description of PERT/CPM techniques.
-
Refer to Problem 2. Determine profit when volume equals 22,000 units.
-
Processing times for new accounts at a bank are shown in the following table. Five samples of four observations each have been taken. Use the sample data in conjunction with Table 10.3 to construct...
Study smarter with the SolutionInn App