SOLVE AS PER INSTRUCUTIONS:

Use excel for linear programing part. Interpret the output in word document. The document must contain a title page, main text and references The formatting must be as Times New Roman, font Size 12, line spacing 1.5, all justified header footer 0.5 each Headings must be bold with font size 14 Marks will be deducted for late submission and poor formatting. Zero marks will be awarded in case of cheating or copy paste. Assignment Topic & Details: Assignment Topic: Vehicle Routing and Scheduling Assignment Detail: The SLC Corporation manufactures a popular commercial security lock at plants in Macon, Louisville, Detroit, and Phoenix. The annual production capacity at each plant is 180,000, 150,000, 250,000, and 200,000, respectively. SLC's locks are sold to retailers through wholesale distributors in seven cities across the United States. The unit cost of shipping from each plant to each distributor is summarized in the following table along with the forecasted demand from each distributor for the coming year. Unit Shipping cost to Distributors Tacoma San Dallas Denver St. Louis Tampa Baltimore Plants Diego Macon $2.50 $2.75 $1.75 $2.00 $2.10 $1.80 $1.65 Louisville $1.85 $1.90 $1.50 $1.60 $1.00 $1.90 $1.85 Detroit $2.30 $2.25 $1.85 $1.25 $1.50 $2.25 $2.00 Phoenix $1.90 $0.90 $1.60 $1.75 $2.00 $2.50 $2.65 Demand 8,500 14,500 13,500 12,600 18,000 15,000 9,000 The company wants to determine the least expensive way of shipping locks from its plants to the distributors. 1) Calculate the total cost by using; a. Northwest corner rule b. Intuitive method 2) Formulate an LP model for this problem a. Formulate objective function and constraints b. Create answer reports and sensitivity reports and interpret the output