Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete all three inventory costing worksheets using the costing method indicated at the top of each page. Method : Weighted Average /Average cost Date Purchases
Complete all three inventory costing worksheets using the costing method indicated at the top of each page.
Method : Weighted Average /Average cost
Date | Purchases | Cost of Goods Sold | Inventory Balance |
1- Jan | 100 units = $1,000 | ||
10 Jan | Sold 90 units @ $40 each. What is the CGS? | ||
14- Mar | 250 units = $3,750 | ||
15 - mar | Sold 140 units @ $40 each. What is the CGS? | ||
30 -JUL | 400 units = $8,000 | ||
5 -OCT | Sold 300 units @ $40 each. What is CGS? | ||
26 -OCT | 600 units = $15,000 | ||
What is the total cost of goods sold? __________ What is the balance of the ending inventory? ______
Method: LIFO
'
Date | Purchases | Cost of Goods Sold | Inventory Balance |
1- Jan | 100 units @ $10 = $1,000 | ||
10-Jan | Sold 90 units @ $40 each. What is CGS? | ||
14- MAR | 250 units @ $15 = $3,750 | ||
15- MAR | Sold 140 units @ $40 each. What is CGS? | ||
30- JUL | 400 units @ $20 = $8,000 | ||
5 -OCT | Sold 300 units @ $40 each | ||
26-OCT | 600 units @ $25 = $15,000 | ||
What is the cost of the goods sold?__________ What is the balance of the ending inventory? _______
Method: FIFO
Date | Purchases | Cost of Goods Sold | Inventory Balance |
1-jan | 100 units @ $10 = $1,000 | ||
10-jan | Sold 90 units @ $40 each. What is the CGS? | ||
14-mar | 250 units @ $15 = $3,750 | ||
15-mar | Sold 140 units @ $40 each. What is the CGS? | ||
30-jul | 400 units @ $20 = $8,000 | ||
5-oct | sold 300 units @ $40 each. What is the CGS? | ||
26 - oct | 600 units @ $25 = $15,000 | ||
What is the total cost of Goods Sold? ______ What is the balance of ending inventory?___________
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started