Kelly Foods has two plants and ships canned vegetables to customers in four cities The cost of shipping one case from a plant to a customer is givern in the accompanying table The plant in Akron has a capacity of 3,500 cases per week and the Evansville plant can produce 4,200 cases per week. Customer orders for the next week are as follows: Chicago: 1, 100 cases; Cincinnati 1,900 cases, Indianapolis 2,400 cases; Pittsburgh: 1,500 cases. Find the minimum-cost shipping plan. E Click here to view the cost of shipping data Complete the table below to indicate the number of cases sent from each plant to each customer to minimize the cost, and then give the total cost (Type integers or decimals. Do not round.) Plant/Customer Chicago Cincinnati Indianapolis Pittsburgh Akron Cost of Shipping Data Evansville Total cost = s Plant Customer Chicago Cincinnati Indianapolis Pittsburgh Akron $1.73 $2.32 $2 45 $2 16 S2 92 Evansville $1.92 $2.35 $1.69

Kelly Foods has two plants and ships canned vegetables to customers in four cities The cost of shipping one case from a plant to a customer is givern in the accompanying table The plant in Akron has a capacity of 3,500 cases per week and the Evansville plant can produce 4,200 cases per week. Customer orders for the next week are as follows: Chicago: 1, 100 cases; Cincinnati 1,900 cases, Indianapolis 2,400 cases; Pittsburgh: 1,500 cases. Find the minimum-cost shipping plan. E Click here to view the cost of shipping data Complete the table below to indicate the number of cases sent from each plant to each customer to minimize the cost, and then give the total cost (Type integers or decimals. Do not round.) Plant/Customer Chicago Cincinnati Indianapolis Pittsburgh Akron Cost of Shipping Data Evansville Total cost = s Plant Customer Chicago Cincinnati Indianapolis Pittsburgh Akron $1.73 $2.32 $2 45 $2 16 S2 92 Evansville $1.92 $2.35 $1.69

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 61P

See similar textbooks

Similar questions

