PLEASE SOLVE THIS IN EXCEL FORMAT

Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions. (For specific identification, units sold consist of 600 units from beginning inventory, 300 from the February 10 purchase, 200 from the March 13 purchase, 50 from the August 21 purchase, and 250 from the September 5 purchase.) Required 1. Compute cost of goods available for sale and the number of units available for sale. 2. Compute the number of units in ending inventory. 3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. (Round all amounts to cents.) 4. Compute gross profit earned by the company for each of the four costing methods in part 3 . Analysis Component 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