$1-$ net operating income for year $1$ and $2$ under absorption costing?

$2-$net operating income for year $1$ and $2$ under variable costing?

Transcribed Image Text:

2. Change all of the numbers in the data area of your worksheet so that it looks like this A 1 Chapter 6: Applying Excel 2 3 Data 4 Selling price per unit 5 Manufacturing costs: B C $ 277 6 7 8 00 9 Variable per unit produced: Direct materials Direct labor Variable manufacturing overhead EA $ 121 $ 51 10 Fixed manufacturing overhead per year 69999 $ 31 $ 91,200 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year $ 2 $ 39,000 14 15 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year Year 1 Year 2 0 2,400 1,900 2,100 2,100 2. Change all of the numbers in the data area of your worksheet so that it looks like this A 1 Chapter 6: Applying Excel 2 3 Data 4 Selling price per unit 5 Manufacturing costs: B C $ 277 6 7 8 00 9 Variable per unit produced: Direct materials Direct labor Variable manufacturing overhead EA $ 121 $ 51 10 Fixed manufacturing overhead per year 69999 $ 31 $ 91,200 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year $ 2 $ 39,000 14 15 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year Year 1 Year 2 0 2,400 1,900 2,100 2,100