The ThunderDownUnder Mining Company has recently appointed you as its new Project Manager. On arriving at work on your first day you notice that efficency in allocating Equipment and Employees on a day to day basis is substandard. You organise a meeting with various section heads and request the following information:
HR Manager provides you with a full list of all 44 employees, the equipment they are authorised to operate (In a Matrix form), the crew to which they are assigned (A, B, C or D), and each crew's Supervisor & Co-ordinator.
Production Manager provides you with a complete list of Ramps (Locations), Sub locations within the Ramps, List of operations carried out, and the current operations being undertaken by the Company.
Workshop Manager provides you with a complete list of the mining equipment including Equipment Group Type, the Equipment individual type, the ID number, and whether its currently operational.
You then retire to your office to design a program to allocate Equipment and Employees as required to complete the operational needs of the Company.
Would you use Excel, Access or a combination of both? And would you care to explain why or how or both?
Sample data will be provided once a concept can be agreed upon.
BTW: Is there any other data that could be relevant?