Problem
A trading company regularly imports Far Eastern products. When orders arrive, the company has to calculate the actual cost of the products, including packaging and labels. In order to do the calculation of the unit cost it is necessary to make the foreign currency exchange, to consider the expenses of the transport, the bank expenses, the expenses with freight forwarder, taxes, as well as, of course, the unitary and global costs in the invoice of the manufacturer. This process took about a morning or afternoon of work and often required an extense review of potential errors.
Solution
An Excel spreadsheet with its own fields was created to launch all the variables, allowing a quick calculation with presentation of the cost values by product.
Result
The businessman is able now to conclude the operation in a couple of minutes, leaving him free time for other important activities. In addition to this productivity gain, the number of calculation errors has also been reduced, and now is very rare.
Did you know we can help your organization to implement management tools? Contact us!