Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / Whispering Winds Corp
Whispering Winds Corp. is a retailer operating in Calgary, Alberta. They use the perpetual inventory method. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Whispering Winds Corp. for the month of January 2017.
| Date | Description | Quantity | Unit Cost or Selling Price |
|---|---|---|---|
| Dec. 31 | Ending inventory | 162 | $19 |
| Jan. 2 | Purchase | 207 | 21 |
| Jan. 6 | Sale | 184 | 30 |
| Jan. 9 | Purchase | 92 | 23 |
| Jan. 10 | Sale | 51 | 44 |
| Jan. 23 | Purchase | 91 | 23 |
| Jan. 30 | Sale | 127 | 47 |
1. Calculate average cost for each unit. (Round answers to 3 decimal places, e.g. 5.125.)
2. For each of the following cost flow assumptions, calculate
(i) cost of goods sold,
(ii) ending inventory, and
(iii) gross profit. (Round answers to 0 decimal places, e.g. 125.)
Part 1)
Average cost = total cost available for sale / total units acquired
Where
Total cost availablefor sale (opening stock + purchase) = (162 *$19 +207*$21+92*$23+91*$23) = $11634
Total units(opening stock + purchase) = 162+207+92+91 = 552
Average cost = $11634/552 =$21.076
Part 2)
ii) Ending units = opening stock + total purchase - total sales = 552-(184+51+127) =190
Value of ending inventory = units * average cost =190 * 21.076 = $4004.44
i) Cost of goods sold (COGS) = total cost available for sale - ending inventory = $11634 -$4004.44 = $7629.56
iii)
Gross profit = total sales - COGS
Total sales = 184*$30 +51*$44+127*$47 = $13733
Gross profit = $13733-$7629.56 = $6103.44
