Management Information Systems: Managing the Digital Firm 7th Edition

Managing the Digital Firm, Seventh Canadian Edition Appendix A Learning Track Modules The following Learning Track Modules are available for downloading by students from the Companion Website. The modules are also available for instructors on the Pearson Catalogue. Chapter 1 Information Systems in Business Today CH1 LT1 How Much Does IT Matter? CH1 LT2 Information Systems and Your

Managing the Digital Firm, Seventh Canadian Edition Appendix B Collaboration and Teamwork Projects The following Collaboration and Teamwork Projects are available for downloading by students from the Companion Website. Chapter 1 Creating a Web Site for Team Collaboration Chapter 2 Identifying Management Decisions and Systems Chapter 3 Identifying Opportunities for Strategic Information Systems Chapter 4 Developing a Corporate Code

Managing the Digital Firm, Seventh Canadian Edition Appendix C Hands-on Guide: How to Analyze a Case Study Management Information Systems by Laudon, Laudon, and Brabston provides a number of case studies for you to analyze. Included in these cases are questions to help you understand and analyze the case. You may, however, be assigned other case

Chapter 1 Hands-on MIS Application Software Exercise Solution This exercise helps students understand how a raw file of sales transactions can be analyzed using database software to produce valuable information for managers. The solutions provided here were created using the query wizard and report wizard capabilities of Access. Students can of course create more

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 1: Information Systems in Global Business Today Learning Track 1: How Much Does IT Matter? In May 2003, Nicholas Carr, an editor at Harvard Business Review, wrote an article titled “IT Doesn’t Matter,” which stirred significant debate in the

Chapter 1 Running Case Solution Description 1. What are the company goals and culture? Dirt Bikes appears to have a very democratic, employee-friendly culture, emphasizing ongoing learning, quality, attention to detail, and employee contributions. 2 What products and services does Dirt Bikes USA provide? How many types of products and services are available to customers?

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 1: Information Systems in Global Business Today Learning Track 2: Information Systems and Your Career Looking out to 2020, the U.S. economy will create 25 million new jobs, and 28.5 million existing jobs will open up as their occupants

Store & Region Sales Database ID Store No Sales Region Item No Item Description 1 1 South 2005 17" Monitor 2 1 South 2005 17" Monitor 3 1 South 2005 17" Monitor 4 1 South 3006 101 Keyboard 5 1 South 3006 101 Keyboard 6 1 South 3006 101 Keyboard 7 1 South 6050 PC Mouse 8 1 South 6050 PC Mouse 9 1 South 6050 PC Mouse 10 1 South 8500 Desktop CPU 11 1 South 8500 Desktop CPU 12 1 South 8500 Desktop CPU 13 2 South 2005

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 1: Information Systems in Global Business Today Learning Track 3: The Rise of Mobile Platform: M-commerce In a few years, the primary means of accessing the Internet both in the U.S. and worldwide will be through mobile devices like

ID Store No 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 1 10 1 11 1 12 1 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 23 2 24 2 25 3 26 3 27 3 28 3 29 3 30 3 31 3 32 3 33 3 34 3 35 3 36 3 37 4 38 4 39 4 40 4 41 4 42 4 43 4 44 4 45 4 46 4 Sales Region South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South North North North North North North North North North North Item No 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 8500 8500 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 8500 8500 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 8500 8500 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 Item Description 17" Monitor 17" Monitor 17" Monitor 101 Keyboard 101 Keyboard 101 Keyboard PC Mouse PC Mouse PC Mouse Desktop CPU Desktop CPU Desktop CPU 17" Monitor 17" Monitor 17" Monitor 101 Keyboard 101 Keyboard 101 Keyboard PC Mouse PC Mouse PC Mouse Desktop CPU Desktop CPU Desktop CPU 17" Monitor 17" Monitor 17" Monitor 101 Keyboard 101 Keyboard 101 Keyboard PC Mouse PC Mouse PC Mouse Desktop CPU Desktop CPU Desktop CPU 17" Monitor 17" Monitor 17" Monitor 101 Keyboard 101 Keyboard 101 Keyboard PC Mouse PC Mouse PC

Best Performing Stores by Total Sales Weekly Sales Store No $267,648.90 6 $170,040.85 7 $158,334.00 5 $91,435.05 8 $90,281.10 1 $90,051.25 3 $75,498.75 4 $54,262.70 2 Page 1 of 1 Best Selling Products by Quantity Item No Units Sold Item Description Unit Price Week Ending Weekly Sales 2005 85 17" Monitor $229.00 11/24/2012 $19,465.00 56 17" Monitor $229.00 12/29/2012 $12,824.00 38 17" Monitor $229.00 10/27/2012 $8,702.00 36 17" Monitor $229.00 11/24/2012 $8,244.00 35 17" Monitor $229.00 12/29/2012 $8,015.00 34 17" Monitor $229.00 10/27/2012 $7,786.00 30 17" Monitor $229.00 11/24/2012 $6,870.00 30 17" Monitor $229.00 11/24/2012 $6,870.00 28 17" Monitor $229.00 10/27/2012 $6,412.00 27 17" Monitor $229.00 10/27/2012 $6,183.00 25 17" Monitor $229.00 11/24/2012 $5,725.00 24 17" Monitor $229.00 10/27/2012 $5,496.00 23 17" Monitor $229.00 12/29/2012 $5,267.00 23 17" Monitor $229.00 12/29/2012 $5,267.00 20 17" Monitor $229.00 11/24/2012 $4,580.00 18 17" Monitor $229.00 10/27/2012 $4,122.00 18 17" Monitor $229.00 10/27/2012 $4,122.00 17 17" Monitor $229.00 11/24/2012 $3,893.00 10 17" Monitor $229.00 12/29/2012 $2,290.00 9 17" Monitor $229.00 12/29/2012 $2,061.00 8

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 1 Information Systems in Business Today LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. How are information systems transforming business, and what is their relationship to globalization? 2. Why are information systems so essential for running and managing a business today? 3. What

Chapter 1 Running Case Assignment: Understanding Information System Requirements Software skills: Presentation software Business skills: Management analysis and information system recommendations How do you know what information systems are really needed by a business and which are the most important? How should a company’s structure or culture affect the building and use of information systems? Dirt Bikes’s

Chapter 10 Hands-on MIS Application Software Solution Description Note that there are two solution files for this case: a spreadsheet solution file and a powerpoint solution file. Students’ solutions will vary, depending on the company they select and the time period over which it is analyzed. The files provided here are merely for purposes

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 10: E-Commerce: Digital Markets, Digital Goods Learning Track 2: Build an E-commerce Business Plan There are lots of different ways to lay out a business plan. The sample outline below is just one of many outlines. After the outline,

Chapter 10 Running Case Solution 1. How could Dirt Bikes benefit from e-commerce? Should it sell motorcycles or parts over the Web? Should it use its Web site primarily to advertise its products and services? Should it use the Web for customer service? Today using the Web can benefit most companies of any size,

MIS13 Chapter 10 Hands-on MIS Application Exercise Instructions Downloading the Data into a Spreadsheet Use the Convert Text to Columns Wizard in your spreadsheet software to arrange the 10K data you downloaded into spreadsheet columns and rows. From the Excel menu, select Data and then select the Text to Columns option. The software

Analyzing a Dot-Com Business Model Yahoo! Inc. [Student Name – Date] 1 Management Information Systems Revenue Outlook ⚫ ⚫ ⚫ 2 Gross revenue decreased 21% from 2010 12% increase in gross margin Declining prices for display ads continued to impact 2011 performance despite investments in social media and nextgeneration advertising. Management Information Systems Cost and Margin Outlook – over 3 Years ⚫ ⚫ 3 Approximately 43% decrease in cost of revenues from 2010

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 10: E-Commerce: Digital Markets, Digital Goods Learning Track 4: E-commerce Payment Systems For the most part, existing payment mechanisms have been able to be adapted to the online environment, albeit with some significant limitations that have led to efforts to

Balance Sheet - Yahoo! (in thousands) 2011 3,452,536 11,330,250 14,782,786 2010 4,345,548 10,582,556 14,928,104 2009 4,594,772 10,341,258 14,936,030 1,207,361 1,034,358 2,241,719 1,625,872 744,103 2,369,975 1,717,728 724,982 2,442,710 Stockholders' Equity 12,541,067 12,558,129 12,493,320 Total Liabilities & Stockholders' Equity 14,782,786 14,928,104 14,936,030 Current Assets Other Assets Total Assets Current Liabilities Non-current Liabilities Total Liabilities C:UsersYenDesktopchờ978-0133156843-SMHands On MIS App SolutionMIS13ch10_spshsolutionfile_03.xls Income Statement - Yahoo! (in Thousands) 2011 4,984,199 1,502,650 3,481,549 70% 2,681,208 800,341.00 27,175 827,516 241,767 (13,842) 1,048,827 21.04% Total Revenues Cost of Revenues Gross Profit Gross Margin Operating Expenses Operating Income (Loss) Other Income (Expense) Net Profit (Loss) (Income Taxes) Minority Interest Net Profit (Loss) after Taxes Net Margin 2010 6,324,651 2,627,545 3,697,106 58% 2,924,582 772,524.00 297,869.00 1,070,393 221,523 (12,965) 1,231,663 19.47% 2009 6,460,315 2,871,746 3,588,569 56% 3,201,877 386,692 187,528 574,220 219,321 (7,297) 597,992 9.26% Net Profit (Loss) after Taxes 1,400,000 1,200,000 1,000,000 800,000 Net Profit (Loss)

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 10: E-Commerce: Digital Markets, Digital Goods Learning Track 1: E-commerce Challenges: The Story of Online Groceries What could be easier than ordering all your groceries online and having them delivered to your doorstep at a time you choose? No more

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 10: E-Commerce: Digital Markets, Digital Goods Learning Track 3: Hot New Careers in E-commerce The Internet/e-commerce economy is hot again, and the prospects for employment in this rapidly expanding segment of the economy have never been better. In 2013,

Chapter 10 Running Case Assignment: Achieving Operational Excellence: Developing an E-Commerce Strategy Software skills: Web browser software, Web page development software Business skills: Strategic analysis This project provides an opportunity for you to develop an e-commerce strategy for a real-world business and to use a Web page development tool to create part of the company’s Web

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 10 E-Commerce: Digital Markets and Digital Goods LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. 2. 3. 4. 5. What are the unique features of e-commerce, digital markets, and digital goods? What are the principal e-commerce business and revenue models? How has e-commerce transformed marketing? How has e-commerce

Balance Sheet - Yahoo! (in thousands) 2011 3,452,536 11,330,250 14,782,786 2010 4,345,548 10,582,556 14,928,104 2009 4,594,772 10,341,258 14,936,030 1,207,361 1,034,358 2,241,719 1,625,872 744,103 2,369,975 1,717,728 724,982 2,442,710 Stockholders\' Equity 12,541,067 12,558,129 12,493,320 Total Liabilities & Stockholders\' Equity 14,782,786 14,928,104 14,936,030 Current Assets Other Assets Total Assets Current Liabilities Non-current Liabilities Total Liabilities Income Statement - Yahoo! (in Thousands) 2011 4,984,199 1,502,650 3,481,549 70% 2,681,208 800,341.00 27,175 827,516 241,767 (13,842) 1,048,827 21.04% Total Revenues Cost of Revenues Gross Profit Gross Margin Operating Expenses Operating Income (Loss) Other Income (Expense) Net Profit (Loss) (Income Taxes) Minority Interest Net Profit (Loss) after Taxes Net Margin 2010 6,324,651 2,627,545 3,697,106 58% 2,924,582 772,524.00 297,869.00 1,070,393 221,523 (12,965) 1,231,663 19.47% 2009 6,460,315 2,871,746 3,588,569 56% 3,201,877 386,692 187,528 574,220 219,321 (7,297) 597,992 9.26% Net Profit (Loss) after Taxes 1,400,000 1,200,000 1,000,000 800,000 Net Profit (Loss) after Taxes 600,000 400,000 200,000 0 2011 2010 2009

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 11 Managing Knowledge LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. What is the role of knowledge management and knowledge management programs in business? 2. What types of systems are used for enterprise-wide knowledge management and how do they provide value for

First Alison Barry Carl Doreen Edward Last Abel Burns Chantler Demos Eggmont Date of Birth 6/15/1943 7/11/1955 11/12/1969 6/10/1958 2/29/1956 Lookup Table Length Bonus 0 0 6 20% 11 30% 16 40% 21 50% 26 100% Age in Years Planned at Retirement Hire Date Retirement Date Year Employed Annual Salary 67.09 7/1/1974 7/1/2010 36.02 $100,000 55.01 9/22/1989 7/1/2010 20.79 $85,000 40.66 7/14/1994 7/1/2010 15.98 $45,000 52.09 3/2/2006 7/1/2010 4.33 $61,000 54.37 9/26/2001 7/1/2010 8.77 $29,000 Retirement Bonus $ 100,000 $ 34,000 $ $ $ 5,800

Chapter 11 Running Case Assignment: Achieving Operational Excellence: Identifying Opportunities for Knowledge Management Software skills: Web browser software, presentation software Business skills: Knowledge management strategy formulation This project provides an opportunity for you to identify opportunities for knowledge management at a real-world business and to suggest value-adding knowledge management applications. Senior management has started reading about knowledge

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 11: Managing Knowledge Learning Track 1: Challenges of Knowledge Management Systems Successful deployment of knowledge management systems requires a very clear understanding of how the firm creates and uses knowledge. Organizations need to determine precisely how they can benefit from knowledge

Chapter 11 Application Solution Description Students will need to find an expert system tool that provides a mechanism, called the inference engine, which automatically matches facts against patterns and determines which rules are applicable. Remind them about what “rules” the expert systems is looking for: the “if” portion of a rule can actually be thought

Chapter 11 Running Case Solution 1. What are the most important knowledge assets at Dirt Bikes? What functions and employee positions are responsible for creating, distributing, and using these knowledge assets? Are all of these assets explicit knowledge? 2. What knowledge outside the organization is required by the company? In this young but growing company,

First Alison Barry Carl Doreen Edward Last Abel Burns Chantler Demos Eggmont Date of Birth 6/15/1943 7/11/1955 11/12/1969 6/10/1958 2/29/1956 Lookup Table Length Bonus 0 0 6 20% 11 30% 16 40% 21 50% 26 100% Age in Years Planned at Retirement Hire Date Retirement Date Year Employed Annual Salary 67.09 7/1/1974 7/1/2010 36.02 $100,000 55.01 9/22/1989 7/1/2010 20.79 $85,000 40.66 7/14/1994 7/1/2010 15.98 $45,000 52.09 3/2/2006 7/1/2010 4.33 $61,000 54.37 9/26/2001 7/1/2010 8.77 $29,000 Retirement Bonus $ 100,000 $ 34,000 $ $ $ 5,800

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 12 Enhancing Decision Making LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. What are the different types of decisions, and how does the decision-making process work? 2. How do information systems support the activities of managers and management decision making? 3. How do

MIS13 Chapter 12 Hands-on MIS Exercise Online Managment Training Inc. Transaction Log: October 28 Cust ID 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 10014 10015 10016 10017 10018 10019 10020 10021 10022 10023 10024 10025 10026 10027 10028 10029 10030 10031 10032 10033 10034 10035 10036 10037 10038 10039 10040 10041 10042 10043 10044 10045 Region East West North West South West East West West South South East North East West West West West West West North West South West West West West South East West North East South West West East South East North South West West South South West Payment Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Paypal Paypal Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Paypal Paypal Paypal Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Source Web Web Web Email Web Email Web Web Web Web Email Web Web Web Web Web Email Web Web Web Email Web Email Web Email Email Web Web Web Email Email Web Web Web Web Web Web Web Web Web Web Web Web Web Web Amount $20.19 $17.85 $23.98 $23.51 $15.33 $17.30 $177.72 $21.76 $15.92 $23.39 $24.45 $20.39 $19.54 $151.67 $21.01 $22.91 $19.51 $20.16 $17.53 $17.74 $17.16 $205.58 $18.12 $20.04 $23.21 $22.79 $16.91 $20.22 $18.36 $206.80 $17.95 $18.29 $18.55 $18.82 $16.35 $16.30 $217 $16.15 $18.78 $150.99 $21.39 $16.60 $23.81 $15.87 $20.82 Product Online Online Online Book Book Online Book Book Online Online Book Book Online Book Online Online Book Book Online Online Book Book Book Online Online Online Online Book Online Book Online Book Book Book Book Online Book Online Online Book Online Online Book Book Online Time Of Day 22:19 13:27 14:27 15:38 15:21 13:11 21:59 4:04 19:35 13:26 14:17 1:01 10:04 9:09 5:05 20:29 15:03 18:54 20:00 12:37 5:05 20:42 10:12 16:27 20:22 19:58 19:44 19:28 15:48 18:14 15:15 12:59 17:38 2:02 14:05 4:04 0:00 10:28 5:05 7:07 19:20 16:23 7:07 13:46 9:09 10046 10047 10048 10049 10050 10051 10052 10053 10054 10055 10056 10057 10058 10059 10060 10061 10062 10063 10064 10065 10066 10067 10068 10069 10070 10071 10072 10073 10074 10075 10076 10077 10078 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 10090 10091 10092 10093 10094 10095 10096 10097 South South West West West East West North East East North West East East East West East South North North East East South South South West South West North East East South North West West North West South North East East East East North West East West West West North North West Credit Paypal Paypal Credit Paypal Paypal Credit Credit Credit Credit Paypal Paypal Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Paypal Paypal Credit Paypal Paypal Web Web Email Web Web Web Web Email Web Web Web Email Web Web Web Web Web Email Email Email Email Email Web Web Email Web Web Email Email Email Web Email Web Web Web Web Email Web Web Web Web Email Web Web Email Email Web Email Web Web Web Web $21.15 $19.66 $21.02 $23.13 $15.17 $209.51 $16.03 $16.17 $18.37 $15.96 $19.29 $16.49 $18.12 $18.22 $18.32 $23.77 $24.35 $20.13 $20.77 $16.98 $19.40 $23.49 $15.58 $21.94 $229.73 $16.06 $22.21 $21.58 $16.09 $16.10 $15.95 $17.77 $19.30 $21.75 $20.51 $16.14 $157.76 $21.55 $21.85 $21.70 $20.31 $23.62 $216.37 $21.99 $18.20 $17.31 $23.94 $174.25 $20.26 $18.73 $22.88 $19.15 Book Online Online Online Online Book Book Online Online Book Book Online Book Online Book Online Book Online Online Online Book Book Book Online Book Book Online Online Book Online Online Book Online Book Book Online Book Book Online Online Book Book Book Online Online Book Book Book Online Online Book Online 6:06 18:50 3:03 6:06 18:53 9:09 17:28 13:18 8:08 8:08 0:00 19:59 17:35 15:52 10:15 19:53 15:16 13:55 13:34 19:21 15:02 4:04 11:39 20:19 1:01 10:31 10:01 0:00 3:03 10:13 0:00 1:01 11:24 10:23 11:29 4:04 19:02 9:09 12:24 13:33 19:26 22:20 10:20 3:03 5:05 0:00 16:08 18:31 4:04 0:00 13:09 14:44 10098 10099 10100 10101 10102 10103 10104 10105 10106 10107 10108 10109 10110 10111 10112 10113 10114 10115 10116 10117 10118 10119 10120 10121 10122 10123 10124 10125 10126 10127 10128 10129 10130 10131 10132 10133 10134 10135 10136 10137 10138 10139 10140 10141 10142 10143 10144 10145 10146 10147 10148 10149 South West West East West North West East North North North West West East West North East East South North South East East North West West North South East West North West West South East West East South West West West East South West West West West East East East East West Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Paypal Paypal Credit Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Paypal Paypal Paypal Credit Credit Paypal Paypal Credit Credit Paypal Email Web Web Web Web Email Email Web Web Web Email Web Web Web Email Web Web Email Web Web Web Web Web Email Web Web Web Web Web Web Web Web Web Email Email Web Web Web Email Web Email Email Web Web Web Web Web Web Web Web Email Web $15.33 $20.82 $20.61 $16.43 $21.10 $21.64 $18.06 $19.35 $23.70 $18.93 $16.83 $22.19 $23.90 $17.47 $209.37 $18 $22.83 $20.31 $22.06 $15.22 $20.60 $18.25 $174.18 $19.58 $17.91 $22.90 $22.26 $19.04 $17.42 $18.54 $19.74 $22.03 $236.49 $19.30 $23.73 $19.96 $20.75 $22.37 $24.03 $24.59 $155.91 $16.43 $15.71 $15.19 $21.35 $19.47 $21.49 $22.20 $21.15 $15.16 $15.71 $24.65 Book Online Online Online Online Book Book Book Online Book Book Book Book Online Book Online Book Online Online Book Online Online Book Online Book Book Book Book Online Book Online Online Book Online Online Book Online Online Online Online Book Book Book Book Online Online Online Online Online Online Book Book 1:01 18:01 18:29 11:23 2:02 22:40 16:00 10:06 19:02 9:09 16:20 18:52 19:40 10:53 20:11 8:08 10:17 14:34 11:07 10:39 20:46 20:42 12:42 22:31 19:14 12:16 17:50 15:23 5:05 19:30 12:49 14:49 16:24 17:00 16:57 16:50 15:02 8:08 11:14 4:04 18:38 9:09 16:44 16:22 17:54 18:17 9:09 12:29 7:07 11:19 9:09 20:41 10150 10151 10152 10153 10154 10155 10156 10157 10158 10159 10160 10161 10162 10163 10164 10165 10166 10167 10168 10169 10170 10171 10172 10173 10174 10175 10176 10177 10178 10179 10180 10181 10182 10183 10184 10185 10186 10187 10188 10189 10190 10191 10192 10193 10194 10195 10196 10197 10198 10199 10200 10201 West East West South West East North South South West South North North West East West West North East West West North North West West East South West North West West East South West South West West West West North North South West East West West North West West South South North Paypal Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Paypal Paypal Paypal Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Paypal Credit Paypal Credit Credit Credit Email Email Web Web Web Web Web Web Web Email Email Web Web Web Web Email Web Web Web Web Web Web Web Web Web Email Web Web Web Web Web Email Web Email Email Web Web Web Web Web Web Web Web Email Web Web Web Web Web Web Email Email $24.88 $17.49 $19.71 $17.33 $15.56 $18.94 $22.86 $15.18 $22.46 $21.39 $22.17 $234.63 $24.97 $15.72 $24.35 $16.09 $23.51 $22.59 $15.59 $190.81 $21.12 $24.60 $21.22 $21.78 $16.54 $177.32 $21.50 $24.65 $19.43 $21.12 $18.10 $24.40 $19.37 $19.17 $241.77 $19.65 $19.88 $15.18 $15.08 $23.74 $19.44 $17.70 $16.99 $16.13 $24.80 $17.52 $23.63 $23.03 $21.03 $21.88 $24.86 $21.43 Book Book Online Book Online Online Book Book Book Book Online Book Book Book Book Book Book Book Online Book Book Online Online Online Online Book Book Online Online Online Online Book Book Online Book Book Book Online Book Book Book Online Online Book Online Book Book Online Online Book Book Online 15:23 21:46 7:07 2:02 21:07 20:00 16:02 6:06 17:44 17:17 10:23 9:09 22:11 10:53 8:08 8:08 16:18 16:51 9:09 21:57 16:40 20:38 12:20 7:07 17:52 15:52 10:53 20:45 9:09 20:13 20:32 13:25 21:48 0:00 9:09 20:46 8:08 12:30 12:15 5:05 9:09 2:02 17:34 13:37 20:28 20:35 19:47 11:27 19:18 3:03 17:27 7:07 10202 10203 10204 10205 10206 10207 10208 10209 10210 10211 10212 10213 10214 10215 10216 10217 10218 10219 10220 10221 10222 10223 10224 10225 10226 10227 10228 10229 10230 10231 10232 10233 10234 10235 10236 10237 10238 10239 10240 10241 10242 10243 10244 10245 10246 10247 10248 10249 10250 10251 10252 10253 South East North South South East West West East South West South North East East West West East West West West East West West West South West West North North East West North East West West West South South East East West West South West West West West North South North East Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Paypal Credit Paypal Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Paypal Credit Credit Web Web Web Web Web Web Email Web Web Web Email Email Web Web Web Web Web Email Web Web Web Email Web Email Web Web Web Web Email Web Email Web Web Web Email Email Web Web Web Web Web Web Email Email Web Email Web Email Email Web Web Email $16.32 $17.20 $17.87 $17.27 $19.76 $17.10 $15.66 $22.37 $15.81 $18.75 $192.41 $242.52 $20.40 $24.71 $21.49 $22.26 $22.39 $21.01 $226.15 $20.67 $21.72 $16.34 $19.19 $19.21 $16.06 $20.87 $15.33 $23.58 $15.34 $216.20 $21.85 $23.59 $20.44 $22.05 $20.42 $20.49 $161.46 $19.69 $24.16 $22.80 $243.70 $210.38 $161.50 $21.92 $23.75 $23.74 $21.67 $22.04 $17.83 $23.60 $19.90 $209.20 Online Online Online Online Book Book Book Book Online Online Book Book Book Online Online Online Book Book Book Book Online Book Book Online Book Online Online Online Book Book Online Book Book Online Book Online Book Online Book Online Book Book Book Online Online Online Book Book Online Book Book Book 15:09 0:00 7:07 7:07 21:13 6:06 11:18 16:21 12:26 2:02 20:23 9:09 0:00 12:45 8:08 5:05 16:16 8:08 16:41 19:27 20:04 17:53 19:08 2:02 17:30 13:41 5:05 2:02 10:08 10:33 14:28 3:03 11:52 8:08 0:00 20:10 14:23 4:04 2:02 10:59 20:26 12:19 16:15 6:06 20:34 3:03 12:41 3:03 12:55 2:02 14:04 17:19 10254 10255 10256 10257 10258 10259 10260 10261 10262 10263 10264 10265 10266 10267 10268 10269 10270 10271 10272 10273 10274 10275 10276 10277 10278 10279 10280 10281 10282 10283 10284 10285 10286 10287 10288 10289 10290 10291 10292 10293 10294 10295 10296 10297 10298 10299 10300 10301 10302 10303 10304 10305 East West West East North South East East West South South West West West East North East North East South West West West South South West South West South South South West West West South South East West East West West East East North East East South West West West South West Credit Credit Paypal Credit Paypal Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Credit Credit Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Paypal Credit Paypal Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Email Web Email Web Web Web Web Web Web Web Web Web Email Web Email Web Web Email Web Web Web Web Web Web Web Web Web Email Email Web Web Web Web Web Web Web Web Email Web Email Web Web Web Web Email Web Web Email Web Web Email Web $24 $17.81 $24.77 $21 $191.43 $24.52 $17.34 $17.19 $22.55 $15.35 $23.20 $241.65 $242.40 $23.01 $17.22 $15.96 $15.45 $17.41 $21.64 $157.86 $18.17 $18.73 $17.24 $23.91 $22.12 $15.25 $24.77 $20.28 $20.33 $16.90 $16.47 $21.18 $15.86 $24.42 $222.38 $188.85 $15.32 $24.71 $20.97 $21.92 $15.40 $23.08 $23.40 $22.65 $24.61 $24.97 $18.57 $16.15 $19.95 $15.61 $19.13 $231.23 Book Book Online Online Book Online Online Book Book Online Book Book Book Online Online Online Online Online Book Book Online Book Book Online Book Online Book Book Online Book Book Book Book Book Book Book Book Book Book Online Book Book Online Book Book Book Book Online Book Online Book Book 11:52 12:36 0:00 17:14 16:36 21:59 8:08 3:03 11:43 10:15 15:38 20:39 17:19 17:44 1:01 1:01 9:09 5:05 10:39 5:05 16:09 20:18 20:47 13:59 17:31 19:11 0:00 6:06 8:08 21:41 16:22 15:10 18:00 1:01 18:53 5:05 9:09 16:22 11:17 19:17 17:16 7:07 1:01 6:06 13:08 16:53 12:45 3:03 19:35 22:02 22:55 0:00 10306 10307 10308 10309 10310 10311 10312 10313 10314 10315 10316 10317 10318 10319 10320 10321 10322 10323 10324 10325 10326 10327 10328 10329 10330 10331 10332 10333 10334 10335 10336 10337 10338 10339 10340 10341 10342 10343 10344 10345 10346 10347 10348 10349 10350 10351 10352 10353 10354 10355 10356 10357 East South West South North South West West South East East South West West North South West North South South East West South South North West West East North East South West North West West West West North East West West East South East West North West West South East North South Credit Paypal Credit Credit Paypal Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Paypal Credit Paypal Credit Paypal Paypal Paypal Credit Paypal Credit Paypal Paypal Paypal Paypal Credit Credit Paypal Paypal Credit Paypal Credit Email Web Web Email Email Web Web Email Web Web Web Web Email Email Web Email Web Web Web Web Email Email Email Email Email Web Email Web Web Web Web Web Email Web Email Web Email Web Web Web Email Email Email Web Web Email Web Web Web Web Web Email $244.75 $21.36 $21.83 $21.58 $17.51 $23.29 $18.35 $23.06 $19.81 $162.74 $16.86 $23.31 $22.92 $22.84 $16.97 $188.16 $22.57 $24.71 $246.67 $20.97 $19.83 $19.09 $16.52 $22.31 $19.52 $24.79 $18.84 $24.58 $17.19 $19.65 $17.35 $22.92 $18.81 $20.08 $24.54 $24.81 $15.94 $18.29 $15.55 $19.20 $17.34 $22.51 $23.45 $16.15 $17.68 $22.11 $18.41 $17.08 $15.77 $22.41 $20.63 $18.14 Book Online Book Online Book Online Book Online Online Book Online Book Book Online Online Book Online Online Book Book Book Book Book Book Online Online Online Online Book Book Book Online Online Book Book Book Online Online Online Online Online Online Online Online Book Book Online Online Online Book Online Book 10:13 20:25 1:01 1:01 20:19 4:04 20:54 11:48 21:19 9:09 9:09 16:23 0:00 17:37 4:04 19:21 18:45 13:34 16:47 8:08 4:04 11:45 6:06 2:02 0:00 9:09 22:04 0:00 12:19 6:06 21:37 16:23 7:07 3:03 4:04 14:40 0:00 8:08 6:06 20:52 18:10 5:05 2:02 13:45 0:00 11:28 1:01 17:06 10:36 7:07 3:03 3:03 10358 10359 10360 10361 10362 10363 10364 10365 10366 10367 10368 10369 10370 10371 10372 10373 10374 10375 10376 10377 10378 10379 10380 10381 10382 10383 10384 10385 10386 10387 10388 10389 10390 10391 10392 10393 10394 10395 10396 10397 10398 10399 10400 10401 10402 10403 10404 10405 10406 10407 10408 10409 North West South North South South West West East East West East North North West West North West South East South North West West South West South West West North South North East West East South West West West West West East West West West South North North East North South West Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Paypal Paypal Credit Paypal Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Credit Credit Credit Web Email Web Web Email Web Email Web Web Web Web Web Web Web Web Web Web Web Email Web Web Email Web Web Web Web Web Web Web Email Email Email Web Web Web Email Email Web Web Web Web Web Web Web Web Email Web Web Web Web Web Web $20.18 $177.30 $15.71 $21.75 $18.25 $203.72 $15.54 $17.50 $21.32 $150.86 $17.39 $23.87 $21.53 $19.64 $18.27 $19.27 $20.16 $15.59 $16.34 $199.18 $19.99 $18.44 $23.75 $20.88 $197.43 $20.32 $16.82 $20.16 $16.79 $22.53 $21.68 $23.54 $17.67 $22.79 $24.80 $15.27 $18.74 $16.47 $18.11 $20.73 $21.64 $17.38 $17.70 $24.66 $24.24 $19.79 $16.86 $19.97 $22.99 $153.83 $15.20 $16.01 Book Book Online Online Book Book Book Online Book Book Book Online Book Online Book Online Book Online Online Book Book Online Book Online Book Book Online Book Book Book Book Book Online Book Book Book Book Online Online Online Online Book Online Book Online Book Online Online Book Book Online Online 11:13 11:33 5:05 17:22 5:05 14:29 19:36 5:05 2:02 13:17 4:04 13:52 16:04 16:14 18:39 6:06 14:38 4:04 12:35 14:00 20:29 18:38 9:09 0:00 10:43 18:33 8:08 13:40 21:27 11:41 14:32 6:06 9:09 0:00 18:09 8:08 22:41 20:26 0:00 17:46 16:11 16:14 7:07 17:07 19:16 7:07 8:08 22:37 9:09 15:07 15:03 20:02 10410 10411 10412 10413 10414 10415 10416 10417 10418 10419 10420 10421 10422 10423 10424 10425 10426 10427 10428 10429 10430 10431 10432 10433 10434 10435 10436 10437 10438 10439 10440 10441 10442 10443 10444 10445 10446 10447 10448 10449 10450 10451 10452 10453 10454 10455 10456 10457 10458 10459 10460 10461 West South East North North West North North West East West South North West East North North West North West East West North North West South West South South East South North West South West West East North North North West West North North West South East West South South West South Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Credit Credit Web Email Web Web Web Web Web Web Web Web Web Email Web Email Web Web Email Web Web Web Web Web Email Email Email Web Web Web Email Web Web Email Web Email Web Web Web Web Web Web Email Web Web Web Web Web Web Web Web Web Web Web $18.88 $21.54 $24.11 $21.43 $24.80 $19.76 $23.97 $19.96 $18.19 $17.28 $24.84 $16.32 $23.47 $16.65 $22.64 $16.66 $21.78 $21.29 $160.78 $21.10 $169.79 $16.99 $23.64 $18.92 $23.96 $18.53 $24.44 $21.81 $18.25 $17.42 $18.40 $23.88 $17.76 $23.06 $18.87 $17.87 $18.77 $18.60 $152.27 $20.83 $21.47 $218.60 $163.37 $24.78 $17.01 $231.23 $22.57 $24.16 $20.68 $21.20 $247.14 $19.10 Online Book Book Book Online Online Online Online Book Online Book Book Book Book Book Book Book Online Book Book Book Book Online Book Book Book Online Online Online Book Book Online Book Book Book Online Book Online Book Book Book Book Book Book Book Book Online Online Book Online Book Book 17:57 19:37 0:00 8:08 0:00 20:15 18:39 11:25 1:01 15:45 8:08 13:50 17:00 19:19 11:53 2:02 14:10 14:14 14:47 14:38 20:13 3:03 8:08 13:23 7:07 21:20 5:05 5:05 15:54 1:01 10:25 3:03 14:37 11:57 16:33 16:11 15:09 0:00 6:06 16:46 17:52 12:33 16:55 21:56 7:07 20:26 15:02 11:02 21:51 7:07 17:16 13:04 10462 10463 10464 10465 10466 10467 10468 10469 10470 10471 10472 10473 10474 10475 10476 10477 10478 10479 10480 10481 10482 10483 10484 10485 10486 10487 10488 10489 10490 10491 10492 10493 10494 10495 10496 10497 10498 10499 10500 10501 10502 10503 10504 10505 10506 10507 10508 10509 10510 South East West West East South South North West West North West West West North West West West West West East North West West West West South West North South South West West West North West East South West North North West West South South West South East North Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Paypal Paypal Credit Credit Credit Paypal Paypal Credit Paypal Paypal Paypal Credit Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Paypal Credit Web Web Email Web Email Web Email Email Email Web Web Email Web Web Web Email Web Web Web Web Web Email Email Web Web Email Web Email Web Email Email Web Email Web Email Email Web Email Web Email Web Web Web Web Web Web Web Web Web $19.02 $19.66 $168.10 $16.83 $23.89 $16.73 $22.05 $17.88 $15.18 $15.62 $20.58 $17.28 $24.38 $15.70 $16.64 $16.77 $22.06 $15.06 $17.70 $24.63 $17.98 $22.56 $17.95 $17.94 $15.72 $15.26 $15.33 $18.88 $18.51 $18.73 $18.69 $18.29 $24.97 $22.91 $16.62 $21.73 $15.92 $20.77 $228.08 $22.14 $17.73 $22.28 $19.92 $17.83 $16.35 $23.70 $22.02 $23.53 $24.63 Online Book Book Book Book Online Online Book Online Online Online Online Online Book Book Book Book Online Book Book Book Book Book Online Online Online Online Book Book Online Online Online Online Book Book Book Online Book Book Book Book Online Book Online Book Book Online Online Book 22:07 1:01 16:22 8:08 0:00 19:20 10:27 6:06 19:25 3:03 18:02 17:32 8:08 1:01 21:58 18:15 18:21 21:31 19:49 19:34 8:08 13:32 17:03 15:44 16:18 20:34 22:22 0:00 15:38 9:09 14:32 21:02 15:32 20:36 9:09 17:31 0:00 20:55 14:57 20:01 5:05 17:39 16:53 6:06 22:29 20:43 11:55 21:52 4:04

