Complete the following questions using excel. Print and attach two documents to this sheet, the solution and an excel formula page for each question. 1. The following information is taken from the inventory records of the Lynbrook Company: 8,000 units @ $20.00 Beginning inventory, 4/1 Purchases: 4/5 4/26 Sales: 4/11 4/28 4,000 units @ $23.50 8,000 units @ $25.00 5,000 units 9,000 units 6,000 units were on hand at the end of April. Required: A. Assuming that Lynbrook uses a periodic inventory system and employs the average cost method, determine cost of goods sold for April and April's ending inventory. B. Repeat requirement A assuming that the company uses a perpetual inventory system. 2. On January 1, 2021, the Lynbrook Company adopted the dollar-value LIFO method for its one inventory pool. The pool's value on this date was $900,000. The 2021, 2022, and 2023 ending inventory valued at year-end costs were $950,000, $975,000, and 1,200,000 respectively. The appropriate cost indexes are 1.03 for 2021, 1.04 for 2022, and 1.08 for 2023. Required: Calculate the inventory value at the end of 2021, 2022, and 2023 using the dollar-value LIFO method