Preview

Microsoft Excel

Powerful Essays
Open Document
Open Document
8907 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Microsoft Excel
2. Costing aircraft components
A British Aerospace case study
Introduction
When we think about the cost of an aircraft, we tend to think of the cost of buying the product rather than the costs of running it! British Aerospace’s service to the customer does not stop at the aircraft acquisition stage, when the aeroplane is sold to the customer. If anything, this is when the customer relationship begins.
This case study focuses upon the processes involved in costing aircraft components. Given the high specifications to which designers have to work, it is important to develop a price for customers which provides ‘Customer Satisfaction at Competitive Cost.’ British Aerospace is a major player in the world aviation industry. Its Military Aircraft Division aims ‘to remain number one in Europe and World Leader in the Military Aircraft Business.’
The design challenge
The challenge to design teams is to design an aircraft that achieves maximum mission effectiveness at minimum cost to the customer. Typically, a military aircraft has a service life of over 30 years. The total operation and support costs such as those involved in owning and operating an aircraft (spares, repairs and servicing) over this time, outweigh the initial cost of acquisition. Therefore, total Life Cycle Cost (LCC) must be minimised in the customer’s interest. The study of the cost of acquisition, operation and support and disposal is known as Life Cycle Cost analysis. To achieve the design challenge, British Aerospace use two main cost reduction techniques.
Re-Engineering
Re-Engineering to reduce the business cost base Since 70% of the final product consists of vendor/bought out equipment, British Aerospace’s suppliers’ performance is critical to enable British Aerospace to achieve improvement, obtain better customer satisfaction and win more business in this competitive environment. Within the Military Aircraft Division, British Aerospace has introduced a Preferred Supplier Process which is