MIS13 Chapter 12 Hands-on MIS Exercise Online Managment Training Inc. Transaction Log: October 28 Cust ID 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 10014 10015 10016 10017 10018 10019 10020 10021 10022 10023 10024 10025 10026 10027 10028 10029 10030 10031 10032 10033 10034 10035 10036 10037 10038 10039 10040 10041 10042 10043 10044 10045 Region East West North West South West East West West South South East North East West West West West West West North West South West West West West South East West North East South West West East South East North South West West South South West Payment Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Paypal Paypal Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Paypal Paypal Paypal Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Source Web Web Web Email Web Email Web Web Web Web Email Web Web Web Web Web Email Web Web Web Email Web Email Web Email Email Web Web Web Email Email Web Web Web Web Web Web Web Web Web Web Web Web Web Web Amount $20.19 $17.85 $23.98 $23.51 $15.33 $17.30 $177.72 $21.76 $15.92 $23.39 $24.45 $20.39 $19.54 $151.67 $21.01 $22.91 $19.51 $20.16 $17.53 $17.74 $17.16 $205.58 $18.12 $20.04 $23.21 $22.79 $16.91 $20.22 $18.36 $206.80 $17.95 $18.29 $18.55 $18.82 $16.35 $16.30 $217 $16.15 $18.78 $150.99 $21.39 $16.60 $23.81 $15.87 $20.82 Product Online Online Online Book Book Online Book Book Online Online Book Book Online Book Online Online Book Book Online Online Book Book Book Online Online Online Online Book Online Book Online Book Book Book Book Online Book Online Online Book Online Online Book Book Online Time Of Day 22:19 13:27 14:27 15:38 15:21 13:11 21:59 4:04 19:35 13:26 14:17 1:01 10:04 9:09 5:05 20:29 15:03 18:54 20:00 12:37 5:05 20:42 10:12 16:27 20:22 19:58 19:44 19:28 15:48 18:14 15:15 12:59 17:38 2:02 14:05 4:04 0:00 10:28 5:05 7:07 19:20 16:23 7:07 13:46 9:09 10046 10047 10048 10049 10050 10051 10052 10053 10054 10055 10056 10057 10058 10059 10060 10061 10062 10063 10064 10065 10066 10067 10068 10069 10070 10071 10072 10073 10074 10075 10076 10077 10078 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 10090 10091 10092 10093 10094 10095 10096 10097 South South West West West East West North East East North West East East East West East South North North East East South South South West South West North East East South North West West North West South North East East East East North West East West West West North North West Credit Paypal Paypal Credit Paypal Paypal Credit Credit Credit Credit Paypal Paypal Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Paypal Paypal Credit Paypal Paypal Web Web Email Web Web Web Web Email Web Web Web Email Web Web Web Web Web Email Email Email Email Email Web Web Email Web Web Email Email Email Web Email Web Web Web Web Email Web Web Web Web Email Web Web Email Email Web Email Web Web Web Web $21.15 $19.66 $21.02 $23.13 $15.17 $209.51 $16.03 $16.17 $18.37 $15.96 $19.29 $16.49 $18.12 $18.22 $18.32 $23.77 $24.35 $20.13 $20.77 $16.98 $19.40 $23.49 $15.58 $21.94 $229.73 $16.06 $22.21 $21.58 $16.09 $16.10 $15.95 $17.77 $19.30 $21.75 $20.51 $16.14 $157.76 $21.55 $21.85 $21.70 $20.31 $23.62 $216.37 $21.99 $18.20 $17.31 $23.94 $174.25 $20.26 $18.73 $22.88 $19.15 Book Online Online Online Online Book Book Online Online Book Book Online Book Online Book Online Book Online Online Online Book Book Book Online Book Book Online Online Book Online Online Book Online Book Book Online Book Book Online Online Book Book Book Online Online Book Book Book Online Online Book Online 6:06 18:50 3:03 6:06 18:53 9:09 17:28 13:18 8:08 8:08 0:00 19:59 17:35 15:52 10:15 19:53 15:16 13:55 13:34 19:21 15:02 4:04 11:39 20:19 1:01 10:31 10:01 0:00 3:03 10:13 0:00 1:01 11:24 10:23 11:29 4:04 19:02 9:09 12:24 13:33 19:26 22:20 10:20 3:03 5:05 0:00 16:08 18:31 4:04 0:00 13:09 14:44 10098 10099 10100 10101 10102 10103 10104 10105 10106 10107 10108 10109 10110 10111 10112 10113 10114 10115 10116 10117 10118 10119 10120 10121 10122 10123 10124 10125 10126 10127 10128 10129 10130 10131 10132 10133 10134 10135 10136 10137 10138 10139 10140 10141 10142 10143 10144 10145 10146 10147 10148 10149 South West West East West North West East North North North West West East West North East East South North South East East North West West North South East West North West West South East West East South West West West East South West West West West East East East East West Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Paypal Paypal Credit Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Paypal Paypal Paypal Credit Credit Paypal Paypal Credit Credit Paypal Email Web Web Web Web Email Email Web Web Web Email Web Web Web Email Web Web Email Web Web Web Web Web Email Web Web Web Web Web Web Web Web Web Email Email Web Web Web Email Web Email Email Web Web Web Web Web Web Web Web Email Web $15.33 $20.82 $20.61 $16.43 $21.10 $21.64 $18.06 $19.35 $23.70 $18.93 $16.83 $22.19 $23.90 $17.47 $209.37 $18 $22.83 $20.31 $22.06 $15.22 $20.60 $18.25 $174.18 $19.58 $17.91 $22.90 $22.26 $19.04 $17.42 $18.54 $19.74 $22.03 $236.49 $19.30 $23.73 $19.96 $20.75 $22.37 $24.03 $24.59 $155.91 $16.43 $15.71 $15.19 $21.35 $19.47 $21.49 $22.20 $21.15 $15.16 $15.71 $24.65 Book Online Online Online Online Book Book Book Online Book Book Book Book Online Book Online Book Online Online Book Online Online Book Online Book Book Book Book Online Book Online Online Book Online Online Book Online Online Online Online Book Book Book Book Online Online Online Online Online Online Book Book 1:01 18:01 18:29 11:23 2:02 22:40 16:00 10:06 19:02 9:09 16:20 18:52 19:40 10:53 20:11 8:08 10:17 14:34 11:07 10:39 20:46 20:42 12:42 22:31 19:14 12:16 17:50 15:23 5:05 19:30 12:49 14:49 16:24 17:00 16:57 16:50 15:02 8:08 11:14 4:04 18:38 9:09 16:44 16:22 17:54 18:17 9:09 12:29 7:07 11:19 9:09 20:41 10150 10151 10152 10153 10154 10155 10156 10157 10158 10159 10160 10161 10162 10163 10164 10165 10166 10167 10168 10169 10170 10171 10172 10173 10174 10175 10176 10177 10178 10179 10180 10181 10182 10183 10184 10185 10186 10187 10188 10189 10190 10191 10192 10193 10194 10195 10196 10197 10198 10199 10200 10201 West East West South West East North South South West South North North West East West West North East West West North North West West East South West North West West East South West South West West West West North North South West East West West North West West South South North Paypal Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Paypal Paypal Paypal Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Paypal Credit Paypal Credit Credit Credit Email Email Web Web Web Web Web Web Web Email Email Web Web Web Web Email Web Web Web Web Web Web Web Web Web Email Web Web Web Web Web Email Web Email Email Web Web Web Web Web Web Web Web Email Web Web Web Web Web Web Email Email $24.88 $17.49 $19.71 $17.33 $15.56 $18.94 $22.86 $15.18 $22.46 $21.39 $22.17 $234.63 $24.97 $15.72 $24.35 $16.09 $23.51 $22.59 $15.59 $190.81 $21.12 $24.60 $21.22 $21.78 $16.54 $177.32 $21.50 $24.65 $19.43 $21.12 $18.10 $24.40 $19.37 $19.17 $241.77 $19.65 $19.88 $15.18 $15.08 $23.74 $19.44 $17.70 $16.99 $16.13 $24.80 $17.52 $23.63 $23.03 $21.03 $21.88 $24.86 $21.43 Book Book Online Book Online Online Book Book Book Book Online Book Book Book Book Book Book Book Online Book Book Online Online Online Online Book Book Online Online Online Online Book Book Online Book Book Book Online Book Book Book Online Online Book Online Book Book Online Online Book Book Online 15:23 21:46 7:07 2:02 21:07 20:00 16:02 6:06 17:44 17:17 10:23 9:09 22:11 10:53 8:08 8:08 16:18 16:51 9:09 21:57 16:40 20:38 12:20 7:07 17:52 15:52 10:53 20:45 9:09 20:13 20:32 13:25 21:48 0:00 9:09 20:46 8:08 12:30 12:15 5:05 9:09 2:02 17:34 13:37 20:28 20:35 19:47 11:27 19:18 3:03 17:27 7:07 10202 10203 10204 10205 10206 10207 10208 10209 10210 10211 10212 10213 10214 10215 10216 10217 10218 10219 10220 10221 10222 10223 10224 10225 10226 10227 10228 10229 10230 10231 10232 10233 10234 10235 10236 10237 10238 10239 10240 10241 10242 10243 10244 10245 10246 10247 10248 10249 10250 10251 10252 10253 South East North South South East West West East South West South North East East West West East West West West East West West West South West West North North East West North East West West West South South East East West West South West West West West North South North East Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Paypal Credit Paypal Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Paypal Credit Credit Web Web Web Web Web Web Email Web Web Web Email Email Web Web Web Web Web Email Web Web Web Email Web Email Web Web Web Web Email Web Email Web Web Web Email Email Web Web Web Web Web Web Email Email Web Email Web Email Email Web Web Email $16.32 $17.20 $17.87 $17.27 $19.76 $17.10 $15.66 $22.37 $15.81 $18.75 $192.41 $242.52 $20.40 $24.71 $21.49 $22.26 $22.39 $21.01 $226.15 $20.67 $21.72 $16.34 $19.19 $19.21 $16.06 $20.87 $15.33 $23.58 $15.34 $216.20 $21.85 $23.59 $20.44 $22.05 $20.42 $20.49 $161.46 $19.69 $24.16 $22.80 $243.70 $210.38 $161.50 $21.92 $23.75 $23.74 $21.67 $22.04 $17.83 $23.60 $19.90 $209.20 Online Online Online Online Book Book Book Book Online Online Book Book Book Online Online Online Book Book Book Book Online Book Book Online Book Online Online Online Book Book Online Book Book Online Book Online Book Online Book Online Book Book Book Online Online Online Book Book Online Book Book Book 15:09 0:00 7:07 7:07 21:13 6:06 11:18 16:21 12:26 2:02 20:23 9:09 0:00 12:45 8:08 5:05 16:16 8:08 16:41 19:27 20:04 17:53 19:08 2:02 17:30 13:41 5:05 2:02 10:08 10:33 14:28 3:03 11:52 8:08 0:00 20:10 14:23 4:04 2:02 10:59 20:26 12:19 16:15 6:06 20:34 3:03 12:41 3:03 12:55 2:02 14:04 17:19 10254 10255 10256 10257 10258 10259 10260 10261 10262 10263 10264 10265 10266 10267 10268 10269 10270 10271 10272 10273 10274 10275 10276 10277 10278 10279 10280 10281 10282 10283 10284 10285 10286 10287 10288 10289 10290 10291 10292 10293 10294 10295 10296 10297 10298 10299 10300 10301 10302 10303 10304 10305 East West West East North South East East West South South West West West East North East North East South West West West South South West South West South South South West West West South South East West East West West East East North East East South West West West South West Credit Credit Paypal Credit Paypal Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Credit Credit Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Paypal Credit Paypal Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Email Web Email Web Web Web Web Web Web Web Web Web Email Web Email Web Web Email Web Web Web Web Web Web Web Web Web Email Email Web Web Web Web Web Web Web Web Email Web Email Web Web Web Web Email Web Web Email Web Web Email Web $24 $17.81 $24.77 $21 $191.43 $24.52 $17.34 $17.19 $22.55 $15.35 $23.20 $241.65 $242.40 $23.01 $17.22 $15.96 $15.45 $17.41 $21.64 $157.86 $18.17 $18.73 $17.24 $23.91 $22.12 $15.25 $24.77 $20.28 $20.33 $16.90 $16.47 $21.18 $15.86 $24.42 $222.38 $188.85 $15.32 $24.71 $20.97 $21.92 $15.40 $23.08 $23.40 $22.65 $24.61 $24.97 $18.57 $16.15 $19.95 $15.61 $19.13 $231.23 Book Book Online Online Book Online Online Book Book Online Book Book Book Online Online Online Online Online Book Book Online Book Book Online Book Online Book Book Online Book Book Book Book Book Book Book Book Book Book Online Book Book Online Book Book Book Book Online Book Online Book Book 11:52 12:36 0:00 17:14 16:36 21:59 8:08 3:03 11:43 10:15 15:38 20:39 17:19 17:44 1:01 1:01 9:09 5:05 10:39 5:05 16:09 20:18 20:47 13:59 17:31 19:11 0:00 6:06 8:08 21:41 16:22 15:10 18:00 1:01 18:53 5:05 9:09 16:22 11:17 19:17 17:16 7:07 1:01 6:06 13:08 16:53 12:45 3:03 19:35 22:02 22:55 0:00 10306 10307 10308 10309 10310 10311 10312 10313 10314 10315 10316 10317 10318 10319 10320 10321 10322 10323 10324 10325 10326 10327 10328 10329 10330 10331 10332 10333 10334 10335 10336 10337 10338 10339 10340 10341 10342 10343 10344 10345 10346 10347 10348 10349 10350 10351 10352 10353 10354 10355 10356 10357 East South West South North South West West South East East South West West North South West North South South East West South South North West West East North East South West North West West West West North East West West East South East West North West West South East North South Credit Paypal Credit Credit Paypal Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Paypal Credit Paypal Credit Paypal Paypal Paypal Credit Paypal Credit Paypal Paypal Paypal Paypal Credit Credit Paypal Paypal Credit Paypal Credit Email Web Web Email Email Web Web Email Web Web Web Web Email Email Web Email Web Web Web Web Email Email Email Email Email Web Email Web Web Web Web Web Email Web Email Web Email Web Web Web Email Email Email Web Web Email Web Web Web Web Web Email $244.75 $21.36 $21.83 $21.58 $17.51 $23.29 $18.35 $23.06 $19.81 $162.74 $16.86 $23.31 $22.92 $22.84 $16.97 $188.16 $22.57 $24.71 $246.67 $20.97 $19.83 $19.09 $16.52 $22.31 $19.52 $24.79 $18.84 $24.58 $17.19 $19.65 $17.35 $22.92 $18.81 $20.08 $24.54 $24.81 $15.94 $18.29 $15.55 $19.20 $17.34 $22.51 $23.45 $16.15 $17.68 $22.11 $18.41 $17.08 $15.77 $22.41 $20.63 $18.14 Book Online Book Online Book Online Book Online Online Book Online Book Book Online Online Book Online Online Book Book Book Book Book Book Online Online Online Online Book Book Book Online Online Book Book Book Online Online Online Online Online Online Online Online Book Book Online Online Online Book Online Book 10:13 20:25 1:01 1:01 20:19 4:04 20:54 11:48 21:19 9:09 9:09 16:23 0:00 17:37 4:04 19:21 18:45 13:34 16:47 8:08 4:04 11:45 6:06 2:02 0:00 9:09 22:04 0:00 12:19 6:06 21:37 16:23 7:07 3:03 4:04 14:40 0:00 8:08 6:06 20:52 18:10 5:05 2:02 13:45 0:00 11:28 1:01 17:06 10:36 7:07 3:03 3:03 10358 10359 10360 10361 10362 10363 10364 10365 10366 10367 10368 10369 10370 10371 10372 10373 10374 10375 10376 10377 10378 10379 10380 10381 10382 10383 10384 10385 10386 10387 10388 10389 10390 10391 10392 10393 10394 10395 10396 10397 10398 10399 10400 10401 10402 10403 10404 10405 10406 10407 10408 10409 North West South North South South West West East East West East North North West West North West South East South North West West South West South West West North South North East West East South West West West West West East West West West South North North East North South West Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Paypal Paypal Credit Paypal Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Credit Credit Credit Web Email Web Web Email Web Email Web Web Web Web Web Web Web Web Web Web Web Email Web Web Email Web Web Web Web Web Web Web Email Email Email Web Web Web Email Email Web Web Web Web Web Web Web Web Email Web Web Web Web Web Web $20.18 $177.30 $15.71 $21.75 $18.25 $203.72 $15.54 $17.50 $21.32 $150.86 $17.39 $23.87 $21.53 $19.64 $18.27 $19.27 $20.16 $15.59 $16.34 $199.18 $19.99 $18.44 $23.75 $20.88 $197.43 $20.32 $16.82 $20.16 $16.79 $22.53 $21.68 $23.54 $17.67 $22.79 $24.80 $15.27 $18.74 $16.47 $18.11 $20.73 $21.64 $17.38 $17.70 $24.66 $24.24 $19.79 $16.86 $19.97 $22.99 $153.83 $15.20 $16.01 Book Book Online Online Book Book Book Online Book Book Book Online Book Online Book Online Book Online Online Book Book Online Book Online Book Book Online Book Book Book Book Book Online Book Book Book Book Online Online Online Online Book Online Book Online Book Online Online Book Book Online Online 11:13 11:33 5:05 17:22 5:05 14:29 19:36 5:05 2:02 13:17 4:04 13:52 16:04 16:14 18:39 6:06 14:38 4:04 12:35 14:00 20:29 18:38 9:09 0:00 10:43 18:33 8:08 13:40 21:27 11:41 14:32 6:06 9:09 0:00 18:09 8:08 22:41 20:26 0:00 17:46 16:11 16:14 7:07 17:07 19:16 7:07 8:08 22:37 9:09 15:07 15:03 20:02 10410 10411 10412 10413 10414 10415 10416 10417 10418 10419 10420 10421 10422 10423 10424 10425 10426 10427 10428 10429 10430 10431 10432 10433 10434 10435 10436 10437 10438 10439 10440 10441 10442 10443 10444 10445 10446 10447 10448 10449 10450 10451 10452 10453 10454 10455 10456 10457 10458 10459 10460 10461 West South East North North West North North West East West South North West East North North West North West East West North North West South West South South East South North West South West West East North North North West West North North West South East West South South West South Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Credit Credit Web Email Web Web Web Web Web Web Web Web Web Email Web Email Web Web Email Web Web Web Web Web Email Email Email Web Web Web Email Web Web Email Web Email Web Web Web Web Web Web Email Web Web Web Web Web Web Web Web Web Web Web $18.88 $21.54 $24.11 $21.43 $24.80 $19.76 $23.97 $19.96 $18.19 $17.28 $24.84 $16.32 $23.47 $16.65 $22.64 $16.66 $21.78 $21.29 $160.78 $21.10 $169.79 $16.99 $23.64 $18.92 $23.96 $18.53 $24.44 $21.81 $18.25 $17.42 $18.40 $23.88 $17.76 $23.06 $18.87 $17.87 $18.77 $18.60 $152.27 $20.83 $21.47 $218.60 $163.37 $24.78 $17.01 $231.23 $22.57 $24.16 $20.68 $21.20 $247.14 $19.10 Online Book Book Book Online Online Online Online Book Online Book Book Book Book Book Book Book Online Book Book Book Book Online Book Book Book Online Online Online Book Book Online Book Book Book Online Book Online Book Book Book Book Book Book Book Book Online Online Book Online Book Book 17:57 19:37 0:00 8:08 0:00 20:15 18:39 11:25 1:01 15:45 8:08 13:50 17:00 19:19 11:53 2:02 14:10 14:14 14:47 14:38 20:13 3:03 8:08 13:23 7:07 21:20 5:05 5:05 15:54 1:01 10:25 3:03 14:37 11:57 16:33 16:11 15:09 0:00 6:06 16:46 17:52 12:33 16:55 21:56 7:07 20:26 15:02 11:02 21:51 7:07 17:16 13:04 10462 10463 10464 10465 10466 10467 10468 10469 10470 10471 10472 10473 10474 10475 10476 10477 10478 10479 10480 10481 10482 10483 10484 10485 10486 10487 10488 10489 10490 10491 10492 10493 10494 10495 10496 10497 10498 10499 10500 10501 10502 10503 10504 10505 10506 10507 10508 10509 10510 South East West West East South South North West West North West West West North West West West West West East North West West West West South West North South South West West West North West East South West North North West West South South West South East North Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Paypal Paypal Credit Credit Credit Paypal Paypal Credit Paypal Paypal Paypal Credit Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Paypal Credit Web Web Email Web Email Web Email Email Email Web Web Email Web Web Web Email Web Web Web Web Web Email Email Web Web Email Web Email Web Email Email Web Email Web Email Email Web Email Web Email Web Web Web Web Web Web Web Web Web $19.02 $19.66 $168.10 $16.83 $23.89 $16.73 $22.05 $17.88 $15.18 $15.62 $20.58 $17.28 $24.38 $15.70 $16.64 $16.77 $22.06 $15.06 $17.70 $24.63 $17.98 $22.56 $17.95 $17.94 $15.72 $15.26 $15.33 $18.88 $18.51 $18.73 $18.69 $18.29 $24.97 $22.91 $16.62 $21.73 $15.92 $20.77 $228.08 $22.14 $17.73 $22.28 $19.92 $17.83 $16.35 $23.70 $22.02 $23.53 $24.63 $19,801.61 Online Book Book Book Book Online Online Book Online Online Online Online Online Book Book Book Book Online Book Book Book Book Book Online Online Online Online Book Book Online Online Online Online Book Book Book Online Book Book Book Book Online Book Online Book Book Online Online Book 22:07 1:01 16:22 8:08 0:00 19:20 10:27 6:06 19:25 3:03 18:02 17:32 8:08 1:01 21:58 18:15 18:21 21:31 19:49 19:34 8:08 13:32 17:03 15:44 16:18 20:34 22:22 0:00 15:38 9:09 14:32 21:02 15:32 20:36 9:09 17:31 0:00 20:55 14:57 20:01 5:05 17:39 16:53 6:06 22:29 20:43 11:55 21:52 4:04 Average of Amount Region East North South West Average of Amount Total $ 41.86 $ 32.48 $ 60.57 $ 38.08 $ 42.49 Sum of Amount Payment Credit Paypal Grand Total Total $ 12,693 $ 7,109 $ 19,802 Count of Cust iD Time Of Day Total 0:00 27 9:09 24 8:08 23 5:05 18 7:07 16 1:01 15 3:03 15 6:06 15 4:04 14 2:02 13 16:22 4 10:53 3 15:02 3 15:38 3 16:23 3 20:26 3 10:13 2 10:15 2 10:23 2 10:39 2 11:52 2 12:19 2 12:45 2 13:34 2 14:32 2 14:38 2 15:03 2 15:09 2 15:23 2 15:52 2 16:11 2 16:14 2 16:18 2 16:53 2 17:00 2 17:16 2 17:19 2 17:31 2 17:44 2 17:52 2 18:38 2 18:39 2 18:53 2 19:02 2 19:20 2 19:21 2 19:35 2 20:00 2 20:13 20:19 20:29 20:34 20:42 20:46 21:59 10:01 10:04 10:06 10:08 10:12 10:17 10:20 10:25 10:27 10:28 10:31 10:33 10:36 10:43 10:59 11:02 11:07 11:13 11:14 11:17 11:18 11:19 11:23 11:24 11:25 11:27 11:28 11:29 11:33 11:39 11:41 11:43 11:45 11:48 11:53 11:55 11:57 12:15 12:16 12:20 12:24 12:26 12:29 12:30 12:33 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 12:35 12:36 12:37 12:41 12:42 12:49 12:55 12:59 13:04 13:08 13:09 13:11 13:17 13:18 13:23 13:25 13:26 13:27 13:32 13:33 13:37 13:40 13:41 13:45 13:46 13:50 13:52 13:55 13:59 14:00 14:04 14:05 14:10 14:14 14:17 14:23 14:27 14:28 14:29 14:34 14:37 14:40 14:44 14:47 14:49 14:57 15:07 15:10 15:15 15:16 15:21 15:32 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15:44 15:45 15:48 15:54 16:00 16:02 16:04 16:08 16:09 16:15 16:16 16:20 16:21 16:24 16:27 16:33 16:36 16:40 16:41 16:44 16:46 16:47 16:50 16:51 16:55 16:57 17:03 17:06 17:07 17:14 17:17 17:22 17:27 17:28 17:30 17:32 17:34 17:35 17:37 17:38 17:39 17:46 17:50 17:53 17:54 17:57 18:00 18:01 18:02 18:09 18:10 18:14 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 18:15 18:17 18:21 18:29 18:31 18:33 18:45 18:50 18:52 18:54 19:08 19:11 19:14 19:16 19:17 19:18 19:19 19:25 19:26 19:27 19:28 19:30 19:34 19:36 19:37 19:40 19:44 19:47 19:49 19:53 19:58 19:59 20:01 20:02 20:04 20:10 20:11 20:15 20:18 20:22 20:23 20:25 20:28 20:32 20:35 20:36 20:38 20:39 20:41 20:43 20:45 20:47 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 20:52 1 20:54 1 20:55 1 21:02 1 21:07 1 21:13 1 21:19 1 21:20 1 21:27 1 21:31 1 21:37 1 21:41 1 21:46 1 21:48 1 21:51 1 21:52 1 21:56 1 21:57 1 21:58 1 22:02 1 22:04 1 22:07 1 22:11 1 22:19 1 22:20 1 22:22 1 22:29 1 22:31 1 22:37 1 22:40 1 22:41 1 22:55 1 Grand Total 510 Average of Amount Region East North South West Product Book Online $ 59.34 $ 19.22 $ 42.96 $ 20.00 $ 58.13 $ 19.80 $ 54.16 $ 19.88

