Question

126%3 Comment Shape Media Ter Chart Tabler Inserts Add Categony Zoom View Chapter 2 Farm (O. Chapter 2: Applying Excel 3 Data 75% Markup on iob co Department Assembly Miling 60.000 8.00 $30,000 3000 Machine-hours 9Direct laborhours 10 Total fed manutacturing overhead cost 1Varible manufachuring overhead per machinehour 12 Vaatle manutachuing overhead per direct laborhour 80,000 s500 000 $2 00 $3.75 Depanment 4CoNt summary for Job 40 Assembly Ming 15 Machine-hours 17 Direct labor-hours 20 $370 $280 s00 18 Drect mateals 1Direct labor cos S70 20 2Erter a formua into each of the cells meked with a 7 below 23 23 Step 1: Calculate the estimated total manufacturing overhead cost for each departments 24 Assembly Miings 2s f manutacturing owerhead cos Vee manutactung overhead per machine-hour or drect laborbour 2 2 tal machinehours or direct laborhoaurs 2 Total vaable manulacturing overhead 2Total manuacturng overhead 30 aStep 2 Calculate the predetermined everhead rate in each degeartment Assembly Ming 3 Total manutacturing overhead 34Totel machine-hours or drect labor-hours Pedelemmined ovehead rte per machnehour or direct lsbor-hous Step 3 Calculate the amount of overhead spplied from both departments to Job 40 Ming Assembly Predtemined overheat te cer machine-hour or drect labor-hour 40 Machinetours or drec abor hours for the job MacBook Air esc A S % 6 5 4 3 2

Answer 1

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
Step 1
		Milling	Assembly
Total Fixed Manufacturing Overhead Cost	a	$ 390,000	$ 500,000
Variable Manufacturing overhead per MH or DLH	b	$       2.00	$       3.75
Total Machiner Hours or Direct Labor Hours	c	60,000	80,000
Total Variable Manufacturing Overhead	b*c=d	$ 120,000	$ 300,000
Total Manufacturing Overhead	a+d=e	$ 510,000	$ 800,000
Step 2
Total Manufacturing Overhead		$ 510,000	$ 800,000
Total Machiner Hours or Direct Labor Hours		60,000	80,000
Predetermined Overhead Rate per MH/DLH		$       8.50	$     10.00
Step 3
Predetermined Overhead Rate per MH/DLH		$       8.50	$     10.00
Machiner Hour or Direct Labor hour for Job		90	20
Manufacturing Overhead Applied		$        765	$        200
Step 4
		Milling	Assembly	Total
Direct Material		$        800	$        370	$     1,170
Direct Labor		$          70	$        280	$         350
Manufacturing Overhead Applied		$        765	$        200	$         965
Total cost of Job 407		$     1,635	$        850	$     2,485
Step 5
Total cost of Job 407				$2,485.00
Markup 75%				$1,863.75
Selling price of Job 407				$4,348.75