Help with req. 3 please

on R Us began Augnt win 55 unts of ron montory tat cost $35 each Durng Augu the company completed the following iwentory transactors: Cick the icon to view the transactions) Read the reairements Requirement 1. Prepare a perpetual inventory record for the merchandise inventory using the FiFO inventory costing method Start by entering the beginning inventory Ibalances. Enter the transactions in chronological order calculating mew inventory on hand balances after each transaction Once all of the transactions have been entered into the perpetual record, calculate the quanity and total cost of merchandise inventory punchased, sold, and o hand at the end of the period. (Enter the oldest inventory layers irst u cost Date Cost CostQuantity Cost Cost Quantity Cost 55 35 1925 45 35 1,575 10 35 350 75 S 52 3,900 75 S 5 3.900 10 35$ 350 60 52 3,120 21 15 5525 780 15 52 780 10 55 550 85 115 Requirement 2. Prepare a perpetual inventory record for the merchandise inventory using the LIFO inventory costing method Start by entering the beginning invetory balances. Enter the transactions in chronological order calculating new inventory on hand balances after each ransaction. Once all of the transacsons have been entered into the perpetual record, calculate the quansty and total cost of merchandse inventory purchased, sold and on hand at the end of the period. (Enter the oidest inventory layers int Inventory on Hand Units Total CostCost Quantity Cost Cost Quantity Cost Cos 55 $ 35 ,25 10 $ 35 350 10 35 350 75$ 52 3,900 10 35 350 5 $ 52 260 10 35 350 5 $ 52 260 10 55 550 45 35 1,575 75 S52$ 3.900 21 70 52 3840 10 S $5$ 550 85 115 Requirement 3 Prepare a perpetual inventory record for the merchandise inventory using the weighted-average inventory coting method Start by entering the beginning inverdory balances Enter the transactions in chronological orde calculating new invertory on hand balances afler each transaction Once all of the transacions have been entered into the perpetual record, calculate the quantty and total cost of merchandse inventory purchased, sold, and on hand at the end of the period on Hand Date Quantity CostCostQuantity Cost Cost Quantity CostCost 45 $ 35 1,575 75 $ 52 3.900 10 5 55 $550 85 115