Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales 17,800 units Sale Price 27 Date Number of Units

Revise your worksheet to reflect these updated assumptions and then answer the questions that follow.

Sales 17,800 units
Sale Price 27

Date Number of Units Unit Cost Total Cost
Beginning 3,900 10.30 $40,170
March 12 5,100 10.20 52,020
June 5 3,800 10.10 38,380
October 22 8,900 9.90 88,110
Totals 21,700 $218,680

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions