信息系统管理小组讨论.ppt

CASE 1 ASSESSING THE VALUE OF INFORMATION 信息评价 Trevor Toy Auto Mechanics 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 should just focus on certain types of repairs, focus on certain types of automobiles, keep only certain mechanics, or perhaps just keep on doing what he’s doing. THE TECHNOLOGY Spreadsheet software and a spreadsheet file, TREVOR.xls, that contains 6 columns of information and 750 transactions. 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 - how 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 TREVOR.xls 数据 A PRE-ANALYSIS OF THE INFORMATION （信息分析产生派生数据） ????? 1.NET REVENUE PER REPAIR - TOTAL CHARGE minus COST OF PARTS 2.NET REVENUE PER HOUR PER REPAIR – (TOTAL CHARGE minus COST OF PARTS) divided by NUM HOURS Derived new data（派生数据） 管经院 课程：信息时代的管理信息系统 * =TOTAL CHARGE - COST OF PARTS =NET REVENUE PER REPAIR /NUM HOURS 数据透视表 各汽车各部件的平均利润