company's inventory records show the following data for the month of July.DateJuly 1July 5July 10July 20July 25July 1DateActivitiesBeginning inventoryPurchaseSalePurchaseSaleJuly 5Average cost July 5July 10July 20200 units @ $50If the company uses the weighted average method and the perpetual inventory system, what would be the cost of its endinginventory?Average cost July 20July 25Total July 25Goods purchasedNumber of Cost perunitsunit50 at $ 75.00Units Acquired at Cost Units Sold at Retail100 units @ $72 = $7,20050 units @ $75 = $3,750225 at $ 77.00225 units @ $77 =$17,325Numberof unitssoldCost of Goods SoldCost per Cost of GoodsSoldunit75 at $ 50.00 =200 at$ 50.00$75 units @ $50$$3,750.0010,000.0010,000.00Number ofunits100 atInventory Balance100 at50 at150 atCost per unit Inventory Balance7,200.007,200.003,750.0010,950.00$175 at$$$75 at150 at225 at $375 at$50.00 =$ +73.00 =77.00 =75.4075.00 =5572.00 =$$72.00 = $75.00 =73.00S$ 3,750.00$ 10,950.0017,325.0028,275.00$$ 13,125.00$ 13,125.00

Name: company's inventory records show the following data for the month of
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: company's inventory records show the following data for the month of July.DateJuly 1July 5July 10July 20July 25July 1DateActivitiesBeginning inventoryPurchaseSalePurchaseSaleJuly 5Average cost July 5July 10July 20200 units @ $50If the company uses t

Under weighted average cost method using perpetual inventory system, value of ending inventory is…

Business

Accounting

A company's inventory records show the following data for Date July 1 July 5 July 10 July 20 July 25 July 1 Activities Beginning inventory Purchase Sale Purchase Sale Date Goods purchased Number of Cost per units unit Units Acquired at Cost 100 units @ $72= $7,200 50 units @ $75 - $3,750 200 units @ $50 If the company uses the weighted average method and the perpetual inventory system, what would be the cost of its ending inventory? 50 at $ 75.00 225 units @ $77 = $17,325 Number of units sold Units Sold at Retail Cost of Goods Sold Cost per unit 75 units @ $50 Cost of Goods Sold Number of units Inventory Balance Cost per unit Inventory Balance 7,200.00 100 at S 100 at $ 72.00 = 72.00- $ 7,200.00

A company's inventory records show the following data for Date July 1 July 5 July 10 July 20 July 25 July 1 Activities Beginning inventory Purchase Sale Purchase Sale Date Goods purchased Number of Cost per units unit Units Acquired at Cost 100 units @ $72= $7,200 50 units @ $75 - $3,750 200 units @ $50 If the company uses the weighted average method and the perpetual inventory system, what would be the cost of its ending inventory? 50 at $ 75.00 225 units @ $77 = $17,325 Number of units sold Units Sold at Retail Cost of Goods Sold Cost per unit 75 units @ $50 Cost of Goods Sold Number of units Inventory Balance Cost per unit Inventory Balance 7,200.00 100 at S 100 at $ 72.00 = 72.00- $ 7,200.00

Financial Accounting

15th Edition

ISBN:9781337272124

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter7: Inventories

Section: Chapter Questions

Problem 4PEB: Beginning inventory, purchases, and sales for WCS12 are as follows: Assuming a perpetual inventory...

See similar textbooks

Similar questions

Refer to the information for Morgan Inc. above. If Morgan uses a perpetual inventory system, what is the cost of ending inventory under FIFO at April 30? a. $32,500 b. $38,400 c. $63,600 d. $69,500
On January 1 of Year 1, Dorso Company adopted the dollar-value LIFO method of inventory costing. Dorsos December 31 ending inventory records are as follows: Year 1: Current cost, 20,000; Index, 100 Year 2: Current cost, 33,600; Index, 120 Using the dollar-value LIFO method, compute Dorsos December 31 ending inventory for Year 2.
Alternative Inventory Methods Park Companys perpetual inventory records indicate the following transactions in the month of June: Required: 1. Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: a. FIFO b. LIFO c. Average cost (Round unit costs to 3 decimal places and other amounts to the nearest dollar.) 2. Next Level Why are the cost of goods sold and ending inventory amounts different for each of the three methods? What do these amounts tell us about the purchase price of inventory during the year? 3. Next Level Which method produces the most realistic amount for net income? For inventory? Explain your answer. 4. Next Level If Park uses IFRS, which of the previous alternatives would be acceptable and why?
Beginning inventory, purchases, and sales for 30xT are as follows: Assuming a perpetual inventory system and using the weighted average method, determine (a) the weighted average unit cost after the May 23 purchase, (b) the cost of the merchandise sold on May 26, and (c) the inventory on May 31.
Hurst Companys beginning inventory and purchases during the fiscal year ended December 31, 20-2, were as follows: There are 1,200 units of inventory on hand on December 31, 20-2. REQUIRED 1. Calculate the total amount to be assigned to the cost of goods sold for 20-2 and ending inventory on December 31 under each of the following periodic inventory methods: (a) FIFO (b) LIFO (c) Weighted-average (round calculations to two decimal places) 2. Assume that the market price per unit (cost to replace) of Hursts inventory on December 31 was 18. Calculate the total amount to be assigned to the ending inventory on December 31 under each of the following methods: (a) FIFO lower-of-cost-or-market (b) Weighted-average lower-of-cost-or-market 3. In addition to taking a physical inventory on December 31, Hurst decides to estimate the ending inventory and cost of goods sold. During the fiscal year ended December 31, 20-2, net sales of 100,000 were made at a normal gross profit rate of 35%. Use the gross profit method to estimate the cost of goods sold for the fiscal year ended December 31 and the inventory on December 31.
Beginning inventory, purchases, and sales for Item Zebra 9x are as follows: Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on April 27 and (b) the inventory on April 30.
Beginning inventory, purchases, and sales for WCS12 are as follows: Assuming a perpetual inventory system and using the weighted average method, determine (a) the weighted average unit cost after the October 22 purchase, (b) the cost of the merchandise sold on October 29, and (c) the inventory on October 31.
Carla Company uses the perpetual inventory system. The following information is available for January of the current year when Carla sold 1,600 units of inventory on January 14. Using the FIFO method, calculate Carlas cost of goods sold for January and its January 31 inventory.
Calculate the cost of goods sold dollar value for A67 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for weighted average (AVG).
Trini Company had the following transactions for the month. Calculate the ending inventory dollar value for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
PERPETUAL: LIFO AND MOVING-AVERAGE Kelley Company began business on January 1, 20-1. Purchases and sales during the month of January follow. REQUIRED Calculate the total amount to be assigned to cost of goods sold for January and the ending inventory on January 31, under each of the following methods: 1. Perpetual LIFO inventory method. 2. Perpetual moving-average inventory method.
Calculate the cost of goods sold dollar value for B74 Company for the sale on November 20, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average (AVG).