CA2885131C - Resource planning method and system - Google Patents
Resource planning method and system Download PDFInfo
- Publication number
- CA2885131C CA2885131C CA2885131A CA2885131A CA2885131C CA 2885131 C CA2885131 C CA 2885131C CA 2885131 A CA2885131 A CA 2885131A CA 2885131 A CA2885131 A CA 2885131A CA 2885131 C CA2885131 C CA 2885131C
- Authority
- CA
- Canada
- Prior art keywords
- visits
- resources
- resource
- schedule
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Quality & Reliability (AREA)
- Biodiversity & Conservation Biology (AREA)
- Game Theory and Decision Science (AREA)
- Life Sciences & Earth Sciences (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Educational Administration (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
FIELD OF INVENTION
[0001] The invention is generally related to operations support systems and more specifically, to a method of and system for managing and planning future use of resources.
BACKGROUND OF THE INVENTION
SUMMARY OF THE INVENTION
When booking new business they will look to find available timeslots at locations that have the capability and capacity to perform the work. They have to take into account the multitude of factors that affect such plans, for example: human resources availability, location capabilities and availability, long term contracts, etc. The goals are to keep the hangars full, identify maintenance window opportunities, and ensure that they are not overbooked. The system and method described hereinafter, sets out ways of managing such resources.
Hence, the system provides a centralized, real-time management system to accommodate this.
The user can easily change the track if he/she wishes to.
Other exemplary 'what if' scenarios may include the following:
1. Add new visit to determine effect on labour demand 2. Add new labour capacity 3. Reschedule a current visit 4. Move a current visit from one line to another line 5. Add another line of maintenance As aircraft hangars generally have only one large door, it is often necessary to move aircraft and MRO tasks around so one aircraft does not "box in" another aircraft in the same hanger.
When a visit is first created on the system, it can be moved around. You can also "lock" a visit, setting a flag which prevents the visit from being accidently moved.
This is done by clicking on the "lock" icon shown in Figures 7 to 9, or actuating the slide shown in Figures and 11. Such an action sets a flag in the data record for the visit, to the "locked" state.
'What if scenarios are done in a way that is analogous to the "Apply" and "Save" approach which is commonly seen on Microsoft based personal computers (PCs). That is, the user can manipulate the schedule on his/her PC to observe the possible impact, and the changes are only updated on the main database 40 if the user clicks on the "save" button.
Otherwise, the user can cancel the experimental changes and the proposed amendments will disappear.
BRIEF DESCRIPTION OF THE DRAWINGS
FIGURE 1 shows an exemplary user network overview in accordance with an embodiment of the invention;
FIGURE 2 shows an exemplary software architecture overview in accordance with an embodiment of the invention;
FIGURES 3 and 4 show exemplary slot planner user interfaces in accordance with an embodiment of the invention;
FIGURE 5 shows an exemplary 'edit capacity' user interface in accordance with an embodiment of the invention;
FIGURE 6 shows an exemplary 'edit work areas' user interface in accordance with an embodiment of the invention;
FIGURE 7 shows an exemplary user interface for a newly created visit in accordance with an embodiment of the invention;
FIGURES 8 and 9 show, respectively, expanded and collapsed displays of a visit record in accordance with an embodiment of the invention;
FIGURE 10 shows an exemplary user interface for displaying visit details in accordance with an embodiment of the invention;
FIGURE 11 shows the exemplary user interface of Figure 10, in edit mode, in accordance with an embodiment of the invention;
FIGURE 12 shows an exemplary user interface for displaying resource demand details in accordance with an embodiment of the invention;
FIGURE 13 shows the exemplary user interface of Figure 12, in edit mode, in accordance with an embodiment of the invention; and FIGURES 14 and 15 shows exemplary process flow diagrams in accordance with embodiments of the invention.
DETAILED DESCRIPTION
As explained above, a 'track' or 'slot' is a defined area in an aircraft hangar, in which an aircraft can be located so that maintenace, repair and inspection tasks can be performed. A
visit 52 typically contains multiple resource demand bars 54. These resource demand bars 54 represent the time required for a given resource demand generated by the visit 52. These resource demand bars 54 therefore mimic phased resource demands of a visit 52. A resource demand bar 54 is added by double-clicking in an empty area of a visit pane 56. The resource demand bars 54 can be moved within the confines of the visit 52 they belong to, simply by dragging and dropping them.
When a new visit 52 is added, there are no resource demands yet (see Figure 7 as an example of a display for a new visit). Clicking on the "Add a demand" button 90 in Figure 7 allows the user to enter new tasks. As the new tasks are added, they will appear as the resource demand bars 54 shown in Figure 8. The titles of the tasks in Figure 8 may be edited by clicking on the resource demand bars 54 themselves. One user may refer to the tasks as "phases" while another may use explicit labels such as "inspection", "repair", "testing", "wrap-up", etc. The user may also drag the left and right edges of each resource demand bar 54 to amend the duration. Clicking between the resource demand bars 54 in Figure 8 will launch a new resource demand bar 54 between the resource demand bar 54 already appearing.
When the visit 52 is collapsed as shown in Figure 9, an icon 92 consisting of a number of horizontal bars, will appear in the top right corner, showing that the visit 52 includes a number of resource demand bars 54.
Phase 1 may have Inspector demand at 2, Phase 2 may have Engineers at 1 and Mechanics at 10, and so on.
Note that updating the value in the duration field 104 in Figure 11 will recalculate the release date 106, and conversely, updating the release date 106 in Figure 11 will recalculate the duration value 104. These calculations can be effected with simple code within the GUI. Once the edits have been completed they can either by saved by clicking on the "save" button 122, or cancelled by clicking on the "cancel" button 124. Note that clicking on the "save" button 122 of Figure 11 does not save the data back to the main database 40, but merely saves the changes locally. It is only when changes are saved from the interface of Figures 3 and 4 that the changes are sent back to the main database 40.
button 74 of Figure 12, the window enters the edit mode 76 shown in Figure 13. All of the fields in Figure 13 are the same as those of Figure 12, except that their entries can be changed while in the editing mode 76. Like the visit interface described above, values in Figure 13 can be amended by clicking on the field, or by using other standard window functionality such as clicking on up/down arrows or using an interactive pop-up calendar. Note that updating the value in the duration field 66 in Figure 13 will recalculate the release date 68. Conversely, updating the release date 68 in Figure 13 will recalculate the duration value 66. These calculations can be effected with simple code within the GUI. Once the edits have been completed they can either by saved by clicking on the "save" button 78, or cancelled by clicking on the "cancel" button 80. Note that clicking on the "save" button 78 of Figure 13 does not save the data back to the main database 40, but merely saves the changes locally. It is only when changes are saved from the interface of Figures 3 and 4 that the changes are sent back to the main database 40.
Once the user has completed their edits, they can be saved by clicking on the "Save" button 172, or they can be abandoned by clicking on the "Cancel" button 174. Note that the "save"
button 172 on the edit capacity interface 160 only effects a local save.
Changes to the data and the resulting calculations will only be effected on the main database 40 if the "save" 140 or "save as" 142 are affected on the main slot plan GUI 50.
The user may delete existing slots 58 from the plan by clicking on the "X" symbol 186 associated with a given slot 58. The user is prompted for confirmation when deleting a hangar area/slot 58 that has a visit 52 scheduled. Once the user has completed their edits, they can be saved locally by clicking on the "Save" button 188, or they can be abandoned by clicking on the "Cancel"
button 190.
Scrolling through the timeline will scroll both the Resource Demand pane and the Visits pane. Days or weeks where the total resource demand is higher than the nominal capacity for any of the resource types are highlighted. Scrolling with the mouse wheel 192 in this pane 134 will scroll the timeline left and right.
pane 136 is where the comparison of nominal capacity and total demand is calculated. If the total demand is greater than the nominal capacity, then the degree of over capacity is displayed 196 to indicate that there is a resource shortfall. The resource demand indication 196 may consist of a number representing the degree or extent of the resource shortfall. The shortfall values are preferrably colour-coded for severity, drawing the user's attention to them. The vertical date/week line is highlighted across timeline, resource type, and visit pane.
Also the date cells of the phases of the visit that is involved in the demand peaks are also highlighted. In the case of Figure 4, the dates of March 28 to 30 and April 5 to 9 are shown as highlighted, with numbers entered in the "resource demand" pane 136 indicating the level of the shortfall in terms of the numbers of the resources which are over-committed.
a) dragging the start date side of a resource demand bar 54 to edit the start date;
b) dragging the end date side of a resource demand bar 54 to edit the end date;
c) dragging the resource demand bar 54 itself inside the same work area to slide the whole visit 52; or d) dragging the resource demand bar 54 itself to another work area.
This may be done via database updates / calls and simple calculations, but it is preferred that the calculation of the over capacity resource demand indicators 196 be done by code on the GUI.
Performing the calculations on the GUI would be faster than having the calculations done by the database management system. But it is also less complicated to have the calculations done by code on the GUI. Performing the calculations on the database management system would require 'what if' scenarios to be sent to the database management system itself rather than keeping them local (i.e. on the user's personal computer only).
will be declined 210. If a suitable slot 58 does exist then the user may assess the resource capacity 212 and optimize the use of the resources by considering the nominal capacity and currently committed demand 214 and:
a) creating an appropriately sized visit in the slot selected 216;
b) increasing or decreasing the duration of the visit as required to ensure that the resource consumption does not exceed the nominal amounts; and c) adjusting the start date or end date to ensure that the resource consumption for all of the visits on the system, does not exceed the nominal amounts.
Of course, the user may also move around other unlocked visits to free up the resources needed for the new project.
as a proposed visit, having the title read "quoted" or "approval pending" to show that the visit is not yet confirmed to go ahead. The user may also "lock" the quoted visit to ensure that it is not accidently erased or disregarded by others. The user may then send a quote to the customer 218 without being concerned that the resources will be committed elsewhere.
a) finds the quoted visit in the slot plan;
b) switches the status in the quoted visit title from "quoted" or "approval pending", to "committed", "contracted" or something similar. This change is then saved on the main database 40; and c) switches the status of the now committed visit to a "locked" state, saving that change on the main database 40 as well.
There is no explicit quoted/contracted button on the system, but such a button could be provided to automate the tasks of locking the visit, and updating the visit title to a term like 'Contracted' or 'Quoted'. It was felt that this task should not be implemented in this way as it provides users with less flexibility.
agreement with the customer 266 he will mark the visit as being committed 268. This is done simply by amending the title of the visit to "committed", "locking" the visit, and saving these changes on the main database 40.
Conclusions
However, it will be apparent to persons skilled in the art that a number of variations and modifications can be made without departing from the scope of the invention as defined in the claims.
Similarly, an electronic memory medium such computer diskettes, hard drives, thumb drives, CD-Roms, Random Access Memory (RAM), Read Only Memory (ROM) or similar computer software storage media known in the art, may be programmed to execute such method steps. As well, electronic signals representing these method steps may also be transmitted via a communication network.
Date recue / Date received 2021-12-02
Claims (23)
a main server;
multiple remote computers; and a communications system allowing said multiple remote computers to access said main server;
said main server being operable to:
maintain a distributed operations support system including maintaining a schedule and data coherency between the main server and each of the multiple remote computers with respect to the schedule;
record resources required for multiple visits scheduled on said distributed operations support system wherein each of said multiple visits is mapped to a set of quantified resource requirements; and tabulate, in real-time, the level of resources required collectively for all of said multiple visits, for each time period in the schedule;
each of said multiple remote computers being operable to:
display said schedule in a graphic interface including a timeline pane, a resource demand pane and a visits pane;
said resource demand pane presenting said level of resources required collectively for all of said multiple visits, for each time period in the schedule; and said visits pane presenting resource demand bars, each resource demand bar representing one of said quantified resource requirements for each of said multiple visits.
maintain a nominal availability value for each of the resources; and compare the nominal availability value for each of the resources to the tabulated levels of resources required for all recorded visits, on a day-by-day basis, identifying resources for which there is a short-fall.
Date Recue/Date Received 2022-07-07
Date Recue/Date Received 2022-07-07
maintaining a distributed operations support system, including maintaining a schedule and data coherency between a main server and each of multiple remote computers with respect to the schedule;
recording resources required for multiple visits scheduled on said distributed operations support system wherein each of said multiple visits is mapped to a set of quantified resource requirements;
tabulating, in real-time, a level of resources required for all of said multiple visits, for each time period in the schedule;
displaying said schedule in a graphic interface on one of said multiple remote computers, said graphic interface including a timeline pane, a resource demand pane and a visits pane;
said resource demand pane presenting said level of resources required collectively for all of said multiple visits, for each time period in the schedule; and said visits pane presenting resource demand bars, each resource demand bar representing one of said quantified resource requirements for each of said multiple visits.
storing a nominal availability value for each of the resources; and comparing the nominal availability value for each of the resources to the tabulated levels of resources required for all recorded visits, on a day-by-day basis, identifying resources for which there is a short-fall, on a visual display.
Date Recue/Date Received 2022-07-07
Date Recue/Date Received 2022-07-07
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA2885131A CA2885131C (en) | 2014-03-14 | 2015-03-16 | Resource planning method and system |
Applications Claiming Priority (5)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA2,846,592 | 2014-03-14 | ||
| CA2846592A CA2846592C (en) | 2014-03-14 | 2014-03-14 | Resource planning method and system |
| US201462033351P | 2014-08-05 | 2014-08-05 | |
| US62/033,351 | 2014-08-05 | ||
| CA2885131A CA2885131C (en) | 2014-03-14 | 2015-03-16 | Resource planning method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CA2885131A1 CA2885131A1 (en) | 2015-09-14 |
| CA2885131C true CA2885131C (en) | 2023-09-12 |
Family
ID=54069243
Family Applications (2)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA2846592A Active CA2846592C (en) | 2014-03-14 | 2014-03-14 | Resource planning method and system |
| CA2885131A Active CA2885131C (en) | 2014-03-14 | 2015-03-16 | Resource planning method and system |
Family Applications Before (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA2846592A Active CA2846592C (en) | 2014-03-14 | 2014-03-14 | Resource planning method and system |
Country Status (2)
| Country | Link |
|---|---|
| US (1) | US11537962B2 (en) |
| CA (2) | CA2846592C (en) |
Family Cites Families (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US4937743A (en) * | 1987-09-10 | 1990-06-26 | Intellimed Corporation | Method and system for scheduling, monitoring and dynamically managing resources |
| US6415259B1 (en) * | 1999-07-15 | 2002-07-02 | American Management Systems, Inc. | Automatic work progress tracking and optimizing engine for a telecommunications customer care and billing system |
| US7457762B2 (en) * | 2001-09-04 | 2008-11-25 | Accenture Global Services Gmbh | Optimization of management of maintenance, repair and overhaul of equipment in a specified time window |
| US7058587B1 (en) * | 2001-01-29 | 2006-06-06 | Manugistics, Inc. | System and method for allocating the supply of critical material components and manufacturing capacity |
| EP1428159A1 (en) * | 2001-09-13 | 2004-06-16 | British Telecommunications Public Limited Company | Resource management method and apparatus |
| US7502747B1 (en) * | 2001-11-29 | 2009-03-10 | Microsoft Corporation | Automated job scheduling based on resource availability |
| US20040117046A1 (en) * | 2002-12-12 | 2004-06-17 | Renzo Colle | User interface for scheduling tasks |
| US8504396B2 (en) * | 2002-12-24 | 2013-08-06 | Sap Aktiengeselleschaft | Flexible maintenance planning |
| US20140081697A1 (en) * | 2003-05-22 | 2014-03-20 | P&RO Solutions, Inc. | Planning and scheduling tool assistant |
| US8725547B2 (en) * | 2004-08-24 | 2014-05-13 | Epic Systems Corporation | Utilization indicating schedule scanner |
| US8296197B2 (en) * | 2005-11-16 | 2012-10-23 | The Boeing Company | Centralized management of maintenance and materials for commercial aircraft fleets with information feedback to customer |
| WO2008067322A1 (en) * | 2006-11-27 | 2008-06-05 | Hntb Holdings Ltd | Resource forecasting and scheduling |
| US9378471B2 (en) * | 2007-03-01 | 2016-06-28 | Ge Aviation Systems Taleris Ltd | Multiple user resource scheduling |
| CA2641164A1 (en) * | 2007-10-16 | 2009-04-16 | John Vujicic | System and method for scheduling work orders |
| US20130103444A1 (en) * | 2011-10-21 | 2013-04-25 | Epic Systems Corporation | Group scheduling and assignment of resources |
| WO2014019059A1 (en) * | 2012-07-31 | 2014-02-06 | Research In Motion Limited | Apparatus and method for attribute-based scheduling |
| US9189824B2 (en) * | 2013-03-11 | 2015-11-17 | McFarland-Johnson, Inc. | Dynamic aviation planning tool |
| US10860955B2 (en) * | 2014-04-04 | 2020-12-08 | Tower Rock Technologies, Llc | Job loader |
-
2014
- 2014-03-14 CA CA2846592A patent/CA2846592C/en active Active
-
2015
- 2015-03-16 CA CA2885131A patent/CA2885131C/en active Active
- 2015-03-16 US US14/658,477 patent/US11537962B2/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CA2846592A1 (en) | 2015-09-14 |
| CA2846592C (en) | 2023-01-03 |
| CA2885131A1 (en) | 2015-09-14 |
| US11537962B2 (en) | 2022-12-27 |
| US20150262104A1 (en) | 2015-09-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7168045B2 (en) | Modeling business objects | |
| US7930201B1 (en) | EDP portal cross-process integrated view | |
| US8738414B1 (en) | Method and system for handling program, project and asset scheduling management | |
| US20110145284A1 (en) | Presenting skills distribution data for a business enterprise | |
| US7519539B1 (en) | Assisted profiling of skills in an enterprise management system | |
| US20070192157A1 (en) | Interactive system for managing, tracking and reporting work and staff performance in a business environment | |
| US20150379447A1 (en) | Resource demand-based project team staffing | |
| US20140278703A1 (en) | Enterprise resource management system and method | |
| Beliën et al. | Improving workforce scheduling of aircraft line maintenance at Sabena Technics | |
| Lam et al. | Benchmarking design‐build procurement systems in construction | |
| US20140180749A1 (en) | Scheduling management environment for cordinating allocation of external resources to a plurality of competing company activities | |
| US20140279588A1 (en) | Legal mandate system and method | |
| US20190266544A1 (en) | Techniques for managing process-flows across an enterprise | |
| Kovaleva et al. | Organizational transformation of culture of the “smart” enterprise | |
| CA2885131C (en) | Resource planning method and system | |
| Ayangbekun et al. | ICT application to human resources management system design | |
| Muthusamy et al. | Using Microsoft Project as planning, monitoring and controlling tool for project success–A case study of construction projects in Malaysia | |
| US20070061461A1 (en) | Computer-implemented method, system, and program product for resource forecasting in an information technology (IT) migration | |
| Redko et al. | Visual Control Methods—The Basis of Quality Control | |
| JP2001195447A (en) | Communication managing device in enterprise resource planning | |
| Garcia | Adaptive virtual team planning and coordination: a mathematical programming approach | |
| Andreadis | Managing human performance technology projects | |
| Johanning | Step 7: Monitoring and Control of the IT Strategy with the IT Strategy Cockpit | |
| Golpîra | Overview of Project Management | |
| Akinsolu | The role of risk assessment in engineering practice |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request |
Effective date: 20200311 |
|
| MPN | Maintenance fee for patent paid |
Free format text: FEE DESCRIPTION TEXT: MF (PATENT, 10TH ANNIV.) - STANDARD Year of fee payment: 10 |
|
| U00 | Fee paid |
Free format text: ST27 STATUS EVENT CODE: A-4-4-U10-U00-U101 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: MAINTENANCE REQUEST RECEIVED Effective date: 20241218 |
|
| U11 | Full renewal or maintenance fee paid |
Free format text: ST27 STATUS EVENT CODE: A-4-4-U10-U11-U102 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: MAINTENANCE FEE PAYMENT DETERMINED COMPLIANT Effective date: 20241218 Free format text: ST27 STATUS EVENT CODE: A-4-4-U10-U11-U102 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: MAINTENANCE FEE PAYMENT PAID IN FULL Effective date: 20241218 |
|
| MPN | Maintenance fee for patent paid |
Free format text: FEE DESCRIPTION TEXT: MF (PATENT, 11TH ANNIV.) - STANDARD Year of fee payment: 11 |
|
| U00 | Fee paid |
Free format text: ST27 STATUS EVENT CODE: A-4-4-U10-U00-U101 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: MAINTENANCE REQUEST RECEIVED Effective date: 20260218 |
|
| U11 | Full renewal or maintenance fee paid |
Free format text: ST27 STATUS EVENT CODE: A-4-4-U10-U11-U102 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: MAINTENANCE FEE PAYMENT PAID IN FULL Effective date: 20260218 |