HCM Planning in BPC
A few years ago we rolled out a very basic solution to allow our Finance folks to plan for headcount. They created their own templates and worked with business owners for HCM planning which includes salary, taxes, medical, etc to comprise a fully burdened expense for each employee. It works great except that the input templates and reports are full of very complex Excel formulas which determine the tax amounts based on rates and currency. This slows down the template considerably and periodically crashes the file. We have only a few hundred employees so the file isn't huge. Can anyone give me some suggestions on the best approach to calculating the fully burdened HCM cost for each employee without heavy use of Excel?