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

$\backslash$table$[[$FIFO$,,$Units,Unit Cost,$\backslash$table$[[$Cost of Goods$],[$Sold$]]],[$From beginning inventory,,$100,$@$,,$$$60,=,$$$6,000$

I need to be able to insert into excel. Pls included cell formulas $($Ex: B$4*$B$3$ for each of these questions in the charfs$)$