Solve only using EXCEL Solver

The ABC Hospital imports implants for Knee Arthroplasty. Different knee surgeries require implants of different sizes. The hospital buys these from two different suppliers-Knee-wala and knee-sure. The supplies by both of them are in packs of 100. The cost and the size-mix of the implant purchased are given in the following table.

Supplier	Cost per pack (in Rs)	No. of implants(percent) Large Medium Small
Knee-Wala	8000	40	20	40
Knee-sure	6000	20	40	40

Each quarter the hospital requires at least 120 large implants, 200 medium implants and 220 small implants. Because of limited availability, at most 400 implants can be purchased from each supplier.

Formulate this problem as a Linear programming Problem (LPPP) and determine the optimal number of packs that should be purchased from each supplier so as to minimize the total cost.