User Account

All Pages

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

  Global viewthe marketing scene is a publication that

global viewthe marketing scene is a publication that provides a platform for professionals and consumers to discuss new

  Explain against the law regardless of it being a normal

Explain against the law regardless of it being a normal practice and okay because their duties are primarily clerical in nature

  Part of the planning process

How is budgeting utilized as a part of the planning process?

  Planning oral briefings

Assume the governor has asked you to present an oral briefing on a controversial environmental program to a board of commissioners of a major county in the state. Three of the nine commissioners oppose the program and have experts on their staff who ..

  Describe the global car industry characteristics

1. Describe the global car industry's characteristics. 2. Describe and analyze NASCAR's domestic and global corporate strategies.

  Advantages and disadvantages of apprenticeships

Can a party participating in integrative bargaining be wolf in sheep's clothing? By this I mean could a person pretend to be interested in pursuing an integrated solution but be playing a zero sum game?.

  Ethnocentric model, polycentric model

Which model will be most appropriate for staffing each group: ethnocentric model, polycentric model, or global model? Explain your reasoning for each case.

  Difference between negligence and intentional tort

1. Discuss the difference between negligence and intentional tort. Is it possible for an action to move from a negligent action to an intentional tort? Include examples of intentional torts in real world.

  Automobile than a steering post interlock device

what difference does it make to the tying arrangement issues if internet explorer is a functionally integrated component of windows? what is it is more like a radio in an automobile than a steering post interlock device?

  Market segmentation approaches

1- Define a target market segment and describe how the two market segmentation approaches are used to develop customer relationship marketing. Provide an example of each approach.

  Microeconomics questionsq1 jonathans preferences are

microeconomics questions.q1. jonathans preferences are characterized by diminishing marginal rate of substitution. at

  Messages and product placement

Advertising messages and product placement are increasingly featured in video games. In your view, is this unethical? Explain.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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