Given the following data what formulas would one use to complete the following excel sheet? Thanks!

Course Documents-MA \D Study Guide for Test-2-? D Chapter 6 Variable Castr x \ x X) px?-0.23600121166516752 1527375548713 ariable and Absorption Costing-Exce HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VEW Caibri B I- A Alignment NumberConditionel Formet as Cell Cells Editing Formatting TableStyles Styies A1 ? ?? ? | Addison, Inc. makes a single product, an indoor freoace. Data for last year is as v 1 Addison, Inc. makes a s oduct, an indoor firepace. Data for last year is as fallows: 3 Selling price per fireplace 4 Manufacturing costs: Variable per unit produced: 6 Direct materlals 135 $43 210,000 545 Direct labor Variable manufacturing overhead 9 Fixed manufacturing overhead per year 10 Selling and administrative expenses: 1 Variable per unit sold 12 Fixed per year 190,000 14 Units in beginning inventory 15 Units produced during the year 16 Units sold during the year 5,000 4,500 18 Use the cata to answer the following. 19 20 1. Assume the company uses variable costing: 22 Compute the unit product cost for one fireploce 24 Prepare a contribution margin income statement for the year Sheet1 |