|
| Wild Water Sports Inc. |
|
| LIFO, FIFO & Weighted Average Methods |
|
| Purchase date |
Item ID |
Item Description |
Quantity |
Unit Cost |
Total Cost |
| Unit Sales Price |
Sales date |
Units Sold |
Total sales |
|
| 2/25/2024 |
PB52541 |
Paddle board Set |
20 |
$ 300.00 |
$ 6,000.00 |
| $ 899.95 |
2/28/2024 |
10 |
$ 8,999.50 |
|
| 03/12/24 |
VC25610 |
Vortex Combo |
20 |
$ 80.00 |
$ 1,600.00 |
| $ 209.99 |
5/3/24 |
10 |
$ 2,099.90 |
|
| 3/22/2024 |
BB26871 |
Bongo Bouncer |
6 |
$ 900.00 |
$ 5,400.00 |
| $ 1,799.99 |
3/13/2024 |
2 |
$ 3,599.98 |
|
| 3/31/2024 |
PB52541 |
Paddle board Set |
24 |
$ 310.00 |
$ 7,440.00 |
| $ 899.95 |
3/16/2024 |
18 |
$ 16,199.10 |
|
| 04/09/24 |
VC25610 |
Vortex Combo |
24 |
$ 86.00 |
$ 2,064.00 |
| $ 209.99 |
3/30/2024 |
20 |
$ 4,199.80 |
|
| 4/18/2024 |
BB26871 |
Bongo Bouncer |
7 |
$ 930.00 |
$ 6,510.00 |
| $ 1,799.99 |
2/4/24 |
4 |
$ 7,199.96 |
|
| 4/28/2024 |
VC25610 |
Vortex Combo |
20 |
$ 90.00 |
$ 1,800.00 |
| $ 209.99 |
10/4/24 |
24 |
$ 5,039.76 |
|
| 05/10/24 |
PB52541 |
Paddle board Set |
16 |
$ 314.00 |
$ 5,024.00 |
| $ 899.95 |
4/23/2024 |
22 |
$ 19,798.90 |
|
| 5/21/2024 |
BB26871 |
Bongo Bouncer |
3 |
$ 980.00 |
$ 2,940.00 |
| $ 1,799.99 |
1/5/24 |
4 |
$ 7,199.96 |
|
| 06/07/24 |
VC25610 |
Vortex Combo |
28 |
$ 95.00 |
$ 2,660.00 |
| $ 209.99 |
12/5/24 |
16 |
$ 3,359.84 |
|
| 06/10/24 |
PB52541 |
Paddle board Set |
33 |
$ 326.00 |
$ 10,758.00 |
| $ 899.95 |
6/6/24 |
15 |
$ 13,499.25 |
|
| 06/12/24 |
BB26871 |
Bongo Bouncer |
9 |
$ 1,000.00 |
$ 9,000.00 |
| $ 1,799.99 |
6/14/2024 |
6 |
$ 10,799.94 |
|
| Using the data provided above, calculate the following using the proper Excel formulas: |
|
| Paddle Board |
|
| Number of items remaining in Ending Inventory |
|
|
| Cost of Goods Sold |
Cost of Ending Inventory |
|
| LIFO |
|
| FIFO |
|
| Weighted Average |
|
| Vortex Combo |
|
| Number of items remaining in Ending Inventory |
|
|
| Cost of Goods Sold |
Cost of Ending Inventory |
|
| LIFO |
|
| FIFO |
|
| Weighted Average |
|
| Bongo Bouncer |
|
| Number of items remaining in Ending Inventory |
|
|
| Cost of Goods Sold |
Cost of Ending Inventory |
|
| LIFO |
|
| FIFO |
|
| Weighted Average |
|
| Total for all products |
|
|
| Cost of Goods Sold |
Cost of Ending Inventory |
|
| LIFO |
|
| FIFO |
|
| Weighted Average |