***I need these answered with cell references please.***

A D E F G H I ] L 1 2 3 100 $60 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. 150 200 $68 $72 270 Required a1. Determine the amount of product costs that would be allocated to cost of goods sold, assuming that Cortez uses FIFO. 6 7 8 9 10 (Use the cells from the given information to complete this question.) A D E F G I j 7 Cost of 11 FIFO Units Unit Cost Goods Sold 12 From beginning inventory 100 @ $60 $6,000 13 From first purchase 150 @ $68 $10,200 14 From second purchase 20 @ $72 $1,440 15 Total 270 $17,640 16 17 a2. Determine the amount of product costs that would be allocated to ending inventory, assuming that Cortez uses FIFO. 18 19 (Use the cells from the given information to complete this question.) 20 Ending 21 FIFO Units Unit Cost Inventory 22 From second purchase 23 24 25 26 b1. Determine the amount of product costs that would be allocated to cost of goods sold, assuming that Cortez uses LIFO. 27 28 (Use the cells from the given information to complete this question.) 29 LIFO Cost of 30 LIFO Units Unit Cost Goods Sold 31 From first purchase 70 @ $68 $4,760 32 From second purchase 200 $72 $14,400 33 @ 34 Total 270 $19,160 35 36 b2. Determine the amount of product costs that would be allocated to ending inventory, assuming that Cortez uses LIFO. 37 38 Use the cells from the given information to contplete this question.) 39 Ending 40 Units Unit Cost Inventory 41 From first purchase 0 $68 $0 42 From beginning inventory 100 @ $60 $6,000 43 Total ending inventory $6,000 44 45 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. 46 47 (Use the cells from the given information to complete this question.) 48 49 50 Cost of goods sold 270 units $68 $18,360 51 Ending inventory units $68 $0 52 53 0