Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Flights from gatwick to belfast international airport

17/11/2021 Client: muhammad11 Deadline: 2 Day

ACC7003 – Case Study

Group work (30% of overall grade)

Submission deadline: see due date and time on Canvas

Please follow the submission guidelines (shown after the case study) carefully.

Brian Air Executive Flying Services – case study

Wayne Beckham looked out of his office window to witness the magnificent sight of snow slowly covering up the Botanic Gardens in Belfast. With a freshly brewed coffee by his side on the cold February morning, he took a blank sheet of paper and started to scribble on it some random notes in relation to his upcoming flights to various cities. A pilot by profession and with more than 12 years of flying experience, he considered himself fortunate to have joined Brian Air Executive Flying Services (BAEFS) some four years ago that allowed him to experience the world of executive flying service.

Prior to joining BAEFS, Beckham flew commercial planes for Fizzy Jet which was known to offer economy-class budget services to passengers. With the scourge of Covid and accompanying decline in passenger numbers, many of his former colleagues at Fizzy Jet had either been furloughed or were on unpaid leave; however, things were little different at Beckham’s current workplace. As BAEFS offered niche executive flying service to corporate executives and high net-worth individuals, Covid-19 and the resulting social distancing rules had led to higher demand in business for BAEFS. This had kept Brian, and 24 of his pilot colleagues, fairly busy throughout the lockdown period.

Beckham had been told the earlier day that he was to embark on an interesting flying mission to various cities and then return to Belfast within the next few days. He was scheduled to first fly to Brussels (Belgium) with the CEO and CFO of the Wimbledon Corporation, both of whom had flown with BAEFS previously and had come to know Beckham personally. The purpose of the trip, as rumour had it, was to pick up two great tennis players Rafa Fed and Andre Chang who were stranded in Brussels during the lockdown. After a short stay of just a few hours in Brussels, they would then travel together to Amsterdam to pick up four more renowned athletes, whose names were yet to be disclosed, but were understood to be good friends of both the CEO and CFO of the Wimbledon Corporation. The entire group of the renowned athletes along with the two lesser-known executives of Wimbledon Corporation were then expected to fly together to London Gatwick, England for a special photo-op session at the London eye before travelling together to Belfast for the opening ceremony of a special sports centre with state-of the art facility in the heart of Belfast.

About BAEFS

BAEFS had created a name for itself in the celebrity world for offering discreet and deluxe flying experience to the rich and famous celebrities. As the rich and famous found themselves constantly being the focus of news articles for traveling in their own private jets, despite passionately telling the world to reduce their carbon footprint, more and more celebrities started to avoid using their personal private jets in favour of more discreet private flying services in an effort to avoiding the prying eyes of paparazzis. The current directors of BAEFS, all of whom worked in the entertainment industry previously, saw a business opportunity and established BAEFS eight years ago in Belfast. Currently, it operates four aircraft to routinely offer executive flying services to mainly European and American customers to locations throughout the world.

Among the four aircraft, BAEFS’s largest and most expensive aircraft was the ATR 72-500 which had a range of 8,000 nautical miles. Purchased with long term loan in 2012, it was flown throughout the world, including the growth areas of Brazil, China, India, and Russia. It burned fuel at a rate of approximately 500 gallons per hour (one gallon of fuel weighs 6.7 pounds). It could carry up to 14 passengers, a flight attendant, and two pilots. The firm also owned and operated two Beechcraft 1900D aircraft (referred to as BC1900 hereafter), which it had purchased in 2016 and 2018. Both the Beechcraft models were smaller and could carry up to eight passengers and two pilots in each. Despite being small, the BC1900 was considered a fast plane and often flew from Belfast to as far as Australia, China, and New Zealand—a larger range than most small jets. Its 13,000-pound-capacity tank and fuel burn rate of 310 gallons per hour meant that it required a fuel stop to reach these more distant destinations.

BAEFS acquired its newest aircraft, a Beechcraft 2100X (BC21X), in 2019. Though this aircraft’s fuel burn rate and passenger capacity is similar to that of the existing two Beechcraft models, its flying range is longer and is also considered more comfortable for longer flights.

Flying with the celebrities

As usual, BAEFS would start its initial flight from Belfast City Airport (BHD) before landing at Brussels airport (BRL) to pick up the great tennis players who were apparently staying somewhere near the city airport. The next flight then would end at Amsterdam Airport (AMD) and the additional mystery athletes were expected to board the plane within an hour or two of landing at AMD. The entire group would then travel together to London Gatwick (GTW) before traveling together to Belfast (BHD) where Beckham’s flying shift was expected to come to an end for the week.

One area of concern that pilots frequently had to deal while flying any aircraft was the take-off and landing weight of the aircraft. Pilots at BAEFS were responsible for creating and submitting their own flight plans to air traffic control and the International Aviation Administration (IAA). To calculate these important measures, the pilots started with the normal operating weight (NOW) of the craft and added the weight of the passengers and fuel. The NOW included weight of the structure of the aircraft, stocked food and drinks, emergency equipment, and the crew. The only component that differed from take-off to landing on a given flight was fuel and the only weight components that differed from flight to flight were passengers and fuel.

