*********************************************************************** 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 minimum revenue constraint. Prices of all sold lots need to sum to 2012925390.000 Adding reserve price constraints Results of minimisation: ------------------------ LP completed with return code = 0 Intermediate results of maximum deviations: Maximum deviation for A1TelekomAustriaAktiengesellschaft: 46663664.849 Maximum deviation for T-MobileAustriaGmbH: 76256767.679 Maximum deviation for HutchisonDreiAustriaGmbH: 22301462.604 Minimum sum of excursions: 145221895.132 Intermediate linear prices: Intermediate linear price for 800MHz: 82497840.585 Intermediate linear price for 900MHz: 106354767.679 Intermediate linear price for 1800MHz: 51563664.849 ---------------------------------------------------------------- ALIGNMENT OF REFERENCE PRICES WITH RESERVE PRICES Lambda set to 4.127. 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: -4153206873.418 Sum of maximum deviations for intermediate solution: 404655916.672 Iteration number 2 - total number of inequality constraints = 4 Return value QP solver: -4040178104.336 Sum of maximum deviations for intermediate solution: 286823985.073 Iteration number 3 - total number of inequality constraints = 5 Return value QP solver: -3959672423.969 Sum of maximum deviations for intermediate solution: 173136112.670 Iteration number 4 - total number of inequality constraints = 6 Return value QP solver: -3923495163.355 Sum of maximum deviations for intermediate solution: 161464507.577 Iteration number 5 - total number of inequality constraints = 7 Return value QP solver: -3897859916.426 Sum of maximum deviations for intermediate solution: 156374989.288 Iteration number 6 - total number of inequality constraints = 8 Return value QP solver: -3710462069.419 Sum of maximum deviations for intermediate solution: 145221895.132 At the minimum sum: 145221895.132. Finished Iterations for QP. Solution (rounded down to nearest whole amounts): -------------------------------------------------- ALP for 800MHz: 82497840.585 (82497840) ALP for 900MHz: 106354767.679 (106354767) ALP for 1800MHz: 51563664.849 (51563664) Lambda: 4.127 Excursions: ----------- A1TelekomAustriaAktiengesellschaft: 46663664.849 T-MobileAustriaGmbH: 76256767.679 HutchisonDreiAustriaGmbH: 22301462.604 ---------------------------------------------------------------- EXPORTING RESULTS Printing results to results\condensed.csv ---------------------------------------------------------------- DONE - EXITING.