for archmage

profilenit.po
fall15part1_inputdata.xlsx
Home>Business & Finance homework help>for archmage

Demand Data

MBA604 Part A Demand is given in Thousand cases.
Period (month) Demand Northeast Marketing/sales budget Northeast Number of contracted restaurants Northeast Demand Northwest Marketing/sales budget Northwest Number of contracted reastaurants Northeast Demand Southeast Marketing/Sales Budget Southeast Number of contracted restaurants Southeast Demand Southwest Marketing/Sales Budget Southwest Number of contracted restaurants Southwest
1 1200 25,000.00 € 80 800 18,000.00 € 50 990 20,000.00 € 88 1550 25,000.00 € 135
2 1300 28,000.00 € 85 850 18,000.00 € 58 950 15,000.00 € 85 1600 25,000.00 € 135
3 1200 30,000.00 € 93 820 18,000.00 € 63 940 15,000.00 € 80 1450 25,000.00 € 140
4 1400 30,000.00 € 95 900 22,000.00 € 66 820 12,000.00 € 77 1500 28,000.00 € 143
5 1500 30,000.00 € 95 880 22,000.00 € 67 900 12,000.00 € 78 1600 28,000.00 € 142
6 1450 35,000.00 € 95 920 22,000.00 € 68 950 12,000.00 € 83 1450 28,000.00 € 144
7 1550 35,000.00 € 95 900 25,000.00 € 73 1030 18,000.00 € 87 1640 28,000.00 € 151
8 1700 38,000.00 € 95 950 25,000.00 € 73 1020 18,500.00 € 91 1670 28,000.00 € 158
9 1800 35,000.00 € 95 1020 26,000.00 € 75 1050 19,000.00 € 92 1750 25,000.00 € 160
10 1630 35,000.00 € 95 930 27,500.00 € 79 1000 19,000.00 € 92 1780 25,000.00 € 157
11 1480 35,000.00 € 95 990 28,000.00 € 77 1050 19,000.00 € 92 1800 25,000.00 € 161
12 1480 35,000.00 € 95 1000 28,500.00 € 77 1100 19,000.00 € 93 1850 25,000.00 € 161
13 35,000.00 € 95 25,000.00 € 75 20,000.00 € 93 25,000.00 € 160

Costs and Capacity

Production cost New Brewery location Transportation cost New Brewery Location
Market Koblenz Bamberg Oldenburg Magdeburg Zwickau Market Koblenz Bamberg Oldenburg Magdeburg Zwickau
Northeast 1600 1500 1800 1400 1600 Northeast 550 450 400 200 250
Northwest 1600 1500 1800 1400 1600 Northwest 350 500 250 300 350
Southeast 1600 1500 1800 1400 1600 Southeast 200 210 450 300 300
Southwest 1600 1500 1800 1400 1600 Southwest 400 300 300 450 400
Capacity
in thousand cases 1,200 1,800 1,200 1,700 1,500
Both production and transportation cost are per 1000 cases.
The capacity is per month, in line with the forecasted monthly demand.