Closed

Sales Tracking Spreadsheet

This project was awarded to rdkarthikn for $114 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
N/A
Total Bids
25
Project Description

We require an Excel Spreadsheet containing multiple worksheets for the tracking and reporting of sales representatives sales activities. We have uploaded a document that shows what some of the values will be however please note, this is for reference only.
The spreadsheet will be required to perform the following functions.
1. Record the actual unit quantities of sales by product for individual sales representatives on a monthly basis. Whether this is achieved from a single data antry sheet or sheets my month, etc is not important to us.
2. Using the entered data described above, we need to report on the following.

a. Individual sales representative reports - by month, grouped by product category, displaying actual montly sales quantity, YTD Total and YTD Variance on separate worksheets for each representative.
b. Group sales representatives report - grouped by product category, displaying individual YTD sales quantities & YTD variance for each representative on the same worksheet.

3. Each product item is afforded a points score that is used for the calculation of sales bonus points. In addition to the actual sales QTY reports, we need to report on the points score separately to the actual sales qty. This is achieved by looking up the points value for a given product and multiplying by the sold QTY.

Points accumulate on a monthly basis however if no sales are achieved in any one of 4 product categories for a given month, no points for that month (in any of the 4 categories) contributes to the YTD total. A crude example of what we want to achieve is included in the example (don't pay any attention to the formulas).

For the points reporting, we require the same as in item 2 above, replacing the sold qty with the points value.

4. If you care to add some meaningful graphs we will happily pay extra.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online