*********************************************************************** Price point calculator for the Austrian multiband auction Version 1.0 (c) 2006-2014 DotEcon Ltd (www.dotecon.com) ---------------------------------------------------------------- DATA IMPORT Using default lot structure Reading from bids file: data\multibandauction_bids.csv ---------------------------------------------------------------- LOT STRUCTURE Categories: Category A1 contains 1 item - reserve 32000000- eligibility 1 Category A2 contains 4 items - reserve 32000000- eligibility 1 Category A3 contains 1 item - reserve 32000000- eligibility 1 Category B1 contains 1 item - reserve 23400000- eligibility 1 Category B2 contains 5 items - reserve 29900000- eligibility 1 Category B3 contains 1 item - reserve 23400000- eligibility 1 Category C1 contains 2 items - reserve 14600000- eligibility 1 Category C2 contains 8 items - reserve 8800000- eligibility 1 Category C3 contains 5 items - reserve 11400000- eligibility 1 Summary of bids loaded: --------------------------------------- Read from file successful: 3 bidders found. Bid data read (zero bids will be automatically added if not present in the bids file): A1TelekomAustriaAktiengesellschaft (ID = 1) xxxx bids read. T-MobileAustriaGmbH (ID = 2) xxxx bids read. HutchisonDreiAustriaGmbH (ID = 3) xxxx bids read. ---------------------------------------------------------------- PROCESSING OF LOADED DATA ---------------------------------------------------------------- PRINCIPAL STAGE RESULTS Reading principal stage results from file: data\multibandauction_results.csv Winning outcome: Bidder A1 A2 A3 B1 B2 B3 C1 C2 C3 Bid amount Base price A1TelekomAustriaAktiengesellschaft 1 2 1 0 2 1 2 3 2 xxxx 1029895738 T-MobileAustriaGmbH 0 2 0 1 2 0 0 4 0 xxxx 653998071 HutchisonDreiAustriaGmbH 0 0 0 0 1 0 0 1 3 xxxx 329031581 Unallocated lots: /0/0/0/0/0/0/0/0/0/ Value of winning bids: xxxx Unallocated lots value: 0 Total value: xxxx Minimum revenue core: 2012925390 ---------------------------------------------------------------- DETERMINATION OF PRICE POINTS ACCORDING TO LINEAR REFERENCE PRICING METHODOLOGY Number of sold categories relevant in ALP determination: 9 ---------------------------------------------------------------- MINIMISATION OF EXCURSIONS Setting up constraints for minimisation -------------------------------------- Setting up epsilon constraints Adding reserve price constraints Results of minimisation: ------------------------ LP completed with return code = 0 Intermediate results of maximum deviations: Maximum deviation for A1TelekomAustriaAktiengesellschaft: 8761692.896 Maximum deviation for T-MobileAustriaGmbH: 52173977.216 Maximum deviation for HutchisonDreiAustriaGmbH: 4830579.216 Minimum sum of excursions: 65766249.328 Intermediate linear prices: Intermediate linear price for A1: 88877049.813 Intermediate linear price for A2: 97679840.112 Intermediate linear price for A3: 71769444.410 Intermediate linear price for B1: 83650033.366 Intermediate linear price for B2: 108480612.582 Intermediate linear price for B3: 108941425.007 Intermediate linear price for C1: 64256605.813 Intermediate linear price for C2: 54075759.366 Intermediate linear price for C3: 61056605.813 ---------------------------------------------------------------- MINIMISATION OF REVENUE SUBJECT TO EXCURSIONS Setting up constraints for minimisation -------------------------------------- Setting up epsilon constraints Adding minimum sum constraint. All excursions need to sum to 65766249.328 Adding reserve price constraints Results of minimisation: ------------------------ LP completed with return code = 0 Intermediate results of maximum deviations: Maximum deviation for A1TelekomAustriaAktiengesellschaft: 8761692.896 Maximum deviation for T-MobileAustriaGmbH: 52173977.216 Maximum deviation for HutchisonDreiAustriaGmbH: 4830579.216 Minimum sum of excursions:65766249.328 Intermediate linear prices: Intermediate linear price for A1: 88877049.813 Intermediate linear price for A2: 97679840.112 Intermediate linear price for A3: 71769444.410 Intermediate linear price for B1: 83650033.366 Intermediate linear price for B2: 108480612.582 Intermediate linear price for B3: 108941425.007 Intermediate linear price for C1: 64256605.813 Intermediate linear price for C2: 54075759.366 Intermediate linear price for C3: 61056605.813 Minimum revenue: 2152762691.575 ---------------------------------------------------------------- ALIGNMENT OF REFERENCE PRICES WITH RESERVE PRICES Lambda set to 3.951. Number of initial inequality constraints: 9 Iterations of quadratic programme (deferred constraint generation): ------------------------------------------------------------------ Iteration number 1 - total number of inequality constraints = 9 Return value QP solver: -4252511659.236 Sum of maximum deviations for intermediate solution: 417070973.363 Iteration number 2 - total number of inequality constraints = 10 Return value QP solver: -4120811898.401 Sum of maximum deviations for intermediate solution: 175093707.266 Iteration number 3 - total number of inequality constraints = 11 Return value QP solver: -4091791454.109 Sum of maximum deviations for intermediate solution: 197895436.272 Iteration number 4 - total number of inequality constraints = 12 Return value QP solver: -4068125941.194 Sum of maximum deviations for intermediate solution: 108032309.379 Iteration number 5 - total number of inequality constraints = 13 Return value QP solver: -4049605749.782 Sum of maximum deviations for intermediate solution: 116515131.478 Iteration number 6 - total number of inequality constraints = 14 Return value QP solver: -4023056076.710 Sum of maximum deviations for intermediate solution: 136678491.517 Iteration number 7 - total number of inequality constraints = 15 Return value QP solver: -4012039380.481 Sum of maximum deviations for intermediate solution: 104223347.568 Iteration number 8 - total number of inequality constraints = 16 Return value QP solver: -3998748763.610 Sum of maximum deviations for intermediate solution: 106997428.731 Iteration number 9 - total number of inequality constraints = 17 Return value QP solver: -3988119689.396 Sum of maximum deviations for intermediate solution: 103414562.086 Iteration number 10 - total number of inequality constraints = 18 Return value QP solver: -3976026334.357 Sum of maximum deviations for intermediate solution: 88945926.135 Iteration number 11 - total number of inequality constraints = 19 Return value QP solver: -3962945945.550 Sum of maximum deviations for intermediate solution: 92136828.850 Iteration number 12 - total number of inequality constraints = 20 Return value QP solver: -3944671823.372 Sum of maximum deviations for intermediate solution: 94923810.170 Iteration number 13 - total number of inequality constraints = 21 Return value QP solver: -3938509148.942 Sum of maximum deviations for intermediate solution: 85184479.873 Iteration number 14 - total number of inequality constraints = 22 Return value QP solver: -3936083432.641 Sum of maximum deviations for intermediate solution: 71545653.638 Iteration number 15 - total number of inequality constraints = 23 Return value QP solver: -3932228841.668 Sum of maximum deviations for intermediate solution: 81589943.470 Iteration number 16 - total number of inequality constraints = 24 Return value QP solver: -3897774212.500 Sum of maximum deviations for intermediate solution: 67262443.684 Iteration number 17 - total number of inequality constraints = 25 Return value QP solver: -3894753173.655 Sum of maximum deviations for intermediate solution: 67410473.297 Iteration number 18 - total number of inequality constraints = 26 Return value QP solver: -3890259251.090 Sum of maximum deviations for intermediate solution: 70887284.151 Iteration number 19 - total number of inequality constraints = 27 Return value QP solver: -3888942805.986 Sum of maximum deviations for intermediate solution: 66398055.532 Iteration number 20 - total number of inequality constraints = 28 Return value QP solver: -3888220143.471 Sum of maximum deviations for intermediate solution: 65766249.328 At the minimum sum: 65766249.328. Finished Iterations for QP. Solution (rounded down to nearest whole amounts): -------------------------------------------------- ALP for A1: 88877049.813 (88877049) ALP for A2: 97679840.112 (97679840) ALP for A3: 71769444.410 (71769444) ALP for B1: 83650033.366 (83650033) ALP for B2: 108480612.582 (108480612) ALP for B3: 108941425.007 (108941425) ALP for C1: 64256605.813 (64256605) ALP for C2: 54075759.366 (54075759) ALP for C3: 61056605.813 (61056605) Lambda: 3.951 Excursions: ----------- A1TelekomAustriaAktiengesellschaft: 8761692.896 T-MobileAustriaGmbH: 52173977.216 HutchisonDreiAustriaGmbH: 4830579.216 ---------------------------------------------------------------- EXPORTING RESULTS Printing results to data\withoutrevconstr.csv ---------------------------------------------------------------- DONE - EXITING.