Find Jobs
Hire Freelancers

Inventory Aging Report on Google Sheets and Analytics/Infographics

$50-100 USD

Zavřený
Zveřejněno před více než 3 roky

$50-100 USD

Zaplaceno při doručení
Hello, I have two massive google sheet tabs. 1. with all sales and 2. with all purchases. row items typically include code, product name, date purchased/sold, qty purchased/sold. I'd like to have a third tab, that runs a line by line, by code, date (purchased and sold), cost (see attached template of the third tab) to generate an inventory aging report so that i can see what we purchased is sold. if not sold, how many days it remained since the date the stock came in to store and categorize them in order of days stock remained in stores (as per purchase document). I'd also like some easy to see infographics based on the aging eg. bar/pie charts with costs, grouped by product group, category, classification. eg. spare parts belonging to a specific product range such as consumables, engine parts, tire-tube, filters etc along with an a/b/c analytics considered for this inforgraphics. Thank you.
IČ projektu: 27520473

O projektu

33 nabídky
Vzdálený projekt
Aktivní před 3 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
33 freelanceři nabízejí v průměru $74 USD za tuto práci
Avatar uživatele
I can perfectly help you with that. I am a professional Financial Analyst, Google Sheet and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
$50 USD v 1 dni
4,8 (115 recenze)
6,7
6,7
Avatar uživatele
Hi, I have carefully reviewed the detailed job description and the excel file uploaded, on this job post. Utilizing my hands-on rich job experience in Inventory Management & Supply Chain Management and my expertise in all relevant techniques of Google sheets, I will deliver a professional job including the Inventory aging report along with the listed variety of charts with costs, grouped by product group, category and classification exactly as per your requirements. Please take a look at the few samples out of my work collection available on the "Inventory Management" and "Dashboards & KPI Reports" portfolio in my profile using the link below: https://www.freelancer.com/u/dfexcel. Please revert to fix up a call preferably a screen sharing session, to discuss the finer details in order to finalize at the earliest. Look forward to work with you soon. Thank you for your time and patience. Regards, Devashish
$78 USD v 3 dnech
5,0 (22 recenze)
6,3
6,3
Avatar uživatele
Hi, As I understand you are looking for Inventory aging report in Google sheets. It would help to get into a quick discussion. Keen to work on this project. Recently completed Google Sheets/Google Maps based projects with good feedback. https://www.freelancer.com/projects/google-maps-api/Goolge-Maps-personal-Pins/details https://www.freelancer.com/projects/google-sheets/need-help-with-google-sheets/details https://www.freelancer.com/projects/javascript/Advanced-Google-sheet-app-script/details https://www.freelancer.com/projects/excel/Google-Sheet-Formula-24741350/details Let me introduce myself as an expert in Google spreadsheets and Google docs. I am well versed with scripting in Google spreadsheets using Apps script, writing custom functions in Google spreadsheets, creating charts, custom functions, linking spreadsheets etc. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$100 USD v 4 dnech
5,0 (75 recenze)
6,2
6,2
Avatar uživatele
Marhaba Ranjit, I'm a dashboard expert I understand your request and create a master-sheet that summarizes all your purchases,sales and stock activity. We can add a timetable and as many filters as you like Presentation will be professional and usage friendly Will include a few charts and pie of course let us discuss your request further John
$75 USD v 7 dnech
5,0 (75 recenze)
5,4
5,4
Avatar uživatele
I have checked the Sheet Hello, Gratitude For The Job Posting If You Crave We Perform A Small Demo Work For You. We Are Very Positive For This Job Because We Have An Immeasurable Skills And Healthy Experience. We Are Waiting For Your Response. Thanks!
$50 USD v 1 dni
4,9 (25 recenze)
4,3
4,3
Avatar uživatele
Dear Client, Speed & Professionalism are my skills. I saw your description & i'm pretty sure that i can pull of it. I am ready to start now within 10% discount. Let's discuss in chat. Best Regards Monirul
$50 USD v 3 dnech
4,9 (19 recenze)
3,9
3,9
Avatar uživatele
Happy to do this file for you! Hey there, my name is Daniela. I graduated from law school, and worked on several positions as an accountant, account manager, billing specialist. I speak English, as well as Italian (language in which I've done my studies) and Romanian. Canva/Photoshop skills, as well as managing pages on different social media (Facebook, Instagram, etc). I have experience as an translator, and customer service, as well as marketing and writing contents. Here for any question you might have.
$100 USD v 2 dnech
5,0 (4 recenze)
4,0
4,0
Avatar uživatele
Hi! eCommerce Website enhancement I'm interested in the project. Alkapton so we; We are an advertising and marketing agency serving small and medium-sized businesses to adapt to digital transformation and improve their communication channels. We have an operating and entrepreneurial spirit. We create value with our educated and experienced team in communication, marketing, design and software. Alkapton; It works like a design school. We constantly research, learn and develop our customers to do our job in the best way possible. We admire knowledge and the sharing of knowledge. By assimilating the work of our customers, we offer them smart solutions, not excuses. In the most creative region of Istanbul; We work in Galata. We will be pleased to meet you for your needs.
$50 USD v 7 dnech
5,0 (2 recenze)
2,6
2,6
Avatar uživatele
Hello Client, Greetings!! I am Excel Expert with an experience of working in excel for more than 15 years. I will be able to create Inventory Ageing Report in Google Sheets. Looking forward to work with you!! Thanks & Regards Parmeshwar Bhandari
$100 USD v 7 dnech
5,0 (2 recenze)
2,3
2,3
Avatar uživatele
This is a quick service that is done within 24 hours and I can finish in a few minutes if possible. I will do the best for you and also provide extra services with unlimited revisions even after you accept your order I can also give it.
$50 USD v 3 dnech
5,0 (1 recenze)
1,9
1,9
Avatar uživatele
Hi I am a professional data scientist and I am well versed with Google spreadsheet. I can provide you the inventory ageing ananlysis and dashboard on Excel. DM me for more details Regards, Sangamesh KS
$50 USD v 1 dni
5,0 (4 recenze)
2,0
2,0
Avatar uživatele
Dear Project Owner I place my bid based on my expertise in python and data analytics and data visualization, excel and Google analytics. I have done these kind of works before. I have a master's degree in big data analytics from university of Barcelona. I know there will be many bids even with lower bid price than me. I can assure you quality work. Please consider my bid
$78 USD v 7 dnech
5,0 (2 recenze)
0,7
0,7
Avatar uživatele
Hello, I'm Accounting student. I understand what you need. I can finish the project in the time that you prescribed, can provide you with utmost quality.
$90 USD v 7 dnech
5,0 (1 recenze)
0,4
0,4
Avatar uživatele
I have past experience in inventory management sheets preparation for spare parts in warehouses also - I can do ABC , FSN , inventory quality and sales quality analysis with ageing also.
$50 USD v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hello sir, I understand your expectation and I am ferfect in data entry as well as account so I can complete this in the given period of time with 100% accuracy
$75 USD v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Dear sir, I have read and understood the project requirements fully. I am experienced data entry specialist in updating products in ecommerce websites ,images,videos and all. I can provide good long term service with best quality. Let us discuss via chat to start.
$75 USD v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hi , Dear sir i am right now available to do this job , i am also having very much experience to tackle inventory like this condition , please reply i will give you the demo first. regards, taj
$75 USD v 2 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I work with data analysis for update navigable maps and I think that this case is easy and i can provide a great report about your items
$70 USD v 5 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
i can do your work perfectly. Hi i am an certified excel vba Expert. For Professional works -Hire me.
$83 USD v 2 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I read through the job details extremely carefully and I am absolutely sure that I can do the project and I can completes your project on time and within your budget. thanks!
$52 USD v 3 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z UNITED ARAB EMIRATES
Dubai, United Arab Emirates
5,0
1
Ověřená platební metoda
Členem od bře 19, 2019

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.