ABC enterprises supply a single product from its two warehouses to three of its customers. The supplies at the warehouses are 120 and 150 units, respectively. The customer demands are 70, 80, and 100 units respectively. The cost of shipping one unit from warehouse i to customer j is as per the following price schedule. Quantity Price Per Unit 0 -25 10$ 25-50 8$ Above 50 6$ For example: If 60 units are being shipped on a particular route, the first 25 units will be charged at the rate of 10 per unit. Similarly, the next 25 units will be charged $8 per unit and the rest at $6 per unit. Develop a linear integer programming model to determine the optimal shipment plan

ABC enterprises supply a single product from its two warehouses to three of its customers. The supplies at the warehouses are 120 and 150 units, respectively. The customer demands are 70, 80, and 100 units respectively. The cost of shipping one unit from warehouse i to customer j is as per the following price schedule. Quantity Price Per Unit 0 -25 10$ 25-50 8$ Above 50 6$ For example: If 60 units are being shipped on a particular route, the first 25 units will be charged at the rate of 10 per unit. Similarly, the next 25 units will be charged $8 per unit and the rest at $6 per unit. Develop a linear integer programming model to determine the optimal shipment plan

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
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 ?
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
Consider a supply chain with a manufacturer (M) and a retailer (R). The manufacturer produces a product A at a cost of c = $50. The manufacturer offers the product to the retailer at a wholesale price of w = $70, and fixes the sale price to p = $90. The market demand is normally distributed with mean of 10,000 units and standard deviation of 1000. Answer the following questions: a. What is the optimal order quantity for the retailer? b. What is the optimal order quantity if the wholesale price is changed to $60? Does the optimal order quantity increase or decrease compared to 1a? Why? c. What is the optimal order quantity if the wholesale price is changed to $80? Does the optimal order quantity increase and decrease compared to 1a? Why? d. If the actual market demand is equal to the mean demand, then what are the profits of the manufacturer and the retailer?
Boston Company use a special part in manufacturing of its finished products. The unit cost thisspecial part is $ 35, and details of its manufacturing cost is as follows. The $35 unit productcost of this part is based on average 25,000 number of parts produced each year.An outside supplier has offered to supply the 25,000 parts at a cost of $30 per part. The specialequipment used to manufacture the above part. This equipment can only be used formanufacturing of this part and if not used it has no resale value.The total amount of general factory overhead, which is allocated based on direct labor-hours,would be unaffected by this decision because it is fixed cost..Suggest the management whether to stop producing internally and buy them from theoutside supplier?Description CAD Direct Materials 10Direct Labor 6Variable overheads…
Total demand for a transportation model is 15 while total supply is 20. Which of the following should be included? a dummy demand of 35 units a dummy demand of 5 units a dummy supply of 5 units a dummy supply of 35 units
She must travel to Kenya to check on quality and transportation. The trip will cost $2,500. The cost of the handbag is $10 and shipping to the United States can occur through the postal system for $2 per handbag or through a freight company which will ship a container that can hold up to 1,000 handbags at a cost of $1,000. The freight company charges $1,000 even if less than 1,000 handbags are shipped. Leslie will sell the handbags to retailers for $20. Assume there are no other costs and benefits. what is the output level that both shipping methods yield same profit? Ho
99. A plastics manufacturer has 1,200 boxes of transparent wrap in stock at one factory and another 1,000 boxes at its second factory. The manufacturer has orders for this product from three different retailers, in quantities of 1,000, 700, and 500 boxes, respectively. The unit shipping costs (in cents per box) from the factories to the retailers are as indicated in the table below. Apply the Vogel's Approximation Method to determine the initial starting solution. Retailer 1 Retailer 3 Factory 1 Factory 2 Retailer 2 13 13 14 11 13 12 A. Z = $276 B. Z = $267 C. Z = $627 D. Z = $ 762
The number of taxicabs in Motorville and the taxicab fares are regulated. The fare currently charged is Rs.500 a ride. Motorville taxicab drivers want to obtain government's permission to raise the fare to increase their revenues and ask you to be their economic adviser. After studying the market, you come up with the following demand schedule for taxicab rides: Price (Rupees per ride) Quantity demanded (rides per month) 300 160 400 120 500 80 600 40 700 0 (i) Calculate the price elasticity of demand for taxicab rides as the fare rises from Rs.500 to Rs.600. Is the demand…
The village board of Park City, Utah, arranges for the clearing of all snow in city streets. Weekly snowfall during the winter is normally distributed with a mean of 10 inches and a standard deviation of 4 inches. The board is considering a long term contract with a snow removal company. The long- term contract costs $1000 per truck per week. Thus, if the board signs a long-term contract for 12 inches, they pay $12,000 per week whether the trucks are used or not. Each truck is capable of clearing 1 inch of snow per week. If snowfall in a week exceeds the quantity that can be handled by the trucks included in the long term lease, the board must make emergency arrangements at a cost of $2,500 for each additional truck brought in. For how many trucks should the board sign a long term contract?
TJ, Inc. makes three nut mixes for sale to grocery chains located in the Southeast. The three mixes, referred to as the Regular Mix, the Deluxe Mix, and the Holiday Mix, are made by mixing different percentages of five types of nuts. In preparation for the fall season, TJ, Inc. just purchased the following shipments of nuts at the prices shown: Type of Nut Shipment Amount (pounds) Cost per Shipment ($) Almond 6,200 7,500 Brazil 7,600 7,225 Filbert 7,600 6,750 Pecan 6,000 7,300 Walnut 7,600 7,875 The Regular Mix consists of 15% almonds, 25% Brazil nuts, 25% filberts, 10% pecans, and 25% walnuts. The Deluxe Mix consists of 20% of each type of nut, and the Holiday Mix consists of 25% almonds, 15% Brazil nuts, 15% filberts, 25% pecans, and 20% walnuts. An accountant at TJ, Inc. analyzed the cost of packaging materials, sales price per pound, and so forth, and determined that the profit contribution per pound is $1.70 for the Regular Mix, $2.05 for the Deluxe Mix, and $2.30…
TJ, Inc. makes three nut mixes for sale to grocery chains located in the Southeast. The three mixes, referred to as the Regular Mix, the Deluxe Mix, and the Holiday Mix, are made by mixing different percentages of five types of nuts. In preparation for the fall season, TJ, Inc. just purchased the following shipments of nuts at the prices shown: Type of Nut Shipment Amount (pounds) Cost per Shipment ($) Almond 6,200 7,500 Brazil 7,600 7,225 Filbert 7,600 6,750 Pecan 6,000 7,300 Walnut 7,400 7,875 The Regular Mix consists of 15% almonds, 25% Brazil nuts, 25% filberts, 10% pecans, and 25% walnuts. The Deluxe Mix consists of 20% of each type of nut, and the Holiday Mix consists of 25% almonds, 15% Brazil nuts, 15% filberts, 25% pecans, and 20% walnuts. An accountant at TJ, Inc. analyzed the cost of packaging materials, sales price per pound, and so forth, and determined that the profit contribution per pound is $1.60 for the Regular Mix, $2.05 for the Deluxe Mix, and $2.20…