Exercise 6-3 Reconciliation of Absorption and Variable Costing Net Operating Incomes
Special instructions: Complete Exercise 6-3 in this document after the requirements list. You can create a table for the reconciliation report. Exhibit 6-4 provides an example that should help you complete the exercise.
Jorgansen Lighting, Inc., manufactures heavy-duty street lighting systems for municipalities. The company uses variable costing for internal management reports and absorption costing for external reports to shareholders, creditors, and the government. The company has provided the following data:
Year 1 |
Year 2 |
Year 3 |
|
Inventories: |
|||
Beginning (units) |
200 |
170 |
180 |
Ending (units) |
170 |
180 |
220 |
Variable costing net operating income |
$1,080,400 |
$1,032,400 |
$996,400 |
The company’s fixed manufacturing overhead per unit was constant at $560 for all three years.
Required:
Exercise 6-5 Companywide and Segment Break-Even Analysis
Special instructions: Answer the questions for Exercise using Microsoft Excel. The equations on page 274 of your textbook will help you complete this exercise.
Piedmont Company segments its business into two regions—North and South. The company prepared the contribution format segmented income statements as shown below:
Total Company |
North |
South |
|||
Sales |
$ 600,000 |
$ 400,000 |
$ 200,000 |
||
Variable expenses |
360,000 |
280,000 |
80,000 |
||
Contribution margin |
240,000 |
120,000 |
120,000 |
||
Traceable fixed expenses |
120,000 |
60,000 |
60,000 |
||
Segment margin |
120,000 |
$ 60,000 |
$ 60,000 |
||
Common fixed expenses |
50,000 |
||||
Net operating income |
$ 70,000 |
Required:
Exercise 7-5 Product and Customer Profitability Analysis
Special instructions: Compute the requirement for Exercise 7-5 on this document.
Thermal Rising, Inc., makes paragliders for sale through specialty sporting goods stores. The company has a standard paraglider model, but also makes custom-designed paragliders. Management has designed an activity-based costing system with the following activity cost pools and activity rates:
Activity Cost Pool |
Activity Rate |
|
Supporting direct labor |
$26 per direct labor-hour |
|
Order processing |
$284 per order |
|
Custom design processing |
$186 per custom design |
|
Customer service |
$379 per customer |
Management would like an analysis of the profitability of a particular customer, Big Sky Outfitters, which has ordered the following products over the last 12 months:
Standard Model |
Custom Design |
|
Number of gliders |
20 |
3 |
Number of orders |
1 |
3 |
Number of custom designs |
0 |
3 |
Direct labor-hours per glider |
26.35 |
28.00 |
Selling price per glider |
$1,850 |
$2,400 |
Direct materials cost per glider |
$564 |
$364 |
The company’s direct labor rate is $19.50 per hour.
Required:
Ex 6-3
Working as follows:
Year 1 | Year 2 | Year 3 | |
Beginning inventories (Units) (A) | 200 | 170 | 180 |
Ending inventories (Units) (B) | 170 | 180 | 220 |
Change in inventories [C= A-B] | 30 | -10 | -40 |
Fixed manufacturing overhead deferred in (released from) inventory [D = $560 × C] | $16,800 | $5,600 | $22,400 |
Variable costing Net operating income | $1,080,400 | $1,032,400 | $996,400 |
Add/(Deduct) (D) | ($16,800) | $5,600 | $22,400 |
Absorption costong Net operating income | $1,063,600 | $1,038,000 | $1,018,800 |
_________________________________________________________________
a)
Inventories increased during year 4
b)
Deferred or released = 50 units ($28,000/$560)
Fixed manufacturing overhead cost = $28,000
Analysis:
Variable costing operating income | $984,400 |
Add: Ending inventory (270 × $560) | $151,200 |
Less: Beginning inventory (220 × $560) | $123,200 |
Absorption costing operating income | $1,012,400 |
Exercise 6-3 Reconciliation of Absorption and Variable Costing Net Operating Incomes Special instructions: Complete Exercise 6-3...
Jorgansen Lighting, Incorporated, manufactures heavy-duty street lighting systems for municipalities. The company uses variable costing for internal management reports and absorption costing for external reports to shareholders, creditors, and the government. The company has provided the following data: Year 1Year 2Year 3Inventories:Beginning (units)200170180Ending (units)170180220Variable costing net operating income$ 1,080,400$ 1,032,400$ 996,400 The company’s fixed manufacturing overhead per unit was constant at $560 for all three years.Exercise 7-3 (Static) Part 2 2. Assume in Year 4 that the company’s variable costing net operating income...
Jorgansen Lighting, Incorporated, manufactures heavy-duty street lighting systems for municipalities. The company uses variable costing for internal management reports and absorption costing for external reports to shareholders, creditors, and the government. The company has provided the following data: Year 1Year 2Year 3Inventories:Beginning (units)200170180Ending (units)170180220Variable costing net operating income$ 1,080,400$ 1,032,400$ 996,400 The company’s fixed manufacturing overhead per unit was constant at $560 for all three years.
Exercise 7-5 Companywide and Segment Break-Even Analysis [LO7-5 Piedmont Company segments its business into two regions-North and South. The compa segmented income statement as shown: Total Company $600,000 360, 000 240,000 120,000 North $ 400, 000 280,000 120,000 60,000 60,000 South Sales Variable expenses Contribution margin Traceable fixed expenses $200,000 80,00 120,000 60,000 Segment margin Common fixed expenses 120,000 60,000 50,000 $ 70,000 Net operating income Required: 1. Compute the companywide break-even point in dollar sales. 2. Compute the break-even...
Exercise 6-12 Variable Costing Income Statement; Reconciliation [LO6-2, LO6-3] Whitman Company has just completed its first year of operations. The company’s absorption costing income statement for the year follows: Whitman Company Income Statement Sales (38,000 units × $43.60 per unit) $ 1,656,800 Cost of goods sold (38,000 units × $21 per unit) 798,000 Gross margin 858,800 Selling and administrative expenses 437,000 Net operating income $ 421,800 The company’s selling and administrative expenses consist of $285,000 per year in fixed expenses...
Piedmont Company segments its business into two regions-North and South. The company prepared the contribution format segmented income statement as shown: Sales Variable expenses Contribution margin Traceable fixed expenses Segment margin Common fixed expenses Net operating income Total Company $ 600,000 360,000 240,000 120,000 120,000 50,000 $ 70,000 North $ 400,000 280,000 120,000 60,000 $ 60,000 South $ 200,000 80,000 120,000 60,000 $ 60,000 Required: 1. Compute the companywide break-even point in dollar sales. 2. Compute the break-even point in...
Piedmont Company segments its business into two regions-North and South. The company prepared the contribution format segmented income statement as shown: Sales Variable expenses Contribution margin Traceable fixed expenses Segment margin Common fixed expenses Net operating income Total Company $ 600,000 360,000 240,000 120,000 120,000 50,000 $ 70,000 North $ 400,000 280,000 120,000 60,000 $ 60,000 South $ 200,000 80,000 120,000 60,000 $ 60,000 Required: 1. Compute the companywide break-even point in dollar sales. 2. Compute the break-even point in...
Exercise 6-5 Companywide and Segment Break-Even Analysis [LO6-5] Piedmont Company segments its business into two regions-North and South. The company prepared the contribution format segmented income statement shown below: Total CompanyNorth South $800,000 $600,000 $200,000 560,000 480,000 80,000 Sales Variable expenses Contribution margin 240,000120,000 120,000 61,00061,000 Traceable fixed expenses Segment margin Common fixed expenses Net operating income 122,000 18,000 $ 59,000 $ 59,000 2,000 $ 66,000 Required: 1. Compute the companywide break-even point in dollar sales Dollar sales for company...
Exercise 5-5 (Algo) Product and Customer Profitability Analysis [LO5-4, LO5-5] Thermal Rising, Inc., makes paragliders for sale through specialty sporting goods stores. The company has a standard paraglider model, but also makes custom-designed paragliders. Management has designed an activity-based costing system with the following activity cost pools and activity rates: Activity Cost Pool Activity Rate Supporting direct labor $ 16 per direct labor-hour Order processing $ 184 per order Custom design processing $ 256 per custom design Customer service $...
1) what is the amount of the difference between the variable costing and absorption costing net operating incomes (losses)? 2) Whats the company's break-even point in unit sales? is the above or below the actual unit sales? Diego Company manufactures one product that is sold for $76 per unit in two geographic regions-the East and West regions. The following information pertains to the company's first year of operations in which it produced 58,000 units and sold 54,000 units. Variable costs...
Exercise 6-5 Companywide and Segment Break-Even Analysis (L06-5) Piedmont Company segments its business into two regions-North and South. The company prepared the contribution format segmented income statement as shown: Sales Variable expenses Contribution margin Traceable fixed expenses Segment margin Common fixed expenses Net operating income Total Company $ 675,000 405,000 270,000 132,000 138,000 58, Bee $ 80,000 North $450,000 315,000 135,000 66,000 $ 69,000 South $225,000 90.000 135,000 66,000 $69.000 Required: 1. Compute the companywide break-even point in dollar sales....