The John Adams Brewing Company has breweries in threecities; the breweries can supply the following numbers of bar-rels of draft beer to the company's distributors each month:BreweryA. TampaMonthly Supply (barrels)4,0005,000B. St. LouisC. Chicago3,50012,500The distributors, spread throughout six states, have the fol-lowing total monthly demand:DistributorMonthly Demand (barrels)1. Tennessee18002. Georgia21003. North Carolina17004. South Carolina10505. Kentucky6. Virginia2350140010.400The company must pay the following shipping costs perbarrel:tofrom12356А.$0.50$.35$0.60$0.45$0.80$0.75В.0.250.650.400.550.200.65C.0.400.700.550.500.350.50Determine the minimum cost shipping routes for thecompany.

Given Information: Since the supply and demand are not balanced, a dummy variable needs to be…

Answered: The John Adams Brewing Company has…

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

In this problem, your company is a distributor of products. You serve as an inventorymanager for the regional distribution center (DC) here in the Atlanta area. In this role,you schedule the purchase and shipment of products from various suppliers inbound to theAtlanta DC. Once you receive the products at the DC, they are stored in inventory untilthey are picked, packed, and shipped outbound to your company’s downstream customersin response to orders.For each of your products, you currently use a single, dedicated supplier. Each of yoursuppliers ships their products to you from their facility using trucking services, and theyprovide you with choices of different LTL or truckload trucking carriers depending on yourshipment size.Consider managing inventory now for product 101 produced by Supplier A. Currently,you face demand for product 101 of about 200 units per week. Each unit of product 101has a purchase cost p of $500 and you decide to value your inventory at the slightly higherrate…
In this problem, your company is a distributor of products. You serve as an inventorymanager for the regional distribution center (DC) here in the Atlanta area. In this role,you schedule the purchase and shipment of products from various suppliers inbound to theAtlanta DC. Once you receive the products at the DC, they are stored in inventory untilthey are picked, packed, and shipped outbound to your company’s downstream customersin response to orders.For each of your products, you currently use a single, dedicated supplier. Each of yoursuppliers ships their products to you from their facility using trucking services, and theyprovide you with choices of different LTL or truckload trucking carriers depending on yourshipment size.Consider managing inventory now for product 101 produced by Supplier A. Currently,you face demand for product 101 of about 200 units per week. Each unit of product 101has a purchase cost p of $500 and you decide to value your inventory at the slightly higherrate…
Using the center-of-gravity model, locate the X and Y coordinates of a warehouse to serve three different customers as follows:
Explain the following sentence "In reality, it can be difficult for managers to achieve logistics management goals when designing logistical procedures because they may face heavy stresses on the supply chain such as rising overall costs"??
please answer quickly
Please solve
Explain the significance of the “Triple Constraint” and how it is affected when trade-offs are needed.
Phylis Ltd has the following transactions in respect of its goods during Dec 2015. Opening stock 78 units @ GH¢25 Dec 5 bought 250 units @ GH¢24 Dec 10 sold 175 units @ GH¢95 Dec 11 bought 140 units @ GH¢26 Dec 12 sold 200 units @ GH¢48 Dec 15 paid for printing GH¢7,200 Dec 16 bought 400 units @ GH¢20 Dec 22 sold 140 units @ GH¢85 Dec 22 commission to sales Executives GH¢ 20,000 Dec 23 sold 155 units @ GH¢40 Additional information; 1. The cost of carrying a unit material inwards was agreed at GH¢1.5 2. Out of the general administrative expenses of GH¢15,200 only GH¢3,700 had been paid during December. 3. The goods sold on December 23rd only 20% has been collected by the company as at close of the year-month 4. The outstanding balance of GH¢7,100 was paid on the 20th January 2021 You are required to: a. Write up the stores ledger card using the weighted average method of stock valuation. b. Prepare trading, profit and loss…
A company has three existing warehouses to which it will ship furniture from a new factory whose location must be decided. The factory will receive raw materials from its wood supplier and fabric supplier. The annual number of shipments, shipment costs and the location of the suppliers and warehouses are shown below Existing facilities Annual L to or from fact cost Coordinate location Wood supplier 120 10 (100, 400) Fabric supplier 200 10 (800,700) Ware h 1 61 10 (300, 600) Ware h 2 40 10 (200, 100) Ware h 3 70 10 (600, 200) Using the median load answer the following questions –Where the factory should be located to minimize annual transportation cost –What will be the minimum annual transportation cost
A pharmaceutical company sells 78 different products. The distribution of annual sales amounts last year for these products is as follows. Number of Products 100 90 80 70 60 50 40 30 20 10 0 0 5,17 301 37 50 75,61 100 150 Annual Sales ($000) 200, 78 200 250 Approximately what percentage of the products had annual sales of less than $80,000 last year? OA. 62 O B. 79.5 OC. 38 O D. 20.5 OE. None of the above
JN Company manufactures two products that use material 1, material 2, and material 3. Consider the following table: Resources needed Material 1 Material 2 Material 3 Price per Unit in Pesos Requirement per Unit Product 1 2 2 0 150 Product 2 3 1 4 200 a. Write the linear programming model for this problem. b. Present the optimal solution and interpret the result. Maximum Availability (units) 1200 1000 800 c. Determine the status of each resource. d. Determine the dual prices for the materials 1, 2 and 3. Explain each value. e. Determine the feasibility ranges for the dual prices obtained in (d). f. If the available number of material 1 is increased to 1300 units, find the new optimum solution. g. Find the range of optimality for (i.) product 1 and (ii.) product 2 for which the optimal. solution remains valid.
: x v fx C DE в F G H K M Consider the linear distribution and the from-to diagram shown in the figure. Assuming that the goal is to minimize the total distance traveled, determine the final distribution recommended by CRAFT using the peer-to-peer trading method. 30 m 30 m from A A B A 2 6 B 3 A В 80 m 20 m

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