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.
36 freelancers are bidding on average $74 for this job
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
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
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.
i will do it because i have a lot of experiance on google sheet... I am happy to answer any queries that you may have. Looking forward to working with you. Thanks...