Please answer the questions in an excel document using proper formulas as needed (simplistic). The problem occasionally says October but as the question is worded, March is meant. (When it says 15-oct under march sales it should be 15-mar)

ACC 317 / FA16 Excel #2 Addison Company sells two types of pumps. One is large and is for commercial use. The other is smaller and is used in residential swimming pools. The following inventory data is available for the month of March. . ACC 317 / FA16 Excel #2 Required: a. Assuming Addison uses a periodic inventory system, determine the cost of inventory on hand at March 31 and the cost of goods sold for March under first-in, first-out (FIFO). b. Assume Addison uses dollar-value LIFO and one pool, consisting of the combination of residential and commercial pumps. Determine the cost of inventory on hand at March 31 and the cost of goods sold for March. Assume Addison's initial adoption of LIFO is on March 1. Use the double-extension method to determine the appropriate price indices. (Hint: The price index for February 28/March 1 should be 1.000) (Round the index to three decimal places.) c. Assume you need to compute a current ratio for Addison's. Which inventory method (FIFO or dollar-value LIFO) do you think would give you a more meaningful current ratio? d. Some of Addison's competitors use LIFO inventory costing and some use FIFO. How can an analyst compare the results of companies in an industry, when some use LIFO and others use FIFO? e. Can companies change from one inventory accounting method to another? If a company changes to an inventory accounting method used by most of its competitors, what are the trade-offs in terms of the conceptual framework discussed in Chapter 2 of the textbook