Question

I need to use the cell references to get my answers

DATA Tiger Mountain Gelato incurs the following costs for its premium ice cream in May 2018: Direct materials cost per pint $ 2.50 per pint Direct labor cost per pint 0.75 per pint Variable manufacturing overhead cost per pint 0.25 per pint Fixed manufacturing overhead costs 6,000 per month Total fixed selling and administrative costs 5,000 per month Sales price per pint 8.00 per pint Pints of gelato produced 12,00 Paste Pints of gelato sold 11,500 pints There were no beginning inventories, so Tiger Mountain Gelato has 500 pintsin ending Finished Goods Inventory (12,000 pints produced less 11,500 pints sold). 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 Costing Variable Costing Requirement 2

Answer 1

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!

Tiger Mountain Gelato:
Please note that selling and admin costs are not a part of product costs.
Fixed manufacturing overhead will be part of product cost under absorption costing so I am calculating Fixed manufacturing overhead per pint.
Fixed manufacturing overhead	6,000.00
Total units produced	12,000.00
Fixed manufacturing overhead per pint	0.50
Product costs per pint	Absorption	Variable
Direct Materials	2.50	2.50
Direct Labor	0.75	0.75
Variable manufacturing overhead per pint	0.25	0.25
Fixed manufacturing overhead per pint	0.50	-
Product costs per pint	$        4.00	$      3.50