for archmage

profilenit.po
fall15part2_inputdata_1.xlsx

cost calculation

Zwickau
Capacity in 1000 cases Resulting total capacity (all breweries) Production Cost per 1000 cases Expected aggregated sales good economy (in 1000 cases) Expected aggregated sales medium economy (in 1000 cases) Expected aggregated sales bad economy (in 1000 cases) Subcontracting cost per 1000 cases
1250 5450 € 1,800.00 6000.00 5000.00 4300.00 2500
1500 5700 € 1,600.00 6000.00 5000.00 4300.00 2500
1700 5900 € 1,400.00 6000.00 5000.00 4300.00 2500
Magdeburg
Capacity in 1000 cases Resulting total capacity (all breweries) Production Cost per 1000 cases Expected aggregated sales good economy (in 1000 cases) Expected aggregated sales medium economy (in 1000 cases) Expectedaggregated sales bad economy (in 1000 cases) Subcontracting cost per 1000 cases
1500 5700 € 1,600.00 6000.00 5000.00 4300.00 3500
1700 5900 € 1,400.00 6000.00 5000.00 4300.00 3500
2200 6400 € 1,300.00 6000.00 5000.00 4300.00 3500
Expected sales are given for 1 month.
The capacity is also monthly capacity.