INSTRUCTIONS FOR ACCOUNTING AND FINANCE STUDENTS After breaking into two or more groups complete the following (additional research is needed). 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 GEl 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