Closed

Excel Dashboard Report / PivotTable for Monthly Sales Data

PLEASE NO BIDS ABOVE $100 - WE HAVE A SUPER SMALL BUDGET TO MAKE THIS HAPPEN

We need a Excel Dashboard Report or a specially made Pivot Table and Report to show the following:

Warranties Upsold (type) to No Warranty Sold (Pie Graph)

Year of Vehicle (Line Chart or Bar Chart)

Average Days in Stock (Gauge)

Customer Deals vs. Wholesale Deals (Deals that don't have a Deal Number and Salesman is House) (Pie Chart)

Salesman Deals for Month - Total Number (Bar Chart with Salesman on 1 Axis and Total Deals on the Other)

Salesman Commission for Month - Total Commission Earned and Average per Deal (2 Charts - 1 shows total salesman commission for each salesman against the others, the other table shows the average)

Running Total for the Month (Ie. Show running total over 31 days and watch it climb)

Average Load per Deal

Average Gross after Commission

Average Total Gross per Deal

Salesman of the Month - Deals (Most Deals)

Salesman of the Month - Gross (Most Gross)

Advertising Source Breakdown (Pie Chart that shows breakdown of Source - Can be drilled down to pick between 2 dates and it will show source breakdown for between those dates)

Total Value of Sales for the Month

Ideally, all of this information would be presented nicely on a A4 piece of paper that could be printed at the end of the month, or during the month, to see how the dealership is performing.

In a month, we would have no more then 150 deals, so entering data directly into Excel is preferred - we do not need an Access database or application to do this.

It would be great if we can record other months in the same spreadsheet and then query data for other months, plus show yearly totals, year to date figures, averages for months of year etc. A Freelancer who can offer this sort of solution will be viewed upon favourably.

Finally, we want to Pick a Salesman - This would then Display their Deals for the Month (List them out with figures), plus show their average load, average gross, Warranties Sold/Missed and Commission made.

In the attached Example Data file for October, I have Data in one sheet and all the specs and how I would like the data presented in the second. If you can take all of this on and help me produce something to help us get a snapshot of sales for the month.

Skills: Excel, Sales, Statistics

See more: excel dashboard pick list, excel dashboard monthly sales report, excel dashboard monthly sales, monthly sales report excel, excel sales monthly report, dashboard averages excel, load average excel dashboard, pivot table sales dashboard, excel table sales salesman, monthly sales report dashboard, dashboard sales pivot table, excel dashboard gross sales, sales dashboard pivot month customer, who made freelancer, we want a salesman, we excel, total for freelancer, the super source, super source, super freelancer, stock take freelancer, salesman of the month, report in freelancer, preferred freelancer how, pivot table freelancer

About the Employer:
( 0 reviews ) CAIRNS, Australia

Project ID: #534462

44 freelancers are bidding on average $72 for this job

vserv

Pls see your PMB. Thanks

$75 USD in 3 days
(52 Reviews)
5.6
nagybatonyi

I can offer a solution for your favourable data entry method, please, see PMB for details! Regards!

$90 USD in 3 days
(40 Reviews)
5.4
sureshdevi

I can do this work. Thanks, Suresh

$100 USD in 3 days
(13 Reviews)
4.3
nmppatel

I am an IT professional with 10 yrs experience. I have very good experience with Excel. I have completed many projects on GAF in Excel skill. I will provide quick & professional service.

$90 USD in 2 days
(9 Reviews)
3.7
FlashBack

Hello Sir I am ready to start & hope to receive your considerations. Thanks & Regards Abir

$100 USD in 3 days
(6 Reviews)
3.4
mantripti

Hi I am Mechanical Engineer + MBA (Marketting) + Cost Management Accountant I have worked on high post of Management as well I am working as free Lancer to take market challanges on Excel Your requirements are very More

$90 USD in 3 days
(9 Reviews)
3.3
KellogITSolution

Hello Please see your PMB for details. Thanks

$75 USD in 3 days
(3 Reviews)
2.6
refractocd

Please refer to PM

$100 USD in 3 days
(3 Reviews)
2.5
dearpravin

Greeting! Please check PM for more details and sample screenshots.

$100 USD in 7 days
(2 Reviews)
2.4
zszabo

Hi, Please see pm. B.R. Zoltan

$100 USD in 5 days
(3 Reviews)
2.2
loki1

Hey mate, pls chk PM for details cheers! Loki 1

$100 USD in 3 days
(1 Review)
1.0
Jayseep

Hi there Just did four of these quite recently Have a look at sample of one in PM sent to you. Let me know when you want me to start Jaysee

$50 USD in 2 days
(0 Reviews)
0.0
pabna

Hi I am highly experienced statistican. I can do the job with entire satisfaction. Please see me at PM. Thanks

$100 USD in 5 days
(0 Reviews)
0.0
rksvba

Hi Please provide me the chance to work with you. I am totally a new user with lots of experience. Let me know if you want me to provide you the example for that..

$100 USD in 2 days
(0 Reviews)
0.0
rezaurc

Dear Sir, It's a nice project to work on. I will will able to satisfy you if the project is awarded. Rezaur

$49.75 USD in 1 day
(0 Reviews)
0.0
gracebd

Hi I am a statistician and data analyst. I can do this work nicely.

$33 USD in 3 days
(0 Reviews)
0.0
ashishporwal

Hi, I hold an MBA and an Engineering Degree from two of India's premier institutes. I have performed lots of similar analysis. You may want to look at my profile for further information.

$100 USD in 5 days
(0 Reviews)
0.0
Phulwale

I will finish up the said task in 2days time once we finalize. If any improvements or modifications neede, i will do accordingly once i deliver.

$65 USD in 2 days
(0 Reviews)
0.0
avnishraghava123

Hi, Icleary understand your requirment and can perform this job ecectly as you want.

$80 USD in 2 days
(0 Reviews)
0.0
DEFerrier

I would love to do this work for you.

$32 USD in 3 days
(0 Reviews)
0.0