Job description
I ask for a quote for the preparation of Excell sheet calculating the selling price of the product on the portal "allegro" according to the given criteria, ie.
-net / gross purchase / shipping smart (related to the tables with surcharges for packages) if "not smart" then the value from the table of delivery costs , category commission , distinction , distinction fee , allero pay, net sales , gross sales , margin, mark-up - and all these data expressed in percentages. After entering the amount of sales must check the range in which I am in when it comes to the amount of surcharges (for example, from 40 to 49.99 is 1.49 PLN , 49.99-59.99 is already 1,,89) show the variants if the customer buys "with smart" and when he buys without smart and COD is 17 PLN which is added to the final commission)