Homework Help is Here – Start Your Trial Now!
Business
Accounting
Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales Sale Price 22,000 units 27 Date Number of Units Unit Cost Total Cost Beginning 5,100 10.30 $52,530 March 12 6,300 10.20 64,260 June 5 5,000 10.10 50,500 October 22 Totals 10,700 9.90 105,930 27,100 $273,220 Required: 1. Use your spreadsheet to recalculate the Cost of Goods Sold, Inventory balances, and Gross Profit under each method and enter your results below: (Round your answers to the nearest whole dollar amount.) FIFO LIFO Weighted Average Cost of Goods Sold Ending Inventory Gross Profit

Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales Sale Price 22,000 units 27 Date Number of Units Unit Cost Total Cost Beginning 5,100 10.30 $52,530 March 12 6,300 10.20 64,260 June 5 5,000 10.10 50,500 October 22 Totals 10,700 9.90 105,930 27,100 $273,220 Required: 1. Use your spreadsheet to recalculate the Cost of Goods Sold, Inventory balances, and Gross Profit under each method and enter your results below: (Round your answers to the nearest whole dollar amount.) FIFO LIFO Weighted Average Cost of Goods Sold Ending Inventory Gross Profit

Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter16: Manufacturing Accounting (mfg)
Section: Chapter Questions
Problem 2R
See similar textbooks
icon
Related questions
Question
Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales Sale Price 22,000 units 27 Date Number of Units Unit Cost Total Cost Beginning 5,100 10.30 $52,530 March 12 6,300 10.20 64,260 June 5 5,000 10.10 50,500 October 22 Totals 10,700 9.90 105,930 27,100 $273,220 Required: 1. Use your spreadsheet to recalculate the Cost of Goods Sold, Inventory balances, and Gross Profit under each method and enter your results below: (Round your answers to the nearest whole dollar amount.) FIFO LIFO Weighted Average Cost of Goods Sold Ending Inventory Gross Profit
Transcribed Image Text:Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales Sale Price 22,000 units 27 Date Number of Units Unit Cost Total Cost Beginning 5,100 10.30 $52,530 March 12 6,300 10.20 64,260 June 5 5,000 10.10 50,500 October 22 Totals 10,700 9.90 105,930 27,100 $273,220 Required: 1. Use your spreadsheet to recalculate the Cost of Goods Sold, Inventory balances, and Gross Profit under each method and enter your results below: (Round your answers to the nearest whole dollar amount.) FIFO LIFO Weighted Average Cost of Goods Sold Ending Inventory Gross Profit
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 1 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS