ABC is an LTL (less-than-truckload) trucking company that delivers loads on a daily basis to five customers. The following list provides the customers associated with each route Route 1 2 3 4 5 ABC 1 2 3 4 5 6 The segments of each route are dictated by the capacity of the truck delivering t loads. For example, on route 1, the capacity of the truck is sufficient to deliver the loads to customers 3,2, and 4 only. The following table lists distances (in miles) among the truck terminal (ABC) and the customers. ABC 0 10 12 16 9 8 Customers served on the route 3, 2, 4 5, 3, 4 2, 1, 5, 3 2, 3, 5 1, 4, 2 1, 3, 5 Miles from i to j 1 2 10 0 32 8 17 10 12 32 0 14 21 20 3 16 8 14 0 15 18 4 9 17 21 15 0 11 5 8 10 20 18 11 0 The objective is to determine the least distance needed to make the daily deliveries to all five customers. Though the solution may result in a customer being served by more than one route, the implementation phase will use only one such route. Formulate the problem as an ILP, and find the optimum solution.

ABC is an LTL (less-than-truckload) trucking company that delivers loads on a daily basis to five customers. The following list provides the customers associated with each route Route 1 2 3 4 5 ABC 1 2 3 4 5 6 The segments of each route are dictated by the capacity of the truck delivering t loads. For example, on route 1, the capacity of the truck is sufficient to deliver the loads to customers 3,2, and 4 only. The following table lists distances (in miles) among the truck terminal (ABC) and the customers. ABC 0 10 12 16 9 8 Customers served on the route 3, 2, 4 5, 3, 4 2, 1, 5, 3 2, 3, 5 1, 4, 2 1, 3, 5 Miles from i to j 1 2 10 0 32 8 17 10 12 32 0 14 21 20 3 16 8 14 0 15 18 4 9 17 21 15 0 11 5 8 10 20 18 11 0 The objective is to determine the least distance needed to make the daily deliveries to all five customers. Though the solution may result in a customer being served by more than one route, the implementation phase will use only one such route. Formulate the problem as an ILP, and find the optimum solution.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Management wants to explore the total profit using What If analysis with the data below. Fixed Cost = $10,000 Material cost per toy = $0.15 Labor cost per toy = $0.10 Vary the Revenue per toy from 0.60 to 1.10 by 0.05, and the labor cost from 0.08 to 0.16 by 0.01 When the quantity sold is 27,000 toys, what is the range of profits when the sales price is $$0.70? - $1,090 to $1,340 $260 to $2,690 $1,610 to $4,040 $2,960 to $5,390 $530 to $2,960
For questions 32-35, use the word list to label the circular flow diagram. I Household Market (Households Sell. Firms Buy.) 35. Market (Firms Sell. Households Buy.) Businesse 34. Product Factor Firms sell goods and services Households sell the factors of production Households pay for the goods and services
Can you provide a snapshot pic of the Solvertable input to show how you came to the answers in part b?
b. Based on this extrapolation, when would Amazon be predicted to equal Walmart in revenue?c. Why has Amazon been growing faster than Walmart? Is the slow growth of Walmart related to the rapid growth of Amazon?
Below is data of lobster sales volume from a seafood company. We are using exponential smoothing (α = 0.5) and 3-year moving average to forecast it. a. Please fill the blanks above and write your processes below. b. What are the mean absolute deviations (MADs) of the two methods? Whichmethod will you choose based on the results? *Please solve for a-b and type or write all your work/steps and answers on paper* NO EXCEL, thank you
a.Conduct a (9-quadrant) TOWS matrix analysis of the University of Professional Studies, Accra.(Note: show the numbering of the specific internal and external factor being matched to arrive at the recommended action) b. Briefly explain two (2) limitations of SWOT analysis.
Write an executive summary of what was discussed in Unit 4 about the new healthcare business or service line. It should also include the following information: A unique mission statement Vision statement How will your business (product and services) benefit society? Financial information What assets are involved? What debts? Debt versus equity Debt ratio Financial cash flow A synopsis of anticipated operational expenses (be sure to include items such as staffing) A synopsis of anticipated revenue (Who is going to pay you? Are there regulations or oversight attached to the revenue stream?) Summary of your future plans
https://moodle.yukonu.ca/mod/resource/view.php?id=341714 Answer the question from the article: Is it practical to develop specific "Yukon Grown" labels for sub-categories such as "certified organics" or "locally born and raised" animals as suggested by our farmers?
Read the case/senario below and answer the question(s) that follow. Auas primary school identifies a need for an assistant teacher to assist in lower primary classrooms three days a week at the school. The principal’s daughter is in her final year studying early childhood development and has been looking for a part time job for the past months without success. He communicates this need to his wife at home and the wife is now asking him to hire their daughter. a) What type of ethical dilemma does this principal find himself in? In detail, explain why do you say so?
This is operations research question and the question is connected. Please with the step-step process on how to do it in excel solver and to insert the formula.