Question

In: Accounting

Problem 6-63A Inventory Costing Methods Anderson's Department Store has the following data for inventory, purchases, and...

Problem 6-63A
Inventory Costing Methods

Anderson's Department Store has the following data for inventory, purchases, and sales of merchandise for December for one of the items the company sells:

Activity Units Purchase Price (per unit) Sale Price (per unit)
Beginning inventory 10 $6.00
Purchase 1, Dec. 2 22 6.80
Purchase 2, Dec. 5 26 7.50
Sale 1, Dec. 7 19 $12.00
Sale 2, Dec. 10 25 12.00
Purchase 3, Dec. 12 12 8.00
Sale 3, Dec. 14 20 12.00

Anderson's uses a perpetual inventory system. All purchases and sales were for cash.

Required:

1. Compute cost of goods sold and the cost of ending inventory using FIFO. If required, round your answers to the nearest cent.

Cost of goods sold $
Cost of ending inventory $

2. Compute cost of goods sold and the cost of ending inventory using the weighted average cost method. (Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest penny.)

Cost of goods sold $
Cost of ending inventory $

Feedback

Incorrect

3. Prepare the journal entries to record these transactions, assuming Anderson's chooses to use the FIFO method. If required, round your answers to the nearest cent.

Dec. 2 Inventory
Cash
(Purchased inventory)
Dec. 5 Inventory
Cash
(Purchased inventory)
Dec. 7
(Recorded cash sales to customers)
Dec. 7
(Recorded cost of goods sold)
Dec. 10
(Recorded cash sales to customers)
Dec. 10
(Recorded cost of goods sold)
Dec. 12
(Purchased inventory)
Dec. 14
(Recorded cash sales to customers)
Dec. 14
(Recorded cost of goods sold)

Solutions

Expert Solution

1. Compute cost of goods sold and the cost of ending inventory using FIFO. If required, round your answers to the nearest cent.

Cost of goods sold = (10*6+22*6.80+26*7.5+6*8) = $452.60

Cost of ending inventory = 6*8 = $48

2. Compute cost of goods sold and the cost of ending inventory using the weighted average cost method.

Cost of goods sold = (19*6.9759+25+6.7959+20*7.4485) = $455.91

Cost of ending inventory = 6*7.4485 = 44.69

3. Prepare the journal entries to record these transactions, assuming Anderson's chooses to use the FIFO method

Date account and explanation debit credit
Dec 2 Inventory 149.60
Cash 149.60
(To record purchase)
Dec 5 Inventory 195
Cash 195
(To record purchase)
Dec 7 Cash (19*12) 228
Sales revenue 228
(To record sales)
Dec 7 Cost of goods sold (10*6+9*6.80) 121.20
Inventory 121.20
(To record cost of goods sold)
Dec 10 Cash (25*12) 300
Sales revenue 300
(To record sales)
Dec 10 Cost of goods sold (13*6.8+12*7.5) 178.40
Inventory 178.40
(TO record cost of goods sold)
Dec 12 Inventory 96
Cash 96
(To record purchase inventory)
Dec 14 Cash (20*12) 240
Sales revenue 240
(To record cost)
Dec 14 Cost of goods sold (14*7.5+6*8) 153
Inventory 153
(To record cost of goods sold)

Related Solutions

