PR 10-6A Product pricing and profit analysis with bottleneck operations Obj. 3 Hercules Steel Company produces three grades of steel: high, good, and regular grade. Each of these products (grades) has high demand in the market, EXCEL TEMPLATE and Hercules is able to sell as much as it can produce of all three. The furnace operation is a bottleneck in the process and is running at 100% of capacity. Hercules wants to improve steel operation profitability. The variable conversion cost is $15 per process hour. The fixed cost is $200,000. In addition, the cost analyst was able to determine the following information about the three products: High Grade Good Regular Grade Grade Budgeted units produced 5,000 5,000 5,000 Total process hours per unit Furnace hours per unit 12 11 10 4 2.5 Unit selling price $280 $270 $250 Direct materials cost per unit $90 $84 $80 The furnace operation is part of the total process for each of these three products. Thus, for example, 4.0 of the 12.0 hours required to process High Grade steel are associated with the furnace. Instructions

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
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
High
Good
Regular
Grade
Grade
Grade
Selling price
Variable conversion cost per unit
Direct materials cost per unit
Total cost per unit
Contribution margin
2.
High
Good
Regular
Grade
Grade
Grade
Contribution margin per unit
Divided by funace (bottleneck) hours per unit
Contribution margin per fumace hour
[Key essay answer here]
Transcribed Image Text:Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded. 1. High Good Regular Grade Grade Grade Selling price Variable conversion cost per unit Direct materials cost per unit Total cost per unit Contribution margin 2. High Good Regular Grade Grade Grade Contribution margin per unit Divided by funace (bottleneck) hours per unit Contribution margin per fumace hour [Key essay answer here]
PR 10-6A Product pricing and profit analysis with bottleneck operations
Obj. 3 Hercules Steel Company produces three grades of steel: high, good, and
regular grade. Each of these products (grades) has high demand in the market,
EXCEL TEMPLATE
and Hercules is able to sell as much as it can produce of all three. The furnace
operation is a bottleneck in the process and is running at 100% of capacity.
Hercules wants to improve steel operation profitability. The variable conversion cost is $15 per
process hour. The fixed cost is $200,000. In addition, the cost analyst was able to determine the
following information about the three products:
High
Grade
Regular
Grade
Good
Grade
Budgeted units produced
5,000
5,000
5,000
Total process hours per unit
Furnace hours per unit
12
11
10
4
3
2.5
Unit selling price
$280
$270
$250
Direct materials cost per unit
$90
$84
085
The furnace operation is part of the total process for each of these three products. Thus, for
example, 4.0 of the 12.0 hours required to process High Grade steel are associated with the furnace.
Instructions
1. Determine the unit contribution margin for each product.
Answer
2. Provide an analysis to determine the relative product profitability, assuming that the furnace is a
bottleneck.
Transcribed Image Text:PR 10-6A Product pricing and profit analysis with bottleneck operations Obj. 3 Hercules Steel Company produces three grades of steel: high, good, and regular grade. Each of these products (grades) has high demand in the market, EXCEL TEMPLATE and Hercules is able to sell as much as it can produce of all three. The furnace operation is a bottleneck in the process and is running at 100% of capacity. Hercules wants to improve steel operation profitability. The variable conversion cost is $15 per process hour. The fixed cost is $200,000. In addition, the cost analyst was able to determine the following information about the three products: High Grade Regular Grade Good Grade Budgeted units produced 5,000 5,000 5,000 Total process hours per unit Furnace hours per unit 12 11 10 4 3 2.5 Unit selling price $280 $270 $250 Direct materials cost per unit $90 $84 085 The furnace operation is part of the total process for each of these three products. Thus, for example, 4.0 of the 12.0 hours required to process High Grade steel are associated with the furnace. Instructions 1. Determine the unit contribution margin for each product. Answer 2. Provide an analysis to determine the relative product profitability, assuming that the furnace is a bottleneck.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Domestic transfer pricing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE 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