can you please complete requirement 3 and 4

3.Prepare income statements in good form for tiger moutain gelato for may 2018 using absorption costing and variable costing.

4.Reconcile the differences between operating incomes and finsished goods inventory balances between the two costing methods.

there are hint and excel skills down below thank you!

Template rev22 - Protected View File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Becatel--files from the Internet can contain viruses. Unless you need to edit it's safe to stay in Protected Vio Search CARE 143 Enab 11 4 A D 1 Variable Costing E F G H 2 Using Excel for Variable Costing 3 4 Tiger Mountain Gelato incurs the following costs for its premium ice cream in May 2018: 5 6 Direct materials cost per pint is $3.75 per pint 7 Direct labor cost per pint is $1.50 per pint 8 Variable manufacturing overhead cost per pint is $0.50 per pint 9 Fixed manufacturing overhead costs are $6,500 per month 10 Total fixed selling and administrative costs are $5,500 per month Sales price per pint is $10.00 per pint 12 Pints of gelato produced are 13,000 pints 13 Pints of gelato sold are 12,500 pints 14 15 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 17 you will be marked wrong. Enter all amounts as positive values. Do not use a minus signor parentheses for any values 18 19 Requirements: 20 1 Calculate Tiger Mountain Gelato's product cost per pint under absorption costing and variable costing 21 2 Calculate the balance in Finished Goods Inventory on May 31, 2015, using absorption costing and variable costing 22 3 Prepare Income statements in good form for Tiger Mountain Gelato for May 2018 wing absorption costing and variable costing 23 4 Reconcile the differences between operating incomes and Finished Goods inventory balances between the two costing methods 24 25 Excel Skills: Instructions ENTERANSWERS ENTERANSWERS Type here to search BI Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful files from the Internet can contain vituses. Unless you need to edit it's safer to sta X f B D E DATA Tiger Mountain Gelato incurs the following costs for its premium ice cream in May 2018: Direct materials cost per pint per pint Direct labor cost per pint per pint Variable manufacturing overhead cost per pint per pint Fixed manufacturing overhead costs per month Total fixed selling and administrative costs Sales price per pint per pint Pints of gelato produced pints Pints of gelato sold pints per month There were no beginning inventories Requirement 1 Calculate Tiger Mountain Gelato's product cost per pint under 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.) Absorption Variable Costing Costing Instructions ENTERANSWERS ENTERANSWERS2 dy Type here to search o AutoSave CH Chapter 21 Excel Template rev22 - Protected View File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to sta N33 XV A B 16 17 D E Requirement 1 Calculate Tiger Mountain Gelato's product cost per pint under 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.) 18 19 Absorption Variable Costing Costing 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Requirement 2 Calculate the balance in Finished Goods Inventory on May 31, 2018, 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.) Beginning inventory in units Units produced Units available for sale Instruction ENTERANSWERS ENTERANSWERS Ready FE Type here to search M Chapter 21 Excel Template rev22 . Protected View - File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to N51 f A D E 33 34 35 36 37 38 B Units produced Units available for sale Units sold Ending Inventory in units Absorption Variable Costing Costing 39 40 41 42 43 Ending inventory in units Product cost per unit Balance in Finished Goods Inventory 45 46 HINTS Cell | Hint: B20:324 Use the selections in the drop-down menu to select the correct description. Follow 48 the order of DATA table. c20:023 | Use cell references to point to the correct unit or dollar amounts from DATA table 49 on this tab. Leave the appropriate cell(s) blank. Do not enter a zero for any zero amounts. 50 C24:024 Use the function =SUMI) to calculate the product cost per pint. C31:C35 Use cell references to point to the units produced and the units sold. Enter zero in si appriopriate cell(s) if there are no units in corresponding category. 52 C40:40 Use cell references to point to the correct product cost. 53 54 ristructions ENTERANSWERS ENTERANSWERS Ready Type here to search O BI oSave OM Chapter 21 Excel Template rev 22. Protected View Search Cat. Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Besarees from the internet can contains Unies you to edit attest in Protected Vi. Enable Editing 6 A D H C G Requirement 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. (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 signor parentheses Absorption Costing Variable Costing Requirement ENTELLANSWERS ENTERANSWERS Type here to search e utoSave Chapter 21 Excel Template re-22 - Protected View Search CAR. Home Insert Page Layout Formulas Review View Help PROTECTED VIEW Be care files from the Internet contains Unless you need to edit safe to stay in Pastected Vis Data Enablediting B D G H Requirement 4 Reconcile the differences between operating incomes and Finished Goods inventory balances between the two costing methods (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 alt amounts as positive values. Do not use a minus sign or parentheses for any values.) Absorption Costing Variable Costing Difference Operating Income Finished Goods Inventory HINTS 1. Use the selections in the drop-down menu to select the correct description 2. Use cell references to point to the correct unit or dollar amounts from ENTERANSWERS1 and ENTERANSWERS2 tabs. 3. All values should be entered as positive values. Cellini E29:30 | Use the ABs function (absolute Value) to calcutate the difference in Operating income and Fished Goods Inventory under ruchom ENTE ANSWERS ENTERANSWERS Type here to search o Template rev 22. Protected View - Search Area File Home Insert Page Layout Formulas Data Review View Help D PROTECTED VIEW Besacelul-files from the Internet con contain viruses Unless you need to edit it's safe to stay in Protected View 143 X f Enab 10 A B. C D 1 Variable Costing E F G H 2 Using Excel for Variable Costing 3 4 Tiger Mountain Gelato incurs the following costs for its premium ice cream in May 2018: 5 6 Direct materials cost per pint is $3.75 per pint 7 Direct labor cost per pint is $1.50 per pint 8 Variable manufacturing overhead cost per pint is $0.50 per pint 9 Fixed manufacturing overhead costs are $6,500 per month Total fixed selling and administrative costs are $5,500 per month 11 Sales price per pint is $10.00 per pint 12 Pints of gelato produced are 13,000 pints 13 Pints of gelato sold are 12.500 pints 14 15 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 17 you will be marked wrong. Enter all amounts as positive values. Do not use a minus signor parentheses for any values 19 Requirements: 20 1 Calculate Tiger Mountain Gelato's product cost per pint under absorption costing and variable costing 21 2 Calculate the balance in Finished Goods Inventory on May 11, 2012, using absorption costing and variable costing 22 Prepare income statements in good form for Tiger Mountain Gelato for May 2015 using absorption costing and variable costing 23 4 Reconcile the differences between operating income and finished Goods inventory balances between the two costing methods 24 25 Excel Skills: Instructions ENTERANSVERSE ENTERANSWERS 1 10 Type here to search o