A firm has 4 plants that produce widgets. Plants A, B, and C can each produce 110 widgets per day. Plant D can produce 55 widgets per day. Each day,the widgets produced in the plants must be shipped to satisfy the demand of 3 customers. Customer 1 requires 85 units per day, customer 2 requires110 units per day, and customer 3 requires 190 units per day. The shipping costs for each possible route are shown in the table below:Shipping Costs per unit at PlantABCDCustomer 1$40$25$20$15Customer 2$35$35$30$20Customer 3$20$15$40$25The firm needs to satisfy all demand each day but would like to minimize the total costs.The objective function for the firm's problem will have how many terms?571012

Answered: A firm has 4 plants that produce…

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

Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here: Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3 Hours required to complete all the oak cabinets 47 40 27 Hours required to complete all the cherry cabinets 64 51 36 Hours available 40 30 35 Cost per hour $34 $41 $52 For example, Cabinetmaker 1 estimates it will take 47 hours to complete all the oak cabinets and 64 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 40 hours available for the final…
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…
Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help. Answer the following question: Which of these is not an element of the objective function? Group of answer choices 4D-T1 600T1 9T2-G 3C-T2 Plz do fast asap
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best. D Demand Forecast Component A B C Time Standard Processing Setup (hr/unit) (hr/lot) 0.04 1.0 0.20 4.4 0.05 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected Optimistic Pessimistic 16,000 10,000 18,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next…
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best. i Demand Forecast Component A B C Time Standard Processing (hr/unit) 0.04 0.20 0.05 Setup (hr/lot) 1.0 4.4 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected 16,000 17,000 10,000 12,000 18,000 24,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next…
The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow). Write the mathematical formulation of the problem. Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the solution obtained in the space provided. What is the optimal cost of transportation?
The City of Boston is taking bids on four construction projects. Four companies have made the bids as shown in the following table: Company 1 2 3 4 Bids Project 1 Project 2 Project 3 Project 4 $4000 $5000 $4000 - $3000 $2000 $4000 $4000 $5000 a. Each bidder can be assigned only I route. Use the assignment method (Hungarian Method) to minimize the cost of assigning the four project contracts.
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.
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?
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…
2.) Your business provides technical support for very complex and specialized machinery used by companies throughout the country, and you currently have support centers at 5 locations. However, due to a poor market, you have been forced to close your centers in Houston and San Diego. You will have to relocate all of your technicians in these two centers to your other three centers in Cleveland, Seattle, and Charlotte. Due to the varying costs of living in each city, and travel and retraining times, the cost for relocating an employee varies depending on where the employee is moving. These costs are given in the following table: To: From: Cleveland Seattle Charlotte $5,000 | $7,000 $7,000 $4,000 $6,000 $8,000 Houston San Diego You currently have 40 employees in Houston and 55 employees in San Diego, which all need to be relocated. Cleveland is able to take in at most 35 relocated employees, Seattle can take in at most 32 employees, and Charlotte is able to take in at most 50 employees.…
Morgan Trucking Company operates a special pickup and delivery service between Chicago and six other cities located in a four-state area. When Morgan receives a request for service, it dispatches a truck from Chicago to the city requesting service as soon as possible. With both fast service and minimum travel costs as objectives for Morgan, it is important that the dispatched truck take the shortest route from Chicago to the specified city. Assume that the following network (not drawn to scale) with distances given in miles represents the highway network for this problem. Chicago 1 36 31 21 2 3 9 10 11 21 4 13 Find the shortest-route distance from Chicago to node 6. 6 5 6 16 6 21 7

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