Freelancer: tassie11
Compartilhar:
Denunciar Inscrição

inventory management

Here it is my proposition for your inventory and sales tracking. I have created 2 tables, one for the sales and one for the purchases, to be updated each day, so you can have all the records for all your transactions. In the Inventory tab, the actual stock (current date) it's automatically calculated, but you can also choose a different date if you want to see what was the stock you had in the end of last month for example. For the Sales analysis, I created a pivot table, where you choose the desired week (or date) and the pivot gives you the top 10 sales for the period. This is, of course, 100% customizable.

Inscrição nº 14 do Concurso para                                                 Do some Excel Work for Company to manage inventory
Inscrição nº14

Painel de Comentários

Não há nenhuma mensagem.