信息系統(tǒng)管理小組討論.ppt

1、1-1 2020/10/5,CASE 1 ASSESSING THE VALUE OF INFORMATION 信息評價 Trevor Toy Auto Mechanics,1-2 2020/10/5,Presentation Overview,THE ISSUE Trevor Toy Auto Mechanics has grown substantially over the past few years. Based on various pieces of information, students are asked to help Trevor decide if he shoul

2、d just focus on certain types of repairs, focus on certain types of automobiles, keep only certain mechanics, or perhaps just keep on doing what hes doing. THE TECHNOLOGY Spreadsheet software and a spreadsheet file, TREVOR.xls, that contains 6 columns of information and 750 transactions.,1-3 2020/10

3、/5,AVAILABLE INFORMATION（可用信息） Repair information on cars, mechanics, and type of repair. MECHANIC # - a unique number assigned to the mechanic who completed the work CAR TYPE - the type of car on which the work was completed WORK COMPLETED what type of repair was performed on the car NUM HOURS - ho

4、w long in hours it took to complete the work COST OF PARTS - the cost of the parts associated with completing the repair TOTAL CHARGE - the amount charged to the customer for the repair,1-4 2020/10/5,TREVOR.xls 數(shù)據(jù),1-5 2020/10/5,A PRE-ANALYSIS OF THE INFORMATION （信息分析產(chǎn)生派生數(shù)據(jù)） 1.NET REVENUE PER REPAIR

5、- TOTAL CHARGE minus COST OF PARTS 2.NET REVENUE PER HOUR PER REPAIR (TOTAL CHARGE minus COST OF PARTS) divided by NUM HOURS,1-6 2020/10/5,Derived new data（派生數(shù)據(jù)）,=TOTAL CHARGE - COST OF PARTS,=NET REVENUE PER REPAIR /NUM HOURS,1-7 2020/10/5,數(shù)據(jù)透視表,1-8 2020/10/5,各汽車各部件的平均利潤,1-9 2020/10/5,1-10 2020/10/5,1-11 2020/10/5,1、按技工的利潤貢獻(xiàn)，4號技工的貢獻(xiàn)最大。 2、BMW,GE的引擎，所有汽車的輪胎，BMW和奔馳的剎車的利潤相對較大。,