Employees of the Pro Shop earn commission on total daily sales. The rate they earn depends...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Employees of the Pro Shop earn commission on total daily sales. The rate they earn depends on the amount of revenue they generate. However, Assistant Managers get a flat commission rate regardless of the amount of revenue. On the EmployeeAnalysis worksheet, in cell D23, enter a formula that will return values based on the following: Return 0.05 for employees who have a job title of Asst Manager. For all other employees, use a XLOOKUP function to retrieve the appropriate rate from the CommmisionRates table based on the Total Revenue value for the employees who are not Asst Managers. Multiply the rate by the Total Revenue to calculate the commission amount earned for each employee. Use the fill handle to copy the formula down through D27. Employees of the Pro Shop earn commission on total daily sales. The rate they earn depends on the amount of revenue they generate. However, Assistant Managers get a flat commission rate regardless of the amount of revenue. On the EmployeeAnalysis worksheet, in cell D23, enter a formula that will return values based on the following: Return 0.05 for employees who have a job title of Asst Manager. For all other employees, use a XLOOKUP function to retrieve the appropriate rate from the CommmisionRates table based on the Total Revenue value for the employees who are not Asst Managers. Multiply the rate by the Total Revenue to calculate the commission amount earned for each employee. Use the fill handle to copy the formula down through D27.
Expert Answer:
Related Book For
Understanding Business Ethics
ISBN: 9781506303239
3rd Edition
Authors: Peter A. Stanwick, Sarah D. Stanwick
Posted Date:
Students also viewed these accounting questions
-
Within the context of the Project Evaluation and Review Technique, please comment on how the Beta Distribution helps in providing better estimates for project control.
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
In December 2022, more than a year after Ontarios vaccine management system was breached, the Ontario government is notifying around 360,000 people that their data was stolen and potentially given to...
-
For a safe re-entry into the Earth's atmosphere, the pilots of a space capsule must reduce their speed from 2.6 104 m/s to 1.1 104 m/s. The rocket engine produces a backward force on the capsule of...
-
Bradburn Corporation was formed 5 years ago through a public subscription of ordinary shares. Daniel Brown, who owns 15% of the ordinary shares, was one of the organizers of Bradburn and is its...
-
J Fisher, White House, Bolton, is selling the following items, the retail prices as shown: plastic tubing at 1 per metre, polythene sheeting at 2 per length, vinyl padding at 5 per box, foam rubber...
-
According to a payroll register summary of Frederickson Company, the amount of employees gross pay in December was $850,000, of which $80,000 was not subject to FICA tax and $750,000 was not subject...
-
The price of a stock is currently $20. A three-month at-the-money call option on the stock is trading at $1.25. The risk-free rate is 4.0%. Calculate the maximum profit and loss for an investor who...
-
FA#6 PROBLEM TREE ANALYSIS TO DO: Make a problem tree analysis about Science, technology & society affecting industry make your own problem about Science, technology and society affecting industry...
-
Organizational Culture and International Expansion Instructions Your initial post should answer the following questions: How does the national culture of an organization affect the way the...
-
Robin's automobile, which she uses exclusively in her trade or business, was damaged in an accident. The adjusted basis of the automobile prior to the accident was $8,000. The fair market value of...
-
In Zierdt, G. L. (2009). Responsibility-centered budgeting: an emerging trend in higher education budget reform, What are two common budget tools and what are the advantages and disadvantages of both?
-
Hydroxylation of A9-THC (a highly lipophilic component of cannabis) generates 11- hydroxy A-Tetra hydrocannabinol (11-OH-THC), a psychoactive compound. Given the REVISED drug decay model...
-
In the Eagan Family Practice Cost Allocation Methods exercise, how should I identify and explain the main cost management problems using the studied cost management theory and what should be Eagan...
-
es Weller Company's budgeted unit sales for next year are provided below: Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 17,000 20,000 16,000 15,000 The company's variable...
-
Which of the following streaming TV devices does not involve use of a remote controller? A) Google Chromecast B) Apple TV C) Amazon Fire TV D) Roku
-
Do you believe we live in a cheating culture? Explain your answer.
-
McWane Corporation has been a fixture in the Birmingham, Alabama, business community since 1921. Started by J. R. McWane and still controlled by the McWane family, McWane Corporation has become an...
-
Swiss banks have had a long tradition of keeping information about their clients confidential. Is this still the correct strategic focus to take in the 21st century? Should the United States...
-
B Arkwright started in business on 1 January 19X5 with 10,000 in a bank account. Unfortunately he did not keep proper books of account. He is forced to submit a calculation of profit for the year...
-
A J Kirkwood is a dealer who has not kept proper books of account. At 31 August 19X6 his state of affairs was as follows: During the year to 31 August 19X7 his drawings amounted to 7,560. Winnings...
-
25.4 P Balance Sheet as at 31 December 19X5 Investment in S: 30,000 shares bought 31.12.19X4 53,400 Fixed assets 60,000 Less Depreciation for year 6,000 54,000 Current assets 10,600 118,000 Share...
Study smarter with the SolutionInn App