Chapter 6: Applying Excel: Exercise (Algo) (Part 2 of 2) 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 st Selling price per unit 5 Manufacturing costs: 6 7 8 9 10 11 12 13 14 15 56 16 17 18 Variable per unit produced: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead per year Selling and administrative expenses: Variable per unit sold Fixed per year Units in beginning inventory Units produced during the year $ CA $ $ $ SA LA B 344 127 80 26 173,600 Year 1 5 79,000 0 3,100 C Year 2 2,800 4

2. Change all of the numbers in the data area of your worksheet so that it looks like this: 2. Change all of the numbers in the data area of your worksheet so that it looks like this