Cortez Company sells chairs that are used at computer stations. Its beginning inventory of chairs was $100$ units at $$60$

per unit. During the year, Cortez made two batch purchases of this chair. The first was a $150-$unit purchase at $$68$ per

unit; the second was a $200-$unit purchase at $$72$ per unit. During the period, it sold $270$ chairs.

Required

a$1.$ Determine the amount of product costs that would be allocated to cost of goods sold, assuming that Cortez uses FIFO.

$($Use the cells from the given information to complete this question.$)$

a$2.$ Determine the amount of product costs that would be allocated to ending inventory, assuming that Cortez uses FIFO.

$($Use the cells from the given information to complete this question.$)$b$1.$ Determine the amount of product costs that would be allocated to cost of goods sold, assuming that Cortez uses LIFO.

$($Use the cells from the given information to complete this question.$)$

b$2.$ Determine the amount of product costs that would be allocated to ending inventory, assuming that Cortez uses LIFO.

$($Use the cells from the given information to complete this question.$)$

c$.$ Determine the amount of product costs that would be allocated to cost of goods sold and ending inventory, assuming that Cortez uses Weighted average.

$($Use the cells from the given information to complete this question.$)$

USE EXCEL FORMULAS AND CELL REFERENCES PLEASE. THANK YOU!