Question
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
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
80,000 items
Deliver goods
number of orders
$60,000
4,000 orders
Process invoice
number of invoices
$48,000
6,000 invoices
Total overhead
$258,000
Three of Bountiful's customers are Rosy's Corner Market, Katy's Fine Foods, and Amy's City Market. Below are data on expected orders and deliveries to these three customers:
Rosy's
Katy's
Amy's
Revenue
$60,000
$90,000
$150,000
Cost of supplies sold
$48,000
$64,000
$120,000
Number of orders
50
300
25
Number of items
550
1,600
1,750
Number of invoices
12
600
18
Required:
1.Determine the gross profit (revenue less cost of supplies sold less cost of order and delivery service) for each of the three customers under the current allocation method.
2.Determine the gross profit (revenue less cost of supplies sold less cost of order and delivery service) for each of the three customers under the proposed ABC allocation method.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To solve this problem we will use the ActivityBased Costing ABC method to allocate the order and delivery service costs to the three customers 1 Deter...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