Question: Please write down constrains and solve it by excel solver A company receives 4 types of different products from 4 suppliers, The suppliers supply products

Please write down constrains and solve it by excel solver
A company receives 4 types of different products from 4 suppliers, The suppliers supply products containing products of particular types as shown in the table below. The table also shows the number of batches available for supply and costs per batch For example, supplier S1 suppliers products P1 and P2 in balance containing 5 units of product P1 and 4 units of product P2. This supplier can supply up to 500 batches, $1.5 per batch- The company needs at least 1500 units of product P1, at least 1000 units of P2, at least 1000units of product P3 and at least 1300 units of product P4 Products S1 Suppliers S3 3 S2 5 4 S4 4 2 4 P1 P2 P3 P4 Available cost($) 3 3 300 5.5 500 1.5 2 300 4.5 4 400 4 What is the minimal cost at which the company can satisfy its demand? Assume that the number of batches supplied can be fractional. (please set constrains and use excel solver to solve question!)Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
