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 good local word-of–mouth reputation and name recognition
When a prospective customer enters the Ace showroom, he or she is greeted by
an Ace sales representative. The sales representative manually fills out a form
with information such as the prospective customer’s name, address, telephone
number, date of visit, and make and model of the vehicle in which the customer
Ace does not believe it has enough information about its customers. It cannot
easily determine which prospects have made auto purchases, nor can it identify
which customer touch points have produced the greatest number of sales leads
or actual sales so it can focus advertising and marketing more on the channels
that generate the most revenue. Are purchasers discovering Ace from
newspaperads, from word of mouth, or from the Web?
Prepare a systems analysis report detailing Ace’s problem and a system
solution that can be implemented using PC database management software.
The company has a PC with Internet access and the full suite of Microsoft
Office desktop productivity tools. Then use database software to develop a
simple system solution. Your systems analysis report should include the
following:
• Description of the problem and its organizational and business impact
• Proposed solution, solution objectives, and solution feasibility