Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hardware, Inc., completed the following inventory transactions during the month of March: (Click the icon to view the transactions.) Read the requirements. Requirement 2. Prepare
Hardware, Inc., completed the following inventory transactions during the month of March: (Click the icon to view the transactions.) Read the requirements. 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.) Data Table Purchases Cost of goods sold Inventory on hand Unit Unit Unit Total Total Cost Total Cost Qty Cost Cost | Qty Cost Cost Date Item Quantity Unit Cost Date Mar Mar 4 1 25 60 1500 Mar 30 58 1740 1500 WIN 58 1740 1 Balance 4 Purchase 12 Sale 22 Purchase 31 Sale Mar 12 1500 Mar 220 Print Done Mar 31 Total 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.) 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 Unit Total Cost Cost of goods sold Unit Total Qty Cost Cost Inventory on hand Unit Total Qty Cost Cost Qty Cost Date Mar Mar 1 4 Mar 12 Mar 22L 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.) 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 Inventory on hand Total Cost of goods sold Unit Total Qty Cost Cost Unit Cost Total Unit Cost Qty Cost Qty Cost Date Mar 1 Mar 41 Mar 12 Mar 22 Mar 31 Total
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started