Jk. 183. Q. Warehouses A, B, & C supply retailers D, E, & F. The supply capacity of the warehouses, and the requirement of the retailers are indicated in the table below.Also indicated in the table cells is the cost of moving one unit from a particular warehouse to a particular retailer.How much should be supplied from each warehouse to each retailer?Set up the problem as a LP problem and solve it using Solver. The Answer Report must be downloaded. Also the solver dialog box should be populated when I open your submission.DataWarehouse BCRequirementD$3.00$5.00$4.005000Retailers$2.00$4,00$6,005000$5.00$2.00$4.004000Supply Capacity500060003000

A transportation problem is a classic optimization problem in operations research and linear…

Answered: Q. Warehouses A, B, & C supply…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section6.5: Set-covering And Location-assignment Models

Problem 34P

See similar textbooks

Similar questions

Three suppliers A, B and C, each produce road grit which has to be delivered to council depots W, X, Y and Z. The stock held at each supplier and the demand from each depot is known. The cost, in pounds, of transporting one lorry load of grit from each supplier to each depot is also known. This information is given in the table. Suppliers Depot W Depot X Depot Y Depot Z Stock (Lorry Loads) Supplier A 180 110 130 290 14 Supplier B 190 250 150 280 16 Supplier C 240 270 190 120 20 Demand (Lorry Loads) 11 15 14 10 50 Use VAT method to supply out all the stocks
There are four factories producing a product that is needed in six destinations. In the table on the left there are the number of products available at the factories, their production costs. For the desinations the selling price of an item and the maximum needed quantity in each destination is given. In the framed boxes the transporation cost of one item from factory to destination are given. Find the number of items to ship
Jing's Pizza wants to know to whether customers will buy the new Fancy Feijoa pizza. You are the owner's son/daughter and your mum (the owner) knows you have just completed a paper in business analytics. She asks (or tells!) you to come up with a plan to answer her question. Luckily, she has a database of frequent customers in an excel spreadsheet. You go through your notes and decide that you will use clustering and find groups of similar customers in her spreadsheet. 1. Identify the data that might use for customers who will buy the new Pizza. 2. What plan or alternative plan might use to sell the pizza?11:35 AM
Problem S11. More Info The food items listed storage location for e best Click the icon to Click the icon to ITEM TRIPS PER VOYAGE AREA NEEDED (BLOCKS) A 6 В 24 Fill in the table below 40 D 10 E 13 F 12 30 More Info 1 3 7 11 13 15 17 Kitchen Aisle 6. 8. 10 12 14 16 18 Enter Print Done part Cloor A|| Chook Apowor N O N 21 23
Two poultry farms supply companies with chicken feeds. The unit costs of shipping from the farms to the companies are given on the table below. The farm's goal is to minimize the cost of meeting customer's demands. For questions a and b; (a) Generate a mathematical model for finding the least cost way of shipping chicken feeds from the farms to the companies. (b) if the demand of company number 2 increased by 3 units. By how much would the costs increase? Show solution. (c). Solve the total cost using the solver add-in in excel.
A company has three existing warehouses to which it will ship furniture from a new factory whose location must be decided. The factory will receive raw materials from its wood supplier and fabric supplier. The annual number of shipments, shipment costs and the location of the suppliers and warehouses are shown below Existing facilities Annual L to or from fact cost Coordinate location Wood supplier 120 10 (100, 400) Fabric supplier 200 10 (800,700) Ware h 1 61 10 (300, 600) Ware h 2 40 10 (200, 100) Ware h 3 70 10 (600, 200) Using the median load answer the following questions –Where the factory should be located to minimize annual transportation cost –What will be the minimum annual transportation cost
1 3 Supply: 4 1 60 40 28 10 120 2 50 30 30 20 150 3. 43 20 20 10 160 Demand: 100 100 100 130 The transportation table of a company that sends products is given below. According to the least cost method what is the value for the first cell to be assigned ?
The following table presents cost, capacity, and demand data for a transportation problem in Stephanie Robbin’s furniture company. Set up the appropriate transportation table and find the optimal solution using Excel's solver. From/To 1 2 3 Supply A 30 10 5 20 B 10 10 10 30 C 20 10 25 75 Demand 40 60 55 a. Is the problem balanced? [ Select ] ["Yes", "it is balanced", "No", "cannot determine"] , If not, where? [ Select ] ["Neither", "Supply", "Demand"] , and by how much? [ Select ] ["0", "40", "30", "25"] b. What is the optimal cost? $ [ Select ] ["2,500", "1,100", "1,275", "1,300"] c. Were you able to meet all demand requirement? [ Select ] ["no", "cannot determine based on the information given", "yes"] If not, which destination (s) was/were not met? [ Select ] ["none, all destinations were met based on supply and demand being equal", "destination 3 by 30 units", "destination 2 by 30 units", "destination 1 by 25 units…
The distribution of daily demand for rental trucks at a vehicle rental company is shown in the following table: Relative Frequency Demand 0.07 0 0.14 1 0.15 2 0.14 3 0.12 4 0.08 5 0.3 6 Trucks are rented by the day only and the company makes $14 per rented truck per day. The rental company keeps four trucks at this location. Assuming that the stocking decision is optimal, what is the implied range of excess cost per truck per day? a. 0 and 186 b. 8.58064 and 14 c. 14 and 24.8889 d. 6 and 8.58064 e. 34.2759 and 79.3333
A product is produced at three plants and shipped to three warehouses. Plant capacity, warehouse demands and transportation costs per unit are shown in the table. Plant Warehouse A B C Plant Capacity 1 20 16 26 500 2 10 14 8 500 3 12 18 6 400 Warehouse Demands 200 600 600 a) Find an initial feasible solution and calculate the cost for this solution. b) If improvement can be made, make one step improvement to the solution in part a, and calculate the cost for the improved solution.
Use the table below to answer the following question(s). Fiberia Accessories, a clothing retailer, is planning to introduce a new line of sweaters as part of the winter collection for $65 with an inventory of 1500. The main selling season is 60 days between November and December. The store then sells the remaining units in a clearance sale at 65 percent discount. Out of the 60 main retail days, Fiberia sells the sweaters at full retail price for only 45 days, while giving a discount of 25 percent for the remaining 15 days. The demand functions a, and b are given as 79.5 and 1.1 respectively. Marked Down Pricing Model for Fiberia Accessories's new sweater Data Retail Price Inventory Selling Season (days) Days at Full Retail Intermediate Markdown Clearance Markdown Demand Function A B $65 1500 60 45 25 percent |65 percent 79.5 1.1 Compute the everyday sales throughout the discount sales period.
ABC pharmaceutical Company has four factories that ship supplies to four warehouses. The company’s management hires you as a consultant to determine a minimum-cost shipping plan for its monthly output to the warehouses. Factory capacities, warehouse demands, and shipping cost per box are shown below. Factory Supply or capacity (boxes) Warehouse Demand (boxes) Richmond 60 Chicago 100 Santa Fe 80 Jacksonville 90 Austin 120 Huntville 50 Vacaville 90 Fresno 70 Shipping Costs per box (In Dollars) From To Chicago To Jacksonville To Huntsville To Fresno Richmond 35 35 46 60 Santa Fe 65 40 35 25 Austin 50 50 80 90 Vacaville 40 40 66 75 Draw a diagram by showing factories, warehouses, and connecting arcs. Define variables, write the objective function and constraints.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS