Excel_Student_09-35kh

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Image of page 3
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 Right Arrow Icon
Ask a homework question - tutors are online