Identify the relevant and irrelevant costs as well

Each branch (division) operates its own facility. The administative offices are located in a separate building and the Administrative-Facility Level Costs are allocated among X. Y and Z The branch income statements are presented for the year 20X8Branch (Division) Z has experienced a Net Loss Branch Z has suffered losses in recent years and the company expects Z to continue to operate at a loss Here are the data: (Note: no formulas have been used to present the data) Division Division Division 2,000,000 1,600,000 1,710,000 Sales Less: Cost of Goods Sold Unit-level Manufacturing Costs Rent on Manufacturing Facility 1,100,000)(580,000)900,000) 240 220 Gross Margin Less: Operating Expenses 660,000800,000 360,000 Unit-Level Selling and Admin. Expenses (60,000) 45,000)150,000) Division-Level Fixed Selling and Admin. Expenses140,000) (125,000)(240,000) Administrative Facility-Level Costs (80,000) (80,000) (80,000) Net Income (loss) 380,000550,000 (110,000 a. Based on the information above, recommend whether Division Z should be eliminated Support your answer by preparing companywide income statements-one with Division Z and one without Division Z. Use the Excel spreadsheet we have included in the folder with the instructions During 20X8, Division Z produced and sold 30,000 units of product. Would your recommendation in part a change if sales and production increase to 45,000 units in 2009? Support your answer by comparing differential revenue and avoidable cost for Division Z, assuming that 45,000 units are sold. Use the same Excel spreadsheet as you used in part a (above c. Suppose that the company could sublease Division Z's 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! (Again, use the same Excel spreadsheet as used in parts a & b above.) Also determine which costs are relative costs and which are not for the company