
Many spend analysis systems capture data only after the money is gone. Honeywell’s OneSource,
by contrast, is like an expanding universe, covering both backward- and forward looking spend data.
It gives the company’s commodity managers a way to spot strategic sourcing and spend
management opportunities in real time. Powered by an i2 Technologies SRM, Strategic Sourcing
platform, OneSource automatically gathers procurement data from 107 (eventually 152) Honeywell
locations. Data available for analysis and decision supports span two previous years plus the current
year. Each site provides six discrete data feeds: open purchase orders, receipts, rejects, unplaced
demand or forecast (demand from MRP system but not yet purchased), supplier master, and
accounts payable spend, including off-purchase order MRO spend. The seventh and eighth data
feeds capture contract manufacture bill of materials (part list) and component part approved vendor
list for businesses doing subcontract spend analysis.
OneSource is technology agnostic, meaning Honeywell’s business units do not need to change the
way they capture and store their spend data. “Data in a specified format is taken from the systems
the site has—from Excel spreadsheets to a vast array of ERP and MRP systems, including Avalon,
BPICS, Cullinet, JD Edwards, MacPac, Oracle, SAP as well as some home-grown versions,” says
Dennis Lemon, corporate director of supplier quality and health management. That is important for a
diversified company like Honeywell, where procurement is decentralised.
Data classification and cleansing is done as part of project rollout and continues using data
maintenance applications administered by designated sites or business resources. “As deployment
has continued,” Lemon says, “data cleansing has identified up to 25% overlap with other sites as
new sites are added. Global supplier rationalisation has allowed Honeywell to realize supply base
reductions in the 40–50% range.”
Page 3 of 4
Typically, according to Lemon, it takes about three months to bring a new site on board with
OneSource. A key factor has been the development of a formal process for doing this. “We use a
defined process that specifies who we work with and how. We involve their sourcing, IT, and quality
people. We help them create data feeds, test, and validate their data, and we train them to use the
system. We really nurture them as they begin to use OneSource.”
Source: Monczka, Handfield, Giunipero and Patterson. (2015: 45)
Questions:
1, Assess the influence of systems analysis in the purchasing process.
2.Evaluate the role of

Step by stepSolved in 2 steps

- What is the importance of data modeling in the context of data warehousing, and how does it impact the design of a data warehouse?arrow_forwardTip Top Toys is a relatively small division of Worldwide Enterprises. Worldwide has nine other divisions, which include insurance, health-care products, and financial planning services, to name a few. The corporate marketing director for Worldwide has requested Tip Top’s customer shopping data to target people who might be likely to purchase items or services from other Worldwide divisions. The database manager is not totally comfortable with this and pointed out Tip Top’s web privacy policy, which states “Tip Top Toys, a division of Worldwide Enterprises, will not share personal data with other companies without a customer’s consent.” The marketing director replied that the statement only applies to outside companies— not other Worldwide divisions. He said he checked with the corporate legal department, and they agreed. The database manager replied, “Even if it is legally OK, it’s not the right thing to do. Many people take our statement to mean that their data does not leave Tip Top.…arrow_forwardTip Top Toys is a relatively small division of Worldwide Enterprises. Worldwide has nine other divisions, which include insurance, health-care products, and financial planning services, to name a few. The corporate marketing director for Worldwide has requested Tip Top’s customer shopping data to target people who might be likely to purchase items or services from other Worldwide divisions. The database manager is not totally comfortable with this and pointed out Tip Top’s web privacy policy, which states “Tip Top Toys, a division of Worldwide Enterprises, will not share personal data with other companies without a customer’s consent.” The marketing director replied that the statement only applies to outside companies— not other Worldwide divisions. He said he checked with the corporate legal department, and they agreed. The database manager replied, “Even if it is legally OK, it’s not the right thing to do. Many people take our statement to mean that their data does not leave Tip Top.…arrow_forward
- Explain the role of data warehouses in business intelligence and analytics. Provide an example of a data warehousing implementation.arrow_forwardA light bulb manufacturer uses descriptive analytics _____. A. to present supply chain to managers visually. B. to achieve efficiency in delivery of goods. C. to schedule staff and vehicle for delivery. D. to plan capacity utilization by incorporating the inherent uncertainty in commodities pricing.arrow_forwardWhat are the ethical issues, as identified with the Markkula Center Framework for Ethical Decision related links, in the strategy of Dollar General Download Dollar Generalas depicted in this article? DG may have "hit a gold mine in rural America," but at what ethical cost? This is not merely your personal opinion but an opinion informed by the detailed and contradictory ethical analysis the Markkula app provides. Between Tuesday and Wednesday (11:59 pm) post your detailed analysis based on Markkula for all to see. Wednesday.-Friday, compare and contrast the work of others in the class, and seek to synthesize overall ethical ideas.arrow_forward
- Could you please help me with these.arrow_forwardwhy are research methods and desing methods important? are there any disadvantages to using either? Which is a better option and why?arrow_forward1. Review the provided CRM data to guide you in selecting the buying firm that will maximize revenue for DataLocker. Once you have analyzed the CRM data, select the appropriate industry that will maximize revenue for DataLocker: Small Size Manufacturing Small Size Hospitality Small Size Services Medium Size Manufacturing Medium Size Hospitality Medium Size Services Large Size Manufacturing Large Size Hospitality Large Size Servicesarrow_forward
- Show complete solutions no need guidelines answers no chat gpt answers okarrow_forwardRead the statements below and identify which type of analytics each statement requires. (Descriptive Analytics /Predictive Analytics/ Prescriptive Analytics) Decision Descriptive Analytics /Predictive Analytics/ Prescriptive Analytics Which candidate will win the election? What price for a product will maximize profit? How much money do I need to save each year to have enough money for retirement? How many products were sold last year? What is the best route for the delivery person to drop off packages to minimize the time needed to deliver all the packages? How many customers do we have and where are they located?arrow_forwardI need a SWOT examination of this data.arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.





