Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers.

$\backslash$table$[[,$Jerry,,Kate$],[$Number of onders,Incorporated,Corpany$],[$Units per order,$6,30],[$Sales returns:,$1,$ bea,$420],[$Number of returns,$4,5],[$Total units returned,$50,140],[$Number of sales calls,$13,5]]$

Colleen sells its products at $$290$ per unit. The firm's gross margin ratio is $20\%.$ Both Jerry and Kate pay their accounts promptly and no accounts receivable is over $30$ days. After using business analytics software to carefuly analyze the operating data for the past $30$ months, the firm has determined the following activity costs:

$\backslash$table$[[$Activity$,],[$Sales calls,$$869$ per visit cost oriver and Rate$],[$Order processing,$189$ per order$],[$Deliveries$,410$ per order$],[$Sales returns,$279$ per return and $$3$ per unit returned$],[$Sales salary,$167,969$ per month$]]$

Required:

Using customers as the cost objects, classify the activity costs into cost categories $($unit$-$level, batch$-$level, etc.$)$ and compute the total cost for Colleen Company to service Jerry. Incorporated and Kate Company.

$2$ Compare the profitability of these two customers.

Complete this question by entering your answers in the tabs below.

Required $1$

Required $2$

Using customers as the cost objects, classify the activity costs into cost categories $($unit$-$level, batch$-$level, etc.$)$ and compute the total cost for Colleen Company to service Jerry, Incorporated and Kate Company.

$\backslash$table$[[,\backslash$table$[[$Jerry$,],[$Incorporated$]],$Kate Company$],[$Customer unit level costs:,,$],[$Cost of goods sold,,$],[$Customer batch level costs:,,$],[,,],[,,],[,,],[,,],[$Customer sustaining costs:,,$]]$