work needs to be done in Excel. thank you

Mike Company has three products, each are operated as separate segments. Mike Company allocates all of its corporate fixed costs to each of its operating segments. Mike Company's CEO, after looking at this past quarter's results has indicated that something needs to be done. He believes that PRODUCT A is losing money and has solicited your help in evaluating several options. Below are the results of the past quarter for each of the product segments and the Company Total. REQUIRED: Determine the Company Total under each of the below, mutually exclusive options: 1. Eliminate Product A 2. Eliminate Product B 3. Eliminate Product \\( \\mathrm{C} \\) 4. Eliminate Product A and Use that capacity to increase Product B Sales by \70 5. Eliminate Product \\( A \\) and Use that capacity to increase Product \\( B \\) Sales by \40 and Product C Sales by \35. 6. Given the options in parts \\( 1-5 \\), which provides the company with the highest total profit