Find Jobs
Hire Freelancers

Business Analysis / Statistical Model

$30-250 USD

Closed
Posted almost 10 years ago

$30-250 USD

Paid on delivery
I help companies manage their transportation spend and I need a way to measure cost savings that my company has delivered against what their costs would have been if they continued to ship products in the manner they have historically. I need a method for measuring what their costs would have been by using past shipment data and a formula by factoring in weight, miles traveled during the month, and the increase/decrease in fuel surcharge. The are variables that come into play, like: fuel cost, distance of shipments, weight per shipment to consider. I realize that it can’t be perfectly accurate, however, I’d like to be able to provide a “you would have spent this amount” estimate based on a formula that would be accurate within +or- x%. I want to use a year over year analysis - example: November 2013 vs November 2014. When November 2014 comes, I’d like to be able to enter total weight, miles, and a fuel surcharge amount and have the model give me a total cost of what they would have spent had they continued with their strategy they used a year ago. I have two months of recent data and a fuel surcharge matrix - fuel currently represents 30% of total cost and moves up and down depending upon the price of fuel. What ideas do you have to be able to build a google spreadsheet for me to help me estimate what costs for client would have been given past shipment history?
Project ID: 6076737

About the project

24 proposals
Remote project
Active 10 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
24 freelancers are bidding on average $193 USD for this job
User Avatar
I am the top ranking freelancer of statistics and mathematics and excellent in both the subjects. I have done a lot of similar jobs before. Please, check reviews of my past projects.
$250 USD in 5 days
4.9 (139 reviews)
6.4
6.4
User Avatar
Hello, Your problem sounds like it needs multivariate regression to be solved. The data might as well have some time dependence structure as well. I would be happy to work on your project if you provide some data. Best, Iva
$155 USD in 3 days
4.9 (60 reviews)
6.0
6.0
User Avatar
Hi What we are talking about here is variance analysis or a common base approach. Say we are comparing the total shipping costs for same of two years (Jun 13 and Jun 14) and the actual cost incurred in Jun 14 is higher. The client may say that under your management the costs have actually gone up. So why should I use your services. To counter this, you must be equipped with all the right numbers and analysis which could be in the following way : 1. The difference could be due to volume or cost. First of all we adjust the total cost to bring both the periods to the same volume level. Say, Jun 14 volume was 10% higher than June 13. So we increase the June 13 costs by 10% of reduce June 14 by 10%. 2. The difference between the costs adjusted for volume is due to cost. Now we need to identify the cost drivers which could have affected the overall cost which could be routing, distance, freight capacity utilisation etc which you will know better than me and You will guide on these. 3. This way we will eliminate all external factors by adjusting any one of the period's costs such that the only difference that will remain will be your logistic management vs the earlier regime. No we can attribute the entire remaining difference to this factor alone.
$188 USD in 7 days
5.0 (42 reviews)
5.7
5.7
User Avatar
Hi, I am interested to the job you recently posted. I have been a professional statistical analyst for over six years. I am an expert user of SPSS, STATA, Eviews, gretl, Minitab and MS Excel. Please see my public profile for my education, related work experiences, previous work feedback and portfolio items. As your requirements, I am able to find an algorithm that will predict the costs using advanced regression methodology using historical data. I am excited to assist you in cost prediction formula using google spreadsheet - please feel free to contact me directly to discuss this position further. Thanking you.
$300 USD in 6 days
4.6 (70 reviews)
6.2
6.2
User Avatar
A proposal has not yet been provided
$231 USD in 5 days
4.7 (16 reviews)
5.3
5.3
User Avatar
Excellent in statistics and mathematics is here to do the job for you. You may go through the reviews that I received from my employer before awarding the project.
$200 USD in 3 days
5.0 (39 reviews)
4.7
4.7
User Avatar
Hello ready to start asap to deliver you, If you can give me your notes and conditions about the model, I can deliver it to you fast and deliverable can be an excel worksheet that you can use it, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, mathematics, accounting, cost calculating, project scheduling and project management and finance that helps in this project.
$147 USD in 4 days
4.4 (35 reviews)
5.0
5.0
User Avatar
Hi, I am writing to express my interest in your project. I work as a Data Scientist and can ensure a quick turnaround.
$155 USD in 3 days
5.0 (5 reviews)
2.9
2.9
User Avatar
Hi, I am a mechanical engineer and expert in Financial management and Stats. Currently I am working as the project manager in production company and it is entirely involved with evaluation of business plans. This is really easy task for me. I can guarantee 100% accuracy and quick completion. You can view my reviews to assure the quality of my works. Hope to hear you from soon. Thank You.
$90 USD in 2 days
4.9 (4 reviews)
2.7
2.7
User Avatar
hi............. I am an Economics & Finance graduate and a professional researcher. I am also proficient in econometrical modeling. I can help u doing this project. like to discuss in detail. thanks!
$222 USD in 7 days
5.0 (4 reviews)
2.5
2.5
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Dear Employer I am new to the website and currently have bid the lowest as I need to get few projects to make some reviews. I have already started working on this ..my husband is in transportation line we are working on the information , but there are few things we need to understand from you, if you feel we are worth giving a shot please contact us. My background I have been part of strategic planning for 5 years and am very well verse with preparing financial, dashboard and MIS, thus this needs good excel skills. I am good in analysing data and have made business presentations to senior management. My presentation skills are also good as i have prepared presentations for senior management. Hope to get the project!!
$100 USD in 7 days
5.0 (1 review)
1.0
1.0
User Avatar
I am a certified chartered accountant.I have work experience of two years in Corporate finance division if Aditya Birla group. Let me know if you need other details. Hope to hear back from you. Thanks
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Chartered Accountants Do you want your accounting and finance including tax matters and other related services sorted. we provide high quality services to our clients. We inspire our Clients worldwide and guide them to do the right thing, and our commitment to quality, which is embedded in who we are and everything we do. Our services are included as follows: Advisory Financial services Assurance Services Accounting, Compliance and Reporting Financial Accounting Advisory Services, Financial Statement Audit, Tax Services We can assist you with these critical issues in today's tax environment, including: Country Tax advisory Personal Taxes Tax Accounting Transaction Tax VAT, GST and Other sales taxes
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there! i've been doing pretty much the SAME EXERCISE on a daily basis for the last 5 years. Except that i'm working in _utility expense_ recoveries. Basically, i do these reports on what my boss' company saved to a client on yr vs yr basis. So, as to your task, i'd say there are these steps to be made: 1. Come up with a formula based on miles and pounds. adjusted for that fuel surcharge. also i assume there should be some 'minimal fee' for either cargos too light or travels too short. 2. create a routine (or enter manually) fuel prices on a 'per item' basis (using con-way data). 3. calc 'what would have been' (prior cost) scenario on a 'per item' basis. After that we could simply use 'sum' function to report svgs on a weekly/monthly basis. My skype is igorisupoff feel free to contact me to discuss the details. Best regards! :)
$194 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I would be able to with a provide you with a flexible and easy to use spreadsheet to perform this function (easy to also add some graphs for visual impact) I worked for freight forwarders for over 20 years and have created many sheets like what you are after especially road transport in identifying preferential suppliers. I am familiar with fuel surcharges in addition to the many ways in which the cost of a load is determined. Regards Matthew
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have good experience in analyzing the data and predicting the future values and predicting the future prices.
$150 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Aucune proposition n'a encore été fournie.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, Hope everything is fine at your end. Reference to your requirements of project you posted, I hereby take the opportunity to offer my services for this project. As you can look into my credentials that I have hands on experience in Accounts and Finance, furthermore I have been teaching Business Analysis, Performance Management and Corporate Finance subjects for past 8 years which give me edge over other freelancers applying for this very project. Even I have worked on quizzes and exams many times. I assure you that I will not let you down once you give an opportunity to work with you. For the discussion boards, Let me tell that I have the best knowledge of such things, As a teacher and as a freelancer. I will discuss the whole requirements with you first to get clear understanding and then I will start working on my own and will give you my 100%. I look forward to the positive response from your kind side. Regards, Saqib Iqbal Freelancer
$244 USD in 3 days
0.0 (1 review)
1.0
1.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Jun 4, 2014

Client Verification

Other jobs from this client

Help with Business Finance
$30-250 USD
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.