Principles of Accounting Volume 1
Principles of Accounting Volume 1
19th Edition
ISBN: 9781947172685
Author: OpenStax
Publisher: OpenStax College
Bartleby Related Questions Icon

Related questions

Question

Good morning, Can somone help me with this? I am having a hard time on how to figure out the inventory balances and amounts on these. Is there a easy to understand way to figure it out?

 

A company's Inventory records show the following data for the month of July.
Date
July 1
Activities
July 5
Beginning inventory
Purchase
July 10
July 20
July 25
Sale
Purchase
Sale
Units Acquired at Cost
100 units @ $63 = $6,300
50 units @ $66 = $3,300
Units Sold at Retail
75 units @ $50
225 units @ $68 $15,300
200 units @ $50
If the company uses the weighted average method and the perpetual Inventory system, what would be the cost of its ending
Inventory?
Date
Goods purchased
Number of Cost per
units
Cost of Goods Sold
Inventory Balance
unit
Number
of units
sold
Cost per
unit
Cost of Goods
Sold
Number of
units
Cost per unit Inventory Balance
July 1
100 at $
63.00 = S
6,300.00
July 5
50 at
$ 54.00
Average cost July 5
100 at
$
150 at $
250 at $
63.00 = S
6,300.00
54.00=
52.00
8,100.00
$ 14,400.00
July 10
75 at $ 52.00] =
$
3,900.00
75 at $
52.00 = S
3,900.00
225 at $68.00
75 at
$
52.00=
S 3,900.00
July 20
225 at
$
68.00 =
15,300.00
Average cost July 20
300 at
$
68.00
$ 19,200.00
July 25
200 at
Total July 25
expand button
Transcribed Image Text:A company's Inventory records show the following data for the month of July. Date July 1 Activities July 5 Beginning inventory Purchase July 10 July 20 July 25 Sale Purchase Sale Units Acquired at Cost 100 units @ $63 = $6,300 50 units @ $66 = $3,300 Units Sold at Retail 75 units @ $50 225 units @ $68 $15,300 200 units @ $50 If the company uses the weighted average method and the perpetual Inventory system, what would be the cost of its ending Inventory? Date Goods purchased Number of Cost per units Cost of Goods Sold Inventory Balance unit Number of units sold Cost per unit Cost of Goods Sold Number of units Cost per unit Inventory Balance July 1 100 at $ 63.00 = S 6,300.00 July 5 50 at $ 54.00 Average cost July 5 100 at $ 150 at $ 250 at $ 63.00 = S 6,300.00 54.00= 52.00 8,100.00 $ 14,400.00 July 10 75 at $ 52.00] = $ 3,900.00 75 at $ 52.00 = S 3,900.00 225 at $68.00 75 at $ 52.00= S 3,900.00 July 20 225 at $ 68.00 = 15,300.00 Average cost July 20 300 at $ 68.00 $ 19,200.00 July 25 200 at Total July 25
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Text book image
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Text book image
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Text book image
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Text book image
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Text book image
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,