The following selected information was extracted from the 20x1 accounting records of Lone Oak Products:
Raw material purchases | $ | 176,000 | |
Direct labor | 256,000 | ||
Indirect labor | 108,000 | ||
Selling and administrative salaries | 133,000 | ||
Building depreciation* | 80,000 | ||
Other selling and administrative expenses | 195,000 | ||
Other factory costs | 343,000 | ||
Sales revenue ($130 per unit) | 1,495,000 | ||
*Seventy-five percent of the company's building was devoted to production activities; the remaining 25 percent was used for selling and administrative functions.
Inventory data:
January 1 | December 31 | |||||
Raw material | $ |
15,900 |
$ |
18,200 |
||
Work in process |
35,800 |
62,100 | ||||
Finished goods* |
113,100 |
97,900 | ||||
*The January 1 and December 31 finished-goods inventory consisted of 1,350 units and 1,190 units, respectively.
a. Calculate Lone Oak’s manufacturing overhead for the year.
b. Calculate Lone Oak’s cost of goods manufactured.
c. Compute the company’s cost of goods sold.
d. Determine net income for 20x1, assuming a 30% income tax rate.
e. Determine the number of completed units manufactured during the year.
a. |
Calculation of Lone Oak's Manufacturing Overhead for the year: |
||
Indirect labor |
$ 108,000 |
||
Building Depreciation = 80000*75% = |
$ 60,000 |
||
Other Factory Costs |
$ 346,000 |
||
Lone Oak's Manufacturing Overhead for the year = |
$ 511,000 |
||
b. |
Calculation of Lone Oak's Cost of Goods Manufactured for the year: |
||
Direct Material : |
|||
Raw Material Purchase for the year |
$ 176,000 |
||
Add: Raw Material Inventory Jan. 1, 20x1 |
$ 15,900 |
||
Less: Raw Material Inventory Dec. 31, 20x1 |
$ (18,200) |
||
Total Direct Material used |
$ 173,700 |
||
Direct Labor |
$ 256,000 |
||
Manufacturing Overhead |
$ 511,000 |
||
Total Manufacturing Costs |
$ 940,700 |
||
Add: Work in Process inventory, Jan 1, 20x1 |
$ 35,800 |
||
Less: Work in Process inventory, Dec 31, 20x1 |
$ (62,100) |
||
Total Cost of Goods Manufactured |
$ 914,400 |
||
c. |
Calculation of Lone Oak's Cost of Goods sold for the year: |
||
Total Cost of Goods Manufactured |
$ 914,400 |
||
Add: Finished Goods inventory, Jan 1, 20x1 |
$ 113,100 |
||
Less: Finished Goods inventory, Dec 31, 20x1 |
$ (97,900) |
||
Lone Oak's Cost of Goods sold for the year = |
$ 929,600 |
||
d |
Calculation of Net income: |
||
Sales Revenue |
$ 1,495,000 |
||
Less: Cost of Goods sold |
$ (929,600) |
||
Gross Revenue |
$ 565,400 |
||
Less: Selling and administrative Expenses: |
|||
Selling and administrative Salaries |
$ 133,000 |
||
Building Depreciation = 80000*25% = |
$ 20,000 |
||
Other Selling and administrative expenses |
$ 195,000 |
||
Total Selling and administrative Expenses |
$ 348,000 |
||
Income before tax |
$ 217,400 |
||
Less: Tax @ 30% |
$ (65220) |
||
Net Income |
$ 152,180 |
||
e. | Number of units manufactured during the year: | ||
Sales [1,495,000/130] | 11500 | ||
Add: ending inventory | 1190 | ||
Less: beginning inventory | (1350) | ||
Number of units manufactured | 11340 |
The following selected information was extracted from the 20x1 accounting records of Lone Oak Products: Raw...
The following selected information was extracted from the 20x1 accounting records of Lone Oak Products: Raw material purchases $ 175,000 Direct labor 255,000 Indirect labor 107,000 Selling and administrative salaries 133,000 Building depreciation* 80,000 Other selling and administrative expenses 195,000 Other factory costs 343,000 Sales revenue ($130 per unit) 1,495,000 *Seventy-five percent of the company's building was devoted to production activities; the remaining 25 percent was used for selling and administrative functions. Inventory data: January 1 December 31 Raw material...
[The following information applies to the questions displayed below.] The following selected information was extracted from the 20x1 accounting records of Lone Oak Products: Raw material purchases $ 175,000 Direct labor 254,000 Indirect labor 109,000 Selling and administrative salaries 133,000 Building depreciation* 80,000 Other selling and administrative expenses 195,000 Other factory costs 343,000 Sales revenue ($130 per unit) 1,495,000 *Seventy-five percent of the company's building was devoted to production activities; the remaining 25 percent was used for selling and administrative...
Required information [The following information applies to the questions displayed below.] The following selected information was extracted from the 20x1 accounting records of Lone Oak Products: Raw material purchases $ 175,000 Direct labor 254,000 Indirect labor 109,000 Selling and administrative salaries 133,000 Building depreciation* 80,000 Other selling and administrative expenses 195,000 Other factory costs 344,000 Sales revenue ($130 per unit) 1,495,000 *Seventy-five percent of the company's building was devoted to production activities; the remaining 25 percent was used for selling...
The following information was extracted from the accounting records of Pickin’ and Grinnin’, LLC, a manufacturer of guitars: Beginning Raw Materials Inventory $375,000 Ending Raw Materials Inventory $435,000 Direct Factory Labor $185,000 Indirect Factory Labor $ 35,000 Factory Utilities $ 44,000 Selling, General, and Administrative Expenses $125,000 Building Depreciation* $300,000 *70% of the building is devoted to production, 30% of the building is devoted to selling and administrative functions. $451,199 in direct materials were purchased during the...
The following data from the just completed year are taken from the accounting records of Eccles Company: Sales Direct labour cost Raw material purchases Selling expenses Administrative expenses Manufacturing overhead applied to work in process Actual manufacturing overhead costs $ 769,000 108,000 150,000 118,000 61,000 228,000 256,000 Inventories: Raw materials Work in process Finished goods Beginning of Year $ 9,800 6,800 71,800 End of Year $11,800 21,800 26,800 Required: 1. Prepare a schedule of cost of goods manufactured. Assume all...
The following data from the just completed year are taken from the accounting records of Eccles Company: Sales Direct labour cost Raw material purchases Selling expenses Administrative expenses Manufacturing overhead applied to work in process Actual manufacturing overhead costs $ 650,000 91,000 133,000 101,000 44,000 211,000 222,000 Inventories: Raw materials Work in process Finished goods Beginning of Year $ 8,100 5,100 70, 100 End of Year $10,100 20,100 25,100 Required: 1. Prepare a schedule of cost of goods manufactured. Assume...
Required: 1. Prepare Twisto Pretzel Company’s schedule of cost of goods manufactured for 20x1. Required information The following information applies to the questions displayed below.] The following data refer to Twisto Pretzel Company for the year 20x1. Work-in-process inventory, 12/31/x0 Selling and administrative salaries Insurance on factory and equipment Work-in-process inventory, 12/31/xl Finished-goods inventory, 12/31/x0 Cash balance, 12/31/x1 Indirect material used Depreciation on factory equipment Raw-material inventory, 12/31/x0 Property taxes on factory Finished-goods inventory, 12/31/x1 Purchases of raw material in...
The following data from the just completed year are taken from the accounting records of Mason Company: Sales Direct labor cost Raw material purchases Selling expenses Administrative expenses Manufacturing overhead applied to work in process Actual manufacturing overhead costs $ 659.000 $ 85,000 $ 133,000 $ 109,000 $ 45.000 $ 200,000 $ 228,000 ces Inventories Raw materials Work in process Finished goods Beginning $ 8,100 $ 5,100 $ 76.000 Ending $ 10, 100 $ 20,400 $25.300 Required: 1. Prepare a...
The following data refer to Twisto Pretzel Company for the year 20x1. Work-in-process inventory, 12/31/x0 $ 8,100 Selling and administrative salaries 13,600 Insurance on factory and equipment 3,600 Work-in-process inventory, 12/31/x1 8,200 Finished-goods inventory, 12/31/x0 14,000 Cash balance, 12/31/x1 6,000 Indirect material used 4,900 Depreciation on factory equipment 2,100 Raw-material inventory, 12/31/x0 10,100 Property taxes on factory 2,400 Finished-goods inventory, 12/31/x1 15,400 Purchases of raw material in 20x1 39,000 Utilities for factory 6,000 Utilities for sales and administrative offices 2,300...
Required information [The following information applies to the questions displayed below.] The following data refer to Twisto Pretzel Company for the year 20x1. Work-in-process inventory, 12/31/x0 Selling and administrative salaries Insurance on factory and equipment Work-in-process inventory, 12/31/x1 Finished-goods inventory, 12/31/x0 Cash balance, 12/31/x1 Indirect material used Depreciation on factory equipment Raw-material inventory, 12/31/XO Property taxes on factory Finished-goods inventory, 12/31/x1 Purchases of raw material in 20x1 Utilities for factory Utilities for sales and administrative offices Other selling and administrative...