Red Frog Freight - 2012 Annual Activity Report


Prepared by Spicy Frog, CEO of Red Frog Freight, Locin WeEda, CEO of Red Frog Investments and Red Frog Rufen CEO of Blue Frog Freight and Black Frog Logistics

Red Frog Freight’s mission is to provide fast and affordable delivery of any volume of freight. Commonly referred to as just “Red Frog” or “RF”, its logistical divisions comprise three operational corporations:

Stats summary (all divisions)

Division Contracts issued Contracts completed Contracts deleted Contracts failed
RFF 110,290 102,527 7,558 194
BFL 14,403 12,407 1,973 14
BFF 4,293 3,838 454 1

 

Division Total rewards (includes tips) Total tips Total collateral
RFF 685,063,091,124 58,853,441,124 75,051,982,610,754
BFL 1,110,679,122,431 24,564,000,987 21,274,892,801,344
BFF 127,317,288,499 9,150,850,999 12,665,787,043,359
Total 1,923,059,502,054 92,568,293,110 108,992,662,455,457

 

 


Summary of Red Frog Freight

  2012 2011 Growth
Contracts 102,527 54,530 88.02%
Volume (m3) 32,303,245,079 22,451,594,301 43.88%
Jumps 1,254,400 662,757 89.27%
Reward (isk) 685,063,091,124 259,229,950,000 164.3%
Collateral provided (isk) 75,051,982,610,754 Not available -

Contracts

RFF experienced significant growth in all contract metrics for RFF year over year. The total contracts and total jumps had comparable gains, and would indicate a constant average jumps per contract in both 2012 and 2011. The relatively lower gain in volume hauled indicates the many small contracts customers issued in 2012 as compared to 2011. The significantly larger growth by percentage in rewards were in part due to price increases enacted during 2012.

Number of contracts completed in 2009, 2010, 2011 and 2012 by RFF

Volume distribution

In the volume per contract in 2012, 20172 contracts — 19.7% of all contracts — had a volume of 20,000m3 or less. There were far more small contracts in 2012 than there were in 2011. Fifty percent (50%) of contracts in 2012 were 140,000m3 or less. There is a spike of contracts in the 480,000m3 to 500,000m3 range this year. In fact, 1698 of those contracts had a volume of exactly 500,000m3. Another bunch of contracts are created at near the maximum contract volume of 860,000 m3.

Number of contracts by volume per contract, 2011 and 2012

Completion time statistics

Red Frogs goal is to complete contracts within 24 hours after set-up, but this is not always possible due to various reasons. We ask for 3 days to accept, and 1 day to complete of our customers, and usually RFF deliver well within these parameters. Out of the 102,527 contracts completed by RFF in 2012, about 82% of the contracts were completed within 24 hours after the contracts were issued, and 97.5% of the contracts were completed within 48 hours after the contracts were issued. The median time from a contract was issued until it was completed was about 9 hours.

2012

N

Mean time

Std dev

Median

25% Quartile

75% Quartile

Issued to accepted

102,527

10.50

12.19

5.37

1.43

15.84

Accepted to completed

102,527

3.04

4.19

1.74

0.88

3.50

Issued to completed

102,527

13.53

12.93

9

3.91

19.40

Month

N

Mean time - hours (Issued to accepted)

