Answer:
A. The correct option is b. $46,067.
B. The correct option is d. $46,620.
Explanation:
Note: The data in this question are merged together. They are therefore sorted before answering the question. See the attached pdf file for the complete question with the sorted data.
The explanation of the answers is now given as follows:
A. Assuming that Rich does not maintain perpetual inventory records, what should be the inventory at January 31, using the weighted-average inventory method, rounded to the nearest dollar?
Note: See part A of the attached excel file for the calculation of the of units and cost of goods available for sale.
Since Rich does not maintain perpetual inventory records, this implies that this is a periodic inventory system. And update to inventory in a periodic inventory system are made on a regular basis, such as monthly, quarterly, etc.
From the part A attached excel file, we have:
Units of goods available for sale = 23,100
Cost of goods available for sales = $236,481
Weighted-average cost per unit = Cost of goods available for sales / Units of goods available for sale = $236,481 / 23,100 = $10.2372727272727
Inventory at January 31 = Units of inventory balance at January 31 * Weighted-average cost per unit = 4,500 * $10.2372727272727 = $46,068
From the options the closest one is b. $46,067. Therefore, the inventory at January 31 is $46,067 and the correct option is b. $46,067.
B. Assuming that Rich maintains perpetual inventory records, what should be the inventory at January 31, using the moving-average inventory method, rounded to the nearest dollar?
Note: See part B of the attached excel file for the calculation of the inventory at January 31 (in bold red color).
Under Perpetual Inventory system, the inventory is updated whenever a purchase or sale is made. It's a procedure that happens in real time.
In the Part B of the attached excel file, the following rates in light red color are made as follows:
Rate on January 6 = ($87,930 + $61,800) / 15,000 = $9.98 per unit
Rate on January 26 = ($74,865 + 86,751) / 15,600 = $10.36 per unit
From the part B attached excel file, we have:
Inventory at January 31 = $46,620.
Therefore, the correct option is d. $46,620.
