A spreadsheet has 9 columns and 7 rows. Column 2 is titled ‘Date’ and lists dates in rows 2 to 6. Column 3 lists account names in rows 2 to 7, without a header. Columns 4 to 9 are titled ‘Units Purchased’, ‘Cost per Unit’, ‘Total Cost of Purchase’, ‘Units Sold’, ‘Selling Price per Unit’, and ‘Total Sales’ in row 1. Column 4 has numerical values in rows 2, 3, 5, and 7. Column 5 lists dollar amounts in rows 2, 3, and 5. Column 6 lists dollar amounts in rows 2, 3, 5, and 7. Column 7 lists numerical values in rows 4, 6, and 7. Column 8 lists dollar amounts in rows 4 and 6. Column 9 lists dollar amounts in rows 4, 6, and 7.
Assuming perpetual LIFO, which formula correctly calculates the cost of the 990 units sold on December 16?
Multiple Choice
=+G6*E2
=+D5*E5
=+G6*E5
=+G6*H6