FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions Icon

Related questions

Question

need answers for 1,2,3 and 4

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