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.
29 freelanceria on tarjonnut keskimäärin 64 $ tähän työhön
5yrs experience creating/implementing Excel pricing spreadsheets for Mfg. Industry. Your project sounds straightforward, I'll be able to complete in 2 days tops.