管理信息系统（英文版·第7版）（中篇共上中下3篇）

UsingExcelandAccessTogetherChapterExtension7StudyQuestionsCopyright©2017PearsonEducation,Inc.Q1:WhyuseExcelandAccesstogether?Q2:Whatisimport/export?Q3:HowcanyoucreatechartswithExcel?Q4:HowcanyoucreategrouptotalsinAccess?Q5:HowcanyouuseExceltographAccessdata?Q6:HowcanyouuseAccesstoreportExceldata?Q7:HowcanyoucombineExcelandAccesstoanalyzedata?Q1:WhyUseExcelandAccessTogether?Copyright©2017PearsonEducation,Inc.AccessDBMSforkeepingtrackofthingsandcreatingreportsExcelUseforcreatingsophisticatedgraphsandanalyzingdataWhyusetogether?Toeliminatere-keyingdata,reducelaboranderrorsQ2:WhatIsImport/Export?Copyright©2017PearsonEducation,Inc.ProcessoftransferringdatafromonesystemtoanotherCreatestemporaryconnectiontosourcedataConnectionclosesafterdatatransferredDevelopprocedures(manualorautomated)toensuredatarefreshedonatimelybasisExampleofDataExportedfromUniversityEnrollmentSystemCopyright©2017PearsonEducation,Inc.Comma-delimitedtextfileCreatingaTextFileinAccessCopyright©2017PearsonEducation,Inc.Openadatabase,clickonExternalData

tabSelectfilethatcontainsdatatoimportClickImportandOKMultiple-panelwizardopensSpecifydatafileisdelimitedNamefieldsanddatatypeExternalDataMenuChoiceCopyright©2017PearsonEducation,Inc.SpecifyingtheSourceFileandDestinationCopyright©2017PearsonEducation,Inc.ImportingTextDataintoAccess:SpecifyingaDelimitedFileCopyright©2017PearsonEducation,Inc.ImportingTextDataintoAccess:NamingandDescribingColumnsDuringImportCopyright©2017PearsonEducation,Inc.DataAfterImportCopyright©2017PearsonEducation,Inc.PieChartCopyright©2017PearsonEducation,Inc.Q3:HowCanYouCreateChartswithExcel?Copyright©2017PearsonEducation,Inc.CreatingaPieChartSelectingtheChartToolsCopyright©2017PearsonEducation,Inc.SampleColumnChartCopyright©2017PearsonEducation,Inc.CreatingaColumnChartCopyright©2017PearsonEducation,Inc.CreatingtheChartTitleCopyright©2017PearsonEducation,Inc.VolunteerdatabasescenarioTVstationmanagerwantstoknowTotalDonationsforeachdateoffundraisingeffort.Also,wantstoknowifsomedatesarebetterthanothers.UsingWORKtable,createaquerytogroupalldonationsbydateandsumTotalDonationsforeachgroup.Q4:HowCanYouCreateGroupTotalsinAccess?Copyright©2017PearsonEducation,Inc.OpenVolunteerdatabase1ClickCreatetab2ClickQueryDesign3SelectWORKtable4ClickAdd

5ClickClose6HowCanYouCreateGroupTotalsinAccess?(cont’d)Copyright©2017PearsonEducation,Inc.SelectingWORKTablefortheQueryCopyright©2017PearsonEducation,Inc.AddingWorkDateandTotalDonationstotheQueryCopyright©2017PearsonEducation,Inc.SelectingSuminTotalRowforTotalDonationsCopyright©2017PearsonEducation,Inc.ResultsofQuerywithGroupbyWorkDateCopyright©2017PearsonEducation,Inc.Double-clickName

toinsertitintoquerytableDouble-clickProspectIDandTotalDonationsClickTotalsicontoinsertTotalrowinquerytableInTotalrowunderProspectID,selectCountInTotalrowunderTotalDonations,selectSumCreateacolumnheadingProspectIDcolumnbykeying“HoursWorked:”CreateacolumnheadingforTotalDonationsas“TotalObtained:”StepsforCreatingaQuerytoComputeTotalHoursandDonationsforEachProspectCopyright©2017PearsonEducation,Inc.1234567ProcessforCreatingaQuerytoComputeTotalHoursandDonationsforEachProspectCopyright©2017PearsonEducation,Inc.ResultsoftheQueryinPreviousSlideCopyright©2017PearsonEducation,Inc.AddingAverageDonationsPerHourCopyright©2017PearsonEducation,Inc.ResultsoftheQuerywithAverageCopyright©2017PearsonEducation,Inc.StepsforCreatingaQuerytoComputeTotalHoursandDonationsforEachProspectCreateacolumnheadingforTotalDonationsas“TotalObtained:”Double-clickName

toinsertitintoquerytableDouble-clickProspectIDandTotalDonationsClickTotalsicontoinsertTotalrowinquerytableInTotalrowunderProspectID,selectCountInTotalrowunderTotalDonations,selectSumCreateacolumnheadingProspectIDcolumnbykeying“HoursWorked:”1234567Copyright©2017PearsonEducation,Inc.ProcessforCreatingaQuerytoComputeTotalHoursandDonationsforEachProspectCopyright©2017PearsonEducation,Inc.ResultsoftheQueryinPreviousSlideCopyright©2017PearsonEducation,Inc.AddingAverageDonationsPerHourCopyright©2017PearsonEducation,Inc.ResultsoftheQuerywithAverageDonationsperHourCopyright©2017PearsonEducation,Inc.Q5:HowCanYouUseExceltoGraphAccessData?Copyright©2017PearsonEducation,Inc.ImportAccessqueryintoExcelanduseExcel’sgraphingcapabilitytodisplayresultsToimportdataintoExcel:ClickData

tabClickGetExternalDatasection,selectFromAccessSelectVolunteerdatabaseMenutoImportDatafromAccessintoExcelCopyright©2017PearsonEducation,Inc.ClickData

tab,then,Get

External

DataSelectFromAccessSelectingtheQuerytoImportCopyright©2017PearsonEducation,Inc.PlacingImportedDataintoSpreadsheetCopyright©2017PearsonEducation,Inc.SpreadsheetwithImportedDataCopyright©2017PearsonEducation,Inc.FormattedImportedDataCopyright©2017PearsonEducation,Inc.BarChartoftheImportedDataCopyright©2017PearsonEducation,Inc.1.UsedAccesstokeeptrackofvolunteersandtheirreceiveddonations,toqueryandgroupdata—alltasksforwhichAccessisideallysuited.2.ImporteddataintoExcelandusedExcel’seasygraphingcapabilitytocreatecharts.ReflectonWhatWeHaveDoneCopyright©2017PearsonEducation,Inc.Q6:HowCanYouUseAccesstoReportExcelData?Copyright©2017PearsonEducation,Inc.Producetwodifferentreportsfromthisdata.Groupallexpensesforagivenexpensecategorytoproduceanexpensetotal.Groupallexpensesforparticulardatestoproduceanexpensetotalforeachdate.DobothbyimportingExceldataintoAccessandusingAccessreportgenerator.SampleExpenseDataCopyright©2017PearsonEducation,Inc.CreatingaNamedRangeinExcelCopyright©2017PearsonEducation,Inc.Highlightdata(includingcolumnheadings)andclickFormulas

tabInDefinedNamessection,clickDefineNameandenterasuitablenameNote:Rangenamescannothaveanyspaces,souseunderscoresCreatingaNamedRangeCopyright©2017PearsonEducation,Inc.CloseExcelworkbookthathasdataOpenAccessdatabaseforimportingClickExternalDatatab,thenclickExcelinImportsectionClickImportsourcedatatonewtable

indatabaseClickOKClickShowNamedRanges,selectEvent_ExpensesCheckboxforFirstRowContainsColumnNamesImportingDatainNamedRangeintoaNewAccessTableCopyright©2017PearsonEducation,Inc.234567ImportingExcelDataintoAccessCopyright©2017PearsonEducation,Inc.ImportingExcelDataintoAccess:

ImportingtheDataintheNamedRangeCopyright©2017PearsonEducation,Inc.ImportingExcelDataintoAccess:AccessHasMetadatatoGuideImportCopyright©2017PearsonEducation,Inc.AfterclickingFinish,AccesscreatestablewithmetadatadescriptionsandplacesdataintoEvent_ExpensestableOpenEvent_ExpensestableClickCreate,clickReportinReportssectionAccessgeneratesreporttomodifytodesiredformatCreatingExpenseReportsCopyright©2017PearsonEducation,Inc.GroupingReportDatabyExpenseCategoryCopyright©2017PearsonEducation,Inc.CreatingGroupTotalsCopyright©2017PearsonEducation,Inc.ResultingReportCopyright©2017PearsonEducation,Inc.2InGrouping&TotalssectionofDesignribbon,clickGroup&Sort.ClickAddClickExpenseCategory,showninnextslideInDesignmode,clickMoreandclickExpensetotaledSelectExpenseforTotalOn,ShowGrandTotalandShowingroupfooterReportfinishedQ7:HowCanYouCombineExcelandAccesstoAnalyzeData?Copyright©2017PearsonEducation,Inc.51234CreatingaQuerytoSumExpensesbyGivenDateCopyright©2017PearsonEducation,Inc.ResultofQuerytoSumExpensesbyGivenDateCopyright©2017PearsonEducation,Inc.CreatingaQuerytoCombineResultsofTwoOtherQueriesCopyright©2017PearsonEducation,Inc.MergeEventDateTotalsquerywithEventExpenseTotals

queryClickCreate/QueryDesign,thenQueriestabinShowTablewindow,asshowninnextslideAddbothEventDateTotalsandEventExpenseTotalstoqueryDragDatefieldinEventDateTotalsanddropontopofEventDateinEventExpenseTotalsqueryAddDate,SumOfTotalDonation,andTotalEventExpensetoqueryRun

(!)

