Chapter 5 Excel Worksheets in class

Chapter 5 Excel Worksheets in class - GOODS PURCHASED COST...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
INVENTORY COSTING ILLUSTRATION The following units of a particular item were available for sale during the year 1-Mar Beg Inventory 4 units @$ 3 Determine the Cost of Goods Sold and Gross Profit 4-Mar Purchase 8 units @ $ 6 using -Specific Identification (SI) 15-Mar Sale 7 units @ 15 -FIFO 21-Mar Purchase 10 units @ 8 -LIFO 31-Mar Sale 12 units @15 -Weighted Average (WA) SPECIFIC IDENTIFICATION: March 15 Sale : 2 units pur @ $3 and 5 units pur a@ $6 March 31 Sale : 2 units pur @ $6 and10 units Pur @ $8. DATE GOODS PURCHASED COST OF GOODS SOLD INVENTORY BALANCE Units Cost Total Units Cost Total Units Cost Total 1-Mar 4-Mar 15-Mar 21-Mar 31-Mar TOTAL FIFO: DATE
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: GOODS PURCHASED COST OF GOODS SOLD INVENTORY BALANCE Units Cost Total Units Cost Total Units Cost Total 1-Mar 4-Mar 15-Mar 21-Mar 31-Mar TOTAL LIFO: DATE GOODS PURCHASED COST OF GOODS SOLD INVENTORY BALANCE Units Cost Total Units Cost Total Units Cost Total 1-Mar 4-Mar 15-Mar 21-Mar 31-Mar TOTAL WEIGHTED AVERAGE: DATE GOODS PURCHASED COST OF GOODS SOLD INVENTORY BALANCE Units Cost Total Units Cost Total Units Cost Total 1-Mar 4-Mar Weighted Average 15-Mar 21-Mar Weighted Average 31-Mar TOTAL Financial Statement Effect Comparison METHOD SI FIFO LIFO WA SALES COGS GROSS PROFIT # END INV #...
View Full Document

This note was uploaded on 04/01/2008 for the course ACCT 2101 taught by Professor Bhan during the Fall '07 term at University of Georgia Athens.

Page1 / 2

Chapter 5 Excel Worksheets in class - GOODS PURCHASED COST...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online