{"id":6801,"date":"2022-03-02T09:06:35","date_gmt":"2022-03-02T09:06:35","guid":{"rendered":"https:\/\/btqlulj0.myraidbox.de\/?p=6801"},"modified":"2024-04-04T10:01:20","modified_gmt":"2024-04-04T09:01:20","slug":"system-supported-personnel-planning","status":"publish","type":"post","link":"https:\/\/bdg.io\/uk\/system-supported-personnel-planning\/","title":{"rendered":"System-supported personnel planning"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Why I recommend system-supported personnel planning<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

By Ina Schwarzenberg<\/em><\/p>

Personal Profile\u00a0<\/strong><\/p>

Ina Schwarzenberg, our specialist for people analytics and BI tools, has been working in the field of financial and HR planning for almost 20 years. As Head of Development, Ina is responsible for and develops the Line of Business HR at bdg.<\/p><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

The wrong tool for a big job<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Excel is certainly a great office tool that hardly any company can do without to collect and structure data. But is it also suitable as a human resource planning tool?<\/p>

I say no \u2013 because I know what BI tools do for personnel planning and data security compared to Excel. And that’s what I’ll explain to you below!<\/p>

By the way, if the keyword Business Intelligence immediately makes you think: “But that must be a lot of effort”, let me already reveal at this point: With the right software and the right implementation partner, you will only need a few weeks for the introduction!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t

Why Excel is not particularly well suited for human resource planning<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

A company I worked for \u2013 let’s call it XYZ GmbH – had introduced a holistic budgeting process. So apart from turnover, the biggest cost block had to be planned: personnel costs.<\/p>

In the first year, XYZ had roughly estimated the personnel costs based on the actual costs of the previous year and the turnover expectations of the next year. But this method quickly turned out to be unreliable. No wonder \u2013 personnel movements are insanely complex!<\/p>

The company decided to plan personnel costs in more detail in order to better understand and explain deviations from the plan later.<\/p>

For this purpose, the personnel cost planning was first prepared centrally with the human resources department. All information \u2013 about existing employees, future departures and new additions \u2013 was obtained from a multitude of Excel files. Then the corresponding FTEs and costs were collected and prepared.<\/p>

Only in this way could XYZ GmbH painstakingly and only approximately determine the starting point \u2013 i.e. the baseline \u2013 for the planning of the coming year.<\/p>

The whole thing was then made available to the cost centre managers in a separate Excel file for planning.<\/p>

You guessed it, maybe you know it too: The preparation of the central and decentralised Excel files took forever \u2013 and faulty formulas were found again and again. Sometimes planners had accidentally corrupted files, so that they had to be repaired during the current planning process. If fixed planning parameters were changed during operation, “the big Excel adjustment” started all over again … Last but not least, those responsible had to consolidate the almost endless files in a time-consuming process in order to be able to evaluate them and present them to the management.<\/p>

And it went even further: the management decided on some planning changes that had to be incorporated into the Excel spreadsheets in order to transparently feed them back to the departments. In addition, the finance department was informed so that they could adjust and finalise the P&L.<\/p>

By the way: this consolidation was also needed for reporting \u2013 because the entire planning was checked against the actual figures during the year. If the planned costs differed from the actual costs, then the big manual search for answers in the Excel files started …<\/p>

Are you close to tears yet? I could go on forever listing other disadvantages that XYZ GmbH had when using Excel for personnel planning … And many companies feel the same way!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"Systemgest\u00fctzte\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

The better decision: an intelligent cloud solution<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

The good news: for a few years now, there have been fantastic system-based solutions that make the personnel planning process much more efficient. That’s exactly the kind of cloud solution I introduced at XYZ GmbH back then.<\/p>

And you can do that too \u2013 for example, with the bdg | HR Suite in SAP Analytics Cloud, Jedox or Board!<\/p>

The bdg | HR Suite offers you unbeatable advantages \u2013 precisely tailored in one solution:<\/p>