Average formula = n1+n2...nn divided by n
Part 1: Performance growth rate 2017-18
Employee 1 = (85-80)/80 = 6.25%
Employee 2 = (80-75)/75 = 6.67%
Average = 6.25% + 6.667% / 2 = 6.46% = answer
Part 2: Average increase in potential
Employee 1 | Employee 2 | |||
Potential % | Diff (85-potential%) | Potential % | Diff (85-potential%) | |
2015 | 65 | 20 | 70 | 15 |
2016 | 65 | 20 | 90 | 0 |
2017 | 70 | 15 | 85 | 0 |
2018 | 75 | 10 | 90 | 0 |
AVERAGE | 16.25 | 3.75 | ||
Average of 16.25 & 3.75 | answer | 10 | ||
For employee 2, In year 2016-2018, the potential is already 85% or more, hence we have taken the target increase to be zero.
Part (c)
Employee 1 | Employee 2 | |||||
Performance % | Potential % | Performance % | Potential % | Diff in
performance % (eg. 2015: 70-75) |
Diff in
potential % (eg. 2015: 65-70) |
|
2015 | 70 | 65 | 75 | 70 | -5 | -5 |
2016 | 85 | 65 | 75 | 90 | 10 | -25 |
2017 | 80 | 70 | 75 | 85 | 5 | -15 |
2018 | 85 | 75 | 80 | 90 | 5 | -15 |
Average | 3.75 | -15 |
part (d)
Employee 1 | Employee 2 | |
Absenteeism % | Absenteeism % | |
2015 | 10 | 5 |
2016 | 7 | 18 |
2017 | 6 | 4 |
2018 | 2 | 23 |
Average absenteeism | 6.25 | 12.5 |
Average attendance (100-average absenteeism) | 93.75 | 87.5 |
Average
salary in 2019 as per average attendance (44714.29*93.75%) |
41,919.64 | 39,125 |
Salary for 100% attendance (39125/87.5%) | 44,714.29 |
The average attendance of employee 2 is 87.5%
He gets an expected salary of 39,125 for 87.5%
If he had 100% attendance, he would get = 39,125/87.5% = 44,714.29
Now, employee 1 has 93.75% expected attendance.
In the Question it is clear that the salary structure for both employees is same over the years.
Hence, employee 1 will get a salary of 44,714.29*93.75% = 41919.64
QUESTION 3 Marketing Executives 1 and 2 Progress Check 2015 2018 Employee 1 Employee 2 2015 2016 2017 2018 2015 2016 2017 2018 | Performance (%) 70 85 80 85 75 75 75 Potential 70 75 70 90 90 65 65 85...
1. Straight-Line Depreciation Year Expense 2015 $ 2016 2017 2018 2019 2. Double-declining balance (Round answers to the nearest whole number, when appropriate.) Depreciation Year Expense 2015 $ 2016 2017 2018 2019 Depreciation Methods On January 2, 2015, Roth, Inc. purchased a laser cutting machine to be used in the fabrication of a part for one of its key products. The machine cost $125,000, and its estimated useful life was four years or 1,200,000 cuttings, after which it could be...
Question 2 of 75 Fred turned 70% on October 1, 2016, He took the first required minimum distribution from his t O December 31, 2017. O March 1, 2018 O April 1, 2018. O April 18, 2018. Mark for folow up Question 3 of 75 Form 8606 is used for all of the following purposes EXCEPT: O To claim an exception to the penalty on an early distribution from a retirement plan. To calculate the taxable portion of a traditional...
Consider the following set of data on the performance rating of an employee in an organization. The rating is ranging from 0 to 4. 0 - very poor 1 - poor 2 - average 3 - Excellent 4 - Outstanding . 1. Analyze the given data and rank them based on their performance. And give reasons. 2. Analyzing their performance between 2011 and 2017, what can you decide about their performance? 3. If the results of 1 and 2 are...
this is the entire thing together C $ 200 2015 170 $ 75% 128 $ 2016 175 $ 77% 135 $ 2017 177 $ 78% 138 S 2018 179 $ 78% 140 $ 2019 183 78% 143 $ $ 9,307,500 $ 9,836,750 $ 10,078,380 $ 10,192,260 $ 10,420,020 $ 2,030,528 $ 2,030,528 $ 2,030,528 $ 2,030,528 $ 2,030,528 $ 207,043 S 207,043 $ 207,043 $ 207,043 $ 207,043 $ 90,300 $ 90,300 $ 90,300 $ 90,300 $ 90,300 $ 11,635,371...
89 2 3 5 6 5 6 2 70 4 4 4 2 2 2 9 4 6 4 3 3 6 9 2 9 7 4 9 5 9 5 60 60 98 LA 534 80 50 00 20 00 20 00 60 40 50 90 50 90 80 20 60 40 30 00 90 70 50 80 90 20 90 10 60 50 60 50 60 00 90 10 70 0 1 0 7 9 9 7 .-9....
free cash flow 1-3. Free Cash Flow; WACC; NPV (3 questions) 2016 2015 2017 2018 2019 2020 2021 M&A 1 2 Revenue 142343 152235 106364 144978 186152 205309 213635 EBIT+After Tax 4225 4522 2214 3214 3621 4314 5835 Capital Expenditure Dep. & Amortization Net Working Capital Change 1823 1088 1657 1577 2606 2395 3123 575 437 622 1026 1066 1045 1087 -4808 6090 1539 903 1689 1758 Free Cash Flow -4342 3382 7785 1044 1178 Other information Your Investment in...
QUESTION: This list of 75 KPIs every manager needs to know is also listed in your text on pages 264-265. After reviewing this list and the required resources for this module, consider which indicators would be most important for an industry of your choosing. Provide background information on the industry you chose, and why you think the KPIs you chose are important. Support your list with resources. Read Below!!!! Reference: Key Performance Indicators (KPIs) should be the vital navigation instruments...
1. Based on the data in case Exhibits 1 and 4, is Costco’s financial performance superior to that at Sam’s Club and BJ’s Wholesale? 2. Does the data in case Exhibit 2 indicate that Costco’s expansion outside the U.S. is financially successful? Why or why not? 3. How well is Costco performing from a strategic perspective? Does Costco enjoy a competitive advantage over Sam’s Club? Over BJ’s Wholesale? If so, what is the nature of its competitive advantage? Does Costco...
Oracle Corporation (ORCL) Income Statement All numbers in thousands Revenue 5/31/2018 5/31/2017 5/31/2016 5/31/2015 Total Revenue 39,831,000 37,728,000 37,047,000 38,226,000 Cost of Revenue 8,081,000 7,469,000 7,479,000 7,532,000 Gross Profit 31,750,000 30,259,000 29,568,000 30,694,000 Operating Expenses Research Development 6,091,000 6,159,000 5,787,000 5,524,000 Selling General and Administrative 9,720,000 9,373,000 9,039,000 8,732,000 Non Recurring - - - - Others - - - - Total Operating Expenses 25,512,000 24,452,000 23,943,000 23,937,000 Operating Income or Loss 14,319,000 13,276,000 13,104,000 14,289,000 Income from Continuing Operations Total...
Based on, “75 Must Know Statistics about Long-Term Care,” Please discuss four conclusions you can come to for the problems that the long term care industry will face in the coming decade. You must include statistics from the article. 75 Must-Know Statistics About Long-Term Care Christine Benz 31 Aug 2017 In my years of speaking to groups of retirees and pre-retirees, I've learned that there are a handful of topics that will send an event completely out of my control....