Inventories&Inventoryestimation GAPASINAO
Inventories&Inventoryestimation GAPASINAO
Inventories&Inventoryestimation GAPASINAO
Problem 3: EXERCISES
1. Joca Co. 2. Worried Co.
(a) FOB Shipping point, Freight collect Perpetual Inventory System
Dec. 31, 20x1 Purchases 100,000 a. Inventory
Accounts payable 100,000 Accounts Payable
Jan. 2 20x2 Freight-In 10,000 Freight In
Cash 10,000
Jan. 5 20x2 Accounts Payable 100,000 b. Accounts Payable
Cash 100,000 Inventory
(b) FOB destination, Freight prepaid c. Accounts Receivale
Dec. 31, 20x1 No entry Sales
Cost of goods sold
Jan. 2 20x2 Purchases 100,000 Inventory
Accounts payable 100,000 d. Sales returns
Jan. 5 20x2 Accounts Payable 100,000 Accounts receivale
Cash 100,000 Inventory
(c) FOB Shipping point, Freight prepaid Cost of goods sold
Dec. 31, 20x1 Purchases 100,000
Freight-In 10,000 5. Using T Account
Accounts Payable 110,000 Inventory beg
Jan. 2 20x2 No entry a. 10,000
b. 36,000
Jan. 5 20x2 Accounts Payable 110,000 c. 15,000
Cash 110,000 d. 25,200
(d) FOB destination, Freight collect
Dec. 31, 20x1 No entry Solution:
Jan. 2 20x2 Purchases 100,000 a.
Accounts Payable 90,000 Inventory beg -
Cash 10,000 Net purchases -
Jan. 5 20x2 Accounts Payable 90,000
Cash 90,000
b.
Inventory beg -
Net purchases -
c.
Inventory beg -
Net purchases -
d.
Inventory beg -
Net purchases -
erpetual Inventory System Periodic Inventory System
54,000 Purchases 50,000
50,000 Freight In 4,000
4,000 Accounts payable 50,000
cash 4,000
5,000 Accounts Payable 5,000
5,000 Purchases Returns 5,000
90,000 Accounts Receivable 90,000
90,000 Sales 90,000
30,000
30,000
6,000 Sales returns 6,000
nts receivale 6,000 Accounts receivable 6,000
2,000
2,000
Inventory
10,000
198,000 112,000 Cost of Sales
96,000 Inventory End
Inventory
36,000
145,000 125,000 Cost of Sales
56,000 Inventory End
Inventory
15,000
58,000 64,000 Cost of Sales
9,000 Inventory End
Inventory
25,200
112,000 89,200 Cost of Sales
48,000 Inventory End
3
Effect of error on
Nature of Error Gross Profit COGS
a. Overstatement of begging inventory Understatemnent Overstatement
b. Understatement of purchases Overstatement Understatemnent
c. Overstatement of purchase returns Overstatement Understatemnent
d. Understatement of purchase returns Understatemnent Overstatement
e. Overstatement of ending inventory Overstatement Understatemnent
f. Understatement of ending Inventory Understatemnent Overstatement
4. Horizon Co.
Gross Method Net Method
Purchase of Inventory
Purchases 90,000 Purchases 88,200
Accounts Payable 90,000 Accounts Payable 88,200
i. The account was paid beyondthe discount period
Accounts Payable 90,000 Accounts Payable 88,200
Purchase discount 1,800 Cash 88,200
Cash 88,200
ii. The account was paid within the discount period
Accounts payable 90,000 Accounts payable 88,200
Cash 90,000 Purchase discount 1,800
Cash 90,000
Problem 4: Multiple choice Computational
Solutions:
1. B. 276,000
Unadjusted bal. (dec. 31, x1) 260,000
(a) 11,000
(b) 5,000
© (16,000)
(d) 20,000
(e) (4,000)
Correct Inventory 276,000
2. C. 75000
Unadjusted Bal 75,000
Included. FOB shipping point (June 30,2002 1,500
Excluded.FOB Destination(July 3, 2002) 2,500
Inventory june 30, 2002 75,000
*No necessary journal entry are needed
3. D. 512,000
Ware house Goods held by consignees
Begging Inventory 110,000 12,000
Purchases 480,000 60,000
Freight in 10,000
Transporation to consignees 5,000
TGAS 600,000 77,000
Ending Inventory (145,000) (20,000)
Cost of goods sold 455,000 57,000
4. D. 43,000
Mark up unsold consigned goods(40k x40%) 16,000
Goods held on consignement by opal 27,000
Total reduction in inventory 43,000
5. C 178,000;178.400
Net method (80k +100k) x 98%) 178,000
Gross Method(80k*98%)+100k 178,400
6. C. 372,400;380,000
Inventory (380k*98%) 372,400
Accounts Payable(372,400+7600) 380,000
Initial recognition on Dec. 15, 20x1
Purchases 372,400
Accounts payable 372,400
Adjusting Entry on Dec. 31, 20x1
Purchases discount loss (389k*2%) 7,600
Accounts payable 7,600
7. A 19,600;176,400
EI(200,000 x98% x 10%) 19,600
COGS(200,000x98%x90%) 176,400
utational
8. C (20,000;176,800;19,680;177,120)
I. Discount is allocated only to the goods sold:
Gross amounts Allocation of discounts
EI (200kx10%) 20,000
COGS (200k*90%) 180,000 3,200
Total 200,000 3,200
II. Discount is allocated to both EI and COGS
Gross amounts Allocation of discounts
EI (200kx10%) 20,000 320
COGS (200k*90%) 180,000 2,880
Total 200,000 3,200
9. D. (31,500;51,100,31,500;51,100)
FIFO periodic
Ending Inventory in units = 1,400-400+800-900+700-600=1,000units
In units Unit Cost
Ending Inventory 1,000
Total Allocation to june 24 purchases (700) 30
Excess allocated to june 14 purchases 300 35
Ending Inventory in pesos
Total TGAS, in pesos
Date Transaction Quantity
1-Jun Balance forwarded 1,400
14-Jun Purchases 800
512,000 24-Jun Purchases 700
Total TGAS, in pesos
TGAS, in pesos 82,600
Ending Inventory (31,500)
Cost of goods sold 51,100
FIFO perpetual
In units Unit Cost
Balance 1,400 24
Sale 400 24
Purchases 800 35
Sale 900 24
Purchases 700 30
Sale 600
100 from june 1 24
500 from june 14 35
Ending Inventory
Cost of Goods sold(9,600+21,600+2,400+17,500)
10. A. (28,480;54,120;26,880;55,720)
Weighted average periodic
Weighted ave. Unit Cost = TGAS, in pesos/Tgas, in units
15. C. 430,000
Sales 1,000,000
Sales discount (50,000)
Unit Cost Total cost Sales returns (10,000)
Net sales 940,000
Cost of goods sold:
38.60 61,760 Beg inv. 60,000
Purchases 500,000
38 91,200 Purchases returns (25,000)
152,960 Purchases discount (10,000)
Freight In 60,000
TGAS 585,000
Units Unit Cost Total Cost Ending Inv. (75,000) (510,000)
2,000 36 72,000 Gross Profit 430,000
3,000 37.20 111,600
4,800 38 182,400 16. C. 504,900
1,900 38.60 73,340 X Y
(300) 38.60 (11,580) Cost (50+5);(30+4);(109+68) 55 34
427,760 NRV(56-4);(60-8);(250-75) 52 52
Lower 52 34
No. of units 3,700 2,500
Total 192,400 85,000
17. D. 0
18. B. 30,000
Recovery 20x2 40,000 = (490,000-450,000)
Reversal of inventory wite down 30,000 = (440,000-410,000)
19. B. 60,000;585,000
Inventory
beg. 60,000
Net. Purchase 465,000
Freight In(squeeze) 60,000 510,000
75,000
TGAS 510,000
Ending Inventory 75,000
Cost of goods available for sale 585,000
Quantity Unit Cost In pesos
2,000 36 72,000 20. A. 25,000;75,000
3,000 37.20 111,600 Inventory
5,000 36.72 183,600 beg. 60,000 25,000
(4,200) (154,224) Purchases 500,000 10,000
4,800 38 182,400 Freight In 60,000 510,000
5,600 37.82 211,776 75,000
600 36.72 22,032
6,200 37.71 233,808
(3,800) 37.71 (143,298)
1,900 38.60 73,340
(300) 38.60 (11,580)
152,270
Z Total
177
175
175
1,300
227,500 504,900
(440,000-410,000)
COGS
Ending Inv.
Purchase returns
Purchase discounts
COGS
End (585K TGAS - 510K COGS)
Inventory Estimation: Problem #3 - page 450 - 455
2. D. 56,400
Inventory
Inventory beg. 162,000
Net purchases 3,412,000 3,018,600 COGS(4,654,000-10,000) x 65%
555,400 end.
(56,000) Goods in transit
(443,000) Actual Inventory
56,400 Lost due to theft
3. D. 124,920
2001
Net sales(788,000-16,000) 772,000
Cost of sales:
Inventory, january 1 -
Purchases 860,000
Purchase returns & Allowances (46,120)
Inventory, end (173,120) (640,760)
Gross profit 2001 131,240
Inventory 2002
Inventory beg. 173,120
Net purchases 627,400 652,800 COGS
147,720 end.
4. A. 120,000
Accounts Payable
- beg.
Payment to suppliers 80,000 90,000 Net purchases
end. 10,000
Inventory
beg. 30,000
Net purchases 90,000 120,000 COGS
- end.
5. A. 29,000
Accounts Payable
29,000 beg.
Payment to suppliers 20,000 43,500 Gross purchases
Purchases returns 2,500
Purchase discounts 5,000
end 45,000
Raw materials
beg. 5,000
Gross purchases 43,500 2,500 Purchases returns
Freight In 1,000 5,000 Purchase discounts
36,000 RM issued to production
6,000 end
Work in process
beg. 20,000
RM issued to production 36,000 51,000 COGM
Direct labor 16,000
Factory overhead 6,000
27,000 end
Finished goods
beg. 23,000
COGM 51,000 45,000 COGS
29,000 end
6. B. 260,500
Raw materials
beg. 11,000
Purchases 150,000 146,000 DM
15,000 end
Work in process
beg. 20,000
Direct materials 146,000
Direct labor 60,000
Factory overhead:
Indirect factorylabor 30,000
Taxes & depr. On factory-bldg 10,000
Utilities 15,000
257,000 COGM
24,000 end
Finished goods
beg. 12,500
COGM 257,000 260,500 COGS
9,000 end
7. D. 283,329.30;284,698.80
Cost Retail
Inventory at jan. 1, 2002 45,000 75,000
Purchases 270,000 590,000
Freight In 6,750
Markups 50,000
Markdowns (20,000)
TGAS 321,750 695,000
Net sales (612,000)
Ending inventory in retail 83,000
8. C. 49,126;64,474
Cost Retail
Purchases 110,600 160,600
Freight in 4,000
Purchase discounts (1,000)
Purchase returns (10,400) (17,200)
Nets purchases 103,200 143,400
Sales 87,600
Sales returns (5,000)
Employee discount 1,000
Normal spoilage 400
Nets sales 84,000
Cost Retail
Inventory, January 1 20,000 28,000
Net Purchases 103,200 143,400
Departmental transfers-In 2,000 3,000
Departmental transfers-out (1,600) (2,400)
Net markups 8,000
Net Markdowns (18,000)
Abnormal spoilage (10,000) (14,000)
Total goods for sale 113,600 148,000
Net Sales (84,000)
Ending inventory at retail 64,000
10. A. 54,600
Cost Retail
Inventory, beg 36,000
Purchases 320,000
Freight in 18,000
Purchase discounts (3,000)
TGAS at sales price 371,000 530,000
Sales 454,000
sales returns (2,000)
Ending inventory at sales price 78,000
TGAS at sales price 530,000