Question

HOW DO I CALCULATE?

Sara's Salsa Company produces its condiments in two types: Extra Fine for restaurant customers and Family Style for home use. Salsa is prepared in department 1 and packaged in department 2. The activities, overhead costs, and drivers associated with these two manufacturing processes and the company's production support activities follow. Process Department 1 Activity Mixing Cooking Product testing Quantity 1,000 1,000 600 Department 2 Machine calibration Labeling Defects Overhead cost Driver $ 4.600 Machine hours 10,500 Machine hours 112,600 Batches $ 127,700 $ 255,000 Production runs 12.500 Cases of output 7,000 Cases of output $ 274,500 $ 91,000 Focus groups 28,000 Machine hours 66.000 Container types $ 195,000 500 130,000 130,000 Support Recipe formulation Heat, lights, and water Materials handling 1,000 Additional production information about its two product lines follows. Units produced Batches Machine hours Focus groups Container types Production runs Extra Fine 21,000 cases 210 batches 300 MH 32 groups 7 containers 210 runs Family Style 109,000 cases 390 batches 700 MH 1B groups i containers 290 runs 4. Using ABC, compute the total cost per case for each product type if the direct labor and direct materials cost is $4 per case of Extra Fine and $3 per case of Family Style. (Round your intermediate calculations to 2 decimal places. Round "Activity Rate" and "Overhead cost per unit" answers to 2 decimal places.) Extra fine Family Style Activity Overhead Cost Activity Drivers Activity Rate Activity Drivers Overhead assigned Activity Drivers Overhead assigned Mixing & Cooking Product testing Machine calibration Labeling & Defects Recipe formulation Heat, light and water Material handling Extra fine Family Style

Answer 1

1)	Plantwide overhead rate
	Estimated overhead/total cases
	578250/120,000
	4.82
	plantwide overhead rate			$4.82	per case
				total cost per unit
2)	Extra Fine			10.82
	Family Style			9.82
3)	Extra Fine		profit	7.18
	Family Style		loss	-0.82
			(a)	(b)			c=a/b			Extra fine		e=c*d	Family style		g=c*f
			overhead	Avtivity Driver			Activity rate			Activity Drivers		overhead	Activity Drivers		overhead
4)	Activity		cost							(d)		assinged	(f)		assinged
	Mixing & cooking		15,100	1,000	machine hours		15.1	per machine hour		300		4530	700		10570
	product testing		112,600	600	Batches		187.6667	per batch		210		39410	390		73190
	Machine Calibration		255,000	500	production run		510	per production run		210		107100	290		147900
	Labeling & Defects		19,500	130,000	cases of output		0.15	per case		21000		3150	109,000		16350
	Recipe formulation		91,000	50	Focus groups		1820	per focus group		32		58240	18		32760
	heat,light and water		28,000	1,000	machine hours		28	per machine hour		300		8400	700		19600
	Material handling		66,000	8	container type		8250	per container type		7		57750	1		8250
			587,200							total OH cost assign		278580	total OH cost assign		308620
										total units produced		21,000	total units produced		109,000
										oh cost per unit		13.27	oh cost per unit		2.83
									Extra	Family
									fine	Style
						Direct materials & direct labor			4.00	3.00
						overhead			13.27	2.83
						tota cost/case			17.27	5.83
	5)	Extra Fine		loss	-2.27		(15-17.27)
		Family Style		profit	0.17		(6-5.83)