MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
8th Edition
ISBN: 9781337274876
Author: Cliff Ragsdale
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
do fast
Determine the total weight of this graph's minimum-weight spanning tree.
Need help
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- Jk.335. Propiem 14-8 Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From To A B C Demand D $9 9 5 50 From/To $8 Candidate solution A B C Total shipped Cost A - B C Total costs 8 3 60 $6 8 3 25 $5 D 0 10 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.) Supply 50 40 75 30 165 165 E F G Supply $arrow_forwarddo fast.arrow_forwardPlease help me with part barrow_forward
- 2. A company has plants at locations A, B and C with the daily capacity to produce chemicals to a maximum of 3000 kg, 1000 kg and 2000 kg respectively. The cost of production (per kg) are P800, P900 and P750 respectively. Customer's requirement of chemicals per day is as follows: Customer Chemical Required Price offered 2000 200 2 1000 215 3 2500 225 1000 200 Transportation cost per kg from plant locations to customer's place is given in table. Customer 2 3 A 5 7 10 12 Plant B 3 4 2 с 3 Find the transportation schedule that minimizes the total transportation cost.arrow_forwardb) A factory is going to modify of a plant layout to install four new machines M₁, M2, M3 and M4. There are 5 vacant places J, K, L, M and N available. Because of limited space machine M₂ cannot be placed at L and M3 cannot be placed at J. The cost of locating machine to place in Shillings is shown below: M₁ M₂ M3 M4 J Kshs '000' 24 28 K Kshs '000' 18 18 22 16 L Kshs '000' 22 28 24 M Kshs '000' 30 20 22 14 N Kshs '000' 22 18 14 16 Required: Determine the optimal assignment schedule in such a manner that the total costs are kept at a minimum.arrow_forward2. As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem solving costs $8000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem solving that should be offered in order to minimize total cost. b. Determine the optimal…arrow_forward
- A company with a network of 10 pipelines transports mango juice according to the details shown in Table 1. Determine the maximum flow per hour. 1. Table/Jadual 1 Сарacity Node Node (m3/h) 140 100 120 100 120 80 110 100 100 100 Reverse Capacity |(m³/h) 60 20 40 40 40 20 30 40 60 60 Start End Pipeline 1 2 3 4 1 1 1 2 3 4 6 6 7 3 7 7 8 8 10arrow_forwardallons of deionized water from each wholesaler to each distribution center is shown in the following table: Question Viewer a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? B. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center is needed. C. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. b. What is the total cost of the solution? The optimal cost is $ ((Enter your response rounded to the nearest dollar.)arrow_forwardJ 2 An electronics store wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annual number of truckloads are given in the accompanying table. Develop a model to find the best location, assuming that straight-line distances can be used between the locations. Experiment with the model by testing each of the possible best solutions, included, to find the best location. Click here to view the data for the store locations and annual numbers of truckloads. Click here to view some possible best solutions. The best location is at____. (Type an ordered pair. Round each coordinate to the nearest integer as needed.)arrow_forward
- Southern Sporting Goods Company makes basketballs and footballs. Each product is produced from two resources-rubber and leather. The resource requirements for each product and the total resources available are as follows: Product Resource Requirement per Unit Rubber (lb.) Basketball 4 Football 5 Total Resources available 500 lb. 800 ft.2 * Each basketball produced results in a profit of $12, and each football earns $16 in profit. b. Transform this model into standard form Leather (ft.2) 3 2 a. Formulate a linear programming model to determine the number of basketballs and footballs to produce in order to maximize profit.arrow_forwardThe metes and bounds system primarily relies on which of the following to describe land? section, lot, and block numbers within a subdivision a readily identifiable point of beginning and the boundaries of a property in terms of distances and compass directions checks, correction lines, and tiers meridians, base lines, townships, and rangesarrow_forwardA company that handles hazardous waste wants to minimize the shipping cost for shipments to a disposal center from five receiving stations it operates. The locations of the receiving stations and the volumes to be shipped daily are given in the below table: Location ( x, y ) Daily Volume ( in truck loads ) A (5.70,5.00) 15 B (4.00,7.70 ) 9 C (1.90,2.80 ) 18 D (2.10,5.20 ) 16 E (7.50, 6.30) 17 1. Which one of the following coordinate is closest to the optimal location using median method? a) (4.00,5.20) b) (4.00,3.64) c) (2.60,5.20) d) (5.80,3.12) 2. Which one of the following coordinate is closest to the optimal location using gravity method? a) (4.22,4.62) b) (5.91,6.16) c) (4.22,5.13) d) (5.28,5.13) 3. Which one of the following is closest to the total distance traveled (optimal objective function value) using Rectilinear distance measure for the optimal median solution? a) 241 b)352 c)157 d)133arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY