1. Download and complete the spreadsheet found in the Variable and Absorption Costing Spreadsheet Dropbox by inserting either formulas or cell references in all of the cells highlighted yellow. Each cell that requires a formula or cell reference has a question mark in it. Originally the fixed manufacturing overhead in cell D9 is $480,000. The absorption costing net operating income should be $1,423,000 and the variable costing net operating income should be $1,391,000. 2. Check the accuracy of the formulas in your spreadsheet by changing the amount of fixed manufacturing overhead in cell D9 from $480,000 to $540,000. This should cause both of your net operating incomes to change. The absorption costing net operating income should now be $1,367,000 and the variable costing net operating income should now be $1,331,000. If the net operating incomes don't recalculate correctly, fix the errors in your spreadsheet before you submit it. You can submit either version because I will change the amount in cell D9 to check that your net operating incomes recalculate correctly. 3. Please let me know if you have any questions and upload your completed spreadsheet to the Dropbox. Battle Company produces and sells a single product, a wooden lawnchair. Costs and operating data are given below: $ 90.00 Selling price per lawnchair Manufacturing costs: Variable (per lawnchair): DM DL Variable Manuf/H Fixed Manuf O/H per year $ $ $ $ 26.00 14.00 10.00 480,000.00 1 Selling and Administrative expenses: 2 Variable (per lawnchair) Fixed Selling and Admin expense per year $ $ 4.00 145,000.00 60,000 56,000 lawnchairs produced during the year 5 lawnchairs sold during the year 7 3 Absorption Costing: Calculate Unit Product Cost: 1 2 DM 3 DL Variable Manuf/H 5 Fixed Manuf O/H 6 Total Unit Product Cost ? ? ? ? ? 7 3 Absorption Costing Income Statement: Sales 1 Cost of Goods Sold ? ? ? 2 Gross Profit 3 Selling and Admin Expense: 2 Variable Selling and Admin expense Fixed Selling and Admin expense 5 Net Operating Income ? ? ? ? ? ? ? ? ? ? 23 DL 24 Variable Manuf O/H 25 Fixed Manuf o/H 26 Total Unit Product Cost 27 28 Absorption Costing Income Statement: 29 30 Sales 31 Cost of Goods Sold 32 Gross Profit 33 Selling and Admin Expense: 34 Variable Selling and Admin expense 35 Fixed Selling and Admin expense 36 Net Operating Income 37 38 Variable Costing: 39 40 Calculate Unit Product Cost: 41 42 DM 43 DL -44 Variable Manuf o/H 45 Total Unit Product Cost ? ? ? ? ? ? ? ? 46 47 Variable Costing Income Statement: 48 49 Sales 50 Variable expenses: 51 COGS 52 Variable Selling and Admin expense 53 Contribution Margin 54 Fixed expenses: 55 Fixed Manuf O/H 56 Fixed Selling and Admin expense 57 Net Operating Income ? ? ? ? ? ? 58 1. Download and complete the spreadsheet found in the Variable and Absorption Costing Spreadsheet Dropbox by inserting either formulas or cell references in all of the cells highlighted yellow. Each cell that requires a formula or cell reference has a question mark in it. Originally the fixed manufacturing overhead in cell D9 is $480,000. The absorption costing net operating income should be $1,423,000 and the variable costing net operating income should be $1,391,000. 2. Check the accuracy of the formulas in your spreadsheet by changing the amount of fixed manufacturing overhead in cell D9 from $480,000 to $540,000. This should cause both of your net operating incomes to change. The absorption costing net operating income should now be $1,367,000 and the variable costing net operating income should now be $1,331,000. If the net operating incomes don't recalculate correctly, fix the errors in your spreadsheet before you submit it. You can submit either version because I will change the amount in cell D9 to check that your net operating incomes recalculate correctly. 3. Please let me know if you have any questions and upload your completed spreadsheet to the Dropbox. Battle Company produces and sells a single product, a wooden lawnchair. Costs and operating data are given below: $ 90.00 Selling price per lawnchair Manufacturing costs: Variable (per lawnchair): DM DL Variable Manuf/H Fixed Manuf O/H per year $ $ $ $ 26.00 14.00 10.00 480,000.00 1 Selling and Administrative expenses: 2 Variable (per lawnchair) Fixed Selling and Admin expense per year $ $ 4.00 145,000.00 60,000 56,000 lawnchairs produced during the year 5 lawnchairs sold during the year 7 3 Absorption Costing: Calculate Unit Product Cost: 1 2 DM 3 DL Variable Manuf/H 5 Fixed Manuf O/H 6 Total Unit Product Cost ? ? ? ? ? 7 3 Absorption Costing Income Statement: Sales 1 Cost of Goods Sold ? ? ? 2 Gross Profit 3 Selling and Admin Expense: 2 Variable Selling and Admin expense Fixed Selling and Admin expense 5 Net Operating Income ? ? ? ? ? ? ? ? ? ? 23 DL 24 Variable Manuf O/H 25 Fixed Manuf o/H 26 Total Unit Product Cost 27 28 Absorption Costing Income Statement: 29 30 Sales 31 Cost of Goods Sold 32 Gross Profit 33 Selling and Admin Expense: 34 Variable Selling and Admin expense 35 Fixed Selling and Admin expense 36 Net Operating Income 37 38 Variable Costing: 39 40 Calculate Unit Product Cost: 41 42 DM 43 DL -44 Variable Manuf o/H 45 Total Unit Product Cost ? ? ? ? ? ? ? ? 46 47 Variable Costing Income Statement: 48 49 Sales 50 Variable expenses: 51 COGS 52 Variable Selling and Admin expense 53 Contribution Margin 54 Fixed expenses: 55 Fixed Manuf O/H 56 Fixed Selling and Admin expense 57 Net Operating Income ? ? ? ? ? ? 58