80 likes | 104 Views
Enterprise Applications. MGMT 661 – Summer 2012 Night #6, Part 1. Enterprise Applications. Definition Integrated suite of applications based on information from different divisions of the corporation. Customer Management. Supply Chain Planning. Central DB. Sales DB. Production DB.
E N D
Enterprise Applications MGMT 661 – Summer 2012 Night #6, Part 1
Enterprise Applications • Definition • Integrated suite of applications based on information from different divisions of the corporation Customer Management Supply Chain Planning Central DB Sales DB Production DB Accounting DB
Advantages • Better information about operation of the business • increased operational efficiency • broad scope of information • shared data, real-time data • Enforce Standard Practices throughout the company
Problems • Complex to Design and Operate • several years to fully implement • not always successful • Usually sold as a large package that is slightly customizable • one size (not always) fits all • extensive modification problems: • makes maintenance a nightmare • degrades performance • possibly compromises data integrity • Very likely will require adjustment of business processes
Refresher on Supply Chain Management textbook Figure 9-2
Supply Chain Info Systems • Purpose: • better at knowing “how many” and “when” • essential for just-in-time • reduce uncertainty about supply and demand • reduce costs via less safety stock • make what we sell • Types: • Execution Systems • track physical status (warehouse, transportation, financial) • automatic replenishment based on orders • Planning Systems • model existing chain • optimal sourcing plans based on forecasted demand
Customer Relationship Info Systems • Purpose • make your customers feel special • integrate info across your departments • Benefits and Features • improved customer service • who they are (contact info, amount of sales, etc) • accurate info decreases call duration • service planning • improved sales • past purchases can help personalize recommendations • supports direct marketing • identify profitable and unprofitable customers • Types • Operational and Analytical textbook section 9.3
Exercise • see Customer Service Request database problem on page 364 • maintenance company • has one database table with customer contact info • service orders are hand-processed • Design a new database table to automate the recording of requests. • Describe how to prioritize requests? • Other possible reports?