Question

In: Accounting

Margaret Rosenthal, accountant for Russell Manufacturing Company, prepared the following income statement for the quarter ending...

Margaret Rosenthal, accountant for Russell Manufacturing Company, prepared the following income statement for the quarter ending December 31, 2019.

Sales $ 1,384,100
Purchases of materials (1) 247,290
Payroll (2) 267,100
Advertising 37,300
Administrative travel 27,900
Manufacturing utilities 50,000
Facility rental (3) 93,000
Depreciation (4) 64,100
Sales commissions 44,000
Annual insurance (manufacturing) 43,000
Office utilities 22,700
Management salaries (5) 391,000
Net income $ 96,710

Notes:

(1) 90% of the materials were direct
(2) 80% direct labour; 20% indirect labour
(3) 80% related to manufacturing
(4) 80% related to manufacturing
(5) 30% related to manufacturing

Furthermore, Rosenthal compiled the following information with respect to inventories for the quarter (note that the company does not maintain inventories of indirect materials).

Beginning Ending
Direct materials $ 7,020 $ 8,100
Work in process 8,220 9,360
Finished goods 11,430 7,510

Required:
1. This part of the question is not part of your Connect assignment.

2. Prepare a cost of goods manufactured statement for the quarter.



3. Prepare a revised income statement for the quarter.

Solutions

Expert Solution

NOTES
1 The cost of goods manufactured (COGM), also called cost of goods completed, calculates the total value of inventory that was produced during the period and is ready for sale. In other words, this is the total amount of expenses incurred to turn work in process inventory into finished goods.
2 The cost of goods manufactured equation is calculated by adding the total manufacturing costs; including all direct materials, direct labor, and factory overhead; to the beginning work in process inventory and subtracting the ending goods in process inventory. This formula will leave you with only the cost of goods that were completed during the period.
3 The formula to calculate the COGM is:
Add: Direct Materials Used
Add: Direct Labor Used
Add: Manufacturing Overhead
Add: Beginning Work in Process (WIP) Inventory
Deduct: Ending Work in Process (WIP) Inventory
COGM
4 Cost of goods sold, often abbreviated COGS, is a managerial calculation that measures the direct costs incurred in producing products that were sold during a period. In other words, this is the amount of money the company spent on labor, materials, and overhead to manufacture or purchase products that were sold to customers during the year.
5 The cost of goods sold formula is calculated by adding purchases for the period to the beginning inventory and subtracting the ending inventory for the period.

SOLUTION

PART 1:

COST OF GOODS MANUFACTURED STATEMENT Explanation
$
Direct materials :
Beginning inventory 7,020 Given in question
Add : Purchases 2,22,561 247290*90%
less : Ending inventory 8,100 Given in question
Direct materials used 2,21,481 (7020+222561-8100)
Direct Labour : 2,13,680 267100*80%
Overhead :
Indirect materials 24,729 247290*10%
Indirect labour 53,420 267100*20%
Faclility rental 74,400 93000*80%
Depreciation 51,280 64100*80%
Management Salaries 1,17,300 391000*30%
Insurance 10,750 (43000/4)
Manufacturing Utilities 50,000 Given in question
3,81,879 Total Overhead
Total manufacturing costs 817040 (221481+213680+381879)
Add : Beginning WIP Inventory 8,220 Given in question
Deduct : Ending WIP Inventory 9,360 Given in question
Cost of goods manufactured 8,15,900 (817040+8220-9360)

PART 2:

RUSSELL MANUFACTURING COMPANY Explanation
INCOME STATEMENT
For the Quarter Ending December 31,2019
$
Sales 13,84,100 Given in question
Cost of Goods Sold
Beginning FG inventory 11,430 Given in question
Add : Cost of goods manufactured 8,15,900 Refer above table
Goods available for sale 8,27,330 (11430+815900)
Deduct : Ending FG inventory 7,510 Given in question
Cost of Goods Sold 8,19,820 (827330-7510)
Gross margin 5,64,280 (1384100-819820)
Deduct : S&A Expenses
Advertising 37,300 Given in question
Administrative travel 27,900 Given in question
Facility rental 18,600 93000*20%
Depreciation 12,820 64100*20%
Sales commission 44,000 Given in question
Management Salaries 2,73,700 391000*70%
Office utilities 22,700 Given in question
4,37,020 Total S&A Expenses
Net income 1,27,260 (564280-437020)

Related Solutions

Income Statement An inexperienced accountant for Prestwick Company prepared the following income statement for the month...
Income Statement An inexperienced accountant for Prestwick Company prepared the following income statement for the month of August, current year. PRESTWICK COMPANY AUGUST 31, CURRENT YEAR Revenues:  Services provided to customers $17,000  Investment by stockholders 5,000  Loan from bank  15,000 $37,000 Expenses:  Payments to long-term creditors $11,700  Expenses required to provide   services to customers 7,800  Purchase of land  16,000   35,500 Net income $  1,500 Statement of Cash Flows Prepare a revised income statement in accordance with generally accepted accounting principles....
The management accountant for Tony's Skateboard Company has prepared the following segmented income statement for each...
The management accountant for Tony's Skateboard Company has prepared the following segmented income statement for each of its three product lines.                                                Jammer         Cruise        Flight       Total       Sales                                $400,000     $250,000    $350,000 $1,000,000       Variable expenses             260,000       150,000      190,000   600,000       Contribution margin          140,000       100,000      160,000   400,000       Other costs                        20,000       30,000      20,000   70,000       Segment margin                120,000         70,000      140,000   330,000       Allocated avoidable costs 30,000       30,000      20,000   80,000       Segment income                 90,000         40,000      120,000   250,000       Allocated corporate costs 50,000      ...
The following incorrect income statement was prepared by the accountant of the Axel Corporation: AXEL CORPORATION...
The following incorrect income statement was prepared by the accountant of the Axel Corporation: AXEL CORPORATION Income Statement For the Year Ended December 31, 2021 Revenues and gains: Sales revenue $ 680,000 Interest revenue 41,000 Gain on sale of investments 88,000 Total revenues and gains 809,000 Expenses and losses: Cost of goods sold $ 370,000 Selling expense 68,000 Administrative expense 88,000 Interest expense 25,000 Restructuring costs 64,000 Income tax expense 48,500 Total expenses and losses 663,500 Net Income $ 145,500...
The following incorrect income statement was prepared by the accountant of the Axel Corporation: AXEL CORPORATION...
The following incorrect income statement was prepared by the accountant of the Axel Corporation: AXEL CORPORATION Income Statement For the Year Ended December 31, 2018 Revenues and gains: Sales $ 650,000 Interest and dividends 38,000 Gain on sale of investments 85,000 Total revenues and gains 773,000 Expenses and losses: Cost of goods sold $ 355,000 Selling expenses 65,000 Administrative expenses 85,000 Interest 32,000 Restructuring costs 61,000 Income taxes 70,000 Total expenses and losses 668,000 Net Income $ 105,000 Earnings per...
The following incorrect income statement was prepared by the accountant of the Axel Corporation: AXEL CORPORATION...
The following incorrect income statement was prepared by the accountant of the Axel Corporation: AXEL CORPORATION Income Statement For the Year Ended December 31, 2021 Revenues and gains: Sales revenue $ 760,000 Interest revenue 49,000 Gain on sale of investments 96,000 Total revenues and gains 905,000 Expenses and losses: Cost of goods sold $ 410,000 Selling expense 76,000 Administrative expense 96,000 Interest expense 33,000 Restructuring costs 72,000 Income tax expense 54,500 Total expenses and losses 741,500 Net Income $ 163,500...
Shown below is an income statement for 2017 that was prepared by a junior accountant at...
Shown below is an income statement for 2017 that was prepared by a junior accountant at Junior Corporation. Junior Corporation Income Statement December 31, 2017        Sales revenue..........................................................................................................       $975,000        Investment revenue...................................................................................................           19,500        Cost of merchandise sold..........................................................................................       (408,500)        Selling expenses......................................................................................................       (155,000)        Administrative expense.............................................................................................       (215,000)        Interest expense.......................................................................................................        (13,000)        Income before special items.......................................................................................         203,000        Special items               Loss on disposal of a segment of the business........................................................         (30,000)              ...
An inexperienced accountant prepared this condensed income statement for Simon Company, a retail firm that has...
An inexperienced accountant prepared this condensed income statement for Simon Company, a retail firm that has been in business for a number of years. SIMON COMPANY Income Statement For the Year Ended December 31, 2017 Prepare a correct multiple-step income statement. Revenues Net sales $850,000 Other revenues 22,000 Cost of goods sold 555,000 Gross profit 317,000 Operating expenses Selling expenses 109,000 Administrative expenses 103,000 Net earnings $105,000 As an experienced, knowledgeable accountant, you review the statement and determine the following...
J Coronado, Ltd. is a local coat retailer. The store’s accountant prepared the following income statement...
J Coronado, Ltd. is a local coat retailer. The store’s accountant prepared the following income statement for the month ended January 31: Sales revenue $ 759,000 Cost of goods sold 313,500 Gross margin 445,500 Operating expenses   Selling expense $ 23,770   Administrative expense 50,710 74,480 Net operating income $ 371,020 Coronado sells its coats for $250 each. Selling expenses consist of fixed costs plus a commission of $6.50 per coat. Administrative expenses consist of fixed costs plus a variable component equal...
J Bonita, Ltd. is a local coat retailer. The store’s accountant prepared the following income statement...
J Bonita, Ltd. is a local coat retailer. The store’s accountant prepared the following income statement for the month ended January 31: Sales revenue $ 769,000 Cost of goods sold 584,440 Gross margin 184,560 Operating expenses   Selling expense $ 23,970   Administrative expense 51,470 75,440 Net operating income $ 109,120 Bonita sells its coats for $250 each. Selling expenses consist of fixed costs plus a commission of $6.50 per coat. Administrative expenses consist of fixed costs plus a variable component equal...
Below is Salem Company’s income statement for 2018 that was prepared by an inexperienced accountant. Salem...
Below is Salem Company’s income statement for 2018 that was prepared by an inexperienced accountant. Salem Company Income Statement As of December 31, 2018 Revenues: Sales revenue ……………..…………………………………… $298,000 Wages payable…………..……………………………………….. 4,000 Gain on sale of investment…………………………………….. 5,250 Deferred revenue………………………………………………. 2,500 Interest payable………………………………………………… 1,000 Accumulated depreciation……………………………………… 10,000 Total revenues ………………………………………………….. $320,750 Less operating expenses: Selling expenses….……………………… …………………. $32,250 Research and development expense………………….…….. 4,750 Prepaid advertising …….…………………………………. 3,000 Indirect manufacturing labor cost..………………………… 16,200 Utilities expense..…. .....................………………………… 10,200 Direct manufacturing labor cost....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT