USE EXCEL AND SOLVER ONLY, IF YOU DONT; DISLIKE

Use Solver to solve this problem. The Excel spreadsheet must show the model, the formulas used and the solution. Be sure to include the answer report when uploading your spreadsheet. Round your answer to 1 decimal place. Solve the following LP problem: Min11S+7M s.t. (1) S+M=200,000 (2) .20S+.05M=>15,000 (3) M=>37,500 S,M=>0 Questions: a. What are the values of the variables S and M ? b. What is the total value of the objective function? c. According to the information in the answer report, what constraints are binding? d. What is the surplus of constraints \#2, and 3 ? Match your answers to the questions. Question \#A Question \#B Question \#C Question \#D [ Choose ] 1,600,000 #2=129,166.7;#3=0 #2=0;#3=129,166.7 1,455,234 1,533,333 S=166,666.7;M=33,333.3 S=30,333.3;M=136,666.7 \#1 and \#3 180,000 S=80,000;M=120,000 #2=23.60;#3=134,166 Only \#3 is binding \#1 and \#2 #2=0;#3=82,000 \#2 and \#3 S=33,333.3;M=166,666.7