Question

In: Accounting

Perpetual Inventory Using Weighted Average Beginning inventory, purchases, and sales for WCS12 are as follows: Oct....

Perpetual Inventory Using Weighted Average

Beginning inventory, purchases, and sales for WCS12 are as follows:

Oct. 1 Inventory 300 units at $13
13 Sale 170 units
22 Purchase 370 units at $14
29 Sale 200 units

a. Assuming a perpetual inventory system and using the weighted average method, determine the weighted average unit cost after the October 22 purchase. Round your answer to two decimal places.
$per unit

b. Assuming a perpetual inventory system and using the weighted average method, determine the cost of goods sold on October 29. Round your "average unit cost" to two decimal places.
$

c. Assuming a perpetual inventory system and using the weighted average method, determine the inventory on October 31. Round your "average unit cost" to two decimal places.
$

Solutions

Expert Solution

a. $13.74
b. $2,748
c. $4,122
Working
Average Cost - Perpetual
Purchases Cost of Goods Sold Inventory Balance
Perpetual Average # of units Cost per unit # of units sold Cost per unit Cost of goods sold # of units Cost per unit Inventory Value
October 1           300 $13.00 $3,900
October 13              170 $13.00 $2,210           130 $13.00 $1,690
Purchase - October 22           370 $14.00           130 $13.00 $1,690
          370 $14.00 $5,180
Average cost           500 $13.74 $6,870
Sale - October 29              200 $13.74 $2,748           300 $13.74 $4,122
Average cost              370 $4,958           300 $4,122

Related Solutions

Perpetual Inventory Using Weighted Average Beginning inventory, purchases, and sales for Meta-B1 are as follows: July...
Perpetual Inventory Using Weighted Average Beginning inventory, purchases, and sales for Meta-B1 are as follows: July 1 Inventory 100 units at $400 12 Sale 70 units 23 Purchase 120 units at $450 26 Sale 110 units a. Assuming a perpetual inventory system and using the weighted average method, determine the weighted average unit cost after the July 23 purchase. $per unit b. Assuming a perpetual inventory system and using the weighted average method, determine the cost of the merchandise sold...
Perpetual Inventory Using Weighted Average Beginning inventory, purchases, and sales for Meta-B1 are as follows: July...
Perpetual Inventory Using Weighted Average Beginning inventory, purchases, and sales for Meta-B1 are as follows: July 1 Inventory 100 units at $400 12 Sale 70 units 23 Purchase 120 units at $450 26 Sale 110 units a. Assuming a perpetual inventory system and using the weighted average method, determine the weighted average unit cost after the July 23 purchase. $per unit b. Assuming a perpetual inventory system and using the weighted average method, determine the cost of the merchandise sold...
Perpetual Inventory Using Weighted Average Beginning inventory, purchases, and sales for Meta-B1 are as follows: July...
Perpetual Inventory Using Weighted Average Beginning inventory, purchases, and sales for Meta-B1 are as follows: July 1 Inventory 100 units at $400 12 Sale 70 units 23 Purchase 120 units at $450 26 Sale 110 units a. Assuming a perpetual inventory system and using the weighted average method, determine the weighted average unit cost after the July 23 purchase. $per unit b. Assuming a perpetual inventory system and using the weighted average method, determine the cost of the merchandise sold...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows:...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1   Inventory 120 units at $39 10   Sale 90 units 15   Purchase 140 units at $40 20   Sale 110 units 24   Sale 45 units 30   Purchase 160 units at $43 The business maintains a perpetual inventory system, costing by the first-in, first-out method. a. Determine the cost of the goods sold for each sale and the inventory...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows:...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 120 units at $39 10 Sale 90 units 15 Purchase 140 units at $40 20 Sale 110 units 24 Sale 45 units 30 Purchase 160 units at $43 The business maintains a perpetual inventory system, costing by the first-in, first-out method. a. Determine the cost of goods sold for each sale and the inventory balance after each sale, presenting the data...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item CZ83 are as follows: January...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item CZ83 are as follows: January 1 Inventory 96 units @ $16 5 Sale 77 units 11 Purchase 107 units @ $20 21 Sale 90 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on January 21 and (b) the inventory on January 31. a. Cost of merchandise sold on January 21 $ b. Inventory on January 31 $
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows:...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 78 units at $95 10 Sale 59 units 15 Purchase 39 units at $100 20 Sale 23 units 24 Sale 14 units 30 Purchase 29 units at $104 The business maintains a perpetual inventory system, costing by the first-in, first-out method. a. Determine the cost of the goods sold for each sale and the inventory balance after each sale, presenting the...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows:...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 42 units at $45 10 Sale 28 units 15 Purchase 21 units at $48 20 Sale 23 units 24 Sale 7 units 30 Purchase 24 units at $50 The business maintains a perpetual inventory system, costing by the first-in, first-out method. a. Determine the cost of the goods sold for each sale and the inventory balance after each sale, presenting the...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows:...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 74 units at $97 10 Sale 56 units 15 Purchase 44 units at $103 20 Sale 27 units 24 Sale 23 units 30 Purchase 33 units at $109 The business maintains a perpetual inventory system, costing by the first-in, first-out method. a. Determine the cost of the goods sold for each sale and the inventory balance after each sale, presenting the...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows:...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 56 units at $97 10 Sale 44 units 15 Purchase 27 units at $101 20 Sale 17 units 24 Sale 14 units 30 Purchase 21 units at $106 The business maintains a perpetual inventory system, costing by the first-in, first-out method. a. Determine the cost of the goods sold for each sale and the inventory balance after each sale, presenting the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT