QUESTION 1A bottling water company distributes its product through four of its wholesale distributorssituated at four locations. The weekly demand of the distributors and the cost of transportationper unit varies between different supply points and destination points. The supply, demand andtransportation cost are as follows:Transportation cost per unitSupply Cape Coast1235765000Aburi6834000DestinationNingo-Prampram252000Akuse7434000(a) Write an equation for the anticipated cost minimization.(b) Draw a network model indicating the flow of the products.(c) Using the Northwest-Corner Rule, how many units should be shipped?Supply600050004000

The transportation model is used to calculate the minimum cost of the route by selecting different…

Answered: (a) Write an equation for the…

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

ABC pharmaceutical Company has four factories that ship supplies to four warehouses. The company’s management hires you as a consultant to determine a minimum-cost shipping plan for its monthly output to the warehouses. Factory capacities, warehouse demands, and shipping cost per box are shown below. Factory Supply or capacity (boxes) Warehouse Demand (boxes) Richmond 60 Chicago 100 Santa Fe 80 Jacksonville 90 Austin 120 Huntville 50 Vacaville 90 Fresno 70 Shipping Costs per box (In Dollars) From To Chicago To Jacksonville To Huntsville To Fresno Richmond 35 35 46 60 Santa Fe 65 40 35 25 Austin 50 50 80 90 Vacaville 40 40 66 75 Draw a diagram by showing factories, warehouses, and connecting arcs. Define variables, write the objective function and constraints.
2. Unbalanced. Provide the transportation model for the calculation of cost given the following data: Use the Stepping Stone Method to solve the following. Use degeneracy method or dummy method if necessary.
Consider the supply chain illustrated here:Last year, the retailer's weekly variance of demand was 200 units. The variance of orders was 500, 600, 750, and I ,350 units for the retailer, wholesaler, distributor, and manufacturer, respectively.(Note that the variance of orders equals the variance of demand for that firm 's supplier.)a) Calculate the bullwhip measure for the retailer.b) Calculate the bullwhip measure for the wholesaler.c) Calculate the bullwhip measure for the distributor.d) Calculate the bullwhip measure for the manufacturer.e) Which firm appears to be contributing the most to the bullwhip effect in this supply chain?
In management science, as with many things, "new" is not always "better" and "analysis" doesn't always beat "intuition." To apply management science correctly, it is important to understand the relative advantages of intuition and analysis in a given situation and to be able to judge whether the benefits of an optimal solution are worth the time and effort needed to find the optimal solution. Review On Social Network Analysis in a Supply Chain Context In this paper, Borgatti and Li (2009) explore the application of a relatively new and very active field of study, social network analysis (SNA), to some long-standing supply chain management (SCM) problems. They argue that the application of SNA to SCM offers significant benefits to the companies that are willing to explore this new frontier. Post your analysis of the methods presented by Borgatti and Li (2009). At a minimum, be sure to address the following: Choose one application of SNA to SCM that you consider most promising and…
Problem S11. More Info The food items listed storage location for e best Click the icon to Click the icon to ITEM TRIPS PER VOYAGE AREA NEEDED (BLOCKS) A 6 В 24 Fill in the table below 40 D 10 E 13 F 12 30 More Info 1 3 7 11 13 15 17 Kitchen Aisle 6. 8. 10 12 14 16 18 Enter Print Done part Cloor A|| Chook Apowor N O N 21 23
East Texas Seasonings began as a small business in Athens Texas. Over the years, the company's success has exceeded the capacity of this one location so Mr. Sass, the owner opened 3 additional branches. Each of these branches house a unique source of the company's secret blend. In an attempt to increase efficiency, the company is preparing to build one processing center to serve its four sources of seasonings. The 4 source locations are at the coordinates shown below. Also, the volume from each source is provided. X-coordinateY-coordinate Volume Athens, Texas 30 40 100 Beaumont, Texas 20 15 400 Carthage, Texas 55 60 150 Denton, Texas 20 70 250 b. Calculate the volume-weighted center of gravity.
Can you help me to solve this question? The case study is in image. Supply chain network: For a Food-Town food item (perishable and short shelf-life such as 'bread'), develop a supply chain network diagram. The diagram must include: Perishable and short shelf-life supply and distribution chain Product flow, information flow, and cash flow directions Afterwards explain the key aspects of the supply chain (product flow, information flow, possible risks, and complexity).
please do it in excel BETTER PRODUCTS COMPANY has decided to start manufacturing four new products in three plants that currently have excess production capacity. The products require comparable production effort per unit, so the available production capacity in the plants is measured by the number of units of any product that can be manufactured per day. a)Formulate this problem as a transportation problem by constructing the appropriate parameter table. Note:One image is of the data and the other image is option 1 to solve the exercise.
Gregory has started a small agricultural business that specialises in maize and sunflower seeds inGrey Town, KZN. His produce is AgriSA approved, and his organisation is looking to hire a supply chain management consultant given their impact and contribution to the local economy. You have been recruited by Gregory, assist him with the following questions: Gregory is uncertain as to which replenishment system he should use. Differentiate between the continuous review and periodic review models and suggest the most suited for him with the aid of at least two practical examples.Note: you are required to provide a paraphrased overview of the models before at least two practical examples are provided to support the choice.
The distribution of daily demand for party cakes at a bakery is shown in the following table: Relative Frequency Demand 0.05 10 0.03 22 0.05 37 0.06 45 0.03 53 0.39 61 0.19 88 0.2 111 Determine the optimal number of cakes to make each day if labour and material are estimated to cost $26.985 per unit. Cakes are sold for $38.55 per unit, and leftover cakes at the end of the day are sold next day at half price. O a. 45 O b. 88 Oc. 61 O d. 111 O e. 53
Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:Commodity Tons Available Volume per Ton (cu.ft.) Profit per Ton ($)1 4,000 40 702 3,000 25 503 2,000 60 604 1,000 50 80You can elect to load any or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions: Cargo Hold Weight Capacity (tons) Volume Capacity (cu.ft.)Forward 3,000 100,000Center 5,000 150,000Rear 2,000 120,000More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold…
Compute the following using excel. Use the formula given in the picture below.

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

(a) Write an equation for the anticipated cost minimization. (b) Draw a network model indicating the flow of the products. (c) Using the Northwest-Corner Rule, how many units should be shipped?