Chapter 6 Excel Works for Managerial Accounting:

How do you do solve and do the excel work for this question?

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. Variable and Absorption Costing-Excel FILE HOME NSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW B I u EE A Alignment Number Conditional Format as Cel Cells Editing Paste Formatting Table Styles Clipboard Font Styles C22 1 Addison, Inc. makes a single product, an indoor fireplace. Data for last year is as follows: S420 3 Selling price per fireplace 4 Manufacturing costs s Variable per unit produced: $135 6 Direct materials $43 7 Direct labor 8 Variable manufacturing overhead $37 $210,000 9 Fixed manufacturing overhead per year 10 Selling and administrative expenses: $45 11 Variable per unit sold 12 Fixed per year $190,000 14 Units in beginning inventory 15 Units produced during the year 5,000 16 Units sold during the year 4,500 18 Use the data to answer the following. 20 1. Assume the company uses variable costing: 21 22 Compute the unit product cost for one freplace 23 24 Prepare a contribution margin income statement for the year Sign In