YellowSmart Company is an online supermarket and sells more than 100,000 products and offers home delivery...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
YellowSmart Company is an online supermarket and sells more than 100,000 products and offers home delivery all year round. It is currently planning the daily routes for 8 of its trucks, which are located in different areas of Singapore. The trucks are responsible for delivering their loads whenever the customer orders are consolidated. The orders at all areas have to be fulfilled by the end of the day. Each truck can deliver the load to at most 4 areas within a day. The following table shows the mileage (in km) for a truck to travel to a customer region (indicated by Area A to Area L) and back to its original location. See table in Excel file. For example, if Truck 1 is assigned to Area A and Area C, Truck 1 will travel from its location to Area A and back to its location, and the total distance travelled is 125km. It will replenish the load and travel 155km from its location to Area C and back to its location. To simplify the problem, we do not consider the sequence of the delivery, i.e. it is fine to deliver to Area C before Area A in our example above. Truck 1 2 3 4 5 6 7 8 A 125 225 157.5 217.5 237.5 275 152.5 140 B 182.5 142.5 165 300 227.5 215 177.5 172.5 C 155 205 187.5 202.5 185 200 227.5 165 D 102.5 192.5 135 F 137.5 227.5 150 165 187.5 170 177.5 205 157.5 147.5 147.5 142.5 137.5 195 137.5 202.5 182.5 227.5 180 160 167.5 Area E 167.5 202.5 G 97.5 162.5 202.5 300 232.5 H 120 195 140 157.5 162.5 1 167.5 210 177.5 175 210 325 152.5 180 207.5 172.5 220 212.5 J 177.5 237.5 300 225 232.5 210 190 137.5 145 250 177.5 K 110 147.5 122.5 135 115 L 147.5 167.5 162.5 155 140 197.5 157.5 170 a) Formulate an assignment model to determine the optimal assignment of the trucks to the areas that will minimize the total mileage. Solve the problem in excel. b) Assume that the demand of each area is given in the form of truck capacity percentage loads. A Truck Capacity Percentage load 89 B 78 C 94 D 82 Area E 90 F 83 G 88 H 79 1 71 J You do not need to consider the average truck load capacity requirement mentioned in part b) Resolve a) and compare the difference (in objective function). 96 K 78 L 85 Determine the optimal assignment of trucks to customers that will minimize the total mileage while also achieving at least an average truck load capacity of 85%. For example, if a truck is assigned to Area A, B and C, the average truck load capacity is (89+78+94)/3. Formulate the model and solve it in excel. Present this in a separate worksheet from part a). c) To simplify the problem, Area A, B, C and D can be grouped into Region 1; Area E, F, G and H can be grouped into Region 2, and the remaining areas can be grouped into Region 3. Each truck can only deliver the load to at most 1 region within a day. Each region will require at least 2 trucks to fulfil its demand. YellowSmart Company is an online supermarket and sells more than 100,000 products and offers home delivery all year round. It is currently planning the daily routes for 8 of its trucks, which are located in different areas of Singapore. The trucks are responsible for delivering their loads whenever the customer orders are consolidated. The orders at all areas have to be fulfilled by the end of the day. Each truck can deliver the load to at most 4 areas within a day. The following table shows the mileage (in km) for a truck to travel to a customer region (indicated by Area A to Area L) and back to its original location. See table in Excel file. For example, if Truck 1 is assigned to Area A and Area C, Truck 1 will travel from its location to Area A and back to its location, and the total distance travelled is 125km. It will replenish the load and travel 155km from its location to Area C and back to its location. To simplify the problem, we do not consider the sequence of the delivery, i.e. it is fine to deliver to Area C before Area A in our example above. Truck 1 2 3 4 5 6 7 8 A 125 225 157.5 217.5 237.5 275 152.5 140 B 182.5 142.5 165 300 227.5 215 177.5 172.5 C 155 205 187.5 202.5 185 200 227.5 165 D 102.5 192.5 135 F 137.5 227.5 150 165 187.5 170 177.5 205 157.5 147.5 147.5 142.5 137.5 195 137.5 202.5 182.5 227.5 180 160 167.5 Area E 167.5 202.5 G 97.5 162.5 202.5 300 232.5 H 120 195 140 157.5 162.5 1 167.5 210 177.5 175 210 325 152.5 180 207.5 172.5 220 212.5 J 177.5 237.5 300 225 232.5 210 190 137.5 145 250 177.5 K 110 147.5 122.5 135 115 L 147.5 167.5 162.5 155 140 197.5 157.5 170 a) Formulate an assignment model to determine the optimal assignment of the trucks to the areas that will minimize the total mileage. Solve the problem in excel. b) Assume that the demand of each area is given in the form of truck capacity percentage loads. A Truck Capacity Percentage load 89 B 78 C 94 D 82 Area E 90 F 83 G 88 H 79 1 71 J You do not need to consider the average truck load capacity requirement mentioned in part b) Resolve a) and compare the difference (in objective function). 96 K 78 L 85 Determine the optimal assignment of trucks to customers that will minimize the total mileage while also achieving at least an average truck load capacity of 85%. For example, if a truck is assigned to Area A, B and C, the average truck load capacity is (89+78+94)/3. Formulate the model and solve it in excel. Present this in a separate worksheet from part a). c) To simplify the problem, Area A, B, C and D can be grouped into Region 1; Area E, F, G and H can be grouped into Region 2, and the remaining areas can be grouped into Region 3. Each truck can only deliver the load to at most 1 region within a day. Each region will require at least 2 trucks to fulfil its demand.
Expert Answer:
Answer rating: 100% (QA)
a Assignment model formulation Variables x11 x12 x13x81 1 if truck is assigned to area 0 o... View the full answer
Related Book For
Business Statistics for Contemporary Decision Making
ISBN: 978-0470910184
6th Edition
Authors: Ken Black
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The functions in Exercises 1128 are all one-to-one. For each function, a. Find an equation for f -1 (x), the inverse function. b. Verify that your equation is correct by showing that f( f -1 (x)) = x...
-
Why has the unemployment rate in the United States typically been lower than the unemployment rates in Canada and the countries in Western Europe?
-
1. What, if anything, should the Ships,Inc. do with regard to salaried personnel who have vacations planned later this year and now don't have enough vacation time? 2. What, if anything, should the...
-
Graph the expectation function for the logistic growth model (12.34) for \(\theta_{1}=10, \theta_{2}=2\), and values of \(\theta_{3}=0.25,1,2,3\), respectively. Overlay these plots on the same set of...
-
Iridium Technologies manufactures a variety of flash memory chips at its main foundry in Anam, Korea. Some chips are sold by Iridium to makers of electronic equipment while others are embedded into...
-
Briefly describe the costs and benefits of investing in private equity (VC and Buyouts)? How do these benefits change if one were to consider a large pension fund and a small foundation?
-
An experiment was conducted regarding a quantitative analysis of factors found in high-density lipoprotein (HDL) in a sample of human blood serum. Three variables thought to be predictive of, or...
-
ok ences Baird Books buys books and magazines directly from publishers and distributes them to grocery stores. The wholesaler expects to purchase the following inventory: Required purchases (on...
-
=3 0.5 1 The economy of Macroland has a production function given by output, capital and labour, respectively. Assume that the savings rate (0) is 10%, the rate of capital depreciation (d) is 1% and...
-
Flexible Budgets, Direct-Cost Variances, and Management Control Flexible Budget Brabham Enterprises manufactures tires for the Formula I motor racing circuit. The company's budgeted and actual...
-
Calculation of Cost of Goods Bold For the Year Ended December 31, 2018 Beginning Inventory Plus: Purchases Cost of goods available for sale Less: Ending Inventory 12.200 34.000 46.200 9,400 Cost of...
-
XYZ Bank told Bob to increase cash to $70,000 from 2016 to 2017. But cash increased from $16,566 in 2016 to just $33,411 in 2017, well short of $70,000. In this assignment, you will review six select...
-
MBA 708 Essentials of Financial Statement Analysis Week 6 Case Study: Transaction and Financial Analysis Tallulah Company has been in business for several years and is publicly traded on a major U.S....
-
An is the of a definite integral as an endpoint of the interval of integration approaches either a specified real number or positive or negative |. Although the integral dr , the integral is da is...
-
Write the given system without the use of matrices. D) - ()- d (x sin t + 8 (2+ 1)
-
The owner of a fast-food restaurant ascertains the ages of a sample of customers. From these data, the owner constructs the frequency distribution shown. For each class interval of the frequency...
-
A machine operator at a pencil-manufacturing facility gathered 10 different random samples of 100 pencils. The operator's inspection was to determine whether the pencils were in compliance or out of...
-
According to the Consumer Electronics Manufacturers Association, 10% of all U.S. households have a fax machine and 52% have a personal computer. Suppose 91% of all U.S. households having a fax...
-
A \(1.0-\mathrm{cm}\)-tall object is \(60 \mathrm{~cm}\) in front of a diverging lens that has a \(-30 \mathrm{~cm}\) focal length. Calculate the image position and height.
-
A 3.0-cm-tall object is \(15 \mathrm{~cm}\) in front of a convex mirror that has a \(-25 \mathrm{~cm}\) focal length. Calculate the image position and height.
-
A \(3.0-\mathrm{cm}\)-tall object is \(45 \mathrm{~cm}\) in front of a convex mirror that has a \(-25 \mathrm{~cm}\) focal length. Calculate the image position and height.
Study smarter with the SolutionInn App