The Jones-Pitt Company has 3 separate branches (divisions): X manufactures utensils Each branch (division operates its own facility The administrative offices are located in a separate building and administrative-facility evel costs are allocated among branches A B and C The branch income statements are presented for the year 2019. Branch Chas experienced a Net Loss Branch Chas suffered fosses in recent years, and the company expects to continue to Joperate at a loss Income Statements by Branch (Note: no formulas have been used to present the data) Division Division Division A B C 2,000,000 1.600.000 1.710,000 Sales Less: Cost of Goods Sold Unt-level Manufacturing Costs Rent on Manufacturing Facility Gross Margin Less: Operating Expenses Unt-Level Selling and Admin Expenses Division-Level Fored Selling and Admin Expenses Administrative Facility-Level Costs 1.100.000 (580,000 (900,000) (240.000 (220.000) (450,000) 600,000 800.000 360,000 160 000 45.000/150,000 (540,000|(125.000(240,000 (80,000 (80,000) (80,000) Net Income (loss) 380.000 550.000 (110,000) Requirements - using the provided Excel file: a. Based on the information above, recommend whether Division should be eliminated. Support your answer by preparing company-wide income statements - one with Division C Jand one without Division C . During 2019, Division produced and sold 30.000 units of product Would your recommendation in part(a.) change if sales and production increase to 45.000 units? Support your answer by comparing differential revenue and avoidable cost for Division Cassuming that 45.000 Junits are sold c. Suppose that the company could sublease Division Cs manufacturing facility for $910.000 Would you operate the division at a production and sales volume of 45.000 units or would you sublease? Support your answer with appropriate computations using Excel Note: you must show supporting schedules/calculations on the Excel worksheet. The Jones-Pitt Company has 3 separate branches (divisions): X manufactures utensils Each branch (division operates its own facility The administrative offices are located in a separate building and administrative-facility evel costs are allocated among branches A B and C The branch income statements are presented for the year 2019. Branch Chas experienced a Net Loss Branch Chas suffered fosses in recent years, and the company expects to continue to Joperate at a loss Income Statements by Branch (Note: no formulas have been used to present the data) Division Division Division A B C 2,000,000 1.600.000 1.710,000 Sales Less: Cost of Goods Sold Unt-level Manufacturing Costs Rent on Manufacturing Facility Gross Margin Less: Operating Expenses Unt-Level Selling and Admin Expenses Division-Level Fored Selling and Admin Expenses Administrative Facility-Level Costs 1.100.000 (580,000 (900,000) (240.000 (220.000) (450,000) 600,000 800.000 360,000 160 000 45.000/150,000 (540,000|(125.000(240,000 (80,000 (80,000) (80,000) Net Income (loss) 380.000 550.000 (110,000) Requirements - using the provided Excel file: a. Based on the information above, recommend whether Division should be eliminated. Support your answer by preparing company-wide income statements - one with Division C Jand one without Division C . During 2019, Division produced and sold 30.000 units of product Would your recommendation in part(a.) change if sales and production increase to 45.000 units? Support your answer by comparing differential revenue and avoidable cost for Division Cassuming that 45.000 Junits are sold c. Suppose that the company could sublease Division Cs manufacturing facility for $910.000 Would you operate the division at a production and sales volume of 45.000 units or would you sublease? Support your answer with appropriate computations using Excel Note: you must show supporting schedules/calculations on the Excel worksheet