When do people use Solver(in excel) in their work field on a daily basis? Is it...

When do people use Solver(in excel) in their work field on a daily basis? Is it an important function?

Solutions

Expert Solution

Solver is used for optimization purpose. In a work field it is used in the following cases:

1. If you want to get an optimum value (maximum or minimum) of a dependent function, given the constraints.

2. If you have lesser equation and more variables and you need an optimum solution, the hit and trial for all possible combination of values for the variables is done by solver.

3. If logistics problems, suppose you want to check for the optimized route, solver does that.

4. If you want to check what possible mixture of ingredient provides the best possible output, given the constraint, solver is the best solution.

Yes it is an importnat function. Solver does all the possible hit and trials with all the possible values that is being defined by the constraints, to provide an optimal solution. Ideally this may take hours or days long for a human to go through all the possible combination of data for the variables to reach the result. Solver does that in seconds.

keosha answered 7 months ago

Next > < Previous

Related Solutions

Do your work in an Excel file. Make Excel do the test statistic calculation.!!!!!!!!! Do people...

Do your work in an Excel file. Make Excel do the test statistic calculation.!!!!!!!!! Do people generally receive the asking price when they sell their home? The accompanying table lists the asking price and sale price for a random sample of ten single-family home sales in Tahlequah, OK. Home Asking price Selling price 1 98,000 94,300 2 122,500 119,800 3 109,900 105,000 4 98,000 100,000 5 79,900 77,000 6 275,000 265,000 7 99,700 96,000 8 97,900 99,200 9 209,000 209,000...

We deal with people on a daily basis, especially at work. Now, how would you respond...

We deal with people on a daily basis, especially at work. Now, how would you respond to someone who is extremely negative or extremely positive? Furthermore, can perception of someone be used to effect attitude? (Yes/No is not an answer. You need to elaborate).

Create an excel workbook for the following questions. Answer these questions under your Solver work for...

Create an excel workbook for the following questions. Answer these questions under your Solver work for each respective problem. 1. Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers can smoke, suites that are non-smoking, budget rooms where the customers can smoke, and budget rooms that are non-smoking. When we build the hotel, we need to plan for how many rooms of each type we should have. The following are requirements for the...

Show your work with Excel and Solver: A city in Ohio is considering replacing its fleet...

Show your work with Excel and Solver: A city in Ohio is considering replacing its fleet of gasoline powered cars with electric cars. The manufacturer of the electric cars claims that this municipality will experience significant cost savings over the life of the fleet if it chooses to pursue this conversion. If the manufacturer is correct, the city will save about $1.5 million. If the new technology employed within the electric cars is faulty as some critics suggest, it will...

Use the Excel Solver to answer the following questions. The owners of the appliance store want...

Use the Excel Solver to answer the following questions. The owners of the appliance store want to spend up to $250,000 on buying new stock. They need to buy at least 100 of each appliance. The prices of buying appliances and the profits derived from selling them are shown in the following table, along with the floor area the devices require when stacked in the warehouse. Appliance Price Profit Area (m2) Clothes dryer $200 $21 1.2 Coffee machine $300 $28...

Show your work with Excel and Solver: Pizza King (PK) and Noble Greek (NG) are competitive...

Show your work with Excel and Solver: Pizza King (PK) and Noble Greek (NG) are competitive pizza chains. PK believes there is a 30% chance that NG will charge $8 per pizza, a 50% that NG will charge $10 per pizza, and a 20% chance that NG will charge $12 per pizza. If PK charges price p1 and NG charges price p2, PK will sell 100 + 25(p2 – p1) pizzas. It costs PK $6 to make a pizza. PK...

Create a model and use Excel Solver to answer the following: A computer company manufactures two...

Create a model and use Excel Solver to answer the following: A computer company manufactures two types of computers. Each type of computer will require assembly time, inspection time, and storage space. The amounts of each of these resources that can be devoted to the production of the computers is limited. The manager wants to determine the quantity of each computer to produce to maximize the profit generated by sales of these computers. In order to develop a suitable model...

Please show me how to do this with Excel QM, not Solver. Astro Winter LLC makes...

Please show me how to do this with Excel QM, not Solver. Astro Winter LLC makes snowplowing equipment. The company buys the engines from a 3rd party vendor – Marshall Engines. Astro Winter has the following production schedule for February, March, April, and May: February – 60; March – 85; April 100; May – 120. Marshall Engines makes and delivers the products to Astro Winter during the month the engines are due. Marshall Engines can only manufacture 40 engines in...

use Excel Solver to answer the following question.You must provide sufficient evidence that you did the...

use Excel Solver to answer the following question.You must provide sufficient evidence that you did the work on your own. For example, what equations did you use in your model? How was the excel spread sheet laid out? A student at a local university has just completed a decision modeling course. On her assignments, she has earned a 86 on the mid-term, a 94 on the final, a 93 on problem sets, and 85 for participation. She has a unique...

When a charged particle moves in an electric field, the field performs work on the particle....

When a charged particle moves in an electric field, the field performs work on the particle. Thus, the energy of the field decreases, turning into kinetic energy of the particle. Does the magnetic field of a permanent magnetic similarly lose energy and perform work when moving a conductor with a current?

Subjects