Variable and Absorption Costing - Excel Spelling Research Thesaurus Proofing Translate Language PAGE LAYOUT New Comment Delete Previous Next Comments Sign In Show/Hide Comment Show All Comments Show Ink VIEW REVIEW FORMULAS DATA INSERT Next Show Ink Comments A1 fx Addison, Inc. makes a single product, an indoor fireplace. Data for last year is as \begin{tabular}{|c|c|c|c|c|c|c|} \hline 2 & A & B & C & D & E & F \\ \hline 9 & Fixed manufacturing overhead per year & $210,000 & & & & \\ \hline 10 & Selling and administrative expenses: & & & & & \\ \hline 11 & Variable per unit sold & $45 & & & & \\ \hline 12 & Fixed per year & $190,000 & & & & \\ \hline 13 & & & & & & \\ \hline 14 & Units in beginning inventory & 0 & & & & \\ \hline 15 & Units produced during the year & 5,000 & & & & \\ \hline 16 & Units sold during the year & 4,500 & & & & \\ \hline 17 & & & & & & \\ \hline 18 & Use the data to answer the following. & & & & & \\ \hline 19 & & & & & & \\ \hline 20 & 1. Assume the company uses variable costing: & & & & & \\ \hline 21 & & & & & & \\ \hline 22 & Compute the unit product cost for one fireplace & & & & & \\ \hline 23 & & & & & & \\ \hline 24 & Prepare a contribution margin income statement fo & & & & & \\ \hline 25 & & & & & & \\ \hline 26 & Sales & & & & & \\ \hline 27 & Variable expenses: & & & & & \\ \hline 28 & Variable cost of goods sold & & & & & \\ \hline 29 & Variable selling and administrative expenses & & & & & \\ \hline 30 & Contribution margin & & & & & \\ \hline 31 & Fixed expenses: & & & & & \\ \hline 32 & Fixed manufacturing overhead & & & & & \\ \hline 33 & Fixed selling and administrative expenses & & & & & \\ \hline 34 & Net operating income & & & & & \\ \hline 35 & & & & & & \\ \hline 36 & Compute the number of fireplaces required to break & & & & & \\ \hline 37 & & & & & & \\ \hline 38 & 2. Assume the company uses absorption costing: & & & & & \\ \hline 39 & & & & & & \\ \hline 40 & Compute the unit product cost for one fireplace & & & & & \\ \hline \end{tabular} Use the data to answer the following. 1. Assume the company uses variable costing: Compute the unit product cost for one fireplace Prepare a contribution margin income statement for the year Sales Variable expenses: Variable cost of goods sold Variable selling and administrative expenses Contribution margin Fixed expenses: Fixed manufacturing overhead Fixed selling and administrative expenses Net operating income Compute the number of fireplaces required to breakeven 2. Assume the company uses absorption costing: Compute the unit product cost for one fireplace Prepare an income statement for the year Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating income Variable and Absorption Costing - Excel Spelling Research Thesaurus Proofing Translate Language PAGE LAYOUT New Comment Delete Previous Next Comments Sign In Show/Hide Comment Show All Comments Show Ink VIEW REVIEW FORMULAS DATA INSERT Next Show Ink Comments A1 fx Addison, Inc. makes a single product, an indoor fireplace. Data for last year is as \begin{tabular}{|c|c|c|c|c|c|c|} \hline 2 & A & B & C & D & E & F \\ \hline 9 & Fixed manufacturing overhead per year & $210,000 & & & & \\ \hline 10 & Selling and administrative expenses: & & & & & \\ \hline 11 & Variable per unit sold & $45 & & & & \\ \hline 12 & Fixed per year & $190,000 & & & & \\ \hline 13 & & & & & & \\ \hline 14 & Units in beginning inventory & 0 & & & & \\ \hline 15 & Units produced during the year & 5,000 & & & & \\ \hline 16 & Units sold during the year & 4,500 & & & & \\ \hline 17 & & & & & & \\ \hline 18 & Use the data to answer the following. & & & & & \\ \hline 19 & & & & & & \\ \hline 20 & 1. Assume the company uses variable costing: & & & & & \\ \hline 21 & & & & & & \\ \hline 22 & Compute the unit product cost for one fireplace & & & & & \\ \hline 23 & & & & & & \\ \hline 24 & Prepare a contribution margin income statement fo & & & & & \\ \hline 25 & & & & & & \\ \hline 26 & Sales & & & & & \\ \hline 27 & Variable expenses: & & & & & \\ \hline 28 & Variable cost of goods sold & & & & & \\ \hline 29 & Variable selling and administrative expenses & & & & & \\ \hline 30 & Contribution margin & & & & & \\ \hline 31 & Fixed expenses: & & & & & \\ \hline 32 & Fixed manufacturing overhead & & & & & \\ \hline 33 & Fixed selling and administrative expenses & & & & & \\ \hline 34 & Net operating income & & & & & \\ \hline 35 & & & & & & \\ \hline 36 & Compute the number of fireplaces required to break & & & & & \\ \hline 37 & & & & & & \\ \hline 38 & 2. Assume the company uses absorption costing: & & & & & \\ \hline 39 & & & & & & \\ \hline 40 & Compute the unit product cost for one fireplace & & & & & \\ \hline \end{tabular} Use the data to answer the following. 1. Assume the company uses variable costing: Compute the unit product cost for one fireplace Prepare a contribution margin income statement for the year Sales Variable expenses: Variable cost of goods sold Variable selling and administrative expenses Contribution margin Fixed expenses: Fixed manufacturing overhead Fixed selling and administrative expenses Net operating income Compute the number of fireplaces required to breakeven 2. Assume the company uses absorption costing: Compute the unit product cost for one fireplace Prepare an income statement for the year Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating income