please show work in excell thank you!

if job q included 30 units what was its unit product cost

Required information (The following information applies to the questions displayed below.) Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments-Molding and Fabrication. It started, completed, and sold only two jobs during March-Job P and Job Q. The following additional Information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month of March): Estimated total machine-hours used Estimated total fixed manufacturing overhead Estimated variable manufacturing overhead per machine-hour Molding 3,600 $ 14,400 $ 1.40 Fabrication 2,160 $ 21,600 $ 2.20 Total 5,760 $ 36,000 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total Job P Job $ 18,720 $ 11,520 $ 30,240 $ 10,800 2,440 1,150 860 1,310 3,300 2,460 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine-hours as the allocation base in both departments and Job P included 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 7. If Job Q included 30 units, what was its unit product cost? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)