Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I keep getting the wrong answer when using solver. Where have I gone wrong? I am trying to solve the second question! Home Insert Draw
I keep getting the wrong answer when using solver. Where have I gone wrong? I am trying to solve the second question!
Home Insert Draw Page Layout Formulas Data Review View Tell me 2 Analysis V ? v V Data An Get External Data Outline Data from Picture Refresh All Data Types Sort & Filter Data Tools What if Analysis ? Solver SUM fx =SUMPRODUCT(B7:07,B10:010) A B C D E F G H 1 J Time Constraint 600 300 200 401 Total Produce 1/3 Quantity Oo 1 2 Cabinet Style French Pro Danish American Hours Used 3 Carpentry 5 3 2. 580 4 Painting 3 1 2 300 5 Finishing 1 1 1 180 6 7 Q Produced 40 100 8 Q Constraint 40 40 40 9 10 Revenue/Prol 28 25 22 11 12 Total Revenu =SUMPRODUCT(B7:07,B10:D10) 13 14 15 16 17 18 19 20 SUM fx =B3*$B$7+C3*$C$7+D3*$D$7 A B D E F I J American 3 1 Hours Used Time Constraint 21 =B3*$B$7+C3*$C$7+D3*$D$7|| 2 300 300 1 180 200 1 1001 40 401 40 Total Produce 1/3 Quantity Oo 25 22 1 2 Cabinet Style French Pro Danish 3 Carpentry 5 4 Painting 3 5 Finishing 1 6 7 Q Produced 401 8 Q Constraint 40 9 10 Revenue/Pro 28 11 12 Total Revenu 4500 13 14 15 16 17 18 19 20 21 A B D E F G H American 3 1 Hours Used Time Constraint 2 580 600 2 300 300 1 180 200 1 100 40 40 40 Total Produce 1/3 Quantity 1 =G7/3 1 2 Cabinet Style French Pro Danish 3 Carpentry 5 4 Painting 3 5 Finishing 1 6 7 Q Produced 40 8 Q Constraint 40 9 10 Revenue/Pro 28 11 12 Total Revenu 4500 13 14 15 16 17 18 25 22 Home Insert Draw Page Layout Formulas Data Review View Tell me 2 Analysis V ? v V Data An Get External Data Outline Data from Picture Refresh All Data Types Sort & Filter Data Tools What if Analysis ? Solver SUM fx =SUMPRODUCT(B7:07,B10:010) A B C D E F G H 1 J Time Constraint 600 300 200 401 Total Produce 1/3 Quantity Oo 1 2 Cabinet Style French Pro Danish American Hours Used 3 Carpentry 5 3 2. 580 4 Painting 3 1 2 300 5 Finishing 1 1 1 180 6 7 Q Produced 40 100 8 Q Constraint 40 40 40 9 10 Revenue/Prol 28 25 22 11 12 Total Revenu =SUMPRODUCT(B7:07,B10:D10) 13 14 15 16 17 18 19 20 SUM fx =B3*$B$7+C3*$C$7+D3*$D$7 A B D E F I J American 3 1 Hours Used Time Constraint 21 =B3*$B$7+C3*$C$7+D3*$D$7|| 2 300 300 1 180 200 1 1001 40 401 40 Total Produce 1/3 Quantity Oo 25 22 1 2 Cabinet Style French Pro Danish 3 Carpentry 5 4 Painting 3 5 Finishing 1 6 7 Q Produced 401 8 Q Constraint 40 9 10 Revenue/Pro 28 11 12 Total Revenu 4500 13 14 15 16 17 18 19 20 21 A B D E F G H American 3 1 Hours Used Time Constraint 2 580 600 2 300 300 1 180 200 1 100 40 40 40 Total Produce 1/3 Quantity 1 =G7/3 1 2 Cabinet Style French Pro Danish 3 Carpentry 5 4 Painting 3 5 Finishing 1 6 7 Q Produced 40 8 Q Constraint 40 9 10 Revenue/Pro 28 11 12 Total Revenu 4500 13 14 15 16 17 18 25 22Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started