Shepherd Cycles started July with 12 bicycles that cost $42 each. On July 16, Shepherd bought 40 bicycles at $68 each. On July 31, Shepherd sold 27 bicycles for $99 each. Requirements 1. Prepare Shepherd Cycle's perpetual inventory record assuming the company uses the LIFO inventory costing method. 2. Journalize the July 16 purchase of merchandise inventory on account and the July 31 sale of merchandise inventory on account. Requirement 1. Prepare Shepherd Cycle's perpetual inventory record assuming the company uses the LIFO inventory costing method. Start by entering the beginning inventory balances. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of inventory purchased, sold, and on hand at the end of the period. (For cost of goods sold, enter the first layer out under LIFO costing first. For inventory on hand, enter the oldest inventory layer first. Abbreviation used: QTY = Quantity; Tot. = - Total) Shepherd Cycles Purchases Cost of Goods Sold Inventory on Hand Date QTY Unit Cost Tot. Cost QTY Unit Cost Tot. Cost QTY Unit Cost Tot. Cost Jul. 1 IAL CH