provide the answer for 2 questions The distances between the customer locations and the distribution centers in miles for a company thathandles 3rd party logistics is as given below.Distance237DC116.316.52019.617.99.312.77.214.916.616.612.711.538.910.11110.89.87.313.419.117.512.916.416.16.9.417.473.6These are the number of boxes the customers need.Customer356.7IDDemand (Boxes)243819372321104.2. Ms. Angela Barnes is routing vehicles to deliver goods to seven customers. The customers are identified withan ID.Consider that each of her trucks can carry, at most, 100 boxes per tour. Use the Savings algorithm to designthe routes.Tip: Remember that the Savings algorithm is a heuristic algorithm. This means that the solution provided bythe Savings algorithm will not necessarily be the optimal solution to the problem.Important: Write the sequence of customers with a dash between the ID numbers (do not use spaces and donot include "DC"). For example, if the route goes from DC to 5 to 2 to 6 to DC, write 5-2-6 or 6-2-5 (both areconsidered correct). In the above example, 2-5-6 or 2-6-5 would be considered wrong!How many tours would Angela need?What are the savings (in distance traveled) compared to delivering directly from the DC to each customer?Round your result to one decimal digit

Compute the savings (Sij) for each pair (i,j) and sort the list as per the descending order of Sij…

The distances between the customer locations and the distribution centers in miles for a company that handles 3rd party logistics is as given below. Distance 1 2 3 7 DC 16.3 16.5 20 19.6 17.9 9.3 12.7 7.2 14.9 16.6 16.6 12.7 11.5 8.9 10.1 11 10.8 9.8 4 7.3 13.4 19.1 17.5 12.9 16.4 16.1 6 9.4 17.4 7 3.6 These are the number of boxes the customers need

The distances between the customer locations and the distribution centers in miles for a company that handles 3rd party logistics is as given below. Distance 1 2 3 7 DC 16.3 16.5 20 19.6 17.9 9.3 12.7 7.2 14.9 16.6 16.6 12.7 11.5 8.9 10.1 11 10.8 9.8 4 7.3 13.4 19.1 17.5 12.9 16.4 16.1 6 9.4 17.4 7 3.6 These are the number of boxes the customers need

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

Question 4 Read the case below and answer the questions that follow after Assessing Risks and Maximizing Profits You have just taken responsibility for purchasing at a major international logistic company, and you are reviewing all of the fuel purchases over the past two years. Fuel is such a necessary commodity for this logistics company and consequently, the company spends a fortune on fuel, and it hired you, in part to look for ways to cut costs. However, the availability of this commodity (fuel) is quite limited in supply. The problem is that, because of the diverse nature of your company’s transportation methods (which cover air, ground and ocean freight), each individual department purchases fuel separately. So, their air division purchases its own jet fuel, the trucking division purchases its own diesel, and the shipping freight division purchases its own oil 4.1 (a) What type of purchasing and supply organizational structure are we observing in the case above?…
Question 5: A Mechanical Design Company produces an innovative design of Batttery used for electric cars. The standard design of producing one(1) unit of Battery is provided in the bill of materials BOM which requires material mix shown in Table Q5a. The current monthly production of Battery is 2000 units per month with the actual material consumption shown in Table Q5b. Determine the following and justify why it is favorable or adverse. (i) Material usage variance; (ii) Material price variance; (ii) Total material cost variance; Table Q5a Usage (units) 5 Materials Total cost (OMR) V 17 W 3 38 X 8 50 Y 38 Table Q5b Usage (units) 12,047 6,902 17,556 4,122 Total cost (OMR) 50,526 94,083 103,953 76,408 Materials V W Y
Question 3 The Mental Health Parity Act requires the same level of health benefits coverage for mental illness as for a physical condition. True False Question 4 A hospital in a rural community is having difficulty attracting radiation therapists. In an effort to attract young, newly trained therapists, the department has decided to pay these newly graduated therapists at a pay rate equivalent to that of radiation therapists who have been with the hospital for up to ten years. What compensation issue is relevant to this scenario? O Internal equity O External competitiveness OExtrinsic rewards O Intrinsic rewards
Question 3 Best Technology (BT) is a leading manufacturer of adhesives used in a variety of industrial applications. BT produces two types of industrial adhesives in its Texas plant for the US market. The two types of adhesives are produced using the same production technology and equipment. They have identical characteristics except their adhesive strengths which are determined by the last production step of mixing with different chemicals. The demands for the two types of adhesives are independent and their weekly demands in the US distribution centre (DC) are approximately normally distributed with their means and standard deviations given below. Adhesives Type I Adhesive Type II Adhesive Mean (kg) Standard Deviation (kg) 9,000 10,000 4,000 3,000 The replenishment lead time of the adhesives from BT's manufacturing plant to the US DC is 4 weeks. The current adhesive production cost is $100/kg, the cost of shipping the adhesive from the plant to the DC is $20,000, and the annual…
Q. Cypress River Landscape Supply is a large wholesale supplier of landscaping materials in Georgia. Cypress River's sales vary seasonally; sales tend to be higher in the spring months than in other months.a. Suppose Cypress River estimates a linear trend without accounting for this seasonal variation. What effect would this omission have on the estimated sales trend?b. Alternatively, suppose there is, in fact, no seasonal pattern to sales, and the trend line is estimated using dummy variables to account for seasonality. What effect would this have on estimation? Thank you for providing answer.
Please answer question 2
Question 26 Amazon has 350 regional warehouse and maintains and average inventory of $150,000,000. The company is considering consolidating to 175 regional warehouses to reduce costs. What would be the combined average inventory in this new arrangement?
Question 4 Cost-benefit-tradeoff problems are linear programming problems involving the allocation of limited resources to activities. O True O False
QUESTION 8 The variable to remove from the current basis is O the variable with the biggest positive ratio value. O the variable with the smallest positive ratio value O the variable with the smallest positive cj - zj value. O the variable with the biggest positive cj - zj value.
Detailed Background of Knutsford Express service company. Providing history, location and services offered
The industry in which Morton Company operates is quite sensitive to cyclical movements in the economy. Thus, profits vary considerably from year to year according to general economic conditions. The company has a large amount of unused capacity and is studying ways of improving profits. Required: 1. New equipment has come onto the market that would allow Morton Company to automate a portion of its operations. Variable expenses would be reduced by $8.70 per unit. However, fixed expenses would increase to a total of $642,060 each month. Prepare two contribution format income statements, one showing present operations and one showing how operations would appear if the new equipment is purchased. 2. Refer to the income statements in (1). For the present operations and the proposed new operations, compute (a) the degree of operating leverage, (b) the break-even point in dollar sales, and (c) the margin of safety in dollars and the margin of safety percentage. 3. Refer again to the data in…
QUESTION # 7 A small restaurant offers tacos to their patrons. One of their specialties is the Mega Taco Supreme. A weekly forecast of the demand of this special taco is to be made in order for the manager to order taco shells in time. Recently the demand has been as follows: Week Tacos Week Таcos April 6 April 13 Аpril 20 April 27 May 4 Мay 11 56 60 65 56 55 50 a. Forecast the demand for the taco for April 27 to May 18 by using the simple moving average method with n-3. Then repeat the forecast by using the weighted moving average method with n=3 and weights of 0.5, 0.3, and 0.2 with 0.5 applied to the most recent demand. b. Calculate the MAD for each method and compare.