Please answer as it like in excel spreadsheet to show work. Thanks in advance!

4. (30 points) Graf Company manufactures two products (XX and YY). The overhead costs ($204,000) have been divided into four cost pools that use the following activity drivers: Number Number of Machine Packing Product Setups Orders Hours Orders of XX YY 60 40 150 50 1,500 2,500 100 60 Cost per pool $36,000 $54,000 $50,000 $64,000 Required: Additionally, Graf incurred the following amounts of direct materials and direct labor on products M and N: XX YY Total Direct materials Direct labor Total $50,000 45,000 $95,000 $40,000 35,000 $75,000 $90,000 80,000 $170,000 Required: Determine the single plantwide factory overhead rate using machine hours as the allocation base. b. Determine the total overhead costs assigned individually to products XX and YY using the single plantwide factory overhead rate determined in part (a) above. c. Determine the activity rate for each activity. d. Determine the total activity (overhead) costs assigned products XX and YY using the activity rates found in part c. e. Determine the total product costs assigned to products XX and YY using the activity rates found in part c