Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 3,100 units at $37 May 10 1,550 units at $39 May 12 2,170 units 20 1,395 units at $41 14 1,860 units 31 930 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Merchandise Sold LIFO Method Prepaid Cell Phones Cost of Cost of Merchandise Merchandise Purchases Purchases Quantity Unit Cost Sold Sold Inventory Inventory Inventory Quantity Total Cost Unit Cost Total Cost Sold Quantity Unit Cost Total Cost Date Purchased May 1 May 10 88 May 12 88 May 14 May 20

Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 3,100 units at $37 May 10 1,550 units at $39 May 12 2,170 units 20 1,395 units at $41 14 1,860 units 31 930 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Merchandise Sold LIFO Method Prepaid Cell Phones Cost of Cost of Merchandise Merchandise Purchases Purchases Quantity Unit Cost Sold Sold Inventory Inventory Inventory Quantity Total Cost Unit Cost Total Cost Sold Quantity Unit Cost Total Cost Date Purchased May 1 May 10 88 May 12 88 May 14 May 20

Name: Beginning inventory, purchases, and sales data for prepaid cell phone
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows:InventoryPurchasesSalesMay 13,100 units at $37May 101,550 units at $39May 122,170 units201,395 units at $41141,860 units31930 unitsa. Assuming that the per

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Using the FIFO method, complete the steps below to calculate the ending inventory units, inventory account balance, and cost of goods sold account balance at the end of the period.Date Activity Units Purchase Price (per unit)Sale Price(per unit)1-Feb Beginning Inventory 100 $ 4515-Feb Purchase 700 $ 529-Apr Sale 1 600 $ 9029-May Purchase 500 $ 5610-Jul Sale 2 600 $ 9010-Sep Purchase 400 $ 5815-Oct Sale 3 400 $ 905-Nov Purchase 900 $ 6218-Dec Sale 4 200 $ 901. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 1.Cost of Goods Sold (units) Total COGS after Sale 1 Inventory Remaining (units) Total Inventory Balance after Sale 1Totals:2. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 2.Cost of Goods Sold (units) Total COGS after Sale 2 Inventory Remaining (units) Total Balance after Sale 2Totals:3. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 3. Cost of Goods Sold (units) Total COGS after…
Beginning inventory, purchases and sales data for T-shirts are as follows: April 3 Inventory 24 units @ $10 11 Purchase 26 units @ $12 14 Sale 36 units 21 Purchase 18 units @ $15 25 Sale 20 units Assuming the business maintains a periodic inventory system; calculate the cost of merchandise sold and ending inventory under the following assumptions: FIFO LIFO Average cost In your computations, round the average cost per unit to two decimal places and round your final answers to the nearest dollar.
The accounting records of Skysong Electronics show the following data. Beginning inventory 1.000 units at $5 Purchases 9,000 units at $7 9.500 units at $10 Sales (a) Determine cost of goods sold during the period under a periodic inventory system using the FIFO method. (Round answer to O decimal places, e.g. 1,250.) Cost of goods sold during the period FIFO
UMET's Stores had the following inventory transactions in 2020: Transaction Units Cost per unit 1/1 Balance 50 $6 2/14 Sale 25 5/23 Purchase 100 8 8/21 Sale 50 11/5 Purchase 25 12 11/18 Sale 95 Required: Compute tge cost of goods sold and the ending inventory using the periodic inventory system for each of the following cost flow assumptions: a. FIFO b. LIFO c. Weighted average
The following are the transactions for the month of July. Units Unit Cost Unit Selling Price July 1 Beginning Inventory 55 $ 10 July 13 Purchase 275 11 July 25 Sold (100 ) $ 14 July 31 Ending Inventory 230 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under FIFO. Assume a periodic inventory system is used. How would i creat a FIFO periodic table?
Use the following information to calculate the a) value of inventory on hand on Mar 31, b) cost of goods sold and c) Gross Profit during March under Perpetual inventory system. a) FIFO b) Weighted Average Mar 1 Beginning Inventory 68 units @ $15.00 per unit 5 Purchase 140 units @ $15.50 per unit 9 Sale 94 units @ $19.00 per unit 11 Purchase 40 units @ $16.00 per unit 16 Purchase 78 units @ $16.50 per unit 20 Sale 116 units @ $19.50 per unit
Beginning inventory, purchases, and sales data for prepaid cell phones for December are as follows: Inventory Purchases Sales Dec. 1 3,800 units at $23 Dec. 10 1,900 units at $25 Dec. 12 2,660 units Dec. 20 1,710 units at $27 Dec. 14 2,280 units Dec. 31 1,140 units Question Content Area a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of goods sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Goods SoldLIFO MethodPrepaid Cell Phones Date QuantityPurchased PurchasesUnit Cost PurchasesTotal Cost QuantitySold Cost ofGoods SoldUnit Cost Cost ofGoods SoldTotal Cost InventoryQuantity InventoryUnit…
Beginning inventory, purchases, and sales data for tennis rackets are as follows
Please help me make a perpetual FIFO, perpetual LIFO, Weighted Average, and Specific ID chart. Thank you
You are given the following information for Sandhill Company for the month ended November 30, 2024 Date Description Units Unit Cost Nov. 1 Beginning inventory 61 352 9 Purchase 100 46 15 Sale (120) 22 Purchase 145 43 29 Sale (150) 30 Purchase 42 42 -/1 Sandhill Company uses a perpetual inventory system. All sales and purchases are on account, Calculate the cost of goods sold and the ending inventory using weighted average (Round the weighted average cost per unir and final answers to 2 decimal places, eg 5,275.75)
The following data regarding purchases and sales of a commodity were taken from the related inventory account (perpetual inventory system is used): May 1 Balance 25 units at $41 6 Sale 20 units 8 Purchase 20 units at $42 16 Sale 10 units 20 Purchase 20 units at $43 23 Sale 25 units 30 Purchase 15 units at $45 (a) Determine the total cost of the inventory balance at May 31, using the first-in, first-out method. Also, identify the quantity, unit price, and total cost of each lot/layer in the ending inventory. (b) Determine the total cost of the inventory balance at May 31, using the last-in, first-out method. Also, identify the quantity, unit price, and total cost of each lot/layer in the ending inventory. (a) FIFO (b) LIFO
The cost of merchandise sold and merchandise inventory is determined from the inventory cost flow assumption. To illustrate, beginning inventory, purchases and sales of shoes are shown below for Grant Co., using a perpetual inventory system. 1. In the table below, fill in the March 24 quantity, unit cost, and total cost in the spaces provided for determining Cost of Merchandise Sold (COMS) and Merchandise Inventory under the FIFO cost flow assumption, assuming 32 shoes are sold on March 24. Determine the COMS and Merchandise inventory final balances. If units are in inventory or are listed under cost of merchandise sold at two different costs, enter the units that were purchased earliest first. 2. In the table below, fill in the March 24 quantity, unit cost, and total cost in the spaces provided for determining Cost of Merchandise Sold (COMS) and Merchandise Inventory under the LIFO cost flow assumption, assuming 32 shoes are sold on March 24. Determine the COMS and Merchandise…