Find Jobs
Hire Freelancers

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

$30-250 USD

Closed
Posted over 11 years ago

$30-250 USD

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 )
Project ID: 2412278

About the project

24 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
24 freelancers are bidding on average $87 USD for this job
User Avatar
Excel developer since 1997. Can do. Regards, Svet.
$220 USD in 3 days
5.0 (54 reviews)
6.2
6.2
User Avatar
Hi, Please provide excel format to know more about work. I am very much interested in long term work relationship. Kindly provide me a chance to do work on it. Awaiting your positive reply. Thanks and Regards:- Teena Sethi
$30 USD in 1 day
4.9 (78 reviews)
5.6
5.6
User Avatar
Please check PM. Thanks
$80 USD in 3 days
4.9 (34 reviews)
5.4
5.4
User Avatar
Excel VBA pro - ten years experience.
$90 USD in 1 day
4.9 (25 reviews)
5.3
5.3
User Avatar
=============== Excel expert here! Please check PM. ===============
$100 USD in 2 days
4.5 (47 reviews)
5.2
5.2
User Avatar
Hi, Please check your inbox, thanks, data2007
$41 USD in 1 day
4.9 (31 reviews)
4.9
4.9
User Avatar
Hi, I can do it with vba. I'm programmer for years and very familiar with this kind of task. What are your daily/weekly sale reports format: csv? Do you have any predesigned excel report? Please send some sample sale report and designed summary report if you already have so I can have closer look and may place a better bid. Best regards, Cuong NH
$250 USD in 15 days
4.7 (21 reviews)
4.9
4.9
User Avatar
Hi I am ready to start
$30 USD in 1 day
4.4 (21 reviews)
4.9
4.9
User Avatar
Hi I'm really interested in your project. I'm an Excel Expert Programmer.
$60 USD in 2 days
5.0 (8 reviews)
4.2
4.2
User Avatar
We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.
$30 USD in 1 day
4.9 (16 reviews)
3.6
3.6
User Avatar
Hi... I would like to apply for the job.
$30 USD in 2 days
4.1 (7 reviews)
3.6
3.6
User Avatar
Stanley, Sample worksheet on the Private Message Board shows I can provide the file you require, It lists automatically the highest and lower sellers from a range of SKUs. Working from home in the UK across four freelancer sites I have a 100% completion record, reasonable Excel skills rating and good feedbackl from international clients. I am happy to work under a Confidentiality and Non-Disclosure Agreement if you want, I can start as soon as you pay the deposit into the site and send me a sample of your existing files. Look forward to hearing from you Bob Allen-Turl
$123 USD in 1 day
5.0 (2 reviews)
3.3
3.3
User Avatar
Thanks for your time in reading my bid. Here is what I can offer: - Excellent MS Excel skills, having used it extensively during my work with the Information Technology industry. - My Excel work includes usage of advanced features like macros, pivot tables, charts / graphs,LOOKUPs etc. - Assured high quality, on time and within budget delivery. - Very thorough, diligent and detail oriented in my work. Please look at the PMB for my credentials. I look forward to working with you on this at the earliest and am sure that I can do a great job for you, if you give me a chance.
$100 USD in 5 days
5.0 (3 reviews)
2.4
2.4
User Avatar
I am a US based consultant with immediate availability to work on your project. I look forward to working with you on this project; see PM for details regards, Paranos.
$125 USD in 1 day
5.0 (1 review)
2.1
2.1
User Avatar
I can surely help you out. Did similar jobs before. Thanks, Exopad
$100 USD in 3 days
5.0 (2 reviews)
1.7
1.7
User Avatar
Our company has been doing these jobs for years and our developers have been doing this for 10 years. We can accomplish this accurately and quickly.
$80 USD in 2 days
5.0 (1 review)
1.4
1.4
User Avatar
I can do it.
$180 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can definitely help you! Please let me know what type of file the original data is in and I may be able to adjustment my turn around time or bid price!
$100 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi sir m interested in your job hire me...waiting foe your positive response.. thanks!!
$70 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to do this project. You may test me with sample sheets.
$30 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Jul 18, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.