External Linkages, Customer Costing, Customer Profitability Emery Company sells small machine parts to heavy equipment manufacturers for an average price of $2.20 per part. There are two types of customers: those who place small, frequent orders and those who place larger, less frequent orders. Each time an order is placed and processed, a setup is required. Scheduling is also needed to coordinate the many different orders that come in and place demands on the plant's manufacturing resources. Emery also inspects a sample of the products each time a batch is produced to ensure that the customer's specifications have been met. Inspection takes essentially the same time regardless of the type of part being produced. Emery's Cost Accounting Department has provided the following budgeted data for customer-related activities and costs (the amounts expected for the coming year): Frequently Ordering Less Frequently Customers Ordering Customers Sales orders 32,000 3,200 Average order size 3,200 32,000 Number of setups 37,250 5.250 Scheduling hours 47,750 5,250 Inspections 37,250 5,250 Average unit cost $1.2 $1.2 *This cost does not include the cost of the following customer-related activites: Customer-related activity costs: Processing sales orders Scheduling production Setting up equipment Inspecting batches $1,760,000 795,000 2,550,000 3,400,000 $8,505,000 Total Required: 1. Assign the customer-related activity costs to each category of customers in proportion to the sales revenue earned by each customer type. Sales revenue Customer-related activity costs Calculate the profitability of each customer type. (Because sales revenues for each customer type are equal, the profitability will be the same for each customer type.) 2. Assign the customer-related activity costs to each customer type using activity rates. Enter the appropriate activity rates below. Processing sales orders per order Scheduling production per scheduling hour Setting up equipment per setup Inspecting batches per inspection Calculate the profitability of each customer category. Customer Profitability Frequent Infrequent External Linkages, Customer Costing, Customer Profitability Emery Company sells small machine parts to heavy equipment manufacturers for an average price of $2.20 per part. There are two types of customers: those who place small, frequent orders and those who place larger, less frequent orders. Each time an order is placed and processed, a setup is required. Scheduling is also needed to coordinate the many different orders that come in and place demands on the plant's manufacturing resources. Emery also inspects a sample of the products each time a batch is produced to ensure that the customer's specifications have been met. Inspection takes essentially the same time regardless of the type of part being produced. Emery's Cost Accounting Department has provided the following budgeted data for customer-related activities and costs (the amounts expected for the coming year): Frequently Ordering Less Frequently Customers Ordering Customers Sales orders 32,000 3,200 Average order size 3,200 32,000 Number of setups 37,250 5.250 Scheduling hours 47,750 5,250 Inspections 37,250 5,250 Average unit cost $1.2 $1.2 *This cost does not include the cost of the following customer-related activites: Customer-related activity costs: Processing sales orders Scheduling production Setting up equipment Inspecting batches $1,760,000 795,000 2,550,000 3,400,000 $8,505,000 Total Required: 1. Assign the customer-related activity costs to each category of customers in proportion to the sales revenue earned by each customer type. Sales revenue Customer-related activity costs Calculate the profitability of each customer type. (Because sales revenues for each customer type are equal, the profitability will be the same for each customer type.) 2. Assign the customer-related activity costs to each customer type using activity rates. Enter the appropriate activity rates below. Processing sales orders per order Scheduling production per scheduling hour Setting up equipment per setup Inspecting batches per inspection Calculate the profitability of each customer category. Customer Profitability Frequent Infrequent