Dennis Kennedy

Cleveland, OH 44125
[email protected]

The Job Schedule is displayed in Hyperlink.
The Job Detail Schedule is displayed in Vertical Form.
The Resource Schedule is displayed in Hyperlink.
The Resource Detail Schedule is displayed in Vertical Form.

This information would be stored in multi-user database tables in FoxPro '.dbf-style'.
Because these are FoxPro Tables, FoxPro can be used (in multi-user mode)
for Maintenance, as well as for Removing Jobs and Resources (People).
And, Lotus 123 and Excel can attach the tables for additional charting, etc.

For simplicity of this Example, I am only displaying First Names.
The Finished Product could combine Last Name, First & Middle Initial with Skill or Employee ID#.
(See Notes at the end of this document.)

Notes and Descriptions could be added to Jobs and Resources (People).
Bar Chart Displays could be added for Quick and Simple Visual Charting.
Adding 'Completion' Schedules could track Job and Resource (People) Progress.
Parishable Materials could also be added into Resources for Planning.
Optimizational Calculations could be added for Automating Scheduling.

Job Schedule Bar Chart

This would show a Bar Chart of all Jobs with Resource (People) completed. You would click on any Job Hyperlink to bring a 'Job Detail' for editing. (An Example to be added at a later date.)

- Portion of Job Completion -
Job #	Pct	Percentage
10001	99%
10002	98%
10003	95%
10004	95%
10005	98%
10006	20%
10007	20%
10008	20%

Job Schedule

This would show a chart of all Jobs with 'Bars'. This is not nearly as useful as the Job Schedule below that is displayed in Hyperlink. Both actually display 'Bars'. This one uses a picture. The one below uses Resource (People) Hyperlinks. You would click on any Job Hyperlink to bring a 'Job Detail' for editing. But, you could add this later as a 'Quick View'. (An Example to be added at a later date.)

Job Schedule Job # 11-21-98 11-28-98 12-05-98 12-12-98 12-19-98 12-26-98 01-02-99 01-09-99 etc 10001 etc 10002 etc 10003 etc 10004 etc 10005 etc 10006 etc 10007 etc 10008 etc

Job Schedule

This would show a chart of all Jobs with Resource (People) assigned. You would click on any Job Hyperlink to bring a 'Job Detail' for editing. You would click on any Resource Hyperlink to bring a 'Resource Detail', too.

Job Schedule Job # 11-21-98 11-28-98 12-05-98 12-12-98 12-19-98 12-26-98 01-02-99 01-09-99 etc 10001 Employee1 Employee2 Employee3 Employee4 Employee5 Employee6 Employee7 Employee8 etc 10002 Employee2 Employee3 Employee4 Employee5 Employee6 Employee7 Employee8 Employee1 etc 10003 Employee3 Employee4 Employee5 Employee6 Employee7 Employee8 Employee1 Employee2 etc 10004 Employee4 Employee5 Employee6 Employee7 Employee8 Employee1 Employee2 Employee3 etc 10005 Employee5 Employee6 Employee7 Employee8 Employee1 Employee2 Employee3 Employee4 etc 10006 Employee6 Employee7 Employee8 Employee1 Employee2 Employee3 Employee4 Employee5 etc 10007 Employee7 Employee8 Employee1 Employee2 Employee3 Employee4 Employee5 Employee6 etc 10008 Employee8 Employee1 Employee2 Employee3 Employee4 Employee5 Employee6 Employee7 etc New Resource

Job Detail Schedule

You would select from the Dropdowns to fill the Job Schedule. (Each dropdown would be filled with available resources.)

Job Detail Schedule 10001 Date Current Select 11-21-98 Employee1 Employee8 Employee2 Employee5 Employee3 Employee6 Employee7 Employee4 Employee1 11-28-98 Employee2 Employee8 Employee2 Employee5 Employee3 Employee6 Employee7 Employee4 Employee1 12-05-98 Employee3 Employee8 Employee2 Employee5 Employee3 Employee6 Employee7 Employee4 Employee1 12-12-98 Employee4 Employee8 Employee2 Employee5 Employee3 Employee6 Employee7 Employee4 Employee1 12-19-98 Employee5 Employee8 Employee2 Employee5 Employee3 Employee6 Employee7 Employee4 Employee1 12-26-98 Employee6 Employee8 Employee2 Employee5 Employee3 Employee6 Employee7 Employee4 Employee1 01-02-99 Employee7 Employee8 Employee2 Employee5 Employee3 Employee6 Employee7 Employee4 Employee1 01-09-99 Employee8 Employee8 Employee2 Employee5 Employee3 Employee6 Employee7 Employee4 Employee1 etc etc etc