MIS13 Chapter 12 Hands-on MIS Exercise Online Managment Training Inc. Transaction Log: October 28 Cust ID 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 10014 10015 10016 10017 10018 10019 10020 10021 10022 10023 10024 10025 10026 10027 10028 10029 10030 10031 10032 10033 10034 10035 10036 10037 10038 10039 10040 10041 10042 10043 10044 10045 Region East West North West South West East West West South South East North East West West West West West West North West South West West West West South East West North East South West West East South East North South West West South South West Payment Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Paypal Paypal Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Paypal Paypal Paypal Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Source Web Web Web Email Web Email Web Web Web Web Email Web Web Web Web Web Email Web Web Web Email Web Email Web Email Email Web Web Web Email Email Web Web Web Web Web Web Web Web Web Web Web Web Web Web Amount $20.19 $17.85 $23.98 $23.51 $15.33 $17.30 $177.72 $21.76 $15.92 $23.39 $24.45 $20.39 $19.54 $151.67 $21.01 $22.91 $19.51 $20.16 $17.53 $17.74 $17.16 $205.58 $18.12 $20.04 $23.21 $22.79 $16.91 $20.22 $18.36 $206.80 $17.95 $18.29 $18.55 $18.82 $16.35 $16.30 $217 $16.15 $18.78 $150.99 $21.39 $16.60 $23.81 $15.87 $20.82 Product Online Online Online Book Book Online Book Book Online Online Book Book Online Book Online Online Book Book Online Online Book Book Book Online Online Online Online Book Online Book Online Book Book Book Book Online Book Online Online Book Online Online Book Book Online Time Of Day 22:19 13:27 14:27 15:38 15:21 13:11 21:59 4:04 19:35 13:26 14:17 1:01 10:04 9:09 5:05 20:29 15:03 18:54 20:00 12:37 5:05 20:42 10:12 16:27 20:22 19:58 19:44 19:28 15:48 18:14 15:15 12:59 17:38 2:02 14:05 4:04 0:00 10:28 5:05 7:07 19:20 16:23 7:07 13:46 9:09 10046 10047 10048 10049 10050 10051 10052 10053 10054 10055 10056 10057 10058 10059 10060 10061 10062 10063 10064 10065 10066 10067 10068 10069 10070 10071 10072 10073 10074 10075 10076 10077 10078 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 10090 10091 10092 10093 10094 10095 10096 10097 South South West West West East West North East East North West East East East West East South North North East East South South South West South West North East East South North West West North West South North East East East East North West East West West West North North West Credit Paypal Paypal Credit Paypal Paypal Credit Credit Credit Credit Paypal Paypal Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Paypal Paypal Credit Paypal Paypal Web Web Email Web Web Web Web Email Web Web Web Email Web Web Web Web Web Email Email Email Email Email Web Web Email Web Web Email Email Email Web Email Web Web Web Web Email Web Web Web Web Email Web Web Email Email Web Email Web Web Web Web $21.15 $19.66 $21.02 $23.13 $15.17 $209.51 $16.03 $16.17 $18.37 $15.96 $19.29 $16.49 $18.12 $18.22 $18.32 $23.77 $24.35 $20.13 $20.77 $16.98 $19.40 $23.49 $15.58 $21.94 $229.73 $16.06 $22.21 $21.58 $16.09 $16.10 $15.95 $17.77 $19.30 $21.75 $20.51 $16.14 $157.76 $21.55 $21.85 $21.70 $20.31 $23.62 $216.37 $21.99 $18.20 $17.31 $23.94 $174.25 $20.26 $18.73 $22.88 $19.15 Book Online Online Online Online Book Book Online Online Book Book Online Book Online Book Online Book Online Online Online Book Book Book Online Book Book Online Online Book Online Online Book Online Book Book Online Book Book Online Online Book Book Book Online Online Book Book Book Online Online Book Online 6:06 18:50 3:03 6:06 18:53 9:09 17:28 13:18 8:08 8:08 0:00 19:59 17:35 15:52 10:15 19:53 15:16 13:55 13:34 19:21 15:02 4:04 11:39 20:19 1:01 10:31 10:01 0:00 3:03 10:13 0:00 1:01 11:24 10:23 11:29 4:04 19:02 9:09 12:24 13:33 19:26 22:20 10:20 3:03 5:05 0:00 16:08 18:31 4:04 0:00 13:09 14:44 10098 10099 10100 10101 10102 10103 10104 10105 10106 10107 10108 10109 10110 10111 10112 10113 10114 10115 10116 10117 10118 10119 10120 10121 10122 10123 10124 10125 10126 10127 10128 10129 10130 10131 10132 10133 10134 10135 10136 10137 10138 10139 10140 10141 10142 10143 10144 10145 10146 10147 10148 10149 South West West East West North West East North North North West West East West North East East South North South East East North West West North South East West North West West South East West East South West West West East South West West West West East East East East West Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Paypal Paypal Credit Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Paypal Paypal Paypal Credit Credit Paypal Paypal Credit Credit Paypal Email Web Web Web Web Email Email Web Web Web Email Web Web Web Email Web Web Email Web Web Web Web Web Email Web Web Web Web Web Web Web Web Web Email Email Web Web Web Email Web Email Email Web Web Web Web Web Web Web Web Email Web $15.33 $20.82 $20.61 $16.43 $21.10 $21.64 $18.06 $19.35 $23.70 $18.93 $16.83 $22.19 $23.90 $17.47 $209.37 $18 $22.83 $20.31 $22.06 $15.22 $20.60 $18.25 $174.18 $19.58 $17.91 $22.90 $22.26 $19.04 $17.42 $18.54 $19.74 $22.03 $236.49 $19.30 $23.73 $19.96 $20.75 $22.37 $24.03 $24.59 $155.91 $16.43 $15.71 $15.19 $21.35 $19.47 $21.49 $22.20 $21.15 $15.16 $15.71 $24.65 Book Online Online Online Online Book Book Book Online Book Book Book Book Online Book Online Book Online Online Book Online Online Book Online Book Book Book Book Online Book Online Online Book Online Online Book Online Online Online Online Book Book Book Book Online Online Online Online Online Online Book Book 1:01 18:01 18:29 11:23 2:02 22:40 16:00 10:06 19:02 9:09 16:20 18:52 19:40 10:53 20:11 8:08 10:17 14:34 11:07 10:39 20:46 20:42 12:42 22:31 19:14 12:16 17:50 15:23 5:05 19:30 12:49 14:49 16:24 17:00 16:57 16:50 15:02 8:08 11:14 4:04 18:38 9:09 16:44 16:22 17:54 18:17 9:09 12:29 7:07 11:19 9:09 20:41 10150 10151 10152 10153 10154 10155 10156 10157 10158 10159 10160 10161 10162 10163 10164 10165 10166 10167 10168 10169 10170 10171 10172 10173 10174 10175 10176 10177 10178 10179 10180 10181 10182 10183 10184 10185 10186 10187 10188 10189 10190 10191 10192 10193 10194 10195 10196 10197 10198 10199 10200 10201 West East West South West East North South South West South North North West East West West North East West West North North West West East South West North West West East South West South West West West West North North South West East West West North West West South South North Paypal Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Paypal Paypal Paypal Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Paypal Credit Paypal Credit Credit Credit Email Email Web Web Web Web Web Web Web Email Email Web Web Web Web Email Web Web Web Web Web Web Web Web Web Email Web Web Web Web Web Email Web Email Email Web Web Web Web Web Web Web Web Email Web Web Web Web Web Web Email Email $24.88 $17.49 $19.71 $17.33 $15.56 $18.94 $22.86 $15.18 $22.46 $21.39 $22.17 $234.63 $24.97 $15.72 $24.35 $16.09 $23.51 $22.59 $15.59 $190.81 $21.12 $24.60 $21.22 $21.78 $16.54 $177.32 $21.50 $24.65 $19.43 $21.12 $18.10 $24.40 $19.37 $19.17 $241.77 $19.65 $19.88 $15.18 $15.08 $23.74 $19.44 $17.70 $16.99 $16.13 $24.80 $17.52 $23.63 $23.03 $21.03 $21.88 $24.86 $21.43 Book Book Online Book Online Online Book Book Book Book Online Book Book Book Book Book Book Book Online Book Book Online Online Online Online Book Book Online Online Online Online Book Book Online Book Book Book Online Book Book Book Online Online Book Online Book Book Online Online Book Book Online 15:23 21:46 7:07 2:02 21:07 20:00 16:02 6:06 17:44 17:17 10:23 9:09 22:11 10:53 8:08 8:08 16:18 16:51 9:09 21:57 16:40 20:38 12:20 7:07 17:52 15:52 10:53 20:45 9:09 20:13 20:32 13:25 21:48 0:00 9:09 20:46 8:08 12:30 12:15 5:05 9:09 2:02 17:34 13:37 20:28 20:35 19:47 11:27 19:18 3:03 17:27 7:07 10202 10203 10204 10205 10206 10207 10208 10209 10210 10211 10212 10213 10214 10215 10216 10217 10218 10219 10220 10221 10222 10223 10224 10225 10226 10227 10228 10229 10230 10231 10232 10233 10234 10235 10236 10237 10238 10239 10240 10241 10242 10243 10244 10245 10246 10247 10248 10249 10250 10251 10252 10253 South East North South South East West West East South West South North East East West West East West West West East West West West South West West North North East West North East West West West South South East East West West South West West West West North South North East Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Paypal Credit Paypal Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Paypal Credit Credit Web Web Web Web Web Web Email Web Web Web Email Email Web Web Web Web Web Email Web Web Web Email Web Email Web Web Web Web Email Web Email Web Web Web Email Email Web Web Web Web Web Web Email Email Web Email Web Email Email Web Web Email $16.32 $17.20 $17.87 $17.27 $19.76 $17.10 $15.66 $22.37 $15.81 $18.75 $192.41 $242.52 $20.40 $24.71 $21.49 $22.26 $22.39 $21.01 $226.15 $20.67 $21.72 $16.34 $19.19 $19.21 $16.06 $20.87 $15.33 $23.58 $15.34 $216.20 $21.85 $23.59 $20.44 $22.05 $20.42 $20.49 $161.46 $19.69 $24.16 $22.80 $243.70 $210.38 $161.50 $21.92 $23.75 $23.74 $21.67 $22.04 $17.83 $23.60 $19.90 $209.20 Online Online Online Online Book Book Book Book Online Online Book Book Book Online Online Online Book Book Book Book Online Book Book Online Book Online Online Online Book Book Online Book Book Online Book Online Book Online Book Online Book Book Book Online Online Online Book Book Online Book Book Book 15:09 0:00 7:07 7:07 21:13 6:06 11:18 16:21 12:26 2:02 20:23 9:09 0:00 12:45 8:08 5:05 16:16 8:08 16:41 19:27 20:04 17:53 19:08 2:02 17:30 13:41 5:05 2:02 10:08 10:33 14:28 3:03 11:52 8:08 0:00 20:10 14:23 4:04 2:02 10:59 20:26 12:19 16:15 6:06 20:34 3:03 12:41 3:03 12:55 2:02 14:04 17:19 10254 10255 10256 10257 10258 10259 10260 10261 10262 10263 10264 10265 10266 10267 10268 10269 10270 10271 10272 10273 10274 10275 10276 10277 10278 10279 10280 10281 10282 10283 10284 10285 10286 10287 10288 10289 10290 10291 10292 10293 10294 10295 10296 10297 10298 10299 10300 10301 10302 10303 10304 10305 East West West East North South East East West South South West West West East North East North East South West West West South South West South West South South South West West West South South East West East West West East East North East East South West West West South West Credit Credit Paypal Credit Paypal Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Credit Credit Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Paypal Credit Paypal Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Email Web Email Web Web Web Web Web Web Web Web Web Email Web Email Web Web Email Web Web Web Web Web Web Web Web Web Email Email Web Web Web Web Web Web Web Web Email Web Email Web Web Web Web Email Web Web Email Web Web Email Web $24 $17.81 $24.77 $21 $191.43 $24.52 $17.34 $17.19 $22.55 $15.35 $23.20 $241.65 $242.40 $23.01 $17.22 $15.96 $15.45 $17.41 $21.64 $157.86 $18.17 $18.73 $17.24 $23.91 $22.12 $15.25 $24.77 $20.28 $20.33 $16.90 $16.47 $21.18 $15.86 $24.42 $222.38 $188.85 $15.32 $24.71 $20.97 $21.92 $15.40 $23.08 $23.40 $22.65 $24.61 $24.97 $18.57 $16.15 $19.95 $15.61 $19.13 $231.23 Book Book Online Online Book Online Online Book Book Online Book Book Book Online Online Online Online Online Book Book Online Book Book Online Book Online Book Book Online Book Book Book Book Book Book Book Book Book Book Online Book Book Online Book Book Book Book Online Book Online Book Book 11:52 12:36 0:00 17:14 16:36 21:59 8:08 3:03 11:43 10:15 15:38 20:39 17:19 17:44 1:01 1:01 9:09 5:05 10:39 5:05 16:09 20:18 20:47 13:59 17:31 19:11 0:00 6:06 8:08 21:41 16:22 15:10 18:00 1:01 18:53 5:05 9:09 16:22 11:17 19:17 17:16 7:07 1:01 6:06 13:08 16:53 12:45 3:03 19:35 22:02 22:55 0:00 10306 10307 10308 10309 10310 10311 10312 10313 10314 10315 10316 10317 10318 10319 10320 10321 10322 10323 10324 10325 10326 10327 10328 10329 10330 10331 10332 10333 10334 10335 10336 10337 10338 10339 10340 10341 10342 10343 10344 10345 10346 10347 10348 10349 10350 10351 10352 10353 10354 10355 10356 10357 East South West South North South West West South East East South West West North South West North South South East West South South North West West East North East South West North West West West West North East West West East South East West North West West South East North South Credit Paypal Credit Credit Paypal Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Paypal Credit Paypal Credit Paypal Paypal Paypal Credit Paypal Credit Paypal Paypal Paypal Paypal Credit Credit Paypal Paypal Credit Paypal Credit Email Web Web Email Email Web Web Email Web Web Web Web Email Email Web Email Web Web Web Web Email Email Email Email Email Web Email Web Web Web Web Web Email Web Email Web Email Web Web Web Email Email Email Web Web Email Web Web Web Web Web Email $244.75 $21.36 $21.83 $21.58 $17.51 $23.29 $18.35 $23.06 $19.81 $162.74 $16.86 $23.31 $22.92 $22.84 $16.97 $188.16 $22.57 $24.71 $246.67 $20.97 $19.83 $19.09 $16.52 $22.31 $19.52 $24.79 $18.84 $24.58 $17.19 $19.65 $17.35 $22.92 $18.81 $20.08 $24.54 $24.81 $15.94 $18.29 $15.55 $19.20 $17.34 $22.51 $23.45 $16.15 $17.68 $22.11 $18.41 $17.08 $15.77 $22.41 $20.63 $18.14 Book Online Book Online Book Online Book Online Online Book Online Book Book Online Online Book Online Online Book Book Book Book Book Book Online Online Online Online Book Book Book Online Online Book Book Book Online Online Online Online Online Online Online Online Book Book Online Online Online Book Online Book 10:13 20:25 1:01 1:01 20:19 4:04 20:54 11:48 21:19 9:09 9:09 16:23 0:00 17:37 4:04 19:21 18:45 13:34 16:47 8:08 4:04 11:45 6:06 2:02 0:00 9:09 22:04 0:00 12:19 6:06 21:37 16:23 7:07 3:03 4:04 14:40 0:00 8:08 6:06 20:52 18:10 5:05 2:02 13:45 0:00 11:28 1:01 17:06 10:36 7:07 3:03 3:03 10358 10359 10360 10361 10362 10363 10364 10365 10366 10367 10368 10369 10370 10371 10372 10373 10374 10375 10376 10377 10378 10379 10380 10381 10382 10383 10384 10385 10386 10387 10388 10389 10390 10391 10392 10393 10394 10395 10396 10397 10398 10399 10400 10401 10402 10403 10404 10405 10406 10407 10408 10409 North West South North South South West West East East West East North North West West North West South East South North West West South West South West West North South North East West East South West West West West West East West West West South North North East North South West Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Paypal Paypal Credit Paypal Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Credit Credit Credit Web Email Web Web Email Web Email Web Web Web Web Web Web Web Web Web Web Web Email Web Web Email Web Web Web Web Web Web Web Email Email Email Web Web Web Email Email Web Web Web Web Web Web Web Web Email Web Web Web Web Web Web $20.18 $177.30 $15.71 $21.75 $18.25 $203.72 $15.54 $17.50 $21.32 $150.86 $17.39 $23.87 $21.53 $19.64 $18.27 $19.27 $20.16 $15.59 $16.34 $199.18 $19.99 $18.44 $23.75 $20.88 $197.43 $20.32 $16.82 $20.16 $16.79 $22.53 $21.68 $23.54 $17.67 $22.79 $24.80 $15.27 $18.74 $16.47 $18.11 $20.73 $21.64 $17.38 $17.70 $24.66 $24.24 $19.79 $16.86 $19.97 $22.99 $153.83 $15.20 $16.01 Book Book Online Online Book Book Book Online Book Book Book Online Book Online Book Online Book Online Online Book Book Online Book Online Book Book Online Book Book Book Book Book Online Book Book Book Book Online Online Online Online Book Online Book Online Book Online Online Book Book Online Online 11:13 11:33 5:05 17:22 5:05 14:29 19:36 5:05 2:02 13:17 4:04 13:52 16:04 16:14 18:39 6:06 14:38 4:04 12:35 14:00 20:29 18:38 9:09 0:00 10:43 18:33 8:08 13:40 21:27 11:41 14:32 6:06 9:09 0:00 18:09 8:08 22:41 20:26 0:00 17:46 16:11 16:14 7:07 17:07 19:16 7:07 8:08 22:37 9:09 15:07 15:03 20:02 10410 10411 10412 10413 10414 10415 10416 10417 10418 10419 10420 10421 10422 10423 10424 10425 10426 10427 10428 10429 10430 10431 10432 10433 10434 10435 10436 10437 10438 10439 10440 10441 10442 10443 10444 10445 10446 10447 10448 10449 10450 10451 10452 10453 10454 10455 10456 10457 10458 10459 10460 10461 West South East North North West North North West East West South North West East North North West North West East West North North West South West South South East South North West South West West East North North North West West North North West South East West South South West South Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Credit Credit Web Email Web Web Web Web Web Web Web Web Web Email Web Email Web Web Email Web Web Web Web Web Email Email Email Web Web Web Email Web Web Email Web Email Web Web Web Web Web Web Email Web Web Web Web Web Web Web Web Web Web Web $18.88 $21.54 $24.11 $21.43 $24.80 $19.76 $23.97 $19.96 $18.19 $17.28 $24.84 $16.32 $23.47 $16.65 $22.64 $16.66 $21.78 $21.29 $160.78 $21.10 $169.79 $16.99 $23.64 $18.92 $23.96 $18.53 $24.44 $21.81 $18.25 $17.42 $18.40 $23.88 $17.76 $23.06 $18.87 $17.87 $18.77 $18.60 $152.27 $20.83 $21.47 $218.60 $163.37 $24.78 $17.01 $231.23 $22.57 $24.16 $20.68 $21.20 $247.14 $19.10 Online Book Book Book Online Online Online Online Book Online Book Book Book Book Book Book Book Online Book Book Book Book Online Book Book Book Online Online Online Book Book Online Book Book Book Online Book Online Book Book Book Book Book Book Book Book Online Online Book Online Book Book 17:57 19:37 0:00 8:08 0:00 20:15 18:39 11:25 1:01 15:45 8:08 13:50 17:00 19:19 11:53 2:02 14:10 14:14 14:47 14:38 20:13 3:03 8:08 13:23 7:07 21:20 5:05 5:05 15:54 1:01 10:25 3:03 14:37 11:57 16:33 16:11 15:09 0:00 6:06 16:46 17:52 12:33 16:55 21:56 7:07 20:26 15:02 11:02 21:51 7:07 17:16 13:04 10462 10463 10464 10465 10466 10467 10468 10469 10470 10471 10472 10473 10474 10475 10476 10477 10478 10479 10480 10481 10482 10483 10484 10485 10486 10487 10488 10489 10490 10491 10492 10493 10494 10495 10496 10497 10498 10499 10500 10501 10502 10503 10504 10505 10506 10507 10508 10509 10510 South East West West East South South North West West North West West West North West West West West West East North West West West West South West North South South West West West North West East South West North North West West South South West South East North Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Credit Paypal Paypal Credit Credit Credit Paypal Paypal Credit Paypal Paypal Paypal Credit Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Paypal Credit Web Web Email Web Email Web Email Email Email Web Web Email Web Web Web Email Web Web Web Web Web Email Email Web Web Email Web Email Web Email Email Web Email Web Email Email Web Email Web Email Web Web Web Web Web Web Web Web Web $19.02 $19.66 $168.10 $16.83 $23.89 $16.73 $22.05 $17.88 $15.18 $15.62 $20.58 $17.28 $24.38 $15.70 $16.64 $16.77 $22.06 $15.06 $17.70 $24.63 $17.98 $22.56 $17.95 $17.94 $15.72 $15.26 $15.33 $18.88 $18.51 $18.73 $18.69 $18.29 $24.97 $22.91 $16.62 $21.73 $15.92 $20.77 $228.08 $22.14 $17.73 $22.28 $19.92 $17.83 $16.35 $23.70 $22.02 $23.53 $24.63 $19,801.61 Online Book Book Book Book Online Online Book Online Online Online Online Online Book Book Book Book Online Book Book Book Book Book Online Online Online Online Book Book Online Online Online Online Book Book Book Online Book Book Book Book Online Book Online Book Book Online Online Book 22:07 1:01 16:22 8:08 0:00 19:20 10:27 6:06 19:25 3:03 18:02 17:32 8:08 1:01 21:58 18:15 18:21 21:31 19:49 19:34 8:08 13:32 17:03 15:44 16:18 20:34 22:22 0:00 15:38 9:09 14:32 21:02 15:32 20:36 9:09 17:31 0:00 20:55 14:57 20:01 5:05 17:39 16:53 6:06 22:29 20:43 11:55 21:52 4:04 Average of Amount Region East North South West Average of Amount Total $ 41.86 $ 32.48 $ 60.57 $ 38.08 $ 42.49 Sum of Amount Payment Credit Paypal Grand Total Total $ 12,693 $ 7,109 $ 19,802 Count of Cust iD Time Of Day Total 0:00 27 9:09 24 8:08 23 5:05 18 7:07 16 1:01 15 3:03 15 6:06 15 4:04 14 2:02 13 16:22 4 10:53 3 15:02 3 15:38 3 16:23 3 20:26 3 10:13 2 10:15 2 10:23 2 10:39 2 11:52 2 12:19 2 12:45 2 13:34 2 14:32 2 14:38 2 15:03 2 15:09 2 15:23 2 15:52 2 16:11 2 16:14 2 16:18 2 16:53 2 17:00 2 17:16 2 17:19 2 17:31 2 17:44 2 17:52 2 18:38 2 18:39 2 18:53 2 19:02 2 19:20 2 19:21 2 19:35 2 20:00 2 20:13 20:19 20:29 20:34 20:42 20:46 21:59 10:01 10:04 10:06 10:08 10:12 10:17 10:20 10:25 10:27 10:28 10:31 10:33 10:36 10:43 10:59 11:02 11:07 11:13 11:14 11:17 11:18 11:19 11:23 11:24 11:25 11:27 11:28 11:29 11:33 11:39 11:41 11:43 11:45 11:48 11:53 11:55 11:57 12:15 12:16 12:20 12:24 12:26 12:29 12:30 12:33 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 12:35 12:36 12:37 12:41 12:42 12:49 12:55 12:59 13:04 13:08 13:09 13:11 13:17 13:18 13:23 13:25 13:26 13:27 13:32 13:33 13:37 13:40 13:41 13:45 13:46 13:50 13:52 13:55 13:59 14:00 14:04 14:05 14:10 14:14 14:17 14:23 14:27 14:28 14:29 14:34 14:37 14:40 14:44 14:47 14:49 14:57 15:07 15:10 15:15 15:16 15:21 15:32 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15:44 15:45 15:48 15:54 16:00 16:02 16:04 16:08 16:09 16:15 16:16 16:20 16:21 16:24 16:27 16:33 16:36 16:40 16:41 16:44 16:46 16:47 16:50 16:51 16:55 16:57 17:03 17:06 17:07 17:14 17:17 17:22 17:27 17:28 17:30 17:32 17:34 17:35 17:37 17:38 17:39 17:46 17:50 17:53 17:54 17:57 18:00 18:01 18:02 18:09 18:10 18:14 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 18:15 18:17 18:21 18:29 18:31 18:33 18:45 18:50 18:52 18:54 19:08 19:11 19:14 19:16 19:17 19:18 19:19 19:25 19:26 19:27 19:28 19:30 19:34 19:36 19:37 19:40 19:44 19:47 19:49 19:53 19:58 19:59 20:01 20:02 20:04 20:10 20:11 20:15 20:18 20:22 20:23 20:25 20:28 20:32 20:35 20:36 20:38 20:39 20:41 20:43 20:45 20:47 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 20:52 1 20:54 1 20:55 1 21:02 1 21:07 1 21:13 1 21:19 1 21:20 1 21:27 1 21:31 1 21:37 1 21:41 1 21:46 1 21:48 1 21:51 1 21:52 1 21:56 1 21:57 1 21:58 1 22:02 1 22:04 1 22:07 1 22:11 1 22:19 1 22:20 1 22:22 1 22:29 1 22:31 1 22:37 1 22:40 1 22:41 1 22:55 1 Grand Total 510 Average of Amount Region East North South West Product Book Online $ 59.34 $ 19.22 $ 42.96 $ 20.00 $ 58.13 $ 19.80 $ 54.16 $ 19.88

