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:
![YellowSmart Company is an online supermarket and sells more than 100,000 products and offers home delivery](https://dsd5zvtm8ll6.cloudfront.net/questions/2024/01/659bd4b0410b1_1704711220555.jpg)
![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](https://dsd5zvtm8ll6.cloudfront.net/questions/2024/01/659bd52d41be3_1704711352403.jpg)
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
-
( Identifying permanent and temporary asset investments ) Classify each of the following investments in assets as either permanent or temporary, and explain your choice: 1 . A seasonal increase in a...
-
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...
-
The activity of moving materials uses four forklifts, each leased for $18,000 per year. A forklift is capable of making 5,000 moves per year, where a move is dened as a round trip from the plant to...
-
The default width of a VARCHAR2 field is: a. 1 b. 30 c. 255 d. Nonetheres no default width for a VARCHAR2 field.
-
Refer to Exercise 5.3. Find the following probabilities: LO8 a. P115 x 302 b. P125 6 x 6 352 c. P1x 302 d. P1x 202 e. P1x 302 f. P125.5 x 30.52
-
You are considering buying stock A. If the economy grows rapidly, you may earn 30 percent on the investment, while a declining economy could result in a 20 percent loss. Slow economic growth may...
-
Private, Incorporated, manufactures and sells two products: Product Z9 and Product N0. The company is considering adopting an activity-based costing system with the following activity cost pools,...
-
Draw a diagram similar to Figure 1.1 that places the following words in the proper relationships: theory, hypothesis, model, data, guess, and law. Figure 1.1 Geology Geochemistry (chemistry of the...
-
If TR2 R2 is a transformation and the action of T is as given, find a formula for T (V), where V is any vector in R2. x-2y x-y 1-8
-
Use least square regression to fit a straight line to the following data taken from the conductance (S/m) of a material with respect to temperature (C) of a composite material used to absorb heat....
-
A pile group consists of nine friction piles in clay soil (see Figure 10-40). The diameter of each pile is 16 in., and the embedded length is 30 ft each. Center-to-center pile spacing is 4 ft. Soil...
-
The rigid bar EBC is supported by two links AB and CD as shown in Figure 1. The Link AB is made of aluminum (E = 70 GPa) and the link CD is made of steel (E = 200 GPa). Both links have a Width = 30...
-
a well-insulated storage tank was pressurized under ideal gas conditions by air flowing into the tank. We used the first law to estimate the final temperature of the gas in the tank, Tf,tank- = We...
-
Transportation of natural gas is commonly done via pipelinesacross long distances. A company uses a 0.6-m diameter pipe totransport natural gas. Then pumping stations are located atdifferent points...
-
You are the auditor of Super Fresh Pty Ltd (SPFL) for the year ended 30 June 2019. SPFL is a manufacturer of tinned shellfish products. It purchases fresh shellfish from local suppliers, and frozen...
-
In a certain school district, 3% of the faculty use none of their sick days in a school year. Find the probability that 5 faculty members selected at random used no sick days in a given year.
-
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) Explain why an analyst may prefer a confidence interval to a hypothesis test. (b) Describe how a confidence interval may be used to assess significance.
-
What recourse do we have if the residual analysis indicates that the regression assumptions have been violated? Describe three different rules, heuristics, or family of functions that will help us.
-
Describe the criterion for rejecting the null hypothesis when using the p-value method for hypothesis testing. Who chooses the value of the level of significance, ????? Make up a situation (one...
Understanding Computers Today And Tomorrow Comprehensive 16th Edition - ISBN: 1305656318 - Free Book
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App