College press publishes textbooks for the college market. The demand for college textbooks is high during the beginning of each semester and then tapers off during the semester. The unavailability of books can cayse a professor to switch apoptions, but the cost of storing books and their rapid obsolescence must also be considered. Given the demand and cost factors here, use the transportation method to design an aggregate production plan for College Press that will economically meet demand. What is the cost of the production plan. Formulate. Then solve using the add in solver with Excel.