Chapter 12 Running Case Assignment: Improving Decision Making: Analyzing the Impact of Component Price Changes Software skills: Spreadsheet formulas, two-variable data table Business skills: Manufacturing bill of materials sensitivity analysis A bill of materials is used in manufacturing and production to show all of the parts and materials required to manufacture a specific item or

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 12: Enhancing Decision Making Learning Track 1: Building and Using Pivot Tables Spreadsheet software is useful for helping managers detect and ­understand patterns in data. For instance, let’s a take a look at one day’s worth of transactions at

Bill of Materials: Moto 300 Brake System Component Brake cable Brake pedal Brake pad Front brake pump Rear brake pump Front brake caliper Rear brake caliper Front brake disc Rear brake disc Brake pipe Brake lever cover Component No. M0593 M0546 M3203 M0959 M4739 M5930 M7942 M3920 M0588 M0943 M1059 Source Nissin Harrison Billet Russell Brembo Brembo Nissin Nissin Russell Russell Harrison Billet Brembo Unit Cost Quantity Extended Cost 27.81 1 6.03 2 27.05 2 66.05 1 54.00 1 105.20 1 106.78 1 143.80 1 56.42 1 28.52 1 2.62 1

Chapter 12 Running Case Solution Bill of Materials: Moto 300 Brake System Component Brake cable Brake pedal Brake pad Front brake pump Rear brake pump Front brake caliper Rear brake caliper Front brake disc Rear brake disc Brake pipe Brake lever cover Total brake system materials cost Front brake caliper cost Total materials cost Front brake caliper cost Component No. M0593 M0546 M3203 M0959 M4739 M5930 M7942 M3920 M0588 M0943 M1059 Source Unit Cost Quantity Extended Cost Nissin 27.81 1 27.81 Harrison Billet 6.03 2 12.06 Russell 27.05 2 54.10 Brembo 66.05 1 66.05 Brembo 54.00 1 54.00 Nissin 105.20 1 105.20 Nissin 106.78 1 106.78 Russell 143.80 1 143.80 Russell 56.42 1 56.42 Harrison Billet 28.52 1 28.52 Brembo 2.62 1 2.62 TOTAL BRAKE SYSTEM MATERIALS COST 657.36 657.36 103 104 105 106 107 27 653.64 654.64 655.64 656.64 657.64 Brake

Chapter 13 Hands-on MIS Application Solution Description Students will have to perform a systems analysis and then design a system solution using database software. They will need to identify information requirements and then map out entities, attributes, and relationships to guide the design of database tables. Ace maintains a very rudimentary customer database that

Chapter 13 Hands-on MIS Ace Auto Dealers Additional Information Ace Auto Dealers specializes in selling new vehicles from Subaru in Portland, Oregon. The company advertises in local newspapers and is also listed as an authorized dealer on the Subaru Web site and other major Web sites for auto buyers. The company benefits from a

Employees with Special Training Course_Name Last_Name First_Name Emp_SS# Position Date_Completed Munoz Luis 012-34-5678 Assembler 3/2/2010 O'Donnell James 567-89-0123 Tester 3/2/2010 Franz George 890-12-3456 Designer 6/23/2011 Kamp Timothy 789-01-2345 Sales Rep 6/28/2009 Lattimore Joseph 123-45-6789 Painter 3/1/2009 Munoz Luis 012-34-5678 Assembler 3/1/2009 Norwick Robert 456-78-9012 Shipping Clerk 3/1/2006 Stokes Brian 987-65-4321 Marketing CAD-Advanced Project Management Tuesday, May 23, 2023 6/28/2011 Page 1 of 1 Employees with Special Training Course_Name Last_Name First_Name Emp_SS# Position Date_Completed Munoz Luis 012-34-5678 Assembler 3/2/2010 O'Donnell James 567-89-0123 Tester 3/2/2010 Franz George 890-12-3456 Designer 6/23/2011 Kamp Timothy 789-01-2345 Sales Rep 6/28/2009 Lattimore Joseph 123-45-6789 Painter 3/1/2009 Munoz Luis 012-34-5678 Assembler 3/1/2009 Norwick Robert 456-78-9012 Shipping Clerk 3/1/2006 Stokes Brian 987-65-4321 Marketing CAD-Advanced Project Management Tuesday, May 23, 2023 6/28/2011 Page 1 of 1 Employee Training History Last_Name First_Name Emp_SS# Munoz Luis 012-34-567 Course_Name Project Management Lattimore Joseph Patricia 12/1/2011 CAD-Advanced 3/2/2010 123-45-678 Carlos 3/1/2009 Powerpoint 6/4/2011 Word for Dummies 8/2/2010 234-56-789 Getting to Yes Robert Project Management James Richard Franz Timothy George 3/1/2006 CAD-Advanced 3/2/2010 Powerpoint 6/4/2009 567-89-012 12/12/2011 678-90-123 3/2/2010 789-01-234 Getting to Yes 10/1/2010 Project Management 6/28/2009 890-12-345 Sellling Yourself Tuesday, May 23, 2023 12/12/2011 10/1/2010 CAD Kamp 10/1/2010 Getting to Yes Word for Dummies Morrissey 3/2/2010 456-78-901 Word for Dummies O'Donnell 11/12/2010 345-67-890 CAD Norwick 2/22/2009 Project

Emp_SS# Last_Name First_Name Street 012-34-5678 Munoz Luis 11 Ram Ridge 123-45-6789 Lattimore 234-56-7890 Artis 345-67-8901 Renaldo Joseph Patricia Carlos 302 Garden St. 45 William St. 793 Ridge Rd. 456-78-9012 Norwick Robert 10 Webb St. 567-89-0123 O'Donnell 678-90-1234 Morrissey 789-01-2345 Kamp James Richard Timothy 56 Mountainview 93 Pond Drive 39 Brook Dr. 890-12-3456 Franz George 8 Powder Tr. 901-23-4567 Collins Dawn 9 Young Ave. 987-65-4321 Stokes Brian 5 Saddle Tr. City Carbondal e Carbondal e Basalt Basalt Carbondal e Carbondal e Basalt Basalt Carbondal e Glenwood Spring Carbondal e State Zip Telephone Birth_Date Marital Position Salary CO 81623 970-945-4338 29-Aug-71 M Assembler $39,000.00 CO CO CO 81623 81621 81621 970-945-7002 970-945-0087 970-945-1883 03-Jul-72 S 11-Apr-73 S 08-May-69 M Painter Secretary Welder $35,000.00 $29,000.00 $41,200.00 CO 81623 970-945-5654 01-Sep-70 M Shipping Clerk $32,500.00 CO CO CO 81623 81621 81621 970-945-3021 970-945-2838 970-945-5944 09-Feb-69 M 30-Jan-60 D 27-Jun-64 M Tester Engineer Sales Rep $37,000.00 $51,000.00 $43,500.00 CO 81623 970-945-9304 21-Sep-64 S Designer $55,000.00 CO 81602 970-945-2648 03-Nov-74 S Assembler $32,000.00 CO 81623 970-945-8943 14-May-63 D Marketing $49,500.00 CustomerID Last Name

Managing the Digital Firm, Seventh Canadian Edition or must be reworked for a production environment. The problem arises when the prototype is adopted as the production version of the system without careful analysis and validation. Prototypes are built so rapidly that documentation and testing are glossed over. The system is so easily changed that

Cust_ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Last Name Flynn Bauer DelFino Hardman Yang Kozlowski Rodriguez Stillman Nagel Sheridan Venable Spadafino Ng Nielsen Downey St. John Keating Melman Grote Tripper First Name Colleen Richard Joseph Pauline Walter Peter Elena Charles Ellen Amy Stephen Anthony Victor Elizabeth Joseph Bettye Christopher Jonathan Teresa Benjamin Street 44 Hastings Ave. 322 Scenic Drive 119 Young Ave. 57 Beekman Road 83 Hunter's Trail 92 Mountain Road 751 Lounsbury Ave. 82 County Road 901 Forest Road 29 Glen Ridge 653 Ridge Road 43 8th Ave. 72 Lincoln Pl. 67 Forest Trail 12 Monica Court 893 Pleasant Ave. 95 Roundhill Road 42 College Dr. 69 Rocky Hill 723 Pine St. City Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland State OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR Zip 97223-0974 97253-9944 97202-4432 97269-0055 97299-9453 97266-0482 97228-0516 97269-5043 97253-9540 97299-5903 97223-4921 97202-4320 97266-2039 97228-8522 97255-6902 97250-5030 97223-4939 97228-3094 97202-5926 97223-9504 Telephone 503-665-5594 503-297-4493 503-668-5503 503-789-9143 503-789-1742 503-297-5780 503-297-7921 503-789-4032 503-297-5021 503-789-4920 503-665-2943 503-668-2399 503-297-5927 503-297-7020 503-668-3901 503-665-2935 503-665-1194 503-297-8925 503-668-3049 503-665-4929

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 13: Building Information Systems Learning Track 3: Primer on Business Process Management Many businesses do not have a clear conception of what business processes exist in their firms, how they work, or how much they cost. In a recent

Chapter 13 Running Case Assignment: Achieving Operational Excellence: Designing an Employee Training and Skills Tracking System and Database Software skills: Database design, querying, and reporting Business skills: Employee training and skills tracking This project requires you to perform a systems analysis and then design a system solution using database software. Dirt Bikes promotes itself as a

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 13: Building Information Systems Learning Track 2: A Primer on Business Process Design and Documentation Why Business Process Design Is Important “Business process design has a long history in American management. In today’s digital environment, over 80% of the $800

tblCustomer_Prospect Cust_ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Last Name Flynn Bauer DelFino Hardman Yang Kozlowski Rodriguez Stillman Nagel Sheridan Venable Spadafino Ng Nielsen Downey St. John Keating Melman Grote Tripper First Name Colleen Richard Joseph Pauline Walter Peter Elena Charles Ellen Amy Stephen Anthony Victor Elizabeth Joseph Bettye Christopher Jonathan Teresa Benjamin Street 44 Hastings Ave. 322 Scenic Drive 119 Young Ave. 57 Beekman Road 83 Hunter's Trail 92 Mountain Road 751 Lounsbury Ave. 82 County Road 901 Forest Road 29 Glen Ridge 653 Ridge Road 43 8th Ave. 72 Lincoln Pl. 67 Forest Trail 12 Monica Court 893 Pleasant Ave. 95 Roundhill Road 42 College Dr. 69 Rocky Hill 723 Pine St. City Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland Portland State OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR OR Zip 97223-0974 97253-9944 97202-4432 97269-0055 97299-9453 97266-0482 97228-0516 97269-5043 97253-9540 97299-5903 97223-4921 97202-4320 97266-2039 97228-8522 97255-6902 97250-5030 97223-4939 97228-3094 97202-5926 97223-9504 Telephone Made_Purchase Touchpoint 503-665-5594 TRUE Web 503-297-4493 FALSE Ad 503-668-5503 TRUE Mouth 503-789-9143 TRUE Ad 503-789-1742 FALSE Web 503-297-5780 TRUE Ad 503-297-7921 FALSE

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 13 Developing Information Systems LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. 2. 3. 4. 5. How does developing new information systems produce organizational change? What are the core activities in the information systems development process? What are the principal methodologies for modelling and designing systems? What

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 13: Building Information Systems Learning Track 1: A Primer on Business Process Design and Documentation Object-oriented development can be used to improve system quality and flexibility. A number of techniques for the analysis and design of object-­oriented systems have been

Chapter 13 Running Case Solution Description Students will have to perform a systems analysis and then design a system solution using database software. They will need to identify information requirements and then map out entities, attributes, and relationships to guide the design of database tables. They will need to populate the database and generate

Estimated Costs & Benefits - New Training System Year 0 2012 Costs Development Business staff IS staff Data conversion Sub Total Maintenance and Support Data entry Maintenance and support Sub Total Total Costs 1 2013 2 2014 3 2015 4 2016 5 2017 $1,000.00 $3,000.00 $4,000.00 $1,000.00 $3,000.00 $4,000.00 $1,000.00 $3,000.00 $4,000.00 $1,000.00 $3,000.00 $4,000.00 $1,000.00 $3,000.00 $4,000.00 $1,850.00 $2,100.00 $11,000.00 $14,950.00 $1,850.00 $2,100.00 $11,000.00 $14,950.00 $1,850.00 $2,100.00 $11,000.00 $14,950.00 $1,850.00 $2,100.00 $11,000.00 $14,950.00 $1,850.00 $2,100.00 $11,000.00 $14,950.00 $10,950.00 $10,950.00 $10,950.00 $10,950.00 $10,950.00 $5,000.00 $15,000.00 $5,500.00 $25,500.00 $45,500.00 Benefits Reduced labor costs HR Staff 1 @$37000 annually HR Staff 2 @ 42000 annually Reduced recruiting costs @11000 annually Sub Total Net Cash Flow -$25,500.00 Total Benefits $74,750.00 Assume HR Staff work officially 50 weeks and 2000 hours per year Financial Models Year 0 Net

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 14: Managing Projects Learning Track 2: Information Technology Investments and Productivity Information technology now accounts for about 35 to 50 percent of total business capital investment in the United States. Whether this investment has translated into genuine productivity gains remains open

