Chapter 4 Question 1

Please explain how to set this up in excel to calculate easily

Required information [The following information applies to the questions displayed below.] O'Brien Company manufactures and sells one product. The following information pertains to each of the company's first three years of operations: During its first year of operations, O'Brien produced 93,000 units and sold 72,000 units. During its second year of operations, it produced 76,000 units and sold 92,000 units. In its third year, O'Brien produced 84,000 units and sold 79,000 units. The selling price of the company's product is $73 per unit. Required: 1. Assume the company uses variable costing and a FIFO inventory flow assumption (FIFO means first-in first-out. In other words, it assumes that the oldest units in inventory are sold first): a. Compute the unit product cost for Year 1, Year 2, and Year 3. b. Prepare an income statement for Year 1, Year 2, and Year 3. Complete this question by entering your answers in the tabs below. Compute the unit product cost for Year 1, Year 2, and Year 3. Prepare an income statement for Year 1, Year 2, and Year 3. Required information [The following information applies to the questions displayed below.] O'Brien Company manufactures and sells one product. The following information pertains to each of the company's first three years of operations: During its first year of operations, O'Brien produced 93,000 units and sold 72,000 units. During its second year of operations, it produced 76,000 units and sold 92,000 units. In its third year, O'Brien produced 84,000 units and sold 79,000 units. The selling price of the company's product is $73 per unit. Required: 1. Assume the company uses variable costing and a FIFO inventory flow assumption (FIFO means first-in first-out. In other words, it assumes that the oldest units in inventory are sold first): a. Compute the unit product cost for Year 1, Year 2, and Year 3. b. Prepare an income statement for Year 1, Year 2, and Year 3. Complete this question by entering your answers in the tabs below. Compute the unit product cost for Year 1, Year 2, and Year 3. Prepare an income statement for Year 1, Year 2, and Year 3