please provide a step by step with formulas you should enter to solve this problem

Please create a single Excel file with each problem on a separate worksheet tab. The problem description for Problem 1 can be found on page 127 of your Practical Management Science textbook, and the problem description for the optional extra-credit question can be found on page 125. Problem 1 Problem 3.36(a) - Manufacturing Mechanical Heart Valves (P. 127 Inputs Supplier 1 Supplier 2 Supplier 3 Cost/valve $75 $65 S50 % small 40% 30% 20% % medium % large 40% 20% 35% 35% 20% 60% Purchases Supplier 1 Supplier 2 Supplier 3 Available 2400 2000 1000 Small Medium Large Valves obtained Required Total cost