Question

In: Accounting

Estimated sales 15,000 books Beginning inventory 0 books Average selling price $81 per book Variable production...

Estimated sales

15,000

books

Beginning inventory

0

books

Average selling price

$81

per book

Variable production costs

$54

per book

Fixed production costs

$225,000

per semester

The fixed cost allocation rate is based on expected sales and is therefore equal to

$ 225,000/15,000 books​ =$ 15 per book.

Managers who are paid a bonus that is a function of gross margin may be inspired to produce a product in excess of demand to maximize their own bonus. There are metrics to discourage managers from producing products in excess of demand. Do you think the following metrics will accomplish this​ objective? Show your work.

a. Incorporate a charge of 5​% of the cost of the ending inventory as an expense for evaluating the manager. ​(Complete all answer boxes. For a​ $0 change, make sure to enter​ "0" in the appropriate​ cell.) Please show formulas for solving

15,000 books

21,000 books

31,500 books

Gross margin

Ending inventory charge

Adjusted gross margin

Solutions

Expert Solution

15,000 books 21,000 books 31,500 books
Gross margin (Requirement 1) $            1,80,000.00 $     2,70,000.00 $      4,27,500.00
Ending inventory charge (Requirement 2) $                           -    $     4,14,000.00 $    11,38,500.00
Adjusted gross margin (Requirement 3) $            1,80,000.00 $     2,49,300.00 $      3,70,575.00
Adjusting for ending inventory Does to some degree  mitigate the increase in inventory associated with excess production.​ Therefore, it may be Difficult  to mechanically compensate for all of the increased income. In​ addition, it does nothing to hold the manager responsible for the poor decisions from the organization's standpoint.
Requirement 1
15,000 Books 21,000 Books 31,500 Books
Revenues (15000 x  $81 per book) $          12,15,000.00 $   12,15,000.00 $    12,15,000.00
Cost of goods sold (15000 x ($54+ $15) $          10,35,000.00 $   10,35,000.00 $    10,35,000.00
Production - volume variance (U/F?) $                           -    $       -90,000.00 $     -2,47,500.00
N F F
Net Cost of Goods Sold $          10,35,000.00 $     9,45,000.00 $      7,87,500.00
Gross Margin $            1,80,000.00 $     2,70,000.00 $      4,27,500.00
Production Volume variance =   Budgeted fixed cost – fixed overhead rate × production
Production Volume variance  (15000) =   $225000 - ($15 x 15000) 0 N
Production Volume variance  (21000) =   $225000 - ($15x 21000) -90000 F
Production Volume variance  (31500) =   $225000 - ($15 x 31500) -247500 F
Requirement 2: Calculate ending inventory in units and in dollars for each production level.
Requirement 2 15,000 Books 21,000 Books 31,500 Books
Beginning Inventory 0 0 0
Production 15000 21000 31500
Sales 15000 15000 15000
Ending Inventory 0 6000 16500
Cost Per Book (54+ 15) 69 69 69
Cost of Ending Inventory 0 414000 1138500
Requirement 3: Managers who are paid a bonus that is a function of gross margin may be inspired to produce a product in excess of demand to maximize their own bonus. There are metrics to discourage managers from producing products in excess of demand. Do you think the following metrics will accomplish this​ objective? Show your work.
a. Incorporate a charge of 5% of the cost of the ending inventory as an expense for evaluating the manager. 15,000 Books 21,000 Books 31,500 Books
Gross Margin $            1,80,000.00 $     2,70,000.00 $      4,27,500.00
Ending inventory charge $                           -    $      (20,700.00) $        (56,925.00)
Adjusted gross margin $            1,80,000.00 $     2,49,300.00 $      3,70,575.00

Related Solutions

The estimated project cost, sales, rent, selling price and production and selling costs of the product...
The estimated project cost, sales, rent, selling price and production and selling costs of the product of a new project are given below. Compute the NPV and payback period of the project. Assume the costs are incurred at the beginning of the year, zero depreciation, no taxes, and discount rate as 10%, Show all calculations. Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Project cost (Rs. Million) 40 70 Rent for land, buildings and machinery (Rs....
Beginning inventory 0   Units produced 27,000   Units sold 18,500   Selling price per unit $ 93   ...
Beginning inventory 0   Units produced 27,000   Units sold 18,500   Selling price per unit $ 93      Selling and administrative expenses:      Variable per unit $ 3      Fixed (total) $ 518,000   Manufacturing costs:      Direct materials cost per unit $ 24      Direct labour cost per unit $ 14      Variable manufacturing overhead cost per unit $ 9      Fixed manufacturing overhead cost (total) $ 756,000 Since the new case is unique in design, management is anxious to see how profitable it will be and has...
    Per Unit .       % of sales Selling price . $75 . 100% Variable Expenses ....
    Per Unit .       % of sales Selling price . $75 . 100% Variable Expenses . $45 . 60% Contribution Margin . $30 40% Fixed expenses are $75,000 per month and the company is selling 3,000 units per month. 2. Refer to the original data . Management is considering using higher quality components that would increase variable cost by $3 per unit. The manager believes that the higher quality product would increase sales by 15% per month. Should the higher...
No of units   Fixed costs   Total variable costs   Total Costs   Total Sales 0   15,000   0   15,000  ...
No of units   Fixed costs   Total variable costs   Total Costs   Total Sales 0   15,000   0   15,000   0 50   15,000   10,500   25,500   15,000 100   15,000   21,000   36,000   30,000 150   15,000   31,500   46,500   45,000 200   15,000   42,000   57,000   60,000 250   15,000   52,500   67,500   75,000 300   15,000   63,000   78,000   90,000 Create a CVP graph.
Variable Costing—Sales Exceed Production The beginning inventory is 8,000 units. All of the units that were...
Variable Costing—Sales Exceed Production The beginning inventory is 8,000 units. All of the units that were manufactured during the period and 8,000 units of the beginning inventory were sold. The beginning inventory fixed manufacturing costs are $42 per unit, and variable manufacturing costs are $93 per unit. a. Determine whether variable costing operating income is less than or greater than absorption costing operating income. b. Determine the difference in variable costing and absorption costing operating income. $
A company has no beginning inventory and sales are estimated to be 20,000 units at $75...
A company has no beginning inventory and sales are estimated to be 20,000 units at $75 per unit. Also assume that sales will not change if more than 20,000 units are manufactured. My question is in manufacturing cost how did the variable unit cost become $35 and the fixed $20?
Sales per period 1,000 units Selling price $40 per unit Variable manufacturing cost $12 per unit...
Sales per period 1,000 units Selling price $40 per unit Variable manufacturing cost $12 per unit Selling expenses $5,100 plus 5% of selling price Administrative expenses $3,000 plus 20% of selling price note Note that some costs have variable components such as commissions on sales and shipping costs. The contribution margin ratio would be: A) 70%. B) 45%. C) 75%. D) 55%.
CVP Analysis Data Unit sales     20,000 units Selling price per unit $60 per unit Variable...
CVP Analysis Data Unit sales     20,000 units Selling price per unit $60 per unit Variable expenses per unit $45 per unit Fixed expenses $240,000 Enter a formula into each of the cells marked with a ? below Review Problem: CVP Relationships Compute the CM ratio and variable expense ratio Selling price per unit ? per unit Variable expenses per unit ? per unit Contribution margin per unit ? per unit CM ratio ? Variable expense ratio ? Compute the...
Book Journal Entries for the following transactions. Inventory includes the following: Beginning balance of $0. On...
Book Journal Entries for the following transactions. Inventory includes the following: Beginning balance of $0. On January 3, 2016 we purchased $22,000 (1000 units at $22) worth of inventory. 1,000 units of inventory was purchased on June 1 for $23/unit; and finally a 1,000 units on December 1 for $24/unit. 2,000 units were sold for $300/unit on December 20th ($120,000 in cash was received and the remaining will be collected in 2017). The rate used for determining uncollectible has been...
Sales price P15 per unit Variable costs: SG&A P2 per unit Production P4 per unit Fixed...
Sales price P15 per unit Variable costs: SG&A P2 per unit Production P4 per unit Fixed costs (total cost incurred for the year): SG&A P14,000 Production P20,000 During the first year, Sherrill Corporation manufactured 5,000 units and sold 3,800. There was no beginning or ending work-in-process inventory. 1. How much income before income taxes would be reported if Stanley uses absorption costing? 2. How much income before income taxes would be reported if variable costing was used? 3. Show why...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT