Closed

Small Business Inventory Consumption Forcast Spreadsheet

I am looking for a spreadsheet where I can input my daily sales on each tab for say up to 30 days (30 tabs) using custom SKU e.g. Product A, Product B etc. Each product will have sold mutltiple times during the day which mean Product A could be on Line 1, 5, 20 etc with a quantity sold for that transaction.

On the last/first tab I need it to show how many products (SKU) we have sold during those days I've inputted data, then work out a projection based on the daily average a product has sold.

e.g. if I input Product A each day 5 times for 30 days that would mean 150 sold during those 30 days combined.

I then can work out the daily average of 5 based over 30 days of selling etc.

Kind Regards

Skills: Excel, Data Entry, Web Scraping, Data Processing, Web Search

About the Client:
( 0 reviews ) Edgware, United Kingdom

Project ID: #34392221

44 freelancers are bidding on average £93 for this job

(543 Reviews)
8.4
(413 Reviews)
8.4
(315 Reviews)
7.2
ksriniravi

Greetings! I understand the requirements. I can set up a worksheet to capture daily sales data for all custom SKU. This would then be used to calculate and report the average sales per custom SKU in the first tab (Pro More

£35 GBP in 1 day
(247 Reviews)
7.0
(184 Reviews)
6.5
(44 Reviews)
6.7
(17 Reviews)
6.2
(65 Reviews)
6.1
PERPETUAL0

Hello Sir , Iam excel expert level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need More

£112 GBP in 2 days
(175 Reviews)
5.9
(98 Reviews)
5.8
hamidr2020

Hello, I am an Excel expert. I offer my services to create Inventory Consumption Forecast Spreadsheet with 30 tabs for daily sales, summary tab for SKU sold and projections based on daily average. We can discuss furth More

£50 GBP in 1 day
(66 Reviews)
5.5
raoarslan56

Here sir, I have read your job description carefully! I will create you spreadsheet to input daily sold(i-e custom SKUs) for all products, then based on reocrd each product SKU Sheet+Table + Graph will automatically up More

£75 GBP in 1 day
(32 Reviews)
5.2
Dataservice429

Hello, We are a Professional Deep Data Miner, Data Scraping, Data Entry Operator, and Lead Generation expert in since 5 years. We are carefully reading your project description. We learn that you need to Small Busines More

£20 GBP in 1 day
(11 Reviews)
4.7
(3 Reviews)
4.8
(12 Reviews)
4.3
(2 Reviews)
3.9
arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and More

£20 GBP in 1 day
(13 Reviews)
3.7
(7 Reviews)
2.9
AlikAgaian

Hi, there. I am Alik and as you can see my profile, I am a tailent developer. I may be able to reply real-time about what you want to discuss for. Now as a manager of our team, 5 elite Full Stack master developers an More

£250 GBP in 40 days
(1 Review)
2.6
rowangr2044

❤️My current review is due to new client’s mistake. ❤️ -----------For confirm, please look at his feedback on my profile. ----------- I am a program expert with 10 years of experience. I have complete skills to complet More

£135 GBP in 7 days
(1 Review)
1.4