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

   ...and dat is dat...


If you have the Vision- We have the Code