Please Help, the names may be different

Function: Formula: Multiply, Subtract, Add, Divide; Cell Referencing BE8.10- Using Excel to Prepare an Absorption-Costing Income Statement and Student Work Area Reconcillation Required: Provide input into cells shaded in yellow in this template. Use mathematical PROBLEM During 2020, Rafael Corp. produced the same number of units it sold. The accountant for Rafael Corp. uses normal costing and uses the budgeted volume to allocate the fixed overhead rate. The company provided the following information a. Prepare an absorption-costing income statement. concerning its production and sales during 2020. b. Reconcile the difference between the net income under variable costing and the net income under absorption costing. That is, show a calculation that explains what causes the difference in net income between the two approaches. Variable costing operating income before tax Plus: ' Fixed manufacturing overhead costs Absorption costing operating income