Alexandria Aluminum Company, a manufacturer of recyclable soda cans, had the following inventorybalances at the beginning and end of 20x1.January 1, 20x1$ 60,000.120,000.Inventory ClassificatlonDecember 31, 20x1Raw material.$ 70,000Work in process115,000Finished goods150,000 .165,000During 20x1, the company purchased $250,000 of raw material and spent $400,000 on direct labor.Manufacturing overhead costs were as follows:Indirect material$ 10,000Indirect labor25,000Depreciation on plant and equipment .100,000Utilities25,000Other30,000Sales revenue was $1,105,000 for the year. Selling and administrative expenses for the year amounted to$110,000. The firm's tax rate is 40 percent.Requlred:1. Prepare a schedule of cost of goods manufactured.2. Prepare a schedule of cost of goods sold.3. Prepare an income statement.4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements.Show how both cost schedules and the income statement will change if the following data change:direct labor is $390,000 and utilities cost $35,000.

Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Answered: Alexandria Aluminum Company, a…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

2.
Complete the missing figures: Q15 Purchases of raw materials during that year Q16 Raw materials use in production during the year Q17 Cost of units completed during the year Q 18 Finished goods inventory Q19 Cost of units sold during the year
[The following information applies to the questions displayed below.] A company began January with 4,000 units of its principal product. The cost of each unit is $7. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals * Includes purchase price and cost of freight. Date of Sale January 5 January 12 January 20 Total Average Cost Total Sales Beginning Inventory Purchases: January 10 January 18 Units 3,000 4,000 7,000 Units 5,000 units were on hand at the end of the month. 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. 2,000 1,000 3,000 6,000 Number of units Purchases Unit Cost* $8 9 Cost of Goods Available for Sale Unit Cost 4,000 $7.00 3,000 $8.00 4,000 $9.00 11,000 Cost of Goods Available for Sale $ 28,000 Total Cost $ 24,000 36,000 $ 60,000 24,000 36,000 $ 88,000 Answer is not complete. Cost of Goods Sold - Average Cost Number of units sold 77,000 X Average Cost…
A company began January with 6,000 units of its principal product. The cost of each unit is $8. Inventory transactions for the month of January are as follows: Date of Purchase Purchases Units Unit Cost* Total Cost January 10 5,000 $ 9 $ 45,000 January 18 6,000 10 60,000 Totals 11,000 $ 105,000 * Includes purchase price and cost of freight. Sales Date of Sale Units January 5 3,000 January 12 2,000 January 20 4,000 Total 9,000 8,000 units were on hand at the end of the month. 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system.
Parker Corp. included the following items under its inventory account: Raw materials.. .P 1,400,000 200,000 650,000 60,000 150,000 2,000,000 Advances for materials ordered. Work in process.. Unexpired inventory insurance.. Advertising catalogs and packaging cartons. Finished goods inventory in the warehouse... Finished goods in the company owned retail store, stated at 50% mark-up on its cost... Finished goods in the hands of consignees including 40% profit on sales.... Finished goods in transit to customers, Shipped at FOB-Destination 750,000 400,000 stated at cost... 250,000 100,000 50,000 40,000 Finished goods out on customers' approval, at cost. Unsalable finished goods, at cost. Office stationeries and supplies. Materials in transit, shipped FOB-Shipping point, excluding P 30,000 freight cost... Goods held on consignment, at sales price, cost, P 150,000.. What is the correct amount of inventory? A. P5,375,000 330,000 200,000 В. Р 5,500,000 C. P5,540,000 D. P5,250,000
! Required information [The following information applies to the questions displayed below.] A company began January with 8,000 units of its principal product. The cost of each unit is $9. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Total Date of Sale January 5 January 12 January 20 Total Includes purchase price and cost of freight. Perpetual FIFO: Sales Beginning Inventory Purchases: January 10 January 18 Units 5,000 8,000 13,000 11,000 units were on hand at the end of the month. Units 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. 3,000 3,000 4,000 10,000 5,000 8,000 21,000 Purchases Unit Cost* $ 10 11 Cost of Goods Available for Sale Cost of Number Unit Goods of units Cost Available for Sale 8,000 $9.00 $ 72,000 10.00 11.00 Total Cost $ 50,000 88,000 $ 138,000 50,000 88,000 $ 210,000 Cost of Goods Sold - January 5 Number of units sold 0 0 0 Cost per unit $…
The following balances (in thousands of dollars) are from the accounts of Birwood Furniture: January 1 December 31 (Beginning) (Ending) ($000) $ 732 ($000) $804 1,174 1,350 159 284 Direct materials inventory Work-in-process inventory. Finished goods inventory Direct materials used during the year amount to $1,296,000 and the cost of goods sold for the year was $1,478,000. Required: Prepare a cost of goods sold statement. Note: Enter your answers in thousands of dollars (i.e., 234,000 should be entered as 234). Beginning work-in-process inventory Manufacturing costs: Direct materials: Beginning inventory Purchases Materials available Direct materials used Total manufacturing costs Total costs of work-in-process BIRWOOD FURNITURE Cost of Goods Sold Statement For the Year Ended December 31 ($000) Cost of goods manufactured $ 732
Required information [The following information applies to the questions displayed below.] A company began January with 7,000 units of its principal product. The cost of each unit is $6. Inventory transactions for the month of January are as follows: Date of Purchase Units Purchases Unit Cost* Total Cost January 10 6,000 $7 January 18 7,000 8 $ 42,000 56,000 Totals 13,000 $ 98,000 *Includes purchase price and cost of freight. Sales Date of Sale Units January 5 3,000 January 12 1,000 January 20 4,000 Total 8,000 12,000 units were on hand at the end of the month. 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Answer is not complete. Inventory on hand Cost of Goods Sold Perpetual Average Cost Number per of units Inventory Value unit Number of units sold Average Cost per Cost of Goods unit Sold Beginning Inventory 7,000 6.0000 ( $…
The following information has been taken from the perpetual inventory system of Elite Mfg Co. for the month ended August 31: Purchases of direct materials Direct materials used Direct labor costs assigned to production $60,000 $50,000 $25,000 Manufacturing overhead costs incurred (and applied) $35,000 發 Balances in inventory August 31 August 1 Materiais Work in Process Finished Goods $65,000547,000 $60.000 *Sue00 M The total amount of inventory to be included in Elite's August 31st balance sheet amounts to A. $135,000 B. $210,000 C. $160,000 D. Some other amount 1 1109
The following information is available from the inventory records of columbia hoodies company for January: Units Unit Cost Total Cost Balance at Jan 1 3,000 $9.77 $29,310 Purchases: Jan 6 2,000 $10.30 $20,600 Jan 26 2,700 $10.71 $28,917 Sales: Jan 7 (2,500) $14.00 $35,000 Jan 31 (4,000) $14.00 $56,000 All sales are made at 14.00 unit price. Q: Compute the ending inventory on Jan 31 using perpetual moving-average cost. A: I have Ending Inventory at 1,200 units with a value of $12,284.73, is this correct? DO NOT GIVE SOLUTION IN IMAGE FORMAT
The Rock Shop shows the following data related to one of the minerals in inventory: Inventory, January 1 300 units @ $5.00 900 units @ $5.40 Purchase, January 9 Purchase, January 19 Total available 210 units @ $6.00 1,410 units O $1,500 $5,874 = If there are 300 units in inventory on January 31, what value should be assigned to cost of goods sold using FIFO? O $1,746 $6,120 $1,500 $4,860 $1,260 $7,620
Frigid Supplies reported beginning inventory of 200 units, for a total cost of $2,000. The companyhad the following transactions during the month:Jan. 3 Sold 20 units on account at a selling price of $15 per unit.6 Bought 30 units on account at a cost of $10 per unit.16 Sold 30 units on account at a selling price of $15 per unit.19 Sold 20 units on account at a selling price of $20 per unit.26 Bought 10 units on account at a cost of $10 per unit.31 Counted inventory and determined that 160 units were on hand.Required:1. Prepare the journal entries that would be recorded using a periodic inventory system.2. Prepare the journal entries that would be recorded using a perpetual inventory system,including any “book-to-physical” adjustment that might be needed.TIP: Adjust for shrinkage by decreasing Inventory and increasing Cost of Goods Sold.3. What is the dollar amount of shrinkage that you were able to determine in (a) requirement 1,and (b) requirement 2? Enter CD (cannot determine) if…

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS