An Excel model and small paper are required for this project. A model for a traveling preacher is needed for a non-profit denomination. Using the seven-step process defined in Unit 1 of Practical Management Science, you will optimize the travel route minimizing miles to travel to 4 locations. The Word document paper is one paragraph for each of the seven steps in the process, stating how you accomplished those steps. No APA is required for this assignment.

• A circuit preacher lives in Chicago and preaches in Los Angeles, Denver, Boston, and Dallas.
• Start with the file of mileage Preacher_Mileage.xlsx located in Canvas Unit 7 Case Study- PreacherMileage-1.xlsx Download Unit 7 Case Study- PreacherMileage-1.xlsx which documents the distances between the cities and has the formulas built into the model.

	Distances Between Cities
		Boston	Chicago	Dallas	Denver	LA
	Boston	0	983	1815	1991	3036				Directions:								Rules:
	Chicago	983	0	1205	1050	2112				The purpose of this project is to set up solver correctly								Start in Chicago
	Dallas	1815	1205	0	801	1425												End in Chicago
	Denver	1991	1050	801	0	1174				Solver Video for Model to Minimize Distance								Minimize the miles traveled in total.
	LA	3036	2112	1425	1174	0
	Model