Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these...

Free

80.2K

Verified Solution

Question

Accounting

Worley Company buys surgical supplies from a variety ofmanufacturers and then resells and delivers these supplies tohundreds of hospitals. Worley sets its prices for all hospitals bymarking up its cost of goods sold to those hospitals by 9%. Forexample, if a hospital buys supplies from Worley that cost Worley$100 to buy from manufacturers, Worley would charge the hospital$109 to purchase these supplies.

For years, Worley believed that the 9% markup covered itsselling and administrative expenses and provided a reasonableprofit. However, in the face of declining profits, Worley decidedto implement an activity-based costing system to help improve itsunderstanding of customer profitability. The company broke itsselling and administrative expenses into five activities asshown:

Activity CostPool (Activity Measure)Total CostTotal Activity
Customer deliveries (Number of deliveries)$516,0006,000deliveries
Manual orderprocessing (Number of manual orders)420,0006,000orders
Electronic orderprocessing (Number of electronic orders)220,00011,000orders
Line itempicking (Number of line items picked)1,081,000460,000line items
Otherorganization-sustaining costs (None)620,000
Total sellingand administrative expenses$2,857,000

Worley gathered the data below for two of the many hospitalsthat it serves—University and Memorial (each hospital purchasedmedical supplies that had cost Worley $33,000 to buy frommanufacturers):

Activity

ActivityMeasureUniversityMemorial
Number ofdeliveries1922
Number of manualorders047
Number ofelectronic orders160
Number of lineitems picked110290

Required:

1. Compute the total revenue that Worley would receive fromUniversity and Memorial.

2. Compute the activity rate for each activity cost pool.

3. Compute the total activity costs that would be assigned toUniversity and Memorial.

4. Compute Worley’s customer margin for University and Memorial.(Hint: Do not overlook the $33,000 cost of goods sold thatWorley incurred serving each hospital.)

Answer & Explanation Solved by verified expert
4.3 Ratings (569 Votes)

Req 1.
Revenues
University Memorial
Cost of supplies 33000 33000
Add: markup @9% 2970 2970
Revenues 35970 35970
Req 2.
STATEMENT SHOWING ACTIVITY RATE OF ACTIVITY POOL
Activity Total Expected Activity
ACTIVITY COST POOL Measures Overheads Activity Rate
Customer deliveries Deliveries 516000 6000 86.00
Manual order processing Order 420,000 6,000 70.00
Electronic prder processing Orders 220,000 11,000 20.00
Line item picking Line items 1081000 460000 2.35
Activity cost
Activity      Rate University Memorial
Activity OH Activity OH
Customer deliveries 86 19 1634 22 1892
Manual order processing 70 0 0 47 3290
Electronic prder processing 20 16 320 0 0
Line item picking 2.35 110 258.5 290 681.5
Total Activity cost 2212.5 5863.5
Req 4.
Customer Margin
University Memorial
Revenue 35970 35970
Less: Cost of supplies 33000 33000
Less: Activity cost 2213 5863.5
Cusotmer margin 757.5 -2893.5

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students