To help you get started, the file already has a list of columns for you to fill out. Row $2$ has the beginning inventory. Starting with row $3,$ you need to fill can find the updated inventory total cost and weighted$-$average cost. Fo accomplish this task, complete the following steps:

a$.$ Conditional logic: Because a new record can be either a "purchase" or a "sale", you need to handle these two situations differentiy; you need to apply If statements:

i$.$ In $E3,$ create an If statement that will be equal to $1$ it $B3$ is a purchase and equal to $-1$ if $B3$ is a sale.

ii$.$ In $F3,$ create an If statement that will be reval to $y$ it $ss$ is a purchase and $0$ otherwisc.

iii. In G$3,$ create an If statement that will be equas ate if it $83$ is a sale and $0$ otherwise.

b$.$ Find units on hand: in $H3,$ qreate an equesion that calculates the updated units on hand: if $B3$ is a purchase, updated units on hand $=H2+C3$; if $B3$ is a hand $=H2-C_3.$

c$.$ Find inventory cost:

Hint: We use $1?$ ar ate

Inventory

weiahted