*********************************************************************** Price point calculator for the Austrian multiband auction Version 1.0 (c) 2006-2014 DotEcon Ltd (www.dotecon.com) ---------------------------------------------------------------- DATA IMPORT Using condensed alternative lot structure 1 Reading from bids file: data\multibandauction_bids.csv ---------------------------------------------------------------- LOT STRUCTURE Categories: Category 800MHz contains 6 items - reserve 32000000- eligibility 1 Category 900MHz contains 7 items - reserve 23400000- eligibility 1 Category 1800MHz contains 15 items - reserve 8800000- 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 [WARN] The winning bid amount of 1491408690 in the principal stage results file is not equal to the bid for package Package: 1/2/1/0/2/1/2/3/2/ by A1TelekomAustriaAktiengesellschaft - setting winning bid amount to 1499208690 [WARN] The winning bid amount of 778000000 in the principal stage results file is not equal to the bid for package Package: 0/0/0/0/1/0/0/1/3/ by HutchisonDreiAustriaGmbH - setting winning bid amount to 785000000 Winning outcome: Bidder 800MHz 900MHz 1800MHz Bid amount Base price A1TelekomAustriaAktiengesellschaft 4 3 7 xxxx 1029895738 T-MobileAustriaGmbH 2 3 4 xxxx 653998071 HutchisonDreiAustriaGmbH 0 1 4 xxxx 329031581 Unallocated lots: /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: 3 ---------------------------------------------------------------- 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: 51285374.000 Maximum deviation for T-MobileAustriaGmbH: 79954135.000 Maximum deviation for HutchisonDreiAustriaGmbH: 3814626.000 Minimum sum of excursions: 135054135.000 Intermediate linear prices: Intermediate linear price for 800MHz: 82960011.500 Intermediate linear price for 900MHz: 110052135.000 Intermediate linear price for 1800MHz: 56185374.000 ---------------------------------------------------------------- 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 135054135.000 Adding reserve price constraints Results of minimisation: ------------------------ LP completed with return code = 0 Intermediate results of maximum deviations: Maximum deviation for A1TelekomAustriaAktiengesellschaft: 51285374.000 Maximum deviation for T-MobileAustriaGmbH: 79954135.000 Maximum deviation for HutchisonDreiAustriaGmbH: 3814626.000 Minimum sum of excursions:135054135.000 Intermediate linear prices: Intermediate linear price for 800MHz: 82960011.500 Intermediate linear price for 900MHz: 110052135.000 Intermediate linear price for 1800MHz: 56185374.000 Minimum revenue: 2110905624.000 ---------------------------------------------------------------- ALIGNMENT OF REFERENCE PRICES WITH RESERVE PRICES Lambda set to 4.327. Number of initial inequality constraints: 3 Iterations of quadratic programme (deferred constraint generation): ------------------------------------------------------------------ Iteration number 1 - total number of inequality constraints = 3 Return value QP solver: -4567366290.934 Sum of maximum deviations for intermediate solution: 419117943.830 Iteration number 2 - total number of inequality constraints = 4 Return value QP solver: -4431857661.016 Sum of maximum deviations for intermediate solution: 260985414.880 Iteration number 3 - total number of inequality constraints = 5 Return value QP solver: -4368184790.006 Sum of maximum deviations for intermediate solution: 176612762.626 Iteration number 4 - total number of inequality constraints = 6 Return value QP solver: -4299429530.047 Sum of maximum deviations for intermediate solution: 165281144.811 Iteration number 5 - total number of inequality constraints = 7 Return value QP solver: -4259065475.207 Sum of maximum deviations for intermediate solution: 149329612.189 Iteration number 6 - total number of inequality constraints = 8 Return value QP solver: -3987514632.463 Sum of maximum deviations for intermediate solution: 135054135.000 At the minimum sum: 135054135.000. Finished Iterations for QP. Solution (rounded down to nearest whole amounts): -------------------------------------------------- ALP for 800MHz: 82960011.500 (82960011) ALP for 900MHz: 110052135.000 (110052135) ALP for 1800MHz: 56185374.000 (56185374) Lambda: 4.327 Excursions: ----------- A1TelekomAustriaAktiengesellschaft: 51285374.000 T-MobileAustriaGmbH: 79954135.000 HutchisonDreiAustriaGmbH: 3814626.000 ---------------------------------------------------------------- EXPORTING RESULTS Printing results to results\without_revconstr_condensed.csv ---------------------------------------------------------------- DONE - EXITING.