I just need help with the weighted average table and the questions that follow! i also attached pictures of my FIFO, LIFO, and specific identification table to help with number 4 & 5.

Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units sold at Retail January 1 Beginning inventory 560 units @ $55 per unit February 10 Purchase 440 units @ $52 per unit March 13 Purchase 140 units @ $40 per unit March 15 Sales 710 units @ $85 per unit August 21 Purchase 180 units @ $60 per unit September 5 Purchase 540 units @ $57 per unit September 10 Sales 720 units @ $85 per unit Totals 1,860 units 1,430 units Required: 1. Compute cost of goods available for sale and the number of units available for sale. $ Cost of goods available for sale Number of units available for sale 100,860 1,860 units 2. Compute the number of units in ending Inventory. 430 units Ending inventory Perpetual FIFO Perpetual LIFO Weighted Average Specific id Compute the cost assigned to ending inventory using weighted average. (Round your average cost per unit to 2 decimal places.) Weighted Average Perpetual: Goods Purchased Cost of Goods Sold Inventory Balance Dato # of units Cost per # of units Cost per Inventory unit Cost per Cost of Goods Sold unit #of units unit Balance January 1 560 a $55.00 - $ 30,800.00 sold February 10 Average February 10 March 13 Average March 13 March 15 August 21 Average August 21 September 5 Average September 5 September 10 Totals $ 0.00 4. Compute gross profit earned by the company for each of the four costing methods. (Round your average cost per unit to 2 decimal places.) FIFO LIFO Weighted Average Specific Identification Sales Less: Cost of goods sold Gross profit $ os 0$ 0 $ 0 5. The company's manager earns a bonus based on a percent of gross profit. Which method of inventory costing produces the highest bonus for the manager? Weighted Average LIFO Specific Identification FIFO Date Goods Purchased # of units unit Perpetual FIFO: Cost of Goods Sold # of units Cost per cost of Goods Sold sold Cost per unit Inventory Balance Cost per Inventory # of units unit Balance 560 at $ 55.00 = $ 30,800.00 January 1 440 at $ 52.00 February 10 Total February 10 140 at $ 40.00 March 13 Total March 13 March 15 5601 at 1501 at 0 at $ 55.00 $ 52.00 $ 40.00 $ 30,800.00 7,800.00 0.00 $ 38,600.00 Total March 15 180 at $ 60.00 August 21 + 560 at $ 55.00 = $ 30,800.00 4401 at $ 52.00 = 22,880.00 $ 53,680.00 560 at $ 55.00 = $ 30,800.00 440 at $ 52.00 - 22,880.00 140 at $40.00 - 5,600.00 $ 59,280.00 at $ 55.00 = 290 at $ 52.00 = 15,080.00 140 at $ 40.00 5,600.00 $ 20,680.00 o at $55.00 $ 0.00 290) at $ 52.00 - 15,080.00 140 at $40.00 = 5,600.00 180 at $60.00 10,800.00 $31.480.00 at $ 55,00 - $ 0.00 290) at $ 52.00 15,080.00 140 at $ 40.00 5,600.00 180 at $ 60.00 = 10,800.00 540 at $ 57.00 30,780.00 $ 62,260.00 o at $ 55.00 - $ 0.00 o at $ 52.00 0.00 Olot $ 40.00 ol at $ 60.00 0.00 4301 at $57.00 24,510.00 $ 24, 510.00 Total August 21 540 at $57.00 September Total September 5 September 10 o at 2901 at 140 at 180 at 110 at $ 55.00 $ 52.00 $ 40.00 $ 60.00 $57.00 0.00 - $ 15,000.00 5,600.00 10,800.00 6,270.00 $ 37,750.00 $ 76,350.00 Total September 10 Totals $ 24,510.00