Obj. 2, 3 fit. The beginning inventory for Dunne Co. and data on purchases and sales for a three-month PR 6-2B LIFO perpetual inventory Gross prof $213,170 period are shown in Problem 6-1B. Instructions 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record TEMPLATE 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. D2 Problem 6-2B Name: Section Score: 0% Key Code: [Key code herel Instructions 9 Answers are entered in the cells with gray backgrounds 10 Cells with non-gray backgrounds are protected and cannot be edited. 11 An asterisk () will appear to the right of an incorrect entry. In part 1, only final inventory cost-Column K- will be graded 12 File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do D2 Purchases Coat of Goods Sold -1 inventory Total Cost Unit Total Unit Unit Quantity Cost Total Cost Quantity Cost Cost Quantity Cost 25 | $1,200 |$ 30000 30 May 8 6 10 19 28 une 5 16 21 28 30 Balances Pr. 6-2B AutoSave ort a ile Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you PR 6-2B (1) Protected View-Excel B. 2. Total sales Total cost of goods sold Gross profit 3. Ending inventory cost Chapter 6 Inventories 327 problems: Series B PR 6-1B FIFO perpetual inventory Obj. 2, 3 The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date TransactionNumber Per of Units 25 Total Apr. 3 Inventory $1.200 30,000 93,000 8 Purchase 1,240 2,000 2,000 1,260 2,000 2,000 1,260 2,250 2,250 1,264 2,250 11 Sale 30 Sale 80,000 May 8 Purchase 75,600 100,000 40,000 100,800 90,000 56,250 44,240 10 Sale 19 Sale 28 Purchase June 5 Sale 16 Sale 21 Purchase 35 28 Sale 99,000