In: Accounting
Surf Deals had the following inventory (surfboards) information available for June and records their inventory using the periodic inventory method.
Date Transaction Units Unit Cost
June 1 Beginning inventory 100 $200
June 2 Purchase 100 $220
June 5 Sale @ $350 per unit (75)
June 18 Purchase 200 $225
June 25 Purchase 100 $230
June 29 Sale @ $360 per unit (200)
Assume that the company uses the FIFO inventory method. Develop an inventory worksheet.
Inventory: ___________ Cost of Goods Sold: ___________
Inventory: ___________ Cost of Goods Sold: ___________
Solution: A | |||||||||||
FIFO METHDO | |||||||||||
COST OF GOODS AVAILABLE FOR SALE | COST OF GOODS SOLD | ENDING INVENTORY | |||||||||
Date | Particulars | No. of Units | Cost Per unit | Total | No. of Units | Cost Per unit | Cost of Goods Sold | No. of Units | Cost Per unit | Ending inventory | |
June, 01 | Beginning Balance | 100 | $ 200.00 | $20,000 | 100 | $ 200.00 | $20,000 | ||||
June, 02 | Purchases | 100 | $ 220.00 | $22,000 | 100 | $ 220.00 | $22,000 | ||||
June, 08 | Purchases | 200 | $ 225.00 | $45,000 | 75 | $ 225.00 | $16,875 | 125 | $ 225.00 | $28,125 | |
June, 25 | Purchases | 100 | $ 230.00 | $23,000 | 100 | $ 230.00 | $23,000 | ||||
Total Goods Available For sale | 500 | $1,10,000 | 275 | $58,875 | 225 | $51,125 | |||||
Weighted Average Cost | |||||||||||
COST OF GOODS AVAILABLE FOR SALE | COST OF GOODS SOLD | ENDING INVENTORY | |||||||||
Date | Particulars | No. of Units | Cost Per unit | Total | No. of Units | Cost Per unit | Cost of Goods Sold | No. of Units | Cost Per unit | Ending inventory | |
June, 01 | Beginning Balance | 100 | $ 200.00 | $20,000 | |||||||
June, 02 | Purchases | 100 | $ 220.00 | $22,000 | |||||||
June, 08 | Purchases | 200 | $ 225.00 | $45,000 | |||||||
June, 25 | Purchases | 100 | $ 230.00 | $23,000 | |||||||
Total Goods Available For sale | 500 | $220.00 | $1,10,000 | 275 | $220.00 | $60,500 | 225 | $220.00 | $49,500 | ||
Answer = A -1 | |||||||||||
Ending Inventory | Cost of Goods Sold | ||||||||||
FIFO | $51,125 | $58,875 | |||||||||
Answer = A -2 | |||||||||||
Weighted average Cost | $49,500 | $60,500 | |||||||||
Answer = A -3 |
Related SolutionsSurf Deals had the following inventory (surfboards) information available for June and records their inventory using...Surf Deals had the following inventory (surfboards) information
available for June and records their inventory using the periodic
inventory method.
Date
Transaction
Units
Unit Cost
June 1 Beginning
inventory
100
$200
June 2 Purchase
100
$220
June 5 Sale @ $350 per
unit
(75)
June 18 Purchase
200
$225
June 25 Purchase
100
$230
June 29 Sale @ $360 per
unit
(200)
Assume that the company uses the FIFO inventory method. Develop
an inventory worksheet.
...
The following information was available from the January inventory records of Rich Company:The following information was available from the January
inventory records of Rich Company:
Units Unit
Cost Total Cost
Balance at January
1
800
$10.00
$8,000
Purchases:
January
6
600
11.00
6,600
January
26
800 12.00 9,600
Rich maintains a perpetual inventory system and
costs inventory using last-in, first-out (LIFO). Sales included:
900 units on Jan 7, and 600 units on Jan 31. All units sold for $20
each. Operating expenses were $500 for the month of January. Assume
a 40%...
The following information was available from the inventory records of Anderson Corp. for January:
The following
information was available from the inventory records of Anderson
Corp. for January:
Units Unit
Cost
Balance at March
1
3,100
9.75
Purchases:
03/05/2016
2,000 10.50
03/25/2015
2,500 10.70
Sales:
03/08/2016
-2,750
03/30/2016
-3,500
Balance at March
31
1,350
Assuming that Anderson
maintains perpetual inventory records, what should be the inventory
at March 31, using the moving-average inventory method, rounded to
the nearest dollar?
Select one:
A. $13,851
B. $13,928
C. $14,016
D. $14,224
Skate ‘n’ Surf began operations on 1 June, buying and selling surfboards, skateboards, wetsuits and the...Skate ‘n’ Surf began operations on 1 June, buying and selling
surfboards, skateboards, wetsuits and the protective gear for
skateboarding. The structure of the business is that of a sole
trader.
The business employed a sales assistant during the month who is to
be paid fortnightly. Tax is deducted from the employee’s wages
(PAYG withholding tax) and remitted to the Australian Taxation
Office (ATO) on a quarterly basis.
The business has not registered with the
ATO for the goods and...
Skate ‘n’ Surf began operations on 1 June, buying and selling surfboards, skateboards, wetsuits and the...Skate ‘n’ Surf began operations on 1 June, buying and selling
surfboards, skateboards, wetsuits and the protective gear for
skateboarding. The structure of the business is that of a sole
trader.
The business employed a sales assistant during the month who is to
be paid fortnightly. Tax is deducted from the employee’s wages
(PAYG withholding tax) and remitted to the Australian Taxation
Office (ATO) on a quarterly basis.
The business has not registered with the
ATO for the goods and...
Skate ‘n’ Surf began operations on 1 June, buying and selling surfboards, skateboards, wetsuits and the...
Skate ‘n’ Surf began operations on 1 June, buying and selling
surfboards, skateboards, wetsuits and the protective gear for
skateboarding. The structure of the business is that of a sole
trader.
The business employed a sales assistant during the month who is to
be paid fortnightly. Tax is deducted from the employee’s wages
(PAYG withholding tax) and remitted to the Australian Taxation
Office (ATO) on a quarterly basis.
The business has not registered with the
ATO for the goods and...
Skate ‘n’ Surf began operations on 1 June, buying and selling surfboards, skateboards, wetsuits and the...Skate ‘n’ Surf began operations on 1 June, buying and selling
surfboards, skateboards, wetsuits and the protective gear for
skateboarding. The structure of the business is that of a sole
trader.
The business employed a sales assistant during the month who is to
be paid fortnightly. Tax is deducted from the employee’s wages
(PAYG withholding tax) and remitted to the Australian Taxation
Office (ATO) on a quarterly basis.
The business has not registered with the
ATO for the goods and...
Skate ‘n’ Surf began operations on 1 June, buying and selling surfboards, skateboards, wetsuits and the...Skate ‘n’ Surf began operations on 1 June, buying and selling
surfboards, skateboards, wetsuits and the protective gear for
skateboarding. The structure of the business is that of a sole
trader. The business employed a sales assistant during the month
who is to be paid fortnightly. Tax is deducted from the employee’s
wages (PAYG withholding tax) and remitted to the Australian
Taxation Office (ATO) on a quarterly basis.
The business has not registered with the ATO for the goods and...
Happy Company uses the periodic inventory method and had the following inventory information available:Happy Company uses the periodic inventory method and had the
following inventory information available:
Units Unit Cost
Total Cost
1/1 Beginning
Inventory
100
$4
$400
1/20
Purchase
400
$6
$2400
7/25
Purchase
200
$7
$1400
10/20
Purchase
300
$8
$2400
1,000
$6,600
A physical county if inventory on December 31 revealed that
there were 400 units on hand
Answer questions below and show computations supporting the
answer:
Assume that the company uses the FIFO...
Anabtawi Company uses the periodic inventory method and had the following inventory information available: ( 8...Anabtawi Company uses the periodic inventory method and had the
following inventory information available: ( 8 points)
Date
Explanation
Number of Units
Unit Cost
Total Cost
January 1
Beginning inventory
100
$4
$400
January 20
Purchase
400
$5
$2,000
July 25
Purchase
300
$6
$1,800
October 20
Purchase
200
$7
$1,400
Total
1000
$5,600
A physical count of inventory on December 31 revealed that there
were 300 units on hand.
Assume that the company uses the FIFO method. The Ending...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|