Explore BrainMass
Share

Carlson Auto Dealers, Inc: Calculate Inventory Cost

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Carlson Auto Dealers Inc. sells a handmade automobile as its only product. Each automobile is identical; however, they can be distinguished by their unique ID number. At the bginning of 2011, Carlson had three cars in inventory, as follows:
Car ID Cost
203 $60,000
207 $60,000
210 $63,000
During 2011, each of the three autos sold for $90,000. Additional purchases (listed in chronological order) and sales for the year as follows:
CAR ID COST SELLING PRICE
211 $63,000 $90,000
212 63,000 93,000
213 64,500 not sold
214 66,000 96,000
215 69,000 100,500
216 70,000 not sold
217 72,000 105,000
218 72,300 106,500
219 75,000 not sold

1. Calculate 2011 ending inventory and cost of goods sold assuming the company uses the specific identification inventory method.
2. Calculate ending inventory and cost of goods sold assuming FIFO and a periodic inventory system.
3. Calculate ending inventory and cost of goods sold assuming LIFO and a periodic inventory system.
4. Calculate ending inventory and cost of goods sold assuming the average cost method and a periodic inventory system.

© BrainMass Inc. brainmass.com October 25, 2018, 5:07 am ad1c9bdddf
https://brainmass.com/business/inventory/carlson-auto-dealers-inc-calculate-inventory-cost-407495

Solution Summary

Your tutorial is in Excel and shows the ending inventory and COGS computations for specific ID, LIFO, FIFO, and average cost. Click on cells to see computations. This is a template you can use for other similar problems.

$2.19
See Also This Related BrainMass Solution

Lifo, Fifo, And perpetual system

Carlson auto dealers inc. sells a handmade automobile as its only product. Each automobile is identical;however they can be distinguished by their unique ID number.

At the beginning of 2009, Carlson had three cars in inventory, as follows:

Car ID Cost
203 60000
207 60000
210 63000

During 2009 each of the three autos sold for 90000. Additional purchases (listed in chronological order) and sales for the year were as follows:

Car ID Cost Selling Price
211 63000 90000
212 63000 93000
213 64500 not sold
214 66000 96000
215 69000 100500
216 70500 not sold
217 72000 105000
218 72300 106500
219 75000 not sold

Required

1.Calculate ending inventory and cost of goods sold assuming FIFO and a periodic inventory system

2. Calculate ending inventory and cost of goods sold assuming LIFO and a periodic inventory system

3. Calculate ending inventory and cost of goods sold assumeing the average cost method and periodic inventory system.

View Full Posting Details