B. For each of the following, you are to set up a linear program and solve theproblem using the Excel Solver.5. Freshly Baked Hub has 3 warehouses and 3 branches store. The following tableshows the shipping costs between each warehouses and store, the warehousecapabilities and store capacities.Branch StoreToCapabilitiesFromYAP 350P 400P 2807,000BP 197P 510P 3708,000P 470P 630P 28512,000Сарacity6,00014,0007,00027,000Linear Program:Solver Solution:х1 x2 х3 х4 х5 х6 х7 х8 х9Decision:Constraints:TotalSign Capability12345Minimize C:Warehouse

Answered: B. For each of the following, you are…

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 inventory manager 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 the Atlanta DC. Once you receive the products at the DC, they are stored in inventory until they are picked, packed, and shipped outbound to your company's downstream customers in response to orders. For each of your products, you currently use a single, dedicated supplier. Each of your suppliers ships their products to you from their facility using trucking services, and they provide you with choices of different LTL or truckload trucking carriers depending on your shipment 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 101 has a purchase cost p of $500 and you decide to value your inventory at the slightly…
Answer using the excel screenshot format to do the question. Secondly, please use the Net flow, sign and the RHS to work on Solver.
i need all parts solution
please justify your answer
Problem 11-3 Solve the newsvendor problem. What is the optimal order quantity? Probability Value Purchase cost c Selling price p Salvage value v 0.13 0.03 0.19 1 2 3 Optimal order quantity 45 70 25 0.16 0.10 4 5 0.39 6
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.
1 3 Supply: 4 1 60 40 28 10 120 2 50 30 30 20 150 3. 43 20 20 10 160 Demand: 100 100 100 130 The transportation table of a company that sends products is given below. According to the least cost method what is the value for the first cell to be assigned ?
Determine the optimal Q and TC given the following information: D = 30,000 boxes Ch = $2 Co $300 Discount schedule: Quantity (boxes) Price ($ per box) 43 1 to 9,999 10,000 to 14,999 41 15,000 to 19,999 38 20,000 or more 36 Show complete solution.
V3 Supply 1 10 U₁ 4 20 112 4 2 30 U3 Demand 15. 20 25 Find a basic feasible solution, by using - Northwest corner method. Check if the initial solution is optimal if not find it, by using method of A) B) multipliers 153 23212 V1
J 2 PLEASE SOLVE USING EXCEL SOLVER
3 Problems seen in the situation of the Company: 1. It does not earn too much but it makes sales enough for maintenance, salaries, income, and savings. 2. Company B makes use of a traditional inventory wherein they manually count their stocks and money. 3. They only have one supplier for liquors. For other supplies which are accessible, they usually buy from the wet market nearby. Proposed Solutions: Solution for no. 1- Digital marketing Solution for no. 2 – Perpetual Inventory System Solution for no. 3 – Supplier Quality Management System Hello, can someone help me? How am I going to create a decomposition diagram for these three solutions?
1. a. Define following: iv. Cycle Inventory v. Level of Product Availability vi. Reverse Logistics vii. Honey Combing

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