Chapter 14 Running Case Assignment: Improving Decision Making: Using Spreadsheet Software to Analyze the Return on a New System Investment Software skills: Spreadsheet formulas and functions Business skills: Capital budgeting This project provides you with an opportunity to use spreadsheet software to use the capital budgeting models discussed in this chapter to analyze the return

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 14 Project Management, Business Value, and Managing Change LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. What are the objectives of project management, and why it is so essential in developing information systems? 2. What methods can be used for selecting and

MIS13 Chapter 14 Solution File Estimated Costs & Benefits - New AutoCAD Department Year Costs Quantity Hardware PCs Network cards Servers Color laser printers Plotters Telecommunications Backup Unit Cabling w/plugs (in feet) Routers w/firewall Switches Telephone connection costs Software Licenses CAD software Database Network Office software 0 1 2 3 4 5 2012 2013 2014 2015 2016 2017 Cost/Unit 50 50 2 3 2 $1,700.00 $50.00 $3,000.00 $5,500.00 $3,100.00 Subtotal $85,000.00 $2,500.00 $6,000.00 $16,500.00 $6,200.00 $116,200.00 $5,000.00 $500.00 $1,000.00 $500.00 $500.00 $7,500.00 $5,000.00 $500.00 $1,000.00 $500.00 $500.00 $7,500.00 $5,000.00 $500.00 $1,000.00 $500.00 $500.00 $7,500.00 $5,000.00 $500.00 $1,000.00 $500.00 $500.00 $7,500.00 $5,000.00 $500.00 $1,000.00 $500.00 $500.00 $7,500.00 1 2,000 2 2 $1,200.00 $0.75 $500.00 $700.00 $5,000.00 Subtotal $1,200.00 $1,500.00 $1,000.00 $1,400.00 $5,000.00 $10,100.00 $500.00 $100.00 $100.00 $100.00 $1,000.00 $1,800.00 $500.00 $100.00 $100.00 $100.00 $1,000.00 $1,800.00 $500.00 $100.00 $100.00 $100.00 $1,000.00 $1,800.00 $500.00 $100.00 $100.00 $100.00 $1,000.00 $1,800.00 $500.00 $100.00 $100.00 $100.00 $1,000.00 $1,800.00 50 50 50 50 $3,500.00 $80.00 $70.00 $250.00 Subtotal $175,000.00 $4,000.00 $3,500.00 $12,500.00 $195,000.00 $1,000.00 $500.00 $500.00 $1,000.00 $3,000.00 $1,000.00 $500.00 $500.00 $1,000.00 $3,000.00 $1,000.00 $500.00 $500.00 $1,000.00 $3,000.00 $1,000.00 $500.00 $500.00 $1,000.00 $3,000.00 $1,000.00 $500.00 $500.00 $1,000.00 $3,000.00 1 50 1 $50,000.00 $75.00 $75,000.00 Subtotal $50,000.00 $3,750.00 $75,000.00 $128,750.00 $40,000.00 $30,000.00 $1,000.00 $1,000.00 $75,000.00 $76,000.00 $116,000.00 $107,000.00 $20,000.00 $1,000.00 $77,000.00 $98,000.00 $10,000.00 $1,000.00 $79,000.00 $90,000.00 $10,000.00 $1,000.00 $82,000.00 $93,000.00 Services In-House trainer AutoCAD training hours/user In-House systems personnel Total Costs by Year Total Costs Benefits Reduced Labor Costs Increased Gross Revenue $450,050.00 $1,015,550.00 $128,300.00 $119,300.00 $110,300.00 $102,300.00 $105,300.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $150,000.00 $150,000.00

MIS13 Chapter 14 Question File The following Tables 1 and 2 show each cost component for the new CAD system as well as annual maintenance costs over a five-year period. Table 1 – CAD System Components Year 0 Costs Item Quantity Cost/each Hardware PCs 50 $1,700 Network Cards 50 $50 Servers 2 $3,000 Color Laser Printers 3 $5,500 Color Laser Plotters 2 $3,100 Telecommunications Backup Unit Cabling w/plugs Routers w/Firewall Switches Telephone Connection Costs Software CAD Software Database Network Office Software Services In-house Trainer AutoCAD Training In-house

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 14: Managing Projects Learning Track 1: Capital Budgeting Methods for Information System Investments Traditional Capital Budgeting Models Capital budgeting models are one of several techniques used to measure the value of investing in long-term capital investment projects. The process of analyzing

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 14: Managing Projects Learning Track 3: Enterprise Analysis (Business Systems Planning) Establishing Organizational Information Requirements To develop an effective information systems plan, the organization must have a clear understanding of both its long- and short-term information requirements. Two principal methodologies

MIS13 Chapter 14 Solution File Estimated Costs & Benefits - New AutoCAD Department Year Costs Quantity Hardware PCs Network cards Servers Color laser printers Plotters Telecommunications Backup Unit Cabling w/plugs (in feet) Routers w/firewall Switches Telephone connection costs Software Licenses CAD software Database Network Office software 0 1 2 3 4 5 2012 2013 2014 2015 2016 2017 Cost/Unit 50 50 2 3 2 $1,700.00 $50.00 $3,000.00 $5,500.00 $3,100.00 Subtotal $85,000.00 $2,500.00 $6,000.00 $16,500.00 $6,200.00 $116,200.00 $5,000.00 $500.00 $1,000.00 $500.00 $500.00 $7,500.00 $5,000.00 $500.00 $1,000.00 $500.00 $500.00 $7,500.00 $5,000.00 $500.00 $1,000.00 $500.00 $500.00 $7,500.00 $5,000.00 $500.00 $1,000.00 $500.00 $500.00 $7,500.00 $5,000.00 $500.00 $1,000.00 $500.00 $500.00 $7,500.00 1 2,000 2 2 $1,200.00 $0.75 $500.00 $700.00 $5,000.00 Subtotal $1,200.00 $1,500.00 $1,000.00 $1,400.00 $5,000.00 $10,100.00 $500.00 $100.00 $100.00 $100.00 $1,000.00 $1,800.00 $500.00 $100.00 $100.00 $100.00 $1,000.00 $1,800.00 $500.00 $100.00 $100.00 $100.00 $1,000.00 $1,800.00 $500.00 $100.00 $100.00 $100.00 $1,000.00 $1,800.00 $500.00 $100.00 $100.00 $100.00 $1,000.00 $1,800.00 50 50 50 50 $3,500.00 $80.00 $70.00 $250.00 Subtotal $175,000.00 $4,000.00 $3,500.00 $12,500.00 $195,000.00 $1,000.00 $500.00 $500.00 $1,000.00 $3,000.00 $1,000.00 $500.00 $500.00 $1,000.00 $3,000.00 $1,000.00 $500.00 $500.00 $1,000.00 $3,000.00 $1,000.00 $500.00 $500.00 $1,000.00 $3,000.00 $1,000.00 $500.00 $500.00 $1,000.00 $3,000.00 1 50 1 $50,000.00 $75.00 $75,000.00 Subtotal $50,000.00 $3,750.00 $75,000.00 $128,750.00 $40,000.00 $30,000.00 $1,000.00 $1,000.00 $75,000.00 $76,000.00 $116,000.00 $107,000.00 $20,000.00 $1,000.00 $77,000.00 $98,000.00 $10,000.00 $1,000.00 $79,000.00 $90,000.00 $10,000.00 $1,000.00 $82,000.00 $93,000.00 Services In-House trainer AutoCAD training hours/user In-House systems personnel Total Costs by Year Total Costs Benefits Reduced Labor Costs Increased Gross Revenue $450,050.00 $1,015,550.00 $128,300.00 $119,300.00 $110,300.00 $102,300.00 $105,300.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $150,000.00 $150,000.00

Chapter 15 Hands-on MIS Application Software Exercise Solution Description: Database and Web-Page Development Tool Exercise: Building a Job Database and Web Page for an International Consulting Firm Students must first be reminded that before coding ever begins, it is the responsibility of the developer to fully understand the task at hand, the company’s needs, and

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 15 Managing Global Systems LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. 2. 3. 4. What major factors are driving the internationalization of business? What are the alternative strategies for developing global businesses? How can information systems support different global business strategies? What are the challenges

Chapter 15 Running Case Solution 1. Which countries would provide the best markets for Dirt Bikes’ products? Your analysis should consider factors such as: In which countries are dirt bikes popular? What is the per capita income of these countries? Which countries should be targeted for selling Dirt Bikes? Given that Dirt Bikes is still

Chapter 15 Running Case Assignment: Achieving Operational Excellence: Expanding International Sales In this project you’ll use the Web to research international markets for a small manufacturing company. Software skills: Web browser and electronic presentation software Business skills: Identifying international markets Management would like to expand international sales for Dirt Bikes. You have been asked to analyze opportunities

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 2 How Businesses Use Information LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. What are business processes? How are they related to information systems? 2. How do information systems serve the various levels of management groups in a business? 3. How do

Chapter 2 Running Case Solution Description The spreadsheet solution file for this case uses a line chart to show the 5-year trend in Dirt Bikes’ total sales and a stacked column chart of 5-year sales trends to show how much international and domestic sales contribute to the total. One can see from these graphs

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 2: Global E-business and Collaboration Learning Track 2: Collaboration and Teamwork Outline Introduction: It’s a Collaborative World 1.0 Why Are Collaboration and Teamwork So Important Today? 2.0 What Are the Business Benefits of Collaboration? 3.0 What Makes a Good Team Member And

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 2: Global E-Business and Collaboration Learning Track 3: Challenges of Using Business Systems Organizations still need different types of information systems serving various organizational levels, functions, and business processes, and they increasingly need systems providing enterprisewide integration. These needs

Orders and Suppliers Vendor Name Spacetime Technologies Steelpin Inc. Steelpin Inc. Steelpin Inc. Steelpin Inc. Steelpin Inc. Alum Sheeting Alum Sheeting Alum Sheeting Alum Sheeting Spacetime Technologies Spacetime Technologies Spacetime Technologies Spacetime Technologies Spacetime Technologies Spacetime Technologies Durrable Products Durrable Products Durrable Products Durrable Products Durrable Products Spacetime Technologies Spacetime Technologies Spacetime Technologies Durrable Products Durrable Products Durrable Products Manley Valve Manley Valve Manley Valve Manley Valve Spacetime Technologies Spacetime Technologies Manley Valve Manley Valve Manley Valve Manley Valve Pylon Accessories Alum Sheeting Steelpin Inc. Alum Sheeting Alum Sheeting Alum Sheeting Pylon Accessories Durrable Products Durrable Products Durrable

Orders and Suppliers Vendor Name Spacetime Technologies Steelpin Inc. Steelpin Inc. Steelpin Inc. Steelpin Inc. Steelpin Inc. Alum Sheeting Alum Sheeting Alum Sheeting Alum Sheeting Spacetime Technologies Spacetime Technologies Spacetime Technologies Spacetime Technologies Spacetime Technologies Spacetime Technologies Durrable Products Durrable Products Durrable Products Durrable Products Durrable Products Spacetime Technologies Spacetime Technologies Spacetime Technologies Durrable Products Durrable Products Durrable Products Manley Valve Manley Valve Manley Valve Manley Valve Spacetime Technologies Spacetime Technologies Manley Valve Manley Valve Manley Valve Manley Valve Pylon Accessories Alum Sheeting Steelpin Inc. Alum Sheeting Alum Sheeting Alum Sheeting Pylon Accessories Durrable Products Durrable Products Durrable

Orders and Suppliers Vendor Name Spacetime Technologies Steelpin Inc. Steelpin Inc. Steelpin Inc. Steelpin Inc. Steelpin Inc. Alum Sheeting Alum Sheeting Alum Sheeting Alum Sheeting Spacetime Technologies Spacetime Technologies Spacetime Technologies Spacetime Technologies Spacetime Technologies Spacetime Technologies Durrable Products Durrable Products Durrable Products Durrable Products Durrable Products Spacetime Technologies Spacetime Technologies Spacetime Technologies Durrable Products Durrable Products Durrable Products Manley Valve Manley Valve Manley Valve Manley Valve Spacetime Technologies Spacetime Technologies Manley Valve Manley Valve Manley Valve Manley Valve Pylon Accessories Alum Sheeting Steelpin Inc. Alum Sheeting Alum Sheeting Alum Sheeting Pylon Accessories Durrable Products Durrable Products Durrable

This worksheet shows the number of Dirt Bikes motorcycles sold between 2008 and 2012. Worksheet name: Sales Amounts are in thousads of dollars Model Enduro 250 Enduro 550 Moto 300 Moto 450 TOTAL 2008 1201 2832 1755 463 6251 Sales by Model 2009 2010 1663 2291 3290 3759 1932 2454 598 661 7483 9165 2011 2312 4078 2615 773 9778 2012 2195 3647 2627 823 9292 2002 0 0 0 0 0 Units sold Annual Sales 4500 4000 3500 3000 2500 2000 1500 1000 500 0 0 Enduro 250 Enduro 550 Moto 300 Moto 450 2008 2009 2010 Year 2011 2012 This worksheet shows Dirt Bikes' income statements and summary balance sheets from 2010-2012 Worksheet name: Statements amounts are in thousands Consolidated

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 2: Global E-business and Collaboration Learning Track 1: Systems from a Functional Perspective We will start by describing systems using a functional perspective because this is the most straightforward approach, and, in fact, because this is how you will

Managing the Digital Firm, Seventh Canadian Edition Describe the characteristics of executive support systems (ESS) and explain how these systems differ from DSS. Executive support systems help senior managers address strategic issues and longterm trends, both in the firm and in the external environment. • • • • ESS address nonroutine decisions requiring judgment, evaluation, and insight because there

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 2: Global E-business and Collaboration Learning Track 5: Occupational and Career Outlook for Information Systems Majors 2010-2020 Total employment in the United States is expected to increase by about seven percent from 2010 to 2020. However, the 20.5 million jobs

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 2: Global E-business and Collaboration Learning Track 4: Organizing the Information Systems Function There are many types of business firms, and there are many ways in which the IT function is organized within the firm (see Figure 1-1).

Chapter 2 Runing Case Assignment: Analyzing Financial Performance Software skills: Spreadsheet charts and formulas Business skills: Financial statement analysis As part of your analysis of the company for management, you have been asked to analyze data on Dirt Bikes’s financial performance. Review Dirt Bikes’s selected financial data in the Introduction to Dirt Bikes, which can

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 3 Information Systems, Organizations, and Strategy LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. Which features of organizations do managers need to know about to build and use information systems successfully? What is the impact of information systems on organizations? 2. How does

