Question: Please show the formulas not just the amount. PROBLEM DATA The records of Anderjak Corporation contain the following information for the month of January Actual

Please show the formulas not just the amount. Please show the formulas not just the amount. PROBLEM DATA The recordsof Anderjak Corporation contain the following information for the month of JanuaryActual production in units Sales in units Sales price per unit Variable

PROBLEM DATA The records of Anderjak Corporation contain the following information for the month of January Actual production in units Sales in units Sales price per unit Variable manufacturing cost per unit Variable selling expense per unit Fixed manufacturing cost Fixed selling expenses 100,000 80,000 $30 $14 $2 $315,000 $100,000 The company has no beginning inventory. REQUIREMENT Open the file VARCOST from the website for this book at cengagebrain.com. Enter the formulas where indicated on the worksheet. Enter your name in cell A1. Save the completed file as VARCOST2. Print the worksheet when done. Also print your formulas. Check figure: Absorption income (cell C31), $768,000. FORMULA1 B 1 2 VARCOST 3 Variable Costing 4 5 Data Section 6 7 Actual production in units 100,000 8 Sales in units 80,000 9 Sales price per unit $30 10 Variable manufacturing costs per unit $14 11 Variable selling costs per unit $2 12 Fixed manufacturing costs $315,000 13 Fixed selling expenses $100,000 14 15 Answer Section 16 17 Income statement: Absorption costing 18 19 Sales 20 Cost of goods sold: 21 Variable manufacturing costs FORMULA2 22 Fixed manufacturing costs FORMULA3 23 Total goods available for sale $0 24 Less ending inventory FORMULA4 25 Cost of goods sold 26 Gross profit 27 Selling expenses: 28 Fixed selling expenses FORMULA5 29 Variable selling expenses FORMULA6 30 Total selling expenses 31 Operating income 32 33 34 Income statement: Variable costing 35 36 Sales 37 Cost of goods sold: 38 Variable manufacturing costs FORMULA7 39 Less ending inventory FORMULAS 0 $0 0 $0 $0 FORMULAS 0 $0 FORMULAS $0 39 Less ending inventory 40 Variable cost of goods sold 41 Manufacturing margin 42 Variable selling expenses 43 Contribution margin 44 Fixed costs: 45 Fixed manufacturing costs 46 Fixed selling expenses 47 Total fixed costs 48 Operating income FORMULA10 0 0 $0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!