The Axis car rental company allows its customers to pick up a rental car at one location and return it to any of its locations. Currently, two locations (1 and 2) have 16 and 18 surplus cars, respectively, and four locations (3, 4, 5, and 6) each need 10 cars. The costs of getting the surplus cars from locations 1 and 2 to the other locations are summarized in the following table. Location 1 Location 2 Costs of Transporting Cars Between Locations Location 4 Location 5 Location 6 $23 $19 Location 3 $54 $24 $17 $18 $30 $31 Because 34 surplus cars are available at locations 1 and 2, and 40 cars are needed at locations 3, 4, 5, and 6, some locations will not receive as many cars as they need. However, management wants make sure that all the surplus cars are sent where they are needed, and that each location needing cars receives at least five. Develop a spreadsheet model for this problem and solve it using Solver. How many cars are to be shipped from Location 2 to Location 5?
Q: A machine makes two components; call them types A and B. It takes 630 seconds to switch production…
A: The batch size is indeed the number of samples processed prior to a model modification. The number…
Q: What is the EMV of each decision alternative? Which action should be selected? What is the expected…
A: A decision tree is a diagram that shows all the possible outcomes of a decision and the…
Q: explain the transformation process in a hotel resort
A: The transformation process of operations in a hotel resort is a complicated process. It involves…
Q: Why do Business Analyst role keep evolving in a Agile project?
A: Agile management is one of the methods that is commonly used in project management. As per this…
Q: (ii) linear programming formulation Let x₁ = number of units i shipped to client j, using the…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Manager at FreeAir Lid, a leading manufacturer of fans used in air conditioning systems. The company…
A: The Breakeven Point is that level of sales at which there is no profit no loss. In other words at…
Q: Consider the following all-integer linear program. Max 1x1 + 1x2 s.t. 5x1 + 7x2 ≤ 42…
A: Linear programming, a mathematical technique used to help management decide how to make the most…
Q: We Care Associates (WCA), a local physician practice group, orders supplies from various…
A: Functional or operational weeks = 52 weeks a year
Q: Consider the following LP problem developed at Zafar Malik's Carbondale, Illinois, optical…
A: Given data is Objective function: Max Z=1X1+1X2 Subject to constraints: C1.) 2X1+1X2≤100C2.)…
Q: Explain how to determine the number of variables and constraints that would be in a transportation…
A: The transportation problem arises frequently in planning for the distribution of goods and services…
Q: 1.Which of the following is a decision-making criterion that is used for decision making under risk?…
A: (1) A project management measure called Expected Monetary Value (EMV) is used in risk analysis to…
Q: a) Find the expected completion time for this project. The expected completion time for this project…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: 11.4 Given the following data, calculate the average demand and the standard deviation. Period 1 2 3…
A: Given data-
Q: You are the executive of a Reynolds business division. Last year, 243 employees worked in your…
A: Given data is Total employees = 243 Total employees who are not in the manager's unit anymore…
Q: Suppose that the feasible region of a maximization LP problem has corners of (0,0), (10,0), (5,5),…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: A manager wants to expand summer resort facilities now or wait at least another year. If he expands…
A: According to Bayesian theorem:Probability for an event A,B shows:PAB=PBA×PAPBWhere, PAB is the…
Q: A restaurant manager tracks complaints from the diner satisfaction cards that are turned in at each…
A: A pareto analysis state that the 80% of results will come out from 20% of the attributes.…
Q: The manager of a medical center wants to schedule staff based on a pattern of 5 days working and 2…
A: The correct option is (a) - Saturday and Sunday It is stated that they have consecutive day offs…
Q: d. Dr. I QUESTION 7 A conversion process consists of four steps: cutting, welding, tumbling, and…
A: Rolled throughput yield is a key metric used in manufacturing. It is defined as the ratio of the…
Q: In 2017, Aurecon was appointed by the City of Ekurhuleni to design and construct rail line…
A: In project management, a project constraint is anything that puts limits on the work that can be…
Q: Maria and Ellie are neighbors. Both are entrepreneurs and they want to do business with each other.…
A: Maria - Manufacturer of the product Ellie - Potential customer for Maria Issues with Maria: High…
Q: a. The minimum project duration. b. The Critical Path c. The total float for each activity. d. The…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: ‘Total Quality Management is combination of various principles which are aimed to establish and…
A: Introduction: Total Quality Management (TQM) is an organizational operation management technique…
Q: What are the benefits of a CPFR program? What does it prevent?
A: NOTE: We are allowed to do one question only. An inventory management system is a must for any…
Q: (a) Show the linear programming formulation. (Let XA1 be the number of units of product A produced…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: or a product mix linear programming problem, we use three materials (A, B and C) to make two…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Which of the following statements about the basic EOQ model is Ture? If the holding cost were to…
A: Economic order quantity (EOQ) is an inventory management tool which helps to identify the optimal…
Q: Inventory holding costs include which of the following? a. Physical warehousing charges b.…
A: When a company keeps goods in a warehouse, they usually have to pay a fee known as "inventory…
Q: Daphne Hudson works for a company with a semi-monthly pay cycle. She earns $100,000 per year and…
A: Earning per year $100,000 Work week (hrs.) 40 Parking allowance per month $100 On-call…
Q: total number of call-center employees needed to meet the minimum requirements. (Let X, the number of…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: The Dahlia Medical Center has 33 labor rooms, 18 combination labor and delivery rooms, and 3…
A: Given data: Labour room = 33 Combination labour = 18 Delivery rooms = 3 Average time = 24 hrs…
Q: Dave Fletcher was able to determine the activity times for constructing his laser scanning machine…
A: Early Start Time (ES): The earliest date by which an activity can start without delaying the…
Q: I need help with question 6 given and prepare the worksheet for Excel by the data of customers.…
A: Note: - As it is specified to answer question 6, we will answer it with all subparts. If an answer…
Q: Holding cost = $7 per unit per month Subcontracting cost = $65 per unit Regular time labor cost =…
A: Given- Holding cost = $7 per unit per monthSubcontracting cost = $65 per unitRegular time labor…
Q: 4. Quarterly demand for smartphones at a retailer is as shown. After obtaining initial estimates for…
A:
Q: An operations manager is deciding on the level of automation for a new process. The fixed cost for…
A: Formula to be used : Break even point = Fixed cost / Contribution margin per unit
Q: Which alternative is best, according to each of the following decision criteria? Maximin Maximax…
A: * Maxi mini criteria - choose the maximum of the minimum payoff that is choosing the minimum of the…
Q: A small firm intends to increase the capacity of a bottleneck operation by adding a new machine. Two…
A: The Breakeven Point is that level of sales at which there is no profit or no loss. In other words at…
Q: VoiceZen is one of the most trusted paint brands in the region. It has two existing manufacturing…
A:
Q: The Bayside Art Gallery is considering installing a video camera security system to reduce its…
A: Decision Variables: Suppose-xi be the 0-1 which is 1 if a camera is installed at opening i, and 0…
Q: (a) Formulate a linear programming model of the problem. (Express your answers using Xij, where each…
A: There are various methods/algorithms to find the distance of the route. In such problems, the…
Q: Slim-Down Manufacturing makes a line of nutritionally complete, weight-reduction beverages. One of…
A: Given data is Ingredient Calories from fat Total Calories Vitamin content Thickeners Cost…
Q: Product Variable Input 2 Multiple Choice 1 The diagram of product curves suggests that when marginal…
A: In the given diagram, Curve 1 is the: Marginal physical product curve Curve 2 is the: Average…
Q: Describe operation management decisions that are taken by a electricity distributor (utility…
A: Electricity distribution business administration and operation are intricate processes. They need…
Q: Quantitative Methods 1.The minimum expected opportunity loss ____________________. a.) is equal to…
A: 1. An expected opportunity loss quantifies the potential loss of making an incorrect choice in the…
Q: Suppose the due date of the project is 18 months and the probability of completing it is 75%, while…
A:
Q: The Measurable Organizational Value (MOV) is the goal of the project and is used to define the value…
A: The project goals are the specific separate goals that are designed apart from company goals. In…
Q: For each of the following occupations, discuss possible hazards. What actions can employers take to…
A: a. Worker in a fast-food restaurant: Risk: For employees, restaurants may demonstrate several risks.…
Q: Use the trend projection method, and the trend projection with seasonal adjustment method to create…
A: Find the given details below: Given details: Period Year Month #Passengers 1 2010 January 151…
Q: Solve the following linear programming problem graphically: Maximize Z=3X+5Y Subject to: 4X+4Y…
A: Given data is Objective function Z=3X+5Y Subject to constraints C1.) 4X+4Y≤48C2.) 1X+2Y≤20C3.)…
N23.
Step by step
Solved in 3 steps with 6 images
- At the end of a cycle of schedules, a trucking firm has a surplus of one vehicle each in cities A, B, C, D, E, and F and a deficit of one vehicle each in cities 1, 2, 3, 4, 5, and 6. The distances between cities with a surplus and the cities with a deficit are shown below. Find an assignment of surplus vehicles to deficit cities that will result in a minimum total distance. What is the total distance? -Solve the following transportation models using Excel Solver. -Find the optimal solution for the transportation problem having the cost and requirement tablebelow.The distance between two cities in the United States can be approximated by the following formula, where lat1 and long1 are the latitude and longitude of city 1 and lat2 and long2 are the latitude and longitude of city 2. 69 (lat1 − lat2)2 + (long1 − long2)2 Ted's daughter is getting married, and he is inviting relatives from 15 different locations in the United States. The file Wedding gives the longitude, latitude, and number of relatives in each of the 15 locations. Ted would like to find a wedding location that minimizes the demand-weighted distance, where demand is the number of relatives at each location. Assuming that the wedding can occur anywhere, find the latitude and longitude of the optimal location. (Hint: Notice that all longitude values given for this problem are negative. Make sure that you do not check the option for Make Unconstrained Variables Non-Negative in Solver. Round your answers to three decimal places.) latitude of the optimal wedding location:…A beer distributor needs to plan how to make deliveries from its warehouse (node 1) to a supermarket (node 7), as shown in the network below. A graph with 7 nodes and 9 arcs is shown. Node 1 is connected to node 2 by arc of value 3, to node 5 by arc of value 3, and to node 6 by arc of value 11. Node 2 is connected to node 3 by arc of value 4. Node 3 is connected to node 2 by arc of value 4 and to node 4 by arc of value 7. Node 4 is connected to node 3 by arc of value 7, to node 6 by arc of value 5, and to node 7 by arc of value 6. Node 5 is connected to node 6 by arc of value 7. Node 6 is connected to node 4 by arc of value 5, to node 5 by arc of value 7, and to node 7 by arc of value 3. Develop the LP formulation for finding the shortest route from the warehouse to the supermarket. (Let xij represent the flow from node i to node j.) Min s.t.Node 1 Flows Node 2 Flows Node 3 Flows Node 4 Flows Node 5 Flows Node 6 Flows Node 7…
- General Ford has two plants, two warehouses, and three customers. The locations of these as follows: Plants: Detroit and Atlanta;Warehouses: Denver and New YorkCustomers: Los Angeles, Chicago, and Philadelphia Cars are produced at plants, then shipped to warehouses, and finally shipped to customers. Detroit can produce 142 cars per week, and Atlanta can produce 86 cars per week. Los Angeles requires 50 cars per week; Chicago, 52; and Philadelphia 84. It costs $9500 to produce a car in Detroit and $7500 to produce a car in Atlanta, and the costs of shipping a car between cities are given in the table below. What is the minimal cost of meeting General Ford's weekly demands?solve with excel solver PharmaCo wants to determine how to deploy sales representatives across its Western U.S. region to support a new drug for obesity. Sales representatives will be located in a "home city", which they serve, in addition to cities with feasible commuting distance, with the objective that all cities must be served by at least one sales representative. The feasible connections between each city in the region are listed below (1 indicates a feasible connection, potential home cities are shown in columns, and cities served in rows): Potential Rep Home City Served? Albuquerque El Paso Denver Phoenix San Diego Los Angeles San Francisco Portland Seattle Las Vegas Salt Lake City Albuquerque 1 1 1 1 0 0 0 0 0 0 0 El Paso 1 1 0 1 0 0 0 0 0 0 0 Denver 1 0 1 1 0 0 0 0 0 0 1 Phoenix 1 1 1 1 1 1 0 0 0 1 1 San Diego 0 0 0 1 1 1…Baseball umpiring crews are currently in four cities where three-game series are beginning. When these are finished, the crews are needed to work games in four different cities. The distances (miles) from each of the cities where the crews are currently working to the cities where the new games will begin are shown in the following table. The X indicates that the crew in Oakland cannot be sent to Toronto. Formulate as a linear programming problem to minimize the miles traveled. HINT: Since one assignment cannot be made, what are the options for that variable in the formulation? Solve using Excel solver. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
- The Child-fair Company has three plants producing child push chairs that are to be shipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipments per month, respectively. Each distribution center needs to receive 10 shipments per month. The distance from each plant to the respective distribution centers is given below. How much should be shipped from each plant to each of the distribution centers to minimize the total shipping cost, where the freight cost for each shipment is $100 plus 50 cents/mile? Formulate this case as a transportation problem (a) algebraically, and (b) on a spreadsheet, then (c) use Solver to obtain the optimal solutionsLuminous lamps have three factories - F1, F2, and F3 with production capacity 30, 50, and 20 units per week respectively. These units are to be shipped to four warehouses W1, W2, W3, and W4 with requirements of 20, 40, 30, and 10 units per week respectively. The transportation costs (in Rs.) per unit between factories and warehouses are given below. Find an initial basic feasible solution.Transportation Problems: The EBKK company has three plants producing child push chairs that are to be shipped to four distribution centers. Plans 1, 2, and 3 produce 12, 17, and 11 shipments per month, respectively. Each distribution center needs to receive 10 shipments per month. The distance from each plant to the respective distribution center is given below: DISTRIBUTION CENTER Plant 1 2 3 4 1 800 1300 400 700 2 1100 1400 600 800 3 600 1200 800 900 a. Draw a complete network representation of the problem b. Is the initial solution optimal? c. Find the optimal solution using the MODI Method d. The freight cost for each shipment is $100 plus 50 cents per mile. How much should be shipped from each plant to each of the distribution centers to minimize the total shipping cost?
- The Sav-Us Rental Car Agency has six lots in Nashville, and it wants to have a certain number of cars available at each lot at the beginning of each day for local rental. The agency would like a model it could quickly solve at the end of each day that would tell it how to redistribute the cars among the six lots in the minimum total time. The times required to travel between the six lots are as follows: To (min.) From 1 2 3 4 5 6 1 12 17 18 10 20 2 14 10 19 16 15 3 14 10 12 8 9 4 8 16 14 12 15 5 11 21 16 18 10 6 24 12 9 17 15 The agency would like the following number of cars at each lot at the end of the day. Also, shown is the number of available cars at each lot at the end of a particular day. Determine the optimal reallocation of rental cars. Lot (cars) Cars 1 2 3 4 5 6 Available 37 20 14 26 40 28…Suisan Fish Company contracts with fishers in Hilo, Kona, and Puna, Big Island to purchase fishes. The fishes are cleaned and stored at the local processing facilities. Then the fishes are shipped to two plants, where they are cut, processed, and packaged as sushi and sashimi. The sushi and sashimi are then transported to three restaurants. The transportation costs per fish from the fishers to the plants and from the plants to the restaurants are summarized in the following tables: Determine the optimal shipments from fishers to plants and from plants to restaurants to minimize total transportation costs. Include the formulation and solver outputs. What would be the effect on the solutions if the capacity at each plant were 70 fishes?A Company has 3 production facilities S1, S2 and S3 with production capacity of 7, 9 and 18 units (in 100's) per week of a product, respectively. These units are tobe shipped to 4 warehouses D1, D2, D3 and D4 with requirement of 5,6,7 and 14 units (in 100's) per week, respectively. The transportation costs (in rupees) per unit between factories to warehouses are given in the table below. D1 D2 D3 D4 Capacity S1 19 30 50 10 7 S2 70 30 40 60 9 S3 40 8 70 20 18 Demand 5 8 7 14 34 Find initial basic feasible solution for given problem by usingcolumn minima methodif the object is to minimize the total transportation cost.