{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 5 Excel Worksheets in class

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

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

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 [email protected] \$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

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

View Full Document
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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online