Question: Instructions - Complete the below chart for Weighted Average. Note: USE Excel for linking the numbers and use formulas in Excel for any calculations. Goods
| Instructions - Complete the below chart for Weighted Average. Note: USE Excel for linking the numbers and use formulas in Excel for any calculations. | ||||||||||
| Goods Purchased | Cost of Goods Sold | Balance in Inventory | ||||||||
| Date | Units | Unit Cost | Total $ | Units | Unit Cost | Total $ | Units | Unit Cost | Total $ | |
| June. 1 | 100 | $1 | ||||||||
| 3 | 500 | $4 | ||||||||
| 8 | 500 | $6 | ||||||||
| 10 | ||||||||||
| 200 | ||||||||||
| 15 | 400 | $7 | ||||||||
| 20 | ||||||||||
| 500 | ||||||||||
| 27 | 400 | $7 | ||||||||
| Total COGS | ||||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
