-
SOFTWARE
SOFTWARESAP HCM & PayrollQuery Manager Query Manager Add-ons Document Builder Variance Monitor DSM for HCM HCM Productivity Suite FLOW GeoClockSAP Landscape & Test Data ManagementData Sync Manager (DSM) suite - System Builder/Shell Sync - Object Sync - Client Sync - Data Secure Archive CentralSupport & TrainingClient Central E-learning & trainingSAP Data Privacy & SecurityData Privacy suite - Data Secure - Data Disclose - Data Redact - Data Retain Soterion (GRC)
-
SERVICES
SERVICESSAP HCM & PayrollPRISM for HR & Payroll SAP SuccessFactors Integration monitoring Payroll reporting Report writingClient-specific DevelopmentCustom development SAP BTPSAP Landscape & Test Data ManagementPRISM Migrations to S/4HANA System Landscape Optimization (SLO) Managed data refresh servicesSAP Data Privacy & SecuritySAP data privacy assessment serviceMass data removal services Data privacy consultingCloud and Application Managed ServicesFunctional AMS Cloud management services Cloud migrations Basis managed services Private cloud hosting SAP on AWS SAP on Azure Premium Support Services RISE BRIDGE Managed Services
- All Solutions
- Request Estimate
-
Resources
Resources Blogs Read the latest updates on SAP SLO, SAP HCM, Data & Privacy, and Cloud Webinars Access expert insights in live and recorded webinars Video library Watch videos and improve your SAP knowledge
- About
Warburtons SAP HCM reports: Query Manager is the best thing since sliced bread
WARBURTONS AT A GLANCE
Warburtons was founded in 1876 by Thomas and Ellen Warburton and is still a privately-owned, family-run business actively managed by the fifth generation of Warburtons. It is the largest baker in the UK with 12 bakeries, 13 depots and 4500 employees serving 18,500 retail customers every week.
Warburtons produces more than a quarter of all bakery products consumed in the UK and has doubled in size in the last decade alone to become a £500 million-a-year operation.
- 4,500 employees
- Run two payrolls: weekly and monthly
- SAP HCM go-live was 2002
- Upgraded to ECC 6.0 EhP2 in early 2007
- Modules: FI/CO, SD, MM, PM, HR, PY, QM, PP, to relevant WM, SRM
WARBURTONS' CHALLENGE
Warburtons needed an easily deployable reporting solution that could quickly and securely access all SAP HCM information and distribute it securely to relevant management for action.
THE FULL STORY: WARBURTONS CHOSE QUERY MANAGER
Challenge - Inadequate SAP HCM reporting
SAP Ad Hoc Query and Wage Type Reporter, plus their custom reports, were not meeting Warburtons’ business demands. Reporting was manual, clumsy and inefficient. Too much time was taken getting, extracting and re-working the data. This was costly and high risk and lead to reliance on key technical personnel who had the skill to manipulate the reports. Key requirements, such as cross-module reporting across all SAP HCM data sources, could not be met.
Solution - Automated SAP HCM reporting
Using Query Manager to completely automate SAP HCM reporting, all the SAP HCM data can be accessed and many reporting combinations are possible across all data sources. Automation has had huge benefits with the scheduling and distribution of reports now taking only 10 minutes on the first day of every month.
Challenge - Excessive time wastage
The monthly manpower report showing employee headcount, FTE, salary and overtime on the same report, meant running two extracts (with Ad Hoc Query and Wage Type Reporter), joining the data on Excel, and then adding a calculation (FTE). Every time this information was needed, (over 80 times a year) it would take more than 2 hours to produce the report and distribute it. This meant over 160 hours per year running and manipulating a single report.
Solution - Manpower reporting, quick and easy
The manpower report now takes five minutes to run and send, as opposed to two hours previously. It took only 30 minutes to create and is run when needed. This report is adjusted all the time – fields are added, different overtime types included or car allowances are updated. Now it takes only two minutes to adjust and test and saves approximately 170 hours per year.
Challenge - Weekly payroll reconciliation
The weekly payroll reconciliation would take one hour per bakery per week. Two payroll extracts plus a master data extract would be combined and calculations run to confirm that gross-to-net actuals versus budgeted/planned amounts were in order. For twelve bakeries, this process took one and a half work days per week or over 620 hours per year.
Solution - Payroll Time savings
The payroll reconciliation report, run per bakery every week, took about two hours to write on Query Manager. It takes just half-an-hour per week to run across all twelve bakeries, saving over 592 hours a year on this report alone.
