Question

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

Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 5%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $105 to purchase these supplies.

For years, Worley believed that the 5% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Worley 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 Activity
Customer deliveries (Number of deliveries) $ 630,000 7,000 deliveries
Manual order processing (Number of manual orders) 639,000 9,000 orders
Electronic order processing (Number of electronic orders) 322,000 14,000 orders
Line item picking (Number of line items picked) 697,500 450,000 line items
Other organization-sustaining costs (None) 670,000
Total selling and administrative expenses $ 2,958,500

Worley gathered the data below for two of the many hospitals that it serves—University and Memorial (each hospital purchased medical supplies that had cost Worley $34,000 to buy from manufacturers):

Activity

Activity Measure University Memorial
Number of deliveries 19 24
Number of manual orders 0 40
Number of electronic orders 19 0
Number of line items picked 160 300

Required:

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

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

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

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

Homework Answers

Answer #1

Answer is given below

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these...
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 8%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $108 to purchase these supplies. For years, Worley believed that the 8% markup covered its selling and...
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these...
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 6%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $106 to purchase these supplies. For years, Worley believed that the 6% markup covered its selling and...
Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these...
Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to dozens of hospitals. In the face of declining profits, Med Max decided to implement an activity-based costing system to improve its understanding of the costs incurred to serve each hospital. The company broke its selling and administrative expenses into four activities as shown below: Activity Cost Pool Activity Measure Total Cost Total Activity Customer deliveries Number of deliveries $ 280,000 4,000 deliveries...
Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these...
Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to dozens of hospitals. In the face of declining profits, Med Max decided to implement an activity-based costing system to improve its understanding of the costs incurred to serve each hospital. The company broke its selling and administrative expenses into four activities as shown below: Activity Cost Pool Activity Measure Total Cost Total Activity Customer deliveries Number of deliveries $ 495,900 5,700 deliveries...
Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these...
Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to dozens of hospitals. In the face of declining profits, Med Max decided to implement an activity-based costing system to improve its understanding of the costs incurred to serve each hospital. The company broke its selling and administrative expenses into four activities as shown below:   Activity Cost Pool Activity Measure Total Cost Total Activity   Customer deliveries Number of deliveries $ 439,900 5,300 deliveries...
For years, Worley believed that the 8% markup covered its selling and administrative expenses and provided...
For years, Worley believed that the 8% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Worley 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 Activity Customer deliveries (Number of deliveries) $ 510,000 6,000 deliveries Manual order processing (Number of manual orders)...
Assume a service company has implemented an activity-based costing system with five activities as shown below:...
Assume a service company has implemented an activity-based costing system with five activities as shown below: Activity Cost Pool (Activity Measure) Total Cost Total Activity Customer deliveries (Number of deliveries) $ 400,000 8,000 deliveries Manual order processing (Number of manual orders) $ 280,000 5,000 manual orders Electronic order processing (Number of electronic orders) $ 150,000 15,000 electronic orders Line item picking (Number of line items picked) $ 450,000 375,000 line items Other organization-sustaining costs (None) $ 300,000 The company serves...
Marvin’s Kitchen Supply delivers restaurant supplies throughout the city. The firm adds 10 percent to the...
Marvin’s Kitchen Supply delivers restaurant supplies throughout the city. The firm adds 10 percent to the cost of the supplies to cover the delivery cost. The delivery fee is meant to cover the cost of delivery. A consultant has analyzed the delivery service using activity-based costing methods and identified four activities. Data on these activities follow: Cost Driver Volume Activity Cost Driver Cost Driver Volume Processing order Number of orders $ 36,000 3,000 orders Loading truck Number of items 126,000...
Applying ABC Methods to Customer Profitability Analysis Bountiful Harvest Distribution delivers supplies to small grocers throughout...
Applying ABC Methods to Customer Profitability Analysis Bountiful Harvest Distribution delivers supplies to small grocers throughout the region. Bountiful currently allocates order and delivery service costs based on a percentage of total revenue. Estimated revenue for the year is $5.16 Million. A consultant has analyzed the order and delivery service costs and identified four activities. Data on these activities are: Activity Cost Driver Cost Driver Volume Process order number of orders $50,000 4,000 orders Load truck number of items $100,000...
Medassist Inc., a distributor of special pharmaceutical products, operates at capacity and has three main market...
Medassist Inc., a distributor of special pharmaceutical products, operates at capacity and has three main market (A. general supermarket chains B. drugstore chains C. mom-and-pop single-store pharmacies) segments. Rick Flair, the new controller of Medassist, reported the following data for 2017 General Mom-and- Supermarket Drugstore Pop Single Medassist 2017 Chains Chains Stores Medassist Revenues $3,710,000 $3,190,000 $1,978,000 $8,878,000 Cost of goods sold 3,610,000 2,995,000 1,804,000 8,409,000 Gross margin $100,000 $195,000 $174,000 469,000 Other operating costs 294,825 Operating income $174,175 For...