Snyder’s of Hanover, which sells about 80 million bags of pretzels, snack chips, and organic snack items each year, had its financial department use spreadsheets and manual processes for much of its data gathering and reporting. Hanover’s financial analyst would spend the entire final week of every month collecting spreadsheets from the heads of more than 50 departments worldwide. She would then consolidate and reenter all the data into another spreadsheet, which would serve as the company’s monthly profit-and-loss statement. If a department needed to update its data after submitting the spreadsheet to the main office, the analyst had to return the original spreadsheet and wait for the department to resubmit its data before finally submitting the updated data in the consolidated document. Assess the impact of this situation/problem on business performance and management decision-making. What are the choices of solutions? Which one is the net fit for this problem?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Snyder’s of Hanover, which sells about 80 million bags of pretzels, snack chips, and organic snack items each year, had its financial department use spreadsheets and manual processes for much of its data gathering and reporting. Hanover’s financial analyst would spend the entire final week of every month collecting spreadsheets from the heads of more than 50 departments worldwide. She would then consolidate and reenter all the data into another spreadsheet, which would serve as the company’s monthly profit-and-loss statement. If a department needed to update its data after submitting the spreadsheet to the main office, the analyst had to return the original spreadsheet and wait for the department to resubmit its data before finally submitting the updated data in the consolidated document. Assess the impact of this situation/problem on business performance and management decision-making. What are the choices of solutions? Which one is the net fit for this problem?

Expert Solution
Step 1

Repeatedly inputting and processing data at a large corporation like Snyders is a source of worry. The contemporary world thinks that gathering data and extracting useful information from it may provide businesses with a competitive edge in the marketplace. Snyders, with fifty divisions dispersed around the globe, must collect a large quantity of data, which must be integrated in order to provide helpful information for the firm. Manually handling such a large amount of data and then processing it without mistakes would take a lot of time and patience. Companies now lose and gain market share on a daily basis, and in order to maintain a competitive advantage, they must keep themselves up to date. Snyders' company performance will undoubtedly be harmed as a result of this operation since data will take time to reach the analyst from various departments in many locations; someone may submit it on time, while someone else may send it three days late, but the analyst will have to wait. It's also possible that the data received from various departments contain errors or omissions that must be corrected before being sent to the analyst. All of this will cause a delay in data processing, and by the time the analyst produces the results, the company may be in a disadvantageous position. If a company's management receives late information, it will be unable to make quick decisions on the adjustments or strategies that need to be implemented, and so opportunities may be lost, severely impacting corporate performance.

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.