Case
Study
Real
Seal, Inc
A Few Screen
Shots of the Workflow Solution...
PROCESS
ONE
Created
a Menu Bar for user friendly access to forms,
reports, queries, database window
PROCESS
TWO
Created
simple entry form to hook clients into bids /
quotes / proposals / inventory...
PROCESS
THREE
Created an Injection
Quotes input form for logging daily, weekly,
monthly quotes for specific companies containing
critical injection design component needs. Includes
a drop down search box to quickly go to other
client quotes and a client drop down to assign
client information to each specific injection
quote. Also last date the record was updated
is automatic, 45 different input variables all
totalling into 5 subgoups add up in real time
and also into a grand total cost box. Print
button for one click reports for instant printing
of screen information, transfer button to send
this quote's info to to the Injection Part form
as a working job and a duplicate button to instantly
recreate the exact quote information for a client
with similar needs.
top
PROCESS
FOUR
Created
an Injection Part input form to hold
quotes that have been accepted by clients and
passed from the Injection Quote form to the
Injection Part form for actual work jobs. Exact
matching similarities to the Injection Quote
input form. Also developed a button to send
all part information to an exact excel spreadsheet
for inventory tracking.
PROCESS
FIVE
Created
a Compression Quotes input form for logging
daily, weekly, monthly quotes for specific companies
with seals containing critical compression design
components. Includes drop down search box to quickly
go to other quotes, client drop down to assign
client information to specific compression quotes,
last date record was updated, 45 different input
variables all totalling into 8 subgoups in real
time and that also adding up in a grand total
cost box. Print button for one click reports for
instant printing of screen information, transfer
button to send this quote info to the Compression
Part form as a working job and a duplicate button
to instantly recreate the exact quote information
for a client with similar compression seal needs.
top
PROCESS
SIX
Created
a Compression Part input form to hold quotes
that have been accepted by clients and passed
from the Compression Quote form to the Compression
Part form with exact matching similarities to
the Compression Quote input form. Also
developed a button to send all part information
to an exact excel spreadsheet for inventory tracking.
PROCESS
SEVEN
Designed
business intelligence reports that group by
specific filters and reveal short and long term
client and component patterns...
- Report
of injection parts by company.
- Report
of injection parts by material.
- Report
of injection quotes by company.
- Report
of injection quotes by material.
- Report
of compression parts by company.
- Report
of compression parts by material.
- Report
of compression quotes by company.
- Report
of compression quotes by material.
top
PROCESS
EIGHT
Built
4 lookup forms for the many changing costing
variables within the software to add / edit
or delete future cost changes.
Form
1 - Injection Raw Material Costs Add / Edit
/ Delete form
Form 2 - Compression Raw Material Costs Add
/ Edit / Delete form
Form 3 - Dynamic Injection Costing Items
- Add / Edit / Delete form
Form 4 - Dynamic Compression Costing Items -
Add / Edit / Delete form
top
