Jeremy Preston-Hoar
PRINCIPAL CONSULTANT
Jeremy is CIBER UK's Principal Consultant for the Enterprise Performance Management product suite, specialising in SAP BusinessObjects reporting tools and SAP Business Planning and Consolidation (SAP BPC). Jeremy has a number of years experience in SAP implementation and support, and was previously an architect and consultant in SAP Finance and Controlling solutions. His specialist industry expertise includes Engineering, High-Tech Manufacturing and Media sectors. A qualified member of the Chartered Institute of Management Accountants (CIMA), Jeremy has 10 years management accounting experience in a variety of roles including Project Accountant, Group Management Accountant and Financial Controller in the manufacturing and engineering services sectors.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Posts by this author
How painful was that? / Looking forward to your next planning round?
Jeremy Preston-Hoar, Principal Consultant : 24 January 2012 / 1:24 PM : 0 
So, those of you whose year end is December will have probably spent the last few months of 2011 pulling the annual budget, forecast or plan together. Whatever you call it, it would have probably been a monumental effort, undertaken by many participants. Those, who have year-ends coming up in the first half of 2012, will probably be making preparations for, or be in the middle of a planning round.
Those of you using Microsoft Excel as a method for modelling, collecting data, and consolidating plan data may also have spent many hours tweaking your models, adding new cost headings, adding new cost centres, and all that other maintenance that requires careful con...
Posted in CIBER UK on 24 January 2012
Tagged: SAP BPC
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
How do you build an integrated planning model with good process flows?
Jeremy Preston-Hoar, Principal Consultant : 23 June 2011 / 10:14 AM : 0
How many times have you heard the question “has the cost centre completed their departmental headcount forecast and have these changes been reflected in corresponding centres?” or equally, “why has one department updated the departmental spend forecast, but not updated the capex forecast?”
Using SAP Business Planning and Consolidation (BPC) some of these questions could become obsolete.
A good planning round relies on:
SAP Bus...
Posted in CIBER UK on 23 June 2011
Tagged: BI Business Intelligence Consolidation performance management Process Improvement SAP BPC SAP BusinessObjects BPC
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Does your planning model seem a little flat?
Jeremy Preston-Hoar, Principal Consultant : 14 April 2011 / 1:46 AM : 0
In this second of a short series of blogs about planning and SAP Business Planning and Consolidation (SAP BPC), I want to challenge readers to think about the depth of their planning models.
Planning models often focus on particular areas, typically overheads in the first instance. Effort is then spent building complex overhead planning models which often result in complex, large Excel files. These models will typically have monthly based input schedules with lines for each cost account, but in the interests of not adding any more complexity, some of the more detailed relationships to drive lines such as salary, costs to employ, or depreciation are left...
Posted in CIBER UK on 14 April 2011
Tagged: Business Intelligence Business Modeling Consolidation SAP BPC SAP BusinessObjects BPC
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Are you descending into spreadsheet hell during the planning round?
Jeremy Preston-Hoar, Principal Consultant : 11 March 2011 / 9:32 AM : 0
I've seen it over and over again in the time I've been an SAP consultant in Finance, and prior to that as an Accountant; businesses have complex planning models engineered by a select team of individuals built in Excel or other spreadsheet applications. These models underpin the future strategic direction of the business, may be responsible for critical decisions, and form the basis of guidance given to investors. However, how many people take time out to consider the implications of these models and critically appraise the points of failures in these models.
These points of failure could include:
Posted in CIBER UK on 11 March 2011
Tagged: Business Intelligence SAP BPC SAP BusinessObjects BPC
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .