Margaret Rosenthal, accountant for Russell Manufacturing Company, prepared the following income statement for the quarter ending December 31, 2016. |
Sales | $ | 1,428,100 |
Purchases of materials (1) | 251,690 | |
Payroll (2) | 268,700 | |
Advertising | 38,100 | |
Administrative travel | 28,700 | |
Manufacturing utilities | 51,600 | |
Facility rental (3) | 85,000 | |
Depreciation (4) | 65,700 | |
Sales commissions | 52,000 | |
Annual insurance (manufacturing) | 51,000 | |
Office utilities | 23,500 | |
Management salaries (5) | 399,000 | |
Net income | $ | 113,110 |
Notes: | |
(1) | 80% of the materials were direct |
(2) | 70% direct labour; 30% indirect labour |
(3) | 80% related to manufacturing |
(4) | 75% 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,420 | $ | 8,740 | |
Work-in-progress | 8,620 | 10,000 | |||
Finished goods | 11,830 | 7,750 | |||
Required: |
1. | Not available in Connect. |
2. | Prepare a cost of goods manufactured statement for the quarter. |
3. | Prepare a revised income statement for the quarter. |
COST OF GOODS MANUFACTURED | |||
Work in process inventory, beginning | $ 8,620 | ||
Direct material cost: | |||
Direct materials inventory, beginning | $ 7,420 | ||
Materials purchased [251690*80%] | $ 2,01,352 | ||
Total materials available | $ 2,08,772 | ||
Direct materials inventory, ending | $ 8,740 | ||
Cost of DM used | $ 2,00,032 | ||
Direct labor [268700*70%] | $ 1,88,090 | ||
Factory overhead: | |||
Indirect material [251690*20%] | $ 50,338 | ||
Depreciation expense [65700*75%] | $ 49,275 | ||
Insurance expense | $ 51,000 | ||
Management salaries [399000*30%] | $ 1,19,700 | ||
Manufacturing utilities | $ 51,600 | ||
Indirect labor [268700*30%] | $ 80,610 | ||
Rent expense-Factory facility [85000*80%] | $ 68,000 | ||
Total factory overhead | $ 4,70,523 | ||
Manufacturing cost for the month | $ 8,58,645 | ||
Total manufacturing cost | $ 8,67,265 | ||
Work in process, Ending | $ 10,000 | ||
Cost of goods manufactured | $ 8,57,265 | ||
INCOME STATEMENT | |||
Sales revenue | $ 14,28,100 | ||
Cost of goods sold: | |||
Finished goods inventory, beginning | $ 11,830 | ||
Cost of goods manufactured | $ 8,57,265 | ||
Cost of goods available for sale | $ 8,69,095 | ||
Less: Finished goods inventory, Ending | $ 7,750 | ||
Cost of goods sold | $ 8,61,345 | ||
Gross margin | $ 5,66,755 | ||
Operating expenses: | |||
Selling expenses: | |||
Advertising expenses | $ 38,100 | ||
Sales commissions | $ 52,000 | ||
Management salaries [399000*70%] | $ 2,79,300 | ||
Rent expense [85000*20%] | $ 17,000 | ||
Administrative travel | $ 28,700 | ||
Depreciation expense [65700*25%] | $ 16,425 | ||
Office utilities | $ 23,500 | ||
Total operating expense | $ 4,55,025 | ||
Net income | $ 1,11,730 |
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, 2016 Sales Purchases of materials (1) $ 1,428,100 251,690 268,700 38,100 28,700 51,600 85,000 65,700 52,000 51,000 23,500 399,000 Payroll (2) Advertising Administrative travel Manufacturing utilities Facility rental (3) Depreciation (4) Sales commissions Annual insurance (manufacturing) Office utilities Management salaries (5) Net income $ 113,110 Notes (1) 80% of the materials were direct (2) 70% direct labour, 30% indirect labour (3) 80%...
value: 10.00 points Margaret Rosenthal, accountant for Russell Manufacturing Company, prepared the following income statement for the quarter ending December 31, 2016. Sales Purchases of materials (1) Payroll (2) Advertising Administrative travel Manufacturing utilities Facility rental (3) Depreciation (4) Sales commissions Annual insurance (manufacturing) Office utilities Management salaries (5) Net income $ 1,378,600 246,740 266,900 37,200 27,800 49,800 92,000 63,900 43,000 42,000 22,600 390,000 96,660 Notes: (1) 80% of the materials were direct (2) 70% direct labour; 30% indirect labour...
value: 10.00 points Margaret Rosenthal, accountant for Russell Manufacturing Company, prepared the following income statement for the quarter ending December 31, 2016. Sales Purchases of materials (1) Payroll (2) Advertising Administrative travel Manufacturing utilities Facility rental (3) Depreciation (4) Sales commissions Annual insurance (manufacturing) Office utilities Management salaries (5) Net income $ 1,378,600 246,740 266,900 37,200 27,800 49,800 92,000 63,900 43,000 42,000 22,600 390,000 96,660 Notes: (1) 80% of the materials were direct (2) 70% direct labour; 30% indirect labour...
An accountant for Lisbon Company, prepared the following amounts to include on the financial statements for the period ending September 30, 2021. Include calculation/formula. Sales Purchases of materials Manufacturing labor Advertising Administrative travel Manufacturing utilities Facility rental Depreciation Sales commissions Insurance Office utilities Management salaries 1,200,000 250,000 270,000 37,000 27,000 49,000 90,000 60,000 31,000 40,000 25,000 380,000 • The purchase of materials included 20% indirect materials. 40% of the manufacturing labor was for indirect manufacturing labor The facility was used...
PART A Pat Fike, accountant for Nozama Company, prepared the following amounts to include on the financial statements for the period ending August 31, 20XX. Sales S1,200,000 Purchases of materials 250,000 Manufacturing labor 270,000 Advertising 37.000 Administrative travel 27,000 Manufacturing utilities 49,000 Facility rental 90,000 Depreciation 60,000 Sales commissions 31,000 Insurance 40,000 Office utilities 25,000 Management salaries 380,000 • The purchase of materials included 20% indirect materials. • 40% of the manufacturing labor was for indirect manufacturing labor • The...
Statement of Cost of Goods Manufactured and Income Statement for a Manufacturing Company The following information is available for Shanika Company for 20Y6: Inventories Materials Work in process 768,240 Finished goods January 1 December 31 $537,770 731,370 747,500 $426,800 738,360 Advertising expense Depreciation expense-office equipment Depreciation expense-factory equipment Direct labor Heat, light, and power-factory Indirect labor Materials purchased Office salaries expense Property taxes-factory Property taxes-headquarters building Rent expense-factory Sales Sales salaries expense Supplies-factory Miscellaneous costs-factory $365,150 51,630 69,370 828,170 27,430...
Howard Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise noted: Work-in-process inventory (January 1) $ 140,400 Work-in-process inventory (March 31) 171,000 Finished goods inventory (January 1) 540,000 Finished goods inventory (March 31) 510,000 Direct materials used 420,000 Indirect materials used 84,000 Direct manufacturing labor 480,000 Indirect manufacturing labor 186,000 Property taxes on manufacturing plant building 28,800 Salespersons' company vehicle costs 12,000 Depreciation of manufacturing equipment 264,000 Depreciation of office equipment 123,600 Miscellaneous plant...
Pat Fike, accountant for Nozama Company, prepared the following amounts to include on the financial statements for the period ending August 31, 20XX. Sales $1,200,000 Purchases of materials 250,000 Manufacturing labor 270,000 Advertising 37,000 Administrative travel 27,000 Manufacturing utilities 49,000 Facility rental 90,000 Depreciation 60,000 Sales commissions I 31,000 Insurance 40,000 Office utilities 25,000 Management salaries 380,000 The purchase of materials included 20% indirect materials. 40% of the manufacturing labor was for indirect manufacturing labor The facility was used partly...
: You are an accountant of a medium-sized manufacturing company. You prepared the income statement for 2018 that showed net income of $10 million and a statement of cash flows, using the indirect method, that showed cash flow from operating activities of negative $10 million. This just didn't make sense to your boss. Prepare a memo explaining: 1. How net income could be positive and operating cash flows negative. Include in your report: 2. How operating cash flows using the...
Statement of Cost of Goods Manufactured and Income Statement for a Manufacturing Company The following information is available for Shanika Company for 20Y6: Inventories January 1 December 31 Materials $216,380 $270,480 Work in process 389,480 367,850 Finished goods 374,340 375,970 Advertising expense $183,660 Depreciation expense-office equipment 25,970 Depreciation expense-factory equipment 34,890 Direct labor 416,540 Heat, light, and power-factory 13,790 Indirect labor 48,690 Materials purchased 408,420 Office salaries expense 142,540 Property taxes-factory 11,360 Property taxes-headquarters building 23,530 Rent expense-factory 19,200 Sales...