Question: using excel solver Consider a distribution planning problem with 5 warehouses (W1 to W5) and 10 retailers (R1 to R10). Warehouse capacity is 2000,3000,3000, 2000,

using excel solver using excel solver Consider a distribution planning problem with 5 warehouses (W1

Consider a distribution planning problem with 5 warehouses (W1 to W5) and 10 retailers (R1 to R10). Warehouse capacity is 2000,3000,3000, 2000, and 3200 respectively for W1 to W5. Retailer demands are (from R1 to R10): 850,600,850,1900, 3100,250,350,400,900,1400. The unit shipping costs (in dollars) between the warehouses and retailers is given in the table below. Determine the optimum distribution plan that will minimize the total cost (formulate and solve, e.g., using Excel solver)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

2. Consider a distribution planning problem with 3 warehouses (W1 to W3) and 8 retailers (R1 to R8). Warehouse capacity is 4000, 5000, and 3000 respectively for W1 to W3. Retailer demands are (from...

PRODUCTION SYSTEMS AND FACILITIES PLANNING (retim Sistemleri ve Tesis Planlamas) Project Study: Warehouse Location The Company 304 has 2 production plants producing dairy products, one in Afyon and...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

B15 X V fx 12000 B C D E G H K L M N O P Q R S T U V W X Y Z AA Plant Decision A company currently ships its product from 5 plants to 4 warehouses. It is considering closing one or more plants to...

PLEASE COMPLETE NO LATER THAN 10/28 @3:30PM Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

Developing an Aggregate Plan - Bradford Manufacturing The Situation You are the operations manager for a manufacturing plant that produces pudding food products. One of your important...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

This is a Red Tomato Aggregate Planning question. In class the professor solved it using the solver in excel, and I would appreciate someone showing me how to use that software to solve this problem...

Analytics Exercise: Developing an Aggregate Plan-Bradford Manufacturing The Situation You are the operations manager for a manufacturing plant that produces pudding food products. One of your impor-...

A force applied by an engine of a train of mass 2.05 106 X kg changes its velocity from 5 m/s to 25 m/s in 5 minutes. The power of the engine is - (a) 1.025 MW(b) 2.05 MW (c) 5 MW (d) 0.5 MW

Assuming the target reflects 10% of the incident power, the working frequency of an ultrasound range finder system with transmitter power 1.5kW and receiver sensitivity 0.15mW operating in medium of...

List four factors a professional accountant must take into account to exercise ethical professional judgement. 2 ) When might the continuity assumption not be valid? 3 ) How does relevance relate to...

Premise: Using a dictionary and list, create a set of key / value pairs that consists of a musical database. The key / value pairs should consist of Artist Name: Song Names pattern. For example, EACH...