AutoSave Off Copy of variable and absorption costing templatesp2020. Scarch File Home Insert Draw P age Layout Formulas Data Review View Developer Help Calibri 11 === General Part 1 A A A Wrap Text Merge & Center BIU $ & 498 % mber Conditional For Formatting To Clipboard Font Alignment 5 Sty! H53 - X X + fx BCDE 1 Miller Corporation produces and sells a single product, a wooden jewelry box. Cost and operating data are given below: $50 3 Selling price per unit 4 Manufacturing costs: 5 Variable (per unit): 6 DM 7 DL 8 Variable Manuf O/H 9 Fixed Manuf O/H per year $15 $2 $140,000 11 Selling and Admin costs: 12 Variable (per unit) 13 Fixed Selling and Admin expense per year $2 $80,000 Year 1 Year 2 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year 19 20 Absorption Costing: 20,000 16,000 4,000 28,000 32,000 21 22 Calculate Unit Product Cost: Year 1 Year 2 24 DM 25 DL 26 Variable Manuf o/H 27 Fixed Manuf O/H 28 Total Unit Product Cost 30 Absorption Costing Income Statements: Sheet1 @ Home Insert Draw Page Layout Formulas Data Review View Developer Help Calibri 2 Wrap Text General 11 . AA EEE A Paste BIU. EE E Merge & Center $ %68- Alignment Number Clipboard Font H53 : fi A 30 Absorption Costing Income Statements: 31 Year 1 Year 2 32 Sales 33 Cost of Goods Sold 34 Gross Profit 35 Selling and Admin Expense: 36 Variable Selling and Admin expense 37 Fixed Selling and Admin expense 38 Net Operating Income 39 Year 1 Year 2 40 Variable Costing: 41 42 Calculate Unit Product Cost: 43 44 DM 45 DL 46 Variable Manuf O/H 47 Total Unit Product Cost 48 49 Variable Costing Income Statements: 50 Year 1 Year 2 51 Sales 52 Variable expenses: 53 COGS 54 Variable Selling and Admin expense 55 Contribution Margin 56 Fixed expenses: 57 Fixed Manuf O/H 58 Fixed Selling and Admin expense 59 Net Operating Income Sheet1 - - - 1. Download and complete the spreadsheet found in the Variable and Absorption costing Spreadsheet Dropbox by inserting formulas or cell references in all cells highlighted yellow. Each cell that requires a formula or cell reference has a question mark in it. Originally, in Year 1, 20,000 units are produced, and 16,000 units are sold, and 28,000 units are produced in Year 2 and 32,000 units are sold. Since more units are produced in Year 2, the absorption unit product cost will decrease because you're spreading the fixed overhead over more units. So....when you calculate absorption COGS in Year 2, you will need to use the year 1 product cost for the older units you sold and the Year 2 product cost for the newer units you sold. The absorption costing net operating income should be $176,000 in Year 1 and $488,000 in Year 2 and the variable costing net operating income should be $148,000 in Year 1 and $516,000 in Year 2. 2. Check the accuracy of the formulas in your spreadsheet by changing the number of units produced in Year 2 to 17,500 (cell C17) and the number of units sold in Year 2 to 21,500 (cell C18). The absorption costing net operating income in Year 2 should now be $246,500 and the variable costing net operating income in Year 2 should be $274,500. Your Year 1 net operating incomes shouldn't change. If the new Year 2 net operating incomes don't calculate correctly, fix the errors in your spreadsheet before you submit it. NI PW