EXCEL ASSIGNMENTS, SUPPLY CHAIN MANAGEMENT

Question 1

										Net Profit	Plants			Capacity Configuration	Plant
										Products	1	2		Products	1	2	Demand
						Demand: A: 1000; B: 1000				A	7	10		A			1000
							Probability: 0.25			B	6	4		B			1000
										Expected Profit:					2000	2000
			Demand A: 1000
										Net Profit	Plants			Capacity Configuration	Plant
						Demand: A: 1000; B: 3000				Products	1	2		Products	1	2	Demand
							Probability: 0.25			A	7	10		A			1000
										B	6	4		B			3000
	Start									Expected Profit:					2000	2000
										Net Profit	Plants			Capacity Configuration	Plant
						Demand: A: 3000; B: 1000				Products	1	2		Products	1	2	Demand
							Probability: 0.25			A	7	10		A			3000
										B	6	4		B			1000
			Demand A: 3000							Expected Profit:					2000	2000
						Demand: A: 3000; B: 3000				Net Profit	Plants			Capacity Configuration	Plant
							Probability: 0.25			Products	1	2		Products	1	2	Demand
										A	7	10		A			3000
										B	6	4		B			3000
										Expected Profit:					2000	2000

Question 2

Question 2a: Your answer:

Question 2b: Your answer:

Question 2c: Your answer: