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$ PB$52541$ Paddle board Set $20$ $ $300\mathrm{.}00$ $ $6,000\mathrm{.}00$ $ $899\mathrm{.}952/28/202410$ $ $8,999\mathrm{.}50$

$03/12/24$ VC$25610$ Vortex Combo $20$ $ $80\mathrm{.}00$ $ $1,600\mathrm{.}00$ $ $209\mathrm{.}995/3/202410$ $ $2,099\mathrm{.}90$

$3/22/2024$ BB$26871$ Bongo Bouncer $6$ $ $900\mathrm{.}00$ $ $5,400\mathrm{.}00$ $ $1,799\mathrm{.}993/13/20242$ $ $3,599\mathrm{.}98$

$3/31/2024$ PB$52541$ Paddle board Set $24$ $ $310\mathrm{.}00$ $ $7,440\mathrm{.}00$ $ $899\mathrm{.}953/16/202418$ $ $16,199\mathrm{.}10$

$04/09/24$ VC$25610$ Vortex Combo $24$ $ $86\mathrm{.}00$ $ $2,064\mathrm{.}00$ $ $209\mathrm{.}993/30/202420$ $ $4,199\mathrm{.}80$

$4/18/2024$ BB$26871$ Bongo Bouncer $7$ $ $930\mathrm{.}00$ $ $6,510\mathrm{.}00$ $ $1,799\mathrm{.}992/4/20244$ $ $7,199\mathrm{.}96$

$4/28/2024$ VC$25610$ Vortex Combo $20$ $ $90\mathrm{.}00$ $ $1,800\mathrm{.}00$ $ $209\mathrm{.}9910/4/202424$ $ $5,039\mathrm{.}76$

$05/10/24$ PB$52541$ Paddle board Set $16$ $ $314\mathrm{.}00$ $ $5,024\mathrm{.}00$ $ $899\mathrm{.}954/23/202422$ $ $19,798\mathrm{.}90$

$5/21/2024$ BB$26871$ Bongo Bouncer $3$ $ $980\mathrm{.}00$ $ $2,940\mathrm{.}00$ $ $1,799\mathrm{.}991/5/20244$ $ $7,199\mathrm{.}96$

$06/07/24$ VC$25610$ Vortex Combo $28$ $ $95\mathrm{.}00$ $ $2,660\mathrm{.}00$ $ $209\mathrm{.}9912/5/202416$ $ $3,359\mathrm{.}84$

$06/10/24$ PB$52541$ Paddle board Set $33$ $ $326\mathrm{.}00$ $ $10,758\mathrm{.}00$ $ $899\mathrm{.}956/6/202415$ $ $13,499\mathrm{.}25$

$06/12/24$ BB$26871$ Bongo Bouncer $9$ $ $1,000\mathrm{.}00$ $ $9,000\mathrm{.}00$ $ $1,799\mathrm{.}996/14/20246$ $ $10,799\mathrm{.}94$

Using the data provided above, calculate the following using the proper Excel formulas: