Question

In: Accounting

Required information [The following information applies to the questions displayed below.] Alexandria Aluminum Company, a manufacturer...

Required information

[The following information applies to the questions displayed below.]

Alexandria Aluminum Company, a manufacturer of recyclable soda cans, had the following inventory balances at the beginning and end of 20x1.

Inventory Classification January 1, 20x1 December 31, 20x1
Raw material $ 60,000 $ 70,000
Work in process 120,000 115,000
Finished goods 150,000 165,000

During 20x1, the company purchased $250,000 of raw material and spent $400,000 on direct labor. Manufacturing overhead costs were as follows:


Indirect material $ 8,000
Indirect labor 26,000
Depreciation on plant and equipment 100,000
Utilities 26,000
Other 30,000

Sales revenue was $1,112,000 for the year. Selling and administrative expenses for the year amounted to $110,000. The firm’s tax rate is 40 percent.

QUESTIONS!!

2. Prepare a schedule of cost of goods sold

ALEXANDRIA ALUMINUM COMPANY

Schedule of Cost of Goods Sold

For the Year Ended December 31, 20x1

Finished-goods inventory, January 1 ???

Add: Cost of goods manufactured ???

Cost of goods available for sale ???

Less: Finished-goods inventory, December 31 ???

Cost of goods sold ???


Prepare Income statement

ALEXANDRIA ALUMINUM COMPANY
Income Statement
For the Year Ended December 31, 20x1
Sales revenue ???
Less: Cost of goods sold ???
Gross margin ???
Selling and administrative expenses ???
Income before taxes ???
Income tax expense ???
Net income $ ???   

Solutions

Expert Solution

  • Note

Schedule of Cost of Goods Manufactured

Direct materials:

Beginning raw material inventory

$60,000

Add: Purchase of raw material

$250,000

Total raw materials available

$310,000

Less: Ending raw material inventory

$70,000

   Raw material used in production

$240,000

Direct labor cost

$400,000

Manufacturing Overhead:

Indirect Labor

$26,000

Indirect material

$8,000

Depreciation Plant Equipment

$100,000

Utilities & Other

$56,000

$190,000

Total manufacturing costs

$830,000

Add: Beginning WIP Inventory

$120,000

Total cost of Work in Process

$950,000

Less: Ending WIP Inventory

$115,000

Cost of Goods manufactured

$835,000

  • [2]

Schedule of Cost of Goods Sold

Finished goods Jan 1

$150,000

Add: Cost of Goods manufactured

$835,000

Cost of Goods available for sale

$985,000

Less: Finished goods Dec 31

$165,000

Cost of Goods Sold

$820,000

  • Income Statement

ALEXANDRIA ALUMINUM COMPANY

Income Statement

For the Year Ended December 31, 20x1

Sales revenue

$1,112,000

Less: Cost of goods sold

$820,000

Gross margin

$292,000

Selling and administrative expenses

$110,000

Income before taxes

$182,000

Income tax expense

$72,800

Net income

$109,200


Related Solutions

Required information [The following information applies to the questions displayed below.] A food manufacturer reports the...
Required information [The following information applies to the questions displayed below.] A food manufacturer reports the following for two of its divisions for a recent year. ($millions) Beverage Division Cheese Division Invested assets, beginning $ 2,662 $ 4,455 Invested assets, ending 2,593 4,400 Sales 2,681 3,925 Operating income 349 634 1. Compute return on investment. 2. Compute profit margin. 3. Compute investment turnover for the year.
Required information [The following information applies to the questions displayed below.] Bunnell Corporation is a manufacturer...
Required information [The following information applies to the questions displayed below.] Bunnell Corporation is a manufacturer that uses job-order costing. On January 1, the company’s inventory balances were as follows: Raw materials $ 59,500 Work in process $ 37,600 Finished goods $ 61,800 The company applies overhead cost to jobs on the basis of direct labor-hours. For the current year, the company’s predetermined overhead rate of $14.25 per direct labor-hour was based on a cost formula that estimated $570,000 of...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the following January purchases and sales data for its only product.    Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 185 units @ $ 11.00 = $ 2,035 Jan. 10 Sales 145 units @ $ 20.00 Jan. 20 Purchase 100 units @ $ 10.00 = 1,000 Jan. 25 Sales 125 units @ $ 20.00 Jan. 30 Purchase 270 units...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the following January purchases and sales data for its only product.    Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 235 units @ $ 16.00 = $ 3,760 Jan. 10 Sales 200 units @ $ 25.00 Jan. 20 Purchase 180 units @ $ 15.00 = 2,700 Jan. 25 Sales 190 units @ $ 25.00 Jan. 30 Purchase 390 units...
Required information [The following information applies to the questions displayed below.]    Warnerwoods Company uses a...
Required information [The following information applies to the questions displayed below.]    Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.    Date Activities Units Acquired at Cost Units Sold at Retail Mar. 1 Beginning inventory 100 units @ $50.00 per unit Mar. 5 Purchase 400 units @ $55.00 per unit Mar. 9 Sales 420 units @ $85.00 per unit Mar. 18 Purchase 120 units @ $60.00 per unit Mar. 25...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on January 1, Year 1, when it acquired $164,000 cash from the owners. During Year 1, the company earned cash revenues of $94,300 and incurred cash expenses of $69,500. The company also paid cash distributions of $9,500. Required Prepare a Year 1 income statement, capital statement (statement of changes in equity), balance sheet, and statement of cash flows under each of the following assumptions. (Consider...
Required information [The following information applies to the questions displayed below.] Rooney Company is a retail...
Required information [The following information applies to the questions displayed below.] Rooney Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks. Required October sales are estimated to be $240,000, of which 40 percent will be...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on January 1, Year 1, when it acquired $168,000 cash from the owners. During Year 1, the company earned cash revenues of $96,300 and incurred cash expenses of $61,800. The company also paid cash distributions of $12,000. Required Prepare a Year 1 income statement, capital statement (statement of changes in equity), balance sheet, and statement of cash flows under each of the following assumptions. (Consider...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on...
Required information [The following information applies to the questions displayed below.] Cascade Company was started on January 1, Year 1, when it acquired $168,000 cash from the owners. During Year 1, the company earned cash revenues of $96,300 and incurred cash expenses of $61,800. The company also paid cash distributions of $12,000. Required Prepare a Year 1 income statement, capital statement (statement of changes in equity), balance sheet, and statement of cash flows under each of the following assumptions. (Consider...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the...
Required information [The following information applies to the questions displayed below.]    Laker Company reported the following January purchases and sales data for its only product.    Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 175 units @ $ 10.00 = $ 1,750 Jan. 10 Sales 135 units @ $ 19.00 Jan. 20 Purchase 130 units @ $ 9.00 = 1,170 Jan. 25 Sales 140 units @ $ 19.00 Jan. 30 Purchase 275 units...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT