Name: ____________________________ ID#: ________________- Valuing Phisical Inventory Cans of Tomato Sauce Cans Price Total Open Inventory 8 $1.25 $10.00 Purchased 7th of Month 17 $1.35 $22.95 Purchased 15th of the Month 31 $1.25 $38.75 Purchased 20th of Month 12 $1.15 $13.80 Total Purchase 60 $3.75 75.50 Total Value good Available 68 85.50 Closing Inventory 26 Number Consumed Actual Price Method Quantity Price Total Value of Closing inventory FIFO Value of Closing inventory Weighted Average Wt Average of Available Value of Closing Inventory Latest Purchase Price Value of Closing Inventory LIFO Value of Closing Inventory Comparison Actual FIFO Wt Ave Last $ LIFO Open Inventory Purchases Total Available Closing Inventory CoGS ** Zero Marks if Excel formulae not used ** Bonus Marks if you Chart CoGS per method ** Your Name and ID Number must be on this sheet