Question
In: Accounting
Calculate the Ending inventory from the following information using FIFO, WEIGHTED AVERAGE methods of Material issues:...
- Calculate the Ending inventory from the following information using FIFO, WEIGHTED AVERAGE methods of Material issues:
The details relating to the purchase and sales of Material X is given below. Calculate the Ending inventory and Cost of goods sold for the Material X:
|
Date |
PARTICULARS |
OMR |
|
1.1.2014 |
Opening stock of Material X 250 units at |
1.200 |
|
5.1.2014 |
Purchased 350 units of Material X at |
1.275 |
|
7.12014 |
Purchased 425 units of Material X at |
1.340 |
|
10.1.2014 |
Sold 800 units |
|
|
12.1.2014 |
Purchased 550 units of Material X at |
1.425 |
|
15.1.2014 |
Sold 620 units |
1.500 |
|
20.1.2014 |
Sold 120 units |
Solutions
Expert Solution
| Date | Particulars | Unit | Price | Amount | |||||
| 1.1.2014 | Opening Stock | 250 | 1.200 | 300.00 | |||||
| 5.1.2014 | Purchased | 350 | 1.275 | 446.25 | |||||
| 7.1.2014 | Purchased | 425 | 1.340 | 569.50 | |||||
| 10.1.2014 | Sold | 800 | |||||||
| 12.1.2014 | Purchased | 550 | 1.425 | 783.75 | |||||
| 15.1.2014 | Sold | 620 | |||||||
| 20.1.2014 | Sold | 120 | |||||||
| Closing Inventory | 35 | ||||||||
| FIFO Method | |||||||||
| Note: Closing inventory is 35 units (250+350+425-800+550-620-120) | |||||||||
| the same is clearly remaining from the units purchased on 12.1.2014 | |||||||||
| therefore the rate is used 1.425 for valuing ending inventory from FIFO method | |||||||||
| and the value from FIFO method is 49.88 | |||||||||
| COGS from FIFO is 2049.63 (Total purchase less ending inventory value i.e. 2099.50 less 49.88) | |||||||||
| WAC Method | |||||||||
| WAC of the material is = (Opening inventory value + Purchase Value)/ (Opening unit + Purchase Unit) | |||||||||
| = | (300+446.25+569.50+783.75)/(250+350+425+550) | ||||||||
| = | 1.333 | ||||||||
| therefore Closing inventory from WAC method is 46.66 (1.333*35) | |||||||||
| COGS from WAC is 2052.84 (Total purchase less ending inventory value i.e. 2099.50 less 46.66) |
ekkarill92 answered 2 years agoRelated Solutions
Prepare a raw material inventory card for Material A using FIFO and Weighted Average methods of...
Prepare a raw material inventory card for Material A using FIFO
and Weighted Average methods of inventory costing for the following
transactions:
June 1 Opening
Balance
50 units @ $5.00
June 2
Purchases
40 units @ $4.50
June 3
Issues
70 units
June 4
Purchases
35 units @ $4.00
June 5
Issues
45 units
Prepare the journal entry necessary to charge the raw material
issued to the production process.
Using Weighted Average, FIFO and LIFO inventory cost flow methods calculate inventory. Be sure to show...
Using Weighted Average, FIFO and LIFO inventory cost flow
methods
calculate inventory. Be sure to show all
work!!!
Beginning
Inventory
600 units @$6
February
purchase
400 units @$7
April
Purchase
700 units @$8
June
purchase
300 units @$9
sold 500
units
Weighted
Average
FIFO
LIFO
Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods.
Inventory Costing Methods: Periodic Inventory Systems. (Appendix
6B)Tyler Company has the following information related to purchases
and sales of one of its inventory items.DateDescriptionUnits Purchased at
CostUnits Sold at
RetailSept. 1Beginning inventory20 units @ $510Purchase30 units @ $820Sales40 units @ $1525Purchase25 units at $10Assume that the company uses the periodic inventory system.Required:Calculate the cost of goods sold and the cost of ending
inventory using the FIFO, LIFO, and average cost methods.
(Note: Use four decimal places for per-unit calculations
and...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average...
Calculate the cost of goods sold and ending inventory using
weighted average. (Round the weighted average cost per
unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal
places, e.g. 5,250.)
Purchases
Cost of
Goods Sold
Balance
Date
Units
Cost
Total
Units
Cost
Total
Units
Cost
Total
Units
Total Cost
WA Cost Per unit
Apr-01
Beginning Inventory
26
$11
$286
26
$11
$286
Apr-15
52
$13
$676
$
$
26
$286
52
$676
$
$
Apr-20
29...
how to calculate various inventory valuation methods [FIFO, LIFO, weighted average, etc.]
please explainhow to calculate various
inventory valuation methods [FIFO, LIFO, weighted average,
etc.]how to calculate cost of goods
sold when using different inventory valuation methodshow to calculate ending
inventory when using different inventory valuation
methodshow to calculate ending
inventory when gross profit rate is given
Based on the following information, calculate the cost of goods sold and ending inventory using FIFO,...
Based on the following information, calculate the cost of goods
sold and ending inventory using FIFO, LIFO, and weighted average
assuming a perpetual inventory system is in place.
Beginning Balance - 90 units at $11
March 3 - Purchase 300 units for $15
April 4 - Sell 240 units for $28
June 30 - Purchase 250 units for $18
August 16 - Sell 180 units for $30
Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted...
Calculate cost of ending inventory and cost of goods sold
using periodic FIFO, LIFO, and Weighted Average Cost methods.
Description # of units Cost per unit
Beginning inventory: 20 20
Jan.15 Purchase: 22 27
Jan. 20 Sale 10 blank
Jan.25 Purchase 18 25
Jan.28 Sale 15 blank
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory
Using FIFO, LIFO, and Weighted Average Cost Methods
The units of an item
available for sale during the year were as follows:
Jan. 1
Inventory
10
units at $36
$360
Aug. 7
Purchase
15
units at $38
570
Dec. 11
Purchase
15
units at $39
585
40
units
$1,515
There are 18 units of
the item in the physical inventory at December 31. The periodic
inventory system is used. Determine the inventory cost using (a)
the first-in, first-out...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost
Methods
The units of an item available for sale during the year were as
follows:
Jan. 1
Inventory
15
units at $36
$540
Aug. 7
Purchase
20
units at $37
740
Dec. 11
Purchase
15
units at $38
570
50
units
$1,850
There are 19 units of the item in the physical inventory at
December 31. The periodic inventory system is used. Determine the
inventory cost using (a) the first-in, first-out...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost
Methods
The units of an item available for sale during the year were as
follows:
Jan. 1
Inventory
9
units at $28
$252
July 7
Purchase
6
units at $31
186
Nov. 23
Purchase
14
units at $33
462
29
units
$900
There are 17 units of the item in the physical inventory at
December 31. The periodic inventory system is used. Determine the
inventory cost using (a) the first-in, first-out...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 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...
- Write a Java Program using the following instruction: Create the following 3 methods that calculate and...
- How would the S/D curves shift if a $3 tax was imposed on suppliers for each...
- Why should a time-based authentication system invalidate the current password on a successful authentication?
ADVERTISEMENT