Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Tech wants to develop an area network that will connect its server at its computer and satellite center with the main campus buildings to improve Internet service. The cable will be laid primarily through existing electrical tunnels, although some cable will have to be buried underground. The following network shows the possible cable connections between the computer center at node 1 and the various buildings, with the distances, in feet, along the branches:
Please do not give solution in image format thanku
A firm has established a distribution network for the supply of a raw material critical to itsmanufacturing. Currently there are two origins for this material, which must be shipped to threemanufacturing plants. The current network has the following characteristics:
COSTS
PLANT 1
PLANT 2
PLANT 3
SUPPLY
Raw Material source 1
$6
$8
$9
400
Raw Material source 2
$4
$7
$3
600
Demand
500
500
500
Supply < Demand
The firm has identified two potential sites for a third raw material source; these are identified asCandidate A and Candidate B. From A, the costs to ship would be $9 to Plant 1, $10 to Plant 2,and $12 to Plant 3. From B, these costs would be $11, $14, and $8. The new source, wherever itis located, will have a capacity of 500 units. Solve with the transportation method. Which siteshould be selected?
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
- In San Francisco, CA there is a low-income neighborhood referred to as the Tenderloin District (‘district’). This area is in the heart of the city but has not experienced the revitalization and gentrification as other areas have in the past fifty years as the economy took off with the development of so many tech companies in the area. Originally, the district was a tourist destination and contained a large number of hotels and motels. As other parts of the city developed, tourists stopped coming to this area and the hotels and motels converted to low-income housing establishments. As such they currently offer homeless people and those living around the poverty line a way to obtain housing at a cost they can afford within the city. Given this history, there are not a lot of single-family dwellings found in the district. Distinct from the housing issues, the district is known for its high crime rate. It has a reputation as the neighborhood in the city where it is easy to obtain drugs (on…arrow_forwardDavis Inc. produces three product lines in its manufacturing facility in St. John's, NL: Product Line (1), Product Line (2), Product Line (3). Davis is considering dropping Product Line (2) because it has been unprofitable for the past two years. Which of the following items is (are) irrelevant to Davis' decision to drop/keep Product Line (2)? O a) Total cost of rent on the manufacturing facility. O b) Customer demand for Product Line (2). Oc) Savings in direct materials cost associated with Product Line (2). O d) All of the above items are considered relevant in the decision.arrow_forwardI need solve this fast pleasearrow_forward
- Maximization Problem: A taxi company has several ride requests from across the city. The company wants to dispatch the taxis in a way that makes the most money. Assign taxis to routes such that the profit is maximized. Taxi 1 2 3 4 Ride 1 11 9 10 1 2 1 9 3 13 3 5 8 5 12 4 8 1 10 11arrow_forwardCargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:Commodity Tons Available Volume per Ton (cu.ft.) Profit per Ton ($)1 4,000 40 702 3,000 25 503 2,000 60 604 1,000 50 80You can elect to load any or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions: Cargo Hold Weight Capacity (tons) Volume Capacity (cu.ft.)Forward 3,000 100,000Center 5,000 150,000Rear 2,000 120,000More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold…arrow_forwardCargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:Commodity Tons Available Volume per Ton (cu.ft.) Profit per Ton ($)1 4,000 40 702 3,000 25 503 2,000 60 604 1,000 50 80You can elect to load any or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions: Cargo Hold Weight Capacity (tons) Volume Capacity (cu.ft.)Forward 3,000 100,000Center 5,000 150,000Rear 2,000 120,000More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold…arrow_forward
- State University has decided to reconstruct the sidewalks throughout the east side of its campus to provide wheelchair access. However, upgrading sidewalks is a very expensive undertaking, so for the first phase of this project, university administrators want to make sure they connect all buildings with wheelchair access with the minimum number of refurbished sidewalks possible.Following is a network of the existing sidewalks on the east side of campus, with the feet between each building shown on the branches:arrow_forwardProblem 6-33 For the following highway network system, determine the maximal flow in vehicles per hour: 3 Maximal flow 2 2 5 2 Vehicle flow capacity: 5000 vehicles per hour vehicles per hour. The highway commission is considering adding highway section 3-4 to permit a flow of 2,000 vehicles per hour or, at an additional cost, a flow of 3,000 vehicles per hour. What is your recommendation for the 3-4 arc of the network? Recommended capacity ▼ vehicles per hour.arrow_forwardThe following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow). Write the mathematical formulation of the problem. Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the solution obtained in the space provided. What is the optimal cost of transportation?arrow_forward
- The Canadian government has built a large grain-shipping port at Churchill, Manitoba, on the Hudson Bay. Grain grown in southern Manitoba is carried by rail to Churchill during the open-water shipping season. Unfortunately the port is open only 50 days per year during July and August. This leads to some critical crew staffing decisions by management. The port has the capacity to load up to 7 ships simultaneously, provided that each loading bay has an assigned crew. The remote location and short shipping season results in a very high labor cost for each crew assigned, and management would like to minimize the number of crews. Ships arrive in a random pattern that can be modeled using the Poisson probability model. If a ship arrives and all available loading bays are filled, the ship will be delayed, resulting in a large cost that must be paid to the owner of the ship. This penalty was negotiated to encourage ship owners to send their ships to Churchill.Results of an initial analysis…arrow_forwardAnswer using the excel screenshot format to do the question.arrow_forwardYou have been hired as a short-term consultant to evaluate Cop waste's Collection operation in the central business district (CBD) due to a disagreement among cop-waste collection staff members and management. The disagreement revolves around the amount of time spent by collectors on off- route activities. Off route activities will take up 15% of each 8 -hour workday for collectors. However, management claims that the collectors are not adhering to the allocated time, while the collectors claim that they spend less than 15% of their time each day. You are given the following information that has been verified by both collectors and management. A hauled container system -conventional type, The average time spent driving from company to the first container is 20 min The average pic up time per container is 6 min v - The average time required to drive between containers is 6 min - The average time required to empty the container at the disposal site is 6 min V - The average round trip…arrow_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