A B $$ D E $$ F G H I J K L M N $14$ nm n N O $682.3$ Use this spreadsheet to prepare solutions for the questions on the instructions file $5$ Jones$-$Pitt Company Income Statement by Branch: $7$ Division A Division B Division C Sales $2,400,0001,500,0001,700,0009$ Less: Cost of Goods Sold $10$ Unit$-$level Manufacturing Costs $(1,250,000)(620,000)(890,000)11$ Rent on Manufacturing Facility $(340,000)(320,000)(440,000)1213$ Gross Margin $810,000560,000370,00014$ Less: Operating Expenses $15$ Unit$-$Level Selling and Admin. Expenses $(90,000)(75,000)(150,000)16$ Division$-$Level Fixed Selling and Admin. Expenses $(160,000)(115,000)(240,000)17$ Administrative Facility$-$Level Costs $(90,000)(90,000)(90,000)1819$ Net Income $($loss$)470,000280,000(110,000)20($Note: no formulas have been used to present the data.$)2122$ Prepare your answers to parts a$,$ b and c on the spreadsheet below: $2324$