Question 1 Part 2 1) Calculate the Profit after Tax by subtracting both taxes: Income Tax and Shipping Tax from Profit. 2) In cell C18, calculate the Total Profit for the West region only. 3) Use goal seek to determine the number of units needed to reach $670 profit for the Quad product. Unit s Cost Price Profit Region Product Unit Revenu after Tax Ille Date SalesRep 8/31/13 Christy Olson 11/27/14 Dan Peterson 11/7/13 Mable Lindsey 6/2/14 Kyle Carr West Doublers MidWest Sunshine West Crested Beaut MidWest Quad 6 6 6 6 Total Total 7 Profit Cost 10 $50.00 $300.00 $60.00 $240.00 15 $29.00 $174.00 $90.00 $84.00 12 $66.00 $396.00 $72.00 $324.00 17 $91.00 $546.00 $102.00 $444.00 Income Tax Shipping Tax 16% 5% Total Profit in West