Std dev - hours (issued to accepted

Median time - hours (issued to accepted

Lower quartile - hours (issued to accepted)

Upper quartile - hours (issued to accepted)

January

6015

7.34

8.04

4.22

1.33

11.07

February

5885

9.50

10.23

5.39

1.61

14.95

March

6948

13.38

13.75

8.31

2.34

20.44

April

7726

13.98

13.93

9.36

2.5

22.18

May

7629

4.84

5.84

2.51

0.82

6.85

June

7070

6.43

8.14

2.75

0.71

9.38

July

7660

5.06

6.62

2.21

0.54

6.89

August

9107

5.60

6.73

2.82

0.67

8.21

September

9491

9.77

10.53

5.75

1.59

14.84

October

10730

15.40

14.81

10.14

2.88

24.81

November

10933

17.07

15.31

12.78

3.45

27.44

December

13333

11.90

12.82

6.64

1.85

18.95

Month

N

Mean time (Accepted to completed)

Std dev (Accepted to completed)

Median time (Accepted to completed)

Lower quartile (Accepted to completed)

Upper quartile (Accepted to completed)

January

6015

3.13

5.87

1.84

0.93

3.40

February

5885

3.08

5.82

1.77

0.87

3.32

March

6948

3.19

4.15

1.79

0.81

3.79

April

7726

3.45

5.12

1.85

0.86

4.04

May

7629

3.32

3.76

2.08

1.06

3.98

June

7070

3.28

3.89

1.93

0.92

3.81

July

7660

3.38

5.25

2.04

1.01

4.03

August

9107

3.09

3.72

1.82

0.89

3.61

September

9491

2.78

3.34

1.55

0.82

3.21

October

10730

2.49

3.24

1.49

0.82

2.64

November

10933

3.10

3.76

1.74

0.89

3.62

December

13333

2.70

3.26

1.54

0.85

3.08

Month

N

Mean time (Issued to completed)

Std dev (issued to completed)

Median time (issued to completed)

Lower quartile (issued to completed)

Upper quartile (issued to completed)

January

6015

10.48

9.71

7.64

3.91

14.77

February

5885

12.58

11.59

9.10

4.21

18.25

March

6948

16.57

14.42

12.03

5.18

23.74

April

7726

17.43

14.71

13.23

5.78

25.49

May

7629

8.17

7.14

5.69

3.05

11.39

June

7070

9.71

9.12

6.49

2.96

13.79

July

7660

8.44

8.33

5.74

2.85

11.82

August

9107

8.68

7.86

5.98

2.76

12.38

September

9491

12.55

11.17

8.99

3.59

18.26

October

10730

17.89

15.26

13.17

4.98

27.51

November

10933

20.17

16.13

15.94

6.19

30.97

December

13333

14.59

13.39

9.86

4.12

21.89

 

Box-plot image with outliers

Boxplot chart with outliers above 180 hours, removed

Completion times by region

Regional coverage of service

In 2012, Red Frog Freight serviced* all high sec regions (21 regions), and all 891 systems with stations in them in contiguous high security space. This is the first time Red Frog delivered to every possible solar system.

* serviced = pick up or drop off location

Region Contract start
(with top ten in parentheses)
Contract destination
(with top ten in parentheses)
Net movement of contracts
(green = into region, yellow= no net movement in or out, orange = out of region
The Forge 40,007 (1) 47,001 (1) -6,994
The Citadel 3,914 (7) 4,776 (4) -862
Placid 1,645 2,195 -550
The Bleak Lands 974 1,182 -208
Derelik 1,788 1,989 -201
Kor-Azor 2,111 2,218 (10) -107
Black Rise 824 916 -92
Khanid 2,662 (10) 2,676 (8) -14
Molden Heath 723 737 -14
Genesis 1,378 1,233 145
Devoid 1,545 1,397 148
Sinq Laison 4,677 (6) 4,422 (5) 255
Verge Vendor 1,345 1,049 296
Everyshore 1,208 722 486
Essence 2,990 (9) 2,410 (9) 580
Kador 1,357 771 586
Heimatar 4,736 (5) 4,032 (6) 704
Domain 12,502 (2) 11,722 (2) 780
Tash-Murkon 3,168 (8) 1,988 1,180
Metropolis 5,222 (4) 3,892 (7) 1,330
Lonetrek 7,751 (3) 5,199 (3) 2,552
Total 102,527 102,527 0

Contract region matrix

The matrix display illustrates the total contracts from each start region to each end region. Intra-regional contracts will be tabulated where the same start region and end region intersect.

Intra-regional contracts 22,749
Inter-regional contracts 79,778

Customers

RFF is the largest hauling service corporation in EVE, which is demonstrated in its unique customer counts.

  2012
Unique customers 15,194
Unique corporations 6,752

New and repeat customers by month

Failed contracts

During 2012 we had a total number of 194 failed contracts. The reasons for failure in these instances have been analysed.

Several of the freighter ganks happened because the pilot was carrying more than one double-wrapped package at a time. We also had a number of losses where the pilot carried just one double-wrapped package. As a result of these incidents, we changed our policy regarding double-wrapping. We are now primarily displaying the goods to any scanners, so they can determine the value for themselves before they decide to gank or not. We believe this, together with the new crime-watch system will reduce the amount of freighter ganks for profit in 2013.

Lost in suicide ganks: 89 contracts (spread over at least 25 freighter ganks)
Lost in awoxer incident: 2 contracts (3 freighters lost)
Theft by pilot: 35 contracts (undercollateralized contracts)
Failed by client, overdue contract: 9
Failed by pilot, returned to client: 4
Unknown: 57

Recruitment and retention

Hauling service is made possible by pilots, and lots of them. In December 2011, a more standardized recruitment application was created. During the entire 2012 year, recruiters at RFF spend large amounts of time on background checks, processing applications, and bringing new pilots into the service.

  2012
Applications received 401
Pilots accepted (approximate) 247
Unique RFF contractors 484

Raw Data

This year you must not rely on our analysis alone; a set of raw data is published below with selected columns of data in CSV format.

RFF_2012_contracts.zip
(4.98 MB, 29.4 MB expanded. 110,290 rows plus header row)

Legend

Column name Description
contractID Contract ID, unique key column
type “Courier”
status Contract status, such as “Completed”, “Deleted”, etc.
forCorp 0 = Issued by a pilot, 1 = Issued on behalf of a corporation
availability Private
dateIssued Date issued, will be between 2012-01-01 and end of 2012-12-31
dateExpired Date expired
dateAccepted Date accepted
numDays Number of days to complete
dateCompleted Date completed
reward Reward specified by the issuer
collateral Collateral
volume Volume
jumps Jumps, as calculated by RF
points Star points, as assigned by RF
baseReward Base reward, as the reward from the RF trip calculator at the time of contract issue
startSolarSystemID Contract start solar system ID
endSolarSystemID Contract destination solar system ID
startSolarSystemName Contract start solar system name
endSolarSystemName Contract destination solar system name
startRegionID Contract start region ID
endRegionID Contract destination region ID
startRegion Contract start region name
endRegion Contract destination region name
secondsItoA Calculated seconds from Date Issued to Date Accepted
secondsAtoC Calculated seconds from Date Accepted to Date Completed
secondsItoC Calculated seconds from Date Issued to Date Completed

 

 


Summary of Black Frog Logistics

  2012
Contracts 12,407
  Low sec 9,277
  Null sec 3,130
Volume (m3) 2,535,180,609.28
Reward (isk) 1,086,115,121,443.94
Collateral provided (isk) 21,274,892,801,344.00

Year over year comparison, fourth quarter

  Oct to Dec 2011 Oct to Dec 2012 Growth
Contracts 1,788 4,053 126.7%
  Low sec 1,365 3,125 128.9%
  Null sec 423 928 119.4%
Volume (m3) 392,063,719 852,428,988 117.4%
Reward (isk) 113,565,500,000 377,771,600,000 232.6%
Collateral provided (isk) 2,923,977,449,964 6,937,140,223,127 137.3%

Contracts

There was a steady rise in contracts completed each month by Black Frog Logistics during the 2012 year, with a marked increase in December 2012, as depicted in the contracts completed chart. As compared to the partial 2011 data, the year over year comparison shows a two-fold increase. In a comparison of the fourth quarter results, the contracts completed increased by 126.7%. The rewards increase outpaced the contracts increase primarily caused by a change to how BFL rewards were calculated, namely the addition of a volume surcharge, and pricing based on lightyear (ly) distance of routes.

Number of contracts completed in 2011 and 2012 by Black Frog (*2011 year incomplete)

Volume distribution in 2012

Completion time

Completion times by route security types

Regional statistics

Region Contract start
(with top ten in parentheses)
Contract destination
(with top ten in parentheses)
Net movement of contracts
(green = into region, yellow= no net movement in or out, orange = out of region
Black Rise 453 (8) 871 (2) -418
Lonetrek 523 (6) 818 (3) -295
Placid 456 (7) 605 (6) -149
Devoid 164 272 -108
Molden Heath 285 385 (10) -100
Curse 332 404 (9) -72
The Bleak Lands 159 201 -42
Solitude 256 295 -39
Everyshore 120 155 -35
The Citadel 135 155 -20
Genesis 264 282 -18
Detorid 96 111 -15
Fountain 53 60 -7
Essence 206 212 -6
Great Wildlands 39 45 -6
Venal 97 102 -5
Kador 56 61 -5
Delve 147 151 -4
Metropolis 724 (2) 728 (4) -4
Geminate 30 34 -4
Derelik 616 (3) 619 (5) -3
Outer Ring 129 127 2
Stain 330 327 3
Pure Blind 34 28 6
Khanid 301 280 21
Kor-Azor 253 229 24
Tash-Murkon 245 220 25
Verge Vendor 174 147 27
Syndicate 303 269 34
Aridia 541 (5) 488 (7) 53
Domain 544 (4) 426 (8) 118
Sinq Laison 406 (10) 266 140
Heimatar 439 (9) 253 186
The Forge 3,497 (1) 2,781 (1) 716
Total 12,407 12,407 0

Failed contracts

During 2012 Black Frog Freight had a total number of 14 failed contracts.

 

 


Summary of Blue Frog Freight

Total 2012
Contracts 3,838
Volume (m3) 963,190,438.52
Jumps 57,934
Reward (isk) 127,317,288,499
Collateral provided (isk) 12,665,787,043,359.00

Year over year comparison, fourth quarter

Total Oct to Dec 2011 Oct to Dec 2012 Growth
Contracts 208 1,296 523%
Volume (m3) 62,163,791 345,217,349 455%
Reward (isk) 5,813,750,000 47,778,812,499 722%
Collateral provided (isk) 603,393,387,623 4,344,655,135,325 620%

Contracts

BFF has continued to grow during 2012, but the influx of contracts varies greatly depending on customer needs.

It’s important to note that a lot of the "rush" contracts are handled directly between the customer and the individual pilot, which lowers the reported statistics by about 15%.

Volume distribution

Completion time

The average Issued to completed is 10h33m, and the median is 6h13m. 71% of the contracts were completed under 12h. (those stats do not include Rush Service)

Regional statistics

Region Contract start
(with top ten in parentheses)
Contract destination
(with top ten in parentheses)
Net movement of contracts
(green = into region, yellow= no net movement in or out, orange = out of region
The Forge 1,425 (1) 2,175 (1) -750
Derelik 83 97 (9) -14
Molden Heath 22 21 1
Verge Vendor 45 38 7
Genesis 53 44 9
Tash-Murkon 74 64 10
Kador 41 30 11
The Bleak Lands 41 30 11
Domain 281 (3) 269 (2) 12
Placid 131 (9) 113 (6) 18
Everyshore 40 18 22
Sinq Laison 171 (6) 149 (4) 22
Khanid 113 85 28
Devoid 84 56 28
Black Rise 59 22 37
Kor-Azor 131 (8) 88 (10) 43
The Citadel 167 (7) 118 (5) 49
Heimatar 172 (5) 111 (8) 61
Essence 126 (10) 32 94
Lonetrek 262 (4) 112 (7) 150
Metropolis 317 (2) 166 (3) 151
Total 3,838 3,838 0

Failed contracts

During 2012 we had a total number of 1 failed contracts. It was lost in a suicide gank.

 

 


Notes on Data Collection

The 2012 year was the first year where all data was harvested via the EVE API, and a full year of statistics for all three freight divisions was available. Most numbers are based on the dateIssued of each contract, and not on the dateAccepted.

If “base rewards” are mentioned anywhere, they represent the reward as calculated by the Red Frog web calculator at the time of contract issue. Therefore, when price increases were rolled out, the new base reward was stored along side that contract.