Transcript Microsoft Powerpoint Presentation

Kyle Croce
Mike Hummel
John McGrady
Patrick Talbot
http://www.acsu.buffalo.edu/~patrickt/
Background Information
 Inefficiencies were discovered within Elite Medical
Supply
 Biggest problem was a lack of technology
utilization to organize this growing company
 We were hired, and created a Microsoft Access
Database to solve these issues
Specifics of the Problem
 Inability to easily track customers who haven’t paid for
their products
 Hours are spent tracking down unpaid orders and the
contact information associated with the
buyers/insurance companies
 No way of tracking the products sold for a given time
period w/o going through each individual paper record
Our Proposed Solution
 Our database can track all details associated with an
order, such as customer details, insurance company
details, products sold, price paid, etc.
 It’s main purpose is to show the user who hasn’t paid in
full for their order
 This database can essentially eliminate the need for
paper, with everything being tracked through the
database
The Value
 A more organized accounts receivable department,
with information that can be worked on by multiple
employees, and be backed up off site.
 A less labor intensive method for collecting overdue
payments, meaning less overtime for an already
overworked staff.
 The information stored in the database can be used to
extract information useful for your company.
Operation of Database
 When an employee at Elite Medical processes and
order for a customer, they will either add a new
customer to the database, or add an order to an
existing customer.
 When an order is placed, the price of all the products
is calculated and a bill is created
 When payment is received, it is recorded into the
database, and the patient will no longer show as
overdue.
Conclusion
 We hope the database we have created will help Elite
Medical Supply continue to grow by utilizing advanced
technology to eliminate inefficiencies within the
company