Excel_Student_09-34kh

Excel_Student_09-34kh - The word Wrong will appear to the...

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

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

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

View Full DocumentRight Arrow Icon
09-34 Name: Solution Enter the appropriate amounts/formulas in the blue-shaded cells.
Background image of page 2
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

Page1 / 2

Excel_Student_09-34kh - The word Wrong will appear to the...

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