Product costs             Labor-hours per case   7.8   3.8   1.0 Total cases produced   1,000   1,000   1,000 Material cost per case $ 8.80 $ 2.80 $ 9.30 Direct labor cost per case $ 46.80 $ 22.80 $ 6.00 Labor-hours per product   7,800   3,800   1,000 Total overhead = $73,500             Total labor-hours = 12,600             Direct labor costs per hour = $6.00             Allocation rate per labor-hour = (a).             Costs of products             Material cost per case $ 8.80 $ 2.80 $ 9.30 Direct labor cost per case   46.80   22.80   6.00 Allocated overhead per case(to be computed)   (b)   (c)   (d) Product cost   (e)   (f)   (g)     CBI recently adopted a general policy to discontinue all products whose gross profit margin percentages [(Gross margin ÷ Selling price) × 100] were less than 10 percent. By comparing the selling prices to the firm’s costs and then calculating the gross margin percentages, Jean could determine which products, under the current cost system, should be dropped. The current selling prices of Almond Dream, Krispy Krackle, and Creamy Crunch are $93.00, $65.00, and $30.00 per case, respectively. Overhead will remain $73,500 per month under all alternatives.   Required: a-1. Complete the table under the current cost system. a-2. Determine which product(s), if any, should be dropped. c-1. Assume that CBI drops the product(s) identified in requirement (a) above. Calculate the gross profit margin percentage for the remaining products. Assume that CBI can sell all products that it manufactures and that it will use the excess capacity from dropping a product to produce more of the most profitable product.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Chocolate Bars, Inc. (CBI), manufactures creamy deluxe chocolate candy bars. The firm has developed three distinct products: Almond Dream, Krispy Krackle, and Creamy Crunch.

 

CBI is profitable, but management is quite concerned about the profitability of each product and the product costing methods currently employed. In particular, management questions whether the overhead allocation base of direct labor-hours accurately reflects the costs incurred during the production process of each product.

 

In reviewing cost reports with the marketing manager, Steve Hoffman, who is the cost accountant, notices that Creamy Crunch appears exceptionally profitable and that Almond Dream appears to be produced at a loss. This surprises both him and the manager, and after much discussion, they are convinced that the cost accounting system is at fault and that Almond Dream is performing very well at the current market price.

 

Steve decides to hire Jean Sharpe, a management consultant, to study the firm’s cost system over the next month and present her findings and recommendations to senior management. Her objective is to identify and demonstrate how the cost accounting system might be distorting the firm’s product costs.

 

Jean begins her study by gathering information and documenting the existing cost accounting system. It is rather simplistic, using a single overhead allocation base—direct labor-hours—to calculate and apply overhead rates to all products. The rate is calculated by summing variable and fixed overhead costs and then dividing the result by the number of direct labor-hours. The product cost is determined by multiplying the number of direct labor-hours required to manufacture the product by the overhead rate and adding this amount to the direct labor and direct material costs.

 

CBI engages in two distinct production processes for each product. Process 1 is labor intensive, using a high proportion of direct materials and labor. Process 2 uses special packing equipment that wraps each individual candy bar and then packs it into a box of 24 bars. The boxes are then packaged into cases, each of which has six boxes. Special packing equipment is used on all three products and has a monthly capacity of 3,000 cases, each containing 144 candy bars (= 6 boxes × 24 bars).

 

To illustrate the source of the distortions to senior management, Jean collects the cost data for the three products, Almond Dream, Krispy Krackle, and Creamy Crunch.

 

  Almond Dream Krispy Krackle Creamy Crunch
Product costs            
Labor-hours per case   7.8   3.8   1.0
Total cases produced   1,000   1,000   1,000
Material cost per case $ 8.80 $ 2.80 $ 9.30
Direct labor cost per case $ 46.80 $ 22.80 $ 6.00
Labor-hours per product   7,800   3,800   1,000
Total overhead = $73,500            
Total labor-hours = 12,600            
Direct labor costs per hour = $6.00            
Allocation rate per labor-hour = (a).            
Costs of products            
Material cost per case $ 8.80 $ 2.80 $ 9.30
Direct labor cost per case   46.80   22.80   6.00
Allocated overhead per case(to be computed)   (b)   (c)   (d)
Product cost   (e)   (f)   (g)
 

 

