Perpetual Inventory Using LIFO

Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows:

Inventory		Purchases		Sales
May 1	1,300 units at $40	May 10	650 units at $42	May 12	910 units
		20	585 units at $44	14	780 units
				31	390 units

Question Content Area

a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

Date	Quantity Purchased	Purchases Unit Cost	Purchases Total Cost	Quantity Sold	Cost of Merchandise Sold Unit Cost	Cost of Merchandise Sold Total Cost	Inventory Quantity	Inventory Unit Cost	Inventory Total Cost
May 1							fill in the blank a73845f59f8bff0_1	$fill in the blank a73845f59f8bff0_2	$fill in the blank a73845f59f8bff0_3
May 10	fill in the blank a73845f59f8bff0_4	$fill in the blank a73845f59f8bff0_5	$fill in the blank a73845f59f8bff0_6				fill in the blank a73845f59f8bff0_7	fill in the blank a73845f59f8bff0_8	fill in the blank a73845f59f8bff0_9
							fill in the blank a73845f59f8bff0_10	fill in the blank a73845f59f8bff0_11	fill in the blank a73845f59f8bff0_12
May 12				fill in the blank a73845f59f8bff0_13	$fill in the blank a73845f59f8bff0_14	$fill in the blank a73845f59f8bff0_15	fill in the blank a73845f59f8bff0_16	fill in the blank a73845f59f8bff0_17	fill in the blank a73845f59f8bff0_18
				fill in the blank a73845f59f8bff0_19	fill in the blank a73845f59f8bff0_20	fill in the blank a73845f59f8bff0_21
May 14				fill in the blank a73845f59f8bff0_22	fill in the blank a73845f59f8bff0_23	fill in the blank a73845f59f8bff0_24	fill in the blank a73845f59f8bff0_25	fill in the blank a73845f59f8bff0_26	fill in the blank a73845f59f8bff0_27
May 20	fill in the blank a73845f59f8bff0_28	fill in the blank a73845f59f8bff0_29	fill in the blank a73845f59f8bff0_30				fill in the blank a73845f59f8bff0_31	fill in the blank a73845f59f8bff0_32	fill in the blank a73845f59f8bff0_33
							fill in the blank a73845f59f8bff0_34	fill in the blank a73845f59f8bff0_35	fill in the blank a73845f59f8bff0_36
May 31				fill in the blank a73845f59f8bff0_37	fill in the blank a73845f59f8bff0_38	fill in the blank a73845f59f8bff0_39	fill in the blank a73845f59f8bff0_40	fill in the blank a73845f59f8bff0_41	fill in the blank a73845f59f8bff0_42
							fill in the blank a73845f59f8bff0_43	fill in the blank a73845f59f8bff0_44	fill in the blank a73845f59f8bff0_45
May 31	Balances					$fill in the blank a73845f59f8bff0_46			$fill in the blank a73845f59f8bff0_47

Question Content Area

b. Based upon the preceding data, would you expect the inventory to be higher or lower using the first-in, first-out method?