Create the worksheet shown below. Use Goal Seek to solve. You have data on how much of product A and B has been sold. How much gross revenue do you need from Product C to hit your target? % Contribution Contribution Product A $158,334 0.20 $31,667 Product B 243,960 0.25 60,990 Product C Total 0.15 $1,440,707 $1 Your first target total in the contribution column is $155,762. NOTE: All cells in column D and row 11 must contain formulas The value result for Product C (cell B10) is $248,419