| As Given | Figures | Index |
| Selling Price (in $) | 82 | A |
| Variable Cost (in $) | 47 | B |
| Fixed Cost (in $) | 25 | C |
| Estimated Unit Sales | 19,000 | D |
| Charge on Inventory | 5% | D1 |
Requirement 1
| Units | |||||
| Index | Particulars | Formula | 19,000 | 26,600 | 28,500 |
| E | Revenues (in $) | Units X (A) | 15,58,000.00 | 21,81,200.00 | 23,37,000.00 |
| F | Cost of Goods Sold (in $) | Units X (B+C) | 13,68,000.00 | 19,15,200.00 | 20,52,000.00 |
| G | Production of Volume Variance* (in $) | (Units - D) X C | 0.00 | -1,90,000.00 | -2,37,500.00 |
| H | Net cost of goods sold (in $) | F-G | 13,68,000.00 | 17,25,200.00 | 18,14,500.00 |
| I | Gross Margin (in $) | E-H | 1,90,000.00 | 4,56,000.00 | 5,22,500.00 |
* Production Volume Variance - It is given that the Fixed cost is per semester and is allocated based on estimated sales. While calculating the Cost of Goods Sold (F), unit rate of fixed cost is used for all the three level of unit productions. However, the fixed cost will not increase throughout the semester. Hence the difference is calculated as volume variance.
Requirement 2
| Units | |||||
| Index | Particulars | Formula | 19,000 | 26,600 | 28,500 |
| Beginning Inventory (in Units) | As Given | 0.00 | 0.00 | 0.00 | |
| Production (in Units) | As Given | 19,000.00 | 26,600.00 | 28,500.00 | |
| Sales (in Units) | D | 19,000.00 | 19,000.00 | 19,000.00 | |
| J | Ending Inventory (in Units) | Units - D | 0.00 | 7,600.00 | 9,500.00 |
| K | Cost per book (in $) | H / Units | 72.00 | 64.86 | 63.67 |
| L | Cost of ending inventory (in $) | J * K | 0.00 | 4,92,914.29 | 6,04,833.33 |
Requirement 3
| Units | |||||
| Index | Particulars | Formula | 19,000 | 26,600 | 28,500 |
| Gross Margin | I | 1,90,000.00 | 4,56,000.00 | 5,22,500.00 | |
| M | Ending Inventory charge | I X D1 | - | 24,645.71 | 30,241.67 |
| N | Adjusted Gross Margin | I - M | 1,90,000.00 | 4,31,354.29 | 4,92,258.33 |
| Excess Production | (Units - D) / D | 0% | 40% | 50% | |
For the below two requirements, the question is not so clear and the drop down list is not visible to be answered for:


Academia Press produces textbooks for high school accounting courses. The company recently hired a new editor,...
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...
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,...
QUESTION 2- (15 points) The following data are from ABC Inc. accounting records at December 31, 2018: Sales (22,000 units) Raw materials inventory, beginning Raw materials inventory, ending Purchases of raw materials Direct labour Prime costs (total) Conversion costs (total) Commissions Work-in-process inventory, beginning Work-in-process inventory, ending Depreciation-equipment Finished goods inventory, beginning (6,000 units) Finished goods inventory, ending (4,000 units) Rent-factory Property taxes: factory Administration General office salaries $1,320,000 76.000 To be determined 232,000 To be determined 512,000 540.000 10%...
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 50,000 70,000 105,000 75,000 80,000 95,000 Selling price per unit $7 Chapter 8: Applying Excel Data Year 3 Quarter 1 2 3 4 1...
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...
Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Data Budgeted unit Sales Selling price per unit 50,000 70.000 115,000 5,000 85,000 100.000 D Chapter 8: Applying Excel Data Year 3 Quarter 5 Budgeted unit sales 50.000 70,000 115,000 60,000 $5,000...
57. During the year, a manufacturing company had the following operating Beginning work-in-process inventory Beginning finished goods inventory Direct materials used in production Direct labor Manufacturing overhead incurred Ending work-in-process inventory Ending finished goods inventory S 45,000 $190,000 $308,000 $475,000 $250,000 $ 67,000 $ 89,000 results: Xist o h oear? A. $1,011,000 B. $1,134,000 C. $1,033,000 D. $1,112,000 58. During April, the CJG Manufacturing Company had the following operating Sales revenue Gross margin Ending work-in-process inventory Beginning work-in-process inventory Ending...
Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 3 Quarter Year 2 Quarter Data 1 2 Budgeted unit sales 45,000 65,000 115,000 70,000 Selling price per unit $ 7 80,000 100,000 | 1 Chapter 8: Applying Excel Data 1 45,000 2 65,000 3 115,000 Year...