Question: on excel #1. Set the initial field values to: Unit Cost: $6.00 If our goal is for the Contribution Margin Percent to be 54%, Invoke
on excel
#1. Set the initial field values to: Unit Cost: $6.00 If our goal is for the Contribution Margin Percent to be 54%, Invoke Goal Seek so as to figure out what the Sales Price (changing cell) is and the answer is $ #2. Set the initial field values to: Sales Price: $13.00 If our goal is for the Contribution Margin Percent to be 53%, Invoke Goal Seek so as to figure out what the Unit Cost must be (changing cell) and as a result, the automatically re-calculated Contribution Margin is $_ Excel: Goal Seek 2. 3 5 HW % 6 Unit Sales Price 7 Unit Production Cost $ $ 2.25 $ 1.10 8 9 Unit Gross Profit/Contribution Margin $ 1.15 51% 10

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
