Question

In: Finance

XYZ Company reports the following initial balance and subsequent purchase of inventory. Assume that 2,000 units...

XYZ Company reports the following initial balance and subsequent purchase of inventory. Assume that 2,000 units were sold during the year. Compute the costs of goods sold and balance of inventory for the year on the year-end balance sheet under the weighted average inventory costing methods. Inventory balance at beginning of year 1,400 units @ $150 each 210,000 inventory purchased during the year 800 units @ $180 each 144,000 Cost of goods available for sale during the year 2,200 units 354,000

A. 321,818; 32,182

B. 318,000; 36,000

C. 324,000; 30,000

D. 300,000; 54,000

Solutions

Expert Solution

Compute per unit cost of goods available for sale, using the equation as shown below:

Per unit cost = Cost of goods available for sales/ Units

                     = $354,000/ 2,200 units

                     = $160.909090909

Hence, per unit cost of good available for sale is $160.909090909.

Compute the cost of goods sold, using the equation as shown below:

Cost of goods sold = Units sold*Per unit cost of goods available for sale

                               = 2,000 units*$160.909090909

                               = $321,818.181818

Hence, the cost of goods sold is $321,818.

Compute the closing inventory balance, using the equation as shown below:

Closing inventory = Cost of goods available for sales – Cost of good sold

                              = $354,000 - $321,818.181818

                              = $32,181.818182

Hence, the closing inventory balance is $32,182.


Related Solutions

XYZ Company reports the following inventory data for the month of June.                              &nbs
XYZ Company reports the following inventory data for the month of June.                                                              June 1 June 30 Direct materials $ 50.00 $ 80.00 Work in process $140.00 $180.00 Finished goods $240.00 $250.00 Direct materials purchased $140.00 Indirect costs of production $180.00 Direct costs of production $220.00 Selling and administrative costs $210.00 Answer the following questions about XYZ Company for the month of June: a) What was the total manufacturing cost (product cost) in the month of June? $ Answer b)...
During the month of August, Shelly sold 26 units and reports the following inventory and purchase...
During the month of August, Shelly sold 26 units and reports the following inventory and purchase information: Date Explanation Units Unit Cost Total Cost August 1 Beginning inventory 12 $250 $3,000 August 13 Purchase 13 300 3,900 August 22 Purchase 10 310 3,100 August 29 Purchase 20 320 6,400 enter the ending inventory at August 31 using the FIFO, LIFO and average-cost methods. enter the cost of goods sold at August 31 using the FIFO, LIFO and average-cost methods.
Maple company uses the periodic inventory system. The beginning balance of inventory and subsequent inventory purchases...
Maple company uses the periodic inventory system. The beginning balance of inventory and subsequent inventory purchases made by the company during the month of March 2019 are given below: March 01: Beginning inventory, 450 units @ $18 per unit. March 18: Inventory purchased, 600 units @ $20 per unit. March 25: Inventory purchased, 700 units @ $26 per unit. The Mark company sold 1,300 units during the month of July. Required: Calculate the cost of goods sold and ending inventory...
Delta company uses the periodic inventory system. The beginning balance of inventory and subsequent inventory purchases...
Delta company uses the periodic inventory system. The beginning balance of inventory and subsequent inventory purchases made by the company during the month of July 2019 are given below: July 01: Beginning inventory, 500 units @ $20 per unit. July 18: Inventory purchased, 800 units @ $24 per unit. July 25: Inventory purchased, 700 units @ $26 per unit. The Delta company sold 1,400 units during the month of July. Required: Compute the cost of goods sold and ending inventory...
Maple company uses the periodic inventory system. The beginning balance of inventory and subsequent inventory purchases...
Maple company uses the periodic inventory system. The beginning balance of inventory and subsequent inventory purchases made by the company during the month of March 2019 are given below: • March 01: Beginning inventory, 450 units @ $18 per unit. • March 18: Inventory purchased, 600 units @ $20 per unit. • March 25: Inventory purchased, 700 units @ $26 per unit. The Mark company sold 1,300 units during the month of March. Required: Calculate the cost of goods sold...
Inventory balance - 500 units $10.00 Purchase, April 11 - 800 units $8.00 Purchase , June...
Inventory balance - 500 units $10.00 Purchase, April 11 - 800 units $8.00 Purchase , June 1 - 700 units $12.00 Sale May 1 (sold at $38.00 per unit) - 500 units Sale July 3 (sold at $38.00 per unit) - 520 units Operating expense (excluding income tax expense) $19,009 FIFO, LIFO and weight average Is 500 times 38 units ? Calculate number of goods avail and CSG Ending inventory FIFO, LIFO and weighted average Income statement
Sheldon Company had 2,000 units of inventory costing $10,000 in beginning inventory at July 1st. During...
Sheldon Company had 2,000 units of inventory costing $10,000 in beginning inventory at July 1st. During July, Sheldon Co. engaged in the following transactions: July 3rd - The company paid cash to purchase 1,000 units of inventory for $6,500. July 10th - The company paid cash to purchase 1,200 units of inventory for $8,400. July 24th – The company paid cash to purchase 250 units of inventory for $2,125. Throughout July, the company sold inventory 3,700 units of inventory for...
1) McKay Company uses process costing. The company started with 2,000 units in beginning inventory. There...
1) McKay Company uses process costing. The company started with 2,000 units in beginning inventory. There were 15,000 new units started during the month. 14,000 units were transferred out and 2,800 units remained in ending inventory. McKay’s normal spoilage rate is 1%. The cost per equivalent unit for the month was $20. How much should be charged to the Loss from Abnormal Spoilage account? 2) McNutt uses job-order costing. Job 725 had total costs of $15,000. 1,000 units were produced...
The Concord Company counted physically their beginning balance on January 02, 2020 and subsequent inventory purchases...
The Concord Company counted physically their beginning balance on January 02, 2020 and subsequent inventory purchases made by the company during the month of January 2020 are given below: Date Description Units   Rate Jan. 02 Beginning Inventory 300 $10 Jan. 11 Purchased 600 12    Jan 23 Purchased 700 11 The company sold 1,300 units during the month of January 2020. Instructions: The company uses periodic inventory system. Compute the cost of goods sold and ending inventory on January 31,...
Jammer Company uses a weighted average perpetual inventory system and reports the following: August 2 Purchase...
Jammer Company uses a weighted average perpetual inventory system and reports the following: August 2 Purchase 18 units at $15.50 per unit. August 18 Purchase 20 units at $14.00 per unit. August 29 Sale 36 units. August 31 Purchase 23 units at $18.50 per unit. What is the per-unit value of ending inventory on August 31? (Round your per unit answers to 2 decimal places.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT