Use the given information and your calculated numbers to complete the Cost of Goods Sold Equation below for all three inventory methods. $($All

numbers should be positive.$)$

$($Use cells A$4$ to D$10$ from the given information to complete this question.$)$function equations for the excel Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO.

$($Use cells A$4$ to D$10$ from the given information to complete this question.$)$

Using Periodic Weighted Average, first calculate the cost per unit using the formula below.

Next, apply that same cost per unit to calculate both the Ending Inventory and Cost of Goods Sold.

$($Use cells A$4$ to D$10$ from the given information to complete this question.$)$