Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
In this chapter, students will be able to understand: Why is integration of data important in business? How do enterprise resource planning systems make businesses run better through integration of data? How do workgroup tools improve business integration? Why are data warehouses important in integrating data? How does the Internet help integrate data on different types of systems? How can a group decision support system help managers achieve a consensus? | Introduction to MIS Chapter 7 Integration of Information Integration Everyone in the company including managers, salespeople, and engineers need access to the same data across the organization. Outline Business Integration Enterprise Resource Planning Customer Relationship Management Workgroups Data Warehouses Integration with Diversity Cases: Automobiles Appendix: Microsoft NetMeeting Business Integration Example Daily Sales Report February 7, 2004 Department Item# Q-sold Price Value House 1153 52 2.95 153.40 5543 13 0.59 7.67 W.Clothing 5563 1 87.32 87.32 7765 4 54.89 219.56 9986 2 15.69 31.38 Shoes 1553 2 65.79 131.58 6673 1 29.39 29.39 Total Sales: 660.30 Returned Merchandise Log February 7, 2004 Item# Q Price Value 1153 3 2.95 8.85 3353 6 27.59 165.54 4453 2 15.95 31.90 8878 1 24.95 24.95 Total 12 231.24 Commissions February 7, 2004 Emp# Name Dept Sales Rate Amount 1143 Jones House 543.95 5% 27.20 2895 Brown M.Clothing 775.35 4% 31.01 4462 Smith W.Clothing 1,544.52 5% 77.23 7893 Torrez Shoes 876.93 6% 52.62 9963 Cousco M.Clothing 589.47 5% 29.47 File: C07E06.xls File: DeptStore2000.mdb Integrated Report Example Weekly Sales Analysis 2/01/04 - 2/07/04 Manager comments are written in the first ten pages, along with comments on special events. Department Analysis Dept Sales Returns Commissions Net House 4,113.58 25.35 205.68 3,882.55 W.Clothing 54,221.92 998.52 3,024.64 50,198.76 M.Clothing 28,664.48 356.24 1,421.58 26,886.66 Shoes 10,225.31 853.47 592.36 8,779.48 Total: 97,225.29 2,233.58 5,244.26 89,747.45 1960s & 1970s MIS Pieces Purchasing: Orders Sales: Orders Production: MRP Marketing: Forecasts Accounting: Integrated Data Separate Reports Changes sales data 3 reports (printed) weekly reports 1970s Sales Terminals Sales Terminals Central computer: create reports Manager: Integrate, graph analyze Secretary: type & revise Management sales data 3 reports (printed) weekly reports 1980s Sales Terminals Sales Terminals Central computer: create reports Manager: . | Introduction to MIS Chapter 7 Integration of Information Integration Everyone in the company including managers, salespeople, and engineers need access to the same data across the organization. Outline Business Integration Enterprise Resource Planning Customer Relationship Management Workgroups Data Warehouses Integration with Diversity Cases: Automobiles Appendix: Microsoft NetMeeting Business Integration Example Daily Sales Report February 7, 2004 Department Item# Q-sold Price Value House 1153 52 2.95 153.40 5543 13 0.59 7.67 W.Clothing 5563 1 87.32 87.32 7765 4 54.89 219.56 9986 2 15.69 31.38 Shoes 1553 2 65.79 131.58 6673 1 29.39 29.39 Total Sales: 660.30 Returned Merchandise Log February 7, 2004 Item# Q Price Value 1153 3 2.95 8.85 3353 6 27.59 165.54 4453 2 15.95 31.90 8878 1 24.95 24.95 Total 12 231.24 Commissions February 7, 2004 Emp# Name Dept Sales Rate Amount 1143 Jones House 543.95 5% 27.20 2895 Brown M.Clothing 775.35 4% 31.01 4462 Smith W.Clothing 1,544.52 5% 77.23 7893