Question

In: Accounting

36) Gabby Company operates under a perpetual inventory system. It began operations on March 1, 20X9,...

36) Gabby Company operates under a perpetual inventory system. It began operations on March 1, 20X9, and had the following transactions affecting inventory during March, 20X9.

March 1 Purchase 500 units @ $5.00 $2,500

March 5 Sale 200 units

March 10 Purchase 300 units @ $5.20 $1,560

March 15 Sale 320 units

March 20 Purchase 400 units @ $5.40 $2,160

March 25 Sale 230 units

Determine the cost of goods sold for the month of March, 20X9 and the ending inventory balance at March 31, 20X9. Assume the company uses the first-in-first-out (FIFO) cost flow assumption.

37) Gabby Company operates under a perpetual inventory system. It began operations on March 1, 20X9, and had the following transactions affecting inventory during March, 20X9.

March 1 Purchase 500 units @ $5.00$2,500

March 5 Sale 200 units

March 10 Purchase 300 units @ $5.20 $1,560

March 15 Sale 320 units

March 20 Purchase 400 units @ $5.40 $2,160

March 25 Sale 230 units

Assume the company is trying to decide between the periodic method and the perpetual method. Gabby has decided to use the last-in-first-out cost flow assumption. Determine the cost of goods sold for the month of March, 20X9 and the ending inventory balance at March 31, 20X9, using both the perpetual method and the periodic method.

Solutions

Expert Solution

Ans. 36 Perpetual FIFO:
Purchase Cost of goods sold Balance
Date Quantity Rate Total cost Quantity Rate Total cost Quantity Rate Total cost
1-Mar 500 $5.00 $2,500 500 $5.00 $2,500
5-Mar 200 $5.00 $1,000 300 $5.00 $1,500
10-Mar 300 $5.20 $1,560 300 $5.00 $1,500
300 $5.20 $1,560
15-Mar 300 $5.00 $1,500
20 $5.20 $104 280 $5.20 $1,456
20-Mar 400 $5.40 $2,160 280 $5.20 $1,456
400 $5.40 $2,160
25-Mar 230 $5.20 $1,196 50 $5.20 $260
400 $5.40 $2,160
Total Cost of goods sold $3,800 Ending inventory $2,420
*In FIFO method the units that have purchased first (earliest), are released the first one and the ending inventory
units remain from the last (recent) purchases.
Ans. 37 LIFO:
Purchase Cost of goods sold Balance
Date Quantity Rate Total cost Quantity Rate Total cost Quantity Rate Total cost
1-Mar 500 $5.00 $2,500 500 $5.00 $2,500
5-Mar 200 $5.00 $1,000 300 $5.00 $1,500
10-Mar 300 $5.20 $1,560 300 $5.00 $1,500
300 $5.20 $1,560
15-Mar 300 $5.20 $1,560
20 $5.00 $100 280 $5.00 $1,400
20-Mar 400 $5.40 $2,160 280 $5.00 $1,400
400 $5.40 $2,160
25-Mar 230 $5.40 $1,242 280 $5.00 $1,400
170 $5.40 $918
Total Cost of goods sold $3,902 Ending inventory $2,318
*In LIFO method the units that have purchased last, are released the first one and the ending inventory
units remain from the first purchases.
Periodic LIFO:
Total units sold (200+320+230) = 750 units
LIFO: Cost of goods available for sale Cost of goods sold - Periodic LIFO Ending inventory - Periodic LIFO
Units Rate Total Units Rate Total Units Rate Total
1-Mar 500 $5.00 $2,500 50 $5.00 $250 450 $5.00 $2,250
10-Mar 300 $5.20 $1,560 300 $5.20 $1,560 0 $5.20 $0
20-Mar 400 $5.40 $2,160 400 $5.40 $2,160 0 $5.40 $0
Total 1200 $6,220 750 $3,970 450 $2,250
Cost of goods sold under Periodic LIFO method =   $3,970.
Ending inventory under Periodic LIFO method =   $2,250.

Related Solutions

