Peruttu

Excel Spreadsheet/Macro to calculate margin

I have a sales rep in another city who iscurrently evaluated on her total sales. Unfortunately she often discounts price to increase total sales (discounting is common in our industry - especially at the moment), without taking into account whether she is generating margin for the company.

In our industry freight is included in final price (not added afterwards). Different areas have different freight costs, as does different volumes to the same area.

We are importers, so the exchange rate at the time of importing determines the landed price (FOB price varies very little). We also use a third party logistics provider who have set charges based on starting an order, and then variable charges per item.

I need all of this info in a dropdown spreadsheet that allows us/her to evaluate pricing to determine margin, to eventually pay her on commission on the amount she generates for the company.

Taidot: Excel

Näytä lisää: logistics excel spreadsheet, calculate margin spreadsheet, excel margin macro, margin account spreadsheet, margin account excel spreadsheet, spreadsheet calculate margin, macro calculate, we excel, sales rep in the us, excel macro calculate spreadsheet, macro sales margin, spreadsheet calculate, margin macro excel, excel macro margin, excel spreadsheet logistics calculate fob, macro determine margin, final price, sales rep company, sales excel, pricing excel, price excel, importers, i need a sales rep, freight, freight exchange

Tietoa työnantajasta:
( 0 arvostelua ) Palmerston North, New Zealand

Projektin tunnus: #485644

29 freelanceria on tarjonnut keskimäärin 64 $ tähän työhön

dev3dworx

I can get it done by Excel VBA (Visual Basic for Application) Please check PMB for details. Thanks and Regards 3dwOrX

115 $ USD 7 päivässä
(19 arvostelua)
4.7
CADDesign911

Dear goldmedalwines, Please see PMB. Thank you. Caddesign911

34.56 $ USD 1 päivässä
(1 arvostelu)
1.0
MissCaprice

Hi there! See PM for more details

30 $ USD 2 päivässä
(1 arvostelu)
1.0
muhammadasad007

Check PMB!

30 $ USD 1 päivässä
(0 arvostelua)
0.0
nanocom

Dear, I can do this kind of simple job.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
speedoflight

Hello. I am very familiar with your situation. I used to work on the traffic department of an auto parts plant (Bosch), and back then we started to keep track of shipments on Lotus 1-2-3. Eventually, we switched to Exc Lisää

90 $ USD 3 päivässä
(0 arvostelua)
0.0
MustafizProbal

The bid amount is dependent upon your data input rate and the time when you want it. If you want it fast then the price may be higher.

60 $ USD 30 päivässä
(0 arvostelua)
0.0
anjanikumarus

We have a team of 77+ staff and we can do all that you can ever think of outsourcing! Expert Virtual Assistants for Small, Mid & Large businesses and Busy Professionals Graduate Assistant: Internet Research, Data ent Lisää

250 $ USD 30 päivässä
(0 arvostelua)
0.0
DEFerrier

I am new to this site but do this sort of work quite regularly. I would love to do this work for you.

60 $ USD 4 päivässä
(0 arvostelua)
0.0
moynul11

I have 5 years experience to do this type of work. If you select me I assure you that I will do that work properly and send right time.

100 $ USD 5 päivässä
(0 arvostelua)
0.0
shridip

I am expertin Excel Entries. So can finish the project faster than anyone else.

30 $ USD 5 päivässä
(0 arvostelua)
0.0
rashid240

we are largest freelance service provider ranging diverse group of team working with us and timely promised delivery please feel free to contact us

30 $ USD 2 päivässä
(0 arvostelua)
0.0
msrodg

5yrs experience creating/implementing Excel pricing spreadsheets for Mfg. Industry. Your project sounds straightforward, I'll be able to complete in 2 days tops.

65 $ USD 2 päivässä
(0 arvostelua)
0.0
alanbalogun

I am ready for this work. Your description is quite clear. Since the scope of work is not stated yet, the quote here is just for a guide.

250 $ USD 20 päivässä
(0 arvostelua)
0.0
pspangen

I am pleased to bid on your request for an Excel spreadsheet to calculate margin of goods sold. The proposed statement of work is as follows: I. Gather full specifications and requirements. Est. Time: 30 minutes Lisää

100 $ USD 1 päivässä
(0 arvostelua)
0.0
obiwangv

Hi, Please check pm.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
rehamsaeed

I worked as cost accountant for industrail company, so have enough experiance to do such job

30 $ USD 1 päivässä
(0 arvostelua)
0.0
sorwarlm

I'm experienced in MS Office full and currently I'm in a data entry firm. So, the job is much more esier for me.

30 $ USD 2 päivässä
(0 arvostelua)
0.0
davidgk

Let's dot it with macros(VBA).. it's better yo maintenance

40 $ USD 2 päivässä
(0 arvostelua)
0.0
Sizzling

This sounds straight forward and very similar to my work. I am a Management Accountant and produce sales commission and budget sheets all the time. I have allowed 5 days as I assume you want this as easy to use as p Lisää

40 $ USD 5 päivässä
(0 arvostelua)
0.0