Computation percent of the quota of sales

Reference no: EM1313462

Computation percent of the quota of sales and raking on profitability

1. Import the Sale Rep List.csv into a worksheet.

2. Create a List of the data

3. Add three more fields

a.Percent of Quota - calculate what percent of the quota has been met with current sales

b. Rank - Use a function to look up in a rank table for the percent of Quota and return the correct rank. create a Rank Table in the worksheet

Percent Rank
90% 1
80% 2
60% 3
0% 4

c. Bonus - Use a function that will give the sales rep $5000 if their Rank is 1 and their District is either 1 or 2.

Reference no: EM1313462

Questions Cloud

Actual rate of unemployment relative to the natural rate : Contraction GAP, Illustrate what does a Contraction Gap imply about the actual rate of unemployment relative to the natural rate.

Hypothesis testing for single mean and confidence interval : Construct a 99% confident interval for the standard deviation of the amount of vitamin B6 per pill.

What is the magnitude of the force on the wheaties box : A 5.20 g pop up toy is compressed 1.50 cm and pops up to the height of 50 cm the spring constant is 270 Nm. What is the loss of energy.

Finding evidence using six-step critical value approach : Using six-step critical value approach, at the 0.05 level of significance, is there evidence that population mean delivery time has been increased below previous population mean value of 25 minutes?

Computation percent of the quota of sales : Computation percent of the quota of sales and raking on profitability and Import the Sale Rep List.csv into a worksheet

Initial allocation of cheese also bread is pareto efficient : Draw the Edge worth Box diagram for this economy also Explicate whether the initial allocation of cheese also bread is Pareto efficient.

What is the rms speed of the molecules : A space vehicle is travelling at 5800 km/h relative to the Earth when the exhausted rocket motor is disengaged and sent backward with a speed of 74km/h relative to the command module. The mass of the motor is four times the mass of the module. What i..

Etiology and genetics of the disease phenylketonuria : Explain the etiology and genetics of disease phenylketonuria (PKU) Phenylketonuria (PKU) refers to a disease found within humans in which the affected individual does not have enzyme phenylalanine hydroxylase.

Question related to basic accounting principle : Multiple choice questions on basic accounting principle and Which of the following account groups are all considered nominal accounts, What type of account is Prepaid Rent

User Account

All Pages