Chapter 3 Running Case Solution Software requirements: Web browser software Word processing software Electronic presentation software (optional) 1. What activities at Dirt Bikes create the most value? The most valuable activities include inbound activities (primarily supply chain management but also including locating appropriate, high quality parts anywhere in the world)), manufacturing (which is mostly assembling the proper materials that

ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Guest First Name Barry Michael Kim Edward Thomas Paul Randall Calvin Homer David Buster Julia Samuel Arthur Darlene Carlyle Albert Charlene Everett Gerald Jamal Louis Nigel Peter Ronald Trista Valerie Walter Xavier Zachary Guest Last Name Lloyd Lunsford Kyuong Holt Collins Bodkin Battenburg Nowotney Gonzalez Sanchez Whisler Martines Kim Gottfried Shore Charleston Goldstone Tilson Chad Pittsfield Smith Paris Stratford Willington Cartier Leven Snell Acton Trezza Miller Room Hayes Cleveland Coolidge Washington Lincoln Coolidge Washington Lincoln Lincoln Jefferson Jackson Reagan Truman Garfield Arthur Quincy Adams Johnson Van Buren Madison Roosevelt Tyler Jackson Eisenhower Grant Jefferson Eisenhower Adams Polk McKinley Washington Room Type Bay-window Ocean Bay-window Ocean Ocean Bay-window Ocean Ocean Ocean Bay-window Ocean Bay-window Side Side Ocean Bay-window Ocean Bay-window Ocean Ocean Bay-window Ocean Ocean Ocean Bay-window Ocean Bay-window Side Side Ocean Arrival Date Departure Date No of Guests Daily Rate 11/30/2012 12/3/2012 2 $150.00 11/30/2012 12/8/2012 3 $112.50 12/3/2012 12/6/2012 1 $150.00 11/30/2012 12/2/2012 4 $325.00 12/8/2012 12/12/2012 2 $300.00 11/30/2012 12/2/2012 2 $150.00 12/3/2012 12/11/2012 2 $292.50 12/1/2012 12/3/2012 1 $300.00 12/4/2012 12/6/2012 5 $320.00 12/4/2012 12/6/2012 2 $175.00 12/4/2012 12/7/2012 2 $250.00 12/9/2012 12/14/2012 1 $150.00 12/19/2012 12/29/2012 3 $112.50 12/12/2012 12/14/2012 2 $125.00 12/23/2012 12/30/2012 5 $198.00 12/2/2012 12/5/2012 2 $150.00 12/4/2012 12/6/2012 3 $250.00 12/4/2012 12/6/2012 1 $150.00 12/9/2012 12/13/2012 2 $275.00 12/4/2012 12/6/2012 2 $275.00 12/19/2012 12/22/2012 2 $150.00 12/9/2012 12/13/2012 1 $250.00 12/13/2012 12/15/2012 2 $200.00 12/18/2012 12/20/2012 1 $200.00 12/23/2012 12/27/2012 4 $175.00 12/16/2012 12/19/2012 1 $200.00 12/2/2012 12/5/2012 1 $150.00 12/23/2012 12/30/2012 6 $148.50 12/13/2012 12/16/2012 2 $125.00 12/12/2012 12/15/2012 2 $325.00 Avg Length of Visit per Room Type Room Type Bay-window Ocean Side Avg Visit Length 3 3.625 5.5 Page 1 Avg No of Visitors per Room Type Room Type Bay-window Ocean Side AvgOfNo of Guests 1.8 2.375 3.25 Page 1 Base Income per Room Room Hayes Cleveland Coolidge Washington Lincoln Coolidge Washington Lincoln Lincoln Jefferson Jackson Reagan Truman Garfield Arthur Quincy Adams Johnson Van Buren Madison Roosevelt Tyler Jackson Eisenhower Grant Jefferson Eisenhower Adams Polk McKinley Washington Daily Rate Length of Visit Base Income/Room $150.00 3 $450.00 $112.50 8 $900.00 $150.00 3 $450.00 $325.00 2 $650.00 $300.00 4 $1,200.00 $150.00 2 $300.00 $292.50 8 $2,340.00 $300.00 2 $600.00 $320.00 2 $640.00 $175.00 2 $350.00 $250.00 3 $750.00 $150.00 5 $750.00 $112.50 10 $1,125.00 $125.00 2 $250.00 $198.00 7 $1,386.00 $150.00 3 $450.00 $250.00 2 $500.00 $150.00 2 $300.00 $275.00 4 $1,100.00 $275.00 2 $550.00 $150.00 3 $450.00 $250.00 4 $1,000.00 $200.00 2 $400.00 $200.00 2 $400.00 $175.00 4 $700.00 $200.00 3 $600.00 $150.00 3 $450.00 $148.50 7 $1,039.50 $125.00 3 $375.00 $325.00 3 $975.00 Page 1 Room Type Bay-window Ocean Bay-window Ocean Ocean Bay-window Ocean Ocean Ocean Bay-window Ocean Bay-window Side Side Ocean Bay-window Ocean Bay-window Ocean Ocean Bay-window Ocean Ocean Ocean Bay-window Ocean Bay-window Side Side Ocean Avg Length

ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Guest First Name Barry Michael Kim Edward Thomas Paul Randall Calvin Homer David Buster Julia Samuel Arthur Darlene Guest Last Name Lloyd Lunsford Kyuong Holt Collins Bodkin Battenburg Nowotney Gonzalez Sanchez Whisler Martines Kim Gottfried Shore 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Carlyle Albert Charlene Everett Gerald Jamal Louis Nigel Peter Ronald Trista Valerie Walter Xavier Zachary Charleston Goldstone Tilson Chad Pittsfield Smith Paris Stratford Willington Cartier Leven Snell Acton Trezza Miller Room Hayes Cleveland Coolidge Washington Lincoln Coolidge Washington Lincoln Lincoln Jefferson Jackson Reagan Truman Garfield Arthur Quincy Adams Johnson Van Buren Madison Roosevelt Tyler Jackson Eisenhower Grant Jefferson Eisenhower Adams Polk McKinley Washington Room Type Arrival Date Departure Date No of Guests Daily Rate Bay-window 12/1/2012 12/4/2012 2 $150.00 Ocean 12/1/2012 12/9/2012 3 $112.50 Bay-window 12/4/2012 12/7/2012 1 $150.00 Ocean 12/1/2012 12/3/2012 4 $325.00 Ocean 12/9/2012 12/13/2012 2 $300.00 Bay-window 12/1/2012 12/3/2012 2 $150.00 Ocean 12/4/2012 12/12/2012 2 $292.50 Ocean 12/2/2012 12/4/2012 1 $300.00 Ocean 12/5/2012 12/7/2012 5 $320.00 Bay-window 12/5/2012 12/7/2012 2 $175.00 Ocean 12/5/2012 12/8/2012 2 $250.00 Bay-window 12/10/2012 12/15/2012 1 $150.00 Side 12/20/2012 12/30/2012 3 $112.50 Side 12/13/2012 12/15/2012 2 $125.00 Ocean 12/24/2012 12/31/2012 5 $198.00 Bay-window Ocean Bay-window Ocean Ocean Bay-window Ocean Ocean Ocean Bay-window Ocean Bay-window Side Side Ocean 12/3/2012 12/5/2012 12/5/2012 12/10/2012 12/5/2012 12/20/2012 12/10/2012 12/14/2012 12/19/2012 12/24/2012 12/17/2012 12/3/2012 12/24/2012 12/14/2012 12/13/2012 12/6/2012 12/7/2012 12/7/2012 12/14/2012 12/7/2012 12/23/2012 12/14/2012 12/16/2012 12/21/2012 12/28/2012 12/20/2012 12/6/2012 12/31/2012 12/17/2012 12/16/2012 2 3 1 2 2 2 1 2 1 4 1 1 6 2 2 $150.00 $250.00 $150.00 $275.00 $275.00 $150.00 $250.00 $200.00 $200.00 $175.00 $200.00 $150.00 $148.50 $125.00 $325.00

Chapter 3 Running Case Assignment: Improving Decision Making: Analyzing Competitive Strategy Software skills: Web browser software and presentation software Business skills: Value chain and competitive forces analysis, business strategy formulation This project provides an opportunity for you to develop the competitive strategy for a real-world business. You’ll use the Web to identify Dirt Bikes’s competitors and

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 3: Information Systems, Organizations, and Strategy Learning Track 1: The Changing Business Environment of Information Technology A combination of information technology innovations and a changing domestic and global business environment makes the role of IT in business even more

Chapter 4 Running Case Solution 1. How much data should Dirt Bikes collect on visitors to its Web site, and why that data? What information could it find out by tracking their activities at its Web site? What value would this information provide the company? What are the privacy problems raised by collecting such

MIS13 Hands-on MIS Management Decision Problem 2 WEB USAGE REPORT FOR THE WEEK ENDING JANUARY 6, 2013 USER NAME Kelleher,Claire Kelleher, Claire Kelleher, Claire McMahon, Patricia McMahon, Patricia Milligan, Robert Milligan, Robert Olivera, Ernesto Talbot, Helen Talbot, Helen Talbot, Helen Talbot, Helen Wright, Steven Wright, Steven MINUTES ONLINE 45 107 96 83 44 112 43 40 125 27 35 73 23 15 WEB SITE VISITED www.doubleclick.net www.yahoo.com www.insweb.com www.itunes.com www.insweb.com www.youtube.com www.travelocity.com www.CNN.com www.etrade.com www.nordstrom.com www.yahoo.com www.ebay.com www.facebook.com www.autobytel.com

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 4: Ethical and Social Issues in Information Systems Learning Track 1: Developing a Corporate Code of Ethics for IT As a manager, you will be responsible for developing, enforcing, and explaining corporate ethics policies. Historically, corporate management has paid

Chapter 4 Solution Description Go to tennisvisitortips.blogspot.com/ to see a sample solution for this exercise. Companies selling tennis equipment or providing services related to the U.S. Open (hotels, restaurants, transportation services) might want to place on this blog text, banner, or video ads or links to their Web sites. Businesses might find the following

Chapter 4 Running Case Assignment: Achieving Operational Excellence: Developing a Web Site Privacy Policy Software skills: Web browser software and presentation software Business skills: Corporate privacy policy formulation Dirt Bikes’s management wants to make sure it has policies and procedures in place to protect the privacy of visitors to its Web site. You have been

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 4 Social, Ethical, and Legal Issues in the Digital Firm LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. What social, ethical, and legal issues are raised by information systems? 2. What specific principles for conduct can be used to guide ethical

Chapter 5 Running Case Solution Alternative 1: Buying the Software Features Number of users Software license fee Software upgrades Customization/implementation Hardware [email protected]$4000 User Training Technical Support 1/2 time ANNUAL TOTAL TOTAL 3-YEAR COST Year 1 25 100,000.00 5,000.00 20,000.00 4,000.00 10,000.00 27,500.00 166,500.00 Year 2 25 0.00 5,000.00 0.00 0.00 0.00 28,325.00 33,325.00 Year 3 25 0.00 5,000.00 0.00 0.00 0.00 29,174.75 34,174.75 233,999.75 Alternative 2: Renting the Software from an ASP Features Number of users Software rental fee ($2500 per user) Customization/implementation User Training ANNUAL TOTAL TOTAL 3-YEAR COST Year 1 25 62500 12000 10000 84500 209500 Year 2 25 62500 0 0 62500 Year 3 25 62500 0 0 62500

Chapter 5 Solution Description The spreadsheet solution file shows that the total 3-year cost of renting hosted software is less expensive than purchasing it and using hosted software requires less management than Dirt Bikes owning and running its software. However, there are other factors to consider-the functionality of the hosted software versus purchased software,

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 5: IT Infrastructure and Emerging Technologies Learning Track 2: Cloud Computing Introduction 1.0 Cloud Computing: Getting it Straight 2.0 Leading Examples and Services 3.0 Cloud Computing: Related Concepts 4.0 Business Pros and Cons of Cloud Computing Introduction Cloud computing is a vision of computing

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 5 IT Infrastructure and Emerging Technologies LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. 2. 3. 4. 5. What is IT infrastructure, and what are its components? What are the stages and technology drivers of IT infrastructure evolution? What are the current trends in computer hardware platforms? What

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 5: IT Infrastructure and Emerging Technologies Learning Track 1: How Computer Hardware and Software Work Although managers and business professionals do not need to be computer technology experts, they should have a basic understanding of the role of hardware

Chapter 5 Hands-on MIS Improving Decision Making: Using a Spreadsheet to Evaluate Hardware and Software Options Desktop and Printer Specifications Each desktop system must satisfy the minimum specifications shown in the following table: MINIMUM DESKTOP SPECIFICATIONS Processor speed 3 GHz Hard drive 500 GB RAM 4 GB DVD-ROM drive DVD-RW Monitor (diagonal measurement) 18 inches Each desktop printer must satisfy the minimum specifications shown in the MINIMUM

Chapter 5 Running Case Assignment: Improving Decision Making: Making the Rent vs. Buy Decision for Hardware and Software Software skills: Spreadsheet formulas, electronic presentation software (optional) Business skills: Technology rent vs. buy decision, TCO analysis This project provides an opportunity for you help a real-world company make a decision about whether to rent or buy

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 5: IT Infrastructure and Emerging Technologies Learning Track 3: Service Level Agreements Service level agreements (SLAs) are contracts between firms that formally define the level of service between a purchaser of services and a vendor of services. Contracts are

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 5: IT Infrastructure and Emerging Technologies Learning Track 4: The Open Source Software Initiative Open source software is software produced by a community of several hundred thousand programmers around the world. Open source software is by definition free, available

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 5: IT Infrastructure and Emerging Technologies Learning Track 5: The Evolution of IT Infrastructure The IT infrastructure in organizations today is an outgrowth of over 50 years of evolution in computing platforms. There have been five stages in this

Hardware and Software Pricing Information - Example Computer Item Minimum Specs Model No. Processor Hard Drive RAM DVD-ROM drive Monitor Printer Item Model No. Print Speed Print Quality Network Ready? Maximum Price/Unit Software Software Version Cost/Unit x 30 Units 3 GHz 500 GB 4 GB DVD-RW 18 inches Cost/Unit x 30 Units Minimum Specs 20 ppm 600 x 600 dpi Yes $700 Cost/Unit x 15 Units MS Office 2010 Professional $349.99 $10,499.70 Lenovo Specs ThinkCentre M78 Small Desktop 3.8 500 4 DVD Recordable W7 19 $788.00 $23,640.00 Hewlett Packard HP LaserJet Pro P1606dn 26 ppm 600 x 600 dpi Yes Dell Specs Vostro 470 HP Specs HP ENVY 23-c110xt All-in-One 3.1 500 6 16X CD/DVD burner (DVD+/-RW) 20 $749.00 $22,470.00 Canon imageCLASS

Hardware and Software Pricing Information - Example Computer Item Minimum Specs Model No. Processor Hard Drive RAM DVD-ROM drive Monitor Printer Item Model No. Print Speed Print Quality Network Ready? Maximum Price/Unit Software Software Version Cost/Unit x 30 Units 3 GHz 500 GB 4 GB DVD-RW 18 inches Cost/Unit x 30 Units Minimum Specs 20 ppm 600 x 600 dpi Yes $700 Cost/Unit x 15 Units MS Office 2010 Professional $349.99 $10,499.70 Lenovo Specs ThinkCentre M78 Small Desktop 3.8 500 4 DVD Recordable W7 19 $788.00 $23,640.00 Hewlett Packard HP LaserJet Pro P1606dn 26 ppm 600 x 600 dpi Yes Dell Specs Vostro 470 HP Specs HP ENVY 23-c110xt All-in-One 3.1 500 6 16X CD/DVD burner (DVD+/-RW) 20 $749.00 $22,470.00 Canon imageCLASS

Chapter 6 Running Case Assignment: Improving Decision Making: Redesigning the Customer Database Software skills: Database design; querying and reporting Business skills: Customer profiling Dirt Bikes U.S.A. sells primarily through its distributors. It maintains a small customer database with the following data: customer name, address (street, city, state, zip code), telephone number, model purchased, date of purchase,

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 6 Databases and Information Management LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. What are the problems of managing data resources in a traditional file environment, and how are they solved by a database management system? 2. What are the major capabilities

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 6: Foundations of Business Intelligence: Databases and Information Management Learning Track 3: Hierarchical and Network Data Models You can still find older systems that are based on a hierarchical or network data model. The hierarchical DBMS is used to model

Chapter 6 Management Decision Problem 2 Proposed Data Warehouse Format and Sample Files Proposed Data Warehouse Format Product _ID Product_ Description Cost_per_ Unit Units_ Sold Sales_Region Division Customer_ID The following are sample files from the two systems that would supply the data for the data warehouse: Mechanical Parts Division Sales System Prod_No Product_ Description Cost_per_Unit 60231 4” Steel bearing 5.28 85773 SS assembly unit 12.45 Units_Sold 900,245 992,111 Sales_Region N.E. M.W Corporate

ID Product Number 1 1 2 2 3 3 4 4 5 5 6 6 Product Category Road Road Road Mtn. Mtn. Mtn. Product Name Classic 109 Elegant 210 Runroad 1000 Eagle 3 Eagle 2 Eagle 1 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Hybrid Hybrid Hybrid Leisure Leisure Leisure Leisure Children Children Children Children Road Road Road Leisure Leisure Mtn. Mtn. Runblend 2000 Eagle 7 Tea for Two Runcool 3000 Starlight Supreme 350 Blue Moon Runkidder 100 Red Rider Coolest 100 Green Rider Runroad 4000 Runroad 5000 Twist & Shout Breeze Breeze LE Bluff Breaker Jetty Breaker 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Purchase Cost Selling Price Supplier Number Quantity on Hand Reorder Level $207.49 $290.49 1 7 2 $281.52 $394.13 1 7 2 $250.95 $350.99 3 8 5 $350.52 $490.73 2 5 2 $401.11 $561.54 2 2 2 $410.01 $574.01 2 1 2 $180.95 $150.89 $429.02 $85.95 $100.47 $50.00 $75.29 $50.95 $15.00 $69.99 $95.47 $390.95 $450.95 $490.50 $89.95 $109.95 $375.00 $455.95 $255.99 $211.46 $609.00 $135.99 $140.66 $70.00 $105.41 $75.99 $25.50 $97.98 $133.66 $495.99 $599.99 $635.70 $130.95 $149.95 $495.00 $649.95 3 2 4 3 4 1 4 3 4 1 4 3 3 4 5 5 5 5 0 9 3 5 1 3 4 10 8 6 4 5 5 0 4 5 3 1 5 2 2 5 2 5 2 5 5 5 5 5 5 2 2 4 3 2 ID No 1 2 3 4 5 Supplier Number Company Name 1 Bicyclist's Choice 2 Bike-One 3 Run-Up Bikes Simpson's Bike 4 Supply 5 The

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 6: Foundations of Business Intelligence: Databases and Information Management Learning Track 2: Introduction to SQL This Hands-On Guide is a brief introduction to Structured Query Language (SQL), the standard language for relational database management systems. SQL can be used for defining

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 6: Foundations of Business Intelligence: Databases and Information Management Learning Track 1: Database Design, Normalization, and EntityRelationship Diagramming This Hands-On Guide will show you how to design a relational database system for a small business using normalization and entity-relationship diagrams.

ID No Supplier Number Street Address 1459 Washington Avenue 2000 Oceanside Lane 1155 Fifth Avenue City State Sioux Falls SD San Diego CA Long Branch NJ 4 Company Name 1 Bicyclist's Choice 2 Bike-One 3 Run-Up Bikes Simpson's Bike 4 Supply 107 Piedmont 5 5 The Bike Path 1999 Stephen Hands Path Tulsa East Hampton 1 2 3 ZIP Code 57106 92110 07521 OK 74114 NY 11937 Product Name Runblend 2000 Starlight Supreme 350 Coolest 100 Green Rider Twist & Shout Jetty Breaker Product Number Supplier Number 7 3 11 4 12 1 16 1 17 4 20 4 24 5 Company Name Run-Up Bikes Simpson's Bike Supply Bicyclist's Choice Bicyclist's Choice Simpson's Bike Supply Simpson's Bike

Chapter 6 Running Case Solution Description The solution file represents one of many alternative database designs that would satisfy Dirt Bikes’ requirements. The design shown here consists of 4 tables: Customer, Distributor, Purchase, and Model. Dirt Bikes’s old customer database was modified by breaking it down into these tables and adding new fields to

tblCustomer CustomerID 1 2 3 4 5 6 7 8 9 10 Last Name Mann Porter Higgins Langan Delgado Stratman Yates Mickel Podell Lowe First Name Street Dwight 23 Colby Lane William 3 Pinehill Rd. Daniel 38 Ryder Rd. Howard 8 Belle Ave. Luis 66 Skyview Terrace Philip 722 Donald Dr. Gerry 11 Buena Vista Dr. Paul 523 Grant St. James 68 Clinton St. Mark 95 Canyon Dr. City Tacoma Logan Lincoln Flagstaff Las Cruces Hayward Ventura Norman Pocatello Pomona State WA UT NE AZ NM CA CA OK ID CA Zip 98109 84321 68526 86002 88003 94541 93012 73072 83202 91767 Phone 2531234333 4357973322 4024716950 9283825877 5055824301 7142785564 8054137922 4053251971 2082514967 9098693955 Email [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] DateofBirth Ed Level 8/2/1980 12 11/24/1971 16 12/30/1967 12 6/26/1966 14 7/22/1961 12 2/16/1974 16 6/6/1979 12 4/1/1978 14 3/8/1972 18 10/18/1969 16 Sport Hunting Skiing Fishing Hunting Football Tennis Skiing Hunting Tennis Skiing Racing TRUE TRUE FALSE TRUE TRUE FALSE FALSE TRUE FALSE FALSE tblDistributor DistID Distributor 1 Ben's Cycles 2 J & J Cycle 3 KB Racing 4 Don's Off Road 5 WX Cycle 6 Performance Cycles 7 Lightning Cycles 8 All-Terrain Cycle 9 Cycle World Page

CustomerID Last Name First Name Street 1 Mann Dwight 23 Colby Lane 2 Porter William 3 Pinehill Rd. 3 4 5 6 7 8 9 10 Higgins Langan Delgado Stratman Yates Mickel Podell Lowe Daniel Howard Luis Philip Gerry Paul James Mark 38 Ryder Rd. 8 Belle Ave. 66 Skyview Terrace 722 Donald Dr. 11 Buena Vista Dr. 523 Grant St. 68 Clinton St. 95 Canyon Dr. City Tacoma Logan State WA UT Zip 98109 84321 Phone (253) 123-4333 (435) 797-3322 Model Enduro 250 Enduro 250 Date Distributor 12-Feb-12 J&J Cycle 27-Mar-12 WX Cycle Lincoln Flagstaff Las Cruces Hayward Ventura Norman Pocatello Pomona NE AZ NM CA CA OK ID CA 68526 86002 88003 94541 93012 73072 83202 91767 (402) 471-6950 (928) 382-5877 (505) 582-4301 (714) 278-5564 (805) 413-7922 (405) 325-1971 (208) 251-4967 (909) 869-3955 Moto 450 Moto 450 Moto 300 Moto 450 Enduro 250 Moto

Chapter 7 Running Case Solution 1. How could the various Internet tools help employees at Dirt Bikes? Create a matrix showing what types of employees and business functions would benefit from using each type of tool and why. The Internet is far easier and less expensive to use for much of telecommunications than more traditional

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 7: Telecommunications, the Internet, and Wireless Technology Learning Track 5: Introduction to Web 2.0 Many of the unique features of e-commerce and the Internet come together in a set of applications and social media technologies referred to as Web 2.0.

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 7: Telecommunications, the Internet, and Wireless Technology Learning Track 2: Telecommunications Services Provided by Commercial Communications Vendors Telecommunications is the digital plumbing that holds the modern digital firm together, and makes it possible for the all the computers, telephones, and Internet

Managing the Digital Firm, Seventh Canadian Edition List and describe alternative ways of locating information on the Web. • • • • • • • Search engines are a facility on the Web that helps you find sites with the information and/or services you want. Examples: Google, Yahoo!, and MSN. Intelligent agent shopping bots use intelligent agent software for searching the Internet

Chapter 7 Running Case Assignment: Achieving Operational Excellence: Using Internet Tools to Increase Efficiency and Productivity Software skills: Web browser software and presentation software Business skills: Employee productivity analysis In this project, you’ll suggest applications of Internet technology to help a employees at real-world company work more efficiently. Dirt Bikes’s management is concerned about how much

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 7: Telecommunications, the Internet, and Wireless Technology Learning Track 1: LAN Topologies Sometimes LANs are described in terms of the way their components are connected together, or their topology. There are three major LAN topologies: star, bus, and ring (see

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 7: Telecommunications, the Internet, and Wireless Technology Learning Track 3: Cellular System Generations Cellular Generations Wireless phone systems throughout the world are gradually moving toward much higher speeds and capacities. This transition involves over $150 billion in worldwide investment by 2016

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 7: Telecommunications, the Internet, and Wireless Technology Learning Track 4: Wireless Applications for Customer Relationship Management, Supply Chain Management, and Healthcare Wireless Applications for Customer Relationship Management Major customer relationship management (CRM) vendors have enhanced their products to provide mobile support for sales and

Chapter 7 Solution file: Using Spreadsheet Software to Evaluate Wireless Services Zip Code 45238 Average work days per month Minutes used per day Minutes used per month Text messages per month Photos per month AT&T Nation Unlimited Verizon Share Everything for Basic Phones 300 MB Plan T-Mobile Classic Unlimited Per Employee 22 180 3960 660 22 Number of Employees 35 Assumptions Hours per Day 3 Text Messages per Day 30 Photos per Week 5 All Employees 770 6300 138600 23100 770 Monthly Monthly Service

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 7 Telecommunications, the Internet, and Wireless Technology LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. What are the principal components of telecommunications networks and key networking technologies? 2. What are the different types of networks, transmission media, and Internet connections? 3. How do the Internet

Chapter 7 Solution file: Using Spreadsheet Software to Evaluate Wireless Services Zip Code 45238 Average work days per month Minutes used per day Minutes used per month Text messages per month Photos per month AT&T Nation Unlimited Verizon Share Everything for Basic Phones 300 MB Plan T-Mobile Classic Unlimited Per Employee 22 180 3960 660 22 Number of Employees 35 Assumptions Hours per Day 3 Text Messages per Day 30 Photos per Week 5 All Employees 770 6300 138600 23100 770 Monthly Monthly Service

Managing the Digital Firm, Seventh Canadian Edition Comprehensive and systematic MIS auditing organizations determine the effectiveness of security and controls for their information systems. An MIS audit identifies all of the controls that govern individual information systems and assesses their effectiveness. Control weaknesses and their probability of occurrence will be noted. The results of

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 8: Securing Information Systems Learning Track 1: The Booming Job Market in IT Security The technology industry has experienced its share of ups and downs over the last decade, from the initial dot-com boom to the dot-com bust, and back

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 8: Securing Information Systems Learning Track 4: General and Application Controls for Information Systems To minimize errors, disaster, computer crime, and breaches of security, special policies and procedures must be incorporated into the design and implementation of information systems. The combination

Chapter 8 Solution File Mercer Paints Risk Assessment Exposure Hackers Malware Power failure User errors Data loss Flooding Training lack Vandalism Enbezzlement Improper use Probability Average Expected of Occurrence Loss ($) Annual Loss 95% 90,000 85,500 60% 75,000 45,000 15% 300,000 45,000 95% 25,000 23,750 12% 70,000 8,400 2% 400,000 8,000 20% 6,000 1,200 1% 100,000 1,000 3% 30,000 900 5% 5,000 250 Expected Annual Loss from Risks 90,000 80,000 70,000 60,000 50,000 40,000 30,000 20,000 10,000 0 Exposure

Chapter 8 Running Case Solution 1. What are the most likely threats to the continued operation of Dirt Bikes’ systems? The single most likely threat is for power outages, which can easily occur because of rain and snow storms, particularly in regions like the Rocky Mountains area. Outages can be very harmful because they

Chapter 8 Running Case Assignment: Achieving Operational Excellence: Developing a Disaster Recovery Plan Software skills: Web browser and presentation software Business skills: Disaster recovery planning Management is concerned that Dirt Bikes’s computer systems could be vulnerable to power outages, vandalism, computer viruses, natural disasters, or telecommunications disruptions. You have been asked to perform an analysis of

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 8: Securing Information Systems Learning Track 5: Management Challenges of Security and Control Information systems security needs organizational and management resources as well as technologies. Establishing a good framework for security and control requires skillful balancing of risks, rewards, and the

Chapter 8 Hands-on MIS Improving Decision Making: Using Spreadsheet Software to Perform a Security Risk Assessment Mercer Paints Risk Assessment Exposure Malware attack Data loss Embezzlement User errors Threats from hackers Improper use by employees Power failure Probability of Occurrence (%) 60% 12% 3% 95% 95% 5% Average Loss ($) 15% $300,000 $75,000 $70,000 $30,000 $25,000 $90,000 $5,000

Chapter 8 Hands-on MIS Security Vulnerabilities and Risk Assessment Tables Management Decision Problem 2 SECURITY VULNERABILITIES BY TYPE OF COMPUTING PLATFORM Platform Number of High Medium Low Total Computers Risk Risk Risk Vulnerabilities Windows Server (corporate applications) 1 11 37 19 Windows 7 Enterprise (high-level administrators) 3 56 242 87 Linux (e-mail and printing services) 1 3 154 98 Sun Solaris (UNIX) (E-commerce and Web servers) 2 12 299 78 195 14 16 1,237 Windows 7 Enterprise user desktops and laptops with office productivity tools that can also

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 8: Securing Information Systems Learning Track 6: Software Vulnerability and Reliability In addition to disasters, viruses, and security breaches, defective software and data also pose a constant threat to information systems, causing untold losses in productivity. An undiscovered error in a

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 8: Securing Information Systems Learning Track 3: Computer Forensics For thirty years, a serial murderer known as the BTK killer (standing for bind, torture, and kill) remained at large in Wichita, Kansas. The BTK killer first struck in 1971 with

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 8: Securing Information Systems Learning Track 2: The Sarbanes-Oxley Act Reacting to corporate accounting and governance scandals that made headlines in the early days of the twenty-first century, the United States Congress enacted legislation to protect investors from fraudulent corporate accounting

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 8 Securing Information Systems LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. 2. 3. 4. Why are information systems vulnerable to destruction, error, and abuse? What is the business value of security and control? What are the components of an organizational framework for security and

Chapter 8 Solution File Mercer Paints Risk Assessment Exposure Hackers Malware Power failure User errors Data loss Flooding Training lack Vandalism Enbezzlement Improper use Probability Average Expected of Occurrence Loss ($) Annual Loss 95% 90,000 85,500 60% 75,000 45,000 15% 300,000 45,000 95% 25,000 23,750 12% 70,000 8,400 2% 400,000 8,000 20% 6,000 1,200 1% 100,000 1,000 3% 30,000 900 5% 5,000 250 Expected Annual Loss from Risks 90,000 80,000 70,000 60,000 50,000 40,000 30,000 20,000 10,000 0 Exposure

ACCT_ID 1 2 3 4 5 NAME Able Association Briggs Bakery Constant Carriers Darning Drapers Eagle Engineers ADDR 123 Axion Street 123 Boggs Street 31 Carmine Le 1234 Dante Ave Eagle Park CITY Albertown Brimstone Carver Driblle Edmonton STATE NY CT NJ NY CT ZIP 11444-4444 11200-1234 20111-1212 12345-6849 11222-2313 DOLLAR_SIZE $50,000.00 $94,000.00 $200,000.00 $60,000.00 $45,000.00 CONTACT_FIRST Alison Barry Carl Delilah Eddie CONTACT_LAST Ableson Berryman Compress Dilman Exeter PHONE (209) 111-1111 (210) 111-1212 (202) 123-1222 (209) 123-4321 (210) 212-2233 FAX (219) 111-2222 (210) 111-1213 (202) 123-1234 (201) 123-4322 (210) 143-2122 tblREQUEST REQUEST_NUM 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 ACCT_ID 1 1 1 2 2 2 2 3 4 4 5 5 5 1 2 3 3 4 5 3 REQ_DATE EQUIP_TYPE 4/4/2012 furnace 4/5/2012 plumbing 4/1/2012 air conditioner 4/4/2012 roofing 4/3/2012 oven 4/3/2012 freezer 4/4/2012 furnace 4/4/2012 air conditioner 4/1/2012 roofing 4/5/2012 window 4/2/2012 oven 4/3/2012 freezer 4/1/2012 roofing 4/2/2012 plumbing 4/5/2012 window 4/5/2012 roofing 4/1/2012 plumbing 4/3/2012 oven 4/5/2012 windows 4/2/2012 furnace Page 1 tblREQUEST PROBLEM no heat can't turn

Chapter 9 Running Case Assignment: Improving Operational Excellence: Identifying Supply Chain Management Solutions Software skills: Web browser and presentation software Business skills: Locating and evaluating suppliers In this project you’ll use the Web to identify the best suppliers for one component of a dirt bike and appropriate supply chain management software for a small manufacturing company. A

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 9: Achieving Operational Excellence and Customer Intimacy: Enterprise Applications Learning Track 1: SAP Business Process Map A Process Map for Procuring New Equipment. The process map shows how SAP enterprise software can integrate different enterprise areas into one smooth process flow

Managing the Digital Firm, Seventh Canadian Edition CHAPTER 9 Enterprise Applications to Manage Supply Chains and Respond to Customers LEARNING OBJECTIVES After reading this chapter, you will be able to answer the following questions: 1. How do enterprise systems help businesses achieve operational excellence? 2. How do supply chain management systems coordinate planning, production, and logistics with suppliers? 3. How

Chapter 9 Running Case Solution 1. Use the Internet to locate alternative suppliers for motorcycle fuel tanks. Identify 2 or 3 suppliers. Find out the amount of time and cost to ship a fuel tank (weighing about 5 pounds) via ground (surface delivery) from each supplier to Dirt Bikes in Carbondale, Colorado. Which supplier

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 9: Achieving Operational Excellence and Customer Intimacy: Enterprise Applications Learning Track 3: Best-Practice Business Processes in CRM Software TABLE 9-1 Examples of Best Practice Business Processes in the Siebel CRM System Business Process Description Priority-based lead qualification and distribution Evaluates and scores leads,

Management Information Systems, 13TH ED. MANAGING THE DIGITAL FIRM Kenneth C. Laudon ● Jane P. Laudon Chapter 9: Achieving Operational Excellence and Customer Intimacy: Enterprise Applications Learning Track 2: Business Processes in Supply Chain Management and Supply Chain Metrics Supply Chain Processes Many processes and subprocesses are involved in managing the supply chain to expedite this flow of information

ACCT_ID 1 2 3 4 5 NAME Able Association Briggs Bakery Constant Carriers Darning Drapers Eagle Engineers ADDR 123 Axion Street 123 Boggs Street 31 Carmine Le 1234 Dante Ave Eagle Park CITY Albertown Brimstone Carver Driblle Edmonton STATE NY CT NJ NY CT ZIP 11444-4444 11200-1234 20111-1212 12345-6849 11222-2313 DOLLAR_SIZE $50,000.00 $94,000.00 $200,000.00 $60,000.00 $45,000.00 CONTACT_FIRST Alison Barry Carl Delilah Eddie CONTACT_LAST Ableson Berryman Compress Dilman Exeter PHONE (209) 111-1111 (210) 111-1212 (202) 123-1222 (209) 123-4321 (210) 212-2233

Dirt Bikes USA Organization Chart CEO and COO Production Parts Shipping & Receiving Manufacturing Administration Service Sales & Marketing Design & Engineering

This worksheet shows the number of Dirt Bikes motorcycles sold between 2007 and 2011. Worksheet name: Sales Amounts are in thousands of dollars Model Enduro 250 Enduro 550 Moto 300 Moto 450 TOTAL 2007 1201 2832 1755 463 6251 Sales by Model 2008 2009 1663 2291 3290 3759 1932 2454 598 661 7483 9165 2010 2312 4078 2615 773 9778 2011 2195 3647 2627 823 9292 This worksheet shows Dirt Bikes' income statements and summary balance sheets from 2009-2011. Worksheet name: Financial Statements amounts are in thousands Consolidated Satements of Income (in thousands) 2012 2011 2010 Revenue Net

Introduction to Dirt Bikes Dirt Bikes USA is a small company headquartered in Carbondale Colorado that manufactures and sells its own brand of off-road motorcycles. It was founded in 1993 to product dirt bikes that could be customized for racing and off-road recreational riding using the best quality components and parts from all over

TEST ITEM FILEJames ClarkUniversity of LethbridgeManagementInformation SystemsSeventh Canadian EditionKenneth C. LaudonNew York UniversityJane P. LaudonAzimuth Information SystemsMary Elizabeth BrabstonI. H. Asper School of Business, University of ManitobaTorontoISBN: 978-0-1337-4144-5Copyright © 2015 Pearson Canada Inc. All rights reserved.This work is protected by Canadian copyright laws and is provided solely for the use

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionC) knowledge and the firm's tangible assets, such as goods or servicesD) time and knowledgeAnswer: ADiff: 3 Page Ref: 9AACSB: Reflective thinking skillsCASE: KnowledgeObjective: 1.161) Which of the following roles in a firm would be least affected by using mobile devices toaccess firm information

60) which of the following are key corporate assets? a) intellectual property, core competencies, and financial and human assets b) production technologies and business processes for sales, marketing, and finance

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition61) E-government refers to the application of ________ to digitally enable government and publicsector agencies' relationships with citizens, businesses, and other arms of government.A) the Internet and networking technologiesB) e-commerceC) e-businessD) any computerized technologyAnswer: ADiff: 1 Page Ref: 44AACSB: Use of information technologyCASE: KnowledgeObjective:

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionChapter 2 How Businesses Use Information Systems1)Enrolling employees in benefits plans is a business process handled by the finance andaccounting function.Answer: FALSEDiff: 2 Page Ref: 33AACSB: Use of information technologyCASE: KnowledgeObjective: 2.12)Operational management is responsible for directing the day-to-day operations of thebusiness and therefore

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionC) value chain analysisD) strategic systems analysisAnswer: ADiff: 1 Page Ref: 82AACSB: Reflective thinking skillsCASE: KnowledgeObjective: 3.361) The most successful solutions or methods for achieving a business objective are calledA) value activities.B) best processes.C) core competencies.D) best practices.Answer: DDiff: 1 Page Ref: 82AACSB: Reflective

