1. As a Group: Using Table 1 in the case duplicate the sensitivity analysis of the production points for the three options considered in the case by management:

1) Build an entire new production facility that would enable GEI to produce all of the products it needed,

2) Outsource production to build partners,

3) Expand the existing GEI facility to increase production. Construct these in a spreadsheet resembling the following (start with 100 units and increment the units upward by 100 units until you have calculated it to 30,000 units:

	Option 1	Option 2	Option 3
	New location	Subcontract	Expand
Fixed costs	$4,000,000.00	$0.00	$1,250,000.00
Variable cost	$55.00	$255.00	$155.00
	Total costs per proposal fixed and variable
	Plan A	Plan B	Plan C
Units	New location	Subcontract	Expand
100	Calculate this	Calculate this	Calculate this
200
30000