Solver Solve a. Enter the data into the worksheet and give the initial values. These initial values ​​do not affect the calculation process. Since the Solver macro needs to iteratively calculate the solution of the planning equation, the cell cannot be a space and must satisfy the constraint of xj>0.
b. Select the Solver command from the Tools menu, open the Solver dialog box, and make the action in the dialog box.
c. Set up the solved packaging process plan through the Solver Results dialog box.
The results are as follows: x1=34, x2=7.5, C=298.
Packaging product output: 1st 200 units, 2nd 1065 units.
Resource utilization in the packaging process:
The first type of 96.3 units, the second type of 54 units, the third type of 81 units, and the first and third types of resources have not yet been fully utilized.
3. The dual problem of packaging process selection adds some symbols to the packaging process selection model: us is the valuation of s resources; uk is the valuation of k packaging products.
Finding the estimates us and uk maximizes the objective function.
The dual problem of packaging process selection is as follows:
F=200v1+600v2-97u1-54u2-100u3→max
5v1+30v2-2.5u1-1.5u2-1.5u3≤7; 4v1+6v2-1.5u1-0.4u2-4u3≤8; where v1≥0, v2≥0; u1≥0; u2≥0; u3≥0
Solver can also be solved with:
V1=2.3; v2=0; u1=0, u2=3; u3=0.
Explain that the 1st and 3rd resources have not been fully utilized and can be adapted to the revised plan to make it better.
4. Conclusions The use of the packaging technology in this paper to select touch type and use Microsoft Excel 5.0 for Windows software can make such problems easily resolved and bring direct economic benefits to packaging companies.
b. Select the Solver command from the Tools menu, open the Solver dialog box, and make the action in the dialog box.
c. Set up the solved packaging process plan through the Solver Results dialog box.
The results are as follows: x1=34, x2=7.5, C=298.
Packaging product output: 1st 200 units, 2nd 1065 units.
Resource utilization in the packaging process:
The first type of 96.3 units, the second type of 54 units, the third type of 81 units, and the first and third types of resources have not yet been fully utilized.
3. The dual problem of packaging process selection adds some symbols to the packaging process selection model: us is the valuation of s resources; uk is the valuation of k packaging products.
Finding the estimates us and uk maximizes the objective function.
To meet the conditions:
Assuming that each packaging process only packs one product, differential costs can be derived from the dual problems selected from the packaging process.
The dual problem of packaging process selection is as follows:
F=200v1+600v2-97u1-54u2-100u3→max
5v1+30v2-2.5u1-1.5u2-1.5u3≤7; 4v1+6v2-1.5u1-0.4u2-4u3≤8; where v1≥0, v2≥0; u1≥0; u2≥0; u3≥0
Solver can also be solved with:
V1=2.3; v2=0; u1=0, u2=3; u3=0.
Explain that the 1st and 3rd resources have not been fully utilized and can be adapted to the revised plan to make it better.
4. Conclusions The use of the packaging technology in this paper to select touch type and use Microsoft Excel 5.0 for Windows software can make such problems easily resolved and bring direct economic benefits to packaging companies.