The CEO knows that companies who recognize and reward team members have increased employee morale, lower...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The CEO knows that companies who recognize and reward team members have increased employee morale, lower turnover and increased productivity. Rewarding employees can increase business profit as much as 20%. 5.1 Activate the 6. Employee Recognition worksheet. Enter a date function in B1 that will always display the current date. Apply a date format to match column D. (2) In cell G3, use a date function to determine the number of full or partial years each employee has been employed as of today. (2) In H3, apply a nested function based on the following criteria; if salesperson has worked more than 3 years, their Total Sales are over 100,000 and they are responsible for Territory Alberta, they will receive a bonus 4% salary increase, otherwise they will receive a standard 1% salary increase. Wherever possible cell referencing should be used. Results should show the conditional raise amount only. (4) In 13 use the IFS function to determine these bonuses. In the function refer to the Sales Positions listed in A18:A20. Each cell in this range is part of the Logical Test Condition and each cell in B18:B20 will be the individual Value if True in the function. These references must also be absolute. Complete the function and confirm that the correct bonuses are displayed. (3) Edit the function in 13 to add both the Conditional Raise from column H and the Salary located in column E. (1) Apply Accounting format with no decimals where salary, sales and bonuses are shown. The Years should be formatted as a number with 1 decimal. (1) 5.2 5.3 5.4 5.5 5.6 5.7 5.8 Insert two new rows at the top of the worksheet and copy the heading from the 2. Year End Subtotals sheet to cell A1. Change the title to Employee Recognition Report. Set row height to 90. Unmerge and remerge across used columns of the worksheet. (1) Apply appropriate table formats including table layouts to the worksheet, using the range A4:117 as the first table. Apply appropriate table formats to the second table in A19:B24. Convert all tables to a range and apply best fit column widths. Replace any references to Column heading titles inserted when applying the table formats. Apply text wrap to the titles in H4:14, set column width for columns D:1 to 12. (4) The CEO knows that companies who recognize and reward team members have increased employee morale, lower turnover and increased productivity. Rewarding employees can increase business profit as much as 20%. 5.1 Activate the 6. Employee Recognition worksheet. Enter a date function in B1 that will always display the current date. Apply a date format to match column D. (2) In cell G3, use a date function to determine the number of full or partial years each employee has been employed as of today. (2) In H3, apply a nested function based on the following criteria; if salesperson has worked more than 3 years, their Total Sales are over 100,000 and they are responsible for Territory Alberta, they will receive a bonus 4% salary increase, otherwise they will receive a standard 1% salary increase. Wherever possible cell referencing should be used. Results should show the conditional raise amount only. (4) In 13 use the IFS function to determine these bonuses. In the function refer to the Sales Positions listed in A18:A20. Each cell in this range is part of the Logical Test Condition and each cell in B18:B20 will be the individual Value if True in the function. These references must also be absolute. Complete the function and confirm that the correct bonuses are displayed. (3) Edit the function in 13 to add both the Conditional Raise from column H and the Salary located in column E. (1) Apply Accounting format with no decimals where salary, sales and bonuses are shown. The Years should be formatted as a number with 1 decimal. (1) 5.2 5.3 5.4 5.5 5.6 5.7 5.8 Insert two new rows at the top of the worksheet and copy the heading from the 2. Year End Subtotals sheet to cell A1. Change the title to Employee Recognition Report. Set row height to 90. Unmerge and remerge across used columns of the worksheet. (1) Apply appropriate table formats including table layouts to the worksheet, using the range A4:117 as the first table. Apply appropriate table formats to the second table in A19:B24. Convert all tables to a range and apply best fit column widths. Replace any references to Column heading titles inserted when applying the table formats. Apply text wrap to the titles in H4:14, set column width for columns D:1 to 12. (4)
Expert Answer:
Answer rating: 100% (QA)
The detailed answer for the above question is provided below 51 Activate the 6 Employee Recognition worksheet Enter a date function in B1 that will always display the current date Apply a date format ... View the full answer
Related Book For
Strategic Management An Integrated Approach
ISBN: 978-1111825843
10th edition
Authors: Charles W. L. Hill, Gareth R. Jones
Posted Date:
Students also viewed these general management questions
-
Use a tree diagram to determine the number of subsets of {3, 7, 9, 11, 24} with the property that the sum of the elements in the subset is less than 28.
-
Use the multiplicative rule to determine the number of sample points in the sample space corresponding to the experiment of tossing a coin the following number of times: a. 2 times b. 3 times c. 5...
-
Use the counting principle to determine the number of sample points in the sample space. One colored chipred, blue, or greenis selected at random and a fair die is rolled.
-
A quality inspector selects a sample of 12 items at random from a collection of 60 items, of which 18 have excellent quality, 25 have good quality. 12 have poor quality, and 5 are defective. (a) What...
-
Mags Pie Shop is a rapidly growing baker and distributor of specialty pies for festive occasions. Mags CPA adviser keeps recommending that Mag install better internal controls over the business....
-
Figure 4-36 includes an EER diagram describing a car racing league. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such...
-
The depreciation expense on office equipment for the month of March is $100. This is the third month that the office equipment, which cost $1,900, has been owned. Prepare the adjusting entry in...
-
Part 1 Goering, Zarcus, and Schmit are partners and share income and loss in a 3:2:5 ratio. The partnerships capital balances are as follows: Goering, $84,000; Zarcus, $69,000; and Schmit, $147,000....
-
Hi, I take IB math SL AI. For my IB math ia I am modelling the lorenze curve in two different countries. What are the step I would have to do? and how would i calculate the area under the curve?
-
Adelle Watson owns a small manufacturing company, Easy Bake, which makes one product, a ceramic pie plate that features even heating that helps prevent pie shells from getting burnt in patches. It is...
-
The standard deviation of return on investment A is 0.30 while the standard deviation of return on investment B is .04. If the correlation coefficient between the returns on A and B is -0.50, the...
-
1. Suppose you invest $4,600 today in an account that earns a nominal annual rate (i nom) of 12 percent, with interest compounded monthly. How much money will you have after 12 years? 2.You want to...
-
Trust is crucial to leading a group effectively. Discuss a time when a leader did not have the trust of the group you were in and how it affected the groups performance. Charismatic leadership is...
-
Consider a 20-year, $1,000 bond with an 5% per annum coupon rate and annual coupons. The bond currently has 7 years left to maturity, at a current yield to maturity of 3.9%. This bond will be trading...
-
Invoice Date: July 3 0 Invoice Terms: 5 / 1 0 EOM Invoice Total: $ 2 8 , 3 9 9 . 3 1 Freight ( incl . ) : $ 1 , 8 4 3 Goods received: November 1 4 Paid: September 0 2 What is the invoice total?
-
(1) Discuss the importance of policy in both daily life and information security. (2) Discuss the concept of GRC (Governance, Risk, and Compliance) in terms of information security. (3) Give an...
-
olve the equation For an equation with real solutions support the answer graphically x 8x 9 ewrite the equation in factored form E x 9 x 1 0 Factor completely he solution set is Type an integer or a...
-
The baseball player A hits the ball from a height of 3.36 ft with an initial velocity of 34.8 ft/s. 0.14 seconds after the ball is hit, player B who is standing 15 ft away from home plate begins to...
-
1. Using the information contained in the case, conduct a five-forces analysis of the U.S. Steel industry. What conclusion can you draw from this? 2. Do you think there are any strategic groups in...
-
1. What macroenvironmental, competitive, and industry forces made Kodak initially successful? Are these the same in their demise? 2. How did Kodak achieve related diversification and vertical...
-
What steps would you recommend that a company take to build mutually beneficial long-term cooperative relationships with its suppliers?
-
Audit Risk Model. Sonya Bagri, Chartered Accountant (CA), is auditing the sales of Barlaam Books, which owns two retail book stores in New Delhi. She has decided to allow only 25 incomplete sales...
-
What two types of internal control are there? What type of audit is performed in each area of internal control?
-
Do corporations believe fraud to be a problem according to KPMG reports? Explain.
Study smarter with the SolutionInn App