Excel_Student_09-34kh

# Excel_Student_09-34kh - The word “Wrong” will appear to...

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

09-34 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: Most recent purchase 350 units @ \$19.50 \$6,825 2. LIFO: Oldest cost 250 units @ \$17.00 \$4,250 Next oldest cost 100 units @ 18.00 1,800 350 units \$6,050 3. Average: Beginning inventory 250 units @ \$17.00 \$4,250 Purchases 900 units @ 18.00 16,200 1,200 units @ 19.50 23,400 Total units \$43,850 Average unit cost \$43,850 divided by 2,350 \$18.66 Ending inventory valuation: 350 units @ \$18.66 \$6,531

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

View Full Document
09-34 Name: Solution Enter the appropriate amounts/formulas in the blue-shaded cells.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: The word “Wrong” will appear to the left of incorrect entries. 1. FIFO: Most recent purchase 350 units @ \$19.50 \$6,825 2. LIFO: Oldest cost 250 units @ \$17.00 \$4,250 Next oldest cost 100 units @ 18.00 1,800 350 units \$6,050 3. Average: Beginning inventory 250 units @ \$17.00 \$4,250 Purchases 900 units @ 18.00 16,200 1,200 units @ 19.50 23,400 Total 2,350 units \$43,850 Average unit cost \$43,850 divided by 2,350 \$18.66 Ending inventory valuation: 350 units @ \$18.66 \$6,531...
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

Excel_Student_09-34kh - The word “Wrong” will appear to...

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

View Full Document
Ask a homework question - tutors are online