Family Food Distributor (FFD) distributes products to grocery stores. The company began operation sixth months ago with...
Family Food Distributor (FFD) distributes products to grocery stores. The company began operation sixth months ago with three major customers: Seven Eleven, Family Mart and Wellcome. For the latest month, FFD has the following customer profitability report:
|
Seven |
Family |
|||
|
Eleven |
Mart |
Wellcome |
Total |
|
|
Revenues |
$45,000 |
$63,000 |
$52,000 |
$160,000 |
|
Costs of goods sold |
31,500 |
44,100 |
36,400 |
112,000 |
|
Gross profit |
13,500 |
18,900 |
15,600 |
48,000 |
|
Store support |
15,000 |
15,000 |
15,000 |
45,000 |
|
Customer profit margin |
(1,500) |
3,900 |
600 |
$3,000 |
The store support costs totaling $45,000 were equally allocated to each customer.
Similar monthly results have been reported since the first month in operation. Connie Chang, the president of FFD, has been wondering about the report above. She is not convinced that the amount of customer profit margin as shown on the report was accurately calculated. Particularly, she feels that charging store support cost equally to each customer does not present an accurate picture of customer profitability.
At a recent seminar on management, Connie learned about ABC (activity-based costing) and thought this new accounting measurement technique might give her a better picture of the company’s profitability. Consequently, she directed the company’s controller to conduct an ABC analysis on store support costs. After a few weeks of long working hours, the controller identifies four activities that make up store support: ordering, delivery of merchandise, shelf-stocking and customer assistance. He further gathers the following data relating to the $45,000 of support cost that is shown in the above report:
|
Monthly |
Activity |
Monthly |
|
|
Activity |
support cost |
driver |
quantity |
|
Ordering |
$ 9,500 |
Number of purchase orders |
95 |
|
Delivery of merchandise |
14,800 |
Number of deliveries |
185 |
|
Shelf-stocking |
9,720 |
Hours of shelf-stocking |
486 |
|
Customer assistance |
10,980 |
Number of items delivered |
54,900 |
|
Total store support cost |
$45,000 |
The controller further identifies the amount of activities associated with the three customers as follows:
|
Seven |
Family |
|||
|
Eleven |
Mart |
Welcome |
Total |
|
|
Number of purchase orders |
50 |
25 |
20 |
95 |
|
Number of deliveries |
120 |
35 |
30 |
85 |
|
Hours of shelf-stocking |
240 |
150 |
96 |
486 |
|
Number of items delivered |
20,000 |
25,000 |
9,900 |
54,900 |
Required
- Calculate the cost per unit of each activity driver.
- Prepare a revised customer profitability report for FFD based on the ABC system.
- Based on the results you obtained in Requirements 1 and 2, what would you recommend to Connie in order to improve FFD’s profitability?
- Briefly describe the advantages of the activity-based costing system over the old costing system of FFD.
Homework Answers
Answer 1:
Answer 2:
First let us allocate support cost based on ABC:
Answer 3:
When support costs are allocated based on ABC, we observe that loss on sales to Customer 'Seven Eleven' is higher at ($9,900).
To improve FFD's profitability:
FFD should further analyze, sales /costs to 'Seven Eleven'. FFD should look into reasons and take appropriate action to eliminate losses like reduce cost or increase sale price or discontinue.
Answer 4:
Advantages of the activity-based costing system over the old costing system of FFD:
1. Old system of allocating support cost equally to customers does not have any basis defining cause and effect relationship . Activity based costing (ABC) method determines the activity cost pools, cost drivers (based on what drives those costs establishing a cause and effect relationship), calculates activity rates and then allocates costs.
2. Traditional methods is not rational whereas ABC method has rational
3. The internal stakeholders who uses these cost data, will understand cost allocation done based on ABC better and can take specific actions. Cost data based on traditional method lacks such analysis and does not help in taking any specific actions to control overhead costs.
4. Cost data based on ABC are much more precise than cost data based on traditional method. As such it results in better decisions. Cost data based on traditional methods may result in erroneous decisions impacting the future of business.
-------------------------------------------------------------------------------------------------------------------------------------------------
The excel sheet (with above 3 tables) with 'show formula' is as below:
Add Answer to:
Family Food Distributor (FFD) distributes products to grocery stores. The company began operation sixth months ago with...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Baked Goods Fresh Produce Sales $ 148,000 $ 142,000 $ 211,000 Cost of goods sold 128,000 104,000 153,000 SFS estimates that store support expenses, in total, are approximately 14% of revenues. The controller says that...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Baked Fresh Frozen Foods Goods Produce $91,000 67,000 $158,175 110,000 Sales $120,000 Cost of goods sold 105,000 SFS estimates that store support expenses, in total, are approximately 20% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods $135,000 119,000 Fresh Baked Goods Produce $120,000 $184,000 88,000 128,000 Sales Cost of goods sold SFS estimates that store support expenses, in total, are approximately 17% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few perio...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Baked Fresh Frozen Foods Goods Produce $126,000 110,000 Sales $98,000 $165,000 115,000 Cost of qoods sold 72,000 SFS estimates that store support expenses, in total, are approximately 14% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Baked Goods Fresh Produce Sales $ 135,000 $ 120,000 $ 194,000 Cost of goods sold 117,000 88,000 136,000 SFS estimates that store support expenses, in total, are approximately 23% of revenues. The controller says that...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods $129,000 111,000 Sales Cost of goods sold Baked Goods $102,000 75,000 Fresh Produce $170,000 118,000 SFS estimates that store support expenses, in total, are approximately 20% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Sales Cost of goods sold $288,000 271, 000 Fresh Produce $524, 000 404, 000 Baked Goods $493, 000 399,000 SFS estimates that store support expenses, in total, are approximately 13% of revenues. The controller says...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Sales Cost of goods sold $288,000 271, 000 Fresh Produce $524, 000 404, 000 Baked Goods $493, 000 399,000 SFS estimates that store support expenses, in total, are approximately 13% of revenues. The controller says...
TELEIL penuu die. Frozen Foods $135,000 117,000 Fresh Baked Goods Produce $120,000 $194,000 88,000 136,000 Sales...
TELEIL penuu die. Frozen Foods $135,000 117,000 Fresh Baked Goods Produce $120,000 $194,000 88,000 136,000 Sales Cost of goods sold SFS estimates that store support expenses, in total, are approximately 23% of revenues The controller says that not every sales dollar requires or uses the same amount of store support activities. A preliminary analysis reveals store support activities for these three product lines are: Frozen Foods Baked Goods Fresh Produce 12 Activity (cost driver) Order processing (number of purchase orders)...
b. Genie Corner Stores operates aleancity and decides to apply ABC analysis to three product lines:...
b. Genie Corner Stores operates aleancity and decides to apply ABC analysis to three product lines: baked goods. milk and fruit juice and frozen foods. Total store and supporting costs (indirect/overhead costs) are $37,760. These indirect/overhead costs are identified in the following activities (cost pools) and their respective cost drivers Activity Total cost Cost driver Ordering Delivery Shelf-stocking Customer support Total $ 7.890 $ 17, 445 $ 5.640 $6785 $37, 760 Number of purchase orders Number of deliveries Number of...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Baked Fresh Frozen Foods Goods Produce $91,000 67,000 $158,175 110,000 Sales $120,000 Cost of goods sold 105,000 SFS estimates that store support expenses, in total, are approximately 20% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods $135,000 119,000 Fresh Baked Goods Produce $120,000 $184,000 88,000 128,000 Sales Cost of goods sold SFS estimates that store support expenses, in total, are approximately 17% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Baked Fresh Frozen Foods Goods Produce $126,000 110,000 Sales $98,000 $165,000 115,000 Cost of qoods sold 72,000 SFS estimates that store support expenses, in total, are approximately 14% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods $129,000 111,000 Sales Cost of goods sold Baked Goods $102,000 75,000 Fresh Produce $170,000 118,000 SFS estimates that store support expenses, in total, are approximately 20% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Sales Cost of goods sold $288,000 271, 000 Fresh Produce $524, 000 404, 000 Baked Goods $493, 000 399,000 SFS estimates that store support expenses, in total, are approximately 13% of revenues. The controller says...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Sales Cost of goods sold $288,000 271, 000 Fresh Produce $524, 000 404, 000 Baked Goods $493, 000 399,000 SFS estimates that store support expenses, in total, are approximately 13% of revenues. The controller says...
TELEIL penuu die. Frozen Foods $135,000 117,000 Fresh Baked Goods Produce $120,000 $194,000 88,000 136,000 Sales Cost of goods sold SFS estimates that store support expenses, in total, are approximately 23% of revenues The controller says that not every sales dollar requires or uses the same amount of store support activities. A preliminary analysis reveals store support activities for these three product lines are: Frozen Foods Baked Goods Fresh Produce 12 Activity (cost driver) Order processing (number of purchase orders)...
b. Genie Corner Stores operates aleancity and decides to apply ABC analysis to three product lines: baked goods. milk and fruit juice and frozen foods. Total store and supporting costs (indirect/overhead costs) are $37,760. These indirect/overhead costs are identified in the following activities (cost pools) and their respective cost drivers Activity Total cost Cost driver Ordering Delivery Shelf-stocking Customer support Total $ 7.890 $ 17, 445 $ 5.640 $6785 $37, 760 Number of purchase orders Number of deliveries Number of...
Most questions answered within 3 hours.
-
1. Develop a use case diagram for the bank case study described
in Chapter 1. 2....
asked 33 seconds ago -
The phylum Protista has often been referred to as a junk drawer
of classification. Explain what...
asked 7 minutes ago -
The average amount of money spent for lunch per person in the
college cafeteria is $7.09...
asked 9 minutes ago -
You follow the lab procedure and at the end of Part 4C, you used
an average...
asked 28 minutes ago -
Write 250-450 words, about the following: • Analyze how a
servant leader in your organization or...
asked 31 minutes ago -
3. American and Japanese workers can each produce 4 cars a
year. An American worker can...
asked 34 minutes ago -
On October 1, 20X1, a company purchased a piece of land by
agreeing to pay the...
asked 47 minutes ago -
Jamie is doing a survey at her school about whether the students
feel the cafeteria food...
asked 51 minutes ago -
What are the roles of 3' and 5' untranslated regions in
mRNAs?
asked 53 minutes ago -
A domestic television receives antenna delivers a sky noise
power of -105 dBm to a matched...
asked 51 minutes ago -
What do you think are the chemical reactions involved in the
breathalyzer tests administered to potentially...
asked 1 hour ago -
A random sample of 120 observations produces a mean of
38.2 from a population with a...
asked 1 hour ago