The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows:NumberDateTransactionPer UnitTotalof UnitsJan. 1Inventory7,500$75.00$562,50010Purchase22,50085.001,912,50028Sale11,250150.001,687,50030Sale3,750150.00562,500Feb. 5Sale1,500150.00225,00010Purchase54,00087.504,725,00016Sale27,000160.004,320,00028Sale25,500160.004,080,000Mar. 5Purchase45,00089.504,027,50014Sale30,000160.004,800,00025Purchase7,50090.00675,00030Sale26,250160.004,200,000Required: 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 weightedaverage cost method. Round unit cost to two decimal places, if necessary.Midnight SuppliesSchedule of Cost of Merchandise SoldWeighted Average Cost MethodFor the three months ended March 31PurchasesCost of Merchandise SoldInventoryDateQuantityUnit CostTotal CostQuantityUnit CostTotal CostQuantityUnit CostJan. 1Jan. 10an. 28Jan. 30Feb. 5Feb. 10Feb. 16Feb. 28Mar. 5Mar. 14Mar. 25Mar. 30Mar. 31Balances

Cost of goods sold: Cost of goods sold is the total of all the expenses incurred by a company to…

Answered: The beginning inventory at Midnight…

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

Ch 9 Problem Set B Problem 9-1 Part B The company uses the perpetual inventory method. It began the month of March with 100 units of inventory, at a unit cost of $55. Purchases during March March 5, 60 units at $60 each. March 18, 200 units at $65 each March 29, 40 units at $75 each. Sales during March March 12, 60 units. March 25, 210 units. All units were sold to customer for $100 each. 1. Use the following format to set up this inventory costing problem, as shown in Video #2. Inventory Date Units Cost per Total Cost Date Units Total Cost Unit Beg Balance Units Cost Beginning Balance + Purchases Goods Available for Sale - Sold Ending Balance
Question Content Area Based on the following data for the current year, what is the inventory turnover (rounded to one decimal place)? Sales on account during year $598,636 Cost of merchandise sold during year 212,753 Accounts receivable, beginning of year 44,419 Accounts receivable, end of year 53,126 Merchandise inventory, beginning of year 32,158 Merchandise inventory, end of year 39,584
Based upon the following data for a business with a periodic inventory system, determine the cost of goods sold for August. Inventory, August 1 Inventory, August 31 Purchases Purchases returns and allowances Purchases discounts Freight in Schedule of the Cost of Goods Sold For the Month Ended August 31 Line Item Description Cost of merchandise purchased: Net purchases Total cost of merchandise purchased $ 71,130 90,820 368,870 16,360 12,190 3,540 Amount Amount 1000 $
petermine the gross profit, cost of merchandise sold, and ending inventory on July 31 using the (a) first-in, first-out, (b) last-in, first-out, and (c) average cost flow methods.
DETERMINING THE BEGINNING AND ENDING INVENTORY FROM A PARTI ALSPREADSHEET: PERIODIC INVENTORY SYSTEM From the following partial spreadsheet, indicate the dollar amount of beginning and ending merchandise inventory to be used to compute cost of goods sold.
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?
Compute cost of goods sold assuming periodic inventory procedures and inventory priced at FIFO.
Please help me make a perpetual FIFO, perpetual LIFO, Weighted Average, and Specific ID chart. Thank you
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
B66's transactions involving inventory for the month are shown below. Calculate the dollar amount of Sales, Cost of Goods Sold, Gross Margin and Ending Inventory using the three cost allocation methods (FIFO, LIFO, and Weighted Average) with perpetual inventory updating. Number of Units Unit Cost Sales Beginning Inventory 100 $66 Sold 50 $120 Purchased 80 $75 Sold 25 $125 Ending Inventory 105 Show your calculations and clearly label your solution. Submit your work as an attachment to this assignment.
How do you calculate the total amount to be assigned to the ending inventory and cost of goods sold December 31 under each of the following methods?

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS