1) Inventory valuation under FIFO method :
Date | Purchases | Purchases | Purchases | COGS | COGS | COGS | Inventory on hand | Inventory on hand | Inventory on hand |
Quantity | unit cost | Total cost | Quantity | Unit cost | Total Cost | Quantity | Unit cost | Total cost | |
July 2 | 10 | 1.60 | 16.0 | 10 | 1.60 | 16.00 | |||
July 6 | 2 | 1.90 | 3.80 |
10 2 |
1.60 1.90 |
16.00 3.80 |
|||
July 8 | 4 | 1.60 | 6.40 |
6 2 |
1.60 1.90 |
9.60 3.80 |
|||
July 13 | 2 | 2.35 | 4.70 |
6 2 2 |
1.60 1.90 2.35 |
9.60 3.80 4.70 |
|||
July 14 | 4 | 1.60 | 6.40 |
2 2 2 |
1.60 1.90 2.35 |
3.20 3.80 4.70 |
|||
Total | 14 | 24.50 | 8 | 12.80 | 6 | $ 11.70 |
2) Inventory valuation under LIFO method :
Date | Purchases | Purchases | Purchases | COGS | COGS | COGS | Invenyory on hand | inventory on hand | Inventory on hand |
Quantity | Unit cost | Total cost | Quantity | Unit cost | Total cost | Quantity | Unit cost | Total cost | |
July 2 | 10 | 1.60 | 16.00 | 10 | 1.60 | 16.00 | |||
July 6 | 2 | 1.90 | 3.80 |
10 2 |
1.60 1.90 |
16.00 3.80 |
|||
July 8 |
2 2 |
1.90 1.60 |
3.80 3.20 |
8 | 1.60 | 12.80 | |||
July 13 | 2 | 2.35 | 4.70 |
8 2 |
1.60 2.35 |
12.80 4.70 |
|||
July 14 |
2 2 |
2.35 1.60 |
4.70 3.20 |
6 | 1.60 | 9.60 | |||
Total | 14 | 24.50 | 8 | 14.90 | 6 | $ 9.60 |
3) Inventory valuation under Weighted average Method:
Weighted Average cost per unit of inventory = Total purchase cost / Total purchased units
Weighted average cost per unit of inventory = $ 24.50 / 14 = $ 1.75
Total units sold = 8
Cost of goods sold = $ 1.75 X 8 = $ 14
Ending inventory ( Units) = Total units purchased - Total units sold = 14 - 8 = 6 units
Ending inventory ( in dollars ) = 6 X $ 1.75 = $ 10.50
If you understand the above solution please give me a like ( Upward rating) . Please .
having a little trouble with this problem, can someone figure it out? chronological order, calculating new...
I
am having a hard time with Fifo/Lifo and am confused how to finish
this.
Inside Track, a regional convenience store chain, maintains milk inventory by the gallon. The first month's milk purchases and sales at its Denver, Colorado, location follow: (Click the icon to view the purchases and sales.) Read the requirements.? Ele-15 Requirement 1. Determine the amount that would be reported in ending merchandise inventory on May 15 using the FIFO inventory costing method. Enter the transactions in...
Requirement 3. Determine the amount that would be reported in ending merchandise inventory on May 15 using the weighted average inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter all amounts to the nearest cent, $X.XX.) Fast Mart,...
1.
2.
Requirement 2. Determine the amount that would be reported in ending merchandise inventory on May 15 using the LIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter all amounts to the nearest cent, $X.XX. Enter...
please clean graph preferred
to be typed, please
Fast Mart, a regional convenience store chain, maintains milk inventory by the gallon. The first month's milk purchases and sales at its Old Saybrook, Connecticut, location follow: i (Click the icon to view the purchases and sales.) Read the requirements. Requirement 1. Determine the amount that would be reported in ending merchandise inventory on May 15 using the FIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on...
Please show answers clearly.
Fit Gym began July with merchandise inventory of 76 crates of vitamins that cost a total of $4,560. During the month, Fit Gym purchased and sold merchandise on account as follows: (Click the icon to view the transactions.) Read the requirements Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and delermine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold...
Requirement 1. Compute cost of goods sold and gross profit using the FIFO inventory costing method Begin by computing the cost of goods sold and cost of ending merchandise inventory using the FIFO inventory costing method. Enter the transacions in chronalogical order, calculating news inventory an hand balances ater each transaction Once all of the transacions have been entered into the perpetal record, caloulate the quantly and total oost of merchandise inventory purchased, sold, and on hand at the end...
Requirement 1. Compute cost of goods sold and gross profit using
the FIFO inventory costing method.
Begin by computing the cost of goods sold and cost of ending
merchandise inventory using the FIFO inventory costing method.
Enter the transactions in chronological order, calculating new
inventory on hand balances after each transaction. Once all of the
transactions have been entered into the perpetual record,
calculate the quantity and total cost of merchandise inventory
purchased, sold, and on hand at the end...
Dec. 1 Beginning merchandise inventory 12 units @ $8 each 8 Sale 8 units @ $21 each 14 Purchase 16 units @ $14 each 21 Sale 15 units @ $21 each 1. Compute the cost of goods sold, cost of ending merchandise inventory, and gross profit using the FIFO inventory costing method. 2. Compute the cost of goods sold, cost of ending merchandise inventory, and gross profit using the LIFO inventory costing method. 3. Which method results in a higher...
Dec. 1 Beginning merchandise inventory 20 tires @ $66 each 11 Purchase 8 tires @ $73 each 23 Sale 15 tires @ $87 each 26 Purchase 13 tires @ $84 each 29 Sale 15 tires @ $87 each Requirement 2. Compute cost of goods sold and gross profit using the LIFO inventory costing method. Begin by computing the cost of goods sold and cost of ending merchandise inventory using the LIFO inventory costing method. Enter the transactions in chronological order,...
Dec. 1 Beginning merchandise inventory 13 units @ $11 each 8 Sale 9 units @ $24 each 14 Purchase 17 units @ $15 each 21 Sale 14 units @ $24 each Assume that Upper J Upper L ToysJ L Toys store bought and sold a line of dolls during DecemberDecember as follows: LOADING... (Click the icon to view the transactions.) Upper J Upper L ToysJ L Toys uses the perpetual inventory system.Read the requirements. LOADING... Requirement 1. Compute the cost...