Question

In: Operations Management

A company needs to open new warehouses to distribute products to the customers in two different...

A company needs to open new warehouses to distribute products to the customers in two different regions. The company has to decide where to open warehouses and in which capacity should be preferred for them. Past data shows that average daily demand of customers are 1000 units for the customers in region 1 and 1200 units for the customers in region 2. There are two possible locations to open a warehouse. The daily equivalent setup cost of opening a warehouse at location alternative A requires $1,000 for a warehouse with delivery capacity of 1000 units per day and it requires $1,500 for a warehouse with delivery capacity of 2200 units per day. The daily equivalent setup cost of opening a warehouse at location alternative B is $550 for a warehouse with a maximum capacity of 1200 units per day. Delivery costs are as follows: $1 from a warehouse located at A to the customers in region 1; $1.5 from a warehouse located at A to the customers in region 2; $1.5 from a warehouse located at B to the customers in region 1; $1 from a warehouse located at B to the customers in region 2. Develop a linear mathematical model for minimizing total daily equivalent cost of distribution system

Solutions

Expert Solution

Linear Programming model is as follows:

Let A1 = 1, if a warehouse is opened at location A with delivery capacity of 1000 units per day, otherwise A1 = 0

A2 = 1, if a warehouse is opened at location A with delivery capacity of 2200 units per day, otherwise A2 = 0

B = 1, if a warehouse is opened at location B with delivery capacity of 1200 units per day, otherwise B = 0

Xij be the quantity to be shipped from warehouse at location i to region j, where i={a,b} and j={1,2}

Minimize 1000A1+1500A2+550B+1Xa1+1.5Xa2+1.5Xb1+1Xb2

s.t.

Xa1+Xa2-1000A1-2200A2 <= 0

Xb1+Xb2-1200B <= 0

Xa1+Xb1 = 1000

Xa2+Xb2 = 1200

Xij >= 0

A1, A2, B = {0,1}

--------------------

Solution using LINGO is as follows:

Result:

Total cost = $ 3,750


Related Solutions

The distribution system for the Herman Company consists of three plants, two warehouses, and four customers....
The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit (in $) from each plant to each warehouse are as follows:                        Warehouse Plant           1                       2            Capacity 1                4                        7               450 2                8                         5              600 3                5                         6               380                             Customer Warehouse          1                        2                            3                             4 1                            6                       4                            8                             4 2                           3                         6                            7                             7 Demand                300                     300                         300                        400 Formulate the linear programming model to minimize the cost of shipping...
Your company needs to raise $46 million to finance a new factory. You’re evaluating two different...
Your company needs to raise $46 million to finance a new factory. You’re evaluating two different 25-year bonds to raise these funds: a coupon bond with an annual coupon rate of 7 percent; and a zero coupon bond. Your company’s tax rate is 30 percent. Both bonds will have a par value of $1,000, and a  required annual return of 7 percent with semi-annual compounding. a-1. How many of the coupon bonds would you need to issue to raise the $46...
Your company needs to raise $44 million to finance a new factory. You’re evaluating two different...
Your company needs to raise $44 million to finance a new factory. You’re evaluating two different 20-year bonds to raise these funds: a coupon bond with an annual coupon rate of 8 percent; and a zero coupon bond. Your company’s tax rate is 40 percent. Both bonds will have a par value of $1,000 and a  required annual return of 8 percent with semi-annual compounding. a-1. How many of the coupon bonds would you need to issue to raise the $44...
A petroleum company fills large drums of oil to distribute to customers. In a random sample...
A petroleum company fills large drums of oil to distribute to customers. In a random sample of 35 drums, the mean number of gallons of oil is 202.52 and the standard deviation is 1.23. The company would like to ensure its customers that the average number of gallons of oil in the drums that the company distributes is greater than 200 gallons. We will conduct a statistical test to evaluate this claim. Formulate the null hypothesis (in words) to evaluate...
Products often service different needs, appeal to different buyers, or are perceived differently in different markets....
Products often service different needs, appeal to different buyers, or are perceived differently in different markets. Consider a good or service that is sold in your country and another using different marketing strategies in each. One of the countries must be the countries home market. Describe the factors to consider in developing international product strategies. Explain the factors to consider when designing international distribution strategies.
A company wishing to export its products into a new country needs to properly understand its...
A company wishing to export its products into a new country needs to properly understand its pricing strategy. What processes can a company explore in order to plan its pricing strategy? Briefly explain why and the implications for getting it correct and the results of being incorrect.
A politician wants to open a new park in the middle of town. She needs to...
A politician wants to open a new park in the middle of town. She needs to make sure that the local community supports the plan. A nearby town recently found that 60% of the community supported a similar plan and she believes that the same proportion will support it in her district. She takes a random survey of 40 people and find that the 10 people are supportive of her plan. She wants to be certain that this is not...
Collier Company installs carpet.  Since each customers’ needs are different, Collier Company uses job costing.  Upon accepting a...
Collier Company installs carpet.  Since each customers’ needs are different, Collier Company uses job costing.  Upon accepting a customer’s order, the carpet selected is cut at the warehouse to correct dimensions and then the carpet is delivered and installed at the customer’s facility.  Collier has decided to use a predetermined overhead rate based on machine hours.  The estimated annual overhead is $585,000 with an estimated 2,600 machine hours.  The following information relates to Job 101: direct materials      $10,000 direct labor cost       7,000 labor hours                40 machine hours               8 A....
name a product that might be used by customers with very different needs. Describe a need...
name a product that might be used by customers with very different needs. Describe a need profile for at least three customer groups for this product. What other products or services could be offered to each of these groups to increase their value to an enterprise?
Magnum Company manufactures two different products, A and B. In the past, the company has allocated...
Magnum Company manufactures two different products, A and B. In the past, the company has allocated its plant wide manufacturing overhead costs based on direct labour hours. The new controller suggests that the company consider assigning overhead costs to the products using either traditional activity-based costing or time-determined activity-based costing. After studying the manufacturing activities and costs, the controller collected the following data for last year: Item Product A Product B Units produced and sold 3,000 5,000 Direct labour hours...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT