Direct Materials Work In Process Finished Goods Direct Materials purchased Direct Labor Indirect materials Indirect Labor Power, 90% plant Property taxes, 80% plant Supervisory labor Administrative expense General Expense Transportation in Security guard 77% plant Gain on sale of furniture 1 Revenue from vending machine Interest Expense Interest Revenue Transportation out Loss on sale of truck Selling commission expense Depreciation Expense (straight line) 82% plant Housekeeping 80% plant Loss on sale of computers Sales Beginning 54,000 199,000 316,000 " Maintenance expense 85% plant Gain on sale of equipment Obsolete (written off) inventory Lease 75% plant Ending 49,000 175,000 295,000 4,580,000 3,840,000 216,000 885,000 259,000 306,000 1,356,000 1,615,000 2,555,000 65,000 345,000 45,000 898,000 475,000 996,000 24,000 27,250,000 135,000 35,000 625,000 65,000 455,000 1,180,000 30%✔ Tax rate Prepare the COGS and Income Statement for Snowy Owl Company 12/31/2022 in excel! Use perfect formatting (column usage, $, commas, summation lines, indents, spelling, etc). Number of shares of comma stock 1.000.000, no preferred stock, no items can be diluted. 15,000 19,000 8,000

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

2.

 

Direct Materials
Work In Process
Finished Goods
Direct Materials purchased
Direct Labor
Indirect materials
Indirect Labor
Beginning
54,000
199,000
316,000
Power, 90% plant
Property taxes, 80% plant
Supervisory labor
Administrative expense
General Expense
Transportation in
Security guard 77% plant
Gain on sale of furniture
Selling commission expense
Depreciation Expense (straight line) 82% plant
Housekeeping 80% plant
Loss on sale of computers
Sales
Revenue from vending machine
Interest Expense
Interest Revenue
Ending
49,000
175,000
295,000
4,580,000
3,840,000
216,000
885,000
259,000
306,000
1,356,000
1,615,000
2,555,000
65,000
345,000
45,000
898,000
475,000
996,000
24,000
27,250,000
15,000
19,000
8,000
135,000
35,000
Transportation out
Loss on sale of truck
Maintenance expense 85% plant
625,000
Gain on sale of equipment
65,000
455,000
Obsolete (written off) inventory
Lease 75% plant
1,180,000
30%
Tax rate
Prepare the COGS and Income Statement for Snowy Owl Company 12/31/2022 in excel! Use perfect
formatting (column usage, $, commas, summation lines, indents, spelling, etc). Number of shares of common
stock 1,000,000, no preferred stock, no items can be diluted.
Transcribed Image Text:Direct Materials Work In Process Finished Goods Direct Materials purchased Direct Labor Indirect materials Indirect Labor Beginning 54,000 199,000 316,000 Power, 90% plant Property taxes, 80% plant Supervisory labor Administrative expense General Expense Transportation in Security guard 77% plant Gain on sale of furniture Selling commission expense Depreciation Expense (straight line) 82% plant Housekeeping 80% plant Loss on sale of computers Sales Revenue from vending machine Interest Expense Interest Revenue Ending 49,000 175,000 295,000 4,580,000 3,840,000 216,000 885,000 259,000 306,000 1,356,000 1,615,000 2,555,000 65,000 345,000 45,000 898,000 475,000 996,000 24,000 27,250,000 15,000 19,000 8,000 135,000 35,000 Transportation out Loss on sale of truck Maintenance expense 85% plant 625,000 Gain on sale of equipment 65,000 455,000 Obsolete (written off) inventory Lease 75% plant 1,180,000 30% Tax rate Prepare the COGS and Income Statement for Snowy Owl Company 12/31/2022 in excel! Use perfect formatting (column usage, $, commas, summation lines, indents, spelling, etc). Number of shares of common stock 1,000,000, no preferred stock, no items can be diluted.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Cost classification
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.
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