Inventory management excel sheet, stock management, automated, visualisation -- 4
$10-30 USD
货到付款
Administration File, in excel or similar:
General info:
I sell products through various ecommerce channels. Website, amazon, bolcom and etsy are the most important.
I would like to get a better overview of my administration by using an extensive excel spreadsheet file with possible macros and graphs.
Please see examples. Overview per platform, per month, numbers. but also costs, shipping costs, platform (sales) costs and purchasing.
These are the most important indicators in my buying/selling process, I have unique products that make marketing costs less than 5% of my turnover. per day, per month, per platform etc I want to see this.
Business info:
I sell felt pennants that are sent around the world by letter post. These are custom made with different designs that I design myself. Think of a football team, and then different designs for each team. I can also have different products per team.(Think of ice hockey pucks, pennants, flags, or metal license plates for example).
I have less than 5 different types of products. Pennants, wall decor license plates, NHL Pucks, NFL helmets, Flags.
Details:
Currently I have 1 overview tab with everything, which gets more and more undoable. I lose a lot of time administrating my deals, stock, and income per platform/product etc. Goal is to automate this more and get a better overview of purchasing costs and postage costs(my 2 biggest costs).
Also to get a better overview per platform and per product in maybe dashboards or simple graphs. Showing per product, per productgroup per month or so.
Solution:
Looking for a solution that can help me centralize all my streams of income (amazon, bolcom, webshop tec.) in 1 excel file and monitor everything here. Get an overview of my purchasing costs, postage costs, income per stream, per product etc. So I can better steer my business to be more effective cost wise and revenue wise.
Can be done in gdocs or excel. Would like to get insights via KPIs or indicators in graphs (like power Bi for example).
If done well there will be more work in the future, hopefully towards a longterm partnership!
Language can be dutch or English.
- See example file
WOULD LIKE TO SEE RELEVANT PROJECT EXAMPLES, RECENT FILES, SCREENSHOTS AND EXAMPLES OF FILES MADE AND ADMINISTRATIONS HELPING TO SETUP. AUTOMATED AS MUCH AS POSSIBLE.
项目ID: #35817829
关于项目
授予:
有45名威客正在参与此工作的竞标,均价$30/小时
Hi There, Getting on the "Inventory management excel sheet, stock management, automated, visualisation -- 4" first page of Google can be done by implementing Search Engine Optimization (SEO) changes to your website. 更多
Hi, We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on Accounting Please come over chat and discuss your requ 更多
Hi, I understood what you need. Basically for your task, I would suggest one consolidated spreadsheet, with a few columns of product type, purchasing cost, postage cost, abroad postage cost, platform, platform cost a 更多
I am a professional data entry operator. I have two years of experience in this field.I am weating for you's every time .I am excited to take your project . And I try to give my best performance. and finished very fir 更多
Trabajo Como Programador Con Experiencia Comprovable Actualmente Trabajo Exel full Soluciones De Prblemas data
Hello there I'd love to work on your project immediately. I'm professional in Microsoft Word and Excel. I have 4 years of experience in this matters. Looking forward to hearing from you.
Hello! My name is Jean and I'm an accountant with two years of freshly graduated experience, my speed of learning and my desire for perfection are my greatest assets. I'm waiting for our next interview. Sincerely,
Get free sample. I am ready to deliver within 24 hrs. I provide native Arabic translation. Hello I am interested in your project. I have excellent experience of this activity and skills. I will do it with the highest q 更多
Hi Dear, Hope you’re doing great! I am available to do this job for you. I clearly understand your all job requirements. That's simple and very easy task and I am happy to assist you. I am waiting for your response. T 更多
I'm a good Data entier and I have some experience about this. I am an admission candidate student .
This job actually suits with my capability. Because this is my first time, so i don't bud to high but still working my best
Hi , I am interesting to do the work and be efficient .I would like to try to work as per your requirement and expectation . let me knew about more detail of the project
I am an informatics engineer and I have worked with save the children for two years as a data entry and data management of beneficiaries information
GREETINGS, As I am a cost and management , I can centralize all streams of income in one excel and can also guide you in cost reduction. I assure you the satisfaction. We can discuss more details in inbox.
Greeting, hope you have a nice day ahead. I have read your requirement and I have experience in Excel, data entry and data processing. Hope we can work together.
Manejo (Excel/Macros/VBA), creo sistemas básicos para generar reportes de ventas, basándose en cálculos comparativos, contables y administrativos.
Hi sir, I'm interested in your project. I have done many projects related to your project. I have 2 year experience in Excel. So please contact me I want to know more about your project.