Fuelling dilemma

By the time Beckham finished his coffee, he had nearly filled up the whole sheet of paper with his fuelling plan and calculations for the exciting flights he was about to undertake within the following few days. Coming up with a fuel plan was a challenging task for pilots because there was no straightforward way to calculate how much fuel to take on or “upload” at the beginning of each leg. One question was whether or not to “preload” which referred to a practice in which extra fuel was uploaded initially to avoid having to purchase higher-priced fuel at destination airports. BAEFS operated its own fuel source at Belfast’s BHD, which kept its fuel costs low. Fuel at BHD at the time cost £3.50 a gallon. In contrast, fuel purchased at BRL cost £9.35 a gallon. As a simple example of preloading, Beckham could decide to upload enough fuel at BHD to carry him through both of the first two flights, thus avoiding buying the more expensive fuel at BRL. In essence, BAEFS would carry or preload from BHD the fuel needed to fly from BRL to AMD.

BAEFS was subject to landing fee at all airports apart from BHD (as it paid other fees for the entire year at the home airport). Landing fees were fixed fees charged to each landing jet by the destination airport’s general-aviation terminal; the fees covered the costs of operation and general expenses of the terminal. The landing fee at BRL was £950 but the fee could be waived if 600 or more gallons of fuel was purchased; and similar policies were applied by the other destination airports where landing fees would be waived with purchase of minimum level of fuel specified at each airport. Hence, from cost-reduction perspective, one had to weigh the benefit of preloading with the cost of landing fees.

With no more space remaining on the sheet of paper he had pulled out earlier, Beckham now took a proper notebook from his drawer to write down the relevant figures for the trip more carefully. He had gathered enough information to make a table (which is shown in Exhibit 1). He patted himself on the back for the work done so far, and in an attempt to take a break from the work, gazed out of the window towards Botanic garden. It was snowing more heavily and he could see children throwing snowballs at each other down at the garden. He also felt like taking a short break to go out in the snow but wanted to finish one more important task before doing so.

Beckham also needed to consider the structural limitations of the BC1900 (see Table 2) in addition to the landing fees and cost of fuel. All aircraft had strict fuel tank capacity along with the departure weight and landing weight limits which were strictly specified and developed by the manufacturer and approved by the IAA. To calculate departing weight or arrival weight, Beckham added NOW to the weight of the fuel and the weight of the passengers (passenger weight calculations were based on a company-mandated figure of 300 pounds per person which includes luggage).

There were two more issues, related to the level of fuel upon landing, to be considered. The first issue to consider was that the company policy required that aircraft always land with at least 2,800 pounds of fuel. This “reserve fuel” was there to ensure jets had enough fuel to make it to an alternative airport should there be bad weather at the destination airport. Any fuel plan Beckham developed would have to be one in which the weight of fuel at arrival was at least 2,800 pounds. The second consideration was that the company required all aircraft to bring the fuel level up to 8,000 pounds immediately upon arrival back at BHD. The reason for this was that the aircraft would always be in a “ready-to-leave” position to go at a very

short notice if required to do so. This meant that Beckham’s fuel plan should begin with the BC1900 containing at least 8,000 pounds of fuel before departing BHD. For the larger aircraft (ATR 72-500 aircraft), the policy was to always land with at least 4,500 pounds of fuel and bring its fuel level up to 8,700 pounds upon arrival at BHD.

As Beckham finalized his BHD to BRL to AMD to GTW to BHD trip, he paused to look out of the window once again to check if it was still snowing. He still has some more calculations to finish before he can go out and enjoy the snow.

TABLE 1

BRIAN AIR EXECUTIVE FLYING SERVICES

Flight Details

Leg

Depart

Arrive

Miles

Duration (hr.:min.)

Fuel burn (pounds)

Fuel price (£/gallon)

Landing fee

Minimum gallons to waive landing fee

1

BHD

BRL

890

02:00

4,800

£3.50

2

BRL

AMD

176

00:40

2,000

£9.35

£950.00

600

3

AMD

GTW

1,202

02:55

5,300

£7.47

£450.00

300

4

GTW

BHD

628

01:35

3,100

£6.01

£400.00

350

TABLE 2

BRIAN AIR EXECUTIVE FLYING SERVICES

Aircraft Limitations

(in pounds)

Aircraft

BC1900

ATR-72

Maximum Departure Weight

36,400

90,900

Maximum Landing Weight

31,800

75,300

NOW*

22,200

48,800

Fuel Tank Capacity

13,000

41,300

*NOW = normal operating weight of the aircraft, including crew and excluding the weight of fuel and passengers.

Required:

1. Formulate a fuel plan for Beckham’s upcoming trip. Present and discuss the optimization function and the constraints from a business perspective. 7 Marks

2. Use linear programming and Solver in Excel to calculate the optimum level of fuel to be bought at various locations to minimize cost. Present all the calculations in good form.

18 Marks

3. Discuss the assumptions used in the linear programming approach above. 5 Marks

Total 30 Marks

[Important information]

Marks will be awarded on:

(i) a group basis, based upon how the Group address the tasks; and

(ii) an individual basis, based on evidence of collaboration as shown in ‘GroupLogReport’ sheet of the answer booklet provided. Unexplained absences/non-participation will attract deductions.

Submission guidelines

You have been assigned to separate groups (MA_CaseStudy 1, 2 etc.) in Canvas. Answer booklet in .xlsx format has been provided with this case study and one digital copy (in .xlsx format) of the answer booklet per group must be uploaded to Canvas by the submission deadline. The answer booklet contains five sheets as shown below in Figure 1:

Figure 1: Format of the answer booklet showing the different sheets

Ensure that the group members’ attendance or absences are logged properly in the ‘GroupLogReport’ sheet in the given format. Answers to Q1, Q2, and Q3 should be provided in sheets Q1, Q2, and Q3 respectively. Additionally, the screenshot of the Solver dialogue box (used to find the optimal solution) should be provided in “SolverScreenshot” sheet.

Plagiarism is treated very seriously; click here for more information on plagiarism.

Any questions that may arise subsequently will be addressed in the FAQ page .

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

A+GRADE HELPER
Assignment Guru
Professional Coursework Help
Top Class Engineers
Financial Analyst
Smart Accountants
Writer Writer Name Offer Chat
A+GRADE HELPER

ONLINE

A+GRADE HELPER

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$34 Chat With Writer
Assignment Guru

ONLINE

Assignment Guru

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$46 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$30 Chat With Writer
Top Class Engineers

ONLINE

Top Class Engineers

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$32 Chat With Writer
Financial Analyst

ONLINE

Financial Analyst

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$34 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$23 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Public boolean record int score - Stage 6 advanced english syllabus - Tootsie roll annual report 2017 - Self balancing robot raspberry pi - CATHERINE OWENS ONLY - Analogous structures are evidence of - What is the difference between servant leadership and followership - Discussion OL - Steps for effective collaboration - Plato apology five dialogues pdf - Case study 3.2 project selection at nova western inc answers - Blank bank statement template - Citation for student of the year - John singleton copley apush - Www armoredpenguin com crossword - What are the seven characteristics of an agile mis infrastructure - Employee portfolio management plan example - Conflict resolution models in nursing - Discussion 10/31 - Countess automated cell counter - Primitive rule of the templars - Salesforce certified b2c commerce developer - Responses - Lockwood 15g graphite lock lubricant - Week 2 Project - West egg and east egg quotes - MHA/516 5 - Homework - Professional Ethics and Responsibilities at work ( IT software job ) - Change management in healthcare literature review - Business Ethics - Clinical interviewing sommers flanagan pdf - Example of reinforcement for sports - Math 30 formula sheet - Descriptive statistics and data visualization - Narrative Essay Rough Draft (SLO#1-8) - G scan 2 key programming - Advantages and disadvantages of duo trio test - Tom o'rourke cause of death - Cba streamline account interest rate - Bible - Commentary Peer Review Worksheet - 7 pin cdi wiring diagram - Informative speech about healthy eating - Revision strategies for writing snhu - Signature Assignment: Government Intervention Analysis - How many different gamete combinations can be produced - Lord of the flies movie piggy dies - Cable high pot test - Clergymen letter to mlk analysis - Social Work- Sexual Orientation, Gender Identity, and Gender Expression - What is the main conflict in the story nilda - Close reading of a poem - Reaction paper 2 - Northcentral university dissertation proposal template - Moonee valley transfer station opening hours - Dicussion ( Principle of Economics) SJ Week 6 - Long term care week 8 - Ethics_paper - Http virtuallabs nmsu edu corn php - Information security - Fiata terms and conditions - Office move gantt chart - Compute the selling price per composite unit - Laura mckinnon attorney arkansas - Common core math learning progressions - Chart discussion - Well child comprehensive soap note - Avon vale pony club - The great rebate runaround - Social work case studies foundation year 2013 pdf - New spirits americans in the gilded age sparknotes - How much is 20 basis points - St joseph's hospice history - Pv diagram of isothermal process - First amendment junkie - Beach in a simple sentence - The Nature and causes of crime - Chippewas company sells one product - They say i say escape from the western diet summary - Cotyledon monocot vs dicot - Like the modernists postmodern writers focused on - Suppose the quantity x of super titan - Does oil ever touch the windings of a hermetic compressor - How to cite the bible chicago bibliography - System sequence diagram in ooad ppt - Hp openview operations agent - Compare and contrast medieval and renaissance - Midtronics exp 1050 software update - Cake creations lisbellaw enniskillen - Leadership - A plane flies from base camp to lake a - How to use ti 83 calculator for statistics - George w bush library groupon - Unguaranteed residual value lease - 23 walhalla drive ringwood east - Appraisal form answers for software engineer - Https openstax org details us history - Excel chapter 4 grader project mountain view realty - Ets gre practice test 2 answers - American genealogical biographical index agbi database online