Get instant access to this case solution for only $19

Allied Office Products Case Solution

Solution Id Length Case Author Case Publisher
488 1756 Words (9 Pages) Agustinus Banu Mulyawan, Dian Ratnasari, Mediani Dyah Natalia, Rahmat Novie Yanto
This solution includes: A Word File A Word File and An Excel File An Excel File

‘Allied business products’ is offering commodity products to its customers by rooting their services on value added services motto. Currently, it has a traditional absorption costing system which allocates costs to all customers based on an overhead rate, ignoring the activity of customers. ‘Allied office products’ is considering introducing SBP pricing system. Based on the analysis, it is found that Allied should incorporate this system in the business as it will provide them with vital information on their customers. The analysis showed that ‘customer A’ is less loyal; however, it is comparatively profitable to the company. It is also recommended that Allied should implement ‘just in time’ inventory service.

Following questions are answered in this case study solution:

  1. Using the information in the text and in Exhibit 2, calculate "ABC" based services costs for the TFC business.

  2. Should TFC implement the SBP pricing system?

  3. What managerial advice do you have for allied about the Total Forms Control (TFC) business? How does Exhibit 6 relate to this question? 

21623406425.png
11623406425.png

Allied Office Products Case Analysis

1. Using the information in the text and in Exhibit 2, calculate "ABC" based services costs for the TFC business.

Any company that manufactures and sells products has the leverage of operating any relevant and legally compliant costing systems for its inventory. In order to find out the exact or accurate costs of products, 'Allied office products' wants to evaluate their costing system for ABC costing system. ABC costing stands for ‘activity based costing’. The traditional costing methods allocate the product cost based on the number of labor hours and purchased raw materials etc. On the contrast, the activity based costing tends to establish a relationship between the overall costs and overhead rate by utilizing the information related to the number of activities consumed by products. This is a more accurate costing system as compared with the traditional ‘absorption costing’ where a single overhead rate is used.

In order to find out the ABC based service costs for TFC business, first you should list the relevant activities and determine the total cost exploited by them. The following table depicts the costs of value added services as calculated by Tim and John.

Table 1: Cost of Value added Activities

Cost of Value added Activities

Activity

Cost ( in 000)

Storage

$1,550

Requisition Handling

$1,801

Basic Warehouse Stock

$761

“ Pick-Pack “ Activity

$734

Data Entry

$612

Desk top delivery

$250

The next step in the chain of calculations is the determination of level of activities and the rate or cost associated with them. The following table depicts the relevant activities and their cost or rate.

Table 2: Other Activities

Other Activities

Number of Cartons

$350,000

Requisitions

310000.00

Lines per Requisition

2.5

%age of lines requiring pick pack activity

90%

Cost of Capital

13%

Desk top Requests

8500

 

 

Now by capitalizing on this data, the ABC service costs for each value added activity can be calculated. Let’s start from storage charge.

Storage Charge

Based on the data pertaining to the storage cost and number of cartons, the storage charge or rate can be calculated as follows:

Table 3: Storage Charge

Storage Charge

Storage

$1,550,000

Number of Cartons

$350,000

Storage Charge

$4.43

Requisition Handling Charge

Requisition costs when divided by the number of requisitions, will yield requisition handling charge.

Table 4: Requisition Handling Charge

Requisition Handling Charge

Requisition Handling

$1,801,000

Requisitions

$310,000

Requisition Handling Charge

$5.81

Basic Warehouse stock selection charge

The overhead charge for this activity can be calculated by the following formula:

Table 5: Basic Warehouse stock selection charge

Basic Warehouse Stock Selection

Basic Warehouse Stock

$761,000

Requisitions

310000.00

Lines per Requisition

2.5

BWSS Cost

$0.98

Data Entry Charges

The formula for calculating data entry charges is as follows.

Table 6: Data Entry Charges

Data Entry Charges

Data Entry

$612,000

Requisitions

310000.00

Lines per Requisition

2.5

Data Entry Charges

$0.79

Charge for Pick pack activity

Charge of pick pack activity is calculated by utilizing the following formula:

Table 7: Charge for Pick pack activity

Charge for “pick-pack” Activity

“ Pick-Pack “ Activity

$734,000

Requisitions

310000.00

Lines per Requisition

2.5

%age of lines requiring

90%

pick pack activity

 

Charge for “pick-pack” Activity

$1.05

Desktop Delivery Charge

The charge for desktop delivery is calculated by dividing desktop costs by desktop requests.

Table 8: Desktop Delivery Charge

Charge for Desk Top Delivery

Desk top delivery

$250,000

Desk top Requests

8500

Charge for Desk Top Delivery 

$29.41

Using your new costing system, calculate distribution services costs for "Customer A" and "Customer B."

Before calculating the distribution costs for both customers, we need to find out the total costs associated with both of them. This can be accomplished by using the overhead charge or rate calculated in the first part. The total costs for 'customer A' are calculated as follows:

Get instant access to this case solution for only $19

Get Instant Access to This Case Solution for Only $19

Standard Price

$25

Save $6 on your purchase

-$6

Amount to Pay

$19

Different Requirements? Order a Custom Solution

Calculate the Price

Approximately ~ 1 page(s)

Total Price

$0

Get More Out of This

Our essay writing services are the best in the world. If you are in search of a professional essay writer, place your order on our website.

Essay Writing Service
whatsapp chat icon

Hi there !

We are here to help. Chat with us on WhatsApp for any queries.

close icon