Campus Press produces textbooks for high school accounting courses. The company recently hired a new editor, Jean Green, to handle production and sales of books for an introduction to accounting course. Jean's compensation depends on the gross margin associated with sales of this book. Jean needs to decide how many copies of the book to produce. The following information is available for the fall semester 2017:
Estimated sales 22,000 books
Beginning inventory 0 books
Average selling price $81 per book
Variable production costs $51 per book
Fixed production costs $418,000 per semester
The fixed-cost allocation rate is based on expected sales and is
therefore equal to $ 418 comma 000/22 comma 000 books = $ 19 per
book.
Jean has decided to produce either 22,000, 27,500, or 29,700 books.
REQUIREMENTS:
1.
Calculate expected gross margin if Jean produces 22,000, 27,500,
or 29,700 books. (Make sure you include the production-volume
variance as part of cost of goods sold.)
2.
Calculate ending inventory in units and in dollars for each
production level.
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 10% of the cost of the ending inventory
as an expense for evaluating the manager.
b. Include nonfinancial measures when evaluating management and
rewarding performance.
1. Calculate expected gross margin if Jean produces 22,000,
27,500, or 29,700 books. (Make sure you include the
production-volume variance as part of cost of goods sold.)
Calculate the gross margin for each level of production. Begin with
22,000 books, then 27,500 books, and lastly 29,700 books. (Enter
a "0" for any zero balance accounts. If an account does not have
a variance, do not select a label.)
22,000 Books | 27,500 Books | 29,700 Books | |
Revenues | |||
Cost of goods sold | |||
Production - volume variance (U/F?) | |||
Net Cost of Goods Sold | |||
Gross Margin |
Requirement 2: Calculate ending inventory in units and in dollars
for each production level.
22,000 Books | 27,500 Books | 29,700 Books | |
Beginning Inventory | |||
Production | |||
Sales | |||
Ending Inventory | |||
Cost Per Book | |||
Cost of Ending Inventory |
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 10% of the cost of the ending inventory as an expense for evaluating the manager.
22,000 books | 27,500 books | 29,700 books | |
Gross Margin | |||
Ending inventory charge | |||
Adjusted gross margin |
Do you think the metric would accomplish the objective of discouraging managers from producing products in excess of demand?
Adjusting for ending inventory __________(Options: Does not, Does to some degree, will always) mitigate the increase in inventory associated with excess production. Therefore, it may be_______(Options: Difficult, easy) to mechanically compensate for all of the increased income. In addition, it _________(Options: does nothing to hold the manager responsible for the poor decisions, rewards the manager for increasing production which is a good decision) from the organization's standpoint.
b. Include nonfinancial measures when evaluating management and rewarding performance.
One nonfinancial measure is to compute the excess production ratio. Determine the formula, then compute the ratio at each production level.
# of books Production / Sales = Excess production ratio
Production / | Sales Units | =Excess Production Ratio | |
22,000 | = | ||
27,500 | = | ||
29,700 | = |
A ratio of ending inventory to beginning inventory is _______(Options: Not Possible, Possible)
The non-financial measures ________(Options: are only
needed if we don't use the inventory metric. ,must be incorporated
into the reward function of the manager to be useful.)
Requirement 1 | |||
22,000 Books | 27,500 Books | 29,700 Books | |
Revenues (22000 x $81 per book) | $ 17,82,000.00 | $ 17,82,000.00 | $ 17,82,000.00 |
Cost of goods sold (22000 x ($51 + $19) | $ 15,40,000.00 | $ 15,40,000.00 | $ 15,40,000.00 |
Production - volume variance (U/F?) | $ - | $ -1,04,500.00 | $ -1,46,300.00 |
N | F | F | |
Net Cost of Goods Sold | $ 15,40,000.00 | $ 14,35,500.00 | $ 13,93,700.00 |
Gross Margin | $ 2,42,000.00 | $ 3,46,500.00 | $ 3,88,300.00 |
Production Volume variance = Budgeted fixed cost – fixed overhead rate × production |
|||
Production Volume variance (22000) = $418000 - ($19 x 22000) |
0 | N | |
Production Volume variance (27500) = $418000 - ($19 x 27500) |
-104500 | F | |
Production Volume variance (29700) = $418000 - ($19 x 29700) | -146300 | F | |
Requirement 2: Calculate ending inventory in units and in dollars for each production level. | |||
Requirement 2 | 22,000 Books | 27,500 Books | 29,700 Books |
Beginning Inventory | 0 | 0 | 0 |
Production | 22000 | 27500 | 29700 |
Sales | 22000 | 22000 | 22000 |
Ending Inventory | 0 | 5500 | 7700 |
Cost Per Book (51 + 19 ) | 70 | 70 | 70 |
Cost of Ending Inventory | 0 | 385000 | 539000 |
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 10% of the cost of the ending inventory as an expense for evaluating the manager. | 22,000 books | 27,500 books | 29,700 books |
Gross Margin | $ 2,42,000.00 | $ 3,46,500.00 | $ 3,88,300.00 |
Ending inventory charge | 0 | -38500 | -53900 |
Adjusted gross margin | $ 2,42,000.00 | $ 3,08,000.00 | $ 3,34,400.00 |
Do you think the metric would accomplish the objective of discouraging managers from producing products in excess of demand? | |||
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. | |||
b. Include nonfinancial measures when evaluating management and rewarding performance. | |||
One nonfinancial measure is to compute the excess production ratio. Determine the formula, then compute the ratio at each production level. | |||
# of books Production / Sales = Excess production ratio | Production / | Sales Units | Excess Production Ratio |
22000 | 22000 | 1 | |
27,500 | 22000 | 1.25 | |
29,700 | 22000 | 1.35 | |
A ratio of ending inventory to beginning inventory is Not Possible | |||
The non-financial measures must be incorporated into the reward function of the manager to be useful. |
Campus Press produces textbooks for high school accounting courses. The company recently hired a new editor,...
Academia Press produces textbooks for high school accounting courses. The company recently hired a new editor, Bailey Green, to handle production and sales of books for an introduction to accounting course. Bailey's compensation depends on the gross margin associated with sales of this book. Bailey needs to decide how many copies of the book to produce. The following information is available for the fall semester 2017: i (Click the icon to view the information.) Bailey has decided to produce either...
Mountain Press produces textbooks for high school accounting courses. The company recently hired a new editor, Jan Green, to handle production and sales of books for an introduction to accounting course compensation depends on the gross margin associated with sales of this book. Jan needs to decide how many copies of the book to produce. The following information is available for the fall semester 201 i (Click the icon to view the information. Jan has decided to produce either 50.000,...
Horizon Press produces textbooks for high school accounting courses The company recently hired a new editor Jaden Green to handle production and sales of books for an introduction to accounting cours Jader's compensation depends on the gross margin associated with sales of this book Jaden needs to decide how many copies of the book to produce the following information is for the fall Semester 2017 (Click the icon to view the information) Jaden has decided to produce either 29,000, 37,700...
Academia Press produces textbooks for college courses. The company recently hired a new editor, Morgan White, to handle production and sales of books for an introduction to accounting course. Morgan's compensation depends on the gross margin associated with sales of this book. Morgan needs to decide how many copies of the book to produce. The following information is available for the fall semester 2013: i (Click the icon to view the information.) Morgan has decided to produce either 16,000, 20,000,...
ADM2341 Managerial Accounting Fall 2019 Solution: Chapter 6 Capstone Problems Q1) The books of Lionel Company, wholesalers of hand held calculators, reflected the following revenues and expenses for various months during the year ended December 31, 2008. August December May Sales in units 24,000 28,000 22,000 Sales revenues $336,000 $392,000 $308,000 Cost of Goods Sold ($60,000) ($70,000) (55,000) Gross Margin $276,000 $322,000 $253,000 Operating Expenses Advertising expense (35,000) (35,000) (35,000) Commissions (72,000) (84,000) (66,000) Selling expense (16,600) (18,600) (15,600) Operating...
Drop down options: Direct manuf. labor , Direct manuf labor hours , Direct materials , Machine hours, Output units produced , Total budgeted overhead costs Drop down option Requirement 7: increase or reduce Drop down option Requirement 8: coordinate and communicate across different parts of the organization create a framework for judging performance look for ways to increase sales and improve quality, efficiency and input prices. look for ways to improve quality and efficiency while also increasing input prices motivate...
11. A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations: Units in beginning inventory 0 Units produced 4,150 Units sold 4,050 Units in ending inventory 100 Variable costs per unit: Direct materials $ 44 Direct labor $ 46 Variable manufacturing overhead $ 9 Variable selling and administrative $ 7 Fixed costs: Fixed manufacturing overhead $ 87,150 Fixed selling and administrative $ 40,500 What is the variable costing unit product...
I am working on doing an analysis of a company for my accounting class. can you please review what I have and correct what I have wrong. Also, Help me with the ones I have left blank as I can not find the right information to solve these. Thank you so much!! Ratio: Formula: Year: Formula: Total: Current Ratio: Current Assets / Current Liabilities 2018 566,951 / 379,743 1.49 Acid-Test Ratio Cash + Short- Term Investments + Current Receivables /...
really need help i have been working on this for hours and barely made any progress, please complete second portion of hw problem from requirments 2-7 Requirements 1. Prepare Trenton's operating budget and cash budget for 2019 by quarter. Required schedules and budgets include: sales budget, production budget direct materials budget, direct labor budget, manufacturing overhead budget, cost of goods sold budget, selling and administrative expense budget, schedule of cash receipts, schedule of cash payments, and cash budget. Manufacturing overhead...
( please answer all the questions) The Trolley Trolley Toy Company manufactures toy building block sets for children. Trolley Trolley is planning for 2019 2019 by developing a master budget by quarters. Trolley Trolley's balance sheet for December December 31 31, 2018 2018, follows: Trolley Toy Company Balance Sheet December 31, 2018 Assets Current Assets: Cash 58,000 Accounts Receivable 22,000 Raw Materials Inventory 1,200 5,400 Finished Goods Inventory Total Current Assets 86,600 Property, Plant, and Equipment Equipment 142,000 (47,000) 95,000...