Need to create a daily and weekly sale in a microsoft excel file

Closed Posted Oct 18, 2015 Paid on delivery
Closed Paid on delivery

Hi,

Our daily and weekly sales report will show uniquie SKUs, Quantity on hand and Quantity sold. We want to be able to take these numbers and plug it into a spreadsheet template to generate information about sales for specific SKUs.

We need someone to create a daily and weekly spreadsheet template with Mircosoft Excel that can show the following information once SKU, Quantity on Hold, and Quantity sold is plugged into the template:

Top 20 Daily SKUs TOP 20 SKUs that sold the most

Top 20 Daily % Gainers TOP 20 SKUs that has the biggest % increase in sale (Only look at SKU that sold more than 10 QTY)

Top 20 Daily % Losers TOP 20 SKUs that has the biggest % decrease in sale (Only look at SKU that sold more than 10 QTY)

Low Stock Inventory Items that are running out of stock (Find velocity, Total QTY / Sales today, list items that will sell out within 21 days )

Top 20 Weekly SKUs TOP 20 SKUs that sold the most

Top 20 Weekly % GainerTOP 20 SKUs that has the biggest % increase in sale (Only look at SKU that sold more than 10 QTY)

Top 20 Weekly % Losers TOP 20 SKUs that has the biggest % decrease in sale (Only look at SKU that sold more than 10 QTY)

Low Stock Inventory Items that are running out of stock (Find velocity, Total QTY / Sales this week, list items that will sell out within 21 days )

Data Entry Data Processing Excel

Project ID: #8710747

About the project

41 proposals Remote project Active Nov 27, 2015

41 freelancers are bidding on average $110 for this job

pandeypriya2003

Hello, We highly recommend our team for your work. We have completed 900+ projects on freelancer alone, We have vast experience in data entry projects like data mining, data research, typing work, magneto data entry More

$34 USD in 3 days
(581 Reviews)
7.7
zExcel

A proposal has not yet been provided

$100 USD in 1 day
(257 Reviews)
7.7
someka

I am mostly online. Just drop me a message so that we can discuss further about pricing and job details.

$105 USD in 3 days
(149 Reviews)
7.3
cugamelover

I'm a computer science professional with extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: ht More

$45 USD in 3 days
(203 Reviews)
7.3
macroPOL

Hello, I am Excel and VBA expert. I can do this project If you have any questions I will be happy to answer. Best regards Jan Krzyzak

$50 USD in 3 days
(94 Reviews)
6.1
expertatwork

hey there...please share your weekly and daily sale reports...we can design a small app to generate the excel sheet that has all the information in the required format...please reply...we can discuss and hopefully get More

$49 USD in 2 days
(166 Reviews)
6.0
nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro conta More

$50 USD in 2 days
(64 Reviews)
5.7
vikas0903

Hi, Approach: I worked on similar project like preparing costing module for a chef, pest control company etc. Please have a look at projects for reference: Pest control costing sheet: https://www.freelancer.com/job More

$155 USD in 3 days
(39 Reviews)
5.6
serdaryalcin

As-salamu alaykum, I will use the data at the worksheet and my macro will create worksheets with the information you listed. It would take about two hours of my time, and we may further need to discuss. But here More

$60 USD in 3 days
(25 Reviews)
4.7
VinayOnTask

I have professional experience in building various reports in excel. I assure you to deliver quality work in less time. Thanks!

$120 USD in 3 days
(9 Reviews)
4.1
OliverFA

La propuesta todavía no ha sido proveída

$50 USD in 7 days
(10 Reviews)
4.0
rikari000813

Hi, I've been creating different types of dashboards in excel which uses vba/macro. I think if you can send a sample data and if we can discuss more, we can come up at an easy to use excel template. I can also sen More

$55 USD in 1 day
(9 Reviews)
3.5
ailingfoong

A proposal has not yet been provided

$155 USD in 3 days
(3 Reviews)
2.5
ekopambudi

Hi, i can support you in excel data processing with VBA i have experience on it, to check my profile and professionalism you check my profile feel free to contact me, Eko Pambudi

$155 USD in 3 days
(4 Reviews)
2.2
pbgn1964

I have am an experienced Supply Chain Professional having ease of working on MS Office applications with excellent level of accuracy. This work can be completed in the desired fashion and within the scheduled time peri More

$156 USD in 3 days
(0 Reviews)
0.0
Mokashihm

A proposal has not yet been provided

$111 USD in 3 days
(0 Reviews)
0.0
caryanvaz

The task can easily be done with vba scripting dictionary which is what I intend using to complete this task.

$138 USD in 2 days
(0 Reviews)
0.0
dumindasanjiwa

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
rajkamal19

I will complete the project with dedication and submit the project within prescribed time limit without any delay.

$155 USD in 2 days
(0 Reviews)
0.0
ChristopherCJ

I CAN HAVE THIS DONE AND BACK TO YOU ALL TO BEGIN USING AT COB TODAY IF YOUD LIKE. I AM A CERTIFIED MICROSOFT OFFICE SPECIALIST, GOING ON MY FIFTH CONSECUTIVE YEAR. I TRULY BELIEVE I AM THE BEST CANDIDATE FOR THIS P More

$233 USD in 1 day
(0 Reviews)
0.0