CBI recently adopted a general policy to discontinue all products whose gross profit margin percentages [(Gross margin ÷ Selling price) × 100] were less than 10 percent. By comparing the selling prices to the firm’s costs and then calculating the gross margin percentages, Jean could determine which products, under the current cost system, should be dropped. The current selling prices of Almond Dream, Krispy Krackle, and Creamy Crunch are $93.00, $65.00, and $30.00 per case, respectively. Overhead will remain $73,500 per month under all alternatives.

 

Required:

a-1. Complete the table under the current cost system.

a-2. Determine which product(s), if any, should be dropped.

c-1. Assume that CBI drops the product(s) identified in requirement (a) above. Calculate the gross profit margin percentage for the remaining products. Assume that CBI can sell all products that it manufactures and that it will use the excess capacity from dropping a product to produce more of the most profitable product.

c-2. If CBI maintains its current rule about dropping products, which additional products, if any, should CBI drop under the existing cost system?

d-1. Assume that CBI drops the products identified in requirements (a) and (c) above. Recalculate the gross profit margin percentage for the remaining product(s) and ascertain whether any additional product(s) should be dropped.

d-2. Which additional products, if any, should CBI drop under the existing cost system?

**Educational Website: Cost System Analysis for Product Manufacturing**

In this exercise, you will learn how to complete a cost analysis table under the current cost system for three products: Almond Dream, Krispy Krackle, and Creamy Crunch. Each product has distinct manufacturing costs associated with labor, materials, and overhead. Follow the detailed explanation to understand how each cost component contributes to the final product cost.

### Product Costs:

#### Almond Dream
- **Labor-hours per case:** 7.80
- **Total cases produced:** 1,000
- **Material cost per case:** $8.80
- **Direct labor cost per case:** $46.80
- **Labor-hours per product:** 7,800

#### Krispy Krackle
- **Labor-hours per case:** 3.80
- **Total cases produced:** 1,000
- **Material cost per case:** $2.80
- **Direct labor cost per case:** $22.80
- **Labor-hours per product:** 3,800

#### Creamy Crunch
- **Labor-hours per case:** 1.00
- **Total cases produced:** 1,000
- **Material cost per case:** $9.30
- **Direct labor cost per case:** $6.00
- **Labor-hours per product:** 1,000

### Overhead and Labor
- **Total overhead:** $73,500
- **Total labor-hours:** 12,600
- **Direct labor costs per hour:** $6.00

The allocation rate per labor-hour and allocated overhead per case are yet to be calculated. These figures will help in determining the total product costs and subsequently the gross profit margin percentage after considering the selling prices.

### Costs of Products:

The final step is to calculate and fill out the remaining sections:
- **Allocated overhead per case**
- **Product cost**
- **Selling price**
- **Gross profit margin percentage**

This structured table allows for the analysis of how various cost factors, like labor and materials, impact the total cost of production and profitability for each product.
Transcribed Image Text:**Educational Website: Cost System Analysis for Product Manufacturing** In this exercise, you will learn how to complete a cost analysis table under the current cost system for three products: Almond Dream, Krispy Krackle, and Creamy Crunch. Each product has distinct manufacturing costs associated with labor, materials, and overhead. Follow the detailed explanation to understand how each cost component contributes to the final product cost. ### Product Costs: #### Almond Dream - **Labor-hours per case:** 7.80 - **Total cases produced:** 1,000 - **Material cost per case:** $8.80 - **Direct labor cost per case:** $46.80 - **Labor-hours per product:** 7,800 #### Krispy Krackle - **Labor-hours per case:** 3.80 - **Total cases produced:** 1,000 - **Material cost per case:** $2.80 - **Direct labor cost per case:** $22.80 - **Labor-hours per product:** 3,800 #### Creamy Crunch - **Labor-hours per case:** 1.00 - **Total cases produced:** 1,000 - **Material cost per case:** $9.30 - **Direct labor cost per case:** $6.00 - **Labor-hours per product:** 1,000 ### Overhead and Labor - **Total overhead:** $73,500 - **Total labor-hours:** 12,600 - **Direct labor costs per hour:** $6.00 The allocation rate per labor-hour and allocated overhead per case are yet to be calculated. These figures will help in determining the total product costs and subsequently the gross profit margin percentage after considering the selling prices. ### Costs of Products: The final step is to calculate and fill out the remaining sections: - **Allocated overhead per case** - **Product cost** - **Selling price** - **Gross profit margin percentage** This structured table allows for the analysis of how various cost factors, like labor and materials, impact the total cost of production and profitability for each product.
The image appears to be a section from a spreadsheet interface used for calculating financial metrics in a manufacturing context. It is formatted as a table with columns and input fields.

