Question

use excel to do this! It is an excel mini project ,so this is the question which is asking to find the cheapest way to purchase enough to meet everyone's needs!?

The business is OUT OF WINDEX and you have FRA in two weeks. In addition to the students needing Windex (150), so does the parents (50) and the teachers (75). There are five suppliers of WINDEX but each one has a different unit cost depending on whether it is for college students, afloat units, or shore units. Budgets are tight (as always) so find the cheapest way to purchase enough to meet everyone’s needs!

                                Supplier 1              supplier 2             supplier 3                     supplier 4       supplier 5   `          

Students	2	2.50	5	5.25	5.50
Afloat Units	2	2.75	5	4.50	4.25
Shore Units	2	2.25	5.25	6.00	6.25
TOTAL SUPPLY	20	50	100	50	60

Answer 1

	Suplier 1	Suplier 2	Suplier 3	Suplier 4	Suplier 5	Demand
Student	2	2.5	5	5.25	5.5	150
Afloat	2	2.75	5	4.5	4.25	50
Shore	2	2.25	5.25	6	6.25	75
Total Supply	20	50	100	50	60
Xij	1	2	3	4	5	LHS
1	6	0	17	8	2	150
2	0	5	3	0	5	50
3	4	16	0	1	4	75
LHS	20	49.75	100	48	57.25
Min Cost	275

Excel file link: https://1drv.ms/x/s!AkW5WQDSTr7DhnERLCNFsY-CkP7j

Xij : i^th person buy windex from j^th suplier. and optimal values are in table Xij and min cost is 275 $(or units whatever given)