answer it in excel

103, 5 5-17 Assigning activity-based costs in manufacturing, used capacity. income Halifax Brass Company manufactures pumps and valves and uses a time-driven activity-based cost (TDABC) system. Last year, Halifax recorded the following data for assigning manufacturing overhead costs to its products: Chapters Activity-Based Cost Systems 221 UNIT COST ESTIMATES RATES PER HOUR) TOTAL UNIT TIME ESTIMATES (HOURS ASSIGNED TO PRODUCTS) PRACTICAL CAPACITY NOT ASSIGNED TO PRODUCTS (HOURS) PUMS VALVES 1,500 1,800 Machine setups and run time Labor for setups, receiving and packing Engineering (for specializing products) $20.00 per machine hour $30.00 per labor hour $80,00 per engineering hour 5,000 ,000 400 2 00 Halifax also developed the following information on revenues and costs other than manufacturing overhead: Total revenues Total direct labor cost Total direct materials cost SG&A expenses $890,000 $120,000 $90,000 $100,000 Required (a) Using the company's TDABC system, how much manufacturing overhead cost will be assigned to pumps? How much will be assigned to valves? (b) What is the company's net income? (Assume the company sells the entire amount of the products it produces.)