Pahros Company buys surgical supplies from a variety of manufacturers and the resells and delivers these supplies to hundreds of hospitals. Cleanwater sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 5%. For years the company believed that 5% mark-up covered its selling and administrative expenses and provided reasonable profit. However, in the face of declining profits, the company decided to implement 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 below: Activity Cost Pool Activity Driver Total Cost Total Activity Customer Deliveries Number of Deliveries $ 500,000 5,000 deliveries Manual order processing Number of manual orders $ 248,000 4,000 orders Electronic order processing Number of electronic orders $ 200,000 12,500 orders Line item picking Number of Line item picked $ 450,000 450,000 line items Other organization - sustaining cost None $ 602,000 Total selling and administrative expense $ 2,000,000 The company gathered the data below for two of the many hospitals that it serves – University and Memorial. Sales revenue generated from University Hospital is $15,000 and from Memorial Hospital $16,000. Activity Driver University Memorial Number of deliveries 10 25 Number of manual orders 0 30 Number of electronic orders 15 0 Number of line item picked 120 250 Required: How much is the customer margin generated by each of the two hospitals. Give your analysis based on your result. Describe the purchasing behaviours that are likely to characterize the least profitable customers. Give your recommendation to the management regarding these two customers in the future. Give your recommendation to the management to be able to increase the profitability of the company’s business.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter2: Building Blocks Of Managerial Accounting

Section: Chapter Questions

Problem 4EB: Roper Furniture manufactures office furniture and tracks cost data across their process. The...

See similar textbooks

Related questions

Question

Pahros Company buys surgical supplies from a variety of manufacturers and the resells and delivers these supplies to hundreds of hospitals. Cleanwater sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 5%. For years the company believed that 5% mark-up covered its selling and administrative expenses and provided reasonable profit. However, in the face of declining profits, the company decided to implement 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 below:

Activity Cost Pool	Activity Driver	Total Cost	Total Activity
Customer Deliveries	Number of Deliveries	$ 500,000	5,000 deliveries
Manual order processing	Number of manual orders	$ 248,000	4,000 orders
Electronic order processing	Number of electronic orders	$ 200,000	12,500 orders
Line item picking	Number of Line item picked	$ 450,000	450,000 line items
Other organization - sustaining cost	None	$ 602,000
Total selling and administrative expense		$ 2,000,000

The company gathered the data below for two of the many hospitals that it serves – University and Memorial. Sales revenue generated from University Hospital is $15,000 and from Memorial Hospital $16,000.

Activity Driver	University	Memorial
Number of deliveries	10	25
Number of manual orders	0	30
Number of electronic orders	15	0
Number of line item picked	120	250

Required:

How much is the customer margin generated by each of the two hospitals. Give your analysis based on your result.
Describe the purchasing behaviours that are likely to characterize the least profitable customers.
Give your recommendation to the management regarding these two customers in the future.
Give your recommendation to the management to be able to increase the profitability of the company’s business.

Expert Solution

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions