Answer Happy

☎ Home 5. = Insert Draw Design Layout 11 Calibri (Body) A- A BIU▾ the X₂ X A Paste Read Only To save a copy of this document, click Duplicate. Assignment3 [Read-only] References Mailings Review View Script Lab Table Design Layout ALE A A A. ¶ AaBbCcDdia. | AaBbCcDdE AaBb AzBDCCDdEd AaBbCel AaBb CcDdEe Heading 1 Normal - AA No Spacing Heading 2 Title Subtitle . This is a group assignment · 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 Page 1 of 2 Assignment-3 Focus 3 59 Instructions: Page 1 of 2 331 words English (United States) Q Search in Document = Styles Pane + Share ✔ Smart Tanpar Tagger Duplicate + 182 %
☎ Home Assignment3 [Read-only] View Script Lab Table Design Review Layout A. ¶ AaBbCcDdE AaBb AzBDCCDdEd AaBbCel | AaBbCcDdEe Heading 1 AaBbCcDdEn No Spacing Normal Heading 2 Title Subtitle 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. 5 5. = Insert Draw Design Layout Calibri (Body) 11 A- A A BIU nhe X₂ X A.✰ . A . A References Mailings ARE A Paste Read Only To save a copy of this document, click Duplicate. Page 2 of 2 331 words English (United States) Focus 3 Q Search in Document = Styles Pane + Share ✔ Smart Tanpar Tagger Duplicate Exc.com pum 182%