Question

In: Operations Management

•VOOM HAS FOUR WAREHOUSES 1, 2,3, AND 4. VOOM NEEDS TO SUPPLY 100 TONS TO RETAILER...

•VOOM HAS FOUR WAREHOUSES 1, 2,3, AND 4. VOOM NEEDS TO SUPPLY 100 TONS TO RETAILER P, 300 TONS TO RETAILER Q, AND 300 TONS TO RETAILER R.  THE COST OF DELIVERY FROM EACH WAREHOUSE TO RETAILERS IS PROVIDED IN THE FOLLOWING TABLE. WHILE EACH OF THE WAREHOUSES HAS AN INVENTORY OF 400 TONS THEY CAN SUPPLY, R REQUIRES THAT EVERY WAREHOUSE SUPPLIES AT LEAST 25 TONS TO R.

    THERE IS A SPECIAL ARRANGEMENT BETWEEN WAREHOUSE 4 AND R WHICH REQUIRES THAT WAREHOUSE 4 HAS TO SUPPLY EXACTLY 100 TONS TO R. ON THE OTHER HAND, P CANNOT TAKE MORE THAN 50 TONS EACH FROM WAREHOUSE 1 AND 2.   

•USE LINEAR PROGRAMMING TO PROVIDE VOOM A PLAN THAT WILL KEEP THEIR TRANSPORTATION COST TO THE MINIMUM.  

Delivery cost/ton($)

P

Q

R

Warehouse 1

$    14.00

$    30.00

$    20.00

Warehouse 2

$    30.00

$    40.00

$    15.00

Warehouse 3

$    18.00

$    20.00

$    14.00

Warehouse 4

$    15.50

$   12.00

$    18.00

Please show on excel and steps

Solutions

Expert Solution

Solver model

The Green colored box is the optimal production plan

Solver formula

Solver window input


Related Solutions

1)      Surrounding the Great Lake are four paper-mills, each producing 100 tons of paper per...
1)      Surrounding the Great Lake are four paper-mills, each producing 100 tons of paper per year. The paper is sold on the national market for $2 per ton, and including all the costs of production, costs for each firm are $1 per ton. Thus each firm earns a pure economic profit of $1 per ton. These paper mills require fresh water to operate and also produce a pollutant, which they dump into the Great Lake. New paper mills can...
The helicopter shown in the figure below has a mass of 12 tons and it needs...
The helicopter shown in the figure below has a mass of 12 tons and it needs to rotate its 14 meter blades (diameter of the blades = 14 meters) at 670 rpm just to hover (stand still in mid air) without any additional load. The air flow caused by the rotation of the helicopter blades may be modeled as a moving cylindrical body of air having a 14 meter diameter. The average velocity of the airflow of that cylindrical air-body...
1. Insomnia, a coffee bean broker, has 4 warehouses from which it can ship to 3...
1. Insomnia, a coffee bean broker, has 4 warehouses from which it can ship to 3 main buyers. The demand for coffee beans at buyer 1 is 800 pounds, at buyer 2 it is 1000, and at buyer 3 it is 500. Each warehouse holds an inventory of 2000 pounds of coffee beans. The warehouses can only ship coffee beans in full pounds. Given the transportation costs below, they need to determine how product should be shipped between the warehouses...
Surrounding the Great Lake are four paper-mills, each producing 100 tons of paper per year. The...
Surrounding the Great Lake are four paper-mills, each producing 100 tons of paper per year. The paper is sold on the national market for $2 per ton, and including all the costs of production, costs for each firm are $1 per ton. Thus each firm earns a pure economic profit of $1 per ton. These paper mills require fresh water to operate, and also produce a pollutant called gunk, which they dump into the Great Lake. New paper mills can...
Surrounding the Great Lake are four paper-mills, each producing 100 tons of paper per year. The...
Surrounding the Great Lake are four paper-mills, each producing 100 tons of paper per year. The paper is sold on the national market for $2 per ton, and including all the costs of production, costs for each firm are $1 per ton. Thus each firm earns a pure economic profit of $1 per ton. These paper mills require fresh water to operate, and also produce a pollutant called gunk, which they dump into the Great Lake. New paper mills can...
1. Access Maslow's Hierarchy of Needs, and in relation to this, list four (4) environmental influences...
1. Access Maslow's Hierarchy of Needs, and in relation to this, list four (4) environmental influences that have a positive influence on early brain development. 2. The following biological and environmental influences can have a negative impact on children’s development and learning. Provide an explanation / reason for each of the following possible influences. (References to be provided): a. Poor diet b. Lack of play c. Limited stimulation on brain development d. Lack of materials or resources e. Inconsistent or...
1. A cosmetic product retailer needs to create a database to keep track of the information...
1. A cosmetic product retailer needs to create a database to keep track of the information for its business operations. The company has a web site that posts all its products. The product information includes product ID, product name, description, and unit price. The company also needs to keep track of customers’ information, including customer names, their shipping addresses, and the email address. The company creates an account for each customer for identification and tracking purpose. A customer can purchase...
There are four theories of motivation: 1. hierarchy-of-needs theory 2. two-factor theory 3. expectancy theory 4....
There are four theories of motivation: 1. hierarchy-of-needs theory 2. two-factor theory 3. expectancy theory 4. equity theory Which one makes the most intuitive sense to you? Give an example of this theory in your life.    Why do you find this motivation theory appealing?
A company has two warehouses A and B, and three retail outlets 1, 2 and 3....
A company has two warehouses A and B, and three retail outlets 1, 2 and 3. The warehouse capacities, retail outlet demands, and per-unit shipping costs ($) are shown in the table below. Formulate a linear programming (LP) model of this transportation problem with the objective of minimizing total shipping cost.                    Retail Outlets Warehouses    1       2     3 Total Supply      A    $5 $8 $3 500     B $7 $4 $6 250             Total Demand 300 400...
. (1) A man has a 4-sided (tetrahedral) die, with four faces, 1, 2, 3, and...
. (1) A man has a 4-sided (tetrahedral) die, with four faces, 1, 2, 3, and 4. He rolls it 12 times. (a) Given that for each roll of the die, the probability of rolling a 4 is 1/4 and the probability of not doing so is 3/4, compute the following probabilities P(x = x0),where x is the number of times that the man rolls a 4 among the 12 trials. (b) What is the average value of x? What...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT