Problem #12: Please resolve this problem using solver in Excel (part c). Step by step screen shoots would be very helpful. Thank you.No hand written solution b. Determine the optimal assignment of11. The distribution system for the Herman Company consists of three plants, two warehouses,and four customers. Plant capacities and shipping costs per unit (in $) from each plant toeach warehouse are as follows:Plant1Warehouse12Demand231485Warehouse163300256Customer demand and shipping costs per unit (in $) from each warehouse to each customerare as follows:2CustomerCapacity45060038046300387300a. Develop a network representation of this problem.b. Formulate a linear programming model of the problem.c. Solve the linear program to determine the optimal shipping plan.446740012. Refer to Problem 11. Suppose that shipments between the two warehouses are permitted atper unit and that direct shipments can be made from Plant 3 to Customer 4 at a cost of$7 per unit.$2a. Develop a network representation of this problem.b. Formulate a linear programming model of this problem.C. Solve the linear program to determine the optimal shipping plan.

Linear programming helps us to find the optimal solution/best outcome, given the constraints.Network…

12. Refer to Problem 11. Suppose that shipments between the two warehouses are permitted at $2 per unit and that direct shipments can be made from Plant 3 to Customer 4 at a cost of $7 per unit. a. Develop a network representation of this problem. b. Formulate a linear programming model of this problem. C. Solve the linear program to determine the optimal shipping plan.

12. Refer to Problem 11. Suppose that shipments between the two warehouses are permitted at $2 per unit and that direct shipments can be made from Plant 3 to Customer 4 at a cost of $7 per unit. a. Develop a network representation of this problem. b. Formulate a linear programming model of this problem. C. Solve the linear program to determine the optimal shipping plan.

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: The offices of Vivobarefoot in the heart of London has had trouble connecting to the internet for a…

A: Microsoft's Office 365 is a cloud-based productivity suite that includes a collection of popular…

Q: Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to…

A: For BlueBox-Fixed cost =$500Variable cost =$0.08Selling Price =$1.00For GreenFilms-Fixed cost…

Q: When calculating the expenses to run a business there are things that can’t be changed called…

A: In business, there are such things that remain fixed or contant throughout the whole operations of…

Q: b. How many weeks will the project take to complete? Number of weeks c. Suppose F could be shortened…

A: The critical path in project management determines the minimum time required for the project to be…

Q: a) What would be the total cost, revenue and profit for a weekly volume of 10,000 bottles? (b) What…

A: Here, It is assumed that all output can be sold, I will answer the given sub-part questions,

Q: “The Beauty of Excel #1: Formulas & Functions”. Observe the use of the Input Section versus the…

A: The Beauty of Excel #1: Formulas & Functions Overview of Input Section vs. Information SectionIn…

Q: What should you look for when you read for formatting errors during the proofreading phase? Check…

A: The primary focus during the proofreading phase is to check for errors in the text, such as…

Q: Given the following data on inputs and outputs at a work center, determine the cumulative deviation…

A: Beginning Backlog = 7Planned and Actual Inputs & Outputs for 6 periods are given below:

Q: With the majority of health-care costs spent for the treatment of chronic diseases and the reason…

A: Information and digital technology have brought many new inventions to the world. Significant…

Q: Explain what a central processing unit and name tow type of CPU and how they differ from each other…

A: The Central Processing Unit (CPU) is the primary component of a computer that performs most of the…

Q: true or false 6. In recent years, companies have had more success with CRM systems that are less…

A: Customer relationship management or CRM is a process for maintaining all your business connections…

Q: Consider the bill of materials (BOM) shown to the right. a. How many immediate parents (one level…

A: In the question, I have been given the BOM, From the BOM, we can understand that the final product…

Q: Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to…

A: For BlueBox-Fixed cost =$500Variable cost =$0.08Selling Price =$1.00For GreenFilms-Fixed cost…

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: A home health care agency in Pennsylvania needs to locate a central office for managing the…

A: The center of gravity method is a technique used in facility or factor location analysis to…

Q: Investigate how the production planning of the beer business is carried out, based on the following…

A: Production planning is the process of creating a plan for the efficient use of resources in the…

Q: The operations manager of a body and paint shop has five cars to schedule for repair. He would like…

A: Makespan is the amount of time required for the completion of operations on all the work centres on…

Q: 25. The paid absence that is most commonly accrued is O a) voting leave b) vacation time. c)…

A: When we are working hard for the company we must be given enough time to rest during the work hours…

Q: Companies are either producing goods or delivering services. This means that only one of the two…

A: Operations management (OM) is the governance of business practices to make the highest degree of…

Q: A person who does well in the Planning stage of the problem-solving framework model of EF has an…

A: The question is related to Entity Framework Model (also known as the EF model). It contains such…

Q: Indicate whether the item below is used as key performance indicators for the areas of (A)…

A: Key performance indicators are related to the development of quantifiable measures employed to…

Q: two parts to the question Node a = new Node(5); Node b = new Node(3, a); Node c = new Node(7, b);…

Q: More in-depth data management and cleaning can be done by Tableau Desktop. Group of answer choices…

A: Tableau Desktop, principally employed for business intelligence, is a data visualization software…

Question

Problem #12: Please resolve this problem using solver in Excel (part c). Step by step screen shoots would be very helpful. Thank you.

No hand written solution

b. Determine the optimal assignment of
11. The distribution system for the Herman Company consists of three plants, two warehouses,
and four customers. Plant capacities and shipping costs per unit (in $) from each plant to
each warehouse are as follows:
Plant
1
Warehouse
1
2
Demand
2
3
1
4
8
5
Warehouse
1
6
3
300
2
5
6
Customer demand and shipping costs per unit (in $) from each warehouse to each customer
are as follows:
2
Customer
Capacity
450
600
380
4
6
300
387
300
a. Develop a network representation of this problem.
b. Formulate a linear programming model of the problem.
c. Solve the linear program to determine the optimal shipping plan.
446
7
400
12. Refer to Problem 11. Suppose that shipments between the two warehouses are permitted at
per unit and that direct shipments can be made from Plant 3 to Customer 4 at a cost of
$7 per unit.
$2
a. Develop a network representation of this problem.
b. Formulate a linear programming model of this problem.
C. Solve the linear program to determine the optimal shipping plan.

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: Introduce Transshipment model

VIEW

Step 2: a.Draw network diagram

VIEW

Step 3: b.Formulate the problem

VIEW

Step 4: c.Solve using solver

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

1– Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. 2. Gas & Go is considering offering movie rentals through a self-service company that would locate a machine on the inside of the market store. BlueBox would charge an annual lease fee of $500 for delivery, setup and maintenance, and there is an energy cost of $0.08 for every video rented. GreenFilms would charge an annual lease of only $400, but the energy cost for every video rental is $0.10 due to the larger size of the machine. Customers rent each movie for $1.00, regardless of the company, and the Gas & Go would earn 30% of that revenue for each rental. a. At what volume in number of rental transactions would the two options have the same cost?
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.
What exactly is meant by the abbreviation BIA (business impact analysis)? What are some functions that might be listed in the BIA for the network that you use at work or at home?
What sets Microsoft Office different from enterprise resource planning (ERP)? Is it feasible to implement it throughout all of the company's operations?
you also should use the binary constraints. can you fix it?
8 - Crowdfunding usually requires smaller amounts of investment contributions in comparison to Microlending. TrueFalse