Laker Company reported the following January purchases and sales data for its only product. For specific identification, ending inventory consists of 340 units from the January 30 purchase, 5 units from the January 20 purchase, and 15 units from beginning inventory. Date January 1 January 10 January 20 January 25 January 30 Activities Beginning inventory Sales Purchase Sales Purchase Totals Units Acquired at Cost 210 units @ $13.50 = 150 units @ $ 12.50 = 340 units @ 700 units $ 12.00- $ 2,835 1,875 4,080 $ 8,790 Units sold at Retail @ 160 units 180 units 340 units $ 22.50 $ 22.50

Laker Company reported the following January purchases and sales data for its only product. For specific identification, ending inventory consists of 340 units from the January 30 purchase, 5 units from the January 20 purchase, and 15 units from beginning inventory. Date January 1 January 10 January 20 January 25 January 30 Activities Beginning inventory Sales Purchase Sales Purchase Totals Units Acquired at Cost 210 units @ $13.50 = 150 units @ $ 12.50 = 340 units @ 700 units $ 12.00- $ 2,835 1,875 4,080 $ 8,790 Units sold at Retail @ 160 units 180 units 340 units $ 22.50 $ 22.50

Name: how do i calculate the weighted average of cost of goods sold SalesCos
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: how do i calculate the weighted average of cost of goods sold SalesCost of goods soldGross profitLAKER COMPANYFor Month Ended January 31Weighted AverageSpecific Identification$$7,650 $4,4463,204 $7,650 $7,650$FIFO7,650 $4,4603,190$LIFO7,6504,0803,570

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter6: Receivables And Inventories

Section: Chapter Questions

Problem 6.4.1P: Inventory by three cost flow methods Details regarding the inventory of appliances on January 1,...

See similar textbooks

Similar questions

Lower-of-cost-or market inventory Data on the physical inventory of Moyer Company as of December 31, 20Y9, are presented below. Quantity and cost data from the last purchases invoice of the year and the next-to-the-last purchases invoice are summarized as follows: Instructions Determine the inventory at cost and at the lower of cost or market, using the first-in, first-out method. Record the appropriate unit costs on an inventory sheet and complete the pricing of the inventory. When there are two different unit costs applicable to an item, proceed as follows: 1. Draw a line through the quantity, and insert the quantity and unit cost of the last purchase. 2. On the following line, insert the quantity and unit cost of the next-to-the-last purchase. 3. Total the cost and market columns and insert the lower of the two totals in the LCM column. The first item on the inventory sheet has been completed below as an example.
The following three identical units of Item BZ1810 are purchased during November: Assume that one unit is sold on November 30 for 90. Determine the gross profit for November and ending inventory on November 30 using the (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average cost methods.
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.
COST ALLOCATION AND LOWER-OF-COST-OR-MARKET Hall Companys beginning inventory and purchases during the fiscal year ended December 31, 20--, were as follows: There are 1,100 units of inventory on hand on December 31. REQUIRED 1. Calculate the total amount to be assigned to the ending inventory and cost of goods sold on December 31 under each of the following 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 Halls inventory on December 31 was 16. 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. Prepare required entries to apply: (a) FIFO lower-of-cost-or-market (b) Weighted-average lower-of-cost-or-market
Pappas Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the year, and the inventory count at December 31 are summarized as follows: Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out method. Present data in columnar form, using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. 2. Determine the cost of the inventory on December 31 by the last-in, first-out method, following the procedures indicated in (1). 3. Determine the cost of the inventory on December 31 by the weighted average cost method, using the columnar headings indicated in (1). 4. Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.
Dymac Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the next 12 months, and the inventory count at December 31 are summarized as follows: Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out method. Present data in columnar form, using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. 2. Determine the cost of the inventory on December 31 by the last-in, first-out method, following the procedures indicated in (1). 3. Determine the cost of the inventory on December 31 by the weighted average cost method, using the columnar headings indicated in (1). 4. Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.
Inventory by three cost flow methods Details regarding the inventory of appliances on January 1, 20Y7, purchases invoices during the year, and the inventory count on December 31. 20Y7. of Amsterdam Appliances are summarized as follows: Instructions Determine the cost of the inventory on December 31, 2O7, by the first-in, first-out method. Present data in columnar form. using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase.
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).
Inventory Costing Methods On June 1, Welding Products Company had a beginning inventory of 210 cases of welding rods that had been purchased for S88 per case. Welding Products purchased 1,150 cases at a cost of $95 per case on June 3. On June 19, the company purchased another 950 cases at a cost of $112 per case. Sales data for the welding rods are: Welding Products uses a perpetual inventory system, and the sales price of the welding rods was $130 per case. Required: 1. Compute the cost of ending inventory and cost of goods sold using the FIFO method. 2. Compute the cost of ending inventory and cost of goods sold using the LIFO method. 3. Compute the cost of ending inventory and cost of goods sold using the average cost method. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.) 4. CONCEPTUAL CONNECTION Assume that operating expenses are $21,600 and Welding Products has a 30% tax rate. How much will the cash paid for income taxes differ among the three inventory methods? 5. CONCEPTUAL CONNECTION Compute Welding Products' gross profit ratio (rounded to two decimal places) and inventory turnover ratio (rounded to three decimal places) under each of the three inventory costing methods. How would the choice of inventory costing method affect these ratios?
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.
Lower-of-cost-or-market inventory Data on the physical inventory of Katus Products Co. as of December 31 follows: Quantity and cost data from the last purchases invoice of the year and the next-to-the-last purchases invoice are summarized as follows: Instructions Determine the inventory at cost and also at the lower of cost or market applied on an item-by-item basis, using the first-in, first-out method. Record the appropriate unit costs on the inventory sheet, and complete the pricing of the inventory. When there are two different unit costs applicable to an item, proceed as follows: 1. Draw a line through the quantity, and insert the quantity and unit cost of the last purchase. 2. On the following line, insert the quantity and unit cost of the next-to-the-last purchase. 3. Total the cost and market columns and insert the lower of the two totals in the LCM column. The first item on the inventory sheet has been completed as an example.