Need help with this, please show equations used and excel. Thank you!

PROBLEM 6-20 Variable and Absorption Costing Unit Product Costs and Income Statements; Explana tion of Difference in Net Operating Income LO6-1, L06-2, L06-3 High Country, Inc., produces and sells many recreational products. The company has just opened a new plant to produce a folding camp cot that will be marketed throughout the United States. The following cost and revenue data relate to May, the first month of the plant's operation: Beginning inventory .......... Units produced Units sold ......... Selling price per unit..... 10,000 8,000 $75 $200,000 Selling and administrative expenses: Variable per unit... Fixed (per month)... Manufacturing costs: Direct materials cost per unit ....... Direct labor cost per unit ..... Variable manufacturing overhead cost per unit .... Fixed manufacturing overhead cost (per month)............ $20 $100,000 Management is anxious to assess the profitability of the new camp cot during the month of May. Required: 1. Assume that the company uses absorption costing. a. Determine the unit product cost. b. Prepare an income statement for May. 2. Assume that the company uses variable costing a. Determine the unit product cost. b. Prepare a contribution format income statement for May. 3. Explain the reason for any difference in the ending inventory balances under the two costing methods and the impact of this difference on reported net operating income