solve linear scheduling using excel and excel solver if necessary

Background While it is operating out of Air Station North Island near San Francisco, the aircraft carrier (CVN-70) is on Daneuvers from Monday through Friday and in port over the weekend. Next week the captain would like to give shore leave for Monday through Friday toas many as the 2500-sailor crew as possible. However, he must carry out the manewers for the week and satisfy navy regulations. The regulations are: 1. Sailors work either the A. M shift (midnight to noon) or the P.M. shift (noon to midnight) any day they work, and during a week they must remain on the same shift every day they work 2. Each sailor who works must be on duty exactly four days, even if there is not enough realwork on some days. The number of sailors required each shift of each day is shown in the following table. Formulate and solve this problem as a linear programming problem so that one would know how many sailors work on each day M TU A.M. 900 1000 P.M. 800 500 W TIL 150 800 1000 300 700 Background While it is operating out of Air Station North Island near San Francisco, the aircraft carrier (CVN-70) is on Daneuvers from Monday through Friday and in port over the weekend. Next week the captain would like to give shore leave for Monday through Friday toas many as the 2500-sailor crew as possible. However, he must carry out the manewers for the week and satisfy navy regulations. The regulations are: 1. Sailors work either the A. M shift (midnight to noon) or the P.M. shift (noon to midnight) any day they work, and during a week they must remain on the same shift every day they work 2. Each sailor who works must be on duty exactly four days, even if there is not enough realwork on some days. The number of sailors required each shift of each day is shown in the following table. Formulate and solve this problem as a linear programming problem so that one would know how many sailors work on each day M TU A.M. 900 1000 P.M. 800 500 W TIL 150 800 1000 300 700