Use Goal Seeking tool for this problem. Excel Homework Use Data > What-If Analysis > Goal Seek... 2009 2009 2009 Revenue Target Unit Sold Unit Cost Unit Price Revenue Costs of Good Sold Product A 3000 $40.00 $50.00 $150,000.00 $120,000.00 Product B 4500 $30.00 $45.00 $202,500.00 $135,000.00 Product C 2300 $25.00 $32.00 $73,600.00 $57,500.00 Total Revenue $426,100.00 Total COGS $312,500.00 Total Gross Profit $113,600.00 Unit Sold Original Product A target units sold is: 3,000 What will be the target units sold for Product A to achieve $150000 Total Gross Profit: What will be the target units sold for Product A to achieve $200000 Total Gross Profit