Excel for happygolucky

Excel for happygolucky - April FIFO Inventory Cost Flow...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
April FIFO Inventory Cost Flow Calculations Golf Bags Cost of Goods Purchased Cost of Goods Sold Cost per Unit Total Cost Units Sold Cost per Unit Cost of Goods Sold Beg. Inventory 30 $95.00 $2,850 Week 1 Sales $- Week 1 Sales $- Purchases (End of Week 1) $- Week 2 Sales $- Week 2 Sales $- Purchases (End of Week 2) $- Week 3 Sales $- Week 3 Sales $- Purchases (End of Week 3) $- Week 4 Sales $- Week 4 Sales $- Week 4 Sales $- Purchases (End of Week 4) $- 30 $2,850 0 $- 30 $2,850 Sets of Golf Clubs Cost of Goods Purchased Cost of Goods Sold Cost per Unit Total Cost Units Sold Cost per Unit Cost of Goods Sold Beg. Inventory 30 $820.00 $24,600 Week 1 Sales $- Week 1 Sales $- Purchases (End of Week 1) $- Week 2 Sales $- Week 2 Sales $- Purchases (End of Week 2) $- Week 3 Sales $- Week 3 Sales $- Purchases (End of Week 3) $- Week 4 Sales $- Week 4 Sales $- Week 4 Sales $- Purchases (End of Week 4) $- 30 $24,600 0 $- 30 $24,600 Golf Shoes Cost of Goods Purchased Cost of Goods Sold Cost per Unit Total Cost
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online