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
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help.
Answer the following question:
Which of these is not an element of the objective function?
Group of answer choices
4D-T1
600T1
9T2-G
3C-T2
Plz do fast asap
Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice.
What is the objective function?
Group of answer choices
Max Z = $3AD + $3AE + $4BD + $3BE + $5CD + $3CE + $4DF + $4DG + $4DH + $10EF + $9EG + $8EH
Min Z = $3AD + $3AE + $4BD + $3BE + $5CD + $3CE + $4DF + $4DG + $4DH + $10EF + $9EG + $8EH
Min Z = $3AD + $3BE + $5CD + $3CE…
Companies A, B, and C supply components to three plants (F, G,
and H) via two crossdocking facilities (D and E). It costs $4 to ship
from D regardless of final destination and $3 to ship to E
regardless of supplier. Shipping to D from A, B, and C costs $3, $4,
and $5, respectively, and shipping from E to F, G, and H costs $10,
$9, and $8, respectively. Suppliers A, B, and C can provide 200,
300 and 500 units respectively and plants F, G, and H need 350,
450, and 200 units respectively. Crossdock facilities D and E can
handle 600 and 700 units, respectively. Logistics Manager, Aretha
Franklin, had previously used "Chain of Fools" as her supply chain
consulting company, but now turns to you for some solid advice.
Set up the solution in Excel and solve with Solver. What are total
costs?
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
- Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City 50,000 Fort Worth 70,000 San Diego 60,000 Minneapolis 80,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder 100,000 Macon 100,000 Gary 150,000 Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) SHIPPED TO PRODUCED AT NEW YORK CITY FORT WORTH SAN DIEGO MINNEAPOLIS Boulder 7 11 8 13 Macon 20 17 12 10…arrow_forwardBindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City 50,000 Fort Worth 70,000 San Diego 60,000 Minneapolis 80,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder 100,000 Macon 100,000 Gary 150,000 Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) PRODUCED AT SHIPPED TO NEW YORK CITY FORT WORTH SAN DIEGO MINNEAPOLIS Boulder 7 11 8 13 Macon 20 17 12 10 Gary 8 18 13 16 Given…arrow_forwardBindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City 50,000 Fort Worth 70,000 San Diego 60,000 Minneapolis 80,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder 100,000 Macon 100,000 Gary 150,000 Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) SHIPPED TO PRODUCED AT NEW YORK CITY FORT WORTH SAN DIEGO MINNEAPOLIS Boulder 7 11 8 13 Macon 20 17 12 10…arrow_forward
- Joburg Logistics (JL), a distributor of various products in Polokwane receives their products from suppliers in Durban, Cape Town, and Johannesburg. The company's management is concerned with the supply cost of a certain product that is supplied by a manufacturer in Durban. Currently JL has a contract with Transnet Freight Rail (TFR) for the transport of the orders from Durban. The following are the rail rate and transit time: Transit time (rail) Rail rate 5 days R2.75/unit The impact on the transport and inventory carrying cost because of this arrangement is a concern of the logistics director, Mrs Micky. As a result, Mrs Micky has requested the logistics manager to evaluate the option to use a 3PL service provider for the shipment from Durban to Johannesburg. The logistics manager has identified a certain 3PL company that has the capacity to perform this contract. However, in order to provide a transport rate, the 3PL company required the size and frequency of orders. JL currently…arrow_forwardEarth Resources Corporation is a multinational company engaged in steamfield development and power plant construction through the government's use of build-operate- transfer (BOT) contracts. Recently, the company has been awarded contracts and has to start drilling operations at four (4) new geothermal sites in the Philippines. In order to ensure that drilling operations are on schedule and in accordance with the provisions of the contract, Earth Resources must send a team of two (2) drilling engineers to each site. Currently, they have eight (8) drilling engineers at various sites where the drilling is almost completed. The chief executive officer (CEO) wants to mobilize all the eight engineers to the four new sites in such a way that the total costs involved is minimized. The CEO requested the company's chief accountant, Ms. Debbie Castro, to prepare a summary of the estimated mobilization costs from the engineer's present locations to their probable new assignments. accomplished…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
- Cargo 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_forwardAbu Dhabi municipality is given an assignment to ensure provision of enough water for residents of the Abu Dhabi city. The water is purified in a large water treatment plant (node 1) and then is sent via a water supply network to the Abu Dhabi city (node 14). As shown in the below water supply network, the capacity of each water pipeline (arc) is shown in million liters per hour. For example, the hourly water flow from node 1 to node 2 is four million liters, and from node 2 to node 1 is zero million liters. a) The municipality is interested to find out how much water (in million liters per hour) can be sent from the water treatment plant to the Abu Dhabi city via this water supply network. Determine it. b) Due to a maintenance problem both nodes 10 and 11 need to be taken offline. Therefore, these nodes cannot flow any water in and out. How this problem impacts the network maximum flow capacity? Please include algebraic method and excel solver.arrow_forwardDM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania. They have decided to build a new distribution warehouse in the state of New York to help serve the growing demand in that market. They have four major customers located in Buffalo, Syracuse, Albany, and New York City. Though New York City is the largest market, it also has the greatest competition and DMOP is not a major player there. When DMOP ships an order to a customer they use their own small fleet of two trucks to deliver, so the cost of delivery is essentially the same for a full or partially full truck. The expected number of annual shipments to each city and their coordinates on an x, y grid is shown in the following table. CITY Buffalo Syracuse Albany New York x-COORDINATES 370 1,465 2,345 2,320 y-COORDINATES 895 945 675 70 NUMBER OF SHIPMENTS 96 100 140 80 Use the centroid method to recommend a location for the new warehouse for DMOP (Round your answers to 1 decimal…arrow_forward
- Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country. New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) Macon Gary PRODUCED AT NEW YORK CITY Boulder 12 From/To Boulder Macon Gary Requirements 75,000 45,000 60,000 50,000 100,000 145,000 65,000 Candidate Solution Boulder Macon Gary Total supplied Profit 24 11 Boulder Macon…arrow_forwardTransportation Problem (Solve using excel): Acme Block Company has orders for 80 tons of concrete blocks at three suburban locations as follows: Northwood -- 25 tons, Westwood -- 45 tons, and Eastwood -- 10 tons. Acme has two plants, each of which can produce 50 tons per week. Delivery cost per ton from each plant to each suburban location is shown in the attached image. How should end of week shipments be made to fill the above orders?arrow_forwardUse the table below to answer the following question(s). The Riviera Transport Company (RTC) produces car accessories at two plants: Dallas and Atlanta. They ship them to major distribution centers in Houston, San Jose, Jacksonville, and Memphis. The accounting, production, and marketing departments have provided the information in the table below, which shows the unit cost of shipping between any plant and distribution center, plant capacities over the next planning period, and distribution center demands. RTC's supply chain manager faces the problem of determining how much to ship between each plant and distribution center to minimize the total transportation cost, not exceed available capacity, and meet customer demand. Assume Xij = amount shipped from plant i to distribution center j, where i = 1 represents Dallas, i = 2 represents Atlanta, j = 1 represents Houston, and so on. Transportatio In Model Data Distribution Center Plant Houston Memphis 18.48 Dallas 13.00 Atlanta 10.75…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,