Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Kramer Office Supplies offers a number of different products to its customers

Kramer Office Supplies offers a number of different products to its customers

Economics

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.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

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