Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales Sale Price 16,400 units 27 Number of Date Beginning March 12 June 5 Units Unit Cost Total Cost 3,500 10.30 $36,050 4,700 10.20 47,940 3,400 10.10 34,340 October 22 8,300 9.90 82,170 Totals 19,900 $200,500 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 16,400 units 27 Number of Date Beginning March 12 June 5 Units Unit Cost Total Cost 3,500 10.30 $36,050 4,700 10.20 47,940 3,400 10.10 34,340 October 22 8,300 9.90 82,170 Totals 19,900 $200,500 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
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter3: Cost Behavior
Section: Chapter Questions
Problem 5CE: Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Step 1: Introduce to FIFO, LIFO and Weighted Average Method
VIEWStep 2: Working for sales revenue
VIEWStep 3: Working for cost of goods sold, ending inventory and gross profit using FIFO
VIEWStep 4: Working for cost of goods sold, ending inventory and gross profit using LIFO
VIEWStep 5: Working for cost of goods sold, ending inventory and gross profit using weighted average method
VIEWSolution
VIEWTrending now
This is a popular solution!
Step by step
Solved in 6 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning