Gotham City Hospital serves cases from four diagnostic-related groups (DRGS). The profit contribution, diagnostic service use (in hours), bed-day use (in days), nursing care use (in hours), and drug use (in dollars) are given in following table. The hospital now has available each week 570 hours of diagnostic services, 1,000 bed-days, 50,000 nursing hours, and $50,000 worth of drugs. To meet the community's minimum health care demands at least 10 DRG1, 15 DRG2, 40 DRG3, and 160 DRG4 cases must be handled each week. Formulate, do not solve, a linear program to determine the hospital's optimal mix of DRGS.

Gotham City Hospital serves cases from four diagnostic-related groups (DRGS). The profit contribution, diagnostic service use (in hours), bed-day use (in days), nursing care use (in hours), and drug use (in dollars) are given in following table. The hospital now has available each week 570 hours of diagnostic services, 1,000 bed-days, 50,000 nursing hours, and $50,000 worth of drugs. To meet the community's minimum health care demands at least 10 DRG1, 15 DRG2, 40 DRG3, and 160 DRG4 cases must be handled each week. Formulate, do not solve, a linear program to determine the hospital's optimal mix of DRGS.

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 76P

See similar textbooks

Similar questions

Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
Please use excel for this problem A furniture manufacturer produces two types of tables – country and contemporary – using three types of machines. The time required to produce the tables on each machine is given in the following table: Machine Country Contemporary Total Machine Time Available Per Week Router 3.5 4.0 1,000 Sander 4.5 6.5 2,000 Polisher 3.0 2.0 1,500 Country tables sell for $395 and contemporary tables sell for $515. Management has determined that at least 25% of the tables made should be country and at least 38% should be contemporary. How many of each type of table should the company manufacture if it wants to maximize its revenue? Formulate an LP model for this problem Create the spreadsheet model and use Solver to solve the problem.
Par, Inc., produces a standard golf bag and a deluxe golf bag on a weekly basis. Each golf bag requires time for cutting and dyeing and time for sewing and finishing, as shown in the following table: Hours Required per Bag Product Cutting and Dyeing Sewing and Finishing Standard Bag 1/2 1 Deluxe Bag 1 2/3 The profits per bag and weekly hours available for cutting and dyeing and for sewing and finishing are as follows: Product Profit per Unit ($) Standard Bag $15 Deluxe Bag $8 Activity Weekly Hours Available Cutting and Dyeing 300 Sewing and Finishing 360 Par Inc. will sell whatever quantities it produces of these two products. The aim of the objective function for Par Inc., should be to maximize the objective value. The optimum solution is: Number of standard bags produced per week = 360 (enter your response as a whole number). Number of deluxe bags produced per week =____ (enter…
Par, Inc., produces a standard golf bag and a deluxe golf bag on a weekly basis. Each golf bag requires time for cutting and dyeing and time for sewing and finishing, as shown in the following table: Hours Required per Bag Product Cutting and Dyeing Sewing and Finishing Standard Bag 1/2 1 Deluxe Bag 1 2/3 The profits per bag and weekly hours available for cutting and dyeing and for sewing and finishing are as follows: Product Profit per Unit ($) Standard Bag $5 Deluxe Bag $8 Activity Weekly Hours Available Cutting and Dyeing 270 Sewing and Finishing 360 Par Inc., will sell whatever quantities it produces of these two products. The aim of the objective function for Par Inc., should be to ▼ Maximize Minimize Par, Inc., produces a standard golf bag and a deluxe golf bag on a weekly basis. Each golf bag requires time for cutting and dyeing and time for sewing and finishing, as shown in the…
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…
The Midland Tool Shop has four heavy presses it uses to stamp out prefabricated metal covers and housings for electric consumer products. All four presses operate differently and are of different sizes. Currently the firm has a contract to produce three products. The contract calls for 400 units of product A, 570 units of product B, and 320 units of product C. The time (in minutes) required for each product to be produced on each machine is as follows: Machine Product 1 2 3 4 A 35 41 34 39 B 40 36 32 43 C 38 37 33 40 Machine 1 is available for 150 hours, machine 2 for 240 hours, machine 3 for 200 hours, and machine 4 for 250 hours. The products also result in different profits, according to the machine they are produced on, because of time, waste, and operating cost. The profit per unit per machine for each product is summarized as follows: Machine Product 1 2 3…
Par, Inc., produces a standard golf bag and a deluxe golf bag on a weekly basis. Each golf bag requires time for cutting and dyeing and time for sewing and finishing, as shown in the following table: Hours Required per Bag Product Cutting and Dyeing Sewing and Finishing Standard Bag 1/2 1 Deluxe Bag 1 2/3 The profits per bag and weekly hours available for cutting and dyeing and for sewing and finishing are as follows: Product Profit per Unit ($) Standard Bag $5 Deluxe Bag $4 Activity Weekly Hours Available Cutting and Dyeing 270 Sewing and Finishing 480 Par Inc., will sell whatever quantities it produces of these two products. a) The aim of the objective function for Par Inc., should be to Maximizethe objective value. b) The optimum solution is: Number of standard bags produced per week = ?
An electronics manufacturing company has three production plants, each of which produces three different models of a particular MP3 player. The daily capacities (in thousands of units) of the three plants are shown in the table. Basic model Gold model Platinum model Plant 1 8 4 8 Plant 2 6 6 3 Plant 3 12 4 8 The total demands are 300,000 units of the Basic model, 172,000 units of the Gold model, and 249,500 units of the Platinum model. The daily operating costs are $50,000 for plant 1, $60,000 for plant 2, and $60,000 for plant 3. How many days should each plant be operated in order to fill the total demand while keeping the operating cost at a minimum? What is the minimum cost? Use the method of the dual.
Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table on this page contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week (or 60 cabinets per day). Owner Bob Winkler would like to determine a product mix to maximize his daily revenue.Use Solver to solve the problem. You need to have one Excel sheet with the problem setup and another sheet with Solver solution
A company imports goods at two ports: Philadelphia and New Orleans. Shipments of one product are made to customers in Atlanta, Dallas, Columbus, and Boston. For the next planning period, the supplies at each port, customer demands, and shipping costs per case from each port to each customer are as follows: Customers Port Atlanta Dallas Columbus Boston Port Supply Philadelphia 2 6 6 2 5,000 New Orleans 1 2 5 7 3,000 Demand 1,400 3,200 2,000 1,400 Develop a network representation of the distribution system. Develop the objective function and the constraints.