-The objective function in terms of the decision variables

The constraint for Capital Requirements in Year 1

The constraint for Capital Requirements in Year 2

The constraint for Capital Requirements in Year 3

The constraint for Capital Requirements in Year 4

Solve the problem using Excel. What is the value of the objective function?

Please help, this is operations research

The Kuwait Refrigeration Company (KRC) is considering a variety of projects with varying capital requirements over the next four year. Faced with limited capital resources, the company must select the most profitable project. The estimated net present value of the projects, the capital requirements, and the available capital are shown in the table below. Let: x1 = 1 if the Plant Expansion is accepted; 0 otherwise. x2 = 1 if the Warehouse Expansion is accepted; 0 otherwise. x3 = 1 if the New Machinery is accepted: 0 otherwise. x4 = 1 if the New Product Research is accepted; 0 otherwise. Project Capital Requirements (1000 KDs) Estimated Net Present Value (1000 KDs) Plant Expansion Warehouse Expansion New Machinery New Product Research 90 40 10 37 Year 1 15 10 10 15 Year 2 20 15 0 10 Year 3 20 20 0 10 Year 4 15 5 4 10 Available Funds 40 50 40 35