Solve Problem 1 with the extra assumption that the investments can be grouped naturally as follows: 14, 58, 912, 1316, and 1720. a. Find the optimal investments when at most one investment from each group can be selected. b. Find the optimal investments when at least one investment from each group must be selected. (If the budget isnt large enough to permit this, increase the budget to a larger value.)
Irwin Textile Mills produces two types of cotton cloth – denim and corduroy. Corduroy is a heavier grade of cotton cloth and, as such as, requires 8 pounds of raw cotton per yard, whereas denim requires 5.5 pounds of raw cotton per yard. A yard of corduroy requires 3.6 hours of processing time; a yard of denim requires 8 hours. Although the demand for denim is practically unlimited, the maximum demand for corduroy is 600 yards per month. The manufacturer has 6,500 pounds of cotton and 3,000 hours of processing time available each month. The manufacturer makes a profit of $3.0 per yard of denim and $4.0 per yard of corduroy. The manufacturer wants to know how many yards of each type of cloth to produce to maximize profit. How much extra cotton, processing time, and the demand for corduroy are left over at the optimal solution after formulating a linear programming model? What is the effect on the optimal solution if the profit per yard of denim is increased from$3.0 to $4.0?
Irwin Textile Mills produces two types of cotton cloth – denim and corduroy. Corduroy is a heavier grade of cotton cloth and, as such as, requires 8 pounds of raw cotton per yard, whereas denim requires 5.5 pounds of raw cotton per yard. A yard of corduroy requires 3.6 hours of processing time; a yard of denim requires 8 hours. Although the demand for denim is practically unlimited, the maximum demand for corduroy is 600 yards per month. The manufacturer has 6,500 pounds of cotton and 3,000 hours of processing time available each month. The manufacturer makes a profit of $3.0 per yard of denim and $4.0 per yard of corduroy. The manufacturer wants to know how many yards of each type of cloth to produce to maximize profit. Formulate a linear programming model for this problem. Solve the problem by using the
Irwin Textile Mills produces two types of cotton cloth—denim and corduroy. Corduroy is a heavier grade of cotton cloth and, as such, requires 7.5 pounds of raw cotton per yard, whereas denim requires 5 pounds of raw cotton per yard. A yard of corduroy requires 3.2 hours of processing time; a yard of denim requires 3.0 hours. Although the demand for denim is practically unlimited, the maximum demand for corduroy is 510 yards per month. The manufacturer has 5,500 pounds of cotton and 3,000 hours of processing time available each month. The manufacturer makes a profit of $2.25 per yard of denim and $3.10 per yard of corduroy. The manufacturer wants to know how many yards of each type of cloth to produce to maximize profit. Due to the market change, the demand for corduroy has increased to 600 yards per month. How would this affect Irwin Textile Mills' profits? Question 2 options: Cannot decide. Profits would decrease. Profits…
Irwin Textile Mills produces two types of cotton cloth—denim and corduroy. Corduroy is a heavier grade of cotton cloth and, as such, requires 7.5 pounds of raw cotton per yard, whereas denim requires 5 pounds of raw cotton per yard. A yard of corduroy requires 3.2 hours of processing time; a yard of denim requires 3.0 hours. Although the demand for denim is practically unlimited, the maximum demand for corduroy is 510 yards per month. The manufacturer has 5,500 pounds of cotton and 3,000 hours of processing time available each month. The manufacturer makes a profit of $2.25 per yard of denim and $3.10 per yard of corduroy. The manufacturer wants to know how many yards of each type of cloth to produce to maximize profit. If Irwin Mills could obtain only 5,000 pounds of cotton per month, at the optimal solution, the value of X2 is: (refer to slides #17-19 for the clue) Question 3 options: 456 510 1,000 0
Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg. The cost in dollars of producing a kitchen chair at each of the two plants is given here. The cost of producing Q1 chairs at Aynor is: 75Q1 + 5Q1^2 + 100 and the cost of producing Q2 kitchen chairs at Spartanburg is 25Q2 + 2.5Q2/2 + 150 Andalus needs to manufacture a total of 40 kitchen chairs to meet an order just received. How many chairs should be made at Aynor and how many should be made at Spartanburg in order to minimize total production cost? Can you please use Excel to formulate and Solver to solve?
he North Shore Bank is working to develop an efficient work schedule for full-time and part-time tellers. The schedule must provide for efficient operation of the bank, including adequate customer service, employee breaks, and so on. On Fridays, the bank is open from 9:00 a.m. to 7:00 p.m. The number of tellers necessary to provide adequate customer service during each hour of operation is summarized as follows: Each full-time employee starts on the hour and works a 4-hour shift, followed by a 1-hour break and then a 3-hour shift. Part-time employees work one 4-hour shift beginning on the hour. Considering salary and fringe benefits, full-time employees cost the bank $15 per hour ($105 a day), and part-time employees cost the bank $8 per hour ($32 per day). a. Formulate an integer programming model that can be used to develop a schedule that will satisfy customer service needs at a minimum employee cost. (Hint: Let xi= number of full-time employees coming on duty at the beginning of…
The problem below involves three variables. Solve it with the simplex method, Excel, or some other technology.A contractor builds three types of houses: the Aries, the Belfair, and the Wexford. Each house requires one lot, and the following table gives the number of labor-hours and the amount of capital needed for each type of house, as well as the profit on the sale of each house. There are 13 lots, 52,400 labor-hours, and $3,684,200 available for the contractor's use. Aries Belfair Wexford Labor-hours 3,000 3,700 5,000 Capital $205,000 $279,600 $350,000 Profit $20,000 $25,000 $30,000 (a) Building how many of each type of house will maximize his profit? Aries houses Belfair houses Wexford houses (b) What is the maximum possible profit?$