Terando Co. began operations on July 1. It uses a perpetual inventory system. During July, the...
Terando Co. began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales. Date: July 1: 8 units $110 cost of units July 6: 7 sales units July 11: 12 units $126 cost of units July 14: 5 sales units July 21: 13 units $137 cost of units July 27: 10 sales units a) Calculate the average cost per unit at July 1, 6, 11, 14, 21, & 27. b)...
Lyon Center began operations on July 1. It uses a perpetual inventory system. During July, the...
Lyon Center began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales. Purchases Date Units Unit Cost Sales Units July 1 7 $62 July 6 5 July 11 3 $66 July 14 3 July 21 4 $71 July 27 3 New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is incorrect. Calculate average cost for each unit. (For calculation and answers...
Problem 9-1 Fitzgibbons Company uses the perpetual inventory method. Fitzgibbons began the month of March with...
Problem 9-1 Fitzgibbons Company uses the perpetual inventory method. Fitzgibbons began the month of March with 100 units of inventory, at a unit cost of $55. On March 5, Fitzgibbons purchased 60 units at $60 each. On March 12, they sold 60 units On March 18, Fitzgibbons purchased 200 units at $65 each On March 25, Fitzgibbons sold 210 units. On March 29, Fitzgibbons purchased 40 units at $75 each. All units were sold to customer for $100 each. Use...
P6-9A Terando Co. began operations on July 1. It uses a perpetual inventory system. During July,...
P6-9A Terando Co. began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales. July 1. Units 5 Unit Cost $120 Sales July 6. Sales Units 4 July 11. Units 7 Unit Cost $136 July 14. Sales Units 3 July 21. Units 8 Unit Cost $147 July 27. Sales units 6 a) Determine the ending inventory under a perpetual inventory system using (1) FIFO, (2) moving-average cost, and (3) LIFO....
Save-Mart Center Inc. began operations on May 1 and uses a perpetual inventory system. During May,...
Save-Mart Center Inc. began operations on May 1 and uses a perpetual inventory system. During May, the company had the following purchases and sales for one of its products: Purchases Sales Date Units Unit Cost Units Unit Price May  1 120 $100 3 80 $250 8 100  110 13 80  275 15  60  115 20 60  300 27 40  325 Instructions (a)   Determine the cost of goods sold and cost of ending inventory using (1) FIFO and (2) average cost....
A company that uses a FIFO inventory system and began operations in Year 1 has the...
A company that uses a FIFO inventory system and began operations in Year 1 has the following information. Year 1 Year 2 Sales units 8,000 10,000 Selling price $45 $46 Production units 12,000 8,000 Unit direct material cost $2.00 $2.00 Unit direct labor cost $1.00 $1.00 Unit commission cost $.50 $.50 Annual Fixed Overhead $180,000 $180,000 Annual Fixed S,G,&A $140,000 $150,000 1. What are the inventoriable cost per unit in years 1 and 2? Absorption Costing Variable Costing 2. What...
Pearl Company began operations on January 1, 2016, adopting the conventional retail inventory system.
Pearl Company began operations on January 1, 2016, adopting the conventional retail inventory system. None of the company’s merchandise was marked down in 2016 and, because there was no beginning inventory, its ending inventory for 2016 of $38,000 would have been the same under either the conventional retail system or the LIFO retail system.On December 31, 2017, the store management considers adopting the LIFO retail system and desires to know how the December 31, 2017, inventory would appear under both...
1. Under the perpetual inventory system, inventory becomes part of cost of goods sold when a...
1. Under the perpetual inventory system, inventory becomes part of cost of goods sold when a company a. receives payment from the customer b. purchases the inventory c. sells the inventory d. pays for the inventory 2. In credit terms of 4/13, n/45, the "4" represents the a. number of days in the discount period b. number of days when the entire amount is due c. full amount of the invoice d. percent of the cash discount 3. Merchandise with...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.
  Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.   Date Activities Units Acquired at Cost Units Sold at Retail   Mar. 1   Beginning inventory   120 units @ $51.40 per unit           Mar. 5   Purchase   235 units @ $56.40 per unit           Mar. 9   Sales           280 units @ $86.40 per unit  ...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.   Date Activities Units Acquired at Cost Units Sold at Retail   Mar. 1   Beginning inventory   140 units @ $51.80 per unit           Mar. 5   Purchase   245 units @ $56.80 per unit           Mar. 9   Sales           300 units @ $86.80 per unit   Mar....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT