D 2,000,000 130 17,500,000 250,000 5 6 Below is price and costs information for aftermarket headlights sold by an auto parts manufacturer. 7 Fixed costs s 8 Selling price per unit s 9 Total variable costs $ 10 Hof units produced 11 12 13 6. What is total cost per unit? Calculate in cell B13. (2 points) 14 15 16 7. What is variable cost per unit? Calculate in cell B16. (2 points) 17 TI 18 8. Using variable cost calculated in Q7, what is contribution margin (%)? 19 Calculate in cell B19. 3 points) 20 21 22 9. What number of units must be sold to break even? Calculate in cell B22. (2 points) 23 24 25 10. A Google Ads campaign is being considered to grow online parts sales. The proposal is to set a daily budget of S60 26 for a 21-day campaign. You have been asked to determine how many units of product must be sold to pay for the 27 proposed AdWords campaign. What is the break-even point in units for this proposed marketing investment? Calculate 28 in cell B30 (3 points) 29 30 31 32 Break-even (W) for Marketing Investment 33 11. The auto parts manufacturer is hoping to make a profit of $8,250,000. How many total units does the auto parts 34 manufacturer need to sell to achieve this profit goal? Calculate in cell B37. (3 points) 35 36 37 Target unit sales (9)