60) which of the following activities would you perform to measure and compare your business processes to similar processes of other companies within your industry? a) benchmarking b) best practices

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition59) Which of the following adjusts copyright laws to the Internet age by making it illegal tocircumvent technology-based protections of copyrighted materials?A) Digital Millennium Copyright ActB) Privacy ActC) Freedom of Information ActD) Electronic Communications Privacy ActAnswer: ADiff: 3 Page Ref: 118AACSB: Reflective thinking skillsCASE:

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionChapter 4 Social, Ethical, and Legal Issues in the Digital Firm1)Even in today's legal climate, there is little incentive for firms to cooperate with prosecutorsinvestigating financial crimes at their firm.Answer: FALSEDiff: 2 Page Ref: 102AACSB: Use of information technologyCASE: ComprehensionObjective: 4.12)Advances in data storage

65) the marketplace for computer hardware a) has become increasingly concentrated in top firms. b) has expanded to include a wide variety of start-up and mobile-computing firms. c) has moved significantly to asian firms. d) has been decimated by mobile and cloud computing.

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionAnswer: ADiff: 2 Page Ref: 145AACSB: Use of information technologyCASE: KnowledgeObjective: 5.266) The practice of contracting custom software development to an outside firm is commonlyreferred to asA) outsourcing.B) scaling.C) service-oriented architecture.D) application integration.Answer: ADiff: 1 Page Ref: 159AACSB: Use of information technologyCASE: KnowledgeObjective: 5.467)

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionChapter 6 Databases and Information Management1)A grouping of characters into a word, a group of words, or a complete number is called arecord.Answer: FALSEDiff: 1 Page Ref: 175AACSB: Use of information technologyCASE: KnowledgeObjective: 6.12)Each characteristic or quality describing a particular entity is called an

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionC) in-memory computing.D) analytic platforms.Answer: ADiff: 2 Page Ref: 185AACSB: Use of information technologyCASE: KnowledgeObjective: 6.364) A nationwide magazine publisher has hired you to help analyze their social media datasetsto determine which of their news publications are seen as the most trustworthy. Which ofthe

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionChapter 7 Telecommunications, the Internet, andWireless Technology1)Telephone networks are fundamentally different from computer networks.Answer: TRUEDiff: 2 Page Ref: 204AACSB: Use of information technologyCASE: ComprehensionObjective: 7.12)Wikis allow visitors to change or add to the original posted material.Answer: TRUEDiff: 1 Page Ref: 227AACSB: Use of information

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition67) What technology allows people to have Knowledge pulled from Web sites and fedautomatically to their computers?A) FTPB) RSSC) HTTPD) BluetoothAnswer: BDiff: 2 Page Ref: 227AACSB: Use of information technologyCASE: ComprehensionObjective: 7.368) The process of employing techniques to help a Web site achieve a

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionChapter 8 Securing Information Systems1)A drive-by download is a technique used by hackers to enable accessing files on a wirelessnetwork.Answer: FALSEDiff: 1 Page Ref: 245AACSB: Use of information technologyCASE: ComprehensionObjective: 8.12)Computers using cable modems to connect to the Internet are more open to penetration

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionC) application proxy filteringD) packet filteringAnswer: ADiff: 3 Page Ref: 261AACSB: Use of information technologyCASE: ComprehensionObjective: 8.467) Which of the following is the greatest threat that employees pose to an organization'sinformation systems?A) forgetting passwordsB) lack of knowledgeC) entering faulty dataD) introducing software errorsAnswer: BDiff:

65) marketing modules in crm systems would provide tools for a) assigning and managing customer service requests. b) capturing prospect and customer data. c) identifying profitable and unprofitable customers. d) managing sales prospect and contact information.

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionAnswer: CDiff: 1 Page Ref: 290AACSB: Use of information technologyCASE: ComprehensionObjective: 9.366) Selling a customer with a checking account a home improvement loan is an example ofA) operational CRM.B) direct marketing.C) cross-selling.D) cross-channel promotions.Answer: CDiff: 2 Page Ref: 291AACSB: Use of information technologyCASE: ComprehensionObjective:

ExamName___________________________________1. E-commerce refers to the use of any networking technologies to transact business.FalseAnswer:TrueExplanation:Comment:Diff: 2Type: TFVar: 1AACSB: Reflective thinking skillsCASE: ComprehensionObjective: 10.1Page Ref: 4032. Consumer e-commerce is still growing at approximately 25% annually.Answer:TrueFalseExplanation:Comment:Diff: 3Type: TFVar: 1AACSB: Reflective thinking skillsCASE: ComprehensionObjective: 10.1Page Ref: 4033. The Internet shrinks information asymmetry.Answer:TrueFalseExplanation:Comment:Diff: 2Type: TFVar: 1AACSB:

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionAnswer: DDiff: 3 Page Ref: 320AACSB: Reflective thinking skillsCASE: ComprehensionObjective: 10.367) Which of the following statements about B2B commerce is not true?A) Eighty percent of online B2B e-commerce is still based on EDI.B) B2B e-commerce represents approximately three-quarters of the overall B2Bmarketplace.C) B2B e-commerce

65) an inference engine is a) a strategy for searching the rule base in case-based reasoning. b) the programming environment of an expert system. c) a method of organizing expert system knowledge into chunks. d) a strategy used to search through the rule base

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionAnswer: DDiff: 2 Page Ref: 355AACSB: Reflective thinking skillsCASE: KnowledgeObjective: 11.466) Forward chaining isA) a strategy for searching the rule base in an expert system that begins with informationentered by the user.B) the programming environment of an expert system.C) a method of organizing expert

ExamName___________________________________1. Improving the quality of high-value decision making by an executive will save an organization far moremoney than improving the quality of lesser-value decisions made at a lower level.FalseAnswer:TrueExplanation:Comment:Diff: 2Type: TFVar: 1AACSB: Use of information technologyCASE: ContentObjective: 12.3Page Ref: 4852. Unstructured decisions are novel and nonroutine, and there is no

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionAACSB: Analytic skillsCASE: AnalysisObjective: 12.266) Which of the following is not an example of a BI predefined production report?A) workforce demographicsB) order cycle timeC) revenue forecastsD) supplier performanceAnswer: CDiff: 3 Page Ref: 383-384AACSB: Analytic skillsCASE: SynthesisObjective: 12.267) MIS typically produceA) new ways of looking

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionChapter 13 Developing Information Systems1)The most common form of IT-enabled organizational change is automation.Answer: TRUEDiff: 2 Page Ref: 403AACSB: Use of information technologyCASE: KnowledgeObjective: 13.12)Rationalization of procedures describes a radical rethinking of the business models.Answer: FALSEDiff: 2 Page Ref: 403AACSB: Reflective thinking skillsCASE: KnowledgeObjective:

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionA) Develop the prototype; use the prototype; revise and enhance the prototype.B) Identify user requirements, develop the prototype, use the prototype, revise and enhancethe prototype.C) Define the requirements, develop solutions, select the best prototype, and implement theprototype.D) Define the requirements, develop the prototype, revise

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionAnswer: CDiff: 2 Page Ref: 434AACSB: Reflective thinking skillsCASE: KnowledgeObjective: 14.167) Which of the following is not a responsibility of effective change management?A) integrating legacy systemsB) dealing with fear and anxiety about new systemsC) training users of the new systemD) enforcing user participation at

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionChapter 14 Project Management, Business Value,and Managing Change1)The cost of a project is based on the time taken to complete the project.Answer: TRUEDiff: 2 Page Ref: 439AACSB: Reflective thinking skillsCASE: KnowledgeObjective: 14.12)An information system project's scope is directly related to its business requirements.Answer: TRUEDiff:

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian EditionChapter 15 Managing Global Systems1)The first step in establishing a corporate strategy and structure for globalization is todetermine the appropriate technology platform.Answer: FALSEDiff: 1 Page Ref: 465AACSB: Reflective thinking skillsCASE: KnowledgeObjective: 15.22)Global business drivers can be divided into two groups: general cultural factors and

Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition65) Which systems are worth sharing on a transnational basis, from a cost and feasibility pointof view?A) only systems that support functions that are absolutely critical to the organizationB) core systems and worthwhile provincial systemsC) core systems and any financial systems that can be