Homework Help is Here – Start Your Trial Now!
Business
Accounting
■ Exercise 2-29 Schedules of Cost of Goods Manufactured and Sold; Income Statement (LO 2-1, 2-3, 2-6) Alexandria Aluminum Company, a manufacturer of recyclable soda cans, had the following inventory balances at the beginning and end of 20x1. Indirect material Indirect labor Depreciation on plant and equipment Inventory Classification Raw material Work in process Finished goods $ 10,000 25,000 100.000 January 1, 20x1 $ 60,000 120,000 150,000 During 20x1, the company purchased $250,000 of raw material and spent $400,000 on direct labor. Manufacturing overhead costs were as follows: December 31, 20x1 $70,000 115,000 165,000

■ Exercise 2-29 Schedules of Cost of Goods Manufactured and Sold; Income Statement (LO 2-1, 2-3, 2-6) Alexandria Aluminum Company, a manufacturer of recyclable soda cans, had the following inventory balances at the beginning and end of 20x1. Indirect material Indirect labor Depreciation on plant and equipment Inventory Classification Raw material Work in process Finished goods $ 10,000 25,000 100.000 January 1, 20x1 $ 60,000 120,000 150,000 During 20x1, the company purchased $250,000 of raw material and spent $400,000 on direct labor. Manufacturing overhead costs were as follows: December 31, 20x1 $70,000 115,000 165,000

Managerial Accounting: The Cornerstone of Business Decision-Making
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter2: Basic Managerial Accounting Concepts
Section: Chapter Questions
Problem 30BEB: 2-30 Cost of Goods Manufactured Morning Smiles Coffee Company manufactures Stoneware French Press...
See similar textbooks
icon
Related questions
Question

question is in image.

Required:

  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.

■ Exercise 2-29 Schedules of Cost of Goods Manufactured and Sold; Income Statement (LO 2-1, 2-3, 2-6) Alexandria Aluminum Company, a manufacturer of recyclable soda cans, had the following inventory balances at the beginning and end of 20x1. Inventory Classification Raw material Work in process Finished goods 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 Indirect labor Depreciation on plant and equipment Utilities Other $ 10,000 25,000 100,000 25,000 30,000 January 1, 20x1 $ 60,000 120,000 150.000 December 31, 20x1 $ 70,000 115.000 165.000 Sales 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. Page 66 Required: 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.
Transcribed Image Text:■ Exercise 2-29 Schedules of Cost of Goods Manufactured and Sold; Income Statement (LO 2-1, 2-3, 2-6) Alexandria Aluminum Company, a manufacturer of recyclable soda cans, had the following inventory balances at the beginning and end of 20x1. Inventory Classification Raw material Work in process Finished goods 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 Indirect labor Depreciation on plant and equipment Utilities Other $ 10,000 25,000 100,000 25,000 30,000 January 1, 20x1 $ 60,000 120,000 150.000 December 31, 20x1 $ 70,000 115.000 165.000 Sales 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. Page 66 Required: 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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cost Sheet
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781337119207
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Corporate Financial Accounting
Corporate Financial Accounting
Accounting
ISBN:
9781305653535
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Corporate Financial Accounting
Corporate Financial Accounting
Accounting
ISBN:
9781337398169
Author:
Carl Warren, Jeff Jones
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS