Calculating bonuses for auto dealerships

Assignment Help Business Management
Reference no: EM131311710

You will create an Excel worksheet for calculating bonuses for auto dealerships based on the quantity of vehicles sold. If a dealer sells above the expected volume, they receive a bonus for each vehicle sold.

  • Open Boston Dealerships and save it as Boston Dealerships (with your name on the end).
  • Review and understand the data before you begin.
  • Each quarter the dealer will receive a bonus for each vehicle sold if sales are greater than the expected volume in row 4.  The bonus is per vehicle. For example, since Dealer #1 sold more than 400 vehicles in the first quarter Dealer #1 will receive a bonus of $32,475. In cell F8, use a function to calculate the amount of the bonus for Dealer #1.  Use all cell addresses in the formula. Use absolute references as needed so that you can autofill this formula down and across.
  • Autofill the formula in F8 down to F17 and across to I17. Check your results.  Make sure there are bonuses for all dealers that have exceeded the expected volume in each quarter.
  • In cell J8, use a function to count the number of bonuses for all four quarters for dealer#1.  Autofill down.
  • In cell K8, use a function to enter the bonus amount in H2 if the dealer has received the number of bonuses in G2. Use absolute references as needed so that you can autofill this formula down.  Autofill down.
  • In cell L8, enter a formula to total the bonuses for each dealer.
  • Dealers that received 4 bonuses already will not get a year-end bonus. Change the entry in G2 to 3.
  • Change the entry in H2 to 250.
  • Apply comma format with no decimal places to F8:L21
  • Add data bars to column L.

Reference no: EM131311710

Questions Cloud

Speculate which areas you believe your company will do well : Based on information provided to you, speculate which areas you believe your company will do well and areas where you think they will be lacking.
What else does a psychologist need to know : Simply reporting measures of central tendency or measures of variability will not tell the whole story. Using the following information, what else does a psychologist need to know or think about when interpreting this information?
Write a set of instructions : First write a set of instructions (algorithm) that can be used to determine whether a year is a leap year. The instruction must be very clear and simple. To check that the algorithm works correctly, you will code it INDIVIDUALLY as an assembly pro..
What is another industry that also uses loyalty programs : What is another industry that also uses loyalty programs to reduce buyer power? How does that industry use loyalty programs to do so?
Calculating bonuses for auto dealerships : You will create an Excel worksheet for calculating bonuses for auto dealerships based on the quantity of vehicles sold. If a dealer sells above the expected volume, they receive a bonus for each vehicle sold.
Define the various methodologies for sociological research : dentify the most important step in the student's guide to research that you would need in order to analyze bullying.Define the identified critical step of research in your words.Explain how bullying relates to one (1) of the following topics:the age..
Distinguish between hardware and software : Do you see technology progressing to the point that we may no longer distinguish between hardware and software and thus no longer perceive differing physical and intellectual interfaces?
Explain what is meant by double-blind : Explain what is meant by ‘double-blind, randomised, placebo controlled trial' in the context of the study - Explain what is meant by ‘Randomisation was stratified by gender'. Why might the researchers in this study decide to ‘stratify by gender'?
How is the usa able to sustain this position : The USA has persistently reported large current account deficits on its balance of payments.

Reviews

Write a Review

 

Business Management Questions & Answers

  What are likely to be the long term critical success factors

What are likely to be the long-term critical success factors for the following types of firms?- A high technology company, such as Microsoft.

  Advocated for congressional control of the fed

Ron Paul (and his son, for that matter) has advocated for congressional control of the Fed and monetary policy for years. One of the pillars of his argument holds that elected officials should be in charge of monetary policy, not appointed individ..

  Delegation of tasks

What should a manager do to overcome this lack of trust or confidence in subordinates so he or she will feel comfortable delegating tasks to them?

  Current examples of workplace safety issues

This assignment asks you to locate and share current examples of workplace safety issues. Go to a recognized business or government periodical or website and provide a summary of a current (no more than 1 year old) issue dealing with workplace saf..

  Using the time value of money for retirement planning

Using the Time Value of Money for Retirement Planning. Carla Lopez deposits $3200 a year into her retirement account. If these funds had an average earning of 9 percent over the 40 years until her retirement, what will be the value of her retirement ..

  Main activities of management accountants

What are the main activities of management accountants with the discrete style?

  Show employee development activities

Could you assist me with analyzing Employee Development Activities and explain why it would enhance the Human Resource Management? I need assistance with about 300 words.

  Identify the return on investment

Identify the Return on Investment (ROI) as well as the Total Cost of Ownership, (TCO) of the wireless order-taking system. Deliberate some of the intangibles Lisa desires to consider and make a recommendation as to whether Lisa must order such a s..

  Discuss whether james must be able to recover from adam

Discuss whether James must be able to recover from Adam based on a contract for the sale of the car.

  Expected growth rate of house prices

A change in government policy changes what people expect to happen in the future. Specifically, suppose that a policy reduces the expected growth rate of house prices by 5 percentage points.

  Assignment-marketing strategy implementation

Determine any strategic partnerships the department store chain could develop that would help promote the higher-ranged-priced products and support the expansion in the west coast.

  Questionrecognizing employee contributionssuppose that you

questionrecognizing employee contributionssuppose that you are the hr manager at a university. you want to create a

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd