Find Jobs
Hire Freelancers

Inventory Aging Report on Google Sheets and Analytics/Infographics

$50-100 USD

Cerrado
Publicado hace más de 3 años

$50-100 USD

Pagado a la entrega
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.
ID del proyecto: 27520473

Información sobre el proyecto

33 propuestas
Proyecto remoto
Activo hace 3 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
33 freelancers están ofertando un promedio de $74 USD por este trabajo
Avatar del usuario
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 en 1 día
4,8 (115 comentarios)
6,7
6,7
Avatar del usuario
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 en 3 días
5,0 (22 comentarios)
6,3
6,3
Avatar del usuario
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 en 4 días
5,0 (75 comentarios)
6,2
6,2
Avatar del usuario
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 en 7 días
5,0 (75 comentarios)
5,4
5,4
Avatar del usuario
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 en 1 día
4,9 (25 comentarios)
4,3
4,3
Avatar del usuario
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 en 3 días
4,9 (19 comentarios)
3,9
3,9
Avatar del usuario
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 en 2 días
5,0 (4 comentarios)
4,0
4,0
Avatar del usuario
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 en 7 días
5,0 (2 comentarios)
2,6
2,6
Avatar del usuario
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 en 7 días
5,0 (2 comentarios)
2,3
2,3
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
1,9
1,9
Avatar del usuario
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 en 1 día
5,0 (4 comentarios)
2,0
2,0
Avatar del usuario
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 en 7 días
5,0 (2 comentarios)
0,7
0,7
Avatar del usuario
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 en 7 días
5,0 (1 comentario)
0,4
0,4
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i can do your work perfectly. Hi i am an certified excel vba Expert. For Professional works -Hire me.
$83 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED ARAB EMIRATES
Dubai, United Arab Emirates
5,0
1
Forma de pago verificada
Miembro desde mar 19, 2019

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.