Also determine which costs are relative costs and which are not for the company

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 . The branch income statements are presented for the year 20X8; Branch (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,0001,710,000 Sales Less: Cost of Goods Sold :Unit-level Manufacturing Costs (1,100,000)(580,000) (900,000) Rent on Manufacturing 220,000)(450,000 240,000 660,000 800,000360,000 (60,000)(45,000)(150,000) (80,000) 380,000 550,000 (110,000) Facility Gross Margin Less: Operatingxenses Unit-Level Selling and Admin. Expenses Division-Level Fixed Selling and Admin. Expenses(140,000 Administrative Facility-Level Costs (125,000) (80,000) (240,000) (80,000) Net Income (loss) 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 b. 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.)