(a) Calculate the total profit for each of the product groups: (i) using the current absorption costing system; (ii) using the proposed activity-based costing system .(b) Explain how the information obtained from the activity-based costing system might be used by the management of the company and outline the circumstances under which an activitybased costing system would produce similar product costs to those produced using a traditional absorption costing system

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter5: Operating Activities: Purchases And Cash Payments
Section: Chapter Questions
Problem 2.7C
icon
Related questions
icon
Concept explainers
Topic Video
Question

A large company sells a range of electrical, clothing, and homeware products through a chain of department stores. The main administration functions are provided from the company’s head office. Each department store has its own warehouse which receives goods that are delivered from a central distribution centre. The company currently measures profitability by product group for each store using an absorption costing system. All overhead costs are charged to product groups based on sales revenue. Overhead costs account for approximately one-third of total costs and the directors are concerned about the arbitrary nature of the current method used to charge these costs to product groups. A consultant has been appointed to analyse the activities that are undertaken in the department stores and to establish an activity-based costing system. The consultant has identified the following data for the latest period for each of the product groups for the X town store in the image below:

(a) Calculate the total profit for each of the product groups:

(i) using the current absorption costing system;

(ii) using the proposed activity-based costing system

.(b) Explain how the information obtained from the activity-based costing system might be used by the management of the company and outline the circumstances under which an activitybased costing system would produce similar product costs to those produced using a traditional absorption costing system

 

Product group
Clothing
Electrical
Homeware
Sales revenue
€3600k
€2900k
€900k
Cost of sales
€2100k
€1700k
€400k
Number of deliveries
84
42
14
Number of pallets per delivery
Number of inventory items
40
10
4
11 000
4 000
3000
Number of customers
1600k
800k
210k
Number of requisitions
460
173
102
The consultant has also obtained the following information about the support activities:
Activity
Cost driver
Overheads $000
Customer service
Number of customers
750
Warehouse receiving
Number of pallets delivered
Number of requisitions
Number of inventory items
380
Warehouse issuing
190
In-store merchandizing
250
Central administration
Sales revenue
230
Transcribed Image Text:Product group Clothing Electrical Homeware Sales revenue €3600k €2900k €900k Cost of sales €2100k €1700k €400k Number of deliveries 84 42 14 Number of pallets per delivery Number of inventory items 40 10 4 11 000 4 000 3000 Number of customers 1600k 800k 210k Number of requisitions 460 173 102 The consultant has also obtained the following information about the support activities: Activity Cost driver Overheads $000 Customer service Number of customers 750 Warehouse receiving Number of pallets delivered Number of requisitions Number of inventory items 380 Warehouse issuing 190 In-store merchandizing 250 Central administration Sales revenue 230
Expert Solution
steps

Step by step

Solved in 3 steps

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
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage