Monitor Industries, Inc., completed the following inventory transactions during the month of March: (Click the icon to view the transactions.) Read the requirements. Requirement 1. Without resorting to calculations, determine which inventory method will result in Monitor Industries, Inc., paying the lowest income taxes. In times of increasing inventory prices, as is the case here, the LIFO method will result in Monitor Industries, Inc., paying the lowest income taxes. Requirement 2. Prepare a perpetual inventory record using FIFO. 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 FIFO costing first. For inventory on hand, enter the oldest inventory layer first.) Purchases Cost of goods sold Inventory on hand i Data Table Total Unit Total Unit Cost Total Cost Unit Cost Date Qty Qty Cost Qty Cost Cost Mar 1 Date Item Quantity Unit Cost Mar 4 Mar es 80 $ 60 Mar 12 1 Balance 4 Purchase 12 Sale 22 Purchase 31 Sale 54 Mar 22L Mar 31 Print Done Total Requirement 3. Prepare a perpetual inventory record using LIFO. Requirement 3. Prepare a perpetual inventory record using LIFO. Start by entering the opening inventory balance. 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.) Purchases Cost of goods sold Inventory on hand Unit Total Cost Unit Cost | Total Cost Unit | Qty | Cost | Total Cost Date Qty | Cost Qty Mar Mar 1 40 Mar 12 Mar 22 Mar 31 Total Requirement 4. Prepare a perpetual inventory record using average cost. Round average cost per unit to the nearest cent and all other amounts to the nearest dollar. Start by entering the opening inventory balance. 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. (Round average cost per unit to the nearest cent and all other amounts to the nearest dollar.) Purchases ... Cost of goods sold ... ... Inventory on hand ... ... | ... Mar 12 Mar 220 Mar 31 Total Requirement 4. Prepare a perpetual inventory record using average cost. Round average cost per unit to the nearest cent and all other amounts to the nearest dollar. Start by entering the opening inventory balance. 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. (Round average cost per unit to the nearest cent and all other amounts to the nearest dollar.) Purchases Cost of goods sold Inventory on hand Unit Total Unit Unit Total Total Cost Date Qty | Cost Cost Qty Cost Qty Cost Cost Mar Mar 4 Mar Mar 12 L 220C Mar 3 Total
