Question
In: Accounting
Date Transaction Number of Units Per Unit Total Jan.1Inventory7,500$ 75.00$ 562,50010Purchase22,50085.001,912,50028Sale11,250150.001,687,50030Sale3,750150.00562,500Feb.5Sale1,500150.00225,00010Purchase54,00087.504,725,00016Sale27,000160.004,320,00028Sale2
Date
Transaction
Number of Units
Per Unit
Total
Jan.1Inventory7,500$ 75.00$ 562,50010Purchase22,50085.001,912,50028Sale11,250150.001,687,50030Sale3,750150.00562,500Feb.5Sale1,500150.00225,00010Purchase54,00087.504,725,00016Sale27,000160.004,320,00028Sale25,500160.004,080,000Mar.5Purchase45,00089.504,027,50014Sale30,000160.004,800,00025Purchase7,50090.00675,00030Sale26,250160.004,200,000
3. Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the weighted average cost method and the periodic inventory system. Round the weighted average unit cost to the nearest cent and use that amount in subsequent computations.
| Inventory, March 31 | |
| Cost of goods sold |
Solutions
Expert Solution
| Cost of Goods Available for Sale | ||||
| Date | Activity | Units | Unit Price | Amount |
| Jan-01 | Beg Inventory | 7500 | $ 75.00 | $ 5,62,500 |
| Jan-10 | Purchase | 22500 | $ 85.00 | $ 19,12,500 |
| Feb-10 | Purchase | 54000 | $ 87.50 | $ 47,25,000 |
| Mar-05 | Purchase | 45000 | $ 89.50 | $ 40,27,500 |
| Mar-25 | Purchase | 7500 | $ 90.00 | $ 6,75,000 |
| Total | 136500 | $ 1,19,02,500 |
Weighted Average Cost per unit = $11902500/136500 = $87.20 per unit
Units sold = 11250+3750+1500+27000+25500+30000+26250 =
125250
Units in ending inventory = 136500 - 125250 = 11250 units
Ending Inventory = 11250 x 87.20 = $981000 or $980975
Cost of Good Sold = $11902500-981000 = $10921500 or $10921525
ekkarill92 answered 2 years agoRelated Solutions
Date Transaction Units In Unit Cost Total Units Sold Sales Price Total 7/1 Balance 100 4.10...
Date
Transaction
Units In
Unit Cost
Total
Units Sold
Sales Price
Total
7/1
Balance
100
4.10
410
7/6
Purchase
800
4.20
3,360
7/7
Sale
300
7.00
2,100
7/10
Sale
300
7.30
2,190
7/12
Purchase
400
4.50
1,800
7/15
Sale
200
7.40
1,480
7/18
Purchase
300
4.60
1,380
7/22
Sale
400
7.40
2,960
7/25
Purchase
500
4.58
2,290
7/30
Sale
200
7.50
1,500
Totals
2,100
9,240
1,400
10,230
Compute FIFO, LIFO, Average for the perpetual inventory system.
Be sure to do...
Date Transaction Units In Unit Cost Total Units Sold Sales Price Total 7/1 Balance 100 4.10...
Date
Transaction
Units In
Unit Cost
Total
Units Sold
Sales Price
Total
7/1
Balance
100
4.10
410
7/6
Purchase
800
4.20
3,360
7/7
Sale
300
7.00
2,100
7/10
Sale
300
7.30
2,190
7/12
Purchase
400
4.50
1,800
7/15
Sale
200
7.40
1,480
7/18
Purchase
300
4.60
1,380
7/22
Sale
400
7.40
2,960
7/25
Purchase
500
4.58
2,290
7/30
Sale
200
7.50
1,500
Totals
2,100
9,240
1,400
10,230
Compute FIFO, LIFO, Average for the periodic inventory system.
Be sure to do...
Inventory records for a company revealed the following: Date Transaction Number of Units Unit Cost Apr....
Inventory records for a company revealed the
following:
Date Transaction Number of Units Unit Cost
Apr. 1 Beginning inventory 500 $2.40
Apr. 20 Purchase 400 $2.50
The company sold 700 units of inventory during the
month. Cost of goods sold assuming FIFO would be:
a.
$1,690
b.
$1,720.
c.
$1,700.
d.
$1,730.
e.
$1,710.
If management can estimate the amount of loss that will
occur due to litigation against the company, and the likelihood of
the loss is reasonably possible,...
During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit...
During the year, TRC Corporation has the following inventory
transactions. Date Transaction Number of Units Unit Cost Total Cost
Jan. 1 Beginning inventory 54 $ 46 $ 2,484 Apr. 7 Purchase 134 48
6,432 Jul. 16 Purchase 204 51 10,404 Oct. 6 Purchase 114 52 5,928
506 $ 25,248 For the entire year, the company sells 440 units of
inventory for $64 each. 3. Using weighted-average cost, calculate
ending inventory, cost of goods sold, sales revenue, and gross
profit. (Round...
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the following:
Date Transaction Number of Units Unit Cost Mar. 1 Beginning
inventory 960 $7.15 Mar. 10 Purchase 540 7.65 Mar. 16 Purchase 395
8.25 Mar. 23 Purchase 530 8.95 Marvin sold 1,790 units of inventory
during the month. Ending inventory assuming FIFO would be (Do not
round your intermediate calculations. Round your answer to the
nearest dollar amount): $5,610 $1,156 $6,864 $1,541
During the year, Trombley Incorporated has the following inventory transactions. Date Transaction Number of Units Unit...
During the year, Trombley Incorporated has the following
inventory transactions.
Date
Transaction
Number
of Units
Unit
Cost
Total Cost
Jan. 1
Beginning inventory
16
$ 18
$ 288
Mar. 4
Purchase
21
17
357
Jun. 9
Purchase
26
16
416
Nov. 11
Purchase
26
14
364
89
$ 1,425
For the entire year, the company sells 69 units of inventory for
$26 each.
1. Using...
During the year, Trombley Incorporated has the following inventory transactions. Date Transaction Number of Units Unit...
During the year, Trombley Incorporated has the following
inventory transactions.
Date
Transaction
Number
of Units
Unit
Cost
Total Cost
Jan. 1
Beginning inventory
11
$ 13
$ 143
Mar. 4
Purchase
16
12
192
Jun. 9
Purchase
21
11
231
Nov. 11
Purchase
21
9
189
69
$ 755
For the entire year, the company sells 51 units of inventory for
$21 each.
A: Using FIFO,...
During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit...
During the year, TRC Corporation has the following inventory
transactions.
Date
Transaction
Number of Units
Unit Cost
Total Cost
Jan.
1
Beginning inventory
49
$
41
$
2,009
Apr.
7
Purchase
129
43
5,547
Jul.
16
Purchase
199
46
9,154
Oct.
6
Purchase
109
47
5,123
486
$
21,833
For the entire year, the company sells 428 units of inventory
for $59 each.
Required:
1. Using FIFO, calculate ending inventory, cost
of goods sold, sales revenue, and gross profit.
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the
following:
Date
Transaction
Number
of Units
Unit
Cost
Mar.
1
Beginning inventory
1,000
$
7.26
Mar.
10
Purchase
540
7.71
Mar.
16
Purchase
760
8.14
Mar.
23
Purchase
590
8.54
Marvin sold 1,910 units of inventory during the month. Cost of
goods sold assuming FIFO would be:
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the
following:
Date
Transaction
Number
of Units
Unit
Cost
Mar. 1
Beginning inventory
1,070
$7.29
Mar. 10
Purchase
580
7.79
Mar. 16
Purchase
445
8.39
Mar. 23
Purchase
550
9.09
Marvin sold 1,960 units of inventory during the month. Ending
inventory assuming FIFO would be
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
- A research team conducted a study showing that approximately 20% of all businessmen who wear ties...
- Research the internet for companies that have executed data science projects. Pick one company and describe...
- Explain two theories or frameworks for understanding how Western Europe emerged out of 1,000 years of...
- Two cannons are mounted as shown in the drawing and rigged to fire simultaneously. They are...
- What is the potential of a cell made up of Zn|Zn2+ and Cu|Cu2+ half-cells at 25o...
ADVERTISEMENT