Question
ABC Company uses perpetual inventory system in its merchandising business. The company has the following inventory transactions in November 2020: Inventory and Purchases Units Sold
ABC Company uses perpetual inventory system in its merchandising business. The company has the following inventory transactions in November 2020:
|
Inventory and Purchases | Units Sold | Selling Price | |
Date | Units | Cost per unit | Units |
|
Beginning inventory | 10 | $20 |
|
|
November 5 | 15 | $22 |
|
|
November 6 |
|
| 20 | $100 |
November 12 | 14 | $25 |
|
|
November 15 |
|
| 15 | $110 |
November 20 | 12 | $28 |
|
|
November 30 |
|
| 10 | $120 |
Required:
1. Using the FIFO method (without setting up a table), calculate: (a) the total units sold; (b) the total cost of goods sold; (c) the total units unsold; (d) ending inventory in $; (e) sales revenue; and (f) gross profit for November 2020. Please show your calculation process.
2. Using the weighted average method, calculate (a) the cost of goods sold (b) the ending inventory.
Please show your calculations in a table as follows:
Date | Goods Purchased | Cost of Goods Sold | Inventory Balance |
|
|
|
|
|
|
|
|
Total |
|
|
|
3. What is the gross profit for November 2020 using the weighted average method?
4. How much merchandise was purchased in November 2020?
5. How much is the merchandise available for sale in November 2020?
(Please show detailed calculations. Round to 2 decimal places for average cost per unit and round to the nearest dollar for all other answers.)
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