Posts Tagged ‘Spreadsheets’

Are you kidding me!

Wednesday, March 2nd, 2011 | Posted by Eric Marcus in Blog

As our lead inside sales associate, I get the chance to talk with lots of costing people. I can recall a conversation where one prospect expressed a great interest in understanding enterprise costing and we started to chat about his needs.

He recalled an incident when one of his internal customers was working on a project that needed cost data. This company was like many others – an ERP system and many legacy systems they adopted from acquisitions. Needless to say, spreadsheets played a critical role in managing the data required to run the business.

His internal customer shuffled through the MANY spreadsheets and selected what he thought was the latest and most accurate cost data for his analysis. After weeks of work, my prospect discovered that the customer was using the wrong spreadsheet and had to deliver the bad news. Well, I’m sure you can imagine the reaction of his customer: Are you kidding me! Sadly, he wasn’t and the analysis project had to start back at square one.

Perhaps you can relate with this story, maybe not. For companies that use enterprise costing systems, having a central location where calculations, business rules, and methodology are stored, when a change is made – it’s updated everywhere. This eliminates the problems with spreadsheets where you must keep track of where, when, and why the changes occurred which can ultimately lead to wrong or inaccurate cost data.

If you live in a spreadsheet maze like this at least you know that you’re not alone. But keep in mind that there are better options available.

Want to get an update as soon as our new blog articles are posted?  Follow us on Twitter to get the latest updates.

Share |

Don’t Force Your Managerial Accounting Process into a Transactional System

Friday, November 12th, 2010 | Posted by Andy Bigalow in Blog

Square Peg in a Round Hole_0565

I have spent the majority of my technology career in the Manufacturing Computer Systems space and have been most impressed with how the world of technology has improved our ability to automate our business transactions.  MRP solutions morphed into ERP solutions.  The ability for a company to design, order, buy, build, ship, invoice and produce a financial statement reflecting their business during a given period of time has provided tremendous gains in not only the transactions costs of doing business, but the ability to manage that information in large quantities.  Multi-country, multi-language, multi-plant, multi-tax code, multi-currency, multi-multi-multi has been a godsend for those large international manufacturing companies.  The likes of SAP, Oracle and others have provided the transactional information essential for running a complex organization.

These systems do a great job of building a standard cost for a product or SKU.  This cost is needed to build a cost-of-goods sold and provide the basis for financial reporting.  However, where these transactional processing ERP systems fall short, is the ability to provide detailed managerial cost accounting information and flexibility.  These systems were not set up to track simultaneous multiple costs for the same SKU and easily manage these different cost attributes by plant, by process, by date, by material substitution, by shift, by packaging etc.  Only a standard cost and current cost are easily handled.  Building rates inside the factory at the machine, work-center and department levels don’t exist.

By using ERP systems for process manufacturing costing processes is often like forcing a square peg into a round hole. The detailed cost data they need to track is splintered away and they’re forced to use a spreadsheet or build a database program to handle the analysis.  I had one controller tell me that his company had “blown up” several computers trying to replicate their costing processes in a spreadsheet.  Process manufacturing companies must become aware that there is an alternative solution of managerial cost accounting that resides in complete harmony with the traditional transaction ERP systems.

Share |

Does your company use spreadsheets for your budgeting, planning and forecasting processes? Are you satisfied?

Tuesday, August 31st, 2010 | Posted by admin in Blog

BPM Partners recently performed a survey of midsized enterprises to better understand their budgeting, planning and forecasting practices. According to the results, “Of the 138 survey respondents whose primary planning, budgeting and forecasting technology is spreadsheets, only 27% of respondents say their finance staff is “very satisfied,” as compared to 47% of those whose primary technology is an automated performance management application.”

Read about the survey: http://www.b-eye-network.com/view/11452
What are the challenges your company faces using spreadsheet tools for the budgeting and planning process? If your company has invested in an enterprise solution, how has it improved the process?

Share |