Need to create a daily and weekly sale in a microsoft excel file
$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: #8710747
About the project
41 freelancers are bidding on average $110 for this job
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
I am mostly online. Just drop me a message so that we can discuss further about pricing and job details.
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
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
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
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
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
I have professional experience in building various reports in excel. I assure you to deliver quality work in less time. Thanks!
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
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
The task can easily be done with vba scripting dictionary which is what I intend using to complete this task.
I will complete the project with dedication and submit the project within prescribed time limit without any delay.
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