Transaction Processing systems TPSI A symbolic representation for a payroll TPS Employee data(various departments) To general ledger: wages and salaries Payroll system 回 Government documents Data elements in Employee checks payroll master file Address Department Payroll Occupation Pay rate queries: Employee Employee Gross Federal State FICA Earnings Vacation time ngs number name (year to date) Gross pay 46848 Stoker,K.2000.00400.0050.00140.006000.00 (year to date) Withholdings Federal income tax State tax FICA
HUANG Lihua, Fudan University Feb., - July., 2006 Transaction Processing Systems (TPS) • A symbolic representation for a payroll TPS
Typical applications of TPs TYPE OF TPS SYSTEM Sales/ Manufacturing/ Finance/ Human Other types marketing roduction accounting resources (e.g, university) systems systems systems systems Major functions Customer service Scheduling General ledger Personnel records Admissions of system Sales management Purchasing Benefits Grade records Promotion tracking Shipping/receiving Cost accounting Compensation Course records Price changes erations Labor relations Alumni records Dealer Training communications Major Sales order Machine control General ledger Employee records Registration system application information systems system: Sales commission Purchase order Benefit systems Student transcript Accounts syste systems receivable/ payable system Sales support Quality control Employee skills Curriculum class system systems Funds managementinventory control system systems Alumni benefactor system
HUANG Lihua, Fudan University Feb., - July., 2006 Typical applications of TPS
(Management Information Systems (MIS) Serve management level; provide reports and access to company data Input: Summary transaction data, high-volume data, simple models Processing: Routine reports, simple models, low-level analysis Output: Summary and exception reports Users: Middle managers
HUANG Lihua, Fudan University Feb., - July., 2006 Management Information Systems (MIS) • Serve management level; provide reports and access to company data – Input: Summary transaction data, high-volume data, simple models – Processing: Routine reports, simple models, low-level analysis – Output: Summary and exception reports – Users: Middle managers
Cow management information systems obtain their data from the organization's TPs Transaction Processing Systems Management Information Systems Order Order MIS FILES file processing sy stem Sales dat Materials Production resource Unit master file planning pro system cost data MIS Product R General Accounting file ledge system Expens
HUANG Lihua, Fudan University Feb., - July., 2006 How management information systems obtain their data from the organization’s TPS
O A Sample report that might be Produced by the mis Consolidated Consumer Products Corporation Sales by Product and Sales Region: 2004 PRODUCTPRODUCT SALES ACTUAL PLANNED ACTUAL VS CODE DESCRIPTION REGION SALES PLANNED 4469 Carpet Cleaner Northeast 4066,700 4800000 0.85 South 3,778,2 3,750.000 1.0 Midwest 4.867,001 4,600000 1.06 West 4,003,440 4,400,000 0.9 TOTAL 16,715,253 17,550.000 0.95 5674 Room Freshener Northeast 3676,700 3,900,000 0.94 South 5.608,112 4,700.000 1.19 Midwest 4,71,ool 4,200000 1.12 West 4563,440 4,900,000 0.93 TOTAL 18.559253 17,700,000 1.05
HUANG Lihua, Fudan University Feb., - July., 2006 A Sample Report that Might be Produced by the MIS