Suppose in the Dorian production model that no minimum production limits are placed on the individual vehicle types. However, minimum production limits are placed on all cars and on all minivans. Specifically, if Dorian produces any cars, regardless of size, it must produce at least 1500 cars total. Similarly, if the company produces any minivans, it must produce at least 1000 minivans total. Modify the model appropriately and use Solver to find the optimal solution.
Suppose in the Dorian production model that no minimum production limits are placed on the individual vehicle types. However, minimum production limits are placed on all cars and on all minivans. Specifically, if Dorian produces any cars, regardless of size, it must produce at least 1500 cars total. Similarly, if the company produces any minivans, it must produce at least 1000 minivans total. Modify the model appropriately and use Solver to find the optimal solution.
For the condition that Dorian should create in any event 1500 vehicles in entirety, think about the subtleties of the creation on work hours, benefit commitment, and steel accessible of the manufacturing, at Dorian Auto.
Now introduce produce at any rate least in the thirteenth line as a choice variable for contributions as given in the case of assembling at Dorian Auto and give zero (0) as the load for each info and exactly the same thing rehash for the seventeenth column for example for units created. The screen captures appear below,
Now, use all the other inputs and formulas as given:
Now, in cell H17 calculate the total number of cars produced by Dorian using the SUM( ) function.
All the inputs have been done. Now, declare the cell H17 with greater than or equal to 1500 constraint and delete the constraint of minimum production which was given in the Dorian Auto example.
After adding constraints to the AddConstraints window, we get the Solver Parameters window to Delete the old constraint.
Step by step
Solved in 4 steps with 19 images