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

Free

50.1K

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 10%. Forexample, if a hospital buys supplies from Worley that cost Worley$100 to buy from manufacturers, Worley would charge the hospital$110 to purchase these supplies.

For years, Worley believed that the 10% 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 Cost Pool (Activity Measure)Total CostTotal Activity
Customer deliveries (Number of deliveries)$616,0007,000deliveries
Manual order processing (Number of manual orders)365,0005,000orders
Electronic order processing (Number of electronic orders)364,00014,000orders
Line item picking (Number of line items picked)875,000500,000line items
Other organization-sustaining costs (None)660,000
Total selling and administrative expenses$2,880,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 $39,000 to buy frommanufacturers):

Activity

Activity MeasureUniversityMemorial
Number of deliveries1020
Number of manual orders045
Number of electronic orders150
Number of line items picked130200

Required:

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

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

Answer & Explanation Solved by verified expert
4.1 Ratings (843 Votes)

Req 1.
Revenues
University Memorial
Cost of supplies 39000 39000
Add: markup @10% 3900 3900
Revenues 42900 42900
Req 2.
STATEMENT SHOWING ACTIVITY RATE OF ACTIVITY POOL
Activity Total Expected Activity
ACTIVITY COST POOL Measures Overheads Activity Rate
Customer deliveries Deliveries 616000 7000 88.00
Manual order processing Order 365,000 5,000 73.00
Electronic prder processing Orders 364,000 14,000 26.00
Line item picking Line items 875000 500000 1.75
Activity cost
Activity      Rate University Memorial
Activity OH Activity OH
Customer deliveries 88 10 880 20 1760
Manual order processing 73 0 0 45 3285
Electronic prder processing 26 15 390 0 0
Line item picking 1.75 130 227.5 200 350
Total Activity cost 1497.5 5395
Req 4.
Customer Margin
University Memorial
Revenue 42900 42900
Less: Cost of supplies 39000 39000
Less: Activity cost 1498 5395
Customer margin 2403 -1495

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