operations research

-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? 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: *1 = 1 if the Plant Expansion is accepted:0 otherwise. x2 = 1 if the Warehouse Expansion is accepted:0 otherwise. *3 = 1 If the New Machinery is accepted:0 otherwise. *4 = 1 if the New Product Research is accepted:0 otherwise. Project Capital Requirements (1000 KD) Estimated Net Present Valee (1000 KD) Plant Expansion Warehouse Expansion New Machinery New Product Research 90 40 10 Year 1 13 JO 10 IS Year 2 20 15 0 10 Year 3 20 20 0 10 Year 4 15 5 4 10 Available Funds 10 so 10 35