Question

In: Accounting

The following data relate to KATZEN Sales Inc., a new company:

The following data relate to KATZEN Sales Inc., a new company:

Planned and actual production

200,000 units

Sales at $45 per unit

180,000 units

Manufacturing costs:

 

Variable

$18 per unit

Fixed

$800,000

Selling and administrative costs:

 

Variable

$6 per unit

Fixed

$925,000

Required: A. Determine the number of units in the ending finished-goods inventory B. Calculate the cost of the ending finished-goods inventory using variable costing C. Calculate the cost of the ending finished-goods inventory using absorption costing D The difference between net income using variable costing & absorption costing is _______ E. Determine the company's variable-costing net income. G. Determine the company's absorption-costing net income. H. Explain the difference in net income amounts. Support your explanation with a reconciliation.

Solutions

Expert Solution

Answer A
The number of units in the ending finished-goods inventory = Units produced - Units sold = 200000 - 180000 = 20000 units
Answer B
Cost of the ending finished-goods inventory using variable costing = Ending inventory units * Variable cost per unit
Cost of the ending finished-goods inventory using variable costing = 20000 units * $18 = $3,60,000
Answer C
Cost of the ending finished-goods inventory using absorption costing = Ending inventory units * [Variable cost per unit + Fixed cost per unit]
Fixed cost per unit = Fixed manufacturing cost / Production Units = $800000 / 200000 units = $4 per unit
Cost of the ending finished-goods inventory using absorption costing = 20000 units * [$18 + $4] = $4,40,000
Answer D
The difference between net income using variable costing & absorption costing = Cost of ending inventory using Absorption costing - Cost of ending variable using Absorption costing
The difference between net income using variable costing & absorption costing = $440000 - $360000 = $80,000
Answer E
Determine the company's variable-costing net income
Sales $8,100,000
Less : Variable cost
- Manufacturing cost $3,240,000
- Selling and administrative cost $1,080,000 $4,320,000
Contribution Margin $3,780,000
Less : Fixed Expenses
- Manufacturing cost $800,000
- Selling and administrative cost $925,000 $1,725,000
Net Income $2,055,000
Answer G
Determine the company's absorption-costing net income
Sales $8,100,000
Less : Cost of manufacturing $3,960,000
Gross Margin $4,140,000
Less : Selling and administrative exp.
- Variable $1,080,000
- Fixed $925,000 $2,005,000
Net Income $2,135,000
Answer H
Reconciliation of net income amounts
Net Income as per Absorption costing $2,135,000
Less : Fixed manufacturing cost included in Ending Inventory [20000 units * $4] $80,000
Net Income as per Variable costing $2,055,000

Related Solutions

