Find Jobs
Hire Freelancers

Develop a Microsoft Excel Sheet for optimal project pricing and determining likelihood of expected profit

$30-250 USD

Dokončeno
Zveřejněno přibližně před 7 roky

$30-250 USD

Zaplaceno při doručení
I need someone to develop an excel worksheet for me that does the following: Part 1 Determine the likelihood of a lump sum (I.e. fixed price) project making a profit (I.e. not making a loss). The lump sum (fixed price) project will have a maximum and a minimum range at which it can be priced. Given this maximum and minimum range, build a spreadsheet that returns the likelihood/probability of achieving 80% of the maximum price and what this 80% number is. The objective ultimately is to determine probability of achieving 80% of the maximum price value of the project. Similarly, the sheet should be dynamic enough to be adjusted so as to determine what's the likelihood to achieve 50% or 10% or any other percentage of the maximum value of the project. The above should be illustrated in a histogram, a (bell distribution) curve and a cumulative distribution curve (similar to an s curve). The sheet should then dynamically indicate the 80% point (or any other predetermined percentage) on the curves/graphs. Part 2 Knowing the above mentioned 80% position, determine the expected profit if the project was costed at this 80% value. I.e. If Part 1 found that the 80% is $1million, what is the expected profit if the project was costed at this $1mil price. Again remember that this is a lump sum (fixed price) project. Plot an expected profit graph against the cumulative distribution curve from Part 1 above. The objective is to see what is the expected (probable) profit/loss at the minimum cost and also at the maximum cost.
IČ projektu: 13265310

O projektu

19 nabídky
Vzdálený projekt
Aktivní před 7 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 USD v 3 dnech
4,9 (115 recenze)
6,3
6,3
19 freelanceři nabízejí v průměru $148 USD za tuto práci
Avatar uživatele
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$250 USD v 2 dnech
4,9 (454 recenze)
8,3
8,3
Avatar uživatele
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$200 USD v 5 dnech
5,0 (475 recenze)
8,0
8,0
Avatar uživatele
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$200 USD v 5 dnech
5,0 (313 recenze)
7,4
7,4
Avatar uživatele
Greetings, I am professionally qualified Accountant from Sri Lanka with A degree in Management & Finance. I am a full-time freelancer. I have the experience in project appraisals and Project management. I am familiar with excel too and my speciality is Accountancy. I can create you any worksheet related to business. Please come to a chat discussion to discuss the project further. I have 13 years of experience in Audit, Accountancy & Secretarial related in the corporate sector. My duties included Invoicing, Quotations, Purchas orders, Bookkeeping Including preparation of chart of accounts, Audits in branches, Unit costing, Cost departments, Selling price evaluation, Pricing for tenders, Audits, Budgeting, Variance Analysis, Financial Accounts up to year end Accounts, Management Accounts, Unit costing, Payroll, HR, cash flows, Project appraisals, Etc. I am familiar with web based accounting systems, Quick Books & MS office, especially with Excel. I have the experienced in handling logistics, Inventory, Etc. I have the experience in dealing with financial institutions, government processes by working with high profile managements in all sectors. Hopefully, my skills meet your requirements. Look forward to discussing with you the opportunity further. Kind regards, Dilip.
$120 USD v 3 dnech
4,8 (14 recenze)
5,0
5,0
Avatar uživatele
Good day, I can create organized and professional dynamic excel sheets. I deliver my work on time and at high degree of accuracy. Please check my profile. Primary sample of work will be provided. Best Regards,
$222 USD v 7 dnech
4,9 (4 recenze)
2,9
2,9
Avatar uživatele
Hi there.. I have read your project details completely and willing to do it for you... Check my recent reviews for our quality work on on time delivery Please inbox and we can discuss about project...
$155 USD v 3 dnech
5,0 (1 recenze)
1,6
1,6
Avatar uživatele
Hello, My name is Alex and I have a strong Finance background, with more than 3 years working in investment banking. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well as I have also a strong financial background with Bachelor and Master degree in Finance and Banking, while also passing CFA Level II Exam (Chartered Financial Analyst) . I would love to work on your project so looking forward, Alex.
$205 USD v 2 dnech
5,0 (2 recenze)
1,5
1,5
Avatar uživatele
Dear Sir or Madam, I would like to recommend myself for delivery of your project as my few years controlling as well as Big 4 experience will result in delivery of a product which will satisfy your needs. If you have any questions about myself please do not hesitate to ask. Regards, Robert
$111 USD v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I am a business planner, with MBA degree in Marketing I have more than 5 years experience in writing business plans I can Also make a professional Pitch deck, Video Deck and pro financial statement for the upcoming 5 years The plan will be smart and on time don't hesitate to invest your time with me Just chat for more Details
$150 USD v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hello This is Nitin Chaudhary expect in excel. 2year experience in Ms-office and data entry. Recently done the data entry job. Thank you
$30 USD v 1 dni
4,8 (1 recenze)
0,1
0,1
Avatar uživatele
Dear sir, I have five years experience in audit and accounting, six months with an investment bank. Now, i am a portfolio manager. I always try to work harder and become a financial expert. I am a new freelancer, but with my experience, I will try to bring the best results for you! Thank you!
$111 USD v 3 dnech
0,0 (0 recenze)
0,6
0,6
Avatar uživatele
having more then 6 years expertise to work with automated excel dashboard preparation, can Easily prepare excel charts and other requirements
$30 USD v 2 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Dear please give me the chance to work for you Already I have read your description so I am 100% clear about your task, just award me then right now I can start your task with my team mates. I have a question on the project; in how many days or hrs do you need your work to be done? For more detail send me a PM Thanks
$111 USD v 3 dnech
5,0 (1 recenze)
0,0
0,0

O klientovi

Pochází z SOUTH AFRICA
Tshwane, South Africa
5,0
7
Ověřená platební metoda
Členem od úno 27, 2017

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.