Requirements: 1. Based on the activity cost and volume data, determine the amount of cost assigned to the following customers, whose goods were all received on the first day of last month.

CONCEPTS IN FED.TAX.,2020-W/ACCESS
20th Edition
ISBN:9780357110362
Author:Murphy
Publisher:Murphy
Chapter16: Tax Research
Section: Chapter Questions
Problem 64DNC
icon
Related questions
icon
Concept explainers
Topic Video
Question
Joshua owns a commercial cold storage warehouse that has 100,000 cubic feet of storage capacity.
Historically, he has charged customers a flat rate of PO.08 per kilo per month for goods stored.
In the past two years, Joshua 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, Joshua asked his accountant, Daniel to improve her understanding of how activity based
costing could help him revise the pricing formula. Daniel has determined that most costs can be
associated with one of four activities. Those activities and their related costs, volume measures, and
volume levels for 2018 follow:
Activity
Cost
Monthly Volume Measure
Send/receive goods
P 25,000
Weight in kilos - 500,000
Store goods
8,000
Volume in cubic feet - 80,000
Move goods
10,000
Volume in square feet - 5,000
Identify goods
4,000
Number of packages 500
Requirements:
1. Based on the activity cost and volume data, determine the amount of cost assigned to the
following customers, whose goods were all received on the first day of last month.
Customer
Weight of Order
Cubic Feet
Square Feet
Number of
in Kilos
Packages
Kathryn
40,000
3,000
300
Ria
40,000
2,000
200
20
Gabbi
40,000
1,000
1,000
80
2. Determine the price to be charged using Activity Based Costing ( ABC ), assuming the price is
based on the cost determined in item 1 plus a markup of 30 percent.
Transcribed Image Text:Joshua owns a commercial cold storage warehouse that has 100,000 cubic feet of storage capacity. Historically, he has charged customers a flat rate of PO.08 per kilo per month for goods stored. In the past two years, Joshua 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, Joshua asked his accountant, Daniel to improve her understanding of how activity based costing could help him revise the pricing formula. Daniel has determined that most costs can be associated with one of four activities. Those activities and their related costs, volume measures, and volume levels for 2018 follow: Activity Cost Monthly Volume Measure Send/receive goods P 25,000 Weight in kilos - 500,000 Store goods 8,000 Volume in cubic feet - 80,000 Move goods 10,000 Volume in square feet - 5,000 Identify goods 4,000 Number of packages 500 Requirements: 1. Based on the activity cost and volume data, determine the amount of cost assigned to the following customers, whose goods were all received on the first day of last month. Customer Weight of Order Cubic Feet Square Feet Number of in Kilos Packages Kathryn 40,000 3,000 300 Ria 40,000 2,000 200 20 Gabbi 40,000 1,000 1,000 80 2. Determine the price to be charged using Activity Based Costing ( ABC ), assuming the price is based on the cost determined in item 1 plus a markup of 30 percent.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L