Business Finance Homework Help

Operations managers use many techniques to solve problems. Some of these techniques are graphical and can be solved using software tools and programs. You will use Excel® and PowerPoint® to solve real-life problems encountered by operations managers.

How many times have you waited, not so patiently in the departure area, for your aircraft to be serviced before you board? Airport operations managers strive to achieve the shortest “turn around time” possible through a carefully choreographed process. Aircraft only make money when they are in the air!

This chart provides a generalized flow for the turnaround of an aircraft. Your task is to produce a Gantt chart, draw an activity on node (AON) network diagram, and determine the critical path.

STEP1: Produce a Gantt Chart

Use Excel to produce a Gantt chart of the aircraft servicing process from the time the aircraft stops at the gate until it is ready for departure. Use this information to create your chart.

• Use the Gantt Chart project planner template to get started. In Excel, select New and then search for the planner.
• Assume that the PLAN START (earliest start time) begins as soon as the predecessor is completed.
• Set the ACTUAL START, ACTUAL DURATION, and PERCENT COMPLETE time to 0 (since we are only using this chart for planning the project).
• Once finished with your Gantt Chart copy and paste your Gantt Chart into your presentation as a picture and resize appropriately.

Once you have completed your Gantt chart, study it, and provide suggestions on ways to shorten the turnaround time. Remember that some items must be completed before others can start (i.e., the jet bridge must be connected before you can offload the passengers and the aircraft cannot have passengers aboard when refueling).Be sure to place your suggestions on the presentation slide with your Gantt Chart.

STEP2: Draw an AON Network Diagram

Create a slide to construct a diagram of activity on node (AON) network of the aircraft turnaround operation. Make sure to produce your graph as shown in the video and in your textbook (i.e. using the ES, EF, LS, LF, Act. name and duration notation).

Watch this video to see how to draw an AON network Diagram: Use Forward and Backward Pass to Determine Project Duration and Critical Path (YouTube, 07:25)

STEP3: Determine a Critical Path

Use your AON network diagram to determine the critical path and calculate the total time of completion. Make sure to annotate the critical path and time of completion on the slide.

Once you produce the AON graph, consider what would happen if activity E Refueling/Water servicing could be reduced to 15 minutes. Write a brief statement on the changes to the critical path and time of completion. Place your statement on the slide.

STEP4: Submit the Assignment

Submit your Gantt chart and your network diagram in one PowerPoint® presentation file.