FER-8= use excelThe following information is available for Juddo Inc., a merchandising business in St. Catharines,Ontario. The business uses the perpetual inventory system and controls its inventory using theFIFO method.Description NumberDateUnit CostSellingof UnitsPriceMay 1Opening150$4May 12Purchase50$5May 22Sale158$12May 30Purchase 90$6Calculate the cost of goods sold and the ending inventory, using a perpetual inventory system.In addition, provide the entries for all the transactions (the chart is provided on the next page.)NOTE: more rows have been provided than you require. Assume all sales and purchases weremade for cash.

The objective of the question is to calculate the cost of goods sold (COGS) and the ending inventory…

Answered: FER-8= use excel The following…

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

Please help me
please dont provide answer in image format thank you
es W Required information [The following information applies to the questions displayed below.] (a Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date March 1 March 5 March 9 March 18 here to search 2 March 25 March 29 Sales Less: Cost of goods sold Gross profit Gross Margin 13 # Activities Beginning inventory Purchase Sales Purchase Purchase Sales Totals 4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, units sold include 140 units from beginning inventory, 270 units from the March 5 purchase, 120 units from the March 18 purchase, and 160 units, from the March 25 purchase. Note: Round weighted average cost per unit to two decimals and final answers to nearest whole dollar. 3 Ri $ FIFO $ 64,210 $ IDI 4 LIFO 99+ 15 % Units Acquired at Cost 250 units. @ $54.00 per unit 300 units @ $59.00 per unit 160 units 300 units 5 1,010 units 64,210 $ @…
You are provided with the following information for Geo Inc., which purchases its inventory from a supplier on account. All sales are also on account. Geo uses the FIFO cost formula in a perpetual inventory system. Increased competition has recently decreased the price of the product. Date Explanation Oct. 1 Beginning inventory 5 Purchases 8 Sales Purchases 15 20 Sales 26 Purchases Units 60 100 (120) 35 (60) 15 Unit Cost Price $140 130 200 120 160 110 Instructions (a) Prepare all journal entries for the month of October for Geo, the buyer. (b) Determine the cost of goods sold and ending inventory amount for Geo. (c) On October 31, Geo learns that the product has a net realizable value of $108 per unit. What amount should ending inventory be valued at on the October 31 statement of financial position? (d) Now assume that Geo uses the average cost formula in a perpetual inventory system. Determine the cost of goods sold and ending inventory amount for Geo, ignoring the effect of (c). (e)…
vishu subject-Accounting
Use the following inventory table to find the cost of goods sold using the first-in, first-out (FIFO) inventory method. Date of purchase Units purchased Cost per unit Retail price per unit Beginning inventory 42 $860 $965 February 5 25 $1,770 $2,115 February 9 19 $945 $1,208 March 3 27 $490 $600 Units sold 81 Question content area bottom Part 1 The cost of goods sold is $enter your response here. (Type an integer or a decimal.)
Please do not give solution in image format thanku
Required information The following information applies to the questions displayed below] Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date March 1 March 5 Harch 9. March 18 March 25 March 29 Total Perpetual FIFO Activities Beginning inventory Purchase Sales Purchase Purchase Sales Totals Date March 1 March 5 March 18 March 25 Complete this question by entering your answers in the tabs below. Perpetual LIFO 3. Compute the cost assigned to ending inventory using (a) FIFO. (b) LIFO. (c) weighted average, and (d) specific identification. For specific identification, units sold include 80 units from beginning inventory. 340 units from the March 5 purchase. 40 units from the March 18 purchase, and 120 units from the March 25 purchase. Weighted Average Goods Available for Sale # of units 400 120 200 720 Specific Id Compute the cost assigned to ending inventory using specific identification. For specific…
Weat
Please don't give image format
Please do not give solution in image format thanku

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