Question

In: Accounting

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           $99,000        $76,500

Cost of goods sold                                              $54,000           $72,000        $51,000

Operating costs (30% of sales revenues)            $26,775           $29,700        $22,950

Profit Margin                                                        $8,475          ($2,700)          $2,550

Profit Margin Ratio                                                 9.5%              -2.7%             3.3%

However, Rose, the new accountant who is a graduate of CSU, believes that not every sales dollar requires or uses the same amount of store support activities. She believes that company should look for other means for the allocation of store operating costs among the product lines – such as ABC. Based on her preliminary investigation and analysis, she could identify four store support operating activities and breakdown total store operating activities by these activities as follows:

Activity-area usage (cost allocation base)      Annual Activity Costs     Cost Driver

Ordering (purchase orders) $12,600    number of purchase orders

Delivery (deliveries) $22,475    number of deliveries Shelf-stocking (hours) Shelf-stocking hours $20,200

Customer support (items sold) $24,150    number of units sold

Total $79,425

Rose also has compiled the following annual data on usage of store support activities by each product line:

Activity-area usage (cost allocation base)

Baked Goods Milk&Fruit Juice Frozen Products

Ordering (purchase orders) 25                     20                 15

Delivery (deliveries)                                               90                     35                 30

Shelf-stocking (hours)                                          190                   174                 40

Customer support (items sold)                         13,500              18,450            8,300

. In the space provided on Answers Sheet, complete the product-line profitability report for

Henderson using ABC for the allocation of store support operating costs among the three products.

1. In the space provided on Answers Sheet, complete the product-line profitability report for

Henderson using ABC for the allocation of store support operating costs among the three products.

2. What new insights does the ABC system provide to Henderson Company managers? Explain.

26. Profitability Analysis

Baked Goods

Milk and Fruit Juice

Frozen Products

Sales Revenues

$89,250

$99,000

$76,500

Cost of goods sold

$54,000

$72,000

$51,000

Solutions

Expert Solution

Statement Showing Product Line Profitability Report Using ABC
Cost Drivers Baked Goods Milk and Frruit Juice Frozen Prodcuts Total
Sales Revenues $89,250 $99,000 $76,500 $264,750
Less: Cost Of Goods Sold $54,000 $72,000 $51,000 $177,000
Gross Profit (a) $35,250 $27,000 $25,500 $87,750
Less: Operation Expenses:
Ordering Purchase Order $5,250 $4,200 $3,150 $12,600
($12600/(25+20+15)X25) ($12600/(25+20+15)X20) ($12600/(25+20+15)X15)
Delivery Deliveries $13,050 $5,075 $4,350 $22,475
($22475/(90+35+30)X90 ($22475/(90+35+30)X35 ($22475/(90+35+30)X30
Self-stocking Hours $9,500 $8,700 $2,000 $20,200
($20200(190+174+40)X190 ($20200(190+174+40)X174 ($20200(190+174+40)X40
Customer Support Items Sold $8,100 $11,070 $4,980 $24,150
($24150/(13500+18450+8300)X13500 ($24150/(13500+18450+8300)X18450 ($24150/(13500+18450+8300)X8300
Total Operating Expenses $35,900 $29,045 $14,480 $79,425
Operating Income (b) -$650 -$2,045 $11,020 $8,325
Profit Margin Ratio (a-b) -0.73% -2.07% 14.41% 11.61%
b) Profit margin ration of Frozen Product is on very higher side on comparison with other product where negative profit margin shown. Hence, Frozen Products is more profitable under ABC system

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

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...
An orange juice processing plant has three production lines. The production lines fill juice into 400...
An orange juice processing plant has three production lines. The production lines fill juice into 400 ml packages. The production manager of the plant would like to know if the production lines are all filling the packages the same amount. A sample of 25 packages from each production line are taken and the data is saved in juice.csv. The production manager would like to know: “are the three production lines filling packages with the same amount of juice, on average?”....
Hungryman Ltd. (HGL) is a manufacturer that has three frozen product lines; quiches, pies and sausage...
Hungryman Ltd. (HGL) is a manufacturer that has three frozen product lines; quiches, pies and sausage rolls sold to supermarkets, cafes, and online customers. The production manager oversees all three product lines and there are three supervisors who oversee production of each product line. The three product lines share the same manufacturing equipment for example, dough mixer, food processor, conveyor belt and oven. Required: If each product line is a cost object, classify the following cost items as direct or...
Cornerstone Exercise 2.3 (Algorithmic) Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For...
Cornerstone Exercise 2.3 (Algorithmic) Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 47,700 units will be produced, with the following total costs: Direct materials ? Direct labor 69,000 Variable overhead 22,000 Fixed overhead 205,000 Next year, Pietro expects to purchase $119,500 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $7,000 $13,600 Ending $6,900 $15,600 Pietro...
Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts...
Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 49,100 units will be produced, with the following total costs: Direct materials ? Direct labor 53,000 Variable overhead 25,000 Fixed overhead 185,000 Next year, Pietro expects to purchase $128,000 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $6,000 $14,000 Ending $5,900 $16,000 Pietro expects to produce 49,100...
Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts...
Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 49,100 units will be produced, with the following total costs: Direct materials ? Direct labor 53,000 Variable overhead 25,000 Fixed overhead 185,000 Next year, Pietro expects to purchase $128,000 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $6,000 $14,000 Ending $5,900 $16,000 Pietro expects to produce 49,100...
Cost of Goods Manufactured Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts...
Cost of Goods Manufactured Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 50,000 units will be produced, with the following total costs: Direct materials ? Direct labor $61,000 Variable overhead 30,000 Fixed overhead 205,000 Next year, Pietro expects to purchase $115,000 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $6,000 $10,500 Ending $5,900 $12,500 Required: 1. Prepare a statement...
Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts...
Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 54,200 units will be produced, with the following total costs: Direct materials ? Direct labor 71,000 Variable overhead 24,000 Fixed overhead 245,000 Next year, Pietro expects to purchase $116,000 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $7,000 $11,900 Ending $6,900 $13,900 Pietro expects to produce 54,200...
Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts...
Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 49,400 units will be produced, with the following total costs: Direct materials ? Direct labor 69,000 Variable overhead 27,000 Fixed overhead 240,000 Next year, Pietro expects to purchase $124,500 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $6,000 $13,000 Ending $5,900 $15,000 Pietro expects to produce 49,400...
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...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT