constraint problem

Hello! I want to create this model in Excel to find the optimal solution with 2 constraints (Labor Hours and Material Available pr. week), below you will see the description and the solution in AMPL. For my own learning in other courses, I wish to make this in Excel using Solver. "Packing can...

Hi, I just watched the solver video which gives a basic introduction on how to use it and I would like some advice is solver can perform in the following scenario Each year 25 customers are distributed between the 5 staff members based on a workload ability Next the staff pick and equal or...

Hi, I'm trying to do a workbook to find a maximum probability with some one constraint. It doesnt find any feasible solution but I do not find any problem with my workbook. Does anyone have a clue of how it could work? I am trying to find max value of cell D15 with help of editing cell H2:J14...

I frequently, inadvertently, hit the right scroll slider and my spreadsheet shoots out of sight and I find myself way down on row 200 or greater, depending on where my cursor hit the scroll bar. This is the range of my spreadsheet A1:M26. How do I constrain it, so it doesn't flying off the...

Here's the scenario: You have 1,2,3,...N tasks to do sequentially, all which take a range of time to complete (column constraint), but you're only allowed to set aside a certain amount of time on each of M days (row constraint) to complete these tasks. Example: You have a 5 chapter book to...

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...