6. Periodic Inventory System and Inventory Costing Methods In chronological order, the inventory, purchases, and sales...
6. Periodic Inventory System and Inventory Costing Methods In chronological order, the inventory, purchases, and sales of a single product for a recent month are as follows: Units   Amount per Unit June 1 Beginning inventory 150 $30 4 Purchase 400   33 12 Purchase 800   36 16 Sale 1,300   60 24 Purchase 300   39 Using the periodic inventory system, compute the cost of ending inventory, cost of goods sold, and gross margin. Use the average-cost, FIFO, and LIFO inventory costing methods....
Brief Exercise 6-35 (Algorithmic) Inventory Costing Methods Tyler Company has the following information related to purchases...
Brief Exercise 6-35 (Algorithmic) Inventory Costing Methods Tyler Company has the following information related to purchases and sales of one of its inventory items. Date Description Units Purchased at Cost Units Sold at Retail Sept. 1 Beginning inventory 400 units @ $13 Sept. 10 Purchase 600 units @ $14 Sept. 20 Sales 680 units @ $24 Sept. 25 Purchase 600 units at $16 Assume the company uses a perpetual inventory system. Required: Calculate ending inventory and cost of goods sold...
Inventory Costing Methods Tyler Company has the following information related to purchases and sales of one...
Inventory Costing Methods Tyler Company has the following information related to purchases and sales of one of its inventory items. Date Description Units Purchased at Cost Units Sold at Retail Sept. 1 Beginning inventory 400 units @ $17 Sept. 10 Purchase 600 units @ $18 Sept. 20 Sales 700 units @ $31 Sept. 25 Purchase 700 units at $20 Assume the company uses a perpetual inventory system. Required: Calculate ending inventory and cost of goods sold using the FIFO, LIFO,...
Inventory Costing Methods Tyler Company has the following information related to purchases and sales of one...
Inventory Costing Methods Tyler Company has the following information related to purchases and sales of one of its inventory items. Date Description Units Purchased at Cost Units Sold at Retail Sept. 1 Beginning inventory 400 units @ $18 Sept. 10 Purchase 600 units @ $19 Sept. 20 Sales 630 units @ $32 Sept. 25 Purchase 800 units at $21 Assume the company uses a perpetual inventory system. Required: Calculate ending inventory and cost of goods sold using the FIFO, LIFO,...
9. Periodic Inventory System and Inventory Costing Methods Portia's Parts Shop recorded the following purchases and...
9. Periodic Inventory System and Inventory Costing Methods Portia's Parts Shop recorded the following purchases and sales during the past year: Jan. 1 Beginning inventory 125 cases @ $23 $ 2,875 Feb. 25 Purchase 100 cases @ $26 2,600 June 15 Purchase 200 cases @ $28 5,600 Oct. 15 Purchase 150 cases @ $28 4,200 Dec. 15 Purchase 100 cases @ $30 3,000 Goods available for sale 675 $18,275 Total sales 500 cases Dec. 31 Ending inventory 175 cases Assume...
Periodic Inventory System and Inventory Costing Methods Portia's Parts Shop recorded the following purchases and sales...
Periodic Inventory System and Inventory Costing Methods Portia's Parts Shop recorded the following purchases and sales during the past year: Jan. 1 Beginning inventory 125 cases @ $23 $ 2,875 Feb. 25 Purchase 100 cases @ $26 2,600 June 15 Purchase 200 cases @ $28 5,600 Oct. 15 Purchase 150 cases @ $28 4,200 Dec. 15 Purchase 100 cases @ $30 3,000 Goods available for sale 675 $18,275 Total sales 500 cases Dec. 31 Ending inventory 175 cases Assume for...
Brief Exercise 6-35 (Algorithmic)Inventory Costing MethodsTyler Company has the following information related to purchases...
Brief Exercise 6-35 (Algorithmic)Inventory Costing MethodsTyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory400 units @ $12Sept. 10Purchase600 units @ $13Sept. 20Sales700 units @ $22Sept. 25Purchase800 units at $15Assume the company uses a perpetual inventory system.Required:Calculate ending inventory and cost of goods sold using the FIFO, LIFO, and average cost methods.FIFOLIFOAvg CostCost of goods sold???Ending inventory???
Periodic Inventory by Three Methods The beginning inventory at Midnight Supplies and data on purchases and...
Periodic Inventory by Three Methods The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar. 5 Purchase...
Periodic Inventory by Three Methods The beginning inventory at Midnight Supplies and data on purchases and...
Periodic Inventory by Three Methods The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar. 5 Purchase...
Periodic Inventory by Three Methods The beginning inventory at Midnight Supplies and data on purchases and...
Periodic Inventory by Three Methods The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar. 5 Purchase...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT