A Power company has three plants that supply the need of three cities (as shown in Table 2). Each plant can supply the following numbers of kWh of electricity. Plant 1, 2 and 3 can supply 30, 40 and 50 million kWh, respectively. The demand at city 1, 2 and 3 are 20, 40 and 40, respectively. The cost of sending electricity from each plant to each city depends on the distance the electricity must travel. Table 2: Transportation costs From City 2 11 To City 1 10 City 3 16 Plant 1 Plant 2 14 11 Plant 3 7 10 13

A Power company has three plants that supply the need of three cities (as shown in Table 2). Each plant can supply the following numbers of kWh of electricity. Plant 1, 2 and 3 can supply 30, 40 and 50 million kWh, respectively. The demand at city 1, 2 and 3 are 20, 40 and 40, respectively. The cost of sending electricity from each plant to each city depends on the distance the electricity must travel. Table 2: Transportation costs From City 2 11 To City 1 10 City 3 16 Plant 1 Plant 2 14 11 Plant 3 7 10 13

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

Cutey Barber Salon Cutey Barber Salon is a trendy barber salon that is located in a densely populated city called Maple. Demand for the services offered by the salon is fairly high. It offers services such as haircuts, hair styling, scalp massaging and conditioning treatment, straight razor and wet shave, beard sculpting, facials and hair colouring. In addition to these services provided, the salon sells premium hair products to customers. The salon has the ability to produce a maximum of 20,000 haircuts and hairstyling per year. Demand for haircuts and hairstyling over the last five years can be seen in the following table:- Year Demand for haircuts and hairstyling 2017 11,500 2018 12,200 2019 13,400 2020 14,000 2021 14,500 Although the business does not have a written vision and mission statement, it is clear in the minds of management what they want to achieve and what they would like to be in the future. Currently, customers can walk in at…
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…
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
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best. D Demand Forecast Component A B C Time Standard Processing Setup (hr/unit) (hr/lot) 0.04 1.0 0.20 4.4 0.05 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected Optimistic Pessimistic 16,000 10,000 18,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next…
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best. i Demand Forecast Component A B C Time Standard Processing (hr/unit) 0.04 0.20 0.05 Setup (hr/lot) 1.0 4.4 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected 16,000 17,000 10,000 12,000 18,000 24,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next…
The 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?
The City of Boston is taking bids on four construction projects. Four companies have made the bids as shown in the following table: Company 1 2 3 4 Bids Project 1 Project 2 Project 3 Project 4 $4000 $5000 $4000 - $3000 $2000 $4000 $4000 $5000 a. Each bidder can be assigned only I route. Use the assignment method (Hungarian Method) to minimize the cost of assigning the four project contracts.
Solve the following problem: The Krampf Lines railway company specializes in coal handling. On Saturday, Krampf had empty cars at the following towns in the quantities indicated: Town Supply of cars Morgantown 35 Youngstown 60 Pitsburg 25 By Monday, the following towns will need cars as follows: Town Demand for cars Coal Valley 30 Coal town 45 Coal junction 25 Coalsburg 20 The result is shown in the table below. To From Coal Valley Coal town Coal junction Coalsburg Morgantown 50 30 60 70 Youngstown 20 80 10 90 Pitsburg 100 40 80 30 Required: Minimize total miles over which cars are moved to new locations regarding the following: Formulate as a linear programming. Use North-West corner method to obtain the total shipment cost of coal cars.
The Makonsel Company is a fully integrated company that both produces goods and sells them at its retail outlets. After production, the goods are stored in the company's two warehouses until needed by the retail outlets. Trucks are used to transport the goods from the two plants to the warehouses, and then from the warehouses to the three retail outlets. Using units of full truckloads, the following table shows each plant's monthly output, its shipping cost per truckload sent to each warehouse, and the maximum amount that it can ship per month to each warehouse. To Unit Shipping Cost Shipping Capacity From Warehouse 1 Warehouse 2 Warehouse 1 Warehouse 2 Output Plant 1 $425 $560 125 150 200 Plant 2 $510 $600 175 200 300 For each retail outlet (RO), the next table shows its monthly demand, its shipping cost per truckload from each warehouse, and the maximum amount that can be shipping per month from each warehouse. To Unit Shipping Cost Shipping Capacity From RO1 RO2 RO3 RO1 RO2 RO3…
A company manufactures a product at its plants in C and D; then ships the product to its four distribution centers in K, L, M, and N. The transportation costs per unit (in dollars per unit) are as follows: from C to K, L, M, and N: 10, 5, 9, and 20. from D to K, L, M, and N: 2, 8, 30, and 10. The monthly demand from K, L., M, and N are: 3000, 1400, 4000, and 1200 units, respectively. On the other hand, the monthly capacity at plants C and D are: 4100 and 5800 units, respectively. Develop a linear programming model that can be used to determine the distribution plan that will minimize total monthly transportation cost. Use Excel Solver to find the optimal solution The optimal solution shows that the total monthly transportation cost is dollars.
Morgan Trucking Company operates a special pickup and delivery service between Chicago and six other cities located in a four-state area. When Morgan receives a request for service, it dispatches a truck from Chicago to the city requesting service as soon as possible. With both fast service and minimum travel costs as objectives for Morgan, it is important that the dispatched truck take the shortest route from Chicago to the specified city. Assume that the following network (not drawn to scale) with distances given in miles represents the highway network for this problem. Chicago 1 36 31 21 2 3 9 10 11 21 4 13 Find the shortest-route distance from Chicago to node 6. 6 5 6 16 6 21 7