Find Jobs
Hire Freelancers

pricing and stock analyst

$25-50 AUD / hour

In Progress
Posted almost 6 years ago

$25-50 AUD / hour

We wish to take advantage of new suppliers with cheaper prices that will give us a low sell price to our customers. in doing this we want to maintain our current gross profit dollars. We need someone to analyise all the data and then build us a model to use going forward.
Project ID: 17159130

About the project

21 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, This project needs good data analysis skills as well as to a certain extent good excel skills. I assume there are various materials that you procure and sell and the model needs to do the following 1) The supplier price needs to be analysed to come up the lowest prices for each of the material 2) Map the suppliers to the price and material identified in Step 1 3) Include your gross profit margin and come up with your possible selling price Also the model can be extended to do the following 1) Identify the mix of suppliers that can be used for each of the materials to get the optimal profit with derisking of dependency of a few suppliers 2) Trend analysis of sales of materials and negotiate a better rate with suppliers for a longer period based on volume I have excellent abilities in both data analysis and excel skills and can build this model with your inputs I have extensive experience in Analytics and Visualization. I have worked in analytics for the past 3 years . I was in Infosys for more than 16+ years and as part of this i was managing anaytics projects for more than 3 years. I have worked on different data analysis problems such as Churn, Forecasting problems etc. I also have excellent experience in Excel and Access and other Microsoft related technologies. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. Hope to hear from you Thanks Regards Vaidy
$25 AUD in 40 days
5.0 (14 reviews)
5.3
5.3
21 freelancers are bidding on average $37 AUD/hour for this job
User Avatar
Hello, I am Excel Expert and VBA Developer with Auditing Background Long story short, I can build for you model and analysis in excel And also if we can cooperate for a long term I could assist you with new clients to help analyze them and provide comparative ratios Anyways, if interested, contact me Thanks & Regards
$50 AUD in 20 days
5.0 (201 reviews)
7.8
7.8
User Avatar
Hello, I can help with you in your project pricing and stock analyst. I have more than 5 years of experience in Accounting, Data Entry, Data Processing, Excel, Finance. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$50 AUD in 40 days
4.9 (295 reviews)
7.7
7.7
User Avatar
PMP certified IT project manager, MBA in marketing, business analyst, market researcher and writer in the field of business plans, presentations, SEO, Adwords project management, marketing and branding, HR, operations, real estate, contracts, finance, legal, health, teams, training. Experience 10 years
$27 AUD in 40 days
4.8 (84 reviews)
7.3
7.3
User Avatar
I am a financial expert and a guru in Excel and VBA. I come up with creative and sophisticated financial & statistical models in a simplified and logical manner. I develop financial modules and financial statements including business valuation & terminal valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.) Furthermore, I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in Financial Reports, accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation.
$44 AUD in 40 days
4.9 (82 reviews)
6.9
6.9
User Avatar
I can do it for you quickly and exactly. Please contact me for saving your time and your money . .
$29 AUD in 40 days
4.9 (105 reviews)
6.6
6.6
User Avatar
Greetings! I am a specialist in financial modeling with 15+ years expereince in financial modeling for the largest investment banks globally. I am a chartered accountant and have built custom models for startups across sectors and regions. I am keen to help you here. Look forward to hear from you. Thanks, RRC
$50 AUD in 30 days
4.8 (76 reviews)
6.5
6.5
User Avatar
Hello, I have more than 14 years of exp and completed more than 325 projects. let me know once you have time to talk. Thanks
$25 AUD in 20 days
4.9 (177 reviews)
6.5
6.5
User Avatar
I have 4 years experience in Excel VBA, VB, Google Spreadsheet, Google Spreadsheet Script, JS and more than 10 years in Excel. Thousands of different tasks has been fulfilled from a simple daily routines with formulas and VBA to the complicated VBA projects in microbiology. I am looking for the projects on: - Excel - Excel VBA - Google SpreadSheet - Outlook VBA - Visual Basic - Data processing - Web scraping Mohsan
$44 AUD in 40 days
5.0 (67 reviews)
6.1
6.1
User Avatar
I can perfectly do your project work and able to complete full work in a shortest possible of time with 100% accuracy, perfection and according to your given instruction. I am ready to show you cost-free sample work for the project right now. I can say undoubtedly that I am the right person for whom you are looking for your project. Let’s discuss in PM so that we can start working on your project right away. I am waiting to have your quick positive reply. Thanks.
$25 AUD in 40 days
4.8 (41 reviews)
5.0
5.0
User Avatar
Hi ! My Name Is Murad, I’d like to be considered for your project. All The Skills You Need I Can Provide Them Please Feel Free To check My Feedback's Thank You
$41 AUD in 40 days
4.6 (81 reviews)
5.1
5.1
User Avatar
Hello there. In previous projects that I have done which was similar to what you need, there was historical data about orders made, which we then analysed against different suppliers, taking into account different exchange rates applicable, different shipping options to customers, cost price for different suppliers, applicable markup, etc. The result was a model which compared the combinations to assess the one that had the best results. This was achieved in Excel using the scenario manager and other tools in Excel. If you are looking for something similar to it, then I am available to assist you. Moosa
$25 AUD in 30 days
5.0 (33 reviews)
4.8
4.8
User Avatar
I am CFA and FRM qualified with ten years of experience in investment banking. I am also a graduate in finance and investment. Apart from that, my skills that are applicable in this project are financial and equity analysis, presentation of the selected stocks, financial modelling, and equity report writing skills etc. For more information, kindly contact me asap
$25 AUD in 40 days
4.8 (58 reviews)
4.6
4.6
User Avatar
Hi there, I am interested in your project. I would the desired model. To maintain current gross profit margin per unit, the selling price shall be reduced in the same proportion as that of reduction in purchase price. If you would like to earn the current gross profit amount (not margin) then voluminous sales has to be done since selling price will be reduced. We can have detailed discussion over it. Please message me to discuss more. Regards Jeetendra Chaurasia
$40 AUD in 40 days
4.8 (26 reviews)
4.8
4.8
User Avatar
hi there, my name is Vasily, and it will be pleasure for me to join you as financial analyses person. I will contribute all my efforts, experience and skills for deliver best results to you and your business. You can have a look in my profile for references about quality of my work and my business experience. It would e great to have chat with you for discuss project details. Looking forward to hear from you soon. Sincerely Yours Vasily
$50 AUD in 40 days
4.4 (10 reviews)
5.1
5.1
User Avatar
Hello there, I am a data analyst with more than 6 years of experience in product supply and pricing domains working with fortune 500 clients on data driven decision making. Please ping for further discussion. Best, Yash "If you torture the data long enough, it will confess"
$40 AUD in 40 days
4.1 (8 reviews)
5.0
5.0
User Avatar
Hi there, I'm a talented and well committed individual to work. I have successfully completed each and every project I accepted in freelancer.com. You can see them in my ratings and reviews. I assure the same in your project. I have read the project decryption and understood the project. I'm sure I can complete this project according to your requirements. In addition I have successfully completed such kind of projects previously. I'd like to discuss the project in detail. Please be kind enough to contact me via chat. Let's just get to work soon. Looking forward to hear from you soon. Thank you.
$25 AUD in 40 days
4.9 (12 reviews)
4.2
4.2

About the client

Flag of AUSTRALIA
DUDLEY PARK, Australia
0.0
0
Payment method verified
Member since Jun 13, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.