Greatly reduced the amount of time to do complex calculation by creating a set of Visual Basic Macros to retrieve data from an Oracle database performing and manipulating easily and calculating the allocation quickly within the spreadsheet. In order to streamline calculations and simplify the calculation process, derived several equations: 1) crated a new equation by manipulating a transcendental equation to find a direct solution, 2) calculated a solution to a common problem by applying measured ratios to allocated the production to its component entities, and 3) solved a large number of problems by combining solution techniques.