Question

In: Accounting

Carlson Auto Dealers Inc. sells a handmade automobile as its only product. Each automobile is identical;...

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 2021, Carlson had three cars in inventory, as follows:

Car ID Cost
203 $ 69,000
207 69,000
210 72,000


During 2021, each of the three autos sold for $99,000. Additional purchases (listed in chronological order) and sales for the year were as follows:

Car ID Cost Selling Price
211 $ 69,000 $ 99,000
212 69,000 102,000
213 70,500 not sold
214 72,000 105,000
215 75,000 109,500
216 73,500 not sold
217 78,000 114,000
218 75,300 115,500
219 81,000 not sold

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

Solutions

Expert Solution

Correct Answer:

FIFO

Cost of Goods Sold

$   6,39,000

Cost of Ending Inventory

$   2,25,300

Working:

Cost of Goods Available for sale

Units

Cost per unit

value

203

Beginning Inventory

1

$            69,000

$             69,000

207

Beginning Inventory

1

$            69,000

$             69,000

210

Beginning Inventory

1

$            72,000

$             72,000

211

Purchases

1

$            69,000

$             69,000

212

Purchases

1

$            69,000

$             69,000

213

Purchases

1

$            70,500

$             70,500

214

Purchases

1

$            72,000

$             72,000

215

Purchases

1

$            75,000

$             75,000

216

Purchases

1

$            73,500

$             73,500

217

Purchases

1

$            78,000

$             69,000

218

Purchases

1

$            75,300

$             75,300

219

Purchases

1

$            81,000

$             81,000

$                      -  

Total

12

$      8,64,300.0

FIFO

A

Total Units Available for sale

12

$            8,64,300

Units Sold

9

Ending Inventory Units

3

Valuation

Cost of Goods Sold

203

1

$       69,000.00

$               69,000

207

1

$       69,000.00

$               69,000

210

1

$       72,000.00

$               72,000

211

1

$       69,000.00

$               69,000

212

1

$       69,000.00

$               69,000

213

1

$       70,500.00

$               70,500

214

1

$       72,000.00

$               72,000

215

1

$       75,000.00

$               75,000

216

1

$       73,500.00

$               73,500

B

Cost of Goods Sold

9

units

$            6,39,000

A-B

Ending Inventory

3

units

$            2,25,300

End of Answer.

Thanks


Related Solutions

Carlson Auto Dealers Inc. sells a handmade automobile as its only product. Each automobile is identical;...
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 2018, Carlson had three cars in inventory, as follows: Car ID Cost 203 $ 51,000 207 51,000 210 54,000 During 2018, each of the three autos sold for $81,000. Additional purchases (listed in chronological order) and sales for the year were as follows: Car ID Cost Selling Price 211 $...
Carlson Auto Dealers Inc. sells a handmade automobile as its only product. Each automobile is identical
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 2021, Carlson had three cars in inventory, as follows:  Car ID..................Cost  203.......................$60,000  207........................60,000  210........................63,000  During 2021, each of the three autos sold for $90,000. Additional purchases (listed in chronological order) and sales for the year were as follows:    Required:  1. Calculate 2021 ending inventory and cost of goods sold...
Carlson Auto Dealers Inc. sells a handmade automobile as its only product. Each automobile is identical;...
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 2021, Carlson had three cars in inventory, as follows: Car ID Cost 203 $ 69,000 207 69,000 210 72,000 During 2021, each of the three autos sold for $99,000. Additional purchases (listed in chronological order) and sales for the year were as follows: Car ID Cost Selling Price 211 $...
Teton Inc sells its only product for 50 per unit Teton, Inc. sells its only product for $50 pe
Teton Inc sells its only product for 50 per unit Teton, Inc. sells its only product for $50 per unit. Fixed expenses total $800,000 per year. Variable expenses are $1,000,000 when 40,000 units are sold. How many units must be sold to earn a net operating income of $75,000?
A manufacturing company makes auto parts and sells them to auto dealers.
 A manufacturing company makes auto parts and sells them to auto dealers. Last week the company shipped 25 auto parts to a dealer. Later it found out that 5 of those parts were defective. By the time the company manager contacted the dealer 4 auto parts from that shipment had already been sold. What is the probability that 3 of those 4 parts were non-defective?
Suppose that a monopoly sells its product in a market with 10 identical consumers. Each consumer...
Suppose that a monopoly sells its product in a market with 10 identical consumers. Each consumer has an individual demand given by P = 30 − 2y, where y is the individual quantity demanded at price P. The firm has no fixed costs and a constant marginal cost equal to 5. a) Show that the aggregate inverse market demand is given by P(Y ) = 30 − Y /5, where Y is total quantity demanded in the market. b) First,...
Grills, Inc. makes a single product - a handmade specialty barbeque grill that sells for $700....
Grills, Inc. makes a single product - a handmade specialty barbeque grill that sells for $700. Data for last year’s operations follow:                                     Units in beginning inventory              0                                     Units produced                          50,000                                     Units sold                                   40,000                                                                                                 Variable costs per unit:                                     Direct materials                                   $      200                                     Direct labor                                                 100                                     Variable manufacturing overhead                70                                     Variable selling and administrative              30                                     Total variable cost per unit                 $      400                                     Fixed costs:                                     Fixed manufacturing...
Suppose a monopoly with constant marginal cost of 10 sells its product to identical consumers. Each...
Suppose a monopoly with constant marginal cost of 10 sells its product to identical consumers. Each consumer has an inverse demand curve given by P = 210 − 10Q. (a) Find the price and quantity the monopolist chooses if it can only set one price, and it can not use a two-part tariff. What is the monopolist’s profit on each consumer? (b) Now suppose the monopolist can use a two-part tariff. What is the profit maximizing choice of the fixed...
Question No.1    An auto parts supplier sells Hardy-brand batteries to car dealers and auto mechanics....
Question No.1    An auto parts supplier sells Hardy-brand batteries to car dealers and auto mechanics. The annual demand is approximately 1500 batteries. The supplier pays 25 R.O for each battery and estimates that the annual holding cost is 30% of the battery's value. It costs approximately 30 R.O to place an order. The supplier currently orders 125 batteries per month. a. Determine the EOQ. b. How many orders will be placed per year using the EOQ? c. Determine the...
Question No.1    An auto parts supplier sells Hardy-brand batteries to car dealers and auto mechanics....
Question No.1    An auto parts supplier sells Hardy-brand batteries to car dealers and auto mechanics. The annual demand is approximately 1500 batteries. The supplier pays 25 R.O for each battery and estimates that the annual holding cost is 30% of the battery's value. It costs approximately 30 R.O to place an order. The supplier currently orders 125 batteries per month. a. Determine the EOQ. b. How many orders will be placed per year using the EOQ? c. Determine the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT