Swanson, Brian (OST) 

DDT ... Ot-1 .. J Pftt It ... l"'fll 

l>tT-o'r -zooeJ. -r'O'fl~ 

From: 

Sent: 

checktsa@gmail.com on behalf of Jim Gallagher Qg727@aol.com] 

Friday, February 24, 2012 11 :19 AM 

To: 

Subject: 

Devany, Dennis (OST); Swanson, Brian (OST); Manistee Airport 

financial overview Public Charters 

Attachments: Combined EMB and Jetream.xlsx 

If you want to see our cost projections for the Manistee program they are as 

follows ... please look at each tab in the excel; one is for 6 months with the EMB 

(summer) and the other for 6 months with the Jetstream (winter). 

The idea is that we hope to develop the right combination of service reliability and 

pricing strategies to keep the 30 seater year round without any additional subsidy 

required. 

Since in Alt EAS we contract with the airport; Barry will provide you with a per flight 

breakdown for when the EMB is used and also when the J etstream is used. 

There is a TON of start up preparation and costs involved with launching this service 

RIGHT. Not to mention the allocation of physical (both manpower and financial) 

resources. 

What do you need from us to get this done so that we can further our progress? 

Thanks again. 

Sincerely, 

Jim Gallagher 

Aviation Technologies, Inc. 

PublicCharters.com 

CheckTSA.com 

@) 

201 Hangar Road 

Wilkes-Barre/Scranton International Airport 

Avoca, PA 18641 

570-457-4147 Phone 

570-457-4113 Fax 

570-760-0880 Cell 

1 
And INC 

Fare Range: 

Aircraft: 

Low $ 49.00 High'$ 149.00 I 

EMB-120 Seats: 27-30 

Aircraft Base: MBL 

Schedule: lOx frequency weekly 

Dept Arrive Stops 

MBL 7:25AM MDW 7:25AM 0 

MDW 11:00 AM MBL 1:00PM 0 

MBL 1:30PM MDW 1:30PM 0 

MDW 6:00PM MBL 8:00PM 0 

TIMES ARE FLEXIBLE 

Item May Jun Jul Aug ~ 

Weeks per Month 4.3 4.3 4.3 4.3 4.3 

Days per Week 5 5 5 5 5 

Depts per Week 20 20 20 20 20 

Depts per Month 86 86 86 86 86 

Avg. Block per Leg 0.90 0.90 0.90 0.90 0.90 

Ttl Block per Month 77.40 77.40 77.40 77.40 77.40 

Load Factor 50% 50% 50% 50% 50% 

Seats per flight 30 30 30 30 30 

Pax per flight 15 15 15 15 15 

Avg. Pax Fare $ 69.00 $ 69.00 $ 69.00 $ 69.00 $ 69.00 

Ttl Pax per Month 1,290 1,290 1,290 1,290 1,290 

Ticket Rev. $ 89,010.00 $ 89,010.00 $ 89,010.00 $ 89,010.00 $ 89,010.00 

Credit Card Fee $ (3,115.35) $ (3,115.35) $ (3,115.35) $ (3,115.35) $ (3,115.35) 

FET & 7.5% $ (6,064.88) $ (6,064.88) $ (6,064.88) $ (6,064.88) $ (6,064.88) 

Agent Comm. $ (2,484.00) $ (2,484.00) $ (2,484.00) $ (2,484.00) $ (2,484.00) 

Ttl Op. Revenue $ 77,345.78 $ 77,345.78 $ 77,345.78 $ 77,345.78 $ 77,345.78 

Direct Operating Cost 

ACMI $ 135,450.00 $ 135,450.00 $ 135,450.00 $ 135,450.00 $ 135,450.00 

Fuel $ 51,084.00 $ 51,084.00 $ 51,084.00 $ 51,084.00 $ 51,084.00 

Ground $ 56,652.50 $ 56,652.50 $ 56,652.50 $ 56,652.50 $ 56,652.50 

Deicing $ $ $ $ $ 

Catering ~ 1,935.00 ~ 1,935.00 ~ 1,935.00 ~ 1,935.00 ~ 1,935.00 

Ttl Direct Op. Cost $ 245,121.50 $ 245,121.50 $ 245,121.50 $ 245,121.50 $ 245,121.50 

Indirect Operationing Costs 

