Data given | |||
Units | Unit Cost | ||
1-Jan | Beginning inventory | 4,190 | $20 |
12-Feb | Purchase | 4,630 | $25 |
2-Mar | Sale | 3,640 | $38 |
18-Apr | Purchase | 5,950 | $28 |
31-May | Sale | 5,180 | $40 |
Total Units Sold | 8,820 | ||
Based on the data above, compute the cost of goods sold under FIFO (perpetual/periodic), LIFO (perpetual/periodic), weighted-average (periodic) and moving-average (perpetual).
To calculate cost of goods sold and ending inventory there are following methods
Under periodic method inventory account is not updated regularly it is adjusted at the end of accounting period.
Under perpetual method inventory account is changed regularly .
Data given Units Unit Cost 1-Jan Beginning inventory 4,190 $20 12-Feb Purchase 4,630 $25 2-Mar Sale...
Why Moms A Option #1: Inventory Costing & Periodic and Perpetual Inventory Systems Jordan Company is a manufacturing firm. Presented below is information concerning one of its products: 1/1 Beginning inventory 4,190 $20 2/12 Purchase 4,630 $25 3/2 Sale 3,640 $38 4/18 Purchase 5,950 $28 5/31 Sale 5,180 $40 Part A Use the ACT350_CTTemplate_Mod5_option1.xlsx file (in the module folder) to compute the cost of goods sold under the following situations: 1. Periodic system, FIFO cost flow 2. Perpetual system, FIFO...
Jordan Company is a manufacturing firm. Presented below is information concerning one of its products: Compute the cost of goods sold under the following situations: Periodic system, FIFO cost flow Perpetual system, FIFO cost flow Periodic system, LIFO cost flow Perpetual system, LIFO cost flow Periodic system, weighted-average cost flow Perpetual system, moving-average cost flow Your answers must be submitted in an Excel file and must show all calculations used to arrive at the final answers. Data given Unit Cost...
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...
Activities Date Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Units Acquired at Cost 22e units $53.40 per unit 285 units $58.40 per unift Units Sold at Retail 38e units $88.40 per unit 145 units $63.40 per unit 270 units $65.40 per unit 25e units $98.4e per unit Totals 92e units 630 units . Compute the cost assigned to ending Inventory using (a) FIFO, (b) LIFO, (c) welghted average,...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,200 $74.00 $532,800 10 Purchase 21,600 84.00 1,814,400 28 Sale 10,800 148.00 1,598,400 30 Sale 3,600 148.00 532,800 Feb. 5 Sale 1,440 148.00 213,120 10 Purchase 51,840 86.50 4,484,160 16 Sale 25,920 158.00 4,095,360 28 Sale 24,480 158.00 3,867,840 Mar. 5 Purchase 43,200...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,700 $79.00 $608,300 10 Purchase 23,100 89.00 2,055,900 28 Sale 11,550 158.00 1,824,900 30 Sale 3,850 158.00 608,300 Feb. 5 Sale 1,540 158.00 243,320 10 Purchase 55,440 91.50 5,072,760 16 Sale 27,720 168.00 4,656,960 28 Sale 26,180 168.00 4,398,240 Mar. 5 Purchase 46,200...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,300 $77.00 $562,100 10 Purchase 21,900 87.00 1,905,300 28 Sale 10,950 154.00 1,686,300 30 Sale 3,650 154.00 562,100 Feb. 5 Sale 1,460 154.00 224,840 10 Purchase 52,560 89.50 4,704,120 16 Sale 26,280 164.00 4,309,920 28 Sale 24,820 164.00 4,070,480 Mar. 5 Purchase 43,800...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,600 $71.00 $539,600 10 Purchase 22,800 81.00 1,846,800 28 Sale 11,400 142.00 1,618,800 30 Sale 3,800 142.00 539,600 Feb. 5 Sale 1,520 142.00 215,840 10 Purchase 54,720 83.50 4,569,120 16 Sale 27,360 152.00 4,158,720 28 Sale 25,840 152.00 3,927,680 Mar. 5 Purchase 45,600...
The following is the inventory record of widgets for the ABC Company Units Cost/Unit 1-Jan Beginning Inventory 1001 $10.00 15-Apr Purchase 2001 $11.00 24-Aug Purchase 300 $12.00 27-Nov Purchase 400 $13.00 At the end of the fiscal year, the physical inventory found 450 widgets on hand at 12/31. Total sales for the year were 500 widgets sold at a retail price of $20.00 per widget Required: (a) Calculate the endign inventory value under FIFO, LIFO and Weighted Average (b) Calculate...
Inventory Date Activity Units Unit Cost Balance 1-Mar Beginning Balance 250 $14 $3,500 3-Mar Sale (200) - - 0 10-Mar Purchase 200 15 ...