PLease provide the answer in Excel format and proivde the funtions used !

Lynch Company manufactures and sells a single product. The following costs were incurred during the company's first year of operations: During the year, the company produced 25,000 units and sold 20,000 units. The selling price of the company's product is $50 per unit. Required: 1. Assume that the company uses absorption costing: a. Compute the unit product cost. b. Prepare an income statement for the year. 2. Assume that the company uses variable costing: a. Compute the unit product cost. b. Prepare an income statement for the year