Kindly give me a detailed response.Please do the iterations manually.I do not need it solved with Solver or any other tool.Thank you very much. 9.1-1. The Childfair Company has three plants producing child push chairs that are to beshipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipmentsper month, respectively. Each distribution center needs to receive 10 shipments permonth. The distance from each plant to the respective distributing centers is given below:DistanceDistribution Center12341800 milesPlant 2 1,100 miles31,300 miles400 miles700 miles1,400 miles600 miles1,000 miles600 miles 1,200 miles800 miles900 milesThe freight cost for each shipment is $100 plus 50 cents per mile.How much should be shipped from each plant to each of the distributioncenters to minimize the total shipping cost?(a) Formulate this problem as a transportation problem by constructing the appropriateparameter table.(b) Draw the network representation of this problem.c (c)Obtain an optimal solution.

Freight cost = $100 + 50 cents per mileThe distance matrix is given below:

9.1-1. The Childfair Company has three plants producing child push chairs that are to be shipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipments per month, respectively. Each distribution center needs to receive 10 shipments per month. The distance from each plant to the respective distributing centers is given below: Distance Distribution Center 1 2 3 1 Plant 2 3 800 miles 1,100 miles 600 miles 1,300 miles 400 miles 700 miles 1,400 miles 600 miles 1,200 miles 800 miles 1,000 miles 900 miles The freight cost for each shipment is $100 plus 50 cents per mile. How much should be shipped from each plant to each of the distribution centers to minimize the total shipping cost? (a) Formulate this problem as a transportation problem by constructing the appropriate parameter table. (b) Draw the network representation of this problem. c (c)Obtain an optimal solution.

9.1-1. The Childfair Company has three plants producing child push chairs that are to be shipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipments per month, respectively. Each distribution center needs to receive 10 shipments per month. The distance from each plant to the respective distributing centers is given below: Distance Distribution Center 1 2 3 1 Plant 2 3 800 miles 1,100 miles 600 miles 1,300 miles 400 miles 700 miles 1,400 miles 600 miles 1,200 miles 800 miles 1,000 miles 900 miles The freight cost for each shipment is $100 plus 50 cents per mile. How much should be shipped from each plant to each of the distribution centers to minimize the total shipping cost? (a) Formulate this problem as a transportation problem by constructing the appropriate parameter table. (b) Draw the network representation of this problem. c (c)Obtain an optimal solution.

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

Related questions

Q: What is the final value of the decision tree?

A: Find the given details below:

Q: Write a minimum of 150 words addressing what you learned:Suppose that a product can be sold at…

A: Based on the given information, the decision to process the product further can be determined by…

Q: you are required to use the event decomposition technique to identify use cases. Develop a table for…

A: Let us understand the meaning of certain concepts used in this question:1. Systems Development:…

Q: Most of the databases we use on a regular basis have gone through the entire design process--from…

A: A data model is a model used to organize the elements of the conceptual data and assign…

Q: Problem 2 The AB manufacturing company has two kinds of products: A and B. They earn $180 profit for…

A: Note that, we could not generate a sensitivity report by hand and without a sensitivity report…

Q: Assume you are the project manager for the Tidal 2 software project. You have been asked to…

A: Project management mechanism keeps the organization on course and allows for proper modifications…

Q: What makes the general simplex method so effective? Give an example to illustrate your point.

A: Let's take a look at a simple transportation system. The transportation simplex method is a linear…

Q: Please answer this case. Thank you

A: Information systems are specialized software used by organizations to collect, store, analyze and…

Q: hese are not the right solutions, they are all coming back wrong which is why I reached out and…

Q: mid west university is installing a high speed intranet System. The following Netwerk shows a…

A: The shortest route problem helps to find the path that will have the minimum distance or cost or any…

Q: and fou posseis

A: The business should be run as per the market conditions, and requirement. The resources for the…

Q: Apply the Plan-Do-Check-Act model on a certain process of your choice.

A: It is possible to implement the Plan-Do-Check-Act (PDCA) model, which is a continuous improvement…

Q: If factory workers are paid based on time and/or productivity, there is likely high inherent risk…

A: In the context of auditing, key assertions are claims made by management regarding the company's…

Q: Is it true that there are a few different approaches to processing? Do you have any idea which of…

A: Processing refers to the analysis of data, manipulation, and transformation of data to find out…

Q: Situation: You are the operations manager of a factory near the town where you live. The senior…

A: As the operations manager of the factory, I understand the challenges that we are facing due to the…

Q: Which one of the following statements is TRUE in the context of sequencing performance criteria?

A: Answer: Option A)

Q: Good Evening Kindly send me a different answer because I'm pretty sure some students have asked…

A: Waste management refers to the systematic process of collecting, treating, disposing of, and…

Q: Suppose you work in a textiles factory. You know that it's normal for machines to print an average…

A: Business operations require some tools and techniques to have an insight into their chances of…

Q: Excel keeps Date and Time data separately to reduce the potential for confusion. True False

A: MS-Excel is a computer software that is widely used by schools, manufacturing organizations,…

