Carlson Auto Dealers, Inc: Calculate Inventory Cost
Not what you're looking for?
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.
Purchase this Solution
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.
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.