querySavequeryasEventResultsandExpensesCombiningtheResultsofTwoQueriesCopyright©2017PearsonEducation,Inc.MatchingDateValuesinTwoQueriesCopyright©2017PearsonEducation,Inc.QuerywithColumnsAddedCopyright©2017PearsonEducation,Inc.ResultofQueryCopyright©2017PearsonEducation,Inc.ClickDataFromAccessinGetExternalDatasectionofribbonSelectAccessdatabasewithquery,andselectEventResultsandExpensesOpenExcelworkbookandimportEventResultsandExpensesqueryImportEventsResultsandExpensesintoExcelCopyright©2017PearsonEducation,Inc.231ResultsofTotalEventExpenseQueryImportedintoExcelCopyright©2017PearsonEducation,Inc.ResultsofTotalEventExpenseQueryImportedintoExcel(cont'd)Copyright©2017PearsonEducation,Inc.ReflectonWhatHasBeenDonewithThisDataCopyright©2017PearsonEducation,Inc.TotalDonationdataoriginatedinAccessandsummedusinganAccessqueryExpensedatafromExcelworksheetFundRaisingExpenseimportedintoAccess,andsummedinaqueryResultsofTotalEventExpensequeryimportedbacktoExcel,andanalyzedActiveReviewCopyright©2017PearsonEducation,Inc.Q1:WhyuseExcelandAccesstogether?Q2:Whatisimport/export?Q3:HowcanyoucreatechartswithExcel?Q4:HowcanyoucreategrouptotalsinAccess?Q5:HowcanyouuseExceltographAccessdata?Q6:HowcanyouuseAccesstoreportExceldata?Q7:HowcanyoucombineExcelandAccesstoanalyzedata?Copyright©2017PearsonEducation,Inc.NetworkandCloudTechnologyChapterExtension8StudyQuestionsCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallQ1:Whatisacomputernetwork?Q2:WhatarethecomponentsofaLAN?Q3:HowdoestheInternetwork?Q4:HowdoestheCloudwork?Q1:WhatIsaComputerNetwork?Copyright©2017PearsonEducation,Inc.PublishingasPrenticeHallQ2:WhatAretheComponentsofaLAN?Copyright©2017PearsonEducation,Inc.PublishingasPrenticeHallTypicalSmallOffice/HomeOfficeAbbreviationsUsedforCommunicationsandComputerMemorySpeedsDifferCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallCommunicationsequipment,kstandsfor1,000,not1,024asitdoesformemoryMstandsfor1,000,000,not1,024×1,024Gstandsfor1,000,000,000,not1,024×1,024×1,024.Thus,100Mbpsis100,000,000bitspersecondCommunicationsspeedsexpressedinbits,memorysizesexpressedinbytesLANProtocolIEEE802.3WiredLAN10/100/1000Mbps

EthernetCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallIEEE802.11WirelessLAN802.11acUpto1.3GpsBluetoothBluetoothProtocolCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallCommonwirelessprotocolusedtomakePANconnectionsDesignedfortransmittingdataovershortdistancesWirelessmice,keyboards,printers,andheadphonestoconnecttodesktopcomputersSmartwatchesandfitnesstrackersuseBluetoothtoconnecttosmartphonesandsenddataovertheInternetClothing,automobiles,andsportsequipmentbecomingBluetoothenabledConnectingYourLANtotheInternetCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallImportantISPfunctions:ProvidesalegitimateInternetaddressProvidesgatewaytotheInternetPaysforInternetbycollectingmoneyfromcustomersandpayingaccessfeesandotherchargestotelecomsOffice(SOHO)LANCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallQ3:HowDoestheInternetWork?Copyright©2017PearsonEducation,Inc.PublishingasPrenticeHallUsingtheInternetforaHotelReservationCarriersandNetNeutralityMessagesbrokenintopacketsPacketsmoveacrossInternet,passingthroughnetworksownedbytelecomcarriersPeeringagreements-CarriersfreelyexchangetrafficamongstthemselveswithoutpayingaccessfeesNetneutralityprincipleAlldatatreatedequallyProblem:somepeopleusemorebandwidththanothersCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallInternetAddressingPublicIPaddressesIdentifiesauniquedeviceonInternet.AssignedbyICANN(InternetCorporationforAssignedNamesandNumbers.PrivateIPaddressesIdentifiesadeviceonaprivatenetwork,usuallyaLAN.AssignmentLANcontrolledCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallIPAddressing:MajorBenefitsPublicIPaddressesconservedOnepublicIPaddressperLANUsingprivateIPaddressesEliminatesregisteringpublicIPaddresswithICANN-approvedagenciesProtectsagainstdirectattackCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallPublicIPAddressesandDomainNamesIPv453DomainnameUniquenameaffiliatedwithapublicIPaddressDynamicaffiliationofdomainnameswithIPaddressesMultipledomainnamesforsameIPaddressURL(UniformResourceLocatorInternetaddressprotocol,suchashttp://orftp://Copyright©2017PearsonEducation,Inc.PublishingasPrenticeHallDomainRegistryCompanyCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallThree-tierArchitectureCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallWatchtheThreeTiersinAction!SampleofCommerceServerPageCommerceserverrequestsshoedatafromDBMSDBMSreadsfromdatabase,returnsdatatocommerceserverCommerceserverformatsWebpagewithdataandsendshtmlversionofpagetouser’scomputerCustomerplacesitemsinshoppingcartCustomerchecksout,commerceserverprogramprocessespayment,schedulesinventoryprocessing,arrangesshipping,emailreceipttocustomerCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallProcessingonaWebServerWhathappenswhenyouvisitaWebsiteandordersomething,andpayforit?Copyright©2017PearsonEducation,Inc.PublishingasPrenticeHallQ4:HowDoestheCloudWork?Copyright©2017PearsonEducation,Inc.PublishingasPrenticeHallService-OrientedArchitecture(SOA)philosophyAllinteractionsamongcomputingdevicesdefinedasservicesinaformal,standardizedwayEnables

allpiecesofthecloudtofittogetherSOAAnalogy:ApprovalRequestInteractionsAmongThreeDepartmentsCheckCustomerCredit•ApproveCustomerCredit•VerifyInventoryAmount•AllocateInventory•ReleaseAllocatedInventoryCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallUsingSOAPrinciples,EachDepartmentDefines:CheckCustomerCreditApproveCustomerCreditInventoryDepartmentVerifyInventoryAmountAllocateInventoryReleaseAllocatedInventoryEachdepartmentformallystatesdatatoreceivewithrequestanddatapromisedtoreturninresponseEveryinteractiondoneexactlysamewayCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallUsingSOAPrinciples:EncapsulationNodepartmentneedstoknowwhoworksinanotherdept.,orhowdept.accomplishesworkEachdept.freetochangepersonneltaskassignments,changeprocessesforperformingservicesFalconSecuritycoulddynamicallycreate1,000InventoryandSalesdepts.withnoneedtochangeanythingitdoesCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallSOAPrinciplesAppliedtoThree-tierArchitectureServicesObtainPartDataObtainPartImagesObtainPartQuantityOnHandOrderPartJavaScriptwrittentoinvoketheseservicescorrectly.Copyright©2017PearsonEducation,Inc.PublishingasPrenticeHallProtocolsSupportingWebServicesCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallWSDL,SOAP,XML,andJSONCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallExampleofJSONDocumentCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallActiveReviewCopyright©2017PearsonEducation,Inc.PublishingasPrenticeHallQ1:Whatisacomputernetwork?Q2:WhatarethecomponentsofaLAN?Q3:HowdoestheInternetwork?Q4:Howdoesthecloudwork?Copyright©2017PearsonEducation,Inc.PublishingasPrenticeHallEnterpriseResourcePlanning(ERP)SystemsChapterExtension9StudyQuestionsCopyright©2017PearsonEducation,Inc.Q1:WhatisthepurposeofERPsystems?Q2:WhataretheelementsofanERPsolution?Q3:HowareERPsystemsimplementedandupgraded?Q4:WhattypesoforganizationsuseERP?Q5:HowdothemajorERPvendorscompare?Q1: WhatIsthePurposeofERPSystems?Copyright©2017PearsonEducation,Inc.Suiteofmodules,database,setofinherentprocessesforconsolidatingbusinessoperationsintoasingle,consistentcomputingplatformPrimarypurposeIntegrationofpurchasing,humanresources,production,sales,andaccountingdataintoasinglesystemAllowrealtimeglobalupdatesoftransactionsEnablecriticalbusinessdecisionsusinglatestdataPre-ERPInformationSystem:BicycleManufacturer(FiveNon-integratedDatabases)Copyright©2017PearsonEducation,Inc.ERPInformationSystemCopyright©2017PearsonEducation,Inc.SomeQuestionsProceduresNeedtoAnswerorResolveCopyright©2017PearsonEducation,Inc.Howdoessalesdepartmentdetermineanorderis“large”?Bydollars?Byvolume?Whoapprovescustomercredit(andhow)?Whoapprovesproductioncapacity(andhow)?Whoapprovesscheduleandterms(andhow)?Whatactionstotakeifcustomermodifiesanorder?Howdoesmanagementobtainoversightonsalesactivity?SalesDashboardCopyright©2017PearsonEducation,Inc.Q2: WhatAretheElementsofanERPSolution?Copyright©2017PearsonEducation,Inc.ERPApplicationprogramsERPBusinessprocessproceduresERPDatabasesERPTrainingandConsultingTrueERPHaveApplicationthatIntegrate:(/erp-101.htm)Copyright©2017PearsonEducation,Inc.Supplychain:

(procurement,salesorderprocessing,inventorymanagement,suppliermanagement,relatedactivities)Manufacturing:

(scheduling,capacityplanning,qualitycontrol,billofmaterials,andrelatedactivities)CRM:

(salesprospecting,customermanagement,marketing,customersupport,callcentersupport)Humanresources:

(payroll,timeandattendance,HRmanagement,commissioncalculations,benefitsadministration,andrelatedactivities)Accounting:

(generalledger,accountsreceivable,accountspayable,cashmanagement,fixedassetaccounting)ERPSolutionComponentsCopyright©2017PearsonEducation,Inc.HardwareCloud-basedhostingPaaS:InstallERPsoftwareanddatabasesonleasedcloudhardwareSaaS:UseERPvendorsERPsoftwareasaserviceSAP,Oracle,Microsoft,andothersHybridmodelERPcustomersstoremostdataoncloudserversandsensitivedataonself-managedserversERPSolutionComponents(cont'd)Copyright©2017PearsonEducation,Inc.Software:ERPApplicationProgramsConfigurableapplicationprogramsSetconfigurationparameterstospecifyhowERPapplicationprogramswilloperateNumberofhoursinstandardworkweek,hourlywagesforjobcategories,wageadjustmentsforovertimeandholidaywork,etc.Morethan8,000configurationdecisionsinSAPERPSolutionComponents(cont'd)Copyright©2017PearsonEducation,Inc.Data:ERPDatabasesIncludesadatabasedesignandinitialconfigurationdataMorethan15,000tableswithmetadataandrelationships,rulesandconstraintsaboutmetadataaboutrelationshipsERPSolutionComponents(cont'd)Copyright©2017PearsonEducation,Inc.TwotypesofERPDatabaseprogramcodeTriggersComputerprogramwithindatabasekeepsdatabaseconsistentwhencertainconditionsariseStoredProceduresEnforcesbusinessrulesNevertosellcertainitemsatadiscountDevelopersandbusinessusersmustconfiguretheseInherentProceduresCopyright©2017PearsonEducation,Inc.BusinessProcessProceduresSetof100s-1000sinherentprocedures(processblueprints)HowtoaccomplishprocessworkusingtheERPapplicationsExampleofSAPOrderingBusinessProcessBlueprintCopyright©2017PearsonEducation,Inc.ExampleofSAPOrderingBusinessProcessBlueprint(cont’d)Copyright©2017PearsonEducation,Inc.People:TrainingandConsultingCopyright©2017PearsonEducation,Inc.VendortrainingcurriculaandnumerousclassesbeforeandafterERPimplementationIn-houseSuperUserstotrainthetrainerTypesoftrainingHowtoimplementtheERPsolutionHowtousetheERPapplicationsoftwareOn-siteconsultingforimplementingandusingERPQ3: HowareERPSystemsImplementedandUpgraded?Copyright©2017PearsonEducation,Inc.ImplementingERPsystemnotforthefaintofheartQ4: WhatTypesofOrganizationsUseERP?Copyright©2017PearsonEducation,Inc.Industry-specificsolutionsERPbyOrganizationSizeCopyright©2017PearsonEducation,Inc.LargeorganizationsHaveresourcesandskilledpersonneltoaccomplishandmanageanERPimplementationChiefinformationofficer(CIO)ERPimplementationpartofstrategicplanningRequiresfullbackingofentireexecutivegroup

MidsizeandSmallOrganizationsCopyright©2017PearsonEducation,Inc.EmployonlyoneortwoITspecialistsMedium-sizeorganizationsFrequentlysmallstaffisolatedfromseniormanagementIsolationcreatesmisunderstandinganddistrustFirststepinmovingtowardERPObtaindeepsenior-levelmanagementcommitmentInternationalERPCopyright©2017PearsonEducation,Inc.WorldwideconsolidationoffinancialstatementsonatimelybasisInherentERPproceduresadaptabletomanyculturesMultiplecurrenciesandlanguages,manageinternationaltransfersofgoodsininventories,workwithinternationalsupplychains/article/694303/How_to_Achieve_Global_ERP

Q5: HowDotheMajorERPVendorsCompare?Copyright©2017PearsonEducation,Inc.ERPMarketLeadersCopyright©2017PearsonEducation,Inc.ERPmarketmaturewithonly3.8%to$25billionin2013Consolidationofvendorsislikely,withsmallervendorsfallingoutentirelyTopfiveown55%ofmarketshareCloudishavingamajorimpactonERPvendorsERPProductsCopyright©2017PearsonEducation,Inc.SAPCopyright©2017PearsonEducation,Inc.ClassicSAPusesthick-client,client-serverarchitectureSAPHANNAEnterpriseCloudPaaSERPBigproblemCannotdramaticallymoveoutofclassicSAPtocloud-basedsolutions,mustfocusresourcesandattentiononneedsofcurrentcustomersInforCopyright©2017PearsonEducation,Inc.GrewbyacquisitionsSellsmanyERPproductsformanydifferentindustriesProductsvaryinpurpose,scope,andqualityServesmidrange,higher-endsmallcompaniesandlower-endlargecompaniesInforBusinessCloud(SaaS)orbare-bonesofferedasIaaSSageCopyright©2017PearsonEducation,Inc.Internationalcompanybeganlicensingaccountingsoftwarein1981Viaacquisitions,nowlicensesenterpriseapplicationsincludingCRMandERPOffernumerousfunctionalapplicationsinfinanceaswellPrimarilytargetshealthcare,construction,distribution,manufacturing,andretailindustriesMicrosoftDynamicsCopyright©2017PearsonEducation,Inc.AX,Nav,GP,Solomon,andDynamicsCRMConsolidatingitsofferings-AXtobetrueERPproductforlargerorganizationsDynamicsCRMextensibletoenableuseforERPandCRMGPusedasaplatformforsimplerERPsolutionsCRMproductonlineasSaaS,nofullERPimplementationinthecloudERPintheFutureCopyright©2017PearsonEducation,Inc.Problemsofcloud-basedERPusingthehybridmodelMobilitywillstillpresentpotentiallyserioussecuritythreatWarehouseworkersonloadingdock,shippingdepartmentcarrymobiledevicesthatenableprocessingERPandotherenterpriseapplications.Managers,decisionmakers,andknowledgeworkerswillhavesimilarapplicationsontheirownphonesorothermobiledevices,devicestheycanaccessfromwork,otheroffices,thestreet,orhome.ERPintheFuture(cont’d)Copyright©2017PearsonEducation,Inc.Increasedvulnerabilitytocriminalhackers,maliciousinsidersPotentialeffectoftheInternetofThingsMachineswillemployERPsystemtoscheduletheirownmaintenanceFactory

floormillingmachinesabletoorderareplacementforadullcutter,possiblymadebya3DprinterMachinesscheduleroutineandemergencymaintenanceforthemselvesActiveReviewCopyright©2017PearsonEducation,Inc.Q1:WhatisthepurposeofERPsystems?Q2:WhataretheelementsofanERPsolution?Q3:HowareERPsystemsimplementedandupgraded?Q4:WhattypesoforganizationsuseERP?Q5:HowdothemajorERPvendorscompare?Copyright©2017PearsonEducation,Inc.SupplyChainManagementChapterExtension10StudyQuestionsCopyright©2017PearsonEducation,Inc.Q1:Whataretypicalinter-enterpriseprocesses?Q2:Whatisasupplychain?Q3:Whatfactorsaffectsupplychainperformance?Q4:Howdoessupplychainprofitabilitydifferfromorganizationalprofitability?Q5:Whatisthebullwhipeffect?Q6:Howdoinformationsystemsaffectsupplychainperformance?Q1:WhatAreTypicalInter-enterpriseProcesses?Copyright©2017PearsonEducation,Inc.ProcessesoccurintwoormoreindependentorganizationsCooperationbynegotiationandcontract;conflictresolutionbynegotiation,arbitration,litigationSimpleModeratelycomplexHighlycomplexSmallretailercreditcardsalestransactionprocess.Standardizedprocessingofchecksamongbanksusing