I need help with all requirements please!

1 Variable Costing Using Excel for Variable Costing Tiger Mountain Gelato incurs the following costs for its premium ice cream in May 2024: Direct materials cost per pint is $4.75 per pint Direct labor cost per pint is $2.50 per pint Variable manufacturing overhead cost per pint is $1.50 per pint Fixed manufacturing overhead costs are $7,500 per month Total fixed selling and administrative costs are $6,500 per month Sales price per pint is $12.00 per pint Pints of gelato produced are 14,000 pints Pints of gelato sold are 13,500 pints There were no beginning inventories 16 Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. ALWAYS use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will 17 be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. 18 19 Requirements: 20 Calculate Tiger Mountain Gelato's product cost per pint under absorption costing and variable costing: 21 Calculate the balance in Finished Goods Inventory on May 31, 2024, using absorption costing and variable costing. 22 3. Prepare income statements in good form for Tiger Mountain Gelato for May 2024 using absorption costing and variable costing. 23 4 Reconcile the differences between operating incomes and Finished Goods Inventory balances between the two costing methods. Requirement 2 Calculate the balance in Finished Goods Inventory on May 31, 2024, using absorption costing and variable costing. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Enter all amounts as positive values, Do not use a minus sign or parentheses for any values.) copy/paste from the Instruction tab you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Prepare income statements in good form for Tiger Mountain Gelato for May 2018 using absorption costing and variable costing. Indent the descriptions for any subtotals using the Increase Indent button. Double underline operating income