70.2K

Verified Solution

Link Copied!

no numbers, only forumlas for each individual cell. starting numbers in top right near directions (ex 100 is cell H2 , $72 is cell I4)

For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: = B3 + c3 A B D G H 1 1 100 WN 150 200 $60 $68 $72 270 2 Cortez Company sells chairs that are used at computer stations. Its beginning inventory of chairs was 100 units at $60 3 per unit. During the year, Cortez made two batch purchases of this chair. The first was a 150-unit purchase at $68 per 4 unit; the second was a 200-unit purchase at $72 per unit. During the period, it sold 270 chairs. 5 6 Required a1. Determine the amount of product costs that would be allocated to cost of goods sold, assuming that Cortez uses FIFO. 8 9. (Use the cells from the given information to complete this question.) 10 7 FIFO Units Unit Cost Cost of Goods Sold 12 13 From first purchase 14 From second purchase 15 Total 16 17 12. 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 Inventory FIFO Units Unit Cost 21 22 23 24 25 26 bl. Determine the amount of product costs that would be allocated to cost of goods sold, assuming that Cortez uses LIFO. 28 (Use the cells from the given information to complete this question.) 27 29 Cost of Goods Sold UFO Units Unit Cost 30 31 33 34 Total B F H 1 K A D E 25 G 26 bi. 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 Units Unit Cost Cost of Goods Sold 30 31 32 33 34 Total 35 36 b2. Determine the amount of product costs that would be allocated to ending Inventory, assuming that Cortez uses LIFO. 38 (Use the cells from the given information to complete this question.) 37 39 40 LIFO Ending Inventory Units Unit Cost 8 43 Total ending Inventory 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. 47 (Use the cells from the given information to complete this question.) nam 49 50 Cost of goods sold 51 Ending inventory units units

Answer & Explanation Solved by verified expert

See Answer