Excel_Student_09-35kh

# Excel_Student_09-35kh - 09-35 Name kathy haines Enter the...

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

09-35 Name: kathy haines Enter the appropriate amounts/formulas in the blue-shaded cells. The word "Wrong" will appear to the left of incorrect entries. 1. FIFO (Perpetual) Inventory Record - Product X Received Issued Balance Date Quantity Unit Cost Cost Quantity Unit Cost Cost Quantity Unit Cost Cost 9-1 600 \$1.50 \$900 9-6 200 \$2.00 \$400 600 1.50 900 200 2.00 400 9-12 400 \$1.50 \$600 200 1.50 300 200 2.00 400 9-13 100 1.50 150 100 1.50 150 200 2.00 400 9-18 250 3.00 750 100 1.50 150 200 2.00 400 250 3.00 750 9-20 150 3.50 525 100 1.50 150 200 2.00 400 250 3.00 750 150 3.50 525 9-25 100 1.50 150 250 3.00 750 200 2.00 400 150 3.50 525 FIFO (perpetual) ending inventory value: 250 units @ \$3.00 \$750 150 units @ 3.50 525 400 \$1,275 2. FIFO (periodic) ending inventory value: 250 units @ \$3.00 \$750 150 units @ 3.50 525 400 \$1,275

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

View Full Document
3. LIFO (Perpetual) Inventory Record - Product X Received Issued Balance Date Quantity Unit Cost Cost Quantity Unit Cost Cost Quantity Unit Cost Cost 9-1 600 \$1.50 \$900
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 08/12/2011 for the course ACCT 2201 taught by Professor Alvarez during the Spring '11 term at FIT.

### Page1 / 4

Excel_Student_09-35kh - 09-35 Name kathy haines Enter the...

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

View Full Document
Ask a homework question - tutors are online