Question: 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

 Create the worksheet shown below. Use Goal Seek to solve You

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 to hit your target? % Contribution Contribution Product A $ 158,334 0.20 $31,667 Product B 243,960 0.25 60,990 Product C 0.15 Total $1,440,707 $1 $248,419 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!