Note: The gray accounts (beginning inventory, purchases, purchase discounts, and freight-in) are closed through this COGS calculation process. Required: Part A- Calculate the following (show your work). 1. Calculate Net Sales 2. Calculate Net Accounts Receivable 3. Calculate Shares Outstanding

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
Rapid Roller Inc.
Adjusted Trial Balance
December 31, 2018
Debit
Credit
140,000
275,000
Cash
Accounts Receivable
Allowance for Doubtful Accounts
$
22,000
Notes Receivable
10,000
Supplies
Inventory, 1/1/18
Equipment
Accumulated Deperciation - Equipment
23,000
X1
950,000
1,250,000
300,000
Building
Accumulated Deperciation - Building
2,000,000
450,000
Land
155,000
Accounts Payable
365,000
Salaries and Wages Payable
Notes Payable
Mortgage Payable
Common Stock
24,000
125,000
1,750,000
Par $ 0.01
20,000
APIC
980,000
Retained Earnings
(110,000)
Dividends - Common
50,000
Sales Revenue
2,650,000
Sales Discounts
35,000
Sales Returns and Allowances
68,000
X2
Purchases
1,060,000
X3
Purchase Discounts
21,000
Freight In
19,000
195,000
X4
Selling Expenses
$
Administrative Expenses
$
245,000
Rent Revenue
26,000
Income Tax Expense
$
325,000
Gain on Sale of Land
177,000
6,800,000
$
6,800,000
The above adjusted trial balance does not include a balance for Cost of Goods Sold (COGS). The reason, the above company has a "periodic" inventory system (they do not keep a continuously updated inventory balance). As an accountant you would identify this with by seeing the accounts that I have
highlighted.
Therefore, before you can create an Income Statement you will need to calculate COGS
Transcribed Image Text:Rapid Roller Inc. Adjusted Trial Balance December 31, 2018 Debit Credit 140,000 275,000 Cash Accounts Receivable Allowance for Doubtful Accounts $ 22,000 Notes Receivable 10,000 Supplies Inventory, 1/1/18 Equipment Accumulated Deperciation - Equipment 23,000 X1 950,000 1,250,000 300,000 Building Accumulated Deperciation - Building 2,000,000 450,000 Land 155,000 Accounts Payable 365,000 Salaries and Wages Payable Notes Payable Mortgage Payable Common Stock 24,000 125,000 1,750,000 Par $ 0.01 20,000 APIC 980,000 Retained Earnings (110,000) Dividends - Common 50,000 Sales Revenue 2,650,000 Sales Discounts 35,000 Sales Returns and Allowances 68,000 X2 Purchases 1,060,000 X3 Purchase Discounts 21,000 Freight In 19,000 195,000 X4 Selling Expenses $ Administrative Expenses $ 245,000 Rent Revenue 26,000 Income Tax Expense $ 325,000 Gain on Sale of Land 177,000 6,800,000 $ 6,800,000 The above adjusted trial balance does not include a balance for Cost of Goods Sold (COGS). The reason, the above company has a "periodic" inventory system (they do not keep a continuously updated inventory balance). As an accountant you would identify this with by seeing the accounts that I have highlighted. Therefore, before you can create an Income Statement you will need to calculate COGS
Summary of the December 31, 2018 year-end physical inventory count:
Product
Units
Unit/Cost
Value
Product A
10,500
2$
1.90
2$
19,950
Product B
45.000
4.32
$
194,400
Product C
17,500
$
9.95
174,125
Product D
19,500
5.21
101,595
Product E
5,000
4.55
22,750
Product F
2,500
12.50
$
31,250
WIP
2$
195,000
Raw Materials
125,000
X5
Total
$
864,070
Prepare COGS schedule below: Completed by your instructor. Please make sure you review and understand the COGS calculation below for future assignments.
COGS
X1 Inventory 1/1/2018
X2 Purchases
950,000
1,060,000
X3 Less: Purchase discounts
21,000
Net purchases
X4 Add: Freight-in
1,039,000
$ 19,000
1,058,000
Inventory available for sale
X5 Less: Inventory 12/31/2018
Cost of good sold
2,008,000
$
864.070
1,143,930
Note: The gray accounts (beginning inventory, purchases, purchase discounts, and freight-in) are closed through this COGS calculation process.
Required:
Part A- Calculate the following (show your work).
1. Calculate Net Sales
2. Calculate Net Accounts Receivable
3. Calculate Shares Outstanding
Transcribed Image Text:Summary of the December 31, 2018 year-end physical inventory count: Product Units Unit/Cost Value Product A 10,500 2$ 1.90 2$ 19,950 Product B 45.000 4.32 $ 194,400 Product C 17,500 $ 9.95 174,125 Product D 19,500 5.21 101,595 Product E 5,000 4.55 22,750 Product F 2,500 12.50 $ 31,250 WIP 2$ 195,000 Raw Materials 125,000 X5 Total $ 864,070 Prepare COGS schedule below: Completed by your instructor. Please make sure you review and understand the COGS calculation below for future assignments. COGS X1 Inventory 1/1/2018 X2 Purchases 950,000 1,060,000 X3 Less: Purchase discounts 21,000 Net purchases X4 Add: Freight-in 1,039,000 $ 19,000 1,058,000 Inventory available for sale X5 Less: Inventory 12/31/2018 Cost of good sold 2,008,000 $ 864.070 1,143,930 Note: The gray accounts (beginning inventory, purchases, purchase discounts, and freight-in) are closed through this COGS calculation process. Required: Part A- Calculate the following (show your work). 1. Calculate Net Sales 2. Calculate Net Accounts Receivable 3. Calculate Shares Outstanding
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
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