Question

In: Accounting

Family Supermarkets (FS) decides to apply ABC analysis to three product lines: baked goods, milk and...

Family Supermarkets (FS) decides to apply ABC analysis to three product lines: baked goods, milk and fruit juice, and frozen foods. It identifies four activities and their activity cost rates as:

Ordering R100 per purchase order
Delivery and receipt of merchandise R80 per delivery
Shelf-stocking R20 per hour
Customer support and assistance 20 cents per item sold

The revenues, cost of sales, store support costs, and activity-area usage of the three product lines are:

Baked
goods
Milk and
fruit juice
Frozen
products

Financial data


Revenues
R57 000
R63 000
R52 000

Cost of sales
R38 000
R47 000
R35 000

Store support
R11 400
R14 100
R10 500

Activity-area usage (cost allocation base)


Ordering (purchase orders)
30
25
13

Delivery (deliveries)
98
36
28

Shelf-stocking (hours)
183
166
24

Customer support (items sold)
15 500
20 500
7 900

Under the simple (traditional) costing system, FS allocated support costs to products at the rate of 30% of cost of sales.

Required:

2.1 Use the ABC system to calculate the operating income for each of the products. (21)

Solutions

Expert Solution

Allocation if support cost using Activity based costing (ABC) :

Activity area usage Cost allocation base Baked goods Milk and fruit juice Frozen products
Ordering R100 per purchase orders 3000 2500 1300
Delivery R80 per delivery 7840 2880 2240
Shelf stocking R20 per hour 3660 3320 480
Customer support 20 % of item sold 3100 4100 1580
Total support cost 17600 12800 5600

Computation of Cost of sales under ABC :

Baked goods Milk and fruit juice Frozen products
Cost of sales as per traditional costing 38000 47000 35000
(-) Stores Support cost as per traditional costing (11400) (14100) (10500)
26600 32900 24500
(+)Stores support cost as per ABC 17600 12800 5600
Cost of sales as per ABC 44200 45700 30100

Computation of operating income as per ABC :

Baked goods Milk and fruit juice Frozen products
Revenue 57000 63000 52000
(-) Cost of sales as per ABC (44200) (45700) (30100)
Operating income 12800 17300 21900

If you are benefited from the solution then please like,if disliked then please specify the reason in the comments.

Thank You

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Supermarkets ​(Upper F​S) operates at capacity and decides to apply ABC analysis to three product​ lines:...
Supermarkets ​(Upper F​S) operates at capacity and decides to apply ABC analysis to three product​ lines: baked​ goods, milk and fruit​ juice, and frozen foods. It identifies four activities and their activity cost rates as​ follows: Ordering $ 98 per purchase order Delivery and receipt of merchandise $ 81 per delivery ​Shelf-stocking $ 22 per hour Customer support and assistance $ 0.18 per item sold Milk and Frozen Baked Goods Fruit Juice Products Financial data Revenues $61,500 $67,000 $52,500 Cost...
CarlsonCarlson Supermarkets ​(Upper CC​S) operates at capacity and decides to apply ABC analysis to three product​...
CarlsonCarlson Supermarkets ​(Upper CC​S) operates at capacity and decides to apply ABC analysis to three product​ lines: baked​ goods, milk and fruit​ juice, and frozen foods. It identifies four activities and their activity cost rates as​ follows: LOADING... ​ Ordering $ 102$102 per purchase order Delivery and receipt of merchandise $ 78$78 per delivery ​Shelf-stocking $ 21$21 per hour Customer support and assistance $ 0.22$0.22 per item sold The​ revenues, cost of goods​ sold, store support​ costs, activities that account...
Henderson Company has three product lines: baked goods, milk and fruit juice, and frozen foods. Company...
Henderson Company has three product lines: baked goods, milk and fruit juice, and frozen foods. Company has experienced net operating losses in its Milk & Fruit Juice line during the last few periods. Company management thinks that the store will improve its profitability if it discontinued the Milk & Fruit Juice line. For product line profitability analysis purposes, currently company is allocating operating expenses as a percentage of sales dollars which approximately is 30% of sales dollar. Sales Revenues                                                   $89,250          ...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store is considering dropping the clothing line because the income statement shows that it is operating at a loss. Note the income statement for these product lines below: Hardware Clothing Sporting Goods Total Sales $10,000 $15,000 $25,000 $50,000 Less: Variable costs $6,000 $8,000 $12,000 $26,000 Contribution Margin $4,000 $7,000 $13,000 $24,000 Less: Fixed costs Direct $2,000 $6,500 $4,000 12,500 Allocated $1,000 $1,500 $2,500 $5,000 Total...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store is considering dropping the clothing line because the income statement shows that it is operating at a loss. Note the income statement for these product lines below: Hardware Clothing Sporting Goods Total Sales $10,000 $15,000 $25,000 $50,000 Less: Variable costs $6,000 $8,000 $12,000 $26,000 Contribution Margin $4,000 $7,000 $13,000 $24,000 Less: Fixed costs Direct $2,000 $6,500 $4,000 12,500 Allocated $1,000 $1,500 $2,500 $5,000 Total...
Activity Base Costing (ABC) Mango Mancam has two produce lines for it well marketed Milk Shake...
Activity Base Costing (ABC) Mango Mancam has two produce lines for it well marketed Milk Shake drink: Regular and Deluxe size. The company assigns $340,000.00 in manufacturing overhead costs to three departments; Purchasing, Mixing and Packing. Additional information about each product line is shown below; Regular Deluxe Number of units Produced per month 220,000 150,000 Number of Units Sold per month 210,000 140,000 Direct Material cost per unit 1.10 1.15 Machine hour per Unit 0.50 0.40 Direct Labor Cost per...
Family branding uses the same name to cover a group of products or product lines (for...
Family branding uses the same name to cover a group of products or product lines (for example, Nivea uses family branding). Individual branding requires the company to provide each product or product line with a distinctive name (for example Procter and Gamble tends to do mostly Individual branding). How should a company decide whether Individual or Family branding is best for a given product? What are some advantages/disadvantages of each type of branding strategy?
A family decides to have children until it has three male children. Assuming ?(????) = ?(??????)...
A family decides to have children until it has three male children. Assuming ?(????) = ?(??????) = 0.5, a. what is the probability that the family has ? female children? b. Calculate ?(?) and ?(?).
A family with a mother, father, two daughters and three sons lines up in a random...
A family with a mother, father, two daughters and three sons lines up in a random order for a photo. (a) Let D be the random variable denoting the number of daughters who are standing next to the mother and for i = 1,2 let Di be the indicator variable that is 1 if daughter i is next to the mother and 0 otherwise. What is the relationship between D, D1, and D2? (b) What are the expectations E[D1] and...
Toyo Japan plant manufactures three product lines, all multi-purpose kitchenware. The plant’s three product models are...
Toyo Japan plant manufactures three product lines, all multi-purpose kitchenware. The plant’s three product models are the Product 1 (P1), the Product 2(P2), and the Product 3 (P3). Until recently, the plant used a job-order product-costing system, with manufacturing overhead applied on the basis of direct-labor hours. The following table displays the basic data upon which the traditional costing system was based. Planned annual production P1 P2 P3 Volume in units 5,000 4,000 1,000 Production runs 40 runs of 125...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT