please help this is very complicated, thank you very much

what do you mean? i sent you everything dummy

here just help me with this

the table i have in requirement 3 is wrong, please help me fix it, and if possible do the remaining requirements 4 and 5 (1 and 2 are finished already)

ih. During August, the company completed the following entory msacions - X Requirements cl sel ye 20 nit 1. Prepare a perpetual inventory record for the merchandise inventory using the FIFO inventory costing method. 2. Prepare a perpetual inventory record for the merchandise inventory using the LIFO inventory costing method. 3. Prepare a perpetual inventory record for the merchandise inventory using the weighted average inventory costing method. 4. Determine the company's cost of goods sold for August using FIFO, LIFO, and weighted average inventory costing methods. 5. Compute gross profit for August using FIFO, LIFO, and weighted-average inventory costing methods. 6. If the business wanted to maximize gross profit, which method would it select? os Print Done swer. e following inventory transactions: - X 1 Data Table W pns ha Units Unit Cost Unit Sales Price 45 $ 83 Aug. 3 Sale 75 $ 52 8 Purchase 85 70 21 Sale 10 55 30 Purchase Print Done Requirement 1. Prepare a perpetual inventory record for the merchandise inventory using the FIFO 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 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 Unit Total Date Quantity Cost Cost Quantity Cost Cost Cost Cost Aug 1 55 3 8 21 Purchases Cost of Goods Sold Unit Total Unit Total Inventory on Hand Unit Total Quantity Cost Cost 55 Date Quantity Cost Cost Quantity Cost Cost Aug. 1 3 8 21 30 Totals E6-20 (similar to) Assume that Whitewall Tire Store completed the following perpetual inventory transactions for a line of tires (Click the icon to view the transactions) Read the requirements Requirement 1. Compute cost doods sold and gross profit using the FIFO inventory costing method 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 reach 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 the destino Layers first Purchases Cost of Goods Sold Inventory on Hand Unit Total Total Total Date Quantity Com Cost Quality Cost Cost Quantity Cost Cost Jul 1 24 615 1466 11 65 765 2015 6115 164 615 76 458 165 615 B15 976 23 6115 138 6S 765 wentory transactions for a line of tires: 79 i More Info - an pel gical order, calc Id, and on hand pod 24 tires @ $ 61 each Jul. 1 Beginning merchandise inventory 11 Purchase 76 each mit ost 23 Sale 82 each 6 tires @ $ 16 tires @ $ 14 tires @ $ 17 tires @ $ 86 each 26 Purchase 29 Sale 82 each Print Done swer Clear All th * -X Requirements cal or nd PL . and 1. 00 Unit 2. 3 . Cos Compute cost of goods sold and gross profit using the FIFO inventory costing method Compute cost of goods sold and gross profit using the LIFO inventory costing method Compute cost of goods sold and gross profit using the weighted-average inventory costing method. (Round weighted-average cost per unit to the nearest cent and all other amounts to the nearest dollar) Which method results in the largest gross profit, and why? 4. Print Done nswer. ead the requirements 0 . YOU 231 6 $ 76 $ 456 26 488 145 86 $ 1,204 8 $ 61 $ 6 $ 76 $ 456 14$ 86 $ 1,204 8 $ 61 $ 29 488 11$ 946 865 6 $ 456 765 86 35 258 $ 946 $ 2.178 Totals 20 $ 1660 33 11 Compute gross profit using the FIFO inventory costing method. Gross profit is $ 528 using the FIFO inventory costing method, Enter any number in the edit fields and then click Check Answer 2. parts remaining Clear All core: 0 73 of 1 pt 3 of 8 (7 complete) HW Score: 61 34%, 6 13 of 1 Question Help E6-20 (similar to) Assume that well The Store completed the following perpetual inventory transactions for a line offres Click the icon to view the transactions) Read the Requirement 2. Compute cent of goods sold and gross profit using the LIFO inventory cotting method Begin by computing the cost of goods sold and cost of ending merchandise Inventory using the LIFO inventory costing method Enter the transactions in chronological order, calculating new inventory on hand balances ator each tamation 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 Purchases Total Cost of Goods Sold Uk Total Cost Com Cost Quantity Cost Cow Inventory on Hand Total Col 245 615 245 611414 55 761 165 61 M 11 75 23 518 75 511 510 wch ead the requirements 854 26 145 865 1204 14 5 145 11 $ 615 86 5 1.204 671 615 29 145 35 86 $ 1.206 61 S 183 52 453 5 671 5 1660 11 33 20 Totals Compute gross profit using the UFO wwentory costing method Gross profis 253 using the UFO inventory costing method Requirement 3. Compute cost of goods sold and gross prof using the weighted average inventory conting method (Round weighted wage cost per un to the nearest cent and all the amounts to the nearest dollar) Begin by computing the cost of goods sold and cost of ending merchandise Inventory using the weighted average 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 assume that Whitewall Tire Store completed the following perpetual inventory transactions for a line of tires Click the icon to view the transactions) Read the requirements Requirement 3. Compute cost of goods sold and gross profit using the weighted average inventory costing method (Round weighted average cost per unit to the nearest cant and all other mounts to the nearest dotor) Begin by computing the cost of goods sold and cost of ending merchandise inventory using the weighted average 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, old, and on hand at the end of the period Purchases Cost of Goods Sold Inventory on Hand Ut Total Unit Total Un Total Date Quantity Col Cosi Quantity Com Col Cost Cost 61 456 24 6 76 6 76 14 1024 64 596 1 23 14 4 06 1200 825 20 29 1275 2299 325 1660 11 20 33 Totals