Solve the following problem. Please only use excel and show work.

X Jx B D E F G H 1 J K L M N o 1 Problem #1 2 3 A business student at Towson University must complete a minimum of 65 courses to graduate. The number of business 4 courses must be greater than or equal to 23. The number of nonbusiness courses must be greater than or equal to 5 20. The average business course requires a textbook costing $60 and 120 hours of study. Nonbusiness courses require a 6 textbook costing $40 and 200 hours of study. The student has a total of 12,000 hours to study. The objective is to 7 minimize the cost of books. a. Formulate this as a Linear Programming problem. Show Mathematical Equations 9 b. Solve Using EXCEL-Solver clearly showing DATA, MODEL and Output and all formulas. 11 c. What is the optimum solution? What is the $$ Spent on Books? 12 d. Which are the Binding Constraints? Where is the Slack or Surplus? 8 10 13 14 15 16 17 19