Advertizing $ 6,450.00 $ 6,450.00 $ 6,450.00 $ 6,450.00 $ 6,450.00 

Reservation/GO$ $ 9,675.00 $ 9,675.00 $ 9,675.00 $ 9,675.00 $ 9,675.00 

Call Center $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 

Ttl Indirect Op. Cost $ 18,125.00 $ 18,125.00 $ 18,125.00 $ 18,125.00 $ 18,125.00 

Ttl Op. Cost $ 263,246.50 $ 263,246.50 $ 263,246.50 $ 263,246.50 $ 263,246.50 

Operating P/L $ (185,900.73) $ (185,900.73) $ (185,900.73) $ (185,900.73) $ (185,900.73) 
$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

Proposal to Provide Alternate Essential Air Service At Manistee, Ml r-------~--~----------~ 

Oct 

4.3 

5 

20 

86 

0.90 

77.40 

50% 

30 

15 

69.00 

1,290 

89,010.00 

(3,115.35) 

(6,064.88) 

(2,484.00) 

77,345.78 

135,450.00 

51,084.00 

56,652.50 

1,935.00 

245,121.50 

6,450.00 

9,675.00 

2,000.00 

18,125.00 

263,246.50 

(185,900.73) 

Docket DOT-OST- 1996-1711 

ACMI incl. Hotel & per diem 

Destin. Ground Fees 

Origin Ground Fees 

Destinaton Turns 

Origination Turns 

Fuel burn/hour 

Fuel price/gallon average 

Advertising per pax (r/t) 

Credit card fee 

Travel Agent Commission: 

Load Factor: 

**Percent of OTA Sales 

MBL Service to MOW 

$ 

$ 

$ 

$ 

$ 

1,750.00 

500.00 

545.00 

2 

3 

165 

4.00 

5.00 

3.50% 

10% 

50% 

30% 

per turn 

per turn 

per day 

per day 

*Re! 

Percer 

Operation 

A-v 

Departur 

DepartL 

Block Hours 

**TARP Commision Agreements negotiated seperately with each Travel Agen< 
*including CRS fees 

Catering- per pax 

;ervation cost/pax 

1t of GDS bookings 

,al Days Per Week: 

Call Center: 

•g. Passenger Fare: 

Deicing : 

$ 

$ 

$ 

$ 

$ 

1.50 

15.00 

2 

5 

2,000.00 

69.00 

-

Seats per flight 30 

es per week (o/w) 20 

tres per week (r/t) 10 

Per Segment (avg) 0.90 

:y 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

s 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

Year Ttl 

25.80 

516 

464.40 

7,740 

534,060.00 

(18,692.10) 

(36,389.25) 

(14,904.00) 

464,074.65 

812,700.00 

306,504.00 

339,915.00 

11,610.00 

1,470,729.00 

38,700.00 

58,050.00 

12,000.00 

108,750.00 

1,579,479.00 

(1,115,404.35) 
Fare Range: 

Aircraft: 

Aircraft Base: 

Item 

Weeks per Month 

Days per Week 

Depts per Week 

Depts per Month 

Avg. Block per Leg 

Ttl Block per Month 

Load Factor 

Seats per flight 

Pax per flight 

Avg. Pax Fare 

Ttl Pax per Month 

Ticket Rev. 

Credit Card Fee 

FET & 7.5% 

Agent Comm. 

Ttl Op. Revenue 

Direct Operating Cost 

ACMI 

Fuel 

Ground 

Deicing 

Catering 

Ttl Direct Op. Cost 

Indirect Operationing Costs 

Advertizing 

Reservation/GDS 

Call Center 

And INC 

Low $ 49.00 High'$ 

19

149.00 I 

Bae-3100 Jetstream Seats: 

MBL 

Schedule: lOx flights round trip per week 

Dept Arrive Stops 

MBL 7:25AM MOW 7:25AM 0 

MOW 11:00 AM MBL 1:00PM 0 

MBL 1:30PM MOW 1:30PM 0 

MOW 6:00PM MBL 8:00PM 0 

TIMES ARE FLEXIBLE 

Ttl Indirect Op. Cost================================ 

Ttl Op. Cost 

Operating P/L 
Proposal to Provide Alternate Essential Air Service At Manistee, Ml ~----~--~----------~ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

s 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

Docket DOT-OST- 1996-1711 

ACMI incl. Hotel & per diem 

Destin. Ground Fees 

Origin Ground Fees 

Destinaton Turns 

Origination Turns 

Fuel burn/hour 

Fuel price/gallon average 

Advertising per pax (r/t) 

Credit card fee 

Travel Agent Commission: 

Load Factor: 

**Percent of OTA Sales 

MBL Service to MOW 

$ 

$ 

$ 

$ 

$ 

1,525.00 

450.00 

545.00 

2 

3 

110 

4.00 

5.00 

3.50% 

10% 

65% 

30% 

per turn 

per turn 

per day 

per day 

*Re~ 

Percer 

Operation 

A\J 

Departur 

DepartL 

Block Hours 

**TARP Commision Agreements negotiated seperately with each Travel Agen< 

Nov Dec Jan Feb Mar 

4.3 4.3 4.3 4.3 4.3 

5 5 5 5 5 

20 20 20 20 20 

86 86 86 86 86 

0.90 0.90 0.90 0.90 0.90 

77.40 77.40 77.40 77.40 77.40 

65% 65% 65% 65% 65% 

19 19 19 19 19 

12 12 12 12 12 

69.00 $ 69.00 $ 69.00 $ 69.00 $ 69.00 

1,032 1,032 1,032 1,032 1,032 

71,208.00 $ 71,208.00 $ 71,208.00 $ 71,208.00 $ 71,208.00 

(2,492.28) $ (2,492.28) $ (2,492.28) $ (2,492.28) $ (2,492.28) 

(4,851.90) $ (4,851.90) $ (4,851.90) $ (4,851.90) $ (4,851.90) 

(1,987.20) $ (1,987.20) $ (1,987.20) $ (1,987.20) $ (1,987.20) 

61,876.62 $ 61,876.62 $ 61,876.62 $ 61,876.62 $ 61,876.62 

118,035.00 $ 118,035.00 $ 118,035.00 $ 118,035.00 $ 118,035.00 

34,056.00 $ 34,056.00 $ 34,056.00 $ 34,056.00 $ 34,056.00 

54,502.50 $ 54,502.50 $ 54,502.50 $ 54,502.50 $ 54,502.50 

5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 

1,548.00 s 1,548.00 s 1,548.00 s 1,548.00 s 1,548.00 

213,141.50 $ 213,141.50 $ 213,141.50 $ 213,141.50 $ 213,141.50 

5,160.00 $ 5,160.00 $ 5,160.00 $ 5,160.00 $ 5,160.00 

7,740.00 $ 7,740.00 $ 7,740.00 $ 7,740.00 $ 7,740.00 

2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 

14,900.00 $ 14,900.00 $ 14,900.00 $ 14,900.00 $ 14,900.00 

228,041.50 $ 228,041.50 $ 228,041.50 $ 228,041.50 $ 228,041.50 

(166,164.88) $ (166,164.88) $ (166,164.88) $ (166,164.88) $ (166,164.88) 
*including CRS fees 

Catering - per pax 

;ervation cost/pax 

1t of GDS bookings 

ral Days Per Week: 

Call Center: 

•g. Passenger Fare: 

Deicing : 

$ 

$ 

$ 

$ 

$ 

1.50 

15.00 

2 

5 

2,000.00 

69.00 

5,000.00 

Seats per flight 19 

es per week (o/w) 20 

1res per week (r/t) 10 

Per Segment (avg) 0.90 

:y 

4.3 

5 

20 

86 

0.90 

77.40 

65% 

19 

12 

$ 69.00 

1,032 

$ 71,208.00 

$ (2,492.28) 

$ (4,851.90) 

$ (1,987.20) 

$ 61,876.62 

$ 118,035.00 

$ 34,056.00 

$ 54,502.50 

$ 5,000.00 

$ 1,548.00 

$ 213,141.50 

$ 5,160.00 

$ 7,740.00 

$ 2,000.00 

$ 14,900.00 

$ 228,041.50 

$ (166,164.88) 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

$ 

Year Ttl 

25.80 

516 

464.40 

6,192 

427,248.00 

(14,953.68) 

(29,111.40) 

(11,923.20) 

371,259.72 

708,210.00 

204,336.00 

327,015.00 

30,000.00 

9,288.00 

1,278,849.00 

30,960.00 

46,440.00 

12,000.00 

89,400.00 

1,368,249.00 

(996,989.28)