Question

Cale Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Cale sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 7%. For example, if a hospital buys supplies from Cale that cost Cale $100 to buy from manufacturers, Cale would charge the hospital $107 to purchase these supplies.For years, Cale believed that the 7% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Cale decided to implement an activity-based costing system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown:Activity Cost Pool (Activity Measure) Total Cost Total ActivityCustomer deliveries (Number of deliveries) $420,000 5,000 deliveriesManual order processing (Number of manual orders) 624,000 8,000 ordersElectronic order processing (Number of electronic orders)170,000 10,000 ordersLine item picking (Number of line items picked) 675,000 450,000 line itemsOther organization-sustaining costs (None) 650,000 Total selling and administrative expenses $2,539,000 Cale gathered the data below for two of the many hospitals that it serves—Georgetown and Providence (each hospital purchased medical supplies that had cost Cale $38,000 to buy from manufacturers): ActivityActivity Measure University Memorial Number of deliveries 16 28Number of manual orders 0 49Number of electronic orders 18 0Number of line items picked 190 210Required:1. Compute the total revenue that Cale would receive from Georgetown and Providence.2. Compute the activity rate for each activity cost pool.3. Compute the total activity costs that would be assigned to Georgetown and Providence.4. Compute Cale's customer margin for Georgetown and Providence.

Answer 1

1. Calculation of total revenue

Total revenue = cost of goods sold + Markup 7% = Revenue

University = 38000 + 2660 = 40660

Memorial = 38000 + 2660 = 40660

Therefore, markup = cost of goods sold x market up

= 38000 x 7%

= 2660

2. Calculations of Activity rates

Activity rate = activity cost pool / total activity = activity rate

Customer deliveries = 420000 / 5000 = 84

Manual order processing = 624000 / 8000 = 78

Ele order processing = 170000 / 10000 = 17

Line time picking = 675000 / 450000 = 1.5

3. Calculations of Activity costs

Activity cost for University

Activity cost pool = Activity x Activity rate

Customer deliveries = 16 x 84 = 1344

Manual order processing = 0 x 78 = 0

Ele order processing = 18 x 17 = 306

Line time picking = 190 x 1.5 = 285

Total activity cost = 1935

Activity cost for Memorial

Activity cost pool = Activity x Activity rate

Customer deliveries = 28 x 84 = 2352

Manual order processing = 49 x 78 = 3822

Ele order processing = 0 x 17 = 0

Line time picking = 210 x 1.5 = 315

Total activity cost = 6489

4. Calculation of Customer margin

University Memorial

Sales revenue 40660 40660

Less : Cost of goods sold 38000 38000

Gross Margin 2660 2660

Less : Activity cost 1935 6489

Customer Margin 725 -3829