Encerrado

Dashboard to display monthly sales data

ONLY BIDS BELOW $100 WILL BE LOOKED AT. I HAVE A VERY SMALL BUDGET. PROGRAM TO VIEW DASHBOARD MUST BE FREE (IE. CRYSTAL REPORTS VIEWER, XCCELIOS VIEWER ETC.)

We need a Dashboard Report to show the following information - it is for a auto dealer:

Types of Warranty Sold 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 – Line Graph)

Average Load per Deal (Info area)

Average Gross after Commission (Info area)

Average Total Gross per Deal (Info area)

Salesman of the Month - Deals (Info Area - Most Deals)

Salesman of the Month - Gross (Info Area - 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 (Info area)

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 an Excel is preferred – and maybe the dashboard would be able to read the data file.

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 a “Salesman Dashboard” which would allow us to select a salesman from a dropdown - 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.

NOTE: This was posted as an Excel request, however I have decided that Excel probably wont be able to offer the interactivity I am looking for and therefore I am looking to other products – maybe Xcelious.

PLEASE PROVIDE SAMPLES OF YOUR WORK OR SCREENSHOT OF MY DATA IN ACTION SO I KNOW WE ARE ON THE RIGHT PATHS.

Habilidades: Anúncios, Excel, Vendas

Ver mais: dealer sales dashboard, display advertising monthly totals, chart sales month year excel, sales salesman data, free monthly sales dashboard, dashboard averages excel, yearly sales dashboard, display averages dashboard, monthly total sales dashboard, display sales data, advertising monthly gross excel, who made freelancer, we want a salesman, we are looking for a dealer, stock take freelancer, salesman of the month, reports freelancer, program monthly budget freelancer, preferred freelancer how, pick freelancer, out source vs freelancer, out of bids freelancer, other sales, number one freelancer, my work freelancer wont

Acerca do Empregador:
( 0 comentários ) CAIRNS, Australia

ID do Projeto: #547402

12 freelancers estão ofertando em média $92 para este trabalho

nagybatonyi

I can offer a solution to your preferred entry method, please, see PMB! Regards!

$90 USD in 3 dias
(38 Comentários)
5.3
telemarketing555

Hello. Please check your PM for my proposal and sample of your dashboard. Thank you.

$100 USD in 5 dias
(21 Comentários)
4.3
rohitkhn

I can start working immediately. Please check PMB.

$100 USD in 5 dias
(0 Comentários)
0.0
kumar910

Hi, I can do the same. Please see PM Rgds, Sunil

$150 USD in 3 dias
(0 Comentários)
0.0
prashant211181

hi, yes i can do same With 100% accuracy And can start now

$99 USD in 4 dias
(0 Comentários)
0.0
beepig

Hi friend, I can do it right now. Please check PM for my demo (I will update it later). Many thanks.

$90 USD in 2 dias
(0 Comentários)
0.0
Treeratna

I am ready

$30 USD em 1 dia
(0 Comentários)
0.0
Orion2525

I have 5 years of professional IT development experience, including crystal reports. I will get the job done.

$99 USD in 3 dias
(0 Comentários)
0.0
Jayseep

Hi I do this most of the time. Attached to my PM is a sample file with a dashboard I've just completed. Hope it suits your requirements Jayseep

$100 USD em 1 dia
(0 Comentários)
0.0
karthidkt

Please find details in PM.

$114 USD in 5 dias
(0 Comentários)
0.0
ExcelUS

Hi, I've pretty much almost completed this project(I was very bored this afternoon!) I just wanted to confirm that you're still accepting bids before I finish it. I've bid just $50 as I'm looking for the feedb Mais

$50 USD in 2 dias
(1 Comentário)
0.0
supotth

pls find screenshot and more detail in PM

$80 USD in 4 dias
(0 Comentários)
0.0