excel solver

  1. S

    Using Solver (trouble with constraints)

    I am having trouble setting up the constraints within Excel Solver, I am pretty green at using Solver with very limited knowledge other than a couple of YouTube videos showing the basics. Here the problem: There is a news channel that is trying to fit 4 segments within 20 mins with the lowest...
  2. T

    Excel Solver Diffucult Problem

    Hello, Fabrics are to be cut to certain sizes. Example; 24 pieces of 225 cm 32 pieces of 175 cm 88 pieces of 150 cm 24 pieces of 75 cm 32 pieces from 50 cm 80 pieces from 35 cm These require 304 meters of fabric. One ball of fabric is 6 meters. 51 balls of fabric is enough without any loss...
  3. A

    Applied Science Management

    I've been struggling with this question, I was able to solve part A, but I need the answer to part B using excel solver please Part A a. Formulate a linear programming model algebraically and determine the number of sheets to be bought and cleaned by laundry and friends. b. Solve the linear...
  4. S

    Excel Solver - Optimizing Profit - Constraint Problem - Micr Office voor Mac 2011

    I am trying to optimize the profit by area constraints in a store. A sort of Knapsack problem. The goal is to optimize the profit by placing department i within section j. 4 departments need to be located to 6 sections. The objective function is a sum of decision variable xij * profit for...
  5. S

    Excel Solver help

    Hello, So I've been trying to tackle this issue for way too long by now. My last resort is asking here for help: It's an optimization problem i need to solve with Excel Solver. I'm encountering my problems when i want to use IF statements but they don't work with solver and I don't know in...
  6. E

    Excel solver help

    i need help with using solver in the following situation i need use solver to find the number of each fan that will maximize profit within the available labour hours what is my set objective? what are my constraints? of course the labour required has to be smaller or equal to labour available...
    • excelnoob7
    • Thread
    • constraints excel solver maximize profit set objective solver
    • Replies: 1
    • Forum: Excel Questions
  7. K

    Excel Solver - Optimal Fantasy Football Lineup - "Solver could not find a feasible solution"

    I am working with the Excel Solver to find the optimal fantasy football roster (maximum projected points). The constraints are: - Salary Cap of $100,000 - Roster Constraints: - 1 QB - 2 to 4 WR - 2 to 4 WR - 1 to 3 TE - 1 Defense - Total roster size must be 10 I have set up the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top