I need an excel expert to build a pricing and commission calculator

Cerrado Publicado hace 4 años Pagado a la entrega
Cerrado Pagado a la entrega

I own an A\C business and need assistance building a calculator that figures out the price of the job, the net profit from the job and the commission owed to the sales person.

I have the material pricing, system pricing, labor cost and operating expenses.

The material pricing is pretty straight forward and has around 20 separate products that are utilized to different degrees on different jobs. So the ability to adjust the quantity of the material is needed.

The systems are more difficult. There are about 164 different system combinations that we utilize and I need the main calculator to automatically pull the cost from auxiliary sheets that can be updated as prices are updated by the manufacture.

The operational expenses should be pretty static

The labor is straight forward as well and the only consideration is the job type (3 total) and how many installers are on the project.

The commission is figured once the net profit is finalized after everything is considered.

Excel Procesamiento de datos Contabilidad Entrada de datos Finanzas

Nº del proyecto: #23176666

Sobre el proyecto

63 propuestas Proyecto remoto Activo hace 4 años

63 freelancers están ofertando un promedio de $420 por este trabajo

schoudhary1553

Hello, I can help you to build a pricing and commission calculator I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several Más

$460 USD en 4 días
(526 comentarios)
8.4
P0L

Hello, I’m an Excel/VBA expert and I can build your pricing and commission calculator. Please check my profile and contact me to discuss further details. Regards.

$350 USD en 5 días
(501 comentarios)
8.0
proffesor1

Hi, I know Excel very well and have enough string statistical and economical background. I can help you with this project. Please let me know if you are interested in my proposal. Regards, Alex.

$500 USD en 7 días
(51 comentarios)
7.6
dgled

I have considerable experience in working with pricing, and I will be happy to send a sample application with markup prices for distributors, wholesalers, and retailers. I served as CFO, Controller, and Chief Accountan Más

$750 USD en 7 días
(111 comentarios)
7.5
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I would like to help you create the calculator you nee Más

$300 USD en 5 días
(334 comentarios)
7.4
indrapandu

Hi, I am excel and VBA/ Macro expert with high knowledge in costing/ project management. I can help you to build the workbook to calculate pricing and commission. Please check my profile, I never bid on the project tha Más

$250 USD en 1 día
(209 comentarios)
6.6
nvchien94

Hello there, I am an Excel expert with VBA/Macros skills. I also work as a Costing/Financial controller so I think I am qualified for your requirements. Please contact and we can discuss detail, I can focus on your ta Más

$250 USD en 5 días
(231 comentarios)
6.6
usmanhassan123

I can build this calculator for you easily by using Excel VBA and macro's. I already designed alot of Excel models, calculators and Dashboards. I have over seven years of experience in Excel development.

$500 USD en 1 día
(117 comentarios)
6.6
suyashdhoot

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 Más

$500 USD en 7 días
(93 comentarios)
6.9
AnowarRatul

$ 250 Only ------ In just 1 Day ----- Excel VBA Macro Coding, Formula Generation and Automation Process Expert with 5 Ratting.

$250 USD en 1 día
(391 comentarios)
6.8
beltran0404

Hello and Happy New Year, My name is Luis and I will be glad to assist you with your project. I have experience with Excel, formulas, and VBA and I can design this calculator to make easier your calculation process i Más

$300 USD en 5 días
(178 comentarios)
6.1
bhupendrayadav

I can develop an Excel based cost calculator, for calculating the cost of the job while considering the operational cost and cost of system combinations used. lets discuss this in detail in chat or over a call. Please Más

$250 USD en 3 días
(54 comentarios)
6.0
IgeS

Hi there, Can you show me the existing template or quotation you have and tell me more about you process your process in computing prices and commission, learning these things will help me design a more flexible PRIC Más

$333 USD en 3 días
(46 comentarios)
5.4
dheerajjshetty19

Hello! Am very interested in ur project and I am an expert in Finance/Accounts/Payroll/SAP/Bookkeeping/Excel/VBA/Marcos/Quickbook.I can meet all requirement of the project. Please Ping me for further discussion.

$250 USD en 1 día
(59 comentarios)
5.4
Baderah

I am an expert equity research analyst and advanced financial modeler with an experience of more than 10 years in the capital markets. I am also CFA and FRM qualified. Therefore I can aptly undertake your work. For mor Más

$250 USD en 7 días
(99 comentarios)
5.6
dionisiotumbaga

Hi, I am interested. I am a project planner with considerable expertise in the design and development of MS Access databases. May I propose to create a user friendly MS Access database with the same functionalities as Más

$250 USD en 7 días
(9 comentarios)
4.8
graphicaa

can discuss all feasibility and scopes we have on this project. Please feel free to write me back with further details how you plan to model the whole thing. Let's talk. Más

$500 USD en 7 días
(7 comentarios)
5.2
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.

$250 USD en 1 día
(26 comentarios)
4.8
ranadeep1

Hi I just want to know if the project still on I would like to bid or please ignore it it’s really..

$250 USD en 7 días
(8 comentarios)
3.3
StephanEdwards

Good day I am a pricing expert, and have developed pricing models for services and materials businesses in similar Excel pricing models. My proposal is to have a master data sheet, where all line item cost and sales pr Más

$500 USD en 5 días
(4 comentarios)
3.4