PLEASE SHOW $3$ DECIMAL POINTS FOR $($A$1)$ MOVING$-$AVERAGE COST PER UNIT AND HOW TO CALCULATE EACH ONE...

GROSS PROFIT WAS WRONG FOR $($A$2)$ HOW DO I CALCULATE IT$.$

SHOW ME FORMULAS IN EXCEL IF EASIER OR JUST WRITE FORMULA PLEASE.

Crane Inc. is a retailer operating in British Columbia. Crane uses the perpetual inventory system. All sales returns from customers

result in the goods being returned to inventory; the inventory is not damaged. Assume that there are no credit transactions; all

amounts are settled in cash. You are provided with the following information for Crane Inc. for the month of January $2022.$

$($a$1)$

Calculate the Moving$-$average cost per unit at January $1,5,8,10,15,16,20,$ & $25.($Round moving$-$average cost per unit answers to $3$

decimal places, e$.$g$.5\mathrm{.}251.)$

Attempts: $0$ of $5$ used

$(a2)$

For each of the following cost flow assumptions, calculate cost of goods sold, ending inventory, and gross profit. $(1)$ LIFO. $(2)$ FIFO.

$(3)$ Moving$-$average cost. $($Round average$-$cost per unit to $3$ decimal places, e$.$g$.12\mathrm{.}502$ and final answer to $0$ decimal places, e$.$g$.1,250.)$