23.07.2022 - 05:04

The Global Gourmet Coffee Company (GGCC) is a distributor and processor of different blends of coffee. GCC currently has 12 different coffees that it offers to gourmet shops in one-pound bags. The maj

Question:

The Global Gourmet Coffee Company (GGCC) is a distributor and processor of different blends of coffee. GCC currently has 12 different coffees that it offers to gourmet shops in one-pound bags. The major cost is raw materials. There is also a substantial amount of manufacturing overhead in the predominantly automated roasting and packing processes. The company uses relatively little direct labor.

GGCC prices it’s coffee at full product cost, including allocated overhead, plus a markup of 30 percent. The company competes primarily on the quality of its products, but customers are price-conscious as well. Data for the 2018 budget include manufacturing overhead of $12,000,000, which is allocated based on each product’s direct labor cost. The budgeted direct labor cost for 2018 totals $1,200,000. Based on the sales budget and raw material budget, purchases and use of raw materials (coffee beans) will total $5,800,000. The expected prime costs for one-pound bags of two of the company’s products are as follows:

Jamaican Columbian
Direct material $2.90 $3.90
Direct labor $0.40 $0.40

An analysis of the 2018 budgeted manufacturing overhead costs is shown in the following chart.

Activity Cost Driver Budgeted Activity Level Budgeted Cost
Purchasing Purchase Orders 2,316 $2,316,000
Material Handling Setups 3,600 2,880,000
Quality Control Batches 1,440 576,000
Roasting Roasting Hours 192,200 3,844,000
Blending Blending Hours 67,200 1,344,000
Packaging Packaging Hours 52,000 1,040,000
Total $12,000,000

Production Data for Jamaican and Columbian coffees in 2018 are as follows:

Jamaican Columbian
Budgeted Sales 2,000 lb 100,000 lb
Batch Size 500 lb 20,000 lb
Setups 3 per batch 3 per batch
Purchase Order Size 500 lb 50,000 lb
Roasting Time 1 hr/200 lb 1 hr/200 lb
Blending Time 0.5 hr/200 lb 0.5 hr/200 lb
Packaging Time 0.1 hr/200 lb 0.1 hr/200 lb

Required:

1. Using GGCC’s current product-costing system:

  • a. Determine the company’s predetermined overhead rate using direct-labor cost as the single cost driver.
  • b. Determine the full product costs and selling prices of one pound of Jamaican coffee and one pound of Colombian coffee.

2. Develop a new product cost, using an activity-based costing approach, for one pound of Jamaican coffee and one pound of Colombian coffee.

3. Fully discuss the implications of the activity-based costing system with respect to:

  • a. The use of direct labor as the sole basis for applying overhead to products?
  • b. The use of the existing product-costing system as the basis for pricing?
Answers (1)
  • Della
    April 13, 2023 в 20:18
    a. The company's predetermined overhead rate using direct-labor cost as the single cost driver is calculated as follows: Predetermined overhead rate = Budgeted manufacturing overhead / Budgeted direct labor cost Predetermined overhead rate = $12,000,000 / $1,200,000 Predetermined overhead rate = $10 per direct labor dollar b. The full product costs and selling prices of one pound of Jamaican coffee and one pound of Colombian coffee are calculated as follows: Jamaican coffee: Direct material cost = $2.90 Direct labor cost = $0.40 Manufacturing overhead cost = ($0.40 x $10) = $4.00 Total cost per pound = $7.30 Markup (30%) = $2.19 Selling price per pound = $9.49 Colombian coffee: Direct material cost = $3.90 Direct labor cost = $0.40 Manufacturing overhead cost = ($0.40 x $10) = $4.00 Total cost per pound = $8.30 Markup (30%) = $2.49 Selling price per pound = $10.79 2. The new product cost using an activity-based costing approach for one pound of Jamaican coffee and one pound of Colombian coffee is calculated as follows: Jamaican coffee: Direct material cost = $2.90 Direct labor cost = $0.40 Manufacturing overhead cost = (3 setups x $960 per setup) + (500 roasting hours x $20 per roasting hour) + (500 blending hours x $10 per blending hour) + (500 packaging hours x $5 per packaging hour) = $23,500 Total cost per pound = $26.80 Markup (30%) = $8.04 Selling price per pound = $34.84 Colombian coffee: Direct material cost = $3.90 Direct labor cost = $0.40 Manufacturing overhead cost = (3 setups x $960 per setup) + (50,000 lb / 20,000 lb per batch x 1.5 batches x $576 per batch) + (100,000 roasting hours x $20 per roasting hour) + (100,000 blending hours x $10 per blending hour) + (100,000 packaging hours x $5 per packaging hour) = $2,814,800 Total cost per pound = $14.07 Markup (30%) = $4.22 Selling price per pound = $18.29 3. The activity-based costing system has several implications: a. The use of direct labor as the sole basis for applying overhead to products may not accurately reflect the actual consumption of manufacturing overhead by each product. This is because products with different levels of complexity, batch sizes, and activity requirements may consume different amounts of manufacturing overhead even if they have the same amount of direct labor cost. b. The use of the existing product-costing system as the basis for pricing may not be optimal since it does not take into account the actual consumption of manufacturing overhead by each product. This may lead to overpricing or underpricing certain products, which can affect the company's profitability and competitiveness. Using activity-based costing can provide more accurate product costs and pricing decisions, which can improve the company's competitiveness in the market.
Do you know the answer?

Leave a comment

Not sure about the answer?
Find the right answer to the question The Global Gourmet Coffee Company (GGCC) is a distributor and processor of different blends of coffee. GCC currently has 12 different coffees that it offers to gourmet shops in one-pound bags. The maj by subject Tech and Engineering, and if there is no answer or no one has given the right answer, then use the search and try to find the answer among similar questions.
Search for other answers
New questions in the category: Tech and Engineering
Authorization
*
*

Password generation