Computational Problems: Variable Costing & Absorption Costing1. The following data relate to QQQ Company, a new...
Computational Problems: Variable Costing & Absorption Costing1. The following data relate to QQQ Company, a new corporation, during a period when the firm produced and sold 100,000 units and 90,000 units, respectively: Direct materials used $400,000 Direct labor 200,000 Fixed manufacturing overhead 250,000 Variable manufacturing overhead 120,000 Fixed selling and administrative expenses 300,000 Variable selling and administrative expenses 45,000 The company met its original planned production target of 100,000 units. The selling price per unit was $15. Required: What is...
The following data relate to the sales of a product over an 8-month period: MONTH Jan...
The following data relate to the sales of a product over an 8-month period: MONTH Jan Feb Mar Apr May June July Aug Sales (units) 56 72 70 65 68 75 66 67 Price ($) 75 65 59 69 69 49 59 59 a) Investigate whether sales are affected more by the level of price or by the change in price of the product. b) Interpret the regression coefficient of the explanatory variable. c) Forecast sales in September if price...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 20Y8: Employee Hours Worked Hourly Rate Weekly Salary Federal Income Tax Retirement Savings Aaron 45 $62 $641.84 $115 Cobb 42 67 623.92 125 Clemente 49 68 835.88 135 DiMaggio 38 54 376.68 0 Griffey, Jr. 46 63 681.60 145 Mantle $1,600 292.45 135 Robinson 38 56 418.40 145 Williams 1,900 370.24 140 Vaughn 46 63 702.60 40 Employees Mantle and Williams are office...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 2016: Employee Hours Worked Hourly Rate Weekly Salary Federal Income Tax U.S. Savings Bonds Aaron 43 $70 $689.44 $130 Cobb 43 58 539.92 140 Clemente 45 64 668.44 150 DiMaggio 39 52 377.80 0 Griffey, Jr. 48 64 749.08 160 Mantle $1,700 317.45 150 Robinson 38 53 387.32 160 Williams 2,100 426.24 155 Vaughn 48 64 770.08 70 Employees Mantle and Williams are...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9. Employee Hours Worked Hourly Rate Weekly Salary Federal Income Tax U.S. Savings Bonds Aaron 46 $68 $750.20 $130 Cobb 41 62 537.68 140 Clemente 48 70 836.44 150 DiMaggio 35 56 366.04 0 Griffey, Jr. 45 62 641.84 160 Mantle $1,800 342.45 150 Robinson 36 54 382.56 160 Williams 2,000 398.24 155 Vaughn 42 62 584.72 80 Employees Mantle and Williams are office...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9. Employee Hours Worked Hourly Rate Weekly Salary Federal Income Tax U.S. Savings Bonds Aaron 45 $62 $641.84 $135 Cobb 42 67 623.92 145 Clemente 49 68 835.88 155 DiMaggio 38 54 376.68 0 Griffey, Jr. 46 63 681.60 165 Mantle $1,600 292.45 155 Robinson 38 56 418.40 165 Williams 1,900 370.24 160 Vaughn 46 63 702.60 40 Employees Mantle and Williams are office...
Payroll Register The following data for Throwback Industries, Inc. relate to the payroll for the week...
Payroll Register The following data for Throwback Industries, Inc. relate to the payroll for the week ended December 9, 20Y8: Hours Hourly Weekly Federal Retirements Employee Worked Rate Salary Income Tax Savings Aaron 46 $30 $338.10 $75 Cobb 41 42 374.75 40 Clemente 43 26 219.83 100 DiMaggio 36 40 302.4 90 Griffey, Jr. 48 38 414.96 50 Mantle $2,280 547.20 65 Robinson 35 34 178.50 40 Williams 2,550 561.00 65 Vaughn 44 46 423.20 40 Employees Mantle and Williams...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 2016: Employee Hours Worked Hourly Rate Weekly Salary Federal Income Tax U.S. Savings Bonds Aaron 43 $70 $689.44 $120 Cobb 43 58 539.92 130 Clemente 45 64 668.44 140 DiMaggio 39 52 377.80 0 Griffey, Jr. 48 64 749.08 150 Mantle $1,700 317.45 140 Robinson 38 53 387.32 150 Williams 2,100 426.24 145 Vaughn 48 64 770.08 60 Employees Mantle and Williams are...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 2016: Employee Hours Worked Hourly Rate Weekly Salary Federal Income Tax U.S. Savings Bonds Aaron 43 $70 $689.44 $105 Cobb 43 58 539.92 115 Clemente 45 64 668.44 125 DiMaggio 39 52 377.80 0 Griffey, Jr. 48 64 749.08 135 Mantle $1,700 317.45 125 Robinson 38 53 387.32 135 Williams 2,100 426.24 130 Vaughn 48 64 770.08 80 Employees Mantle and Williams are...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December...
The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 20Y8: Employee Hours Worked Hourly Rate Weekly Salary Federal Income Tax Retirement Savings Aaron 43 $70 $689.44 $100 Cobb 43 58 539.92 110 Clemente 45 64 668.44 120 DiMaggio 39 52 377.80 0 Griffey, Jr. 48 64 749.08 130 Mantle $1,700 317.45 120 Robinson 38 53 387.32 130 Williams 2,100 426.24 125 Vaughn 48 64 770.08 40 Employees Mantle and Williams are office...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT