Answer:
FIFO Method:
This method describes first in first out of the inventory which means that inventory purchased first will be sold out first. The above question is divided into purchase, issue (sale) and the remaining balance so the balance of the inventory will be clearly arrived :
Date | Purchase of camera | Issues of camera | Remaining Balance |
Units | $/units | Total $ | Units | $/units | Total $ | Units | $/units | Total $ | |
Jan 1 | 20 | 90 | 1800 | 20 | 90 | 1800 | |||
Jan 5 | 60 | 75 | 4500 | 60 | 75 | 4500 | |||
Jan 15 | 20 | 90 | 1800 | ||||||
10 | 75 | 750 | 50 | 75 | 3750 | ||||
Jan 26 | 80 | 85 | 6800 | 80 | 85 | 6800 | |||
Jan 30 | 40 | 75 | 3000 | 10 | 75 | 750 | |||
80 | 85 | 6800 |
AVERAGE COST METHOD:
In this method the inventories are valued at weighted average cost of all the purchases. Average cost is calculated each time when the inventory is issued.
Date | Purchase of camera | Issue of cameras | Remaining Balance |
Unit | $/units | Total $ | Unit | $/units | Total $ | Unit | $/units | Total $ | |
Jan 1 | 20 | 90 | 1800 | 20 | 90 | 1800 | |||
Jan 5 | 60 | 75 | 4500 | 60 | 75 | 4500 | |||
80 | 78.75 | 6300 | |||||||
Jan 15 | 30 | 78.75 | 2362.50 | 50 | 78.75 | 3937.50 | |||
Jan 26 | 80 | 85 | 6800 | 80 | 85 | 6800 | |||
130 | 82.596 | 10737.50 | |||||||
Jan 30 | 40 | 82.596 | 3303.84 | 90 | 82.596 | 7433.66 | |||
Now, the journal Entries in both methods:
Date | FIFO Method | Average Cost Method |
Particulars | DR (in $) | CR (in $) | Particulars | DR (in $) | CR (in $) | |
Jan 5 | Purchase A/c Dr | 4500 | Purchase A/c Dr | 4500 | ||
To Accounts Payable | 4500 | To Accounts Payable | 4500 | |||
Jan 15 | Accounts Receivable A/c Dr | 2550 | Accounts Receivable A/c Dr | 2362.50 | ||
To Sales | 2550 | To Sales | 2362.50 | |||
Jan 26 | Purchase A/c Dr | 6800 | Purchase A/c Dr | 6800 | ||
To Accounts Payable | 6800 | To Accounts Payable | 6800 | |||
Jan 30 | Accounts Receivable A/c Dr | 7550 | Accounts Receivable A/c Dr | 7433.66 | ||
To Sales | 7550 | To Sales | 7433.66 |
Camera Beginning inventor Unt Cost 590 Sale Purchase Sale 100 Prepare inventory using Fire and Average...
Oct. 1 Oct. 9 Oct. 11 Oct. 17 Beginning inventory Purchase Sale Purchase Oct. 22 Oct. 25 Oct.29 Sale Purchase Sale Calculate the weighted average cost. (Round Weighted-average cost per unit e Textbook and Media List of Accounts Calculate ending Inventor of goods sold, wyoss profit under each of the following methods. (1) LIFO. (2) FIFO. (3) Average-cost. (Round answers 83 EO The ending inventory S The cost of goods sold $ Gross profit eTextbook and Media List of Accounts...
FIFO, LIFO, WEIGHTED AVERAGE - Determine cost of beginning inventory and each purchase, each sale, ending inventory Beginning inventory 100 units at 150 Purchases January 3: 100 units at 50 February 10: 150 units at 45 June 3: 90 units at 60 August 2: 200 units at 40 October 10: 210 units at 40 Sales: January 4: 40 units March 11: 30 units June 31: 50 units September 10: 80 units November 2: 50 units After determining the cost of...
FIFO, LIFO, WEIGHTED AVERAGE - Determine cost of beginning inventory and each purchase, each sale, ending inventory Beginning inventory 100 units at 150 Purchases January 3: 100 units at 50 February 10: 150 units at 45 June 3: 90 units at 60 August 2: 200 units at 40 October 10: 210 units at 40 Sales: January 4: 40 units March 11: 30 units June 31: 50 units September 10: 80 units November 2: 50 units After determining the cost of...
INVENTORY ITEM 621AB UNITS DATE COST Beginning Inventory $6 $7 Jan 1 120 Purchase 200 Jan 7 Sale Jan 10 250 Purchase $8 Jan 15 300 Jan 17 Purchase $9 200 Sale 325 Jan 20 Sale Jan 25 100 Jan 28 Purchase $10 175 Smith Corporation uses a perpetual inventory system. Determine the costs assigned to Cost of Goods Sold and Ending Inventory using both FIFO and LIFO methods. DATE ITEM RED16 UNITS COST Beginning Inventory $10 Jan 1 100...
Jun. 1 Beginning merchandise inventory 12 Purchase 20 Sale 24 Purchase 29 Sale 17 units @ 5 units @ 14 units @ 11 units @ 13 units @ $ $ $ $ $ 15 each 19 each 37 each 23 each 37 each 1. Compute ending merchandise inventory, cost of goods sold, and gross profit using the FIFO inventory costing method. 2. Compute ending merchandise inventory, cost of goods sold, and gross profit using the LIFO inventory costing method. 3....
Perpetual Inventory Using Weighted Average Beginning inventory, purchases, and sales for Meta-B1 are as follows: July 1 Inventory 100 units at $400 12 Sale 70 units 23 Purchase 120 units at $450 26 Sale 110 units a. Assuming a perpetual inventory system and using the weighted average method, determine the weighted average unit cost after the July 23 purchase. $ per unit b. Assuming a perpetual inventory system and using the weighted average method, determine the cost of the merchandise...
Perpetual Inventory Using Weighted Average Beginning inventory, purchases, and sales for Meta-B1 are as follow July 1 Inventory 100 units at $400 12 Sale 70 units 23 Purchase 120 units at $450 26 Sale 110 units a. Assuming a perpetual inventory system and using the weighted average method, determine the weighted average unit cost after the July 23 purchase. average methode per unit b. Assuming a perpetual inventory system and using the weighted average method, determine the cost of the...
2.75 LO71.7-2.74,75 74 Recording Inventory Transactions. Connutina Ending Inventor and Cost or Determining the Errects or LC&NRV Rule on the Inventory Turnover Chaiz Inc. specializes in importing furniture for commercial use es importing furniture for commercial use. Chaiz reported the following information all transactions are on account) for the quarter ending September Date Transaction Units Amount per Unit July 1 Inventory 224 $36.0 July 13 Purchase 152 35.5 July 29 Sale 242 49.5 August 3 Purchase 112 34.5 August 16...
Units Cost/selling price June $30 33 1 Beginning inventory 4 Purchase 8 Sale 12 Purchase 16 Sale 20 Sale 300 800 400 1,000 700 500 Required: Using periodic Inventory system, Compute ending inventory balance, cost of goods sold and gross margin under LIFO. (25%)
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 $29 $290 Aug. 7 Purchase 19 units at $31 589 Dec. 11 Purchase 10 units at $32 320 39 units $1,199 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...