Sales spread sheet

  • Posted:
  • Proposals: 0
  • Remote
  • #686293
  • Expired
  • 0

Description

Experience Level: Intermediate
Hello
I would like you to quote for a job.
We sell products on Amazon and eBay for which we download daily sales on csv files in 2 slightly different formats.
We have product description and product code on excel which we can use
So ideally we need to have quick and seamless information on the below;
(a) DAILY SALES - Collect data on goods sold in each selling site, and both sites together on a daily basis.
(b) SALES PERFORMANCE - Work out have sales increased/decreased on a particular item over the last day or same time last week and over the year.
(c) CURRENT STOCK - Amend the stock in hand using sold data
(d) SELL OUT/REORDERING -Work out how long our stock in hand will run out using current sales
(e) NEW STOCK ARRIVAL (most important) -Incorporate stock sheet with new stock arriving (quantity and date)
(f) PROFIT – work out best selling and most profitable products.


Thank you
RJ

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.