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 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
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…
Required information Lyndia Company is a merchandiser that sells a total of 15 products to its customers. The company provided the following information from last year: Selling Price Variable Cost Product 1 Unit Sales per Unit per Unit 9,000 $ 29 $12.95 2 16,500 $ 99 $68.55 3 6,000 $ 85 $42.50 4 19,500 $109 $85.00 5 4,500 $ 19 $ 6.35 6 27,000 $119 7 3,000 $ 39 $92.00 $14.30 8 7,500 $ 79 $33.18 9 9,000 $ 69 $30.36 10 15,000 $.95 $77.60 11 10,500 $ 59 $25.40 12 1,500 $ 65 $29.00 222 13 3,000 $ 44 $12.40 141 6,000 $ 49 $13.48 15 12,000 150,000 $ 89 $61.83 Last year, Lyndia's total fixed expenses and net operating income were $3,000,000 and $1,223,070, respectively. The company would like your assistance in developing some financial projections for this year.
Stadium View Apartment Complex has 30 apartments to rent. Historical data Trend suggests that any time rent increases by $60.00 per month one apartment becomes vacant. The current rent is $600.00 per month. How many $60.00 increases will enable Stadium View Apartments maximize its total monthly rent revenue?
14.1. Care Alliance (CA), a manufacturer of emergency care kits for disaster relief, has received the annual disaster readiness plans from its major constituents and now must develop an operations plan to set production, labor, and inventory levels of its basic emergency products for the next four quarters. Demand for the kits, given below, varies with seasonal weather, political climate, and economic conditions. The average worker at CA can produce 10,000 kits a quarter at a cost of $9 per kit. The cost of holding inventory is $2 per kit per quarter. Due to the medical nature of many of its products and concern for quality, hiring and firing costs are $700 per worker. CA currently employs 20 workers. Given the demand forecast below, develop a quarterly operations production plan for CA using (a) chase demand and (b) level production: Quarter Demand 1 150,000 2 250,000 3 350,000 4 250,00
Q4. What are the important long-term issues relevant for managing capacity, revenue, and customer satisfaction for SWA? Explain comprehensively.