Excel Solver not solving problem, keeps spitting out an error.

Problem_1 (2) (1).xlsx



The product portfolio problem asks which products a firm should be making. If there are contracts that obligate the firm to enter certain markets, then the question is which products to make in quantities beyond the required minimum. Consider Grocery Distributors (GD), a company that distributes 15 different vegetables to grocery stores. GD’s vegetables come in standard cardboard cartons that each take up 1.4 cubic feet in the warehouse.

The company replenishes its supply of frozen foods at the start of each week and rarely has any inventory remaining at week’s end. An entire week’s supply of frozen vegetables arrives each Monday morning at the warehouse, which can hold up to 20,000 cubic feet of product. In addition, GD’s supplier extends a line of credit amounting to $33,000. That is, GD is permitted to purchase up to $33,000 worth of product each Monday. GD can predict sales for each of the 15 products for the coming week. This forecast is expressed in terms of a minimum and maximum level of sales. The minimum quantity is based on a contractual agreement that GD has made with a few retail grocery chains; the maximum quantity represents an estimate of the sales potential in the upcoming week. The unit cost and unit selling price for each product are known.

How many cartons of each product should GD order at the start of the week to maximise its profit?


this is the problem data I am trying to solve with excel solver. simpler problems work with it but it just refuses to work with this one. I know the constraints and everything but it theres some sort of conflict, can anyone help?

regards

Microsoft® Excel® for Microsoft 365 MSO (Version 2309 Build 16.0.16827.20130) 32-bit is the version.


I am using the solver however when I click solve, an error appears saying variable bounds conflict in binary or alldifferent constraint.

I have tried the 3 different solving methods that are available to me. what could be going wrong?

by all different / binary constraint, does the program mean an actual constraint, with "bin" or "dif"? i have none of those.

genuinely dont know where im going wrong. could you test to see if your solver runs and works on this file? this is a completed version of another problem with different constraints. it tells me the lower and upper bounds on variables allow no feasible solution for this one...

Product_Portfolio_Problem.xlsx.xlsx

Problem_1 (2).xlsx


Tinkered with it. Managed to get a solution through deleting the credit constraint. What could be causing it?

SOLVED!

downloaded opensolver, immediately let me know that the $33,000 value is meant to be numeric. changed it to 33,000, and have got a result.

Thank you all for input!