New discussion | Applied Sciences homework help

[ad_1]

START HERE

&”-,Bold”AVIA 360&”-,Regular”
&”-,Italic”2017 Spring Semester Corporate &
Business Aviation

START HERE:
Rarely does a company jump into the commitments of a large scale corporate flight department. Costs associated with equipment, operations, and personnel can be breathtaking to the unaccustomed financial controller. Most flight departments grow over a period of time, and many have rich histories that help to justify aircraft upgrades and growth.
This file goes slightly against this conventional wisdom. Within the City-Pair Analysis worksheet tab, a ficticious stone and aggregate copany is comparing their airline demand to an on-demand model of transportation. The data contained in the large data table on this worksheet represents the level of travel of one “key traveler,” the Chief Operations Officer (COO). The total level of travel for the company is purposely augmented to help with the outcomes of this assignment. In reality, this ficticious company would probably already have an aircraft or be leaning heavily on some other method of on-demand transportation.
The blue worksheet tabs below represent worksheets that will be used on course assignments and have input fields. Other tabs contain key course related materials and will also be used for course assignments. You should plan to follow specific assignment instructions that will refer to and guide you through this Excel file with these multiple worksheets. Below is a quick summary of each tab so you may begin to familiarize yourself with content and layout.

Aircraft Feasibility Study

City-Pair Analysis Tab:
Read the instructions at the top of the worksheet. The yellow dropdown / input cell is where you would click to select a specific airframe. The output cells will automatically populate. Notice how different aircraft can influence Aircraft Hours.

Aircraft Data Tab:
This is the database for the Excel file. Feel free to scroll and compare airframes here; especially when you want to compare a specific data set across the entire database. New aircraft are listed in the top-half of the database with a “n” preceeding the name. Used aircraft are listed in the bottom half, with the year of manufacture preceeding the name.

RV Analysis Tab:
This tab provides an output which compares the Value Factor to Purchase Price. This analysis is only done with new aircraft. Value Factor is calculated as follows:

(Maximum Speed x Maximum Range x Maximum Cabin Volume) / 10,000 = Value Factor

Value Factor is on the vertical axis and purchase price is on the horizonal axis. The main objective of this type of analysis is to help generate questions about the market, value, and resale.

Quick Compare Tab:
This tab allows you to select up to six airframes from the database and perform a horizontal analysis on twenty-nine variables that include different specifications and performance parameters.

Product Timeline Tab:
This worksheet provides a general idea of turboprop and turbojet aircraft available to a potential buyer. The chart depicts product lines from a variety of manufacturers as well as their respective production years.

Selection Matrix Tab:
This worksheet allows you to select five different airframes and score them within a subjective matrix. Matrix categories and subcategory values are derived from key traveler interviews. Select your airframe(s) at the top using the dropdown lists.
1. Values in the yellow cells indicate the weight of importance. Scale of 1 to 4 (4=most important)
2. Airframe totals are automattically calculated by this formula:
Weight Factor x Item Score (I.S.) = Factor Value (F.V.)

Cost of Operation Tab:
This worksheet helps with the calculation of and the depiction of the cost of operation. More instructions will follow, but you will be able to select an airframe and immediately see its cost of operation compared to multiple airframes and multiple on-demand methods.

Amortization & You Pick Tabs:
Both of these worksheets are amortization tables. Amortization is linked to the aircraft database and the You Pick is not. Use the You Pick worksheet to enter anything you want to see an payment schedule for. An amortization schedule is already built into the Cost of Operation worksheet.

City-Pair Analysis

AVIA 360 Corporate &

Business Aviation

City-Pair Analysis City-Pair Analysis

On-Demand Model FLIGHT TO FLIGHT FROM Airline Model FLIGHT TO FLIGHT FROM

Springfield Aircraft Trip Time Time Time Time Total Nashville Time Wait at Flight Layover Time Time Wait at Flight Layover Time Overnights Single Trip Total Total

TN Capacity Miles to Flight to Job to Flight to Trip Trip TN to Airport Time Time to Job to Airport Time Time to Req Cost Cost Cost Trip Trip

M91 Pass >4 Freq X’s 2 Airport Time Site Airport Time Office Time Time Airport TSA two legs Site Airport TSA two legs Office Time Time

*Springfield TN M91 0 Nashville TN BNA 0

Cincinatti OH LUK 194.4 3 1 2 777.6 0.1 0.5 0.5 0.5 0.5 0.1 2.2 4.3 Cincinatti OH CVG 199.8 1.0 1.5 4.0 0.6 0.7 0.7 1.5 3.0 0.9 1.0 2 371 1,113 2,226.00 14.9 29.8

*Owensboro KY OWB 73.1 4 1 3 438.6 0.1 0.2 0.3 0.3 0.2 0.1 1.2 3.5 Evansville IN EVV 122 1.0 1.5 3.3 1.3 1.0 1.0 1.5 3.3 1.3 1.0 3 499 1,996 5,988.00 16.2 48.6

Greenwood IN HFY 189.6 4 1 3 1137.6 0.1 0.5 0.5 0.5 0.5 0.1 2.1 6.4 Indianapolis IN IND 216.3 1.0 1.5 2.9 0.7 1.0 1.0 1.5 2.9 0.7 1.0 3 393 1,572 4,716.00 14.2 42.6

Dupage IL DPA 328.1 4 1 1 656.2 0.1 0.8 0.5 0.5 0.8 0.1 2.8 2.8 Chicago IL ORD 355.8 1.0 1.5 1.7 0.0 0.6 0.6 1.5 1.7 0.0 1.0 1 240 960 960.00 9.6 9.6

Leesburg FL LEE 529.8 3 1 3 3178.8 0.1 1.3 0.5 0.5 1.3 0.1 3.8 11.5 Orlando FL MCO 535.8 1.0 1.5 2.6 1.5 1.0 1.0 1.5 2.6 1.5 1.0 3 210 630 1,890.00 15.2 45.6

Lake City FL LCQ 438.9 3 1 3 2633.4 0.1 1.1 0.5 0.5 1.1 0.1 3.4 10.2 Jacksonville FL JAX 420.3 1.0 1.5 2.5 1.0 1.0 1.0 1.5 2.5 1.0 1.0 3 230 690 2,070.00 14.0 42

Witham FL SUA 656.5 3 1 1 1313 0.1 1.6 0.5 0.5 1.6 0.1 4.5 4.5 Palm Beach FL PBI 658.8 1.0 1.5 3.0 1.0 1.0 1.0 1.5 3.0 1.0 1.0 1 310 930 930.00 15.0 15

*Anderson SC AND 239.4 4 1 3 1436.4 0.1 0.6 0.7 0.7 0.6 0.1 2.8 8.4 Spartanburg SC GSP 229.9 1.0 1.5 2.0 1.0 1.0 1.0 1.5 2.0 1.0 1.0 3 250 1,000 3,000.00 13.0 39

*Athens GA AHN 234.8 4 1 3 1408.8 0.1 0.6 0.5 0.5 0.6 0.1 2.4 7.1 Atlanta GA ATL 185.9 1.0 1.5 1.9 0.0 1.0 1.0 1.5 1.9 0.0 1.0 3 309 1,236 3,708.00 10.8 32.4

On-Demand Model n Learjet 70 Input Field Rock Hill SC UZA 300.2 3 1 4 2401.6 0.1 0.8 0.3 0.3 0.8 0.1 2.3 9.2 Charlotte NC CLT 284.5 1.0 1.5 1.8 0.0 1.0 1.0 1.5 1.8 0.0 1.0 4 288 864 3,456.00 10.6 42.4

Block Speed (for 300 nm trip) 400 Ouput Field *Shelby NC EHO 269.7 4 1 3 1618.2 0.1 0.7 0.5 0.5 0.7 0.1 2.5 7.6 Charlotte NC CLT 284.5 1.0 1.5 1.8 0.0 1.0 1.0 1.5 1.8 0.0 1.0 3 288 1,152 3,456.00 10.6 31.8

Expansion into OK *Effingham IL 1H2 170.2 4 1 3 1021.2 0.1 0.4 0.5 0.5 0.4 0.1 2.1 6.2 St Louis MO STL 236 1.0 1.5 2.4 0.0 1.0 1.0 1.5 2.4 0.0 1.0 3 315 1,260 3,780.00 11.8 35.4

*Mitchell IN FRH 118.9 4 1 3 713.4 0.1 0.3 0.5 0.5 0.3 0.1 1.8 5.4 Evansville IN EVV 122 1.0 1.5 3.3 1.3 1.0 1.0 1.5 3.3 1.3 1.0 3 499 1,996 5,988.00 16.2 48.6

Key Employee – COO Elizabethtown KY EKX 83.8 3 1 3 502.8 0.1 0.2 0.3 0.3 0.2 0.1 1.2 3.7 Louisville KY SDF 131 1.0 1.5 3.0 1.3 1.0 1.0 1.5 3.3 1.3 1.0 3 405 1,215 3,645.00 15.9 47.7

Employee Trip Miles 30,867.8 36,893.4 Overnights Latrobe PA LBE 418.2 4 1 4 3345.6 0.1 1.0 0.3 0.3 1.0 0.1 2.9 11.6 Pittsburgh PA PIT 400.7 1.0 1.5 2.6 1.2 0.6 0.6 1.5 2.6 1.2 1.0 4 330 1,320 5,280.00 13.8 55.2

Aircraft Hours 77.2 92.2 7 12 Washington MO FYG 229.4 4 1 4 1835.2 0.1 0.6 0.5 0.5 0.6 0.1 2.3 9.4 St.Louis MO STL 236 1.0 1.5 2.4 0.0 1.0 1.0 1.5 2.4 0.0 1.0 4 330 1,320 5,280.00 11.8 47.2

Employee Hours 142.0 169.8 Lawrence MO LWC 420.3 4 1 4 3362.4 0.1 1.1 0.7 0.7 1.1 0.1 3.7 14.8 Kansas City MO MCI 426.1 1.0 1.5 2.5 1.2 0.6 0.6 1.5 2.5 1.2 1.0 4 399 1,596 6,384.00 13.6 54.4

Time Savings using On-Demand 609.7 706.7 *Sedalia MO DMO 324.4 4 1 3 1946.4 0.1 0.8 0.5 0.5 0.8 0.1 2.8 8.5 Kansas City MO MCI 426.1 1.0 1.5 2.5 1.2 0.6 0.6 1.5 2.5 1.2 1.0 3 399 1,596 4,788.00 13.6 40.8

Combined Non-Duplicated Travel Miles Caruthersville MO M05 135 4 1 2 540 0.1 0.3 0.3 0.3 0.3 0.1 1.5 3.0 Memphis TN MEM 173.5 1.0 1.5 2.3 1.0 0.6 0.6 1.5 2.3 1.0 1.0 2 379 1,516 3,032.00 12.8 25.6

Total Trip Miles 113,977.7 120,003.3 *Union City TN UCY 100.1 4 1 3 600.6 0.1 0.3 0.3 0.3 0.3 0.1 1.3 3.9 drive 3.0 3.0 0 0 0.00 6.0 18

Total Aircraft Hours 284.9 300.0 30867.8 49.7 142.0 55 $70,577.00 259.6 751.7

*Afton OK GMJ 376.6 4 1 8 6025.6 0.1 0.9 0.7 0.7 0.9 0.1 3.5 27.9 Tulsa OK TUL 446 1.0 1.5 3.2 1.0 1.1 1.1 1.5 3.2 1.0 1.0 8 420 1,680 13,440.00 15.6 124.8

* These are cities with aggregate mines 36893.4 53.2 169.8 63 $84,017.00 15.6 124.8

Airline Model for COO Travel

Travel Hours 751.7 876.5 Overnights

Estimated Airline Travel Cost $70,577.00 $84,017.00 55 63

INSTRUCTIONS
GIVEN:
As you zoom out you will notice three sections to this worksheet: 1) Input and output fields to the left, 2) an on-demand city-pair analysis in the middle, and 3) an airline city-pair analysis on the right. The on-demand and airline tables to right represent the travel frequency and destinations of the Chief Operations Officer of an ficticious aggregate company. Here are some key points to understanding the data and outputs displayed on this worksheet:
• In the example, the closest airport that provides airline service? KBNA, Nashville International (cell AE8)
• In the example, the closest airport that may be used by a corporate aircraft? M91, Springfield Robertson Co. (cell N8)
• The difference in cities (Column N to Column AE) is due to airports available for on-demand that are closer to job site.
• To get started, click in the top yellow input field and select an aircraft from the drop down menu.
• When you select an aircraft Cell D19 will auto fill and clear the error “X”
• Notice the impact of your selected aircraft to the City-Pair data
• The top three textboxes are On-Demand model outputs, while the bottom textbox is the output for the Airline model.
• Aircraft listed in the drop-down are either new “n”, remanufactured “r”, or used (year of manufacture) preceeding the make and model.

[ad_2]

Homework helper

6 thoughts on “New discussion | Applied Sciences homework help”

  1. I抎 must test with you here. Which is not one thing I usually do! I get pleasure from studying a put up that may make individuals think. Additionally, thanks for allowing me to remark!

  2. At this time it looks like BlogEngine is the best blogging platform available right now. (from what I’ve read) Is that what you’re using on your blog?

  3. One other thing is that an online business administration training is designed for people to be able to smoothly proceed to bachelor’s degree programs. The 90 credit college degree meets the lower bachelor diploma requirements then when you earn your own associate of arts in BA online, you will get access to the most up-to-date technologies in this field. Some reasons why students have to get their associate degree in business is because they’re interested in this area and want to receive the general education and learning necessary in advance of jumping right into a bachelor education program. Thanks for the tips you actually provide with your blog.

  4. Good blog post. A few things i would like to bring about is that laptop memory should be purchased if the computer can no longer cope with what you do with it. One can add two random access memory boards having 1GB each, for instance, but not certainly one of 1GB and one having 2GB. One should check the manufacturer’s documentation for one’s PC to be certain what type of storage is needed.

  5. Thank you for the good writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! By the way, how could we communicate?

  6. That is really interesting, You are an overly professional blogger. I’ve joined your feed and sit up for looking for extra of your magnificent post.

Leave a Comment

Your email address will not be published.