PLEASE DO NOT CUT OFF ANSWER AND MARK BOXES WITH THE SAME NAME AS THEY HAVE IN THE PHOTO. Required:1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. Round unit cost to two decimal places, ifnecessary.Midnight SuppliesPerpetual Inventory AccountWeighted Average Cost MethodFor the three months ended March 31PurchasesCost of Merchandise SoldInventoryDateQuantityUnit CostTotal CostQuantityUnit CostTotal CostQuantityUnit CostTotal CostJan. 17,500 VJan. 1022,50085 V$1,912,50Jan. 2811,25p $$1,687,50 xJan. 303,750Accounting numeric field1,50Feb. 5Feb. 1054,000 V87.504,725,00 vFeb. 1627,000Feb. 2825,500Mar. 545,00089.50 V4,027,50Mar. 1430,000Mar. 257,50090675,000Mar, 3026,250 vMar. 31Balances2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period.Total salesTotal cost of merchandisesoldGross profit from sales3. Determine the ending inventory cost as of March 31. Weighted Average Cost Method with Perpetual InventoryThe beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows:Number PerDate Transaction of Units UnitTotalJan.Inventory7,500 $75.00$562,50010 Purchase22,50085.00 1,912,50028 Sale11,250 150.00 1,687,50030 Sale3,750 150.00562,500Feb.Sale5.1,500 150.00225,00010 Purchase54,00087.50 4,725,00016 Sale27,000 160.00 4,320,00028 Sale25,500 160.00 4,080,000Mar.Purchase45,00089.50 4,027,50014Sale30,000 160.00 4,800,00025 Purchase7,50090.00675,00030 Sale26,250 160.00 4,200,000

The gross profit is calculated as difference between sales and cost of sales.

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. Round unit cost to two decimal places, it necessary. Midnight Supplies Perpetual Inventory Account Weighted Average Cost Method For the three months ended March 31 Purchases Cost of Merchandise Sold Inventory Unit Cost Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Total Cost Jan. 1 7,500 Jan. 10 22,500 85 s1,912,50 Jan, 28 11,20 1,687,50 x 3,750 Accounting numeric field 1,50- Jan. 30 Feb. 5 Feb. 10 54,000 87.50 4,725,00 Feb. 16 27,000 Feb. 28 25,500 Mar. S 45,000 89.50 4,027,50 Mar. 14 30,000 Mar. 25 7,500 90 675,000 Mar. 30 26,250 Mar. 31 Balances 2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period. Total sales

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. Round unit cost to two decimal places, it necessary. Midnight Supplies Perpetual Inventory Account Weighted Average Cost Method For the three months ended March 31 Purchases Cost of Merchandise Sold Inventory Unit Cost Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Total Cost Jan. 1 7,500 Jan. 10 22,500 85 s1,912,50 Jan, 28 11,20 1,687,50 x 3,750 Accounting numeric field 1,50- Jan. 30 Feb. 5 Feb. 10 54,000 87.50 4,725,00 Feb. 16 27,000 Feb. 28 25,500 Mar. S 45,000 89.50 4,027,50 Mar. 14 30,000 Mar. 25 7,500 90 675,000 Mar. 30 26,250 Mar. 31 Balances 2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period. Total sales

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

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 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.
Calculate the cost of goods sold dollar value for B67 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).
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.
LIFO perpetual inventory The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are shown in Problem 6-1B. Instructions 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. 2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period. 3. Determine the ending inventory cost on June 30.
Calculate the cost of goods sold dollar value for A65 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO).
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.
Calculate the cost of goods sold dollar value for A66 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for last-in, first-out (LIFO).
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 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.
Bleistine Company had the following transactions for the month. Calculate the gross margin for the period for each of the following cost allocation methods, using periodic inventory updating. Assume that all units were sold for $50 each. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Akira Company had the following transactions for the month. Calculate the gross margin for the period for each of the following cost allocation methods, using periodic inventory updating. Assume that all units were sold for $25 each. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)