You May Also Find These Documents Helpful

  • Satisfactory Essays

    2. Which of the following identifies the patterns used for each data series in a chart?…

    • 985 Words
    • 5 Pages
    Satisfactory Essays
  • Better Essays

    De Havilland has a very systematic approach with its procurement process, one that prepares the negotiating team with a solid background of the marketplace and information that helps ensure the corporation leaves no stone unturned with its supplier selection process. This particular bid, on flap shrouds and equipment bay doors, received from the nine (9) different suppliers poses the question “Why is there such has a wide range in pricing between Suppliers?”. Was the Supplier’s understanding of the specifications misunderstood or are there missing attributes in producing and delivering the products. It is important to address the reasons as to why the lowest bidder is 211% (CDA currency) less expensive than the current supplier used at De Havilland. When the current supplier, Dollard Plastics was approached by De Havilland to reduce costs, they refused to do so knowingly that such…

    • 1449 Words
    • 6 Pages
    Better Essays
  • Powerful Essays

    Aircraft Solutions

    • 1868 Words
    • 8 Pages

    The main company strategy of Aircraft Solutions is to provide low cost design and computer-aided modeling packages to customers to reduce their development operating cost. One thing AS is especially proud of is that it will help the customer through all phases of new product deployment. It will help starting from the early prototypes through final large-volume production and assembly. Eventually the goal of Aircraft Solutions is to make long-term relationships with its customers and to keep on doing business with them in the long run.…

    • 1868 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    In playing the airplane game, my team’s initial strategy was to differentiate our product by providing a high quality airplane with an aeronautical design built to outlast our competitor’s products. We constructed our mission statement and overall objective around what we perceived to be our customer’s enjoyment. Using a complex design, our airplane would be able to achieve further distances as well as simulate the flight of a real aircraft. Structuring our strategy in this manner led us to believe our company would be an order-winner in both quality and flexibility while remaining an order-qualifier in both time (response) and cost.…

    • 833 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Excel Chapter 1

    • 4708 Words
    • 19 Pages

    B) the current cell location of the insertion point as indicated by a dark border.…

    • 4708 Words
    • 19 Pages
    Satisfactory Essays
  • Powerful Essays

    My spreadsheet

    • 1377 Words
    • 5 Pages

    Prepare solutions to the following problems and submit them as instructed by your section instructor. Show all calculations, or identify the sequence of steps and buttons to your financial calculator, to support the solutions you submit.…

    • 1377 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Excel Worksheet

    • 875 Words
    • 4 Pages

    On Page 1, click at the beginning of the newsletter title. Insert an online picture from Office.com Clip Art, by searching for microscope. Insert a picture of a black and white microscope. If you cannot locate the picture, use the Insert Pictures command to insert the picture downloaded with the files provided with this project—go_w03_grader_h3_microscope.jpg. Recolor the picture by applying Blue, Accent color 1 Light. Apply a Black, Text 1 Picture Border and change the Weight to 2 1/4 pt.…

    • 875 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Excel Word

    • 1789 Words
    • 8 Pages

    Your supervisor in the Finance department at Med Supply Online Warehouse has asked you to create a worksheet that will project the annual gross margin, expenses, total expenses, operating income, income taxes, and net income for the next six years based on a table of assumptions he has provided you with. In Part 1 of this project, you will create the worksheet. In Part 2, you will create a chart to present the data. And in Part 3, you will use Goal Seek to analyze a sales scenario.…

    • 1789 Words
    • 8 Pages
    Good Essays
  • Good Essays

    This is a case about three different companies dedicated to the manufacturing of aircrafts. Those three major companies are: Boeing, Airbus Industry and McDonnell Douglas; each of one was struggling to produce enough aircraft to satisfy a seemingly unquenchable need for passenger and freight transport around the world, developed in this form many kinds of aircrafts in different models and styles.…

    • 1675 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Owning an aircraft is an expensive affair. An Airliner’s decision to acquire an aircraft is invariably accompanied by the question of whether the aircraft is to be taken on lease or to be purchased. The answer largely depends on the airline’s requirements, cost of the aircraft, availability of capital, legal constraints and taxation issues. Prior to the 1980’s purchasing an aircraft was the primary choice for the airlines – but new aircrafts were becoming an unattractive proposition for airline operators to buy aircrafts. Therefore, it is a common…

    • 741 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Decisions Ltd. is a multinational company that produces and sells spare parts for the automotive industry. The traditional costing system used by the company is based on the number of units for charging overheads to products. However, and the CEO thinks that this could lead to poor pricing decisions, considering the different level of complexity of the three main lines of production. Recent improvements in the accounting information system, however, now allows the CEO to gather the information needed to improve pricing decisions. The information that follows is related to the old and the new system. Selected data from the old information system (year 2007) Total manufacturing overhead Total output (units) Model 1 Total production Material cost per unit Direct labour cost per unit 200 £24 £13 8,000 400 Model 2 160 £32 £11 Model 3 40 £24 £7…

    • 1219 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Strategic Cost Management Chapter 11 The Honda Business Model for Suppliers Six-year plan 100% understanding of all components of product cost Lean supplier development concurrent engineering Flawless new product launch Communications The Value Equation Definitions Price analysis Process of comparing supplier prices against external price benchmarks Cost analysis Process of analyzing each individual cost element that makes up final price…

    • 1504 Words
    • 7 Pages
    Good Essays
  • Good Essays

    Due to rapid changes and new trends in the aviation business, continuous product revision is required to respond to customer demand and to react to increasing competition. Lufthansa Consulting has developed a specialized in-flight service evaluation system which reviews and assesses the onboard product of airlines, in detail, and can be adapted to particular customer requests. The client receives a comprehensive analysis of more than one hundred single product elements as a basis to review the overall in-flight product strategy and to improve processes on board.…

    • 1360 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    Microsoft Excel

    • 1757 Words
    • 8 Pages

    Note: To help prevent dangerous code from running, it is recommend that you return to any of the settings that disable all macros after you are finished working with macros.…

    • 1757 Words
    • 8 Pages
    Powerful Essays
  • Better Essays

    Spreadsheets

    • 1059 Words
    • 5 Pages

    International Business offers a versatile selection of professions after graduation. As a result, I chose to focus on business leadership coaching, just like at the beginning of this semester. As an important note my parents own a coaching company, BoMentis, and my dream is to either take over it one day or at least work with them. Based on my research and personal experience, coaching has spread increasingly all throughout the world and is becoming more and more international. This is why my background in international business will benefit the future company I work with. Furthermore, after taking the course in spreadsheets and databases I believe I have an advantage over my peers. The ability to use Excel and Access are crucial. Even now I notice excelling in my classes as a result of my new speciality knowledge over my other peers. In the following I will explain how the learnt course material will fulfil the requirements in the work field.…

    • 1059 Words
    • 5 Pages
    Better Essays

Related Topics