The GMA corporation shows the following data related to an item of InventoryInventory, January 1 100 units @P50 Purchases, January 9 300 units @ P54 Purchases, January 19 90 units @ P60 Sales, January 20 340 units Inventory, January 31 150 units What value should be assigned to the ending inventory using Weighted Average method?
Question
The GMA corporation shows the following data related to an item of InventoryInventory, January 1 100 units @P50 Purchases, January 9 300 units @ P54 Purchases, January 19 90 units @ P60 Sales, January 20 340 units Inventory, January 31 150 units What value should be assigned to the ending inventory using Weighted Average method?
Solution
To calculate the value of the ending inventory using the Weighted Average method, follow these steps:
-
Calculate the total cost of the inventory at the beginning and the purchases made during the month.
- Beginning inventory: 100 units @ P50 = P5000
- Purchases on January 9: 300 units @ P54 = P16200
- Purchases on January 19: 90 units @ P60 = P5400
-
Add these amounts to get the total cost of the inventory available for sale.
- Total cost of inventory available for sale = P5000 + P16200 + P5400 = P26600
-
Calculate the total number of units available for sale.
- Total units available for sale = 100 units (beginning inventory) + 300 units (purchased on January 9) + 90 units (purchased on January 19) = 490 units
-
Calculate the weighted average cost per unit. This is done by dividing the total cost of inventory available for sale by the total number of units available for sale.
- Weighted average cost per unit = P26600 / 490 units = P54.29 (rounded to the nearest cent)
-
Multiply the weighted average cost per unit by the number of units in the ending inventory to get the value of the ending inventory.
- Value of ending inventory = 150 units (ending inventory) * P54.29 = P8143.50
So, the value that should be assigned to the ending inventory using the Weighted Average method is P8143.50.
Similar Questions
The GMA corporation shows the following data related to an item of InventoryInventory, January 1 200 units @P50 Purchases, January 9 200 units @ P54 Purchases, January 19 100 units @ P60 Sales, January 20 380 units What value should be assigned to the Cost of Sale using FIFO?
The GMA corporation shows the following data related to an item of InventoryInventory, January 1 100 units @P50 Purchases, January 9 300 units @ P54 Purchases, January 19 90 units @ P60 Sales, January 20 340 units What will be the ending inventory in units using FIFO?
Jammer Company uses a weighted average perpetual inventory system and reports the following: Date Activities Units Acquired at Cost Units Sold at RetailAugust 2 Purchase 10 units @ $27 = $270 August 18 Purchase 15 units @ $30 = $450 August 29 Sales 20 units soldAugust 31 Purchase 14 units @ $31 = $434 What is the per unit value of ending inventory on August 31? Answers should be rounded to the nearest cent.Multiple Choice$27.00$32.32$28.80$30.42$31.00
Under the weighted average system of stock valuation, the average unit cost is calculated by:Question 12Answera.Dividing the total cost of inventory on hand by the total number of inventory items on handb.Adding the unit purchase prices of inventory items on hand and dividing the sum by twoc.Dividing the total cost of inventory issued by the total number of inventory items issuedd.Dividing the total cost of inventory on hand by two
Which inventory costing method uses the oldest cost for Cost of Goods Sold on the income statement and the newest cost for Inventory on the balance sheet?Multiple choice question.Weighted averageSpecific identificationLIFOFIFO
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.