Elements of the model

Variable solutions
The Objective function
Restrictions

Organize data in MS-Excel and use Search for a solution (Solver).

Make a template for the solution yourself.

Task No3. The optimal plan for placing production orders. The company plans to produce 300 thousand of the same type of products at its four enterprises every month. For the development of this new type of product allocated 18 000 (thousand EUR). Developed for each branch projects of the development of new products are characterized by certain values of the cost of a single product and the necessary specific investments. Company No1 No2 No3 No4 TOTAL Variable solutions X1 X2 X3 X4 300 Unit cost The Investment per unit 83 120 89 80 95 0 98 40 18000 Production and investment costs can be considered proportional to the number of products produced. To determine such a plan for placing monthly production volumes by enterprises, at which the total production costs will be minimal. Note Fill in the table of model elements. Keep in mind that 18 000 thousand EUR. - This is the amount allocated only for capital investment, but not to cover the monthly costs of production. The latter will be covered by additional funds (first - short-term loans, then - deductions from sales). It is believed that to ensure a given volume of production, you need to invest the more money, the greater will be its capacity (the number of products produced per month)