Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
Kramer Office Supplies offers a number of different products to its customers
Kramer Office Supplies offers a number of different products to its customers. It currently allocates its ordering and delivery costs to its residential and business customer groups on the basis of order value. However, the company has recently decided to implement activity-based costing starting in 2022 to assign these costs to customers. Key data for 2021 are as follows:
ActivityActivity
CostActivity BaseActivity
Volume
ResidentialActivity
Volume
BusinessTotal
Activity
VolumeSales (order value) $3,580,000 $2,930,000 $6,510,000 Order processing$954,000 No. of orders 6,010 2,290 8,300 Generating sales 759,000 No. of sales calls 1,700 4,100 5,800 Sales follow-up 819,000 No. of follow-ups 102 408 510 Processing change orders 58,000 No. of change orders 190 220 410 Delivery 1,272,383 No. of deliveries 5,960 4,440 10,400 Total$3,862,383
Kramer has 1,990 residential customers and 510 business customers.
Required:
1. Compute the cost per customer for residential and business customers for 2021, using the current system of cost allocation. (Do not round intermediate calculations. Round "Cost per customer" to 2 decimal places and the rest to the nearest whole dollar amount.)
2. Assume that the 2021 data will hold for 2022. Compute the cost per customer for residential and business customers for 2022 using the proposed system of cost allocation. In doing so, calculate the overhead allocation rate for each activity, and use these rates to assign costs to the two customer groups. (Round your intermediate calculations and final answers to 2 decimal places.)
3.
This part of the question is not part of your Connect assignment.
Expert Solution
| Solution to Requirement 1 | |||||
| Computation of Cost per Customer | |||||
| Particulars | Amount | Residential Customer | Business Customer | ||
| Total Cost to be allocated | $3,862,383 | ||||
| Sales Order Value | $6,510,000 | $3,580,000 | $2,930,000 | ||
| Cost Allocated on the Basis of Sales Order Value (A) | $3,862,383 | 2124014 | 1738369 | ||
| [$3,862,383 * $3,580,000 / $6,510,000] | [$3,862,383 * $2,930,000 / $6,510,000] | ||||
| Number of Customer (B) | 2,500 | 1,990 | 510 | ||
| Cost per Customer (A / B) | $1,067.34 | $3,408.57 | |||
| Solution to Requirement 2 | |||||
| Computation for Allocation of Cost and Cost per Customer | |||||
| Particulars | Basis of Allocation | Ratio | Cost to be Allocated | Residential Customer | Business Customer |
| Order Processing | No. of Orders | 6010:2290 | $954,000 | 690787.9518 | 263212.0482 |
| Generating Sales | No. of Sales Call | 1700:4100 | $759,000 | $222,466 | $536,534 |
| Sales Follow Up | No. of Follow Ups | 102:408 | $819,000 | $163,800 | $655,200 |
| Processing Change Order | No. of Change Order | 190:220 | $58,000 | $26,878 | $31,122 |
| Delivery | No. of Deliveries | 5960:4440 | $1,272,383 | $729,173 | $543,210 |
| Cost Allocated (A) | $1,833,105 | $2,029,278 | |||
| Number of Customer (B) | 1,990 | 510 | |||
| Cost per Customer (A/B) | $921.16 | $3,978.98 |
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





