Sales return is an event when good are returned from the buyer to the supplier for one of the following reasons: wrong orders, more goods delivered than the requested, damaged product, damaged packaging, expiration of the term … By analysing the cause of the reimbursement we may , for a longer period of time, to decide what needs to be done to reduce their number to a minimum.
When you buy a product, unless you buy it on the flea market (where they have a rule “they gave it to me that way”), you get the right to warranty. By warranty, the manufacturer undertakes to repair or replace the damaged goods to another within the specified time period. Warranty is not something that is specifically bought, it comes with the product. How to calculate warranty costs?
How to calculate distance between the two places on the map? The simplest way is by using the formula for calculating the haversine, which for the given coordinates returns the distance of the points on the sphere. However, this is the air distance. If you are planning to take off on the road, you are surely interested in getting from point A to point B by traffic. In the following text I will show you how to use Google Maps to calculate distance.
The catalog is a list of items associated with prices that and, by rule, it should not be changed more than once a day. In practice it is formed by consecutive adding codes of items, dates and prices in the table. How to find the last (current) price? Although at first glance it seems simple, this can be a considerable brain teaser. Also, this is an excellent demonstration of the practical application of formulas containing arrays and one of the “recipes” you will surely like.
In one of the earlier „recipes“ I briefly described the statistical functions in Excel. My knowledge of statistics is quite modest (one of these days will probably take some additional lessons to improve my knowledge). However, I would like to dedicate one article to this area. On a practical case, the analysis of wages in a small company, I’ll show you how you can use these functions to make you come up with some interesting conclusions.