Knowee
Questions
Features
Study Tools

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?

🧐 Not the exact question you are looking for?Go ask a question

Solution

To calculate the value of the ending inventory using the Weighted Average method, follow these steps:

  1. 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
  2. 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
  3. 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
  4. 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)
  5. 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.

This problem has been solved

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

1/3

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.