### Description of the Table:

**Header:**
- The header instructs users to calculate the gross profit margin percentage of products after certain products are dropped per given instructions (requirement (a)). It assumes that the company can sell all manufactured products and use excess capacity efficiently.

**Column Headings:**
- The table is divided into several columns, each for a different product or requirement.

**Rows:**
1. **Direct Labor Cost per Hour:** Input field for the hourly rate paid to labor.
2. **Direct Labor-Hours per Case:** Input field for the number of labor hours required to produce one case.
3. **Total Cases Produced:** Input field for the total number of cases produced.
4. **Labor-Hours per Product:** Input field for the total labor hours needed per product.
5. **Allocation Rate per Labor Hour:** Field related to distributing overhead or other costs per labor hour.
6. **Allocated Production Costs:**
   - **Material Cost per Case:** Input field for the cost of materials per case.
   - **Direct Labor Cost per Case:** Input field for labor cost per case based on labor hours.
   - **Allocated Overhead per Case:** Input field for overhead costs allocated per case.
7. **Product Cost:** 
   - Shows total product cost in dollars with a value of $0.00 in the image.
8. **Gross Profit Margins:**
   - **Selling Price:** Field to enter or calculate the selling price.
   - **Product Cost—Direct Labor Allocation Base:** Base cost using direct labor allocation, shown as $0.00.
   - **Profit Margin Percentage:** Field to calculate and display the profit margin percentage, shown as 0%.

**Navigation:**
- There are buttons labeled "Req A2" and "Req C2" for moving to different sections of the task or calculations.

The table is designed for financial analysis and requires input values to calculate operational and financial metrics like product costs and profit margins.
Transcribed Image Text:The image appears to be a section from a spreadsheet interface used for calculating financial metrics in a manufacturing context. It is formatted as a table with columns and input fields. ### Description of the Table: **Header:** - The header instructs users to calculate the gross profit margin percentage of products after certain products are dropped per given instructions (requirement (a)). It assumes that the company can sell all manufactured products and use excess capacity efficiently. **Column Headings:** - The table is divided into several columns, each for a different product or requirement. **Rows:** 1. **Direct Labor Cost per Hour:** Input field for the hourly rate paid to labor. 2. **Direct Labor-Hours per Case:** Input field for the number of labor hours required to produce one case. 3. **Total Cases Produced:** Input field for the total number of cases produced. 4. **Labor-Hours per Product:** Input field for the total labor hours needed per product. 5. **Allocation Rate per Labor Hour:** Field related to distributing overhead or other costs per labor hour. 6. **Allocated Production Costs:** - **Material Cost per Case:** Input field for the cost of materials per case. - **Direct Labor Cost per Case:** Input field for labor cost per case based on labor hours. - **Allocated Overhead per Case:** Input field for overhead costs allocated per case. 7. **Product Cost:** - Shows total product cost in dollars with a value of $0.00 in the image. 8. **Gross Profit Margins:** - **Selling Price:** Field to enter or calculate the selling price. - **Product Cost—Direct Labor Allocation Base:** Base cost using direct labor allocation, shown as $0.00. - **Profit Margin Percentage:** Field to calculate and display the profit margin percentage, shown as 0%. **Navigation:** - There are buttons labeled "Req A2" and "Req C2" for moving to different sections of the task or calculations. The table is designed for financial analysis and requires input values to calculate operational and financial metrics like product costs and profit margins.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education