Founded in 1859 in Liverpool as a sugar refiner, today Tate & Lyle is a global provider of specialty food and other ingredients to four markets: food and beverage manufacturers (sweeteners, texturants, and fiber), the paper manufacturers (starches), animal feed producers (corn meal), and cosmetic manufacturers (cosmetics and creams). It operates over 30 manufacturing facilities in four regions: the Americas, Europe, the Middle East, and Africa. Throughout its history Tate & Lyle grew through acquisitions of many companies in its operating regions, and in the 1970s began to diversify from the sugar business to more specialized agricultural food products. In 2016 the company had €2.6 billion in sales and €189 million in profits. Tate & Lyle’s 2020 strategic plan is to expand the specialty food segment, broaden the geographic mix of sales to include Asia Pacific and Latin America, and generate over €200 million in sales from new products. As a multinational agribusiness, the firm faces stiff competition from giant global competitors like ConAgra, Archer Daniels Midland, and BASF.   In the process of growing over many decades, Tate & Lyle had gathered a large collection of financial accounting systems across four regions and thirty operating facilities. The accounts produced by all these financial systems were reconciled through manual means, using spreadsheets produced by individual units, telephone calls, paper records, fax, and emails to clarify disparities. Each region had its own manual processes for reconciling accounts. Reconciliation refers to the business processes used by firms to ensure that recorded expenditures and revenues are accurately reflected in cash outflow and income statements. The existing manual system stored records in different locations around the globe, which led to errors and made it difficult to produce monthly and annual financial statements. Senior managers understood that the firm could not achieve its business strategic objectives without a major re-thinking of its basic financial accounting systems.   The solution management decided on was to centralize financial accounting at a single location in Lodz, Poland, and to develop an Account Reconciliation and Task Management system. This new system is based on SAP’s ERP (Enterprise Resource Planning) system, which brings together thousands of general ledger accounts and transactions located the four regions into a single system. SAP’s ERP utilizes their HANA relational database software, which stores and retrieves data, and provides many other enterprise capabilities, including predictive analytics, management dashboards, and text search. The consulting firm Black Line was hired to implement the new system and coordinate with Tate & Lyle financial groups. Implementing the system required two years of intensive planning and the integration of legacy systems into the new single system. The major requirements for the new system included standardized templates, electronic approval of workflows, an easy-to-use interface so managers could quickly obtain the information on firm performance that they needed, as well as the ability to handle multiple currencies,  produce basic reports in a timely fashion, and integrate data in the SAP system with non-SAP accounting systems already in use at the regional level.   Implementing the new system also gave managers the opportunity to revise and simplify business processes based on industry best practices, and to enforce their use across all the four regions. The result is a reconciliation system that is accurate, timely, transparent, and able to produce end-of-day results, report on progress towards month-end closing targets, identify outstanding tasks, and communicate with the teams responsible for completing the tasks.   Draw use case diagrams and activity diagrams for the Tate & Lyle described in the above scenario. Propose the hardware and software required to meet the needs of your business.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Founded in 1859 in Liverpool as a sugar refiner, today Tate & Lyle is a global provider of specialty food and other ingredients to four markets: food and beverage manufacturers (sweeteners, texturants, and fiber), the paper manufacturers (starches), animal feed producers (corn meal), and cosmetic manufacturers (cosmetics and creams). It operates over 30 manufacturing facilities in four regions: the Americas, Europe, the Middle East, and Africa. Throughout its history Tate & Lyle grew through acquisitions of many companies in its operating regions, and in the 1970s began to diversify from the sugar business to more specialized agricultural food products. In 2016 the company had €2.6 billion in sales and €189 million in profits. Tate & Lyle’s 2020 strategic plan is to expand the specialty food segment, broaden the geographic mix of sales to include Asia Pacific and Latin America, and generate over €200 million in sales from new products. As a multinational agribusiness, the firm faces stiff competition from giant global competitors like ConAgra, Archer Daniels Midland, and BASF.

 

In the process of growing over many decades, Tate & Lyle had gathered a large collection of financial accounting systems across four regions and thirty operating facilities. The accounts produced by all these financial systems were reconciled through manual means, using spreadsheets produced by individual units, telephone calls, paper records, fax, and emails to clarify disparities. Each region had its own manual processes for reconciling accounts. Reconciliation refers to the business processes used by firms to ensure that recorded expenditures and revenues are accurately reflected in cash outflow and income statements. The existing manual system stored records in different locations around the globe, which led to errors and made it difficult to produce monthly and annual financial statements. Senior managers understood that the firm could not achieve its business strategic objectives without a major re-thinking of its basic financial accounting systems.

 

The solution management decided on was to centralize financial accounting at a single location in Lodz, Poland, and to develop an Account Reconciliation and Task Management system. This new system is based on SAP’s ERP (Enterprise Resource Planning) system, which brings together thousands of general ledger accounts and transactions located the four regions into a single system. SAP’s ERP utilizes their HANA relational database software, which stores and retrieves data, and provides many other enterprise capabilities, including predictive analytics, management dashboards, and text search.

The consulting firm Black Line was hired to implement the new system and coordinate with Tate & Lyle financial groups. Implementing the system required two years of intensive planning and the integration of legacy systems into the new single system. The major requirements for the new system included standardized templates, electronic approval of workflows, an easy-to-use interface so managers could quickly obtain the information on firm performance that they needed, as well as the ability to handle multiple currencies,  produce basic reports in a timely fashion, and integrate data in the SAP system with non-SAP accounting systems already in use at the regional level.

 

Implementing the new system also gave managers the opportunity to revise and simplify business processes based on industry best practices, and to enforce their use across all the four regions. The result is a reconciliation system that is accurate, timely, transparent, and able to produce end-of-day results, report on progress towards month-end closing targets, identify outstanding tasks, and communicate with the teams responsible for completing the tasks.

 

Draw use case diagrams and activity diagrams for the Tate & Lyle described in the above scenario.

Propose the hardware and software required to meet the needs of your business.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 3 images

Blurred answer
Knowledge Booster
Analysis of Performance Measurement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education