Project Detail

Excel Dashboard Report / PivotTable for Monthly Sales Data  

Excel Dashboard Report / PivotTable for Monthly Sales Data is project number 534462
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status: Cancelled

Selected Providers: -

Budget: $30-250

Created: 10/22/2009 at 23:19 EDT

Bid Count: 44

Average Bid:
$ 72

10/28/2009 at 23:19 EDT

Project Creator: trippo
Employer Rating: (No Feedback Yet)

Bid On This Project
 

Description

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.


Additional files submitted:
October Deals.xls

Messages Posted:4 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

100

3 days

10-22-2009 23:34 EDT

I can do this work. Thanks, Suresh

help

 

90

2 days

10-23-2009 20:34 EDT

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.

help

 

100

3 days

10-22-2009 23:46 EDT

Please refer to PM

help

 

75

3 days

10-23-2009 01:01 EDT

Hello Please see your PMB for details. Thanks

help

 

100

7 days

10-26-2009 04:29 EDT

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

help

 

75

3 days

10-23-2009 01:37 EDT

Pls see your PMB. Thanks

help

 

100

3 days

10-23-2009 00:35 EDT

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

help

 

100

3 days

10-23-2009 03:51 EDT

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

help

 

90

3 days

10-23-2009 23:29 EDT

Hi, Please see PM for details. Regards,

help

 

100

5 days

10-23-2009 03:07 EDT

Hi, Please see pm. B.R. Zoltan

help

 

90

3 days

10-23-2009 06:06 EDT

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

help

 

90

3 days

10-27-2009 23:14 EDT

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 specific and clear It would be enjoying to work on this project I wish to take up this work Regards

help

 

100

5 days

10-25-2009 07:32 EDT

(No Feedback Yet)

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

help

 

50

2 days

10-22-2009 23:38 EDT

(No Feedback Yet)

hi respected sir i have understand what u want i can do this on timely so please give this task to me.

help

 

99

3 days

10-23-2009 00:42 EDT

(No Feedback Yet)

Hi, Pivot table , query creating, excel report formation is not a difficult task for me to do. Pl. allow me to take maximum 3 days. I will finish the task as you expected and more. If you have faith, pl. award the project to me.

help

 

50

2 days

10-23-2009 01:54 EDT

(No Feedback Yet)

u will surprise to see my services

help

 

80

3 days

10-23-2009 01:54 EDT

(No Feedback Yet)

I'm an Expert in Excel and pivot tables. Satisfaction will be guaranteed or you will get your money back.

help

 

75

3 days

10-23-2009 02:57 EDT

(No Feedback Yet)

Hi, I saw your sample file it's the same as my work present work here..I know I can handle the task and can deliver the report as per your delivery requirement..I like to work with spreadsheets and with some mathematical calculations..I always do my job in serious manner and confidentiality..pls provide me the chance to work with the projects..thanks..

help

 

100

4 days

10-23-2009 03:06 EDT

(No Feedback Yet)

Hi, Can be done easily. I have done a more complex dashboard system with 12 sheets of data (current & history). Please see PMB. Rgds, Sunil

help

 

85

3 days

10-23-2009 03:23 EDT

(No Feedback Yet)

In the 1st day I can provide you a draft result of the project in which you can see and give feedbacks if necessary adjustments will be made. 2nd day will be fine tuning of the output report for you to see and test

help

 

70

3 days

10-23-2009 03:33 EDT

(No Feedback Yet)

I have posted a draft copy of the message in clarification board. It requires Microsoft Excel 2007. Certain macros need to be run to display the report. If you are satisfied with the draft copy, you may post a private message to me

help

 

40

3 days

10-23-2009 04:14 EDT

(No Feedback Yet)

I will be able to provide an excellent project meeting your requirements. Awaiting your reply

help

 

50

1 day

10-23-2009 22:25 EDT

(No Feedback Yet)

Can complete all your requirements using Excel and vba macros.

help

 

35

1 day

10-23-2009 06:25 EDT

(No Feedback Yet)

Please check PMB. Reagrds - MSTech

help

 

120

5 days

10-23-2009 07:38 EDT

(No Feedback Yet)

i want to work as part time job...

help

 

50

3 days

10-23-2009 07:53 EDT

(No Feedback Yet)

Hi, Please see PM for more details.

help

 

100

2 days

10-23-2009 08:11 EDT

(No Feedback Yet)

Dear Sir/Madam, I am interested in working for you. Please consider me. Thanks and Regards Jeno S

help

 

45

3 days

10-23-2009 11:03 EDT

(No Feedback Yet)

Hi! I can do this, my day to day work is basically doing analysis using excel and presenting it to management. I can do this with pivot chart using Excel 2007.

help

 

65

10 days

10-23-2009 11:58 EDT

(No Feedback Yet)

Please give me a chance to provide you deliverables with highest quality

help

 

80

5 days

10-23-2009 18:32 EDT

(No Feedback Yet)

I sat down and created all the data extracts from your sample spreadsheet, and am now building the charts. The multiple-months is no problem also. I have built several dashboards like this in the past.

help

 

38

2 days

10-23-2009 22:04 EDT

(No Feedback Yet)

Hi We are very much interetsed in your project and we have excel expert team and we can deliver 100% accuracy.Kindly keep in touch

help

 

100

2 days

10-24-2009 01:47 EDT

(No Feedback Yet)

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..

help

 

50

2 days

10-24-2009 02:14 EDT

(No Feedback Yet)

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

help

 

100

5 days

10-24-2009 06:16 EDT

(No Feedback Yet)

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.

help

 

49.75

1 day

10-25-2009 09:58 EDT

(No Feedback Yet)

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

help

 

33

3 days

10-26-2009 01:58 EDT

(No Feedback Yet)

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

help

 

80

2 days

10-26-2009 09:34 EDT

(No Feedback Yet)

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

help

 

32

3 days

10-26-2009 12:02 EDT

(No Feedback Yet)

I would love to do this work for you.

help

 

65

2 days

10-27-2009 04:07 EDT

(No Feedback Yet)

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.

help

 

50

2 days

10-27-2009 20:21 EDT

(No Feedback Yet)

sir pls provide me a chance to work with u.

help

 

35

3 days

10-28-2009 07:35 EDT

(No Feedback Yet)

Lets us provide you the best of our services.

help

 

50

3 days

10-28-2009 09:24 EDT

(No Feedback Yet)

I have significant experience doing statistical data analysis for the department of defense, including sophisticated reports in Excel. I can do everything on your list, including the "extras". This is my first project on Freelancer, and I will do an excellent job for a relatively small fee in order to gain positive feedback.

help

 

30

2 days

10-28-2009 13:03 EDT

(No Feedback Yet)

we have statistics lectures in our team.this is a simple task for us.please let us handle the project.

help

 

30

3 days

10-28-2009 13:52 EDT

(No Feedback Yet)

I have a lot of experience with Excel dashboards and would love to help. Regards.

help


    Bid on this Project