Resource Schedule

This would show a chart of all Resources (People) with Jobs assigned. You would click on any Resource Hyperlink to bring a 'Resource Detail' for editing. You would click on any Job Hyperlink to bring a 'Job Detail', too.

Resource Schedule Resource 11-21-98 11-28-98 12-05-98 12-12-98 12-19-98 12-26-98 01-02-99 01-09-99 etc Employee8 10008 10007 10006 10005 10004 10003 10002 10001 etc Employee2 10002 10001 10008 10007 10006 10005 10004 10003 etc Employee5 10005 10004 10003 10002 10001 10008 10007 10006 etc Employee3 10003 10002 10001 10008 10007 10006 10005 10004 etc Employee6 10006 10005 10004 10003 10002 10001 10008 10007 etc Employee7 10007 10006 10005 10004 10003 10002 10001 10008 etc Employee4 10004 10003 10002 10001 10008 10007 10006 10005 etc Employee1 10001 10008 10007 10006 10005 10004 10003 10002 etc New Job

Resource Detail Schedule

You would select from the Dropdowns to fill the Job Schedule. (Each dropdown would be filled with vacant jobs.)

Resource Detail Schedule Employee1 Date Current Select 11-21-98 10001 10001 10002 10003 10004 10005 10006 10007 10008 11-28-98 10008 10001 10002 10003 10004 10005 10006 10007 10008 12-05-98 10007 10001 10002 10003 10004 10005 10006 10007 10008 12-12-98 10006 10001 10002 10003 10004 10005 10006 10007 10008 12-19-98 10005 10001 10002 10003 10004 10005 10006 10007 10008 12-26-98 10004 10001 10002 10003 10004 10005 10006 10007 10008 01-02-99 10003 10001 10002 10003 10004 10005 10006 10007 10008 01-09-99 10002 10001 10002 10003 10004 10005 10006 10007 10008 etc etc etc

Notice that Phases 1 through 4 will be complete, except for replacing time 'lines' with time 'displays'. (Time 'lines' can be easily added at a later time, but time 'displays' provide more information and initial flexibility. And the Phase 5 'automation' may be added at a later time.)

Furthermore, since all work performed is done so in 'real time' multi-user mode, against the web-database, results are instantaneous and all major error is absolutely minimized.

Finally, the manipulation and display of the Job Schedule and of the Job Detail Schedule also allows the INVERSE to be true - the manipulation and display of the Resource (People) Schedule and the Resource (People) Detail Schedule.

Phase 0. Create a Web Engine (Multi-Tier).

Phase 1. ...accept availability of all non-operations personnel (Resources) and create an output consisting of available individuals, their skills and the time when these individuals will be available for application to engineering tasks. This output shall cover the period of one year broken down into intervals of one week.

Phase 2. ...create individual job schedule/manpower/skill requirements (online in the MRP Application) for the several engineering jobs expected. ...map these individual (Job Schedules) against Phase 1. ...ability, on a week-by-week basis, to match the manpower number/skill requirements of the individual engineering jobs against the manpower number/skills available so that all jobs can thereby be scheduled.

Phase 3: ...development of user-friendly, web-based software that will permit the display of the results of Phases 1 and 2 (not in timelines at this time, but in time displays). This software will accept the manual inputs from Phase 2 and display two types of screens. The first display shall consist of a series of individuals schedule (displays) for each engineering job showing milestones and deliverables (M/D's). ...The software shall allow the user to click on any individual job's schedule line to bring up a second screen which displays all of the particular job's details in (time displays).

Phase 4. Using the result of Phase 3, the offeror shall develop additional user-friendly, web-based software which will allow management to adjust the outputs from Phase 1. This Phase's software will also provide a manual method for the adjustment of each individual engineering job's schedule to reflect the changes made to Phase 1 output.