please do requirement 1 -2

1.calculate Tiger Mountain Gelato's product cost per pint under absorption costing and variable costing.

2.Calculate the balance in Finshed Goods Inventory on May 31,2018, using absorption costing and variable costing.

(there are hints down below as well

Template rex22 - Protected View Search (AR) File Home Insert Page Layout Formulas Data Review View Help D PROTECTED VIEW Pecatelul-files from the Internet can contain viruses Unless you need to edit it's safe to stay in Protected View 143 x fo Enab 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 10 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 minus ir parentheses for any values 18 19 Requirements: 20 1 Calculate Tiger Mountain Gelato's product cost per pint under absorption costing and variable costing 2 Calculate the balance in Finished Goods Inventory on May 11, 2013, using absorption costing and variable costing 22 3 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 incomes and Finished Goods inventory balance between the two costing methods 24 25 Excel Skills: Instructions ENTERANSWERS ENTERANSWERS Type here to search o O 2 File Home Insert Page Layout Formulas Data Review PROTECTED VIEW Be careful_files from the Internet can contain viruses. Unless your 017 X B 9 D 8 Variable manufacturing overhead cost per pint is $0.50 per pint Fixed manufacturing overhead costs are $6,500 per month 10 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 or 17 you will be marked wrong. Enter all amounts as positive values. Do not use an 18 19 Requirements: 20 1 Calculate Tiger Mountain Gelato's product cost per pint under absorption 21 2 Calculate the balance in Finished Goods Inventory on May 31, 2018, using 22 3 Prepare income statements in good form for Tiger Mountain Gelato for 23 4 Reconcile the differences between operating incomes and Finished Goo 24 25 Excel Skills: 26 1 Use data validation to select descriptions. 27 2 Create formulas with cell references. 28 3 Format the cells appropriately for dollars, numbers, or units. 29 4 Use the ABS function (absolute value) in a formula. 30 37 32 Savina & Submitting Chapter Excel Assianments Instructions ENTERANSWERS ENTERANSWERS 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