PRODUCT MARGIN REPORT

Product Margin Report is macro-enabled workook which saves time generating periodic reports. It combines Sales and Cost of Goods Sold ledger reports into one. The tool was created for accounting department of the electronic components distribution business. It is used monthly as a controlling tool and for sales reps commission calculation. Client estimated monthly time savings ranging from 3 to 6 hours / month.

PROBLEM:
Distribution business compensates Sales Reps based on gross profit generated on each sale. Current financial system does not provide report with required detail. Instead, it is possible to obtain exact data from two separate ledger reports – Sales and Cost of Goods Sold. Combining these two is not difficult task but it is highly time-consuming and tideous. The time spend each month to prepare this report was estimated for 3 – 6 hours.

SOLUTION:
We created excel spreadheet with the code working behind the scenes. The code executes all tideous and manual opearations that user needed to complete in order to prepare the report. The tool enables to prepare margin report in 5 minutes. All that needs to be done is exporting source data from the ledger, pasting it in the tool and clicking one button. Client estimated monthly time savings ranging from 3 to 6 h / month. Additonally, as report preparation takes few minutes now, it now also used throughout the month as a controlling tool which helps to identify unprofitable sales as they occur.