1- Using variable costing, compute unit product cost, breakeven, and prepare an income statement.

2- Using absorption costing, compute unit product cost, and prepare an income statement.

How do i solve the cells in excel?

Variable and Absorption Costing Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calculate Now Function Defined Form Calculation EA Calculate Sheet ula Options Library Names Auditing Calculation C26 1 Addison Inc. makes a single product, a indoor fireplace. Data for last yea is as follows n 3 Selling price per fireplace $420 4 Manufacturing costs: 5 Variable per unit produced: $135 6 Direct materials $43 Direct labor $37 8 Variable manufacturing overhead 9 Fixed manufacturing overhead per year $210,000 10 Selling and administrative expenses: $45 11 Variable per unit sold 12 Fixed per year $190,000 13 14 Units in beginning inventory is Units produced during the year 5,000 16 Units sold during the year 4,500 18 Use the data to answer the following. 19 20 1.Assume the company uses variable costing: 21 22 Compute the unit product cost for one fireplace 15 23 24 Prepare a contribution margin income statement for the year 25 26 27 variable expenses: 28 Variable cost of goods sold 29 Variable selling and administrative expenses 30 Contribution margin 31 Fixed expenses: 32 d manufacturing overhead Sheet1 BEE Attempt(s) 9/10 Sign In 10% Hint