• VOOM has four warehouses 1, 2,3, and 4. VOOM needsto supply 200 Tons to Retailer P, 200 Tons to Retailer Q,and 200 tons to Retailer R. The cost of delivery fromeach warehouse to retailers is provided in the followingtable. While each warehouse has an inventory of 500tons they can supply, R requires that every warehousesupplies at least 25 tons to R. There is a specialarrangement between Warehouse 4 and R whichrequires that Warehouse 4 has to supply exactly 55tons to R. On the other hand, P can take up to 150 tonseach from warehouses 1 and 2.• •Use linear programming to provide VOOM with a planto keep their transportation cost minimal. Deliverycost/ton($)PQRWarehouse1 $ 14.00 $ 30.00 $ 20.00Warehouse2 $ 30.00 $ 40.50 $ 15.003 $ 18.50 $ 20.00 $ 24.00WarehouseWarehouse 4 $15.50 $ 12.50 $ 28.00

For this question, I will prepare the spreadsheet model, Then, I will solve this spreadsheet model…

Answered: VOOM has four warehouses 1, 2,3, and 4.…

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

2. Warehouses A, B, and C and D have 25, 25, 15 and 18 units of a certain commodity, respectively. Customers V, W, X, and Y have respective demands of 18, 26, 28, and 11 units of this commodity. The costs per unit to ship this commodity from each warehouse to each customer are given in the table below: AB A C D Deman d 4 5 1 5 W 2 6 4 8 X 5 1 4 5 Y 1 5 2 4 Supply Fill the table and find how can all of these demands be met from these warehouses at minimum total cost? (Use transportation problem methods)
Sherwin Williams is one of the largest paint manufacturers in the world. They sell their interior house paint for residential consumers in their own stores as well as consumers can order them online for pickup at their local Sherwin Williams store. Benjamin Moore is another large paint manufacturer in North America and they sell their interior house paint for residential consumers through a network of over 7,500 independent paint and hardware stores. Sherwin Williams uses a/an while Benjamin Moore uses a/an O a. corporate vertical marketing system; conventional distribution channel O b. conventional distribution channel; corporate vertical marketing system C. corporate vertical marketing system; direct distribution channel O d. contractual vertical marketing system; conventional distribution channel O e. None of the above Clear my choice
Yang's Material Company hauls gravel to a construction site, using a small truck and a large truck. The carrying capacity and operating cost per load are given in the accompanying table. Yang must deliver a minimum of 120 cubic yards per day to satisfy his contract with the builder. The union contract with his drivers requires that the total number of loads per day is a minimum of 5. How many loads should be made in each truck per day to minimize the total cost? Small Truck Large Truck 40 $44 Capacity (yd³) Cost per Load 30 $76 In order to minimize the total cost, the number of loads in a small truck that should be made is loads in a large truck that should be made is and the number of
Inventory A certain bookstore chain has two stores, one in San Francisco and one in Los Angeles. It stocks three kinds of books: hardcover, softcover, and plastic (for infants). At the beginning of January, the central computer showed the following books in stock. Hard Soft Plastic San Francisco 1,000 3,000 6,000 Los Angeles 1,000 6,000 3,000 Its sales in January were as follows: 600 hardcover books, 1,300 softcover books, and 1,900 plastic books sold in San Francisco, and 300 hardcover, 300 softcover, and 500 plastic books sold in Los Angeles. The bookstore chain actually maintained the same sales figures for the first 6 months of the year. Each month, the chain restocked the stores from its warehouse by shipping 500 hardcover, 1,400 softcover, and 1,400 plastic books to San Francisco and 600 hardcover, 600 softcover, and 600 plastic books to Los Angeles. (a) Use matrix operations to determine the total sales over the 6 months, broken down by store and type of book.…
Oranges are grown, picked and then stored in warehouses in Tampa, Miami, and Fresno.Theses warehouses supply oranges to markets in New York, Philadelphia, Chicago, and Boston.The following table shows the shipping costs per truckload (in hundreds of dollars), supply, anddemand. Because of an agreement between distributors, shipments are prohibited from Miamito Chicago:To (cost, in $100)From New York Philadelphia Chicago Boston SupplyTampa 9 14 12 17 150Miami 11 10 6 10 250Fresno 12 8 15 7 200Demand 110 250 140…
Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as- needed basis for a price 10% higher than the market price the distributor pays for the beans. The current market price is $0.47 per pound for Brazilian Natural and $0.62 per pound for Colombian Mild. The compositions of each coffee blend are as follows: Blend Bean Regular DeCaf Brazilian Natural 75% |40% Colombian Mild 25% 60% Romans sells the Regular blend for $3.60 per pound and the DeCaf blend for $4.40 per pound. Romans would like to place an order for the Brazilian and Colombian coffee beans that will enable the production of 1000…
Markus, Inc., has harvested 400 tons of lumber from a pine forest located outside of Manchester, 200 tons from a forest near Seattle, and 150 tons from a forest outside of Portland. Japan has placed an order for 300 tons at a price of $1200 per ton, Taiwan needs 300 tons and will pay $1000 per ton, and Singapore wants 250 tons at $1000 per ton. It costs Markus, Inc. $500 to get each ton from the pine forest to the port in Manchester, $400 per ton to the port in Seattle, and $300 per ton to Portland. Assume that each pine forest only supplies its closest port. The following table provides the cost for shipping each ton by sea from these ports to the respective countries: ________________________________________________________________________ SHIPPING COST ($/TON) OF LUMBER BY SEA TO: FROM JAPAN TAIWAN SINGAPORE Manchester 250 250 200 Seattle 250 200 200 Portland…
The 23,000-seat Air East Arena houses the local professional ice hockey, basketball, indoor soccer, and arena football teams as well as various trade shows, wrestling and boxing matches, tractor pulls, and circuses. Arena vending annually sells large quantities of soft drinks and beer in plastic cups with the name of the arena and the various team logos on them. The local container cup manufacturer that supplies the cups in boxes of 100 has offered arena management the following discount price schedule for cups: Order Quantity (boxes) Price per Box 2000-6999 $47 7000-11,999 43 41 12,000-19,999 20,000+ 38 The annual demand for cups is 2.3 million, the annual carrying cost per box of cups is $1.90, and ordering cost is $320. Determine the optimal order quantity and total annual inventory cost. a. Find the economic order quantity Q* for each group b. Find the total annual cost TC for each group for the values of Q* found in (a). c. From (a) and (b) state the economic order quantity that…
A retail has 8 stores supplied from 4 suppliers, where each supplier supplies different goods. Delivery from the Supplier is in trucks with a capacity of 40,000 units at a cost of $1100 per load plus $100 per delivery to the store. Inventory costs are $0.2 per unit per year. The Supply Chain Manager is considering whether to use direct shipping or Milk Run delivery for 4 stores for each truck in one shipment a) if annual sales in each store are 1000,000 units, which shipping method provides the lower cost b) if the annual sales in each store are 200,000 units, which shipping method provides the lower cost
Waikato Farm Machinery Ltd (‘WFML’), is a well- established business, with the main base of its operations in Te Rapa, Hamilton. Its business is the importation and distribution of farm machinery such as tractors, loaders, diggers, bulldozers as well as farming equipment such as disc ploughs, rotovators, grain silos including machinery used by dairy farmers in milking sheds. The imported equipment is then sold at wholesale prices to smaller businesses in other centres in the Waikato and King Country regions, that on sell them to farmers. WFML has developed a formidable reputation as a supplier of such goods for at least two reasons. First, it imports machinery and equipment of the highest quality such as John Deere tractors from the United States and International Harvester tractors from Germany. Secondly, it has consistently stood by the goods it sells and efficiently attends to any difficulties experienced by retailers such as the repair of any defects. More importantly it is able to…

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