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 Indirect labor Depreciation on plant and equipment Utlities Other $ 10,000 25.000 100.000 25.000 30.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. Required: 1. Prepare a schedule of cost of goods manufactured. 2. Prepare a schedule of cost of goods sold. 3. Prepare an income statement Page 66

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
M
I INI 64
1
21 3. I
Indirect material
Indirect labor
Depreciation on plant and equipment
Utilities
Other
4. I
Predictions: On
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.
$10.000
25.000
5
Inventory Classification January 1, 20x1
Rew material
$ 60.000
Work in process
120,000
Finished goods
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:
100.000
25.000
30.000
IN 6.
[I
F
.*.
Accessibility: Investigate
19
10.1 11.
1.121 13.1 14. 1
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.
December 31, 20x1
$70,000
115.000
165.000
-0-
15.
1
Required:
L Prepare a schedule of cost of goods manufactured.
2. Prepare a schedule of cost of good 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 cos1 §. 5,000.
Focus
17 118
Page 66
Editing
حار أكثر *
A
m
|
Transcribed Image Text:M I INI 64 1 21 3. I Indirect material Indirect labor Depreciation on plant and equipment Utilities Other 4. I Predictions: On 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. $10.000 25.000 5 Inventory Classification January 1, 20x1 Rew material $ 60.000 Work in process 120,000 Finished goods 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: 100.000 25.000 30.000 IN 6. [I F .*. Accessibility: Investigate 19 10.1 11. 1.121 13.1 14. 1 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. December 31, 20x1 $70,000 115.000 165.000 -0- 15. 1 Required: L Prepare a schedule of cost of goods manufactured. 2. Prepare a schedule of cost of good 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 cos1 §. 5,000. Focus 17 118 Page 66 Editing حار أكثر * A m |
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education