Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

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 22

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Core Concepts Of Information Technology Auditing

Authors: James E Hunton, Stephanie M Bryant, Nancy A Bagranoff

1st Edition

ISBN: 0471222933, 9780471222934

More Books

Students also viewed these Accounting questions