BU131 Project PROJECT DESCRIPTION

BU131 Project PROJECT DESCRIPTION

BU131 Project PROJECT DESCRIPTION BU131ProjectPROJECT DESCRIPTIONProject Introduction:Dirt Bikes U.S.A. is a small company headquartered in Carbondale, Colorado. It manufactures and sells its own brand ofoff-road motorcycles. The company, founded in 1993, produces customized dirt bikes for racing and off-roadrecreational riding using the best quality components from all over the world. Today, the company faces a new set ofchallenges and opportunities. You have been asked, as a consultant, to apply your knowledge of information systemsto help Dirt Bikes U.S.A. solve some of the problems it is encountering.Course Objective Tested:1. Project the future impact of information systems on businesses and on your career.2. Use information systems to enhance a business’s reach, competitive advantage, and operational efficiency.3. Choose appropriate hardware, software, and Information technology (IT) management infrastructure for abusiness.4. Choose appropriate security, backup, virus protection, and control measures for a business’s informationsystems.5. Use enterprise systems, supply chain management (SCM) systems, and customer relationship management(CRM) systems to achieve operational excellence.6. Use e-commerce and M-commerce to achieve operational excellence and customer intimacy.7. Use knowledge management techniques to improve the decision-making process and operational efficiency.8. Design an appropriate information system to solve business problems.1BU131ProjectPROJECT SUBMISSION PLANProjectDescription/Requirements of Project PartEvaluation CriteriaPartDirt Bikes U.S.A.—Case Study1Task 1:Examine the Dirt Bikes U.S.A. case study and review Howto Analyze a Case Study. After reading the case study,review the following information:Company History and BackgroundOrganization Chart and EmployeesProducts and ServicesSales and MarketingOn the basis of this information, answer the followingquestions:1.Which products should the company restock?2.Which stores and sales regions would benefitfrom promotional campaigns and additionalmarketing?3.When (what time of year) should the companyoffer products at full price and when should itoffer discounts?Task 2:Dirt Bikes’ management wants to be sure that it ispursuing the right competitive strategy. You have beenasked to perform a competitive analysis of the companyto find the information you need. Prepare a report thatanalyzes Dirt Bikes using the value chain and competitiveforces models. Your report should include the following:1.2Which activities at Dirt Bikes create the mostCriteriaDid the studentsanswer thespecified casestudy questions?Did you provideanswers thatfollow a logicalpattern andinclude anexplanation forassumptions andappropriateexamples?Did you includeappropriatespreadsheetdata to supporttheir answers?PointsAssigned35%45%20%PointsEarnedBU131ProjectProjectDescription/Requirements of Project PartPartvalue?2.How does Dirt Bikes provide value to itscustomers?3.Who are Dirt Bikes’ major competitors? How dothe prices of their products compare with thoseof Dirt Bikes’? What product features do theyemphasize?4.What are the competitive forces that can affectthe industry?5.What competitive strategy should Dirt Bikespursue?6.What information systems best support thatstrategy?7.(Optional) Use electronic presentation softwareto summarize your findings for the management.Task 3:Dirt Bikes would like to implement new software forproduction planning, quality control, and scheduling. Thesoftware will be used by 25 members of the company’smanufacturing staff. The management is wonderingwhether to purchase the software from a commercialvendor along with the hardware required or to use ahosted software solution from a Software as a Service(SaaS) provider. (The hosted software runs on the serviceprovider’s computer.) You have been asked to help themanagement with this rent-versus-buy decision bycalculating the total cost of each option over a three-yearperiod. The cost of purchasing the software includes theinitial purchase price of the software (licensing fee of$100,000 in the first year), and the cost of implementing3Evaluation CriteriaBU131ProjectProjectDescription/Requirements of Project PartPartand customizing the software in the first year ($20,000).Hardware costs include a server to run the software (afirst-year purchase of $4,000), one information systemsspecialist devoting half his or her time to support thesoftware ($55,000 in full-time annual salary and benefitswith a 3 percent annual salary increase each year afterthe first year), and user training in the first year($10,000).You also need to account for the cost of annualsoftware upgrades ($5,000). On the other hand, the costsof renting hosted software include the rental fees ($2,500annually per user), implementation and customizationcosts ($12,000 in the first year), and training ($10,000 inthe first year).1.Use your spreadsheet software to calculate thetotal cost of renting or purchasing this softwareover a three-year period. Identify the lowestprice alternative that meets Dirt Bikes’requirements.2.What other factors should Dirt Bikes consider,besides cost, while determining whether to rentor buy the hardware and software?3.(Optional) If possible, use electronic presentationsoftware to summarize your findings formanagement.4.Submission Requirements:Submit your findings in an MS Word document.Submit the updated spreadsheet and databasefiles.4Font: Arial; 12-pointLine Spacing: DoubleEvaluation CriteriaBU131ProjectProjectDescription/Requirements of Project PartEvaluation CriteriaPartAssigned: Week 1Due: Week 3Grading Weight: 12.5%Dirt Bikes U.S.A.—Redesign Database2Task 1:Dirt Bikes U.S.A. sells primarily through its distributors.Click here to download the database file. It maintains asmall customer database with the following data:Customer nameAddress (street, city, state, ZIP code)Telephone numberModel purchasedDate of purchaseDistributorThe distributors collect this data after each sale and thenforward it to Dirt Bikes. Dirt Bikes would like to be able tomarket more aggressively to its customers. The marketingdepartment would like to send customers e-mail noticesof special racing events and of sales on parts. It wouldalso like to learn more about customers’ interests andtastes, their ages, years of schooling, other sports inwhich they are interested, and whether they attend dirtbike racing events. In addition, Dirt Bikes would like toknow whether its customers own more than onemotorcycle. If a motorcycle was purchased from DirtBikes, the company would like to know the date ofpurchase, model name, and distributor from whom it waspurchased. If the customer owns a non-Dirt Bikesmotorcycle, the company would like to know the5CriteriaDid you preparea reportcontaininganswers to thecase studyquestions?Did you includeappropriatetables, reports,and databasesto support theiranswers?Did you design asolution asinstructed in theDirt Bikes U.S.Acase study?PointsAssigned35%25%40%PointsEarnedBU131ProjectProjectDescription/Requirements of Project PartPartmanufacturer and model of the other motorcycle (ormotorcycles) and the distributor from whom thecustomer purchased that motorcycle.On the basis of the above information, perform thefollowing activities:1.Redesign Dirt Bikes’ customer database so that itcan store and provide the information neededfor marketing. You will need to develop a designfor the new customer database and thenimplement it using database software. Considerusing multiple tables in your new design.Populate each new table with 10 records.2.Develop reports that would be of interest to DirtBikes’ marketing and sales department (forexample, lists of repeat Dirt Bikes customers, DirtBikes customers who attend racing events, or theaverage ages and years of schooling of Dirt Bikescustomers) and print them.Task 2:The management is concerned that Dirt Bikes’ computersystems could be vulnerable to power outages,vandalism, computer viruses, natural disasters, ortelecommunications disruptions. You have been asked toperform an analysis of system vulnerabilities and disasterrecovery planning for the company.Answer the questions below. You may refer to Table 7.2,“Examples of Computer Crime,” on page 242 of yourtextbook for more information.1.Identify the threats to which Dirt Bikes’ systemsare most vulnerable.6Evaluation CriteriaBU131ProjectProjectDescription/Requirements of Project PartPart2.Classify the most critical systems at Dirt Bikes.What would be the impact on the company ifthese systems could not operate? How longcould the company survive if these systems weredown? Which systems are the most important toback up and restore in the event of a disaster?3.Use the Internet to locate two disaster recoveryservices that could be used by a small business,such as Dirt Bikes. Compare them in terms of theservices they offer. Which of the two servicesshould Dirt Bikes use? How would these serviceshelp Dirt Bikes recover from a disaster?Task 3:Dirt Bikes cannot fulfill many of its orders on timebecause of delays in sourcing some important motorcyclecomponents and parts, such as fuel tanks. Complaints aremounting from distributors who fear losing sales if thedirt bikes they have ordered are delayed too long. DirtBikes’ management has asked you to help address someof its supply chain issues. Based on this information,answer the questions listed below:1.Use the Internet to locate alternative suppliersfor motorcycle fuel tanks. Identify two or threesuppliers. Find out the time and the cost ofshipping a fuel tank (weighing about five pounds)by ground (surface delivery) from each supplierto Dirt Bikes in Carbondale, Colorado. Which ofthese suppliers is likely to ship the fuel tanks inthe shortest amount of time and at the lowestcost?7Evaluation CriteriaBU131ProjectProjectDescription/Requirements of Project PartPart2.The management wants to know about anysupply chain management software that wouldbe appropriate for a small business, such as DirtBikes. Use the Internet to locate two providers ofsupply chain management software. Brieflydescribe the capabilities of the two softwareapplications and indicate how they could helpDirt Bikes. Which of these products would bemore appropriate for Dirt Bikes? Why?3.(Optional) Use electronic presentation softwareto summarize your findings for management.Task 4:Dirt Bikes’ management believes that the company couldbenefit from e-commerce. The company sells motorcyclesand parts primarily through authorized dealers. It alsoadvertises in various magazines catering to dirt bikeenthusiasts and maintains booths at important off-roadmotorcycle racing events. You have been asked to explorehow Dirt Bikes could benefit from e-commerce and byselling online through a website.1.Prepare a report for management that answersthe following questions:a.How could Dirt Bikes benefit from ecommerce? Should it sell itsmotorcycles or parts online? Should ituse its website to advertise its productsand services or to offer customerservice?b.How would a website provide value toDirt Bikes? Use the Internet to research8Evaluation CriteriaBU131ProjectProjectDescription/Requirements of Project PartPartthe cost of an e-commerce site for asmall-to medium-sized company. Howmuch revenue or cost savings would thewebsite have to produce to make it aworthwhile investment for Dirt Bikes?2.Prepare specifications to describe the functionsthat should be performed by Dirt Bikes’ website.Provide links to other websites or systems inyour specifications.3.(Optional) Design the home page for Dirt Bikes’website along with an important secondary pagelinked to the home page using a word processoror a Web page development tool of your choice.4.Identify some important website features thatcan be used to create customer relationships.Analyze the challenge that Dirt Bikes may face inthe course of creating customer intimacy andloyalty.Task 5:Dirt Bikes promotes itself as a “learning company.” Itencourages employees to undergo training to help themadvance in their careers. As employees move on, theirpositions fall vacant. These positions must be filledquickly to maintain the company’s pace of production.Dirt Bikes’ human resources staff would like to find a wayof quickly identifying qualified employees who have thetraining to fill vacant positions. Once the company knowswho these employees are, it has a better chance of fillingopen positions internally rather than paying to recruitoutsiders. Dirt Bikes would like to track each employee’s9Evaluation CriteriaBU131ProjectProjectDescription/Requirements of Project PartPartyears of education and the title and date of completion ofany training that each employee has attended. Dirt Bikes’existing employee database is limited to basic humanresources data, such as employee name, identificationnumber, birth date, address, telephone number, maritalstatus, job position, and salary. Click here to downloadsome sample records from this database. Dirt Bikes’human resources staff maintains employees’ skills andtraining data in paper folders.On the basis of this information, prepare a systemanalysis report describing Dirt Bikes’ problem andsuggesting a solution that can be implemented usingdatabase software. The report should include thefollowing points:Description of the problem and its organizationaland business impactProposed solution and solution objectivesInformation requirements to be addressed bythe solutionPeople, organization, and technology issues tobe addressed by the solution, including changesin business processesOn the basis of the requirements you have identified,design the solution using database software and populateit with at least 10 records per table. Consider whether youcan use or modify the existing employee database in yourdesign. Print out the design for each table in your newapplication. Use the system to create queries and reportsthat would be of interest to the management, such as thenames of employees who have a college education, orhave undergone training in project management or10Evaluation CriteriaBU131ProjectProjectDescription/Requirements of Project PartPartadvanced computer-aided design (CAD) tools. If possible,use electronic presentation software to summarize yourfindings for the management.Submit a report including the answers to thequestions posed in this part of the project.Include appropriate databases to support youranswers.Submission Requirements:Submit your findings in an MS Word document.Submit the updated spreadsheet and databasefiles.Font: Arial; 12-pointLine Spacing: DoubleAssigned: Week 3Due: Week 5Grading Weight: 12.5%End of Project Description11Evaluation Criteria

  • Continue to make an order HERE