Rockwell Inflight Provisioning System

Problem:

American Airlines has DVD Players for Rental along with selections of Movies. These Players need to be serviced at the end of each leg of a flight. Each Player must be cleaned and serviced, then repackaged for rental on another flight. Any players which need further servicing must be pulled out of the system and sent to a location for repair.

Each Flight will have at least one DVD cart loaded and put on the Aircraft. All DVD Players sent out for repair must be logged as such and when they are returned they must be logged back into the system.

Requirements:

There are 8 main requirements for the proper functioning of the Rockwell Inflight Provisioning system.

• Outbound Provisioning:
• Inbound Provisioning:
• Audit In-Stock Inventory:
• Receive Inventory:
• Transfer Inventory to Base:
• Transfer to Repair:
• Develop using MS Access:
• Allow Scanning as much as possible:

RIPS Screen Shots

Main Menu

Outbound Provisioning

Outbound Provisioning w/Existing Flight Hints

Outbound Provisioning w/New Flight Hints

Audit Inventory

Receive Inventory

Transfer Parts to Base

Transfer Parts to Repair

Transfer Parts to Repair - Reasons

Date/Time Selector

Return to Projects