i Data Table . Jul.5 Purchase 156 crates @ $64 each Jul. 13 Sale 180 crates @ $104 each Jul. 18 Purchase 114 crates @ $75 each Jul. 26 Sale 150 crates @ $112 each 7 Print Done TO GET Huise Inventory of 78 crates of vitamins that cost a total of $4,290. During the month, Exercise World purchased and sold merchandise on account as follows: B Click the icon to view the transactions) Read the requirements Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit Begin by computing the cost of goods sold and cost of ending merchandise inventory using the FIFO inventory costing method. 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 merchandise inventory purchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first.) Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Date Unit Quantity Total Cost Cost Quantity Cost Cost Quantity Jul. 1 Cost Cost Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost Jul. 1 5 13 Enter any number in the edit fields and then click Check Answer 13 18 26 Totals