(solution) ONLY PART TWO TO OF THE PROJECT!!! NOTE THAT I NEED THE ACCESS

(solution) ONLY PART TWO TO OF THE PROJECT!!! NOTE THAT I NEED THE ACCESS

ONLY PART TWO TO OF THE PROJECT!!! NOTE THAT I NEED THE ACCESS FILE AND SPREADSHEETS DON’T PUT THEM INSIDE THE WORD DOC THEY MUST BE SEPERATE!! 

Case study link below

http://wps.prenhall.com/bp_laudon_essbus_7/48/12304/3149825.cw/#C 

BU131
Project
PROJECT DESCRIPTION
Project Introduction:
Dirt Bikes U.S.A. is a small company headquartered in Carbondale, Colorado. It manufactures and sells its own brand of
off-road motorcycles. The company, founded in 1993, produces customized dirt bikes for racing and off-road
recreational riding using the best quality components from all over the world. Today, the company faces a new set of
challenges and opportunities. You have been asked, as a consultant, to apply your knowledge of information systems
to 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 a
business. 4. Choose appropriate security, backup, virus protection, and control measures for a business's information
systems. 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. 1 BU131
Project
PROJECT SUBMISSION PLAN Project Description/Requirements of Project Part Evaluation Criteria Part
Dirt Bikes U.S.A.?Case Study 1 Task 1:
Examine the Dirt Bikes U.S.A. case study and review How
to Analyze a Case Study. After reading the case study,
review the following information: Company History and Background Organization Chart and Employees Products and Services Sales and Marketing On the basis of this information, answer the following
questions:
1. Which products should the company restock? 2. Which stores and sales regions would benefit
from promotional campaigns and additional
marketing? 3. When (what time of year) should the company
offer products at full price and when should it
offer discounts? Task 2:
Dirt Bikes? management wants to be sure that it is
pursuing the right competitive strategy. You have been
asked to perform a competitive analysis of the company
to find the information you need. Prepare a report that
analyzes Dirt Bikes using the value chain and competitive
forces models. Your report should include the following:
1. 2 Which activities at Dirt Bikes create the most Criteria
Did the students
answer the
specified case
study questions?
Did you provide
answers that
follow a logical
pattern and
include an
explanation for
assumptions and
appropriate
examples?
Did you include
appropriate
spreadsheet
data to support
their answers? Points
Assigned
35% 45% 20% Points
Earned BU131
Project
Project Description/Requirements of Project Part Part
value?
2. How does Dirt Bikes provide value to its
customers? 3. Who are Dirt Bikes? major competitors? How do
the prices of their products compare with those
of Dirt Bikes?? What product features do they
emphasize? 4. What are the competitive forces that can affect
the industry? 5. What competitive strategy should Dirt Bikes
pursue? 6. What information systems best support that
strategy? 7. (Optional) Use electronic presentation software
to summarize your findings for the management. Task 3:
Dirt Bikes would like to implement new software for
production planning, quality control, and scheduling. The
software will be used by 25 members of the company?s
manufacturing staff. The management is wondering
whether to purchase the software from a commercial
vendor along with the hardware required or to use a
hosted software solution from a Software as a Service
(SaaS) provider. (The hosted software runs on the service
provider?s computer.) You have been asked to help the
management with this rent-versus-buy decision by
calculating the total cost of each option over a three-year
period. The cost of purchasing the software includes the
initial purchase price of the software (licensing fee of
$100,000 in the first year), and the cost of implementing
3 Evaluation Criteria BU131
Project
Project Description/Requirements of Project Part Part
and customizing the software in the first year ($20,000).
Hardware costs include a server to run the software (a
first-year purchase of $4,000), one information systems
specialist devoting half his or her time to support the
software ($55,000 in full-time annual salary and benefits
with a 3 percent annual salary increase each year after
the first year), and user training in the first year
($10,000).You also need to account for the cost of annual
software upgrades ($5,000). On the other hand, the costs
of renting hosted software include the rental fees ($2,500
annually per user), implementation and customization
costs ($12,000 in the first year), and training ($10,000 in
the first year).
1. Use your spreadsheet software to calculate the
total cost of renting or purchasing this software
over 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 rent
or buy the hardware and software? 3. (Optional) If possible, use electronic presentation
software to summarize your findings for
management. 4.
Submission Requirements: Submit your findings in an MS Word document. Submit the updated spreadsheet and database
files. 4 Font: Arial; 12-point
Line Spacing: Double Evaluation Criteria BU131
Project
Project Description/Requirements of Project Part Evaluation Criteria Part
Assigned: Week 1
Due: Week 3
Grading Weight: 12.5%
Dirt Bikes U.S.A.?Redesign Database 2 Task 1:
Dirt Bikes U.S.A. sells primarily through its distributors.
Click here to download the database file. 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 Distributor The distributors collect this data after each sale and then
forward it to Dirt Bikes. Dirt Bikes would like to be able to
market more aggressively to its customers. The marketing
department would like to send customers e-mail notices
of special racing events and of sales on parts. It would
also like to learn more about customers? interests and
tastes, their ages, years of schooling, other sports in
which they are interested, and whether they attend dirt
bike racing events. In addition, Dirt Bikes would like to
know whether its customers own more than one
motorcycle. If a motorcycle was purchased from Dirt
Bikes, the company would like to know the date of
purchase, model name, and distributor from whom it was
purchased. If the customer owns a non-Dirt Bikes
motorcycle, the company would like to know the
5 Criteria
Did you prepare
a report
containing
answers to the
case study
questions?
Did you include
appropriate
tables, reports,
and databases
to support their
answers?
Did you design a
solution as
instructed in the
Dirt Bikes U.S.A
case study? Points
Assigned
35% 25% 40% Points
Earned BU131
Project
Project Description/Requirements of Project Part Part
manufacturer and model of the other motorcycle (or
motorcycles) and the distributor from whom the
customer purchased that motorcycle.
On the basis of the above information, perform the
following activities:
1. Redesign Dirt Bikes? customer database so that it
can store and provide the information needed
for marketing. You will need to develop a design
for the new customer database and then
implement it using database software. Consider
using multiple tables in your new design.
Populate each new table with 10 records. 2. Develop reports that would be of interest to Dirt
Bikes? marketing and sales department (for
example, lists of repeat Dirt Bikes customers, Dirt
Bikes customers who attend racing events, or the
average ages and years of schooling of Dirt Bikes
customers) and print them. Task 2:
The management is concerned that Dirt Bikes? 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 system vulnerabilities and disaster
recovery planning for the company.
Answer the questions below. You may refer to Table 7.2,
?Examples of Computer Crime,? on page 242 of your
textbook for more information.
1. Identify the threats to which Dirt Bikes? systems
are most vulnerable. 6 Evaluation Criteria BU131
Project
Project Description/Requirements of Project Part Part
2. Classify the most critical systems at Dirt Bikes.
What would be the impact on the company if
these systems could not operate? How long
could the company survive if these systems were
down? Which systems are the most important to
back up and restore in the event of a disaster? 3. Use the Internet to locate two disaster recovery
services that could be used by a small business,
such as Dirt Bikes. Compare them in terms of the
services they offer. Which of the two services
should Dirt Bikes use? How would these services
help Dirt Bikes recover from a disaster? Task 3:
Dirt Bikes cannot fulfill many of its orders on time
because of delays in sourcing some important motorcycle
components and parts, such as fuel tanks. Complaints are
mounting from distributors who fear losing sales if the
dirt bikes they have ordered are delayed too long. Dirt
Bikes? management has asked you to help address some
of its supply chain issues. Based on this information,
answer the questions listed below:
1. Use the Internet to locate alternative suppliers
for motorcycle fuel tanks. Identify two or three
suppliers. Find out the time and the cost of
shipping a fuel tank (weighing about five pounds)
by ground (surface delivery) from each supplier
to Dirt Bikes in Carbondale, Colorado. Which of
these suppliers is likely to ship the fuel tanks in
the shortest amount of time and at the lowest
cost? 7 Evaluation Criteria BU131
Project
Project Description/Requirements of Project Part Part
2. The management wants to know about any
supply chain management software that would
be appropriate for a small business, such as Dirt
Bikes. Use the Internet to locate two providers of
supply chain management software. Briefly
describe the capabilities of the two software
applications and indicate how they could help
Dirt Bikes. Which of these products would be
more appropriate for Dirt Bikes? Why? 3. (Optional) Use electronic presentation software
to summarize your findings for management. Task 4:
Dirt Bikes? management believes that the company could
benefit from e-commerce. The company sells motorcycles
and parts primarily through authorized dealers. It also
advertises in various magazines catering to dirt bike
enthusiasts and maintains booths at important off-road
motorcycle racing events. You have been asked to explore
how Dirt Bikes could benefit from e-commerce and by
selling online through a website.
1. Prepare a report for management that answers
the following questions:
a. How could Dirt Bikes benefit from ecommerce? Should it sell its
motorcycles or parts online? Should it
use its website to advertise its products
and services or to offer customer
service? b. How would a website provide value to
Dirt Bikes? Use the Internet to research 8 Evaluation Criteria BU131
Project
Project Description/Requirements of Project Part Part
the cost of an e-commerce site for a
small-to medium-sized company. How
much revenue or cost savings would the
website have to produce to make it a
worthwhile investment for Dirt Bikes?
2. Prepare specifications to describe the functions
that should be performed by Dirt Bikes? website.
Provide links to other websites or systems in
your specifications. 3. (Optional) Design the home page for Dirt Bikes?
website along with an important secondary page
linked to the home page using a word processor
or a Web page development tool of your choice. 4. Identify some important website features that
can be used to create customer relationships.
Analyze the challenge that Dirt Bikes may face in
the course of creating customer intimacy and
loyalty. Task 5:
Dirt Bikes promotes itself as a ?learning company.? It
encourages employees to undergo training to help them
advance in their careers. As employees move on, their
positions fall vacant. These positions must be filled
quickly to maintain the company?s pace of production.
Dirt Bikes? human resources staff would like to find a way
of quickly identifying qualified employees who have the
training to fill vacant positions. Once the company knows
who these employees are, it has a better chance of filling
open positions internally rather than paying to recruit
outsiders. Dirt Bikes would like to track each employee?s
9 Evaluation Criteria BU131
Project
Project Description/Requirements of Project Part Part
years of education and the title and date of completion of
any training that each employee has attended. Dirt Bikes?
existing employee database is limited to basic human
resources data, such as employee name, identification
number, birth date, address, telephone number, marital
status, job position, and salary. Click here to download
some sample records from this database. Dirt Bikes?
human resources staff maintains employees? skills and
training data in paper folders.
On the basis of this information, prepare a system
analysis report describing Dirt Bikes? problem and
suggesting a solution that can be implemented using
database software. The report should include the
following points: Description of the problem and its organizational
and business impact Proposed solution and solution objectives Information requirements to be addressed by
the solution People, organization, and technology issues to
be addressed by the solution, including changes
in business processes On the basis of the requirements you have identified,
design the solution using database software and populate
it with at least 10 records per table. Consider whether you
can use or modify the existing employee database in your
design. Print out the design for each table in your new
application. Use the system to create queries and reports
that would be of interest to the management, such as the
names of employees who have a college education, or
have undergone training in project management or
10 Evaluation Criteria BU131
Project
Project Description/Requirements of Project Part Part
advanced computer-aided design (CAD) tools. If possible,
use electronic presentation software to summarize your
findings for the management. Submit a report including the answers to the
questions posed in this part of the project. Include appropriate databases to support your
answers. Submission Requirements: Submit your findings in an MS Word document. Submit the updated spreadsheet and database
files. Font: Arial; 12-point Line Spacing: Double Assigned: Week 3
Due: Week 5
Grading Weight: 12.5% End of Project Description 11 Evaluation Criteria