Customer Profitability Analysis Gonalong, Inc. has 10 customers that account for all of its $4,430,000 of net income. Its activity-based costing system is able to assign all costs, except for $650,000 of general administrative costs, to key activities incurred in connection with serving its customers. A customer profitability analysis based on activity costing produced the following customer profits and losses:

Traditional Product Costing versus Activity-Based Costing Assume that Panasonic Company has determined its estimated total manufacturing overhead cost for one of its plants to be $1,591,000, consisting of the following activity cost pools for the current month:

Activity Centers	Activity Costs	Cost Drivers	Activity Level
Assembly setups	$ 330,000	Setup hours	2,000
Materials handing	162,000	Number of moves	600
Assembly	900,000	Assembly hours	18,000
Maintenance	199,000	Maintenance hours	1,990
Total	$1,591,000

Total direct labor hours used during the month were 14,800. Panasonic produces many different electronic products, including the following two products produced during the current month:

	Model X301	Model Z205
Units produced	3,500	3,500
Direct materials costs	$34,000	$34,000
Direct labor costs	$29,000	$29,000
Direct labor hours	700	700
Setup hours	60	120
Materials moves	30	60
Assembly hours	900	900
Maintenance hours	20	80

Required a. Calculate the total per-unit cost of each model using direct labor hours to assign manufacturing overhead to products. Round answers for unit cost to two decimal places, if applicable.

	X301	Z205
Direct materials	Answer	Answer
Direct labor	Answer	Answer
Overhead	Answer	Answer
Total cost	Answer	Answer
Units	Answer	Answer
Unit cost	Answer	Answer

b. Calculate the total per-unit cost of each model using activity-based costing to assign manufacturing overhead to products. Round answers for unit cost to two decimal places, if applicable.

	X301	Z205
Total direct materials costs	Answer	Answer
Total direct labor costs	Answer	Answer
Overhead costs:
Assembly setup	Answer	Answer
Materials handling	Answer	Answer
Assembly	Answer	Answer
Maintenance	Answer	Answer
Total costs	Answer	Answer
Units produced	Answer	Answer
Unit cost	Answer	Answer

Prepare a customer profitability profile like the one in Exhibit 6.3. The following link includes an Excel worksheet to create the profitability profile graph: profitability_profile_template.

Using the customer profitability analysis provided in the exercise to calculate the following profits. (i) Calculate the total profits from the 3 most profitable customers $Answer

(ii) Calculate the total profits for the 5 most profitable customers $Answer (iii) Calculate the total profits for the 8 most profitable customers $Answer (iv) Calculate the total profits for the 9 most profitable customers $Answer