I want to get a spreadsheet that will calculate my sell prices of consumables automatically while taking into account the following variables:
multiple suppliers of the same products (but they have different ordering codes)
Multiple freight costs from different suppliers - and cost amortised over the volume of cartridges they order (more they buy, less they pay freight)
Various markup levels depending on client, (4 levels of pricing markup at this stage)
One spreadsheet with multiple workbooks - one workbook per client - could be 100 clients or more
A formatted workbook per client that I can easily email to them (xls) with their default pricing for the printers they have already, hiding all costs/calculations - that client can enter their quantites they want and send us the sheet for us to process (manually at this stage) - same sheet I can use to quote customers..
I am doing this to ensure that selling consumables I am making a profit at all volumes I sell and prices are consistent when quoting..
Sample spreadsheet attached - I simply don't have the time to do this myself..
Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan
4 freelancer bu iş için ortalamada 27$ teklif veriyor
Hello! Let's talk over skype to discuss the project in detail. I'll prepare the excel sheet exactly according to your requirement. Regards Khurram