¿Cuánto dinero se gasta la compañía en hojas de cálculo? Es una pregunta a la que ha querido dar respuesta Philip Howard, de Bloor Research. Según nos cuenta en su artículo "Managing spreadsheet fraud", publicado en The Register, dado el uso extensivo que se hace de esa herramienta en las empresas y lo expuesta que está a los errores, la factura que las empresas están pagando por esos errores, puede estar, suponiendo según las estimaciones de PwC y KPMG que el 90% de las hojas de cálculo pueden contener algún tipo de error, entre los US$10.000 y US$100.000 por error y por mes.
"According to both PricewaterhouseCoopers and KPMG, more than 90 per cent of corporate spreadsheets have material errors in them. Worse, estimates suggest that such errors costs between $10,000 and $100,000 per error per month. Let's take the Fortune 500 and let's suppose that each of these companies has just 10 (a pitifully small number) spreadsheets of corporate significance. Then nine have errors. Let's be circumspect and suppose that each has only one error and that it is spotted within three months (wildly optimistic); then each error costs $165,000 on average.
So how much money is the Fortune 500 wasting annually? It is a simple sum: $165,000 times 9 times 500. That amounts to just shy of three quarters of a billion dollars. And is that anywhere near realistic? No. It is probably safe to say that corporate America, for example, loses in excess of $10bn annually through the misuse and abuse of spreadsheets. That's a big number: it suggests a problem worth managing."
El autor del artículo aporta también los resultados de su investigación y una serie de recomendaciones, en forma de White Paper - "Managing Spreadsheets" - para mejorar la utilización que se hace de una herramienta tan potente y peligrosa como el Excel, estándar de facto en este tipo de aplicaciones.
"The key point about spreadsheets is that you need to know which ones are critical to your business, which ones are merely important and which ones you do not have to bother too much about. Once you know that, you can start to apply appropriate policies depending on the criticality of the spreadsheet involved."
"According to both PricewaterhouseCoopers and KPMG, more than 90 per cent of corporate spreadsheets have material errors in them. Worse, estimates suggest that such errors costs between $10,000 and $100,000 per error per month. Let's take the Fortune 500 and let's suppose that each of these companies has just 10 (a pitifully small number) spreadsheets of corporate significance. Then nine have errors. Let's be circumspect and suppose that each has only one error and that it is spotted within three months (wildly optimistic); then each error costs $165,000 on average.
So how much money is the Fortune 500 wasting annually? It is a simple sum: $165,000 times 9 times 500. That amounts to just shy of three quarters of a billion dollars. And is that anywhere near realistic? No. It is probably safe to say that corporate America, for example, loses in excess of $10bn annually through the misuse and abuse of spreadsheets. That's a big number: it suggests a problem worth managing."
El autor del artículo aporta también los resultados de su investigación y una serie de recomendaciones, en forma de White Paper - "Managing Spreadsheets" - para mejorar la utilización que se hace de una herramienta tan potente y peligrosa como el Excel, estándar de facto en este tipo de aplicaciones.
"The key point about spreadsheets is that you need to know which ones are critical to your business, which ones are merely important and which ones you do not have to bother too much about. Once you know that, you can start to apply appropriate policies depending on the criticality of the spreadsheet involved."
Technorati tags: management consultancy spreadsheet
No hay comentarios:
Publicar un comentario