Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departmentsMolding and Fabrication. It started, completed, and sold only two jobs during MarchJob 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):

	Molding			Fabrication			Total
Estimated total machine-hours used		4,100			2,460			6,560
Estimated total fixed manufacturing overhead	$	16,400		$	24,600		$	41,000
Estimated variable manufacturing overhead per machine-hour	$	1.40		$	2.20

	Job P			Job Q
Direct materials	$	21,320		$	13,120
Direct labor cost	$	34,440		$	12,300
Actual machine-hours used:
Molding		2,820			1,310
Fabrication		980			1,450
Total		3,800			2,760

Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month

Required: For questions 1-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-15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base.

rev: 06_03_2020_QC_CS-214320

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.)

8. Assume that Sweeten Company used cost-plus pricing (and a markup percentage of 80% of total manufacturing cost) to establish selling prices for all of its jobs. What selling price would the company have established for Jobs P and Q? What are the selling prices for both jobs when stated on a per unit basis? (Do not round intermediate calculations. Round your final answers to nearest whole dollar.)

9. What was Sweeten Companys cost of goods sold for March? (Do not round intermediate calculations.)

10. What was the companys plantwide predetermined overhead rate? (Round your answer to 2 decimal places.)

11. How much manufacturing overhead was applied to Job P and how much was applied to Job Q? (Do not round intermediate calculations.)

12. If Job P included 20 units, what was its unit product cost? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)

13. 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.)

14. Assume that Sweeten Company used cost-plus pricing (and a markup percentage of 80% of total manufacturing cost) to establish selling prices for all of its jobs. What selling price would the company have established for Jobs P and Q? What are the selling prices for both jobs when stated on a per unit basis? (Do not round intermediate calculations. Round your final answers to nearest whole dollar.)

15. What was Sweeten Companys cost of goods sold for March? (Do not round intermediate calculations.)

Please use excel and show how you did it thank you