Suppose that you have completed 60 credits toward graduation from University of Florida and that you want to finish in the next four semesters. You have the option of taking from 0 to 19 credits each semester. Using the current tuition rates ($22,595 per semester for full-time enrollment and $1040 per credit hour for part-time enrollment), write an integer program to find the most economical way to complete the 120 required total credits in the next four semesters. Use software to find a solution for your IP.

Are there multiple optimal solutions? HINT: Use a binary variable yi for the decision to go full-time versus part-time in semester i. Use other integer variables: xi for part-time credits (up to 11) and zi for full-time credits (up to 19) each semester. Please solve this using excel