Question:workstations available. Permanent and temporary operators work 8 hours per day. A permanentoperator averages about 0.4 error per day, whereas a temporary operator averages 0.9 error per day.The company wants to limit errors to 15 per day. A permanent operator is paid $120 per day wherasa temporary operator is paid $75 per day. Corsouth wants to determine the number of permanentand temporary operators it needs to minimize cost. Formulate, and solve an integer programmingmodel for this problem and compare this solution to the non-integer solution.5.Globex Investment Capital Corporation owns six companies that have the following estimatedreturns (in millions of dollars) if sold in one of the next 3 years:Year Sold(estimated returns, $1,000,000s)Company1231$14$18$2311153182327416212551216226212328To generate operating funds, the company must sell at least $20 million worth of assets in year 1, $25million in year 2, and $35 million in year 3. Globex wants to develop a plan for selling these companiesduring the next 3 years to maximize return.Formulate an integer programming model for this problem and solve it by using the computer.2.

Linear programming refers to an optimization method for maximizing or minimizing an objective…

Answered: Formulate an integer programming model…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

An Electrical Utility Startup Problem A problem faced by an electrical utility company each day is that of deciding which generators to start up. The utility in question has five generators with the characteristics shown in the following table. If any Megawatt-hours (MW-hr) are produced by a generator, the generator must be started up and the fixed startup cost is incurred. At least 8600 MW-hrs must be generated today. Set up and solve a linear spreadsheet model (with some binary variables) to determine the operating plan that will minimize their overall costs. For full credit, the model must be linear (no multiplication of changing cells, no IF statements, no MAX statements, etc.). Fixed Startup Cost Cost per MW-hr Generated Maximum Capacity (MW-hr) Generator A $2400 $10 2100 Generator B $2800 $9 2400 Generator Generator C D $4000 $3350 $8 $10 2700 3100 Generator E $1700 $11 3700
a company possesses two manufacturing plants, each of which can produce three products: X,Y, and Z from common raw material. However, the proportions in which the products are produced are different in each plant and so are the plant’s operating costs per hour. Following are the data on the production per hour and costs together with current orders in hand for each product. a company possesses two manufacturing plants, each of which can produce three products: X,Y, and Z from common raw material. However, the proportions in which the products are produced are different in each plant and so are the plant’s operating costs per hour. Following are the data on the production per hour and costs together with current orders in hand for each product. Plant product operating cost per hour(birr) X YZ A 2 4 3 9 B 4 3 2 10 Orders on hand 54 24 60 You are required to use graphical method to find out the number of production hours needed to fulfill the orders on…
A linear programming computer package is needed. Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec's production schedule calls for 4,500 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown. Component Manufacturing Cost Purchase Cost Frame Support Min Strap Component Frame Support Strap Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows. Cutting constraint Milling constraint Shaping constraint Frame…
RVW buys 15 used VW's at each of two car auctions each week held at different locations. It then transports the cars to repair shops it contracts with. When they are restored to RVW's specifications, RVW sells 10 each to three different used car lots. There are various costs associated with the average purchase and transportation prices form each auction to each repair shop. Also, there are transportation costs from the repair shops to the used car lots. RVW is concerned with minimizing its total cost given the costs in the table below. Repair Shops S1 S2 Used Car lots L1 L2 L3 Auction 1 500 550 500 S1 250 300 Auction 2 450 600 450 S2 350 650 What is the minimum Cost 29000 17500 32000 25500
What combination of x and y will yield the optimum for this problem? Maximize $10x + $4y, subject to (1) 5x + 3y ≤ 15 and (2) 3x + 6y ≤ 18 and (3) x, y ≥ 0.
XYZ Inc. produces two types of paper towels, called regular and super-soaker. Regular uses 2 units of recycled paper per unit of production and super-soaker uses 3 units of recycled paper per unit of production. The total amount of recycled paper available per month is 10,000. They also have a binding contract to use at least 8000 units of recycled paper per month with a local pollution control organization. Letting X1 be the number of units of regular produced per month and X2 represent the number of units of super-soaker produced per month, the appropriate constraint/s willI be A) 2X1 + 3X2 > 8000 or 2X1 + 3X2 8000 and 2X1 + 3X2 8000
A linear programming computer package is needed. Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company's needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows. Component Supplier 1 2 3 1 $13 $14 $15 2 $11 $12 $11 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows. Supplier 1 2 3 Capacity 500 900 700 If the Edwards production plan for the next period includes 900 units of component 1 and 700 units of component 2, what purchases do you recommend? That is, how many…
The newly-established pediatric department of a local hospital is in need of full-time nurses who will work in 8-hour shift per day and part-time nurses who will work in 4-hour shifts per day. Each day is divided into 6 four-hours periods, which requires different number of nurses., as shown in the table below: Time Period Index Time Period Covered 7am - 11am. 11am-3pm 3pm - 7pm 7pm - 11pm 11pm-3am 3am - 7am 1 2 3 4 5 6 Required Number of Nurses 7 9 12 5 4 3 The shifts of full-time nurses can begin at the start of any of the four-hour periods. Hospital policy requires that there must be at least two full-time nurses at each time period. Also, the number of part-time nurses cannot exceed the number of full-time nurses in any time period. Full-time nurses get paid at $160 per shift, while the part-time nurses get paid at $50 per shift. Formulate a linear programming model that will determine the nursing schedule so as to minimize the total cost.
A linear programming computer package is needed. Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec's production schedule calls for 4,500 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown. Component Manufacturing Cost Purchase Cost Frame Support Min Strap Component Frame Support $37.00 Strap $10.50 Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows. $5.50 Cutting 3.5 1.3 0.8 Department 350 2.2 $50.00…
Use the simplex algorithm to solve the following LP: max z x1 x2 x3 s.t. x1 2x2 2x3 20
Sunseel Industries produces two types of raw materials, A and B, with a production cost of $4 and $8 per unit, respectively. The combined production of A and B must be at least 700 units per month. The factory is expected to produce at least 400 units of B and not more than 1200 units of A each month. The processing times for A and B are observed to be 5 hours and 4 hours, respectively. A total of 3000 production hours are available per month. Develop a linear program that Sunseel Industries can use to determine the number of units of each raw material to produce that will meet the demand and minimize the total cost.
Five to six times a year, Kicker puts on tent sales in various cities throughout Oklahoma and the surrounding states. The tent sales are designed to show Kicker customers new products, engender enthusiasm about those products, and sell soon to be out-of-date products at greatly reduced prices. Each tent sale lasts one day and requires parking lot space to set up the Kicker semitrailer; a couple of show cars; a disc jockey playing music; a tent to sell Kicker merchandise, distribute brochures, and so on. Last year, the Austin, TX tent sale was held in a corner of the parking lot outside the city exhibition hall where the automotive show was in progress. Because most customers were interested more in the new model cars than in the refurbishment of their current cars, foot traffic was low. In addition, customers did not want to carry speakers and amplifiers all the way back to where they had originally parked. Total direct costs for this tent sale were $14,300. Direct costs…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS