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.

$\backslash$table$[[100,$$$60,],[150,$$$68,],[200,$$$72,270]]$

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.$)$

$\backslash$table$[[$FIFO$,,$Units,,Unit Cost,,$\backslash$table$[[$Ending$],[$Inventory$]]],[$From second purchase,$V,\backslash$table$[[$@

Give the excel formulas to get these answers!!!! Must use an excel formula