Question

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

  1. Calculate the cost per unit of each activity driver.
  2. Prepare a revised customer profitability report for FFD based on the ABC system.
  3. Based on the results you obtained in Requirements 1 and 2, what would you recommend to Connie in order to improve FFD’s profitability?
  4. Briefly describe the advantages of the activity-based costing system over the old costing system of FFD.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer 1:

Monthly quantity Activity Ordering Delivery of merchandise Shelf-stocking Customer assistance Total store support cost Monthl

Answer 2:

First let us allocate support cost based on ABC:

Total Number of purchase orders Number of deliveries Hours of shelf-stocking Number of items delivered Seven Eleven 50 120 24

Welcome Total Revenues Costs of goods sold Gross profit Store support Customer profit margin Seven Family Mart Eleven $45,000

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:

Activity 2 Ordering 3 Delivery of merchandise 4 Shelf-stocking 5 Customer assistance 6 Total store support cost D E Cost per

Add a comment
Know the answer?
Add Answer to:
Family Food Distributor (FFD) distributes products to grocery stores. The company began operation sixth months ago with...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT