Activity-Based Costing, Unit Cost, Ending Work-in-Process Inventory

Salazar Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Salazar identified three overhead activities and related drivers. Budgeted information for the year is as follows:

Activity	Cost	Driver	Amount of Driver
Setting up design	$168,000	Setups	1,200
Purchasing	186,000	Number of parts	15,000
Other overhead	415,000	Direct labor hours	50,000

Salazar worked on five jobs in March. Data are as follows:

		Job 15		Job 16		Job 17		Job 18		Job 19
Balance, March 1		$34,600		$39,890		$24,090		$0		$0
Direct materials		$28,000		$37,900		$25,350		$11,000		$13,580
Direct labor		$10,000		$8,500		$23,000		$12,700		$8,000
Setups		20		14		35		8		15
Number of parts		150		180		200		500		300
Direct labor hours		650		580		1,600		870		520

By March 31, Jobs 15, 16, and 17 were completed and sold. The remaining jobs were in process.

Required:

1. Calculate the activity rates for each of the three overhead activities. If required, round your answers to the nearest cent.

Setup rate	$fill in the blank 266e87009fd4ffb_1 per set up
Purchasing rate	$fill in the blank 266e87009fd4ffb_2 per part
Other overhead rate	$fill in the blank 266e87009fd4ffb_3 per direct labor hour

2. Prepare job-order cost sheets for each job showing all costs through March 31. What is the cost of each job by the end of March?. If an amount is zero, enter "0".

Salazar Company
Job-Order Cost Sheets
	Job 15	Job 16	Job 17	Job 18	Job 19
Balance, March 1	$fill in the blank d977fb02dfbd04e_1	$fill in the blank d977fb02dfbd04e_2	$fill in the blank d977fb02dfbd04e_3	$fill in the blank d977fb02dfbd04e_4	$fill in the blank d977fb02dfbd04e_5
Direct materials	fill in the blank d977fb02dfbd04e_6	fill in the blank d977fb02dfbd04e_7	fill in the blank d977fb02dfbd04e_8	fill in the blank d977fb02dfbd04e_9	fill in the blank d977fb02dfbd04e_10
Direct labor	fill in the blank d977fb02dfbd04e_11	fill in the blank d977fb02dfbd04e_12	fill in the blank d977fb02dfbd04e_13	fill in the blank d977fb02dfbd04e_14	fill in the blank d977fb02dfbd04e_15
Applied overhead:
Setups	fill in the blank d977fb02dfbd04e_16	fill in the blank d977fb02dfbd04e_17	fill in the blank d977fb02dfbd04e_18	fill in the blank d977fb02dfbd04e_19	fill in the blank d977fb02dfbd04e_20
Purchasing	fill in the blank d977fb02dfbd04e_21	fill in the blank d977fb02dfbd04e_22	fill in the blank d977fb02dfbd04e_23	fill in the blank d977fb02dfbd04e_24	fill in the blank d977fb02dfbd04e_25
Other overhead	fill in the blank d977fb02dfbd04e_26	fill in the blank d977fb02dfbd04e_27	fill in the blank d977fb02dfbd04e_28	fill in the blank d977fb02dfbd04e_29	fill in the blank d977fb02dfbd04e_30
Total cost	$fill in the blank d977fb02dfbd04e_31	$fill in the blank d977fb02dfbd04e_32	$fill in the blank d977fb02dfbd04e_33	$fill in the blank d977fb02dfbd04e_34	$fill in the blank d977fb02dfbd04e_35

3. Calculate the balance in Work in Process on March 31. $fill in the blank c435acf84fde00b_1

4. Calculate the cost of goods sold for March. $fill in the blank c435acf84fde00b_2

Check My Work