Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercise 7 - 1 0 ( Algo ) Customer Profitability Analysis [ LO 7 - 3 , LO 7 - 4 , LO 7 -
Exercise Algo Customer Profitability Analysis LO LO LO
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 For example, if a hospital buys supplies from Worley that cost Worley $ to buy from manufacturers, Worley would charge the hospital $ to purchase these supplies.
For years, Worley believed the markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Worley decided to implement an activitybased costing system to improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown:
tableActivity Cost Pool Activity MeasureTotal Cost,Total ActivitytableCustomer deliveries Number ofdeliveries$ deliveriestableManual order processing Number of manualorders orderstableElectronic order processing Number ofelectronic orders orderstableLine item picking Number of line itemspicked line itemstableOther organizationsustaining costsNoneTotal selling and a
Worley gathered the data below for two of the many hospitals it servesUniversity and Memorial each hospital purchased medical supplies that cost Worley $ to buy from manufacturers:
tableActivityActivity Measure,Number of deliveries,Number of manual orders,tableNumber of electronicorderstableNumber of line itemspicked
Required:
Compute the total revenue Worley would receive from University and Memorial.
Compute the activity rate for each activity cost pool.
Compute the total activity costs assigned to University and Memorial.
Compute Worley's customer margin for University and Memorial. Hint Do not overlook the $ cost of goods sold that Worley incurred serving each hospital.
Complete this question by entering your answers in the tabs below.
tableRequiredRequired,Required,Required
Compute the total revenue Worley would receive from University and Memorial.
tabletableTotalRevenueUniversityMemorial
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started