Find Jobs
Hire Freelancers

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

$30-250 USD

Terminado
Publicado hace alrededor de 7 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 13265310

Información sobre el proyecto

19 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
4,9 (115 comentarios)
6,3
6,3
19 freelancers están ofertando un promedio de $148 USD por este trabajo
Avatar del usuario
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 en 2 días
4,9 (454 comentarios)
8,3
8,3
Avatar del usuario
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 en 5 días
5,0 (475 comentarios)
8,0
8,0
Avatar del usuario
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 en 5 días
5,0 (313 comentarios)
7,4
7,4
Avatar del usuario
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 en 3 días
4,8 (14 comentarios)
5,0
5,0
Avatar del usuario
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 en 7 días
4,9 (4 comentarios)
2,9
2,9
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
1,6
1,6
Avatar del usuario
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 en 2 días
5,0 (2 comentarios)
1,5
1,5
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
4,8 (1 comentario)
0,1
0,1
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,6
0,6
Avatar del usuario
having more then 6 years expertise to work with automated excel dashboard preparation, can Easily prepare excel charts and other requirements
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
0,0
0,0

Sobre este cliente

Bandera de SOUTH AFRICA
Tshwane, South Africa
5,0
7
Forma de pago verificada
Miembro desde feb 27, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.