$(1)$ Create a spreadsheet that shows the annual shipping volume of $16,000$ cwt for each of the methods described in the case. Assume one day for a $200-$mile trip for a truck and two days for rail. $(2)$ Determine the costs if a private truck and a back$-$haul were arranged. Determine the costs should the company purchase a truck for this activity. $(3)$ With the information you have been provided and have calculated, provide a detailed proposal to Ms$.$ Jones with the various alternatives. In your proposal, indicate the alternative that provides the best solution. $(4)$ Using the information derived from this case study, discuss how at least one of the Saint Leo University core values apply to this situation.