Question

In: Accounting

Wildhorse Co. has the following inventory data: July 1 Beginning inventory 32 units at $21 $672...

Wildhorse Co. has the following inventory data: July 1 Beginning inventory 32 units at $21 $672 7 Purchases 113 units at $22 2486 22 Purchases 16 units at $24 384 $3542 A physical count of merchandise inventory on July 30 reveals that there are 52 units on hand. Using the FIFO inventory method, the amount allocated to cost of goods sold for July is

a. $2366

b. $1112

c. $2430

d. $1176

Solutions

Expert Solution

  • Correct Answer = Option ‘a’ $ 2,366
  • Workings

>Units available = 32 + 113 + 16 = 161 units
>Units in ending inventory = 52 units
>Units sold = 161 – 52 = 109 units

>Cost of Goods Sold calculation:

FIFO

Cost of Goods available for sale

Cost of Goods Sold

Ending Inventory

Units

Cost/unit

COG for sale

Units sold

Cost/unit

COGS

Units

Cost/unit

Ending inventory

Beginning Inventory

32

$                21.00

$                            672.00

32

$         21.00

$              672.00

0

$        21.00

$                         -  

Purchases:

07-Jul

113

$                22.00

$                        2,486.00

77 [109 – 32]

$         22.00

$           1,694.00

36

$        22.00

$                792.00

22-Jul

16

$                24.00

$                            384.00

0

$         24.00

$                        -  

16

$        24.00

$                384.00

TOTAL

161

$                        3,542.00

109

$           2,366.00 = ANSWER

52

$            1,176.00


Related Solutions

Tamarisk, Inc. has the following inventory data: July 1 Beginning Inventory 42 units at $21 $882...
Tamarisk, Inc. has the following inventory data: July 1 Beginning Inventory 42 units at $21 $882 7 Purchases 146 units at $22 3212 22 Purchases 21 units at $23 483 $4577 A physical count of merchandise inventory on July 30 reveals that there are 52 units on hand. Using the FIFO inventory method, the amount allocated to cost of goods sold for July is a.$3412. b.$3381. c.$3475. d.$3308.
Ayayai Corp. has the following inventory data: July 1 Beginning inventory 28 units at $18 $504...
Ayayai Corp. has the following inventory data: July 1 Beginning inventory 28 units at $18 $504 7 Purchases 99 units at $19 1881 22 Purchases 14 units at $21 294 $2679 A physical count of merchandise inventory on July 30 reveals that there are 45 units on hand. Using the LIFO inventory method, the amount allocated to ending inventory for July is $827. $810. $855. $945.
Blossom has the following inventory data: July 1 Beginning inventory 35 units at $71 5 Purchases...
Blossom has the following inventory data: July 1 Beginning inventory 35 units at $71 5 Purchases 212 units at $66 14 Sale 142 units 21 Purchases 106 units at $68 30 Sale 99 units Assuming that a perpetual inventory system is used, what is the ending inventory on a LIFO basis for July? $7869 $7569 $7581 $7617
Oriole has the following inventory data: July 1 Beginning inventory 34 units at $67 5 Purchases...
Oriole has the following inventory data: July 1 Beginning inventory 34 units at $67 5 Purchases 202 units at $63 14 Sale 134 units 21 Purchases 101 units at $65 30 Sale 94 units Assuming that a perpetual inventory system is used, what is ending inventory (rounded) under the average cost method for July? (Round intermediate calculations to 3 decimal places, e.g. 12.531.) a. $6319 b. $7007 c. $7075 d. $7051
Marigold has the following inventory data: July 1 Beginning inventory 31 units at $16 $496 7...
Marigold has the following inventory data: July 1 Beginning inventory 31 units at $16 $496 7 Purchases 109 units at $16 1744 22 Purchases 16 units at $17 272 $2512 A physical count of merchandise inventory on July 30 reveals that there are 39 units on hand. Using the LIFO inventory method, the amount allocated to ending inventory for July is
Trumpeting Trumpets has the following inventory data: July 1 Beginning inventory 62 units at $149 5...
Trumpeting Trumpets has the following inventory data: July 1 Beginning inventory 62 units at $149 5 Purchases 372 units at $139 14 Sale 248 units 21 Purchases 186 units at $143 30 Sale 174 units Assuming that a periodic inventory system is used, what is the cost of goods sold on a FIFO basis?
Windsor, Inc. has the following inventory data: July 1 Beginning inventory 26 units at $5.20 5...
Windsor, Inc. has the following inventory data: July 1 Beginning inventory 26 units at $5.20 5 Purchases 103 units at $5.70 14 Sale 69 units 21 Purchases 52 units at $6.20 30 Sale 48 units Assuming that a perpetual inventory system is used, what is the value of ending inventory on a LIFO basis for July?
Snug-As-A-Bug Blankets has the following inventory data: July 1 Beginning inventory 23.0 units at $47.0 5...
Snug-As-A-Bug Blankets has the following inventory data: July 1 Beginning inventory 23.0 units at $47.0 5 Purchases 140.0 units at $44.0 14 Sale 94.0 units 21 Purchases 70.0 units at $45.0 30 Sale 66.0 units Assuming that a perpetual inventory system is used, what is the ending inventory on a LIFO basis for July?
Problem 6-3A Wildhorse Co. had a beginning inventory on January 1 of 308 units of Product...
Problem 6-3A Wildhorse Co. had a beginning inventory on January 1 of 308 units of Product 4-18-15 at a cost of $19 per unit. During the year, the following purchases were made. Mar. 15 820 units at $22 Sept. 4 718 units at $25 July 20 513 units at $23 Dec. 2 205 units at $28 2,050 units were sold. Wildhorse Co. uses a periodic inventory system a.Determine the cost of goods available for sale. b. Calculate average cost per...
Carla Vista Co. had a beginning inventory balance on July 1 of 410 units at a...
Carla Vista Co. had a beginning inventory balance on July 1 of 410 units at a cost of $3.00 each. During the month, the following inventory transactions took place: Purchases Sales Date Units Cost per unit Date Units Price per unit July 10 1,600 $3.10 July 2 270 $5.90 13 670 3.50 11 1,010 5.90 27 600 3.90 28 730 6.40 (a) Correct answer iconYour answer is correct. Calculate the cost of goods available for sale and the number of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT