PERIODIC INVENTORY SYSTEM | ||||||||
AVERAGE COST METHOD | ||||||||
COST OF GOODS AVAILABLE FOR SALE | COST OF GOODS SOLD | |||||||
Date | Particulars | Units | Rate | Total | Units | Rate | Total | |
Sept, 01 | Beginning inventory | 4000 | $ 10.00 | $ 40,000 | ||||
Purchases | ||||||||
Sept, 07 | Purchases | 2000 | $ 10.30 | $ 20,600 | ||||
Sept, 25 | Purchases | 8000 | $ 10.80 | $ 86,400 | ||||
Goods Avaiable for sold | 14000 | $ 10.50 | $ 1,47,000 | |||||
Sales (4000 units + 4000 units) | -8000 | $ 10.50 | $ -84,000 | 8000 | $ 10.50 | $ 84,000 | ||
TOTAL | 6000 | $63,000 | 8000 | $84,000 | ||||
ANSWER : | ||||||||
Cost of Goods Sold | $84,000 | |||||||
Ending inventory | $63,000 | |||||||
PERPETUAL INVENTORY SYSTEM | ||||||||
AVERAGE COST METHOD | ||||||||
INVENTORY ON HAND | COST OF GOODS SOLD | |||||||
Date | Particulars | Units | Rate | Total | Units | Rate | Total | |
Sept, 01 | Beginning inventory | 4000 | $ 10.00 | $ 40,000 | ||||
Sept, 09 | Purchases | 2000 | $ 10.30 | $ 20,600 | ||||
Subtotal Average Costs | 6000 | $ 10.10 | $ 60,600 | |||||
Sept, 10 | Sales | -4000 | $ 10.10 | $ -40,400 | 4000 | $ 10.10 | $40,400 | |
Subtotal Average Costs | 2000 | $ 10.10 | $ 20,200 | |||||
Sept, 25 | Purchases | 8000 | $ 10.80 | $ 86,400 | ||||
Subtotal Average Costs | 10000 | $ 10.66 | $1,06,600 | |||||
Sept, 29 | Sales | -4000 | $ 10.66 | $ -42,640 | 4000 | $ 10.66 | $42,640 | |
TOTALS | 6,000 | $ 10.66 | $63,960 | 8,000 | $83,040 | |||
ANSWER : | ||||||||
Cost of Goods Sold | $83,040 | |||||||
Ending inventory | $63,960 | |||||||
The following information is taken from the inventory records of the CNB Company for the month...
The following information is taken from the inventory records of the CNB Company for the month of September: Beginning inventory, 9/1/2021 4,000 units @ $10.00 Purchases: 9/7 2,000 units @ $10.30 9/25 8,000 units @ $10.80 Sales: 9/10 4,000 units 9/29 4,000 units 6,000 units were on hand at the end of September. ________________________________________ Required: 1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September...
The following information is taken from the inventory records of the CNB Company for the month of September: 9/7 Beginning inventory 9/1/2021 8,000 units @ $10.00 Purchases: 6,000 units @ $10.70 9/25 9,000 units $12.60 Sales: 9/10 8.000 units 9/29 9,000 units 6,000 units were on hand at the end of September. Required: 1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory. 2....
The following information is taken from the inventory records of the CNB Company for the month of September: Beginning inventory. 9/1/2018 6,400 units @ $10.00 Purchases: 3,600 units @ $11.50 9/25 10,000 units @ $12.30 Sales: 9/10 4,000 units 9/29 5,000 unita 11. 000 units were on hand at the end of September Required: 1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory...
The following information is taken from the inventory records of the CNB Company for the month of September: Beginning inventory, 9/1/2018 Purchases: 8,000 units e $10.00 6,000 units $10.70 9,000 units $12.60 9/7 9/25 Sales 8,000 units 9,000 units 9/10 9/29 6,000 units were on bhand at the end of September. Required: 1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory. 2. Repeat...
The following information is taken from the inventory records of the CNB Company for the month of September: Beginning inventory, 9/1/2021 8,000 units @ $10.00 Purchases: 9/7 6,000 units @ $10.70 9/25 16,000 units @ $10.90 Sales: 9/10 6,000 units 9/29 10,000 units 14,000 units were on hand at the end of September. Required: 1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory....
The following information is taken from the inventory records of the CNB Company for the month of September: Beginning inventory, 9/1/20218,000units @ $10.00Purchases:9/76,000units @ $10.709/2516,000units @ $10.90Sales:9/106,000units9/2910,000units14,000 units were on hand at the end of September. Required:1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory.2. Assuming that CNB uses a perpetual inventory system and employs the average cost method, determine cost of goods sold for September and...
PLEASE GIVE SOLUTION IN THE SAME FORMAT AS THE IMAGE THANK YOU! The following Information is taken from the Inventory records of the CNB Company for the month of September: 9/7 Beginning inventory, 9/1/2021 8, eee units @ $11.00 Purchases: 7,000 units @ $11.30 9/25 9,000 units @ $11.70 Sales: 9/10 6,000 units 9/29 10,000 units 8,880 units were on hand at the end of September. Required: 1. Assuming that CNB uses a periodic Inventory system and employs the average...
Required information [The following information applies to the questions displayed below.) Ferris Company began January with 4,000 units of its principal product. The cost of each unit is $7. Merchandise transactions for the month of January are as follows: Purchases Unit Cost Date of Purchase Jan. 18 Jan. 18 Totals Units 3,000 4,000 7,000 Total Cost $24,000 36,000 60,000 * Includes purchase price and cost of freight Units Date of Sale Jan. 5 Jan. 12 Jan. 20 Total 2.000 1,000...
Problem 3: Beaver Inventory Problem Beaver Company has the following inventory transactions for the month of April: Purchases Sales April 1 (beginning balance) April Units 600 1,500 800 1,200 700 500 Cost $6.00 $6.08 $6.40 $6.50 $6.60 $6.79 3 9 11 23 27 Units 500 1,400 600 1,200 900 29 Required: 1. Assume Beaver Company uses periodic inventory records. Determine the value of ending inventory using: a. FIFO b. LIFO c. Average-cost 2. Assume Beaver Company uses perpetual inventory records....
The inventory records of Kuffel Co. reflected the following information for the year ended December 31, 2016: Date Transaction Number of Units Unit Cost Total Cost 1/1 Beginning inventory 150 $ 32 $ 4,800 1/24 Purchase 70 33 2,310 2/22 Sale (100 ) - - 3/7 Purchase 90 35 3,150 4/10 Purchase 140 38 5,320 6/11 Sale (100 ) - - 9/28 Purchase 50 38 1,900 12/4 Sale (100 ) - - Required: a. Assume that Kuffel Co. uses...