Purchase Solution

Absorption Method: Calculating Bonuses and Subjects

Not what you're looking for?

Ask Custom Question

Basic Budget
Units in beginning inventory 0
Units produced 400,000
Units sold 400,000
Units in ending inventory 0

Variable costs per unit:
Direct materials $57.20
Direct labor 15.00
Variable manufacturing overhead 5.00
Variable selling and administrative 10.00

Total variable cost per unit $87.20

Fixed costs:
Fixed manufacturing overhead $6,888,000
Fixed selling and administrative 4,560,000

Total fixed costs $11,448,000

Budge Income Statement

Sales (400,000 units x $120 per unit) $48,000,000
Cost of goods sold (400,000 units x $94.42 per unit) 37,768,000
Gross Margin 10,232,000
Selling and administrative expenses:
Variable selling and administrative
(400,000 units x $10 per unit) 4,000,000
Fixed selling and administrative 4,560,000 8,560,000

Net operating income $1,672,000

-A profit goal of $2,000,000 for the upcoming year. To provide incentives, it has been agreed that bonuses for top managers of $10,000 to $25,000 each if the profit goal is met. They would be all or nothing. If the net operating income turned out to be $2,000,000 or more, the bonus would be paid.

1-assuming that the company does not build up its inventory and selling price and cost structure remain the same, how many devices would have to be sold to meet the net operating goal of $2,000,000?

2-Verify your answer by constructing a revised budget and budgeted absorption costing income statement that yields a net operating income of $2,000,000.

3-After realizing by October of the next year, it was clear the company would not make the $2,000,000 target goal. It looked like the company would wind up the year as planned with sales of 400,000 units, no ending inventories and a profit of $1,672,000.

-Managers pointed out that the present rate of sales there is enough capacity to produce tens of thousands of additional devices for the warehouse and thereby shift fixed manufacturing overhead costs to another year in order to still get their bonuses.

If sales are 400,000 units for the year and the selling price and cost structure remain the same, how many units would have to be produced in order to show a profit of at least $2,000,000 under absorption costing?

4-Verify the answer by constructing an absorption costing income statement.

5-Do you think the plan should be approved to build ending inventories in order to attain the target profit?

6-What advice would you share about giving bonuses in the future?

Purchase this Solution

Solution Summary

This solution provides a complete computation of the given finance problem in Excel.

Purchase this Solution


Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.