Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Paul Seto owns and manages a commercial storage warehouse. He stores a vast variety of perishable goods for his customers. Under the existing pricing policy,

 Paul Seto owns and manages a commercial storage warehouse. He stores a vast variety of perishable goods for his customers. Under the existing pricing policy, he has charged customers using a flat rate of $2.40 per kilogram per month for goods stored. His storage warehouse has 10,000 cubic metres of storage capacity.

In the past two years, Seto has become dissatisfied with the profitability of the warehouse operation. Despite the fact that the warehouse remains relatively full, revenues have not kept pace with operating costs. Recently, Seto approached his accountant, Albert Lo, about using activity-based costing (ABC) to improve his understanding of the causes of costs and revise the pricing formula. Lo has determined that most costs can be associated with one of four activities. Those activities and their related monthly costs, volume measures, and volume levels for 2020 are as follows:

Activity Cost Monthly Volume Measure

Send/receive goods $80,000 Weight in kilograms - 50,000

Store goods $8,000 Volume in cubic metres - 800

Move goods $10,000 Volume in square metres - 500

Identify goods $3,000 Number of packages - 500

Lo has also collected last month's information on the following 3 customers whose goods were all received on the first day of last month.

Customers Weight of Order (Kilograms) Cubic Metres Square Metres Number of Packages

Sunshine Co. 20,000 600 30 10

Best Buy Co. 20,000 400 20 40

Chow's Trading 20,000 200 100 160

Seto would like Lo to perform some analyses based on the above information and data in order to evaluate whether to use ABC

a. Determine the price to be charged to each of the 3 customers under the existing pricing policy.

b. Based on the monthly activity cost and volume data provided, determine the amount of costs assigned to each of the 3 customers.

c. Determine the price to be charged to each of the 3 customers using activity-based costing (ABC), assuming Seto would base the price on the cost determined in part (b) plus a markup of 40 percent.

d. Critically discuss whether Seto's existing pricing policy captures the costs incurred to provide the warehouse services.

e. A cost hierarchy categorizes costs into different cost pools on the basis of the different types of cost drivers or cost-allocation bases. Describe the four levels of a manufacturing cost hierarchy under the ABC system with regard to Seto's storage warehouse.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

a To determine the price to be charged to each of the 3 customers under the existing pricing policy we will use the flat rate of 240 per kilogram per month Customer Sunshine Co Total Price Weight of O... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools for business decision making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

6th Edition

978-1119191674, 047053477X, 111919167X, 978-0470534779

More Books

Students also viewed these Accounting questions