Q: As the owner of a fast food restaurant with declining sales, your customers are looking for…

A: Below excel screenshot show the approach for solving this problem using linear programming.

Q: The MEG athletic center located in cleaveland, ohio, is interested in implementing a new payroll.…

A: The MEG Athletic Center located in Cleveland, Ohio, is interested in upgrading its manual payroll…

Q: Please do not give solution in image format thanku What is the average value of a loyal customer…

A: Revenue per unit = 50Given that, Frequency of repurchase is every month ( 12 Times a…

Q: The DPCI score for size would be 4 in which of the following situations? The project manager and…

A: In managing the organizational project, we would consider the DPCI score or Darnall Preston…

Q: Management is the process of coordinating and overseeing the activities of an organization to…

A: The objective of the question is to understand how managers can balance the needs and expectations…

Q: From the letters a, b, c, d, and e, how many four-letter groups can be formed if each letter can be…

A: The objective of the question is to find out the number of four-letter groups that can be formed…

Question

Kindly give me a detailed response. Please do the iterations manually. I do not need it solved with Solver or any other tool. Thank you very much.

9.1-1. The Childfair Company has three plants producing child push chairs that are to be
shipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipments
per month, respectively. Each distribution center needs to receive 10 shipments per
month. The distance from each plant to the respective distributing centers is given below:
Distance
Distribution Center
1
2
3
4
1
800 miles
Plant 2 1,100 miles
3
1,300 miles
400 miles
700 miles
1,400 miles
600 miles
1,000 miles
600 miles 1,200 miles
800 miles
900 miles
The freight cost for each shipment is $100 plus 50 cents per mile.
How much should be shipped from each plant to each of the distribution
centers to minimize the total shipping cost?
(a) Formulate this problem as a transportation problem by constructing the appropriate
parameter table.
(b) Draw the network representation of this problem.
c (c)Obtain an optimal solution.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: State the given information

VIEW

Step 2: a) Formulate the transportation problem

VIEW

Step 3: b) Draw the network representation of the transportation problem

VIEW

Step 4: c) Find the feasible solution

VIEW

Step 5: c) Find the optimal solution

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 6 steps with 25 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

A significant question that faces all analysts is how much effort to expend studying and documenting the existing system (if one exists). Excess attention to an existing system can consume considerable time and can result in simply updating that system with newer technology. As a result, no matter how inefficient the current system is, system developers simply reimplement the procedures that are already in place. On the other hand, if a new system inherits many or all of the requirements of an existing system, then an analyst risks missing important requirements through insufficient study of the existing system. To minimize both risks, analysts must balance the review of current business functions with discovery of new system requirements. It is still critical to have a complete correct set of system requirements, but in today’s fast-paced world, there is no time or money to review all the old systems and document all the inefficient procedures. In fact, in today’s development…
Write out the equation for 'margin for error'. In a business environment, what is the meaning of o in this equation, and why would a firm first try to reduce the margin for error using this term. What else can the firm do to reduce the margin for error? Explain each thing it can do, and why it does so, and what its pros and cons are.
Can you please make a report exactly like the image for any output needed in the proposed Car Sharing IS. Add a brief description of your report to explain what it shows.
Correct complete solutions need only 100% sure experts solve it correct complete solutions with final answers and drawing ok
Your company wants to replicate its travel expense management process from paper-based to an electronic process. In the current process, an employee wishing to travel would simply complete a travel notification form and send to his/her supervisor, and keep a copy. There is no requirement for the supervisor to approve the form prior to the employee travel. At the end of the travel, the employee attaches his/her travel expense receipts to his/her copy of the travel notification form and submits to the supervisor for approval. For this project, the company has indicated that it does not plan to change any aspect of the paper-based travel expense management process, at least initially, even though not doing so could expose the company to various types of risks. You have been appointed the project manager for this project, and one of your responsibilities is to assess the risks associated with replicating the paper-based travel expense management process without introducing any new controls…
As the owner of a fast food restaurant with declining sales, your customers are looking for something new and exciting on the menu. Your market research indicates that they want a burger that is loaded with everything as long as it meets certain health requirements. Money is no object to them. Use Excel to answer this question Requirements: Must include at least one of each item and no more than six of each item Must use whole items (no half or partial servings) Final burger must contain no more than: 3,000 mg of sodium 50 g of fat 3,000 calories Must keep the servings of ketchup and lettuce the same Must keep the servings of pickles and tomatoes the same Must use exactly two buns a. What is the most expensive burger you can make that meets these requirements? b. What are the allocations of each ingredients.
The blocks on the right side of the Business Model Canvas represent the customer, the blocks on the left represent the infrastructure, and the blocks at the bottom represent the financial viability of the business model. Select one: True False
2. Process management is a. the ongoing activity of recording facts and specifications for a system for current and future reference b. the activity of scoping, planning and staffing the development of a system c. the activity of organizing the development of a system d. the activity of documenting, managing, and continually improving the process of systems development
8 - Crowdfunding usually requires smaller amounts of investment contributions in comparison to Microlending. TrueFalse