create account

How to use Solver in Excel by theexcelclub

View this thread on: hive.blogpeakd.comecency.com
· @theexcelclub ·
$9.60
How to use Solver in Excel
[![Thumbnail](https://images.dlive.io/d1658b12-76fa-11e8-9118-0242ac110002)](https://dlive.io/video/theexcelclub/f0062930-76f9-11e8-827c-49f76fdbeab3)

What is Solver in Excel?
Solver in Excel is part of the What if functions that are available. Itโ€™s an add in that you must turn on. Solverโ€™s basic purpose is to find a solution that satisfies all the constraints and return the optimal result.

In order for Solver to work properly, the worksheet must be set up in a specific way. Most importantly, you must have a solid understanding of the problem that you are trying to solve!

Solver in Excel Example
The example in the video below is for a business that assembles and sells furniture. This business currently sells two types of dining chairs.  One made from maple and another from mahogany. While the maple chair is of lower quality, it is easier to manufacture and sell. The mahogany chair, is of a much better quality.  But the price is much higher and it is more time intensive to produce.

From examining the worksheet, you can see that it takes three hours of rough carpentry to assemble the maple chair.  While the mahogany chair takes four hours. After the chair has been assembled, it takes two hours of finish work to get the mahogany chair to showroom standards. It only takes one hour with the maple chair:

The problem that you need to solve is to figure out how many of each type of chair can be constructed to maximize weekly total revenue for the company. And  what the maximum total revenue will be.

What complicates this problem is that the business employs one part-time finish carpenter who is only available for a total of 30 hours per week. The two rough carpenters employed by the company are full-time employees who are available for a combined total of 80 hours a week. In addition, the lumber yard that supplies the company can only provide enough mahogany for up to 10 chairs a week. All these factors are constraints

In the video we will look at turning on Solver in Excel. Then we will work through the example above.

This video is part of  #learnandearn -Learn from the post then engage with it on the Steemit Blockchain and the best comments, questions and tips left will be rewarded with upvotes.  Comments that are not relevant and do not add value will not be voted on

My video is at [DLive](https://dlive.io/video/theexcelclub/f0062930-76f9-11e8-827c-49f76fdbeab3)
๐Ÿ‘  , , , , , , , , , , , , , , , , , , , ,
properties (23)
authortheexcelclub
permlinkf0062930-76f9-11e8-827c-49f76fdbeab3
categorydlive
json_metadata"{"tags":["dlive","dlive-video","learning","Excel","Excel Solver","theexcelclub","video","learning","learnandearn"],"app":"dlive/0.1","format":"markdown","language":"en","thumbnail":"https://images.dlive.io/d1658b12-76fa-11e8-9118-0242ac110002","ipfsHash":"QmX4nF1pmTMtTNwW3xY4XRBmGpTc6bVpUHoNNrHaVnhp2T"}"
created2018-06-23 15:33:48
last_update2018-06-23 15:33:48
depth0
children6
last_payout2018-06-30 15:33:48
cashout_time1969-12-31 23:59:59
total_payout_value7.255 HBD
curator_payout_value2.347 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2,408
author_reputation49,417,421,433,400
root_title"How to use Solver in Excel"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id61,925,921
net_rshares4,800,026,013,852
author_curate_reward""
vote details (21)
@a-0-1 ·
https://steemit.com/free/@bible.com/4qcr2i
properties (22)
authora-0-1
permlinkre-theexcelclub-f0062930-76f9-11e8-827c-49f76fdbeab3-20180623t153422852z
categorydlive
json_metadata{"tags":["dlive"],"links":["https://steemit.com/free/@bible.com/4qcr2i"],"app":"steemit/0.1"}
created2018-06-23 15:34:21
last_update2018-06-23 15:34:21
depth1
children0
last_payout2018-06-30 15:34:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length42
author_reputation-1,593,356,047,755
root_title"How to use Solver in Excel"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id61,925,994
net_rshares0
@cheetah ·
Hi! I am a robot. I just upvoted you! I found similar content that readers might be interested in:
http://theexcelclub.com/use-solver-excel/
properties (22)
authorcheetah
permlinkcheetah-re-theexcelclubf0062930-76f9-11e8-827c-49f76fdbeab3
categorydlive
json_metadata""
created2018-06-23 15:34:12
last_update2018-06-23 15:34:12
depth1
children1
last_payout2018-06-30 15:34:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length140
author_reputation942,693,160,055,713
root_title"How to use Solver in Excel"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id61,925,971
net_rshares0
@paulag ·
this is my content - I am trying to move my brand to steemit, thanks for the upvote!
properties (22)
authorpaulag
permlinkre-cheetah-cheetah-re-theexcelclubf0062930-76f9-11e8-827c-49f76fdbeab3-20180623t160146730z
categorydlive
json_metadata{"tags":["dlive"],"app":"steemit/0.1"}
created2018-06-23 16:01:45
last_update2018-06-23 16:01:45
depth2
children0
last_payout2018-06-30 16:01:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length84
author_reputation274,264,287,951,003
root_title"How to use Solver in Excel"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id61,929,020
net_rshares0
@guiltyparties ·
$0.02
!cheetah whitelist
๐Ÿ‘  
properties (23)
authorguiltyparties
permlinkre-theexcelclub-f0062930-76f9-11e8-827c-49f76fdbeab3-20180623t171409713z
categorydlive
json_metadata{"tags":["dlive"],"app":"steemit/0.1"}
created2018-06-23 17:13:21
last_update2018-06-23 17:13:21
depth1
children1
last_payout2018-06-30 17:13:21
cashout_time1969-12-31 23:59:59
total_payout_value0.016 HBD
curator_payout_value0.005 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length18
author_reputation261,203,126,670,124
root_title"How to use Solver in Excel"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id61,936,937
net_rshares11,034,724,359
author_curate_reward""
vote details (1)
@cheetah ·
Okay, I have whitelisted @theexcelclub. I won't bug them.
properties (22)
authorcheetah
permlinkcheetah-re-guiltypartiesre-theexcelclub-f0062930-76f9-11e8-827c-49f76fdbeab3-20180623t171409713z
categorydlive
json_metadata""
created2018-06-23 17:13:24
last_update2018-06-23 17:13:24
depth2
children0
last_payout2018-06-30 17:13:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length57
author_reputation942,693,160,055,713
root_title"How to use Solver in Excel"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id61,936,947
net_rshares0
@theexcelclub ·
$0.09
To take part in #learnandearn on this excel video please go to this link to leave your comment, questions, feedback or tips

https://steemit.com/dlive/@theexcelclub/f0062930-76f9-11e8-827c-49f76fdbeab3
๐Ÿ‘  
properties (23)
authortheexcelclub
permlink6939e1b0-76fb-11e8-b73b-d1bcc7516684
categorydlive
json_metadata{"tags":["dlive"],"app":"dlive/0.1"}
created2018-06-23 15:38:00
last_update2018-06-23 15:38:00
depth1
children0
last_payout2018-06-30 15:38:00
cashout_time1969-12-31 23:59:59
total_payout_value0.074 HBD
curator_payout_value0.017 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length201
author_reputation49,417,421,433,400
root_title"How to use Solver in Excel"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id61,926,443
net_rshares47,291,675,827
author_curate_reward""
vote details (1)