Levels Bonus

Create a Levels Bonus spreadsheet (using the one attached).

Add all salespersons sales (deal credits) for each store to a combined total monthly sales tab. This should be a formula to automatically find the salesperson at each store's tab for that particular month. For example, Rosario has sales of 7.5+.5+2.5 at the GM, Imports and Toyota stores for a total January sales of 10.5.

Then set up a formula to calculate the 90 day average. In this spreadsheet the Nov-Dec-Jan would be totalled and divided by 3 to get the average.

Then RANK the salespeople based on most to least sales on the 90 day average ending January 2013.

Utlimately we'll add more months to the spreadsheet and allow it to automatically calculate all 3 stores total sales and the 90 day average of each.

Thank you.

Taidot: tiedonsyöttö, Excel

Näytä lisää: the levels, levels 2, excel spreadsheet formula, find a salesperson, GM, find salesperson, bonus, excel formula spreadsheet spreadsheet, data set formula, excel 2013 formula, salespeople, dec 2013, nov 2013, create tab excel, month month excel sales spreadsheet, levels, excel formula spreadsheet, calculate store data, data entry toyota, sales data entry example excel, data entry formula, spreadsheet store data entry, sales bonus spreadsheet, data ending, sales rank data

Tietoa työnantajasta:
( 1 arvostelu ) Clarksville, United States

Projektin tunnus: #4256595

Myönnetty käyttäjälle:


Hi. Looks like simple task. Regards, Eugene

$40 USD 1 päivässä
(8 Arvostelua)

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


##### Excel expert here! Please check PM. #####

$50 USD 1 päivässä
(43 arvostelua)

Hi I would like to apply for the posted by you. Rgds Rohit

$80 USD 7 päivässä
(6 arvostelua)

Hi sir i am ready for work kindly i provide u 100% good work kindly i request u sir kindly check my private massages and let me know sir i am waiting for u great response thanks.

$1000 USD 30 päivässä
(3 arvostelua)

Airborne Developers is interested in completing this project for you. Our staff are hired professionals that will help you complete your project with the best quality. Our support system is fast and efficient, you will Lisää

$200 USD 5 päivässä
(0 arvostelua)

I have 10+ years advanced user experience on Excel; I can finish the task within 24 hours; I am familiar with macro level and have been building various financial spreadsheet models in my previous works and also as par Lisää

$150 USD 1 päivässä
(0 arvostelua)