A manufacturing firm has three plants and wants to find the most efficient means of meeting the requirements ofits four customers. The relevant information for the plants and customers, along with shipping costs in dollars perunit, are shown in the table below:Factory(capacity)A (100)B (75)C (100)Customer 1(25)$15$20$22Customer (requirement)Customer 2 Customer 3(50)$10$12$20(125)$20$19$25Customer 4(75)$17$20$14Note: This question requires Solver.Formulate the problem in Solver and find the optimal solution. What is the optimal quantity to ship from Factory Ato Customer 2? Multiple Choice125 units50 units25 units75 units100 units

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

Answered: Note: This question requires Solver.…

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

The Gorilla Oil Company near Pittsburg transports gasoline to its distributors by truck. The company recently contracted to supply gasoline distributors in Kansa, and it has $1,000,000 available to spend on the necessary expansion of its fleet of gasoline tank trucks. Three models of gasoline tank trucks are available. II. Truck Model Capacity (gallons) Purchase Cost Monthly Operating Cost Super Tanker Regular Line Econo-Tanker 5,000 3,000 2,000 $50,000 $40,000 $25,000 $1,000 $ 800 $ 600 The company estimates that the monthly demand for the region will be 500,000 gallons of gasoline. Because of the size and speed differences of the trucks, the number of deliveries or round trips possible per month for each truck model will vary. Trip capacities are estimated at 10 trips per month for the Super Tanker, 20 trips per month for the Regular Line, and 30 trips per month for the Econo-Tanker. Based on maintenance and driver availability, the firm does not want to add more than 30 new vehicles…
Solve c using Two-Phase method Solve d using big m method
Problem 2 The University of South Wisconsin has had steady enrollments over the past five years. The school has its one bookstore, called University Book Store, but there are also three private bookstores in town: Bill’s Book Store, College Book Store, and Battle’s Book Store. The university is concerned about the large number of students who are switching to one of the private stores. As a result, South Wisconsin’s president, Andy Lange, has decided to give a student three hours of university credit to look into the problem. The following matrix of transition probabilities was obtained: University Bill’s College Battle’s University 0.5 0.2 0.2 0.1 Bill’s 0.1 0.6 0.2 0.1 College 0.1 0.1 0.7 0.1 Battle’s 0.05 0.1 0.1 0.75 At the present time, market shares for University, College, Battle’s and Bill’s book stores are 0.3, 0.3, 0.2, 0.2. What will the market share…
(Problem 1) A manager of Drexel Clothing Company has to make a decision on shipping. There are two shippers, A and B. Both offer a two-day rate: A for $500 and B for $525. In addition, A offers a three-day rate of $450 and a nine-day rate of $325 and B offers a four-day rate of $400 and a seven-day rate for $375. Annual holding costs are 25% of unit price. Four hundred boxes are to be shipped, and each box has a price of $250. The shipping charges are for the entire batch of 400 boxes. Which shipping alternative would you recommend? Explain.
please solve for question C
NEED ALL 1. Nodes with only outflows (total outflows <= capcity) 2. Nodes with only inflows (total inflows >= demand) 3. Nodes with both outflows and inflows (total outflows = total inflows) 4. Network structure and flows (List of arcs in the network by (Origin, Destination) 5. Objective to minimize
A company manufactures a product at its plants in C and D; then ships the product to its four distribution centers in K, L, M, and N. The transportation costs per unit (in dollars per unit) are as follows: from C to K, L, M, and N: 10, 5, 9, and 20. from D to K, L, M, and N: 2, 8, 30, and 10. The monthly demand from K, L., M, and N are: 3000, 1400, 4000, and 1200 units, respectively. On the other hand, the monthly capacity at plants C and D are: 4100 and 5800 units, respectively. Develop a linear programming model that can be used to determine the distribution plan that will minimize total monthly transportation cost. Use Excel Solver to find the optimal solution The optimal solution shows that the total monthly transportation cost is dollars.
allons of deionized water from each wholesaler to each distribution center is shown in the following table: Question Viewer a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? B. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center is needed. C. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. b. What is the total cost of the solution? The optimal cost is $ ((Enter your response rounded to the nearest dollar.)
Chapter 5: Food Goblin Supermarkets use both cashiers and baggers to serve customers at check out. During the peak hours, 8 cashiers and 6 baggers serve approximately 75 customers per hour. On average, a cashier spends 6 minutes at checkout and a bagger spends 4 minutes at bagging to serve a customer. Calculate the utilization of cashiers and their capacity cushion during a peak hour?
Please help to solve question d and e.
The Tubular Ride Boogie Board Company has manufacturing plants in Tucson, Arizona and Toronto, Ontario. You have been given the job of coordinating distribution of the latest model, the Gladiator, to outlets in Honolulu and Venice Beach. The Tucson plant, when operating at full capacity, can manufacture 620 Gladiator boards per week, while the Toronto plant, beset by labor disputes, can produce only 410 boards per week. The outlet in Honolulu orders 500 Gladiator boards per week, while Venice Beach orders 530 boards per week. Transportation costs are as follows. Tucson to Honolulu: $10 per board; Tucson to Venice Beach: $5 per board. Toronto to Honolulu: $20 per board; Toronto to Venice Beach: $10 per board. (a) Assuming that you wish to fill all orders and ensure full capacity production at both plants, is it possible to meet a total transportation budget of $9,900? O Yes O No If so, how many Gladiator boards are shipped from each manufacturing plant to each distribution outlet? (If…
The demand for subassembly Sis 130 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 1 unit of V. 1 unit of W. and 2 units of X. Finally, each unit of U requires 2 units of Y and 3 units of Z One firm manufactures all items It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U. 1 week to make V. 3 weeks to make W. 2 weeks to make X. 2 weeks to make Y, and 2 weeks to make Z W Click the icon to view the product structure and the time-phased product structure. In addition to 130 units of S, there is also a demand for 30 units of U, which is a component of S. The 30 units of U are needed for maintenance purposes These units are needed in week 6 Modify the gross material requirements plan to reflect this change (type 0f the input bax is nat used) Lead Time (weeks) Week Item Gross req Order release The product structure. The time-phased product structure. Level Q V W U/2) X Y 2 V(1) W1) X2) Y(2) Z3) 4 6. Time in weeks -co

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

Note: This question requires Solver. Formulate the problem in Solver and find the optimal solution. What is the optimal quantity to ship from Factory A to Customer 2?