The selling price per unit is $38

Please help me to solve this problem step by step in excel, especially the steps for number 3-5, thank you so much.

Week 8 Task 10.1 The following information pertains to Chain Co for last year: Beginning inventory in units 5.000 units Units produced 60.000 units Units sold 38.500 units Costs per unit: Direct materials $8,75 Direct labor costs $3,85 Variable overhead cost $2,45 Total overhead costs per year $76.000 Normal capacity for the year 40.000 units Variable selling expenses per unit Variable general and administrative per unit $2 Fixed selling expense total $225.000 Fixed general and administrative expenses total $168.000 The unit fixed overhead is based on 40.000 units produced, which is normal capacity. Corporate income tax rate is 25% flat. Instructions: 1. Prepare income statements under absorption costing 2. Prepare income statements under variable costing 3. Prepare a schedule to show reconciliation the difference operating income between absorption costing and variable costing. 4. Compute ending inventory per unit under absorption costing 5. Compute ending inventory per unit under variable costing