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:CustomersPortAtlantaDallasColumbusBostonPort SupplyPhiladelphia26625,000New Orleans12573,000Demand1,4003,2002,0001,400 Develop a network representation of the distribution system.Develop the objective function and the constraints.

Answered: Image /qna-images/answer/03cf9525-d90f-4c78-a990-23374c1aff52.jpg

Answered: Develop a network representation of the…

Business

Management

Develop a network representation of the distribution system. Develop the objective function and the constraints.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 47P

See similar textbooks

Similar questions

This problem is based on Motorolas online method for choosing suppliers. Suppose Motorola solicits bids from five suppliers for eight products. The list price for each product and the quantity of each product that Motorola needs to purchase during the next year are listed in the file P06_93.xlsx. Each supplier has submitted the percentage discount it will offer on each product. These percentages are also listed in the file. For example, supplier 1 offers a 7% discount on product 1 and a 30% discount on product 2. The following considerations also apply: There is an administrative cost of 5000 associated with setting up a suppliers account. For example, if Motorola uses three suppliers, it incurs an administrative cost of 15,000. To ensure reliability, no supplier can supply more than 80% of Motorolas demand for any product. A supplier must supply an integer amount of each product it supplies. Develop a linear integer model to help Motorola minimize the sum of its purchase and administrative costs.
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?
#4) Debbie Gibson is considering three investment options for a small inheritance that she has just received-stocks, bonds, and money market. The return on her investment will depend on the performance of the economy, which can be strong, average, or weak. If the market is strong her returns are 9% for stocks, 6% for bonds and 4% for money market. If the market is average her returns are 5% for stocks, 4% for bonds and 6% for money market. If the market is weak her returns are -7% for stocks, 2% for bonds and 1% for money market. (Round values to the nearest hundredths of a percent). a) Create a decision table and a decision tree. b) Which investment should Debbie choose if she uses the maximax criterion? What are the returns? c) Which investment should Debbie choose if she uses the maximin criterion? What are the returns? d) Which investment should Debbie choose if she uses the equally likely criterion? What are the returns? e) Which investment should Debbie choose if she uses the…
A one-day vaccination clinic has forecast the number of workers needed according to the table shown below. Workers can work either an 8-hour, 10-hour, or 12-hour shift. The respective costs per worker are $150, $180, and $210. Determine the least cost schedule. In each case, a worker can start at the beginning of any 2-hour period that allows them to work the next 8, 10, or 12 hours, respectively. Time Period Workers Needed 8-10 13 10-12 16 12-2 18 2-4 20 4-6 19 6-8 9
Hoosier Power needs to determine a capacity expansion plan to meet Bloomington’s power needs for the next 20 years. The current capacity is 5000 kwh. The demand for the current year is 4000 kwh, and demand is expected to increase by 1000 kwh in each succeeding year. At the beginning of each year, Hoosier Power must determine the amount of capacity to add, given the following inputs: ■ Any year in which capacity is added, a fixed cost of $120,000 is incurred plus a cost of $120 per kwh of capacity. ■ At most 10,000 kwh of capacity can be added in a single year. ■ It costs $25 per year to maintain a unit of capacity. ■ It costs $12 per year to produce a kwh. ■ If production does not meet demand, a shortage cost of $80 per kwh short is incurred. Develop a linear integer model to help Hoosier Power minimize its costs for the next 20 years.
Case Problem: Textbook Publishing ASW Publishing, Inc., a small publisher of college textbooks, must make a decision regarding which books to publish next year. The books under consideration are listed in the following table, along with the projected threeyear sales expected from each book. Book Subject Type of Book Projected Sales (000s) Business calculus New 20 Finite mathematics Revision 30 General statistics New 15 Mathematical statistics New 10 Business statistics Revision 25 Finance New 18 Financial accounting New 25 Managerial accounting Revision 50 English…
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 the objective function and the constraints.
Debbie Gibson is considering three investment options for a small inheritance that she has just received-stocks, bonds, and money market. The return on her investment will depend on the performance of the economy, which can be strong, average, or weak. If the market is strong her returns are 9% for stocks, 6% for bonds and 4% for money market. If the market is average her returns are 5% for stocks, 4% for bonds and 6% for money market. If the market is weak her returns are -7% for stocks, 2% for bonds and 1% for money market. (Round values to the nearest hundredths of a percent). a) Create a decision table and a decision tree. b) Which investment should Debbie choose if she uses the maximax criterion? What are the returns? c) Which investment should Debbie choose if she uses the maximin criterion? What are the returns? d) Which investment should Debbie choose if she uses the equally likely criterion? What are the returns? e) Which investment should Debbie choose if she uses the…
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.
The Gulf Coast Foundry is developing a long-range strategic plan for buying scrap metal for its foundry operations. The foundry can buy scrap metal in unlimited quantities from two sources, Atlanta (A) and Birmingham (B), and it receives the scrap daily in railroad cars. The scrap is melted down, and lead and copper are extracted for use in the foundry processes. Each railroad car of scrap from source A yields 1 ton of copper and 1 ton of lead and costs $10,000. Each railroad car of scrap from source B yields 1 ton of copper and 2 tons of lead and costs $15,000. If the foundry needs at least 21/2 tons of copper and at least 4 tons of lead per day for the foreseeable future, how many railroad cars of scrap should be purchased per day from Source A and Source B to minimize the long-range scrap metal cost?
Fertilizing the Lawn. The facilities manager at Oxbridge University is planning to apply fertilizer to the grass in the quadrangle area in the spring. The grass needs nitrogen, phosphorus, and potash in at least the amounts given in the following table: Mineral Minimum Weight (lb) Nitrogen 12 Phosphorus 14 Potash 18 Three kinds of commercial fertilizer are available, with mineral content and prices per 1,000 pounds as given in the following table. There is virtually unlimited supply of each kind of fertilizer. Fertilizer Nitrogen Content (lb) Phosphorus Content (lb) Potash Content (lb) Price ($) A 20 10 5 10 B 10 5 15 8 C 15 10 5 7 How much of each fertilizer should be purchased to satisfy the requirements at minimum cost
Varma Investment Services must develop an investment portfolio for a new client. As an initial investment strategy, the new client would like to restrict the portfolio to a mix of two stocks: Stock Price/Share Estimated Annual Return (%) AGA Products $ 50 6 Key Energy 100 10 The client wants to invest $50,000 and established the following two investment goals. LO 1, 2