Excel analysis spreadsheet
$250-750 AUD
S-au achitat serviciile după ce au fost prestate
I have sales info for approx 25 items. Every month I get a sales report (and corresponding inventory report). I have data for 12+ months. I need to be able to analyse the sales rates, with visuals after I put the sales rates in.
In summary, I need a spreadsheet whereby
*I can load the weekly/monthly sales & Stock on Hand that will in turn show me sales rate.
*I also want to be able to have drop down boxes so I can select each sku/supplier to view. (I will have 6 or 7 names of suppliers with a few specific sku's per supplier)
*I need a Purchases section (column) whereby I can input what I have purchased and yet to arrive and have the spreadsheet amend the sales rate until stock runs out (adjusted sales rate based on shipping time - months).
*Reporting page with some pictures/graphs (not sure what I need to show).
*If possible, and separate to the above, I want to be able to load in sales throughout the year to show an annualised sales graph - In other words, I'd like to see for each sku, where the sales are happening throughout the year (graph by month/quarter).
Basically I need something I can easily upload sales data into that will spit out my sales rates over a given period, weigh up how much stock I have left at current sales rates and adjust for stock on order so I can be ahead of my inventory control.
ID Proiect: #17976943
Detalii despre proiect
78 freelanceri plasează o ofertă medie de 388$ pentru proiect
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Ex Mai multe
This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel analysis spreadsheet. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with you Mai multe
Dear client I am very much interested in the project. I understand the scope of work. I can certainly help you in this project. I have strong hold in excel and I have previously carried out a number of projects in the Mai multe
Hello, I can build a fully automated excel with the information and functionality you want using power query in excel as i have advanced excel skills and over 8 years in the field. Please check my portfolio to see Mai multe
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Mai multe
Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.
I am excel and vba expert, i have completed many excel analysis project, please review my profile. Mohsan
Hello there, as an expert in excel and VBA, i can help you to accurately develop such a workbook where you can enter your yearly or monthly sales data and get the required output as you have specified. Please contact m Mai multe
I possess exceptional data and statistical analysis experience. I use Excel, STATA, R-Programming and SPSS software’s in qualitative and quantitative research and report writing. I hold MBA (Strategic Management) under Mai multe
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Mai multe
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have an opportunity to consult deta Mai multe
hello! I can do it for you. I can assure you of a quality and accurate output within budget. I know exactly what you need. I will make dashboard for you considering all your needed reports that will easily update Mai multe
Hi, I have developed many excel tools for sales analysis, operations management, team scheduling and inventory management before and I can develop the excel macro exactly for your need to make your daily sales reportin Mai multe
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor Mai multe