Please show the work and formula from the reference cell. I appreciate it a lot!!

A B C F G 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 a1. 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 B C D E F